CREATE TABLE `activitybaseprop` ( `ID` smallint(6) NOT NULL DEFAULT '0' COMMENT '活动ID 1:签到奖励 2:升级福利 3:天天美食 4:月卡系统 5:激活码兑换 6:分享 7:问卷调查 8:登录有礼', `Name_CN` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '活动名称', `Name_EN` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `Name_TW` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `SourceFile` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '资源文件', `Dec_CN` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `Dec_EN` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `Dec_TW` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `IsUsing` tinyint(4) DEFAULT '1' COMMENT '是否使用中 0:禁用 1:使用 2:使用(但活动栏中不显示)', PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `activityprop` ( `ID` smallint(6) NOT NULL DEFAULT '0', `ActivityBaseID` smallint(6) DEFAULT '0' COMMENT '对应基础表ID', `IsUsing` tinyint(4) DEFAULT '1' COMMENT '是否使用中', `Name_CN` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '活动名称', `Name_EN` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `Name_TW` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `Desc_CN` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '活动名称', `Desc_EN` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `Desc_TW` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `StartTime` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '开始时间', `EndTime` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '结束时间', `FinishCond` int(11) DEFAULT '0' COMMENT '完成条件', `SourceFile` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '资源文件', `EncResID1` smallint(5) DEFAULT '0' COMMENT '资源奖励ID', `EncResID1Param1` int(11) DEFAULT '0' COMMENT '资源奖励1参数1', `EncResID1Param2` int(11) DEFAULT '0' COMMENT '资源奖励1参数2', `EncResID2` smallint(5) DEFAULT '0' COMMENT '资源奖励ID2', `EncResID2Param1` int(11) DEFAULT '0' COMMENT '资源奖励2参数1', `EncResID2Param2` int(11) DEFAULT '0' COMMENT '资源奖励2参数2', `EncResID3` smallint(5) DEFAULT '0' COMMENT '资源奖励ID3', `EncResID3Param1` int(11) DEFAULT '0' COMMENT '资源奖励3参数1', `EncResID3Param2` int(11) DEFAULT '0' COMMENT '资源奖励3参数2', `EncResID4` smallint(5) DEFAULT '0' COMMENT '资源奖励ID4', `EncResID4Param1` int(11) DEFAULT '0' COMMENT '资源奖励4参数1', `EncResID4Param2` int(11) DEFAULT '0' COMMENT '资源奖励4参数2', `EncResID5` smallint(5) DEFAULT '0' COMMENT '资源奖励ID5', `EncResID5Param1` int(11) DEFAULT '0' COMMENT '资源奖励5参数1', `EncResID5Param2` int(11) DEFAULT '0' COMMENT '资源奖励5参数2', `EncResID6` smallint(5) DEFAULT '0' COMMENT '资源奖励ID', `EncResID6Param1` int(11) DEFAULT '0' COMMENT '资源奖励1参数1', `EncResID6Param2` int(11) DEFAULT '0' COMMENT '资源奖励6参数2', PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `activitysubjectdetailprop` ( `ID` smallint(6) NOT NULL DEFAULT '0', `Name_CN` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '活动名称', `Name_EN` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `Name_TW` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `Idx` varchar(20) DEFAULT NULL COMMENT '选项序号', `SubjectID` smallint(6) DEFAULT '0' COMMENT '题目', PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `activitysubjectprop` ( `ID` smallint(6) NOT NULL DEFAULT '0', `Name_CN` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '活动名称', `Name_EN` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `Name_TW` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `Dec_CN` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `Dec_EN` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `Dec_TW` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `ChkFlag` tinyint(4) DEFAULT '0' COMMENT '是否为多选 0:单选 1:多选', `Idx` tinyint(2) DEFAULT NULL COMMENT '选项分页号', `ActivityID` smallint(6) DEFAULT '0' COMMENT '对应活动表ID', PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `activityupdaterateprop` ( `ID` smallint(6) NOT NULL AUTO_INCREMENT, `ActivityID` smallint(6) DEFAULT '0' COMMENT '对应活动表ID(activityprop)', `MinSort` smallint(6) DEFAULT '0' COMMENT '最小名次', `MaxSort` smallint(6) DEFAULT '0' COMMENT '最大名次', `Rate` smallint(6) DEFAULT '0' COMMENT '倍数', PRIMARY KEY (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;