Browse code

kamctl: db sql files updated after xsl changes

- insert statement for version is after creation of the table

Daniel-Constantin Mierla authored on 04/12/2015 20:59:11
Showing 1 changed files
... ...
@@ -1,4 +1,3 @@
1
-INSERT INTO version (table_name, table_version) values ('rtpproxy','1');
2 1
 CREATE TABLE `rtpproxy` (
3 2
     `id` INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
4 3
     `setid` VARCHAR(32) DEFAULT 00 NOT NULL,
... ...
@@ -8,3 +7,5 @@ CREATE TABLE `rtpproxy` (
8 7
     `description` VARCHAR(64) DEFAULT '' NOT NULL
9 8
 );
10 9
 
10
+INSERT INTO version (table_name, table_version) values ('rtpproxy','1');
11
+
Browse code

kamctl: regenerated mysql creation scripts

Daniel-Constantin Mierla authored on 13/05/2015 20:24:28
Showing 1 changed files
... ...
@@ -1,10 +1,10 @@
1 1
 INSERT INTO version (table_name, table_version) values ('rtpproxy','1');
2
-CREATE TABLE rtpproxy (
3
-    id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
4
-    setid VARCHAR(32) DEFAULT 00 NOT NULL,
5
-    url VARCHAR(64) DEFAULT '' NOT NULL,
6
-    flags INT DEFAULT 0 NOT NULL,
7
-    weight INT DEFAULT 1 NOT NULL,
8
-    description VARCHAR(64) DEFAULT '' NOT NULL
2
+CREATE TABLE `rtpproxy` (
3
+    `id` INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
4
+    `setid` VARCHAR(32) DEFAULT 00 NOT NULL,
5
+    `url` VARCHAR(64) DEFAULT '' NOT NULL,
6
+    `flags` INT DEFAULT 0 NOT NULL,
7
+    `weight` INT DEFAULT 1 NOT NULL,
8
+    `description` VARCHAR(64) DEFAULT '' NOT NULL
9 9
 );
10 10
 
Browse code

DB scheme: remove default MySQL engine definition

* remove default MySQL engine definition from table definitions
* if nothing is specified then MySQL server will choose the default from its cfg
* if you like to specify it, change the MYSQL_TABLE_TYPE define in
lib/srdb1/schema/entities.xml and run "make dbschema" in the top level directory
* the stylesheet doesn't check the engine type, Kamailio supports MyISAM and InnoDB

Henning Westerholt authored on 29/05/2013 10:38:10
Showing 1 changed files
... ...
@@ -6,5 +6,5 @@ CREATE TABLE rtpproxy (
6 6
     flags INT DEFAULT 0 NOT NULL,
7 7
     weight INT DEFAULT 1 NOT NULL,
8 8
     description VARCHAR(64) DEFAULT '' NOT NULL
9
-) ENGINE=MyISAM;
9
+);
10 10
 
Browse code

Revert "DB scheme: as discussed on sr-users list, change default mysql engine to InnoDB"

This reverts commit fa49fe070adadfff893b338f2a2d69776c043653.

Henning Westerholt authored on 29/05/2013 10:30:58
Showing 1 changed files
... ...
@@ -6,5 +6,5 @@ CREATE TABLE rtpproxy (
6 6
     flags INT DEFAULT 0 NOT NULL,
7 7
     weight INT DEFAULT 1 NOT NULL,
8 8
     description VARCHAR(64) DEFAULT '' NOT NULL
9
-) ENGINE=InnoDB;
9
+) ENGINE=MyISAM;
10 10
 
Browse code

DB scheme: as discussed on sr-users list, change default mysql engine to InnoDB

Henning Westerholt authored on 29/05/2013 09:49:59
Showing 1 changed files
... ...
@@ -6,5 +6,5 @@ CREATE TABLE rtpproxy (
6 6
     flags INT DEFAULT 0 NOT NULL,
7 7
     weight INT DEFAULT 1 NOT NULL,
8 8
     description VARCHAR(64) DEFAULT '' NOT NULL
9
-) ENGINE=MyISAM;
9
+) ENGINE=InnoDB;
10 10
 
Browse code

lib/srdb1, kamctl: Add new rtpproxy db table to schema

Hugh Waite authored on 29/03/2013 14:54:52
Showing 1 changed files
1 1
new file mode 100644
... ...
@@ -0,0 +1,10 @@
1
+INSERT INTO version (table_name, table_version) values ('rtpproxy','1');
2
+CREATE TABLE rtpproxy (
3
+    id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
4
+    setid VARCHAR(32) DEFAULT 00 NOT NULL,
5
+    url VARCHAR(64) DEFAULT '' NOT NULL,
6
+    flags INT DEFAULT 0 NOT NULL,
7
+    weight INT DEFAULT 1 NOT NULL,
8
+    description VARCHAR(64) DEFAULT '' NOT NULL
9
+) ENGINE=MyISAM;
10
+