From 9928b96a20f17fe532dd0ac26914f83cbe34867a Mon Sep 17 00:00:00 2001
From: Christian Weiske <cweiske@cweiske.de>
Date: Thu, 24 Nov 2016 22:09:28 +0100
Subject: websub subcriptions work

---
 data/schema.sql | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 data/schema.sql

(limited to 'data/schema.sql')

diff --git a/data/schema.sql b/data/schema.sql
new file mode 100644
index 0000000..7f9312a
--- /dev/null
+++ b/data/schema.sql
@@ -0,0 +1,14 @@
+CREATE TABLE `subscriptions` (
+  `sub_id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
+  `sub_topic` varchar(4096) NOT NULL,
+  `sub_status` enum('subscribing','active','unsubscribing','unsubscribed','expired','denied') NOT NULL,
+  `sub_lease_seconds` int NOT NULL,
+  `sub_expires` datetime NOT NULL,
+  `sub_secret` varchar(256) NOT NULL,
+  `sub_capkey` varchar(128) NOT NULL,
+  `sub_created` datetime NOT NULL,
+  `sub_updated` datetime NOT NULL,
+  `sub_pings` int NOT NULL,
+  `sub_lastping` datetime NOT NULL,
+  `sub_statusmessage` varchar(512) NOT NULL
+) COMMENT='' COLLATE 'utf8_general_ci';
-- 
cgit v1.2.3

