From e67fa24d3c21792b3adab3f88e2383219018b696 Mon Sep 17 00:00:00 2001
From: Trygve Laugstøl <trygvis@inamo.no>
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

