-- 员工表
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `realname` varchar(50) NOT NULL DEFAULT '' COMMENT '姓名',
  `headimg` varchar(255) NOT NULL DEFAULT '' COMMENT '自拍图片',
  `openid` char(32) NOT NULL UNIQUE COMMENT '微信openid',
  `status` int DEFAULT 1 COMMENT '1=正常 2=删除 3=其他组织',
  `created` bigint(13) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`)
)ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COMMENT='员工表';

-- 中奖信息
DROP TABLE IF EXISTS `lottery`;
CREATE TABLE `lottery` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `user_id` int(10) NOT NULL UNIQUE DEFAULT 0 COMMENT '用户id',
  `award` varchar(50) NOT NULL DEFAULT '' COMMENT '奖品',
  `is_cancel` int NOT NULL DEFAULT 0 COMMENT '是否取消 0=否 1=是',
  `is_next` int NOT NULL DEFAULT 0 COMMENT '取消中奖后是否能再次参与 0=不能 1=能',
  `created` bigint(13) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='中奖记录表';

-- 抽奖设置
DROP TABLE IF EXISTS `setting`;
CREATE TABLE `setting` (
  `key` char(50) NOT NULL UNIQUE COMMENT '键',
  `value` varchar(500) NOT NULL DEFAULT '' COMMENT '值',
  `note` varchar(255) NOT NULL DEFAULT '' COMMENT '描述'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='抽奖设置';

INSERT INTO `setting` values('isStopSign','1','是否停止注册 1=停止 2=开启'); 
INSERT INTO `setting` values('isStartVote','1','是否开启节目投票通道 1=开启 2=关闭');
INSERT INTO `setting` values('voteUrl','https://yq.vchangyi.com/B7BCF1B00A692CB96953A60ECF016356/Questionnaire/h5/index.html#/app/page/questionnaire/fillin-questionnaire?_identifier=yuanquan&qu_id=20129','节目投票通道url');