[sr-dev] git:master: kamctl: regenerated db creation scripts

[Daniel-Constantin Mierla]

Module: sip-router
Branch: master
Commit: e09b5bc8f7d17d8d9d9754152d78b0c835e94a9f
URL:    http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=e09b5bc8f7d17d8d9d9754152d78b0c835e94a9f

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
Date:   Sun Sep  2 13:36:55 2012 +0200

kamctl: regenerated db creation scripts

---

 utils/kamctl/db_sqlite/standard-create.sql |    3 ++-
 utils/kamctl/mysql/standard-create.sql     |    3 ++-
 utils/kamctl/oracle/standard-create.sql    |    3 ++-
 utils/kamctl/postgres/standard-create.sql  |    3 ++-
 4 files changed, 8 insertions(+), 4 deletions(-)

diff --git a/utils/kamctl/db_sqlite/standard-create.sql b/utils/kamctl/db_sqlite/standard-create.sql
index 0add99d..ae5ce2a 100644
--- a/utils/kamctl/db_sqlite/standard-create.sql
+++ b/utils/kamctl/db_sqlite/standard-create.sql
@@ -1,5 +1,6 @@
 CREATE TABLE version (
     table_name VARCHAR(32) NOT NULL,
-    table_version INTEGER DEFAULT 0 NOT NULL
+    table_version INTEGER DEFAULT 0 NOT NULL,
+    CONSTRAINT version_table_name_idx UNIQUE (table_name)
 );
 
diff --git a/utils/kamctl/mysql/standard-create.sql b/utils/kamctl/mysql/standard-create.sql
index 42dbaf6..d76d450 100644
--- a/utils/kamctl/mysql/standard-create.sql
+++ b/utils/kamctl/mysql/standard-create.sql
@@ -1,5 +1,6 @@
 CREATE TABLE version (
     table_name VARCHAR(32) NOT NULL,
-    table_version INT UNSIGNED DEFAULT 0 NOT NULL
+    table_version INT UNSIGNED DEFAULT 0 NOT NULL,
+    CONSTRAINT table_name_idx UNIQUE (table_name)
 ) ENGINE=MyISAM;
 
diff --git a/utils/kamctl/oracle/standard-create.sql b/utils/kamctl/oracle/standard-create.sql
index 23f5525..6f29e49 100644
--- a/utils/kamctl/oracle/standard-create.sql
+++ b/utils/kamctl/oracle/standard-create.sql
@@ -1,6 +1,7 @@
 CREATE TABLE version (
     table_name VARCHAR2(32),
-    table_version NUMBER(10) DEFAULT 0 NOT NULL
+    table_version NUMBER(10) DEFAULT 0 NOT NULL,
+    CONSTRAINT version_table_name_idx  UNIQUE (table_name)
 );
 
 BEGIN map2users('version'); END;
diff --git a/utils/kamctl/postgres/standard-create.sql b/utils/kamctl/postgres/standard-create.sql
index 0add99d..ae5ce2a 100644
--- a/utils/kamctl/postgres/standard-create.sql
+++ b/utils/kamctl/postgres/standard-create.sql
@@ -1,5 +1,6 @@
 CREATE TABLE version (
     table_name VARCHAR(32) NOT NULL,
-    table_version INTEGER DEFAULT 0 NOT NULL
+    table_version INTEGER DEFAULT 0 NOT NULL,
+    CONSTRAINT version_table_name_idx UNIQUE (table_name)
 );