summaryrefslogtreecommitdiff
path: root/plugins/FeedSub/feedinfo.sql
blob: e9b53d26eb0824573b9c94bf7159c038ce7022d5 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
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;