newlist

  博客园 :: 首页 :: 博问 :: 闪存 :: 新随笔 :: 联系 :: 订阅 订阅 :: 管理 ::
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;

 

posted on 2015-02-26 16:26  一枚程序  阅读(272)  评论(0编辑  收藏  举报