1 CREATE TABLE `feedinfo` (
2 `id` int(11) NOT NULL auto_increment,
3 `profile_id` int(11) NOT NULL,
4 `feeduri` varchar(255) NOT NULL,
5 `homeuri` varchar(255) NOT NULL,
6 `huburi` varchar(255) NOT NULL,
7 `verify_token` varchar(32) default NULL,
8 `sub_start` datetime default NULL,
9 `sub_end` datetime default NULL,
10 `created` datetime NOT NULL,
11 `lastupdate` datetime NOT NULL,
13 UNIQUE KEY `feedinfo_feeduri_idx` (`feeduri`)
14 ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;