[sr-dev] git:master: sca: remove old SQL table creation file

Module: sip-router Branch: master Commit: cc3bc9669a2c528db9a8ada5e13cd553be9d2f1e URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=cc3bc96… Author: Andrew Mortensen <admorten(a)isc.upenn.edu> Committer: Andrew Mortensen <admorten(a)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;