[sr-dev] git:master: utils: Update dialog table version from 6 to 7.

Timo Reimann sr at foo-lounge.de
Sat Mar 3 00:01:50 CET 2012


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=f554ba1fa7e035a65aa2adc80d25a4560aaf9d3a
>> 
>> Author: Timo Reimann<sr at foo-lounge.de>
>> Committer: Timo Reimann<sr at 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 at lists.sip-router.org
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev




More information about the sr-dev mailing list