From e67fa24d3c21792b3adab3f88e2383219018b696 Mon Sep 17 00:00:00 2001 From: Trygve Laugstøl Date: Tue, 13 Mar 2012 15:25:25 +0000 Subject: o Initial import. --- mq.sql | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 mq.sql (limited to 'mq.sql') diff --git a/mq.sql b/mq.sql new file mode 100644 index 0000000..80b8744 --- /dev/null +++ b/mq.sql @@ -0,0 +1,24 @@ +PRAGMA foreign_keys = ON; + +DROP TABLE item; +DROP TABLE queue; + +CREATE TABLE queue( + name VARCHAR(100) PRIMARY KEY, + endpoint_url VARCHAR(200) +); + +CREATE TABLE item( + id CHAR(13), + queue_name VARCHAR(100) NOT NULL, + created INTEGER NOT NULL, + headers CLOB NOT NULL, + PRIMARY KEY (id, queue_name), + FOREIGN KEY(queue_name) REFERENCES queue(name) +); + +INSERT INTO queue VALUES('a', NULL); +INSERT INTO queue VALUES('github', NULL); +INSERT INTO queue VALUES('b', "http://trygvis.dyndns.org/~trygvis/2012/02/http-mq/endpoint.php"); +-- INSERT INTO item VALUES('1', 'a', datetime('now')); +-- INSERT INTO item VALUES('1', 'b', datetime('now')); -- cgit v1.2.3