Browse code

kamctl: moved files in own directory

- tools/* => tools/kamctl1/*
- avoid the mixture of kamctl and pike_top tools

Daniel-Constantin Mierla authored on 22/09/2009 09:27:49
Showing 1 changed files
1 1
deleted file mode 100644
... ...
@@ -1,28 +0,0 @@
1
-INSERT INTO version (table_name, table_version) values ('sip_trace','2');
2
-CREATE TABLE sip_trace (
3
-    id NUMBER(10) PRIMARY KEY,
4
-    time_stamp DATE DEFAULT to_date('1900-01-01 00:00:01','yyyy-mm-dd hh24:mi:ss'),
5
-    callid VARCHAR2(255) DEFAULT '',
6
-    traced_user VARCHAR2(128) DEFAULT '',
7
-    msg CLOB,
8
-    method VARCHAR2(50) DEFAULT '',
9
-    status VARCHAR2(128) DEFAULT '',
10
-    fromip VARCHAR2(50) DEFAULT '',
11
-    toip VARCHAR2(50) DEFAULT '',
12
-    fromtag VARCHAR2(64) DEFAULT '',
13
-    direction VARCHAR2(4) DEFAULT ''
14
-);
15
-
16
-CREATE OR REPLACE TRIGGER sip_trace_tr
17
-before insert on sip_trace FOR EACH ROW
18
-BEGIN
19
-  auto_id(:NEW.id);
20
-END sip_trace_tr;
21
-/
22
-BEGIN map2users('sip_trace'); END;
23
-/
24
-CREATE INDEX sip_trace_traced_user_idx  ON sip_trace (traced_user);
25
-CREATE INDEX sip_trace_date_idx  ON sip_trace (time_stamp);
26
-CREATE INDEX sip_trace_fromip_idx  ON sip_trace (fromip);
27
-CREATE INDEX sip_trace_callid_idx  ON sip_trace (callid);
28
-
Browse code

- replace manual generated SQL schemes for oracle with the ones created from the XSL infrastructure

git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4078 689a6050-402a-0410-94f2-e92a70836424

Henning Westerholt authored on 24/04/2008 10:19:40
Showing 1 changed files
... ...
@@ -1,28 +1,28 @@
1
-INSERT INTO VERSION (table_name,table_version) VALUES ('sip_trace',2);
2
-create table SIP_TRACE
3
-(
4
-  ID          NUMBER(10) not null,
5
-  TIME_STAMP  DATE default to_date('01-JAN-1900 00:00:01','dd-mm-yyyy hh24:mi:ss'),
6
-  CALLID      VARCHAR2(255) default '',
7
-  TRACED_USER VARCHAR2(128) default '',
8
-  MSG         VARCHAR2(1000) not null,
9
-  METHOD      VARCHAR2(50) default '',
10
-  STATUS      VARCHAR2(128) default '',
11
-  FROMIP      VARCHAR2(50) default '',
12
-  TOIP        VARCHAR2(50) default '',
13
-  FROMTAG     VARCHAR2(64) default '',
14
-  DIRECTION   VARCHAR2(4) default ''
1
+INSERT INTO version (table_name, table_version) values ('sip_trace','2');
2
+CREATE TABLE sip_trace (
3
+    id NUMBER(10) PRIMARY KEY,
4
+    time_stamp DATE DEFAULT to_date('1900-01-01 00:00:01','yyyy-mm-dd hh24:mi:ss'),
5
+    callid VARCHAR2(255) DEFAULT '',
6
+    traced_user VARCHAR2(128) DEFAULT '',
7
+    msg CLOB,
8
+    method VARCHAR2(50) DEFAULT '',
9
+    status VARCHAR2(128) DEFAULT '',
10
+    fromip VARCHAR2(50) DEFAULT '',
11
+    toip VARCHAR2(50) DEFAULT '',
12
+    fromtag VARCHAR2(64) DEFAULT '',
13
+    direction VARCHAR2(4) DEFAULT ''
15 14
 );
16
-alter table SIP_TRACE add constraint PK_SIP_TRACE primary key (ID);
17
-create index SIP_TRACE_CALLID_IDX on SIP_TRACE (CALLID);
18
-create index SIP_TRACE_DATE_IDX on SIP_TRACE (TIME_STAMP);
19
-create index SIP_TRACE_FROMIP_IDX on SIP_TRACE (FROMIP);
20
-create index SIP_TRACE_TRACED_USER_IDX on SIP_TRACE (TRACED_USER);
21
-create or replace trigger sip_trace_tr
15
+
16
+CREATE OR REPLACE TRIGGER sip_trace_tr
22 17
 before insert on sip_trace FOR EACH ROW
23 18
 BEGIN
24 19
   auto_id(:NEW.id);
25 20
 END sip_trace_tr;
26 21
 /
27
-BEGIN map2users('SIP_TRACE'); END;
22
+BEGIN map2users('sip_trace'); END;
28 23
 /
24
+CREATE INDEX sip_trace_traced_user_idx  ON sip_trace (traced_user);
25
+CREATE INDEX sip_trace_date_idx  ON sip_trace (time_stamp);
26
+CREATE INDEX sip_trace_fromip_idx  ON sip_trace (fromip);
27
+CREATE INDEX sip_trace_callid_idx  ON sip_trace (callid);
28
+
Browse code

Add db_oracle module and toolses for it

git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3997 689a6050-402a-0410-94f2-e92a70836424

Iouri Kharon authored on 09/04/2008 15:46:09
Showing 1 changed files
1 1
new file mode 100644
... ...
@@ -0,0 +1,28 @@
1
+INSERT INTO VERSION (table_name,table_version) VALUES ('sip_trace',2);
2
+create table SIP_TRACE
3
+(
4
+  ID          NUMBER(10) not null,
5
+  TIME_STAMP  DATE default to_date('01-JAN-1900 00:00:01','dd-mm-yyyy hh24:mi:ss'),
6
+  CALLID      VARCHAR2(255) default '',
7
+  TRACED_USER VARCHAR2(128) default '',
8
+  MSG         VARCHAR2(1000) not null,
9
+  METHOD      VARCHAR2(50) default '',
10
+  STATUS      VARCHAR2(128) default '',
11
+  FROMIP      VARCHAR2(50) default '',
12
+  TOIP        VARCHAR2(50) default '',
13
+  FROMTAG     VARCHAR2(64) default '',
14
+  DIRECTION   VARCHAR2(4) default ''
15
+);
16
+alter table SIP_TRACE add constraint PK_SIP_TRACE primary key (ID);
17
+create index SIP_TRACE_CALLID_IDX on SIP_TRACE (CALLID);
18
+create index SIP_TRACE_DATE_IDX on SIP_TRACE (TIME_STAMP);
19
+create index SIP_TRACE_FROMIP_IDX on SIP_TRACE (FROMIP);
20
+create index SIP_TRACE_TRACED_USER_IDX on SIP_TRACE (TRACED_USER);
21
+create or replace trigger sip_trace_tr
22
+before insert on sip_trace FOR EACH ROW
23
+BEGIN
24
+  auto_id(:NEW.id);
25
+END sip_trace_tr;
26
+/
27
+BEGIN map2users('SIP_TRACE'); END;
28
+/