开发信息 返回

  • PHPEMS4.1数据库升级信息

    • 发布人:peadmin
  • CREATE TABLE IF NOT EXISTS `x2_consumelog` (
      `conlid` int(11) NOT NULL AUTO_INCREMENT,
      `conlcost` int(11) NOT NULL,
      `conluserid` int(11) NOT NULL,
      `conlinfo` varchar(120) NOT NULL,
      `conltype` int(4) NOT NULL,
      `conltime` int(11) NOT NULL,
      PRIMARY KEY (`conlid`),
      KEY `conluserid` (`conluserid`,`conltype`,`conltime`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

    x2_course表,请在模型中增加下列字段
      `course_oggfile` varchar(250) NOT NULL,
      `course_webmfile` varchar(250) NOT NULL,
      `course_youtu` varchar(240) NOT NULL,

    x2_coursesubject表增加下列字段
    `csdemo` tinyint(1) DEFAULT NULL,
      `csprice` text,

    x2_examhistory表增加下列字段
    `ehneedresit` tinyint(1) NOT NULL,
      `ehispass` tinyint(1) DEFAULT NULL,

    CREATE TABLE IF NOT EXISTS `x2_feedback` (
      `fbid` int(11) NOT NULL AUTO_INCREMENT,
      `fbquestionid` int(11) NOT NULL,
      `fbtype` varchar(120) NOT NULL,
      `fbcontent` text NOT NULL,
      `fbuserid` int(11) NOT NULL,
      `fbtime` int(11) NOT NULL,
      `fbstatus` tinyint(4) NOT NULL,
      `fbdoneuserid` int(11) NOT NULL,
      `fbdonetime` int(11) NOT NULL,
      PRIMARY KEY (`fbid`),
      KEY `fbquestionid` (`fbquestionid`,`fbuserid`),
      KEY `fbtype` (`fbtype`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

    CREATE TABLE IF NOT EXISTS `x2_opencourse` (
      `ocid` int(11) NOT NULL AUTO_INCREMENT,
      `ocuserid` int(11) NOT NULL,
      `occourseid` int(11) NOT NULL,
      `octime` int(11) NOT NULL,
      `ocendtime` int(11) NOT NULL,
      PRIMARY KEY (`ocid`),
      KEY `ocuserid` (`ocuserid`,`occourseid`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

    x2_user表增加下列字段
    `useropenid` varchar(48) NOT NULL

  • 2017-07-31