summaryrefslogtreecommitdiff
path: root/plugins/FeedSub/feedinfo.sql
diff options
context:
space:
mode:
authorBrion Vibber <brion@pobox.com>2009-11-19 20:55:38 -0800
committerBrion Vibber <brion@pobox.com>2009-11-19 21:04:21 -0800
commitdd36c2de23dbdb30f333be1f9d5292d62363b0c8 (patch)
tree89eae38f77e74b51478cc2ec0c13a0ac249d75ba /plugins/FeedSub/feedinfo.sql
parentdc90e90fd2748f953a2d4750105817b41cafe43a (diff)
Initial functional version of feed subscription plugin, currently supporting only PuSH-enabled feeds.
Diffstat (limited to 'plugins/FeedSub/feedinfo.sql')
-rw-r--r--plugins/FeedSub/feedinfo.sql14
1 files changed, 14 insertions, 0 deletions
diff --git a/plugins/FeedSub/feedinfo.sql b/plugins/FeedSub/feedinfo.sql
new file mode 100644
index 000000000..e9b53d26e
--- /dev/null
+++ b/plugins/FeedSub/feedinfo.sql
@@ -0,0 +1,14 @@
+CREATE TABLE `feedinfo` (
+ `id` int(11) NOT NULL auto_increment,
+ `profile_id` int(11) NOT NULL,
+ `feeduri` varchar(255) NOT NULL,
+ `homeuri` varchar(255) NOT NULL,
+ `huburi` varchar(255) NOT NULL,
+ `verify_token` varchar(32) default NULL,
+ `sub_start` datetime default NULL,
+ `sub_end` datetime default NULL,
+ `created` datetime NOT NULL,
+ `lastupdate` datetime NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `feedinfo_feeduri_idx` (`feeduri`)
+) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;