<span style="font-family:SimHei;font-size:18px;">创建数据库:</span>
DROP DATABASE IF EXISTS `subscribe`;
CREATE DATABASE `subscribe` DEFAULT CHARSET utf8;USE `subscribe`;
创建数据表:
DROP TABLE IF EXISTS `subscribe`;CREATE TABLE `subscribe` (
`ID` int(10) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`LiveID` varchar(20) NOT NULL COMMENT '直播ID',
`UID` varchar(20) NOT NULL DEFAULT '0' COMMENT '用户ID',
`From` smallint(2) NOT NULL DEFAULT '1' COMMENT '1:Web 2:Mobile 3:Pad 4:TV 5:PC',
`AddTime` int(10) NOT NULL DEFAULT '1' COMMENT '添加时间',
PRIMARY KEY (`ID`),
KEY `IX_Uid` (`UID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='直播预约表'