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
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
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
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 |
+ |