diff options
Diffstat (limited to 'mq.sql')
-rw-r--r-- | mq.sql | 24 |
1 files changed, 24 insertions, 0 deletions
@@ -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')); |