[sr-dev] git:master: srdb1/dbschema: regenerated db creation scripts

[Andreas Granig]

Hi,

How does the generation of db creation scripts actually work? In the
past, I manually adapted all the files, which seemed pretty pointless
due to the existence of the xml definitions.

So is there a make target or a script for that? Will this support all
existing db backends?

And what's the difference between lib/srdb1/schema and lib/srdb2/schema?

Thanks for clarification,
Andreas

On 05/22/2012 12:43 PM, Daniel-Constantin Mierla wrote:
> Module: sip-router
> Branch: master
> Commit: 861603806e72876e0348c25031bcd64892023a20
> URL:    http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=861603806e72876e0348c25031bcd64892023a20
> 
> Author: Daniel-Constantin Mierla <miconda at gmail.com>
> Committer: Daniel-Constantin Mierla <miconda at gmail.com>
> Date:   Tue May 22 12:41:05 2012 +0200
> 
> srdb1/dbschema: regenerated db creation scripts
> 
> - lcr_rule version update was not taken in consideration
> - reported by Timo Teräs
> 
> ---
> 
>  utils/kamctl/db_berkeley/kamailio/version |    2 +-
>  utils/kamctl/db_sqlite/lcr-create.sql     |    2 +-
>  utils/kamctl/dbtext/kamailio/version      |    2 +-
>  utils/kamctl/mysql/lcr-create.sql         |    2 +-
>  utils/kamctl/oracle/lcr-create.sql        |    2 +-
>  utils/kamctl/postgres/lcr-create.sql      |    2 +-
>  6 files changed, 6 insertions(+), 6 deletions(-)
> 
> diff --git a/utils/kamctl/db_berkeley/kamailio/version b/utils/kamctl/db_berkeley/kamailio/version
> index 235d82b..c51ace4 100644
> --- a/utils/kamctl/db_berkeley/kamailio/version
> +++ b/utils/kamctl/db_berkeley/kamailio/version
> @@ -63,7 +63,7 @@ imc_rooms|1
>  lcr_gw|
>  lcr_gw|2
>  lcr_rule|
> -lcr_rule|1
> +lcr_rule|2
>  lcr_rule_target|
>  lcr_rule_target|1
>  location|
> diff --git a/utils/kamctl/db_sqlite/lcr-create.sql b/utils/kamctl/db_sqlite/lcr-create.sql
> index 8493e26..63eb37d 100644
> --- a/utils/kamctl/db_sqlite/lcr-create.sql
> +++ b/utils/kamctl/db_sqlite/lcr-create.sql
> @@ -31,7 +31,7 @@ CREATE TABLE lcr_rule_target (
>  
>  CREATE INDEX lcr_rule_target_lcr_id_idx ON lcr_rule_target (lcr_id);
>  
> -INSERT INTO version (table_name, table_version) values ('lcr_rule','1');
> +INSERT INTO version (table_name, table_version) values ('lcr_rule','2');
>  CREATE TABLE lcr_rule (
>      id INTEGER PRIMARY KEY NOT NULL,
>      lcr_id SMALLINT NOT NULL,
> diff --git a/utils/kamctl/dbtext/kamailio/version b/utils/kamctl/dbtext/kamailio/version
> index 31bf74b..0396a99 100644
> --- a/utils/kamctl/dbtext/kamailio/version
> +++ b/utils/kamctl/dbtext/kamailio/version
> @@ -26,7 +26,7 @@ htable:2
>  imc_members:1
>  imc_rooms:1
>  lcr_gw:2
> -lcr_rule:1
> +lcr_rule:2
>  lcr_rule_target:1
>  location:5
>  matrix:1
> diff --git a/utils/kamctl/mysql/lcr-create.sql b/utils/kamctl/mysql/lcr-create.sql
> index f7dbf26..efa65b2 100644
> --- a/utils/kamctl/mysql/lcr-create.sql
> +++ b/utils/kamctl/mysql/lcr-create.sql
> @@ -31,7 +31,7 @@ CREATE TABLE lcr_rule_target (
>  
>  CREATE INDEX lcr_id_idx ON lcr_rule_target (lcr_id);
>  
> -INSERT INTO version (table_name, table_version) values ('lcr_rule','1');
> +INSERT INTO version (table_name, table_version) values ('lcr_rule','2');
>  CREATE TABLE lcr_rule (
>      id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
>      lcr_id SMALLINT UNSIGNED NOT NULL,
> diff --git a/utils/kamctl/oracle/lcr-create.sql b/utils/kamctl/oracle/lcr-create.sql
> index 530a798..5fe88a0 100644
> --- a/utils/kamctl/oracle/lcr-create.sql
> +++ b/utils/kamctl/oracle/lcr-create.sql
> @@ -47,7 +47,7 @@ BEGIN map2users('lcr_rule_target'); END;
>  /
>  CREATE INDEX lcr_rule_target_lcr_id_idx  ON lcr_rule_target (lcr_id);
>  
> -INSERT INTO version (table_name, table_version) values ('lcr_rule','1');
> +INSERT INTO version (table_name, table_version) values ('lcr_rule','2');
>  CREATE TABLE lcr_rule (
>      id NUMBER(10) PRIMARY KEY,
>      lcr_id NUMBER(5),
> diff --git a/utils/kamctl/postgres/lcr-create.sql b/utils/kamctl/postgres/lcr-create.sql
> index 52f51c5..958213a 100644
> --- a/utils/kamctl/postgres/lcr-create.sql
> +++ b/utils/kamctl/postgres/lcr-create.sql
> @@ -31,7 +31,7 @@ CREATE TABLE lcr_rule_target (
>  
>  CREATE INDEX lcr_rule_target_lcr_id_idx ON lcr_rule_target (lcr_id);
>  
> -INSERT INTO version (table_name, table_version) values ('lcr_rule','1');
> +INSERT INTO version (table_name, table_version) values ('lcr_rule','2');
>  CREATE TABLE lcr_rule (
>      id SERIAL PRIMARY KEY NOT NULL,
>      lcr_id SMALLINT NOT NULL,
> 
> 
> _______________________________________________
> sr-dev mailing list
> sr-dev at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 900 bytes
Desc: OpenPGP digital signature
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20120522/29d7ebfc/attachment.pgp>