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

[Andrew Mortensen]

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

Author: Andrew Mortensen <admorten at isc.upenn.edu>
Committer: Andrew Mortensen <admorten at 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;