Module: sip-router Branch: tteras/mohqueue Commit: 24f66ecc72064c9bf40deeb324e666b6b95dfa83 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=24f66ec… Author: Timo Teräs <timo.teras(a)iki.fi> Committer: Timo Teräs <timo.teras(a)iki.fi> Date: Mon Oct 7 08:41:37 2013 +0300 mohqueue: remove handwritten .sql, it is now autogenerated --- modules/mohqueue/mohqueue.sql | 23 ----------------------- 1 files changed, 0 insertions(+), 23 deletions(-) diff --git a/modules/mohqueue/mohqueue.sql b/modules/mohqueue/mohqueue.sql deleted file mode 100644 index 583ba06..0000000 --- a/modules/mohqueue/mohqueue.sql +++ /dev/null @@ -1,23 +0,0 @@ -INSERT INTO version (table_name, table_version) values ('mohqueues','1'); -CREATE TABLE mohqueues ( - id SERIAL PRIMARY KEY NOT NULL, - name VARCHAR(25), - uri VARCHAR(100) NOT NULL, - mohdir VARCHAR(100), - mohfile VARCHAR(100) NOT NULL, - debug INTEGER NOT NULL, - CONSTRAINT mohqueue_uri_idx UNIQUE (uri), - CONSTRAINT mohqueue_name_idx UNIQUE (name) -); - -INSERT INTO version (table_name, table_version) values ('mohqcalls','1'); -CREATE TABLE mohqcalls ( - id SERIAL PRIMARY KEY NOT NULL, - mohq_id INTEGER NOT NULL, - call_id VARCHAR(100) NOT NULL, - call_status INTEGER NOT NULL, - call_from VARCHAR(100) NOT NULL, - call_contact VARCHAR(100), - call_time TIMESTAMP WITHOUT TIME ZONE NOT NULL, - CONSTRAINT mohqcalls_idx UNIQUE (call_id) -); \ No newline at end of file