PHPEMS

开发信息 返回

• 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