diff options
author | Brion Vibber <brion@pobox.com> | 2009-11-20 09:42:19 -0800 |
---|---|---|
committer | Brion Vibber <brion@pobox.com> | 2009-11-20 09:42:19 -0800 |
commit | b189c9500c3ea5362edfcbf818c2f847b4892da5 (patch) | |
tree | 760ed684d9595b872ec3258ff338c5cf22e27bf0 /plugins/FeedSub/feedinfo.sql | |
parent | d645db38ae4ff4179f7fc31d4501d48054c4b8e6 (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.sql | 14 |
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; |