DROP TABLE IF EXISTS `{#prefix}website`;
CREATE TABLE `{#prefix}website` (
  `vkey` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '键',
  `value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '值',
  PRIMARY KEY (`vkey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('name', '天方夜谭云助手');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('keywords', '天方夜谭，音乐，播放器，程序，秒赞网');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('describe', '天方夜谭云助手，秒赞，音乐播放器，云签到混合型全新的系统');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('qq', '17404785');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('email', '17404785@qq.com');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('group', '592427909');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('foot', 'copyright © 2020 By 天方夜谭');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('reg_q_quota', '1');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('reg_p_quota', '1');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('reg_s_quota', '1');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('reg_u_quota', '10');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('reg_money', '1.00');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('login_notice', '请先登录后再进行操作！<img src=\"http://img.baidu.com/hi/jx2/j_0001.gif\"/>');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('users_notice', '该程序由天方夜谭一个人独立开发<br/>QQ：17404785,交流Q群：592427909<br/>该程序为天方夜谭云助手商业版V1.0.0<br/>程序为商业版,请勿泛滥,否正后果自负<br/><p>开发不易,互相尊重,版权所有,侵权必究!</p><p><img src=\"http://img.baidu.com/hi/jx2/j_0057.gif\"/></p>');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('music_api', 'https://cloud.xmyrs.cn/music/api.php');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('palyer_notice', '在这里你可以任意克隆任何一个播放器的样式哦，如果不知道怎么用，请联系站长QQ17404785！(●&#39;◡&#39;●)<img src=\"http://img.baidu.com/hi/jx2/j_0025.gif\"/>');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('player_font_color', 'white');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('player_external_box_shadow', '0px 0px 0px 1px rgba(158, 158, 158, 0.26)');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('player_background', 'transparent url(https://desk-fd.zol-img.com.cn/t_s1366x768c5/g5/M00/0C/09/ChMkJ13XoBCIeseEAAP4CsGl2PMAAvXlwOr-dAAA_gi582.jpg) center center no-repeat');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('player_transparent', 'blur(50px)');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('player_switch_box_shadow', '1px 0px 0px 1px #9e9e9e5e');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('player_switch_background', '#eeeeee21 none repeat scroll 0% 0%');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('player_hover_btn_coler', '#03a9f4');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('player_cover_frame_color', '4px solid white');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('player_progress_color', 'rgba(0,0,0,.3)');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('player_progress_back_color', 'aqua');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('player_progress_btn_color', 'white');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('player_roll_color', '#00ffff17');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('player_scroll_bar_color', '#4CAF50');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('player_lyric_container_color', '#607d8b4f');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('player_lyric_art_font_file', 'https://style.xmyrs.cn/font/gute.ttf');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('player_lyric_text_shadow', '0 0 20px #8BC34A');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('player_lyric_font_color', '#8bc34a');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('player_lyric_hover_color', '#8bc34a');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('qqlogin_api', 'https://qqlogin.xmyrs.cn/qqlogin2/');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('terminal_api', 'http://127.0.0.1:51888/');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('terminal_key', '123456');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('terminal_cron', '123456');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('greetings_title', '欢迎来到天方夜谭云助手');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('greetings_content', '站长QQ：17404785，官方交流Q群：592427909，期待您的到来！');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('smtp_host', 'smtp.qq.com');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('smtp_port', '465');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('smtp_user', 'admin@qq.com');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('smtp_pwd', 'admin');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('codepay_id', '105465');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('codepay_key', 'oF4DJcFt6ikhMPo5BXkDi786Vw7E5FNC');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('codepay_act', '0');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('agent_take', '80');
INSERT INTO `{#prefix}website`(`vkey`, `value`) VALUES ('action', 'notice');

DROP TABLE IF EXISTS `{#prefix}website_goods`;
CREATE TABLE `{#prefix}website_goods` (
  `id` int(16) NOT NULL AUTO_INCREMENT COMMENT '唯一标识',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '商品名称',
  `image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '商品图片',
  `content` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '商品描述',
  `stock` int(20) DEFAULT '0' COMMENT '商品数量',
  `mold` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '商品类型',
  `money` decimal(7,2) DEFAULT NULL COMMENT '商品价格',
  `addtime` datetime DEFAULT NULL COMMENT '上架时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `{#prefix}website_leader`;
CREATE TABLE `{#prefix}website_leader` (
  `id` int(16) NOT NULL AUTO_INCREMENT COMMENT '唯一标识',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '客服称呼',
  `qq` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '客服QQ',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `{#prefix}website_player`;
CREATE TABLE `{#prefix}website_player` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '唯一标识',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '播放器名称',
  `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '播放器图片',
  `style` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '播放器样式',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `{#prefix}website_player`(`id`, `name`, `image`, `style`) VALUES (1, '默认样式', 'https://style.xmyrs.cn/TFYT/player.png', '1');

DROP TABLE IF EXISTS `{#prefix}website_prize`;
CREATE TABLE `{#prefix}website_prize` (
  `id` int(16) NOT NULL AUTO_INCREMENT COMMENT '唯一标识',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '奖品名称',
  `num` int(20) DEFAULT NULL COMMENT '奖品数量',
  `mold` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '奖品类型',
  `luck` int(20) DEFAULT NULL COMMENT '中奖概率',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `{#prefix}website_prize`(`id`, `name`, `num`, `mold`, `luck`) VALUES (1, '加群资格', 592427909, 'jq', 50);
INSERT INTO `{#prefix}website_prize`(`id`, `name`, `num`, `mold`, `luck`) VALUES (2, '彩虹屁', 3, 'money', 50);
INSERT INTO `{#prefix}website_prize`(`id`, `name`, `num`, `mold`, `luck`) VALUES (3, '挂机配额', 2, 'q_quota', 50);
INSERT INTO `{#prefix}website_prize`(`id`, `name`, `num`, `mold`, `luck`) VALUES (4, '播放器配额', 1, 'p_quota', 50);
INSERT INTO `{#prefix}website_prize`(`id`, `name`, `num`, `mold`, `luck`) VALUES (5, '歌单配额', 2, 's_quota', 50);
INSERT INTO `{#prefix}website_prize`(`id`, `name`, `num`, `mold`, `luck`) VALUES (6, '音乐储存配额', 1, 'u_quota', 20);
INSERT INTO `{#prefix}website_prize`(`id`, `name`, `num`, `mold`, `luck`) VALUES (7, '谢谢参与', 0, 'no', 50);
INSERT INTO `{#prefix}website_prize`(`id`, `name`, `num`, `mold`, `luck`) VALUES (8, '谢谢参与', 0, 'no', 50);

DROP TABLE IF EXISTS `{#prefix}website_toplist`;
CREATE TABLE `{#prefix}website_toplist` (
  `id` int(16) NOT NULL AUTO_INCREMENT COMMENT '唯一标识',
  `music_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '网易云歌单ID',
  `remarks` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `{#prefix}website_toplist`(`id`, `music_id`, `remarks`) VALUES (1, '19723756', '云音乐飙升榜');
INSERT INTO `{#prefix}website_toplist`(`id`, `music_id`, `remarks`) VALUES (2, '3779629', '云音乐新歌榜');
INSERT INTO `{#prefix}website_toplist`(`id`, `music_id`, `remarks`) VALUES (3, '2884035', '网易原创歌曲榜');
INSERT INTO `{#prefix}website_toplist`(`id`, `music_id`, `remarks`) VALUES (5, '2250011882', '抖音排行榜');
INSERT INTO `{#prefix}website_toplist`(`id`, `music_id`, `remarks`) VALUES (4, '3778678', '云音乐热歌榜');
INSERT INTO `{#prefix}website_toplist`(`id`, `music_id`, `remarks`) VALUES (7, '991319590', '云音乐说唱榜');

DROP TABLE IF EXISTS `{#prefix}video_api`;
CREATE TABLE `{#prefix}video_api` (
  `id` int(16) NOT NULL AUTO_INCREMENT COMMENT '唯一标识',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '接口备注',
  `api` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '接口地址',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `{#prefix}video_api`(`id`, `name`, `api`) VALUES (1, '默认接口1', 'http://api.baiyug.vip/index.php?url=');
INSERT INTO `{#prefix}video_api`(`id`, `name`, `api`) VALUES (2, '默认接口2', 'http://jiexi.071811.cc/jx2.php?url=');
INSERT INTO `{#prefix}video_api`(`id`, `name`, `api`) VALUES (3, '默认接口3', 'https://www.myxin.top/jx/api/?url=');
INSERT INTO `{#prefix}video_api`(`id`, `name`, `api`) VALUES (4, '默认接口4', 'https://jx.99yyw.com/?url=');
INSERT INTO `{#prefix}video_api`(`id`, `name`, `api`) VALUES (5, '默认接口5', 'http://o8ve.cn/1/?url=');
INSERT INTO `{#prefix}video_api`(`id`, `name`, `api`) VALUES (6, '默认接口6', 'http://api.xyingyu.com/?url=');
INSERT INTO `{#prefix}video_api`(`id`, `name`, `api`) VALUES (7, '默认接口7', 'http://api.greatchina56.com/?url=');
INSERT INTO `{#prefix}video_api`(`id`, `name`, `api`) VALUES (8, '默认接口8', 'http://jx.618g.com/?url=');
INSERT INTO `{#prefix}video_api`(`id`, `name`, `api`) VALUES (9, '默认接口9', 'http://jx.du2.cc/?url=');
INSERT INTO `{#prefix}video_api`(`id`, `name`, `api`) VALUES (10, '默认接口10', 'http://jx.iaeec.cn/jx.php/?url=');
INSERT INTO `{#prefix}video_api`(`id`, `name`, `api`) VALUES (11, '默认接口11', 'https://api.flvsp.com/?url=');
INSERT INTO `{#prefix}video_api`(`id`, `name`, `api`) VALUES (12, '默认接口12', 'http://jiexi.071811.cc/jx2.php?url=');
INSERT INTO `{#prefix}video_api`(`id`, `name`, `api`) VALUES (13, '默认接口13', 'http://www.82190555.com/index/qqvod.php?url=');
INSERT INTO `{#prefix}video_api`(`id`, `name`, `api`) VALUES (14, '默认接口14', 'https://api.flvsp.com/?url=');
INSERT INTO `{#prefix}video_api`(`id`, `name`, `api`) VALUES (15, '默认接口15', 'http://www.82190555.com/index/qqvod.php?url=');

DROP TABLE IF EXISTS `{#prefix}player`;
CREATE TABLE `{#prefix}player` (
  `id` int(16) NOT NULL AUTO_INCREMENT COMMENT '唯一标识',
  `only` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '绑定users表',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '播放器名称',
  `auto_play` tinyint(1) DEFAULT '0' COMMENT '自动播放(1=是/0=否)',
  `play_mode` tinyint(1) DEFAULT '0' COMMENT '播放模式(1=顺序/2=随机)',
  `song_quota` varchar(11) COLLATE utf8_unicode_ci DEFAULT '0' COMMENT '播放器歌单配额',
  `is_clone` tinyint(1) DEFAULT '0' COMMENT '是否允许克隆',
  `style` int(10) DEFAULT '0' COMMENT '播放器样式',
  `addtime` datetime DEFAULT NULL COMMENT '创建时间',
  `font_color` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '字体颜色',
  `external_box_shadow` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '播放器边框阴影色',
  `background` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '播放器默认背景',
  `transparent` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '播放器透明度',
  `switch_box_shadow` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '播放器开关阴影色',
  `switch_background` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '按钮背景颜色',
  `hover_btn_coler` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '鼠标滑过按钮颜色',
  `cover_frame_color` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '封面边框颜色',
  `progress_color` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '进度槽颜色',
  `progress_back_color` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '进度条颜色',
  `progress_btn_color` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '进度按钮颜色',
  `roll_color` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '滚动槽颜色',
  `scroll_bar_color` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '滚动条颜色',
  `lyric_container_color` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '歌词容器颜色',
  `lyric_art_font_file` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '艺术字文件',
  `lyric_text_shadow` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '歌词阴影颜色',
  `lyric_font_color` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '歌词颜色',
  `lyric_hover_color` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '歌词滑过的颜色',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `{#prefix}player_song`;
CREATE TABLE `{#prefix}player_song` (
  `id` int(16) NOT NULL AUTO_INCREMENT COMMENT '唯一标识',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '歌单名称',
  `quota` int(11) DEFAULT '127' COMMENT '歌曲配额',
  `img` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '歌单图片',
  `addtime` datetime DEFAULT NULL COMMENT '创建日期',
  `only` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '绑定users表',
  `player_id` int(16) DEFAULT NULL COMMENT '绑定播放器',
  `sort` int(16) DEFAULT '1' COMMENT '排序',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `{#prefix}player_music`;
CREATE TABLE `{#prefix}player_music` (
  `music_id` int(16) NOT NULL AUTO_INCREMENT COMMENT '唯一标识',
  `music_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '名称',
  `music_artist` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '歌手',
  `music_album` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '专辑名称',
  `music_url_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '歌曲ID',
  `music_pic_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'PIC DI',
  `music_lyric_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '歌词ID',
  `music_source` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '歌曲来源',
  `music_sort` int(16) DEFAULT '0' COMMENT '歌曲排序',
  `song_id` int(16) DEFAULT NULL COMMENT '绑定歌单',
  `only` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '绑定users表',
  PRIMARY KEY (`music_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `{#prefix}users`;
CREATE TABLE `{#prefix}users` (
  `uid` int(16) NOT NULL AUTO_INCREMENT COMMENT '唯一标识',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '昵称',
  `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '用户名',
  `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '密码',
  `qqopenid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'QQID',
  `qq` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'QQ号码',
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '联系邮箱',
  `cookie` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '登录COOKIE',
  `aqproblem` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '密保问题',
  `aqanswer` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '密保答案',
  `regip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '注册IP',
  `regcity` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '注册城市',
  `regtime` datetime DEFAULT NULL COMMENT '注册时间',
  `active` tinyint(1) DEFAULT NULL COMMENT '状态(删除=1)',
  `only` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '绑定数据',
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `{#prefix}users_chat`;
CREATE TABLE `{#prefix}users_chat` (
  `cid` int(16) NOT NULL AUTO_INCREMENT COMMENT '唯一标识',
  `content` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '聊天内容',
  `sendtime` datetime DEFAULT NULL COMMENT '发送时间',
  `qq` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '绑定users表',
  PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `{#prefix}users_lastlog`;
CREATE TABLE `{#prefix}users_lastlog` (
  `uid` int(11) NOT NULL COMMENT '绑定users表',
  `lastip` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '登录IP',
  `lastcity` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '登录城市地区',
  `lasttime` datetime NOT NULL COMMENT '登录时间'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `{#prefix}users_order`;
CREATE TABLE `{#prefix}users_order` (
  `id` int(16) NOT NULL AUTO_INCREMENT COMMENT '唯一标识',
  `order` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '订单号',
  `state` int(1) DEFAULT '0' COMMENT '订单状态',
  `mold` int(1) DEFAULT NULL COMMENT '支付方式',
  `addtime` datetime DEFAULT NULL COMMENT '创建时间',
  `endtime` datetime DEFAULT NULL COMMENT '完成时间',
  `only` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '绑定users表',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `{#prefix}users_service`;
CREATE TABLE `{#prefix}users_service` (
  `only` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '绑定users表',
  `vip` tinyint(1) DEFAULT '0' COMMENT 'VIP状态',
  `vipstart` datetime DEFAULT NULL COMMENT '开通时间',
  `vipend` datetime DEFAULT NULL COMMENT '结束时间',
  `q_quota` int(5) DEFAULT '0' COMMENT '挂机配额',
  `p_quota` int(5) DEFAULT '0' COMMENT '播放器配额',
  `s_quota` int(5) DEFAULT '0' COMMENT '歌曲配额',
  `u_quota` int(5) DEFAULT '0' COMMENT '歌曲上传配额',
  `music_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '网易云歌单ID',
  `money` decimal(7,2) DEFAULT '0.00' COMMENT '彩虹屁(余额)',
  `agent` tinyint(1) DEFAULT '0' COMMENT '代理(1=开通，0=关闭)',
  `cqyzt` tinyint(1) DEFAULT '0' COMMENT '交友状态',
  `chat_bg` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '聊天背景图片',
  `luck` tinyint(1) DEFAULT '0' COMMENT '抽奖状态',
  PRIMARY KEY (`only`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
