onepage_mrhi/doc/onepage_project.sql

-- 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 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 '列表中是否显示',
  `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_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,
  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`
--

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