Initial functional version of feed subscription plugin, currently supporting only PuSH-enabled feeds.

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;