1 CREATE TABLE `subscriptions` (
2 `sub_id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
3 `sub_topic` varchar(4096) NOT NULL,
4 `sub_status` enum('subscribing','active','unsubscribing','unsubscribed','expired','denied') NOT NULL,
5 `sub_lease_seconds` int NOT NULL,
6 `sub_expires` datetime NOT NULL,
7 `sub_secret` varchar(256) NOT NULL,
8 `sub_capkey` varchar(128) NOT NULL,
9 `sub_created` datetime NOT NULL,
10 `sub_updated` datetime NOT NULL,
11 `sub_pings` int NOT NULL,
12 `sub_lastping` datetime NOT NULL,
13 `sub_statusmessage` varchar(512) NOT NULL
14 ) COMMENT='' COLLATE 'utf8_general_ci';