-- MySQL dump 10.13 Distrib 5.5.43, for debian-linux-gnu (x86_64) -- -- Host: 192.168.12.4 Database: onepage_v1_sg -- ------------------------------------------------------ -- Server version 5.5.38-0+wheezy1-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `article_like` -- DROP TABLE IF EXISTS `article_like`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `article_like` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `event_id` int(11) NOT NULL DEFAULT 0, `uid` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `event_id` (`event_id`,`uid`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='文章点赞'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `article_like_counter` -- DROP TABLE IF EXISTS `article_like_counter`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `article_like_counter` ( `event_id` int(10) unsigned NOT NULL DEFAULT 0, `likes` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`event_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='文章点赞计数'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `lottery_data` -- DROP TABLE IF EXISTS `lottery_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lottery_data` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `events_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '所属抽奖活动ID', `prize_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '奖项ID', `uid` int(11) NOT NULL DEFAULT '0' COMMENT '获奖用户ID', `winning_time` int(10) unsigned NOT NULL COMMENT '用户获奖时间', `winners_time` int(10) unsigned NOT NULL COMMENT '程序到时发奖间', `scratch_receive` tinyint(2) NOT NULL DEFAULT '1' COMMENT '对刮挂卡领取奖品的特殊处理 1:用户已领取 2：用户未领取', `extend` text NOT NULL DEFAULT '', `create_time` int(10) unsigned NOT NULL DEFAULT 0, `update_time` int(10) unsigned NOT NULL DEFAULT 0, `cas_token` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='抽奖数据表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `lottery_delivery_channels` -- DROP TABLE IF EXISTS `lottery_delivery_channels`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lottery_delivery_channels` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '渠道ID', `str_name` varchar(100) NOT NULL DEFAULT '' COMMENT '渠道名称', `events_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '活动ID', `platform_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '平台ID', `pv_num` int(10) NOT NULL DEFAULT '0' COMMENT 'pv数', `extend` text NOT NULL DEFAULT '', `create_time` int(10) unsigned NOT NULL DEFAULT 0, `update_time` int(10) unsigned NOT NULL DEFAULT 0, `cas_token` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='投放渠道'; /*!40101 SET character_set_client = @saved_cs_client */; -- ---------------------------- -- Table structure for focus -- ---------------------------- DROP TABLE IF EXISTS `focus`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `focus` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `platform_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '平台ID', `name` varchar(100) NOT NULL COMMENT '名称', `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态：1：存在 2：删除', `extend` text NOT NULL COMMENT '扩展字段', `create_time` int(10) unsigned NOT NULL COMMENT '创建时间', `update_time` int(10) unsigned NOT NULL COMMENT '更新时间', `cas_token` int(10) unsigned NOT NULL COMMENT '乐观锁', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='精彩推荐'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `lottery_events` -- DROP TABLE IF EXISTS `lottery_events`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lottery_events` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '抽奖活动ID', `events_name` varchar(100) NOT NULL DEFAULT '' COMMENT '抽奖活动名称', `begin_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '活动开始时间', `end_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '活动结束时间', `type` tinyint(3) NOT NULL DEFAULT '0' COMMENT '活动类型 ：转盘：刮挂卡', `display` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否显示 0 ：不显示 1：显示', `share_button` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否显示分享按钮 1 ：不显示 2：显示', `del` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否被管理员删除', `list_display` tinyint(1) NOT NULL DEFAULT '0' COMMENT '列表中是否显示', `category_id` tinyint(1) NOT NULL DEFAULT '0' COMMENT '分类id', `focus_display` tinyint(1) NOT NULL DEFAULT '0' COMMENT '推荐到焦点图', `top_display` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否置顶', `platform_ids` int(10) NOT NULL DEFAULT '0' COMMENT '所属列表', `operator_uid` int(10) NOT NULL DEFAULT '0' COMMENT '操作人UID', `extend` text NOT NULL DEFAULT '', `create_time` int(10) unsigned NOT NULL DEFAULT 0, `update_time` int(10) unsigned NOT NULL DEFAULT 0, `cas_token` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='抽奖活动信息表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `lottery_events_code_data` -- DROP TABLE IF EXISTS `lottery_events_code_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lottery_events_code_data` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `events_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '所属活动ID', `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户ID', `data` text NOT NULL DEFAULT '' COMMENT '数据', `extend` text NOT NULL DEFAULT '', `create_time` int(10) unsigned NOT NULL DEFAULT 0, `update_time` int(10) unsigned NOT NULL DEFAULT 0, `cas_token` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='奖池数据表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `lottery_events_forms` -- DROP TABLE IF EXISTS `lottery_events_forms`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lottery_events_forms` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `events_id` int(10) unsigned NOT NULL DEFAULT 0, `uid` int(10) unsigned NOT NULL DEFAULT 0, `extend` text NOT NULL DEFAULT '', `create_time` int(10) unsigned NOT NULL DEFAULT 0, `update_time` int(10) unsigned NOT NULL DEFAULT 0, `cas_token` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='活动表单'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `lottery_events_invitation` -- DROP TABLE IF EXISTS `lottery_events_invitation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lottery_events_invitation` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `events_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '所属活动ID', `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户ID', `user_name` varchar(100) NOT NULL DEFAULT '' COMMENT '姓名', `phone` varchar(100) NOT NULL DEFAULT '' COMMENT '电话', `city` varchar(100) NOT NULL DEFAULT '' COMMENT '城市', `mail` varchar(100) NOT NULL DEFAULT '' COMMENT 'Email', `extend` text NOT NULL DEFAULT '', `create_time` int(10) unsigned NOT NULL DEFAULT 0, `update_time` int(10) unsigned NOT NULL DEFAULT 0, `cas_token` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='活动[邀请函用户]'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `lottery_events_letters` -- DROP TABLE IF EXISTS `lottery_events_letters`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lottery_events_letters` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '字母-id', `events_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '所属活动ID', `ABC_name` varchar(100) NOT NULL DEFAULT '' COMMENT '字母名称', `img_1` varchar(100) NOT NULL DEFAULT 'null' COMMENT '字母名称图片1', `img_2` varchar(100) NOT NULL DEFAULT 'null' COMMENT '字母名称图片2', `num` int(10) NOT NULL DEFAULT '1' COMMENT '字母数量', `winning_num` int(10) NOT NULL DEFAULT '0' COMMENT '抽中字母数量', `extend` text NOT NULL DEFAULT '', `create_time` int(10) unsigned NOT NULL DEFAULT 0, `update_time` int(10) unsigned NOT NULL DEFAULT 0, `cas_token` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='活动[收集字母信息]'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `lottery_events_log` -- DROP TABLE IF EXISTS `lottery_events_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lottery_events_log` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'LOGID', `events_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '所属活动ID', `type` tinyint(3) NOT NULL DEFAULT '0' COMMENT '1：访问 2：参与 3：获得', `uid` int(11) NOT NULL DEFAULT '0' COMMENT '获奖用户ID', `extend` text NOT NULL DEFAULT '', `create_time` int(10) unsigned NOT NULL DEFAULT 0, `update_time` int(10) unsigned NOT NULL DEFAULT 0, `cas_token` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='活动日志信息表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `lottery_events_try` -- DROP TABLE IF EXISTS `lottery_events_try`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lottery_events_try` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'LOGID', `events_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '所属活动ID', `uid` int(11) NOT NULL DEFAULT '0' COMMENT '获奖用户ID', `apply_txt` text NOT NULL COMMENT '用户申请信息', `extend` text NOT NULL DEFAULT '', `create_time` int(10) unsigned NOT NULL DEFAULT 0, `update_time` int(10) unsigned NOT NULL DEFAULT 0, `cas_token` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='活动[试用申请信息]'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `lottery_events_user_letters` -- DROP TABLE IF EXISTS `lottery_events_user_letters`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lottery_events_user_letters` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `events_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '所属活动ID', `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户ID', `extend` text NOT NULL DEFAULT '', `create_time` int(10) unsigned NOT NULL DEFAULT 0, `update_time` int(10) unsigned NOT NULL DEFAULT 0, `cas_token` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='活动[用户收集字母信息]'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `lottery_events_vote` -- DROP TABLE IF EXISTS `lottery_events_vote`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lottery_events_vote` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `events_id` int(10) unsigned NOT NULL COMMENT '所属活动ID', `title` varchar(100) NOT NULL DEFAULT '' COMMENT '投票标题', `img_url` varchar(100) NOT NULL DEFAULT '' COMMENT '投票配图', `num` int(10) NOT NULL DEFAULT '0' COMMENT '投票数', `add_num` int(10) NOT NULL DEFAULT '0' COMMENT '作弊投票数', `extend` text NOT NULL DEFAULT '', `create_time` int(10) unsigned NOT NULL DEFAULT 0, `update_time` int(10) unsigned NOT NULL DEFAULT 0, `cas_token` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='活动[投票项]'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `lottery_events_vote_user_log` -- DROP TABLE IF EXISTS `lottery_events_vote_user_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lottery_events_vote_user_log` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `events_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '所属活动ID', `vote_id` varchar(100) NOT NULL DEFAULT '' COMMENT '投票项ID', `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户ID', `extend` text NOT NULL DEFAULT '', `create_time` int(10) unsigned NOT NULL DEFAULT 0, `update_time` int(10) unsigned NOT NULL DEFAULT 0, `cas_token` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='活动[用户投票记录]'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `lottery_prize` -- DROP TABLE IF EXISTS `lottery_prize`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lottery_prize` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '奖项ID', `events_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '所属活动ID', `prize_name` varchar(100) NOT NULL DEFAULT '' COMMENT '奖品名称', `prize_num` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '奖品数量', `prize_winning_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '已经抽中的数量', `type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态 1:实物 2：虚拟', `display` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否显示 0 ：不显示 1：显示', `extend` text NOT NULL DEFAULT '', `create_time` int(10) unsigned NOT NULL DEFAULT 0, `update_time` int(10) unsigned NOT NULL DEFAULT 0, `cas_token` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='抽奖奖品表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `lottery_prize_virtual_data` -- DROP TABLE IF EXISTS `lottery_prize_virtual_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lottery_prize_virtual_data` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `prize_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '奖项ID', `data` text NOT NULL DEFAULT '' COMMENT '奖池数据', `lottery_data_id` int(11) NOT NULL DEFAULT '0' COMMENT '获奖数据ID', `extend` text NOT NULL DEFAULT '', `create_time` int(10) unsigned NOT NULL DEFAULT 0, `update_time` int(10) unsigned NOT NULL DEFAULT 0, `cas_token` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='奖池数据表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `lottery_pv_uv_log` -- DROP TABLE IF EXISTS `lottery_pv_uv_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lottery_pv_uv_log` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id', `events_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '活动ID', `pv_num` int(10) NOT NULL DEFAULT '0' COMMENT 'pv数', `uv_num` int(10) NOT NULL DEFAULT '0' COMMENT 'uv数', `date` int(10) unsigned NOT NULL COMMENT '统计日期时间戳', `extend` text NOT NULL DEFAULT '' COMMENT '扩展字段', `create_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '创建时间', `update_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '更新时间', `cas_token` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '乐观锁', PRIMARY KEY (`id`), UNIQUE KEY `events_id` (`events_id`,`date`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='活动PV&UV统计按日'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `lottery_user_express` -- DROP TABLE IF EXISTS `lottery_user_express`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lottery_user_express` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户ID', `phone` varchar(100) NOT NULL DEFAULT '' COMMENT '电话', `address` text NOT NULL COMMENT '地址', `user_name` varchar(100) NOT NULL DEFAULT '' COMMENT '收货人姓名', `extend` text NOT NULL DEFAULT '', `create_time` int(10) unsigned NOT NULL DEFAULT 0, `update_time` int(10) unsigned NOT NULL DEFAULT 0, `cas_token` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `uid` (`uid`), UNIQUE KEY `uid_2` (`uid`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='用户收货信息'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `lottery_user_feedback` -- DROP TABLE IF EXISTS `lottery_user_feedback`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lottery_user_feedback` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'LOGID', `events_id` int(10) unsigned NOT NULL COMMENT '所属活动ID', `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户ID', `extend` text NOT NULL DEFAULT '', `create_time` int(10) unsigned NOT NULL DEFAULT 0, `update_time` int(10) unsigned NOT NULL DEFAULT 0, `cas_token` int(10) unsigned NOT NULL DEFAULT 0, `status` int(10) unsigned NOT NULL DEFAULT 1 COMMENT '显示状态 1显示 2隐藏', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='用户反馈信息'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `lottery_user_participate_log` -- DROP TABLE IF EXISTS `lottery_user_participate_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lottery_user_participate_log` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'LOGID', `events_id` int(10) unsigned NOT NULL COMMENT '所属活动ID', `uid` int(11) NOT NULL DEFAULT '0' COMMENT '获奖用户ID', `extend` text NOT NULL DEFAULT '', `create_time` int(10) unsigned NOT NULL DEFAULT 0, `update_time` int(10) unsigned NOT NULL DEFAULT 0, `cas_token` int(10) unsigned NOT NULL DEFAULT 0, `audit` int(10) unsigned NOT NULL DEFAULT 1, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='活动用户参与表'; /*!40101 SET character_set_client = @saved_cs_client */; -- ---------------------------- -- Table structure for category -- ---------------------------- DROP TABLE IF EXISTS `category`; CREATE TABLE `category` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `name` varchar(100) NOT NULL COMMENT '分类名', `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态：1：存在 2：删除', `extend` text NOT NULL COMMENT '扩展字段', `create_time` int(10) unsigned NOT NULL COMMENT '创建时间', `update_time` int(10) unsigned NOT NULL COMMENT '更新时间', `cas_token` int(10) unsigned NOT NULL COMMENT '乐观锁', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='平台分类'; -- -- Table structure for table `platform` -- DROP TABLE IF EXISTS `platform`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `platform` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'platformID', `name` varchar(100) NOT NULL DEFAULT '' COMMENT '平台名称', `css` varchar(100) NOT NULL DEFAULT '' COMMENT 'css文件名称', `extend` text NOT NULL DEFAULT '', `create_time` int(10) unsigned NOT NULL DEFAULT 0, `update_time` int(10) unsigned NOT NULL DEFAULT 0, `cas_token` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='平台'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `platform_bulletin` -- DROP TABLE IF EXISTS `platform_bulletin`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `platform_bulletin` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'bulletinID', `title` varchar(100) NOT NULL DEFAULT '' COMMENT '标题', `content` text NOT NULL DEFAULT '' COMMENT '内容', `operator_uid` int(11) NOT NULL DEFAULT '0' COMMENT '操作ID', `extend` text NOT NULL DEFAULT '', `create_time` int(10) unsigned NOT NULL DEFAULT 0, `update_time` int(10) unsigned NOT NULL DEFAULT 0, `cas_token` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='平台公告'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `user_info` -- DROP TABLE IF EXISTS `user_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user_info` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id（本平台UID）', `passport_uid` varchar(100) NOT NULL DEFAULT '' COMMENT '第三方用户ID', `groupid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '分组id', `is_new` tinyint(1) unsigned NOT NULL COMMENT '是否新用户，0新用户(待获取用户信息) 1老用户', `nickname` char(255) NOT NULL DEFAULT '' COMMENT '用户的昵称', `localRemark` char(150) NOT NULL DEFAULT '' COMMENT '本地备注', `extend` text NOT NULL COMMENT '扩展字段', `create_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '创建时间', `update_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '更新时间', `cas_token` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '乐观锁', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='用户基础数据'; /*!40101 SET character_set_client = @saved_cs_client */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2015-12-17 17:36:39