o Initial import.

1 files changed, 24 insertions, 0 deletions

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'));