· 7 years ago · Feb 09, 2019, 04:08 AM
1CREATE TABLE IF NOT EXISTS `bot` (
2 `id` smallint(6) NOT NULL AUTO_INCREMENT,
3 `channel` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
4 `title` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
5 `status` text COLLATE utf8_unicode_ci NOT NULL,
6 `online` tinyint(1) NOT NULL DEFAULT '0',
7 `viewers` smallint(5) NOT NULL DEFAULT '0',
8 `up_time` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
9 `image` text COLLATE utf8_unicode_ci NOT NULL,
10 `broadcast` tinyint(1) NOT NULL DEFAULT '0',
11 `site` tinyint(1) NOT NULL DEFAULT '0',
12 `live_id` int(10) NOT NULL,
13 PRIMARY KEY (`id`)
14) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=378 ;