Module: sip-router Branch: master Commit: cc3bc9669a2c528db9a8ada5e13cd553be9d2f1e URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=cc3bc966...
Author: Andrew Mortensen admorten@isc.upenn.edu Committer: Andrew Mortensen admorten@isc.upenn.edu Date: Wed Nov 28 23:23:48 2012 -0500
sca: remove old SQL table creation file
- use make dbschema to generate sql from xml table schema instead.
---
modules/sca/sca.sql | 17 ----------------- 1 files changed, 0 insertions(+), 17 deletions(-)
diff --git a/modules/sca/sca.sql b/modules/sca/sca.sql deleted file mode 100644 index 6333a7d..0000000 --- a/modules/sca/sca.sql +++ /dev/null @@ -1,17 +0,0 @@ -INSERT INTO version (table_name, table_version) values ('sca_subscriptions', '0'); -CREATE TABLE sca_subscriptions ( - id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, - subscriber VARCHAR(255) NOT NULL, - aor VARCHAR(255) NOT NULL, - event INT(1) NOT NULL, - expires INT(11) NOT NULL, - state INT(1) NOT NULL, - app_idx INT(4) NOT NULL, - call_id VARCHAR(255) NOT NULL, - from_tag VARCHAR(128) NOT NULL, - to_tag VARCHAR(128) NOT NULL, - notify_cseq INT(11) NOT NULL, - subscribe_cseq INT(11) NOT NULL, - - CONSTRAINT sca_subscriptions_idx UNIQUE (subscriber, call_id, from_tag, to_tag) -) ENGINE=MyISAM;
-
Andrew Mortensen