Module: sip-router Branch: master Commit: f554ba1fa7e035a65aa2adc80d25a4560aaf9d3a URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=f554ba1f...
Author: Timo Reimann sr@foo-lounge.de Committer: Timo Reimann sr@foo-lounge.de Date: Fri Mar 2 23:34:05 2012 +0100
utils: Update dialog table version from 6 to 7.
---
utils/kamctl/db_sqlite/dialog-create.sql | 2 +- utils/kamctl/mysql/dialog-create.sql | 2 +- utils/kamctl/oracle/dialog-create.sql | 2 +- utils/kamctl/postgres/dialog-create.sql | 2 +- 4 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/utils/kamctl/db_sqlite/dialog-create.sql b/utils/kamctl/db_sqlite/dialog-create.sql index a75494e..10f6c7a 100644 --- a/utils/kamctl/db_sqlite/dialog-create.sql +++ b/utils/kamctl/db_sqlite/dialog-create.sql @@ -1,4 +1,4 @@ -INSERT INTO version (table_name, table_version) values ('dialog','6'); +INSERT INTO version (table_name, table_version) values ('dialog','7'); CREATE TABLE dialog ( id INTEGER PRIMARY KEY NOT NULL, hash_entry INTEGER NOT NULL, diff --git a/utils/kamctl/mysql/dialog-create.sql b/utils/kamctl/mysql/dialog-create.sql index c2efd36..d4ec70a 100644 --- a/utils/kamctl/mysql/dialog-create.sql +++ b/utils/kamctl/mysql/dialog-create.sql @@ -1,4 +1,4 @@ -INSERT INTO version (table_name, table_version) values ('dialog','6'); +INSERT INTO version (table_name, table_version) values ('dialog','7'); CREATE TABLE dialog ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, hash_entry INT(10) UNSIGNED NOT NULL, diff --git a/utils/kamctl/oracle/dialog-create.sql b/utils/kamctl/oracle/dialog-create.sql index 46795ac..0f6859f 100644 --- a/utils/kamctl/oracle/dialog-create.sql +++ b/utils/kamctl/oracle/dialog-create.sql @@ -1,4 +1,4 @@ -INSERT INTO version (table_name, table_version) values ('dialog','6'); +INSERT INTO version (table_name, table_version) values ('dialog','7'); CREATE TABLE dialog ( id NUMBER(10) PRIMARY KEY, hash_entry NUMBER(10), diff --git a/utils/kamctl/postgres/dialog-create.sql b/utils/kamctl/postgres/dialog-create.sql index ff91313..9955cfb 100644 --- a/utils/kamctl/postgres/dialog-create.sql +++ b/utils/kamctl/postgres/dialog-create.sql @@ -1,4 +1,4 @@ -INSERT INTO version (table_name, table_version) values ('dialog','6'); +INSERT INTO version (table_name, table_version) values ('dialog','7'); CREATE TABLE dialog ( id SERIAL PRIMARY KEY NOT NULL, hash_entry INTEGER NOT NULL,
Hi Timo,
the way to update the database creation scripts is to update the appropriate xml files in lib/srdb1/schema, then do 'make dbschema' in the root of source tree -- the sql scripts and the other db engines files (dbtext, berkeley, etc) in utils/kamctl/* will be regenerated.
In this particular case, you have to update 'lib/srdb1/schema/dialog.xml'
Cheers, Daniel
On 3/2/12 11:34 PM, Timo Reimann wrote:
Module: sip-router Branch: master Commit: f554ba1fa7e035a65aa2adc80d25a4560aaf9d3a URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=f554ba1f...
Author: Timo Reimannsr@foo-lounge.de Committer: Timo Reimannsr@foo-lounge.de Date: Fri Mar 2 23:34:05 2012 +0100
utils: Update dialog table version from 6 to 7.
utils/kamctl/db_sqlite/dialog-create.sql | 2 +- utils/kamctl/mysql/dialog-create.sql | 2 +- utils/kamctl/oracle/dialog-create.sql | 2 +- utils/kamctl/postgres/dialog-create.sql | 2 +- 4 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/utils/kamctl/db_sqlite/dialog-create.sql b/utils/kamctl/db_sqlite/dialog-create.sql index a75494e..10f6c7a 100644 --- a/utils/kamctl/db_sqlite/dialog-create.sql +++ b/utils/kamctl/db_sqlite/dialog-create.sql @@ -1,4 +1,4 @@ -INSERT INTO version (table_name, table_version) values ('dialog','6'); +INSERT INTO version (table_name, table_version) values ('dialog','7'); CREATE TABLE dialog ( id INTEGER PRIMARY KEY NOT NULL, hash_entry INTEGER NOT NULL, diff --git a/utils/kamctl/mysql/dialog-create.sql b/utils/kamctl/mysql/dialog-create.sql index c2efd36..d4ec70a 100644 --- a/utils/kamctl/mysql/dialog-create.sql +++ b/utils/kamctl/mysql/dialog-create.sql @@ -1,4 +1,4 @@ -INSERT INTO version (table_name, table_version) values ('dialog','6'); +INSERT INTO version (table_name, table_version) values ('dialog','7'); CREATE TABLE dialog ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, hash_entry INT(10) UNSIGNED NOT NULL, diff --git a/utils/kamctl/oracle/dialog-create.sql b/utils/kamctl/oracle/dialog-create.sql index 46795ac..0f6859f 100644 --- a/utils/kamctl/oracle/dialog-create.sql +++ b/utils/kamctl/oracle/dialog-create.sql @@ -1,4 +1,4 @@ -INSERT INTO version (table_name, table_version) values ('dialog','6'); +INSERT INTO version (table_name, table_version) values ('dialog','7'); CREATE TABLE dialog ( id NUMBER(10) PRIMARY KEY, hash_entry NUMBER(10), diff --git a/utils/kamctl/postgres/dialog-create.sql b/utils/kamctl/postgres/dialog-create.sql index ff91313..9955cfb 100644 --- a/utils/kamctl/postgres/dialog-create.sql +++ b/utils/kamctl/postgres/dialog-create.sql @@ -1,4 +1,4 @@ -INSERT INTO version (table_name, table_version) values ('dialog','6'); +INSERT INTO version (table_name, table_version) values ('dialog','7'); CREATE TABLE dialog ( id SERIAL PRIMARY KEY NOT NULL, hash_entry INTEGER NOT NULL,
sr-dev mailing list sr-dev@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
Hey Daniel,
Am 02.03.2012 um 23:48 schrieb Daniel-Constantin Mierla:
the way to update the database creation scripts is to update the appropriate xml files in lib/srdb1/schema, then do 'make dbschema' in the root of source tree -- the sql scripts and the other db engines files (dbtext, berkeley, etc) in utils/kamctl/* will be regenerated.
In this particular case, you have to update 'lib/srdb1/schema/dialog.xml'
Thanks for the note -- I did miss to update a few scripts with the manual approach.
The schema file is now updated and all generated scripts committed.
Cheers,
--Timo
On 3/2/12 11:34 PM, Timo Reimann wrote:
Module: sip-router Branch: master Commit: f554ba1fa7e035a65aa2adc80d25a4560aaf9d3a URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=f554ba1f...
Author: Timo Reimannsr@foo-lounge.de Committer: Timo Reimannsr@foo-lounge.de Date: Fri Mar 2 23:34:05 2012 +0100
utils: Update dialog table version from 6 to 7.
utils/kamctl/db_sqlite/dialog-create.sql | 2 +- utils/kamctl/mysql/dialog-create.sql | 2 +- utils/kamctl/oracle/dialog-create.sql | 2 +- utils/kamctl/postgres/dialog-create.sql | 2 +- 4 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/utils/kamctl/db_sqlite/dialog-create.sql b/utils/kamctl/db_sqlite/dialog-create.sql index a75494e..10f6c7a 100644 --- a/utils/kamctl/db_sqlite/dialog-create.sql +++ b/utils/kamctl/db_sqlite/dialog-create.sql @@ -1,4 +1,4 @@ -INSERT INTO version (table_name, table_version) values ('dialog','6'); +INSERT INTO version (table_name, table_version) values ('dialog','7'); CREATE TABLE dialog ( id INTEGER PRIMARY KEY NOT NULL, hash_entry INTEGER NOT NULL, diff --git a/utils/kamctl/mysql/dialog-create.sql b/utils/kamctl/mysql/dialog-create.sql index c2efd36..d4ec70a 100644 --- a/utils/kamctl/mysql/dialog-create.sql +++ b/utils/kamctl/mysql/dialog-create.sql @@ -1,4 +1,4 @@ -INSERT INTO version (table_name, table_version) values ('dialog','6'); +INSERT INTO version (table_name, table_version) values ('dialog','7'); CREATE TABLE dialog ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, hash_entry INT(10) UNSIGNED NOT NULL, diff --git a/utils/kamctl/oracle/dialog-create.sql b/utils/kamctl/oracle/dialog-create.sql index 46795ac..0f6859f 100644 --- a/utils/kamctl/oracle/dialog-create.sql +++ b/utils/kamctl/oracle/dialog-create.sql @@ -1,4 +1,4 @@ -INSERT INTO version (table_name, table_version) values ('dialog','6'); +INSERT INTO version (table_name, table_version) values ('dialog','7'); CREATE TABLE dialog ( id NUMBER(10) PRIMARY KEY, hash_entry NUMBER(10), diff --git a/utils/kamctl/postgres/dialog-create.sql b/utils/kamctl/postgres/dialog-create.sql index ff91313..9955cfb 100644 --- a/utils/kamctl/postgres/dialog-create.sql +++ b/utils/kamctl/postgres/dialog-create.sql @@ -1,4 +1,4 @@ -INSERT INTO version (table_name, table_version) values ('dialog','6'); +INSERT INTO version (table_name, table_version) values ('dialog','7'); CREATE TABLE dialog ( id SERIAL PRIMARY KEY NOT NULL, hash_entry INTEGER NOT NULL,
sr-dev mailing list sr-dev@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
-
Daniel-Constantin Mierla -
Timo Reimann