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,35 +0,0 @@
1
-INSERT INTO version (table_name, table_version) values ('dialog','3');
2
-CREATE TABLE dialog (
3
-    id NUMBER(10) PRIMARY KEY,
4
-    hash_entry NUMBER(10),
5
-    hash_id NUMBER(10),
6
-    callid VARCHAR2(255),
7
-    from_uri VARCHAR2(128),
8
-    from_tag VARCHAR2(64),
9
-    to_uri VARCHAR2(128),
10
-    to_tag VARCHAR2(64),
11
-    caller_cseq VARCHAR2(7),
12
-    callee_cseq VARCHAR2(7),
13
-    caller_route_set VARCHAR2(512),
14
-    callee_route_set VARCHAR2(512),
15
-    caller_contact VARCHAR2(128),
16
-    callee_contact VARCHAR2(128),
17
-    caller_sock VARCHAR2(64),
18
-    callee_sock VARCHAR2(64),
19
-    state NUMBER(10),
20
-    start_time NUMBER(10),
21
-    timeout NUMBER(10) DEFAULT 0 NOT NULL,
22
-    sflags NUMBER(10) DEFAULT 0 NOT NULL,
23
-    toroute NUMBER(10) DEFAULT 0 NOT NULL
24
-);
25
-
26
-CREATE OR REPLACE TRIGGER dialog_tr
27
-before insert on dialog FOR EACH ROW
28
-BEGIN
29
-  auto_id(:NEW.id);
30
-END dialog_tr;
31
-/
32
-BEGIN map2users('dialog'); END;
33
-/
34
-CREATE INDEX dialog_hash_idx  ON dialog (hash_entry, hash_id);
35
-
Browse code

- set 0 default values for the new columns

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

Daniel-Constantin Mierla authored on 09/04/2009 15:48:34
Showing 1 changed files
... ...
@@ -18,9 +18,9 @@ CREATE TABLE dialog (
18 18
     callee_sock VARCHAR2(64),
19 19
     state NUMBER(10),
20 20
     start_time NUMBER(10),
21
-    timeout NUMBER(10),
22
-    sflags NUMBER(10),
23
-    toroute NUMBER(10)
21
+    timeout NUMBER(10) DEFAULT 0 NOT NULL,
22
+    sflags NUMBER(10) DEFAULT 0 NOT NULL,
23
+    toroute NUMBER(10) DEFAULT 0 NOT NULL
24 24
 );
25 25
 
26 26
 CREATE OR REPLACE TRIGGER dialog_tr
Browse code

- regenerated db table creation for dialog and purplemap

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

Daniel-Constantin Mierla authored on 27/02/2009 19:49:01
Showing 1 changed files
... ...
@@ -1,4 +1,4 @@
1
-INSERT INTO version (table_name, table_version) values ('dialog','2');
1
+INSERT INTO version (table_name, table_version) values ('dialog','3');
2 2
 CREATE TABLE dialog (
3 3
     id NUMBER(10) PRIMARY KEY,
4 4
     hash_entry NUMBER(10),
... ...
@@ -18,7 +18,9 @@ CREATE TABLE dialog (
18 18
     callee_sock VARCHAR2(64),
19 19
     state NUMBER(10),
20 20
     start_time NUMBER(10),
21
-    timeout NUMBER(10)
21
+    timeout NUMBER(10),
22
+    sflags NUMBER(10),
23
+    toroute NUMBER(10)
22 24
 );
23 25
 
24 26
 CREATE OR REPLACE TRIGGER dialog_tr
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,33 +1,33 @@
1
-INSERT INTO VERSION (table_name,table_version) values ('dialog',2);
2
-create table DIALOG
3
-(
4
-  ID               NUMBER(10) not null,
5
-  HASH_ENTRY       NUMBER(10) not null,
6
-  HASH_ID          NUMBER(10) not null,
7
-  CALLID           VARCHAR2(255) not null,
8
-  FROM_URI         VARCHAR2(128) not null,
9
-  FROM_TAG         VARCHAR2(64) not null,
10
-  TO_URI           VARCHAR2(128) not null,
11
-  TO_TAG           VARCHAR2(64) not null,
12
-  CALLER_CSEQ      VARCHAR2(7) not null,
13
-  CALLEE_CSEQ      VARCHAR2(7) not null,
14
-  CALLER_ROUTE_SET VARCHAR2(512),
15
-  CALLEE_ROUTE_SET VARCHAR2(512),
16
-  CALLER_CONTACT   VARCHAR2(128) not null,
17
-  CALLEE_CONTACT   VARCHAR2(128) not null,
18
-  CALLER_SOCK      VARCHAR2(64) not null,
19
-  CALLEE_SOCK      VARCHAR2(64) not null,
20
-  STATE            NUMBER(10) not null,
21
-  START_TIME       NUMBER(10) not null,
22
-  TIMEOUT          NUMBER(10) not null
1
+INSERT INTO version (table_name, table_version) values ('dialog','2');
2
+CREATE TABLE dialog (
3
+    id NUMBER(10) PRIMARY KEY,
4
+    hash_entry NUMBER(10),
5
+    hash_id NUMBER(10),
6
+    callid VARCHAR2(255),
7
+    from_uri VARCHAR2(128),
8
+    from_tag VARCHAR2(64),
9
+    to_uri VARCHAR2(128),
10
+    to_tag VARCHAR2(64),
11
+    caller_cseq VARCHAR2(7),
12
+    callee_cseq VARCHAR2(7),
13
+    caller_route_set VARCHAR2(512),
14
+    callee_route_set VARCHAR2(512),
15
+    caller_contact VARCHAR2(128),
16
+    callee_contact VARCHAR2(128),
17
+    caller_sock VARCHAR2(64),
18
+    callee_sock VARCHAR2(64),
19
+    state NUMBER(10),
20
+    start_time NUMBER(10),
21
+    timeout NUMBER(10)
23 22
 );
24
-alter table DIALOG add constraint PK_DIALOG primary key (ID);
25
-create index DIALOG_HASH_IDX on DIALOG (HASH_ENTRY,HASH_ID);
26
-create or replace trigger dialog_tr
23
+
24
+CREATE OR REPLACE TRIGGER dialog_tr
27 25
 before insert on dialog FOR EACH ROW
28 26
 BEGIN
29 27
   auto_id(:NEW.id);
30 28
 END dialog_tr;
31 29
 /
32
-BEGIN map2users('DIALOG'); END;
30
+BEGIN map2users('dialog'); END;
33 31
 /
32
+CREATE INDEX dialog_hash_idx  ON dialog (hash_entry, hash_id);
33
+
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,33 @@
1
+INSERT INTO VERSION (table_name,table_version) values ('dialog',2);
2
+create table DIALOG
3
+(
4
+  ID               NUMBER(10) not null,
5
+  HASH_ENTRY       NUMBER(10) not null,
6
+  HASH_ID          NUMBER(10) not null,
7
+  CALLID           VARCHAR2(255) not null,
8
+  FROM_URI         VARCHAR2(128) not null,
9
+  FROM_TAG         VARCHAR2(64) not null,
10
+  TO_URI           VARCHAR2(128) not null,
11
+  TO_TAG           VARCHAR2(64) not null,
12
+  CALLER_CSEQ      VARCHAR2(7) not null,
13
+  CALLEE_CSEQ      VARCHAR2(7) not null,
14
+  CALLER_ROUTE_SET VARCHAR2(512),
15
+  CALLEE_ROUTE_SET VARCHAR2(512),
16
+  CALLER_CONTACT   VARCHAR2(128) not null,
17
+  CALLEE_CONTACT   VARCHAR2(128) not null,
18
+  CALLER_SOCK      VARCHAR2(64) not null,
19
+  CALLEE_SOCK      VARCHAR2(64) not null,
20
+  STATE            NUMBER(10) not null,
21
+  START_TIME       NUMBER(10) not null,
22
+  TIMEOUT          NUMBER(10) not null
23
+);
24
+alter table DIALOG add constraint PK_DIALOG primary key (ID);
25
+create index DIALOG_HASH_IDX on DIALOG (HASH_ENTRY,HASH_ID);
26
+create or replace trigger dialog_tr
27
+before insert on dialog FOR EACH ROW
28
+BEGIN
29
+  auto_id(:NEW.id);
30
+END dialog_tr;
31
+/
32
+BEGIN map2users('DIALOG'); END;
33
+/