<?php
$sql="
CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_admin` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `weid` varchar(150) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `createtime` int(11) NOT NULL,
  `logintime` int(11) NOT NULL,
  `is_delete` tinyint(11) NOT NULL DEFAULT '1' COMMENT '0正常 1禁用',
  `pcate_id` int(8) NOT NULL COMMENT '一级类目id',
  `cate_id` int(8) NOT NULL COMMENT '二级级类目id',
  `relation_id` text NOT NULL COMMENT '关联试卷ID',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_advert` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `weid` int(11) DEFAULT '0',
  `homeId` varchar(255) DEFAULT NULL COMMENT '首页广告id',
  `secondId` varchar(255) DEFAULT NULL COMMENT '解析页广告id',
  `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_banji` (
  `banji_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(10) unsigned DEFAULT NULL,
  `uidht` int(10) unsigned NOT NULL,
  `school_id` int(10) unsigned NOT NULL,
  `nianfen_id` int(10) unsigned NOT NULL,
  `xdgl_id` int(10) unsigned NOT NULL,
  `nid` int(10) unsigned NOT NULL,
  `name` varchar(50) NOT NULL,
  `bname` varchar(50) NOT NULL,
  `parentid` int(10) unsigned NOT NULL,
  `displayorder` tinyint(3) unsigned NOT NULL,
  `enabled` tinyint(1) unsigned NOT NULL,
  `icon` varchar(100) NOT NULL,
  `banjikouhao` varchar(100) NOT NULL,
  `banxun` varchar(100) NOT NULL,
  `banjimubiao` varchar(100) NOT NULL,
  `bzrjy` varchar(200) NOT NULL,
  `description` varchar(200) NOT NULL,
  `styleid` int(10) unsigned NOT NULL,
  `linkurl` varchar(500) NOT NULL,
  `ishomepage` tinyint(1) NOT NULL,
  `status` int(11) DEFAULT '0',
  `icontype` tinyint(1) unsigned NOT NULL,
  `css` varchar(500) NOT NULL,
  PRIMARY KEY (`banji_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_banner` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL COMMENT '图片路径 ',
  `type` tinyint(1) DEFAULT '1' COMMENT '图片跳转方式 1本程序跳转  2外部链接 ',
  `link` text COMMENT '链接',
  `status` tinyint(1) DEFAULT '2' COMMENT '图片状态 1 显示 2 不显示',
  `createtime` int(11) NOT NULL COMMENT '创建时间',
  `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='轮播图表';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `name` varchar(255) NOT NULL COMMENT '分类名称',
  `pid` varchar(255) DEFAULT '0' COMMENT '分类父级 默认为顶级分类',
  `order` int(5) DEFAULT '0' COMMENT '分类序号  默认为0',
  `status` tinyint(1) DEFAULT '1' COMMENT '分类核状态 1 显示 2不显示',
  `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识',
  `createtime` int(11) NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`),
  KEY `idx_name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='分类表';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_cdkey` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL DEFAULT '0',
  `cid` int(11) NOT NULL DEFAULT '0',
  `code` varchar(255) DEFAULT NULL COMMENT '题库',
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户id 0未领取',
  `createtime` int(11) DEFAULT NULL COMMENT '时间',
  `usetime` int(11) DEFAULT NULL COMMENT '时间',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态 1未使用 2已使用',
  `kpool` varchar(2000) DEFAULT NULL COMMENT '到期时间',
  `display` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1启用 2作废',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`),
  KEY `idx_cid` (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='兑换码';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_cdkey_cate` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL,
  `createtime` int(11) DEFAULT NULL COMMENT '时间',
  `qpool` varchar(2000) DEFAULT NULL COMMENT '题库',
  `kpool` varchar(2000) DEFAULT NULL COMMENT '知识库',
  `msg` varchar(255) DEFAULT NULL COMMENT '提示信息',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态 1启用 2禁用',
  `is_delete` tinyint(1) DEFAULT '1' COMMENT '状态 1正常 2删除',
  `papers` varchar(2000) NOT NULL COMMENT '试卷ids',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='兑换码';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_cdkeys` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL DEFAULT '0',
  `code_id` int(11) NOT NULL DEFAULT '0',
  `kpool_id` int(11) NOT NULL DEFAULT '0' COMMENT '绑定',
  `type` tinyint(11) NOT NULL DEFAULT '0' COMMENT '绑定类型 1 试卷 2题库',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`),
  KEY `idx_code_id` (`code_id`),
  KEY `idx_kpool_id` (`kpool_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='兑换码-题库表';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_exercise` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `weid` int(11) DEFAULT '0',
  `uid` int(11) NOT NULL,
  `testid` int(11) NOT NULL,
  `test_type` int(11) DEFAULT NULL,
  `uanswer` varchar(255) DEFAULT NULL,
  `istatus` tinyint(2) DEFAULT '1',
  `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
  `isright` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='记录练习做的每道题';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_feedback` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `weid` int(11) DEFAULT '0',
  `uid` int(11) NOT NULL,
  `testid` int(11) DEFAULT NULL,
  `relation` varchar(255) DEFAULT NULL,
  `content` text,
  `istatus` tinyint(2) DEFAULT '1',
  `createtime` int(11) DEFAULT NULL COMMENT '时间',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='反馈表';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_gift` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '礼品id',
  `weid` int(11) unsigned NOT NULL DEFAULT '0',
  `name` varchar(100) NOT NULL COMMENT '礼品名称',
  `price` int(11) NOT NULL DEFAULT '100' COMMENT '礼品市场价格',
  `coins` int(11) NOT NULL DEFAULT '500' COMMENT '礼品所需金币',
  `image` varchar(255) NOT NULL COMMENT '礼品图片',
  `about` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_index_btn` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL DEFAULT '0',
  `doid` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL,
  `icon` varchar(255) DEFAULT NULL COMMENT '图片路径 ',
  `status` tinyint(1) DEFAULT '1' COMMENT '图片状态 1 显示 2 不显示',
  `sort` int(11) DEFAULT '0' COMMENT '排序',
  `types` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1模块功能 2题库',
  `library_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COMMENT='菜单按钮表';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_knowledge` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `one` int(11) DEFAULT '0' COMMENT '分类1',
  `two` int(11) DEFAULT '0' COMMENT '分类2',
  `three` int(11) DEFAULT '0' COMMENT '分类3',
  `title` varchar(255) NOT NULL,
  `content` text NOT NULL COMMENT '公告内容 ',
  `status` tinyint(1) DEFAULT '2' COMMENT '状态 1显示 2不显示',
  `createtime` int(11) NOT NULL COMMENT '创建时间',
  `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='知识点';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_knowledge_cate` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `name` varchar(255) NOT NULL COMMENT '知识点名称',
  `type` int(11) DEFAULT '1' COMMENT '分类 1刷知识点 2考前必备',
  `pid` int(11) DEFAULT '0' COMMENT '默认0为顶级分类',
  `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识',
  `status` tinyint(1) DEFAULT '1' COMMENT '显示隐藏',
  `price` decimal(10,2) DEFAULT '0.00',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='知识点分类表';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_notice` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `type` tinyint(1) NOT NULL COMMENT '公告类型',
  `title` varchar(255) NOT NULL COMMENT '公告标题',
  `content` text NOT NULL COMMENT '公告内容 ',
  `image` varchar(255) DEFAULT NULL COMMENT '活动公告的图片',
  `readnum` int(11) DEFAULT '0' COMMENT '阅读量',
  `status` tinyint(1) DEFAULT '2' COMMENT '公告状态 1 显示 2 不显示',
  `createtime` int(11) NOT NULL COMMENT '创建时间',
  `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识',
  `video_audio_id` varchar(255) DEFAULT NULL COMMENT '音/视频ID',
  `pcate` int(11) DEFAULT NULL COMMENT '文章所属分类',
  `ccate` int(11) DEFAULT NULL COMMENT '文章所属子分类',
  `article_type` tinyint(1) DEFAULT NULL COMMENT '文章的类型1文章2视频',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`),
  KEY `idx_type` (`type`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='公告表';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `type` int(11) NOT NULL COMMENT '购买类型 1购买考试 2VIP购买 ',
  `out_trade_no` varchar(255) NOT NULL,
  `userid` int(11) NOT NULL,
  `openid` varchar(255) DEFAULT NULL COMMENT '购买者的openid',
  `order_status` tinyint(1) NOT NULL COMMENT '订单状态 0未支付1已支付',
  `all_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '总金额',
  `true_money` decimal(10,2) NOT NULL COMMENT '实付款',
  `createtime` int(11) NOT NULL,
  `paytime` int(11) DEFAULT NULL,
  `msg` varchar(255) DEFAULT NULL,
  `dataid` int(11) DEFAULT NULL,
  `transaction_sn` varchar(255) DEFAULT NULL COMMENT '第三方流水号',
  `istatus` tinyint(1) DEFAULT '1' COMMENT '订单删除标识',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`),
  KEY `idx_out_trade_no` (`out_trade_no`),
  KEY `idx_transaction_sn` (`transaction_sn`),
  KEY `idx_dataid` (`dataid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_paper` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `title` varchar(255) NOT NULL COMMENT '试卷标题',
  `type` tinyint(1) DEFAULT '1' COMMENT '试卷类型',
  `franction` text NOT NULL COMMENT '每个题型有多少  每个题多少分',
  `total_franction` int(4) DEFAULT '0' COMMENT '试卷总分值',
  `status` int(1) DEFAULT '2' COMMENT '试卷状态 默认为2 待完善试卷 1 已完善试卷',
  `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识',
  `createtime` int(11) NOT NULL COMMENT '创建时间',
  `dnum` int(11) DEFAULT '0' COMMENT '做题人数',
  `displayorder` int(10) DEFAULT '0' COMMENT '显示顺序',
  `price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '试卷价格默认0',
  `times` int(8) NOT NULL COMMENT '试卷时间单位分',
  `is_repeat` tinyint(1) NOT NULL DEFAULT '2' COMMENT '重复答题 1可以 2否',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`),
  KEY `idx_type` (`type`),
  KEY `idx_status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='试卷表';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_paper_test` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `paperid` varchar(255) NOT NULL COMMENT '试卷标题',
  `testid` int(11) NOT NULL COMMENT '试题ID',
  `test_type` int(11) NOT NULL COMMENT '题型类型',
  `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识',
  `createtime` int(11) NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`),
  KEY `idx_paperid` (`paperid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='试卷试题表';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_phonecode` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `phone` varchar(11) NOT NULL,
  `code` int(11) NOT NULL COMMENT '手机验证码',
  `createtime` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_phone` (`phone`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='手机发送验证码';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_q_year` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `name` varchar(255) NOT NULL COMMENT '年份名称',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态 1 显示 2不显示',
  `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识',
  `createtime` int(11) NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`),
  KEY `idx_name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='试题年份表';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_school` (
  `school_id` int(11) NOT NULL AUTO_INCREMENT,
  `weid` int(11) DEFAULT NULL,
  `school_name` varchar(200) DEFAULT NULL,
  `school_logo` varchar(200) DEFAULT NULL,
  `school_info_intro` text COMMENT '学校描述',
  `addtime` int(11) DEFAULT NULL,
  `mu_str` varchar(30) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1',
  `line_status` tinyint(1) DEFAULT '1',
  `cookbook_status` tinyint(1) DEFAULT '1',
  `class_notice_status` tinyint(1) DEFAULT '1' COMMENT '班级公告是否需要审核；1=》不需要；2=》需要',
  `school_type` tinyint(1) DEFAULT '0',
  `host_url` text COMMENT '官网地址',
  `on_school` tinyint(1) unsigned DEFAULT '0' COMMENT '在校天数',
  `begin_day` tinyint(1) unsigned DEFAULT '0' COMMENT '开始上课周数',
  `am_much` tinyint(1) unsigned DEFAULT '0' COMMENT '上午课数',
  `pm_much` tinyint(1) unsigned DEFAULT '0' COMMENT '下午课数',
  `ye_much` tinyint(1) unsigned DEFAULT '0' COMMENT '晚上课数',
  `line_type` text COMMENT '班级圈类别',
  `appointment` text COMMENT '预约类别',
  `parents` tinyint(1) DEFAULT '3' COMMENT '学生可绑定家长数',
  `add_time` int(11) unsigned DEFAULT '0',
  PRIMARY KEY (`school_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_setting` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `mchid` varchar(50) DEFAULT NULL COMMENT '微信支付商户ID',
  `pay_secret` varchar(50) DEFAULT NULL COMMENT '支付密匙',
  `pay_open` tinyint(1) DEFAULT '0' COMMENT '支付开启 1开启',
  `signcertpath` varchar(255) DEFAULT NULL COMMENT '商户CERT证书路径',
  `signkeypath` varchar(255) DEFAULT NULL COMMENT '商户KEY证书路径',
  `AccessKeyId` varchar(255) DEFAULT NULL COMMENT '阿里云账号',
  `AccessKeySecret` varchar(255) DEFAULT NULL COMMENT '阿里云秘钥',
  `SignName` varchar(255) DEFAULT NULL COMMENT '阿里云短信签名',
  `TemplateCode` varchar(255) DEFAULT NULL COMMENT '阿里云验证码模板id',
  `RegionId` varchar(255) DEFAULT NULL COMMENT '阿里云视频点播区域名',
  `banner_height` int(11) DEFAULT '232' COMMENT '轮播图高',
  `shareupper` int(11) DEFAULT '0' COMMENT '每日分享获得积分上限',
  `share_title` varchar(255) DEFAULT NULL COMMENT '分享标题',
  `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识',
  `is_display` tinyint(1) DEFAULT '1' COMMENT '公告是否显示',
  `display_num` int(11) DEFAULT '5' COMMENT '公告显示条数',
  `use_integral_num` int(10) DEFAULT NULL COMMENT '高频题消耗积分个数',
  `franction` text COMMENT '每个题型有多少每题多少分',
  `paper_time` int(11) DEFAULT NULL COMMENT '考试时长单位(分)',
  `reward_integral` int(11) DEFAULT NULL COMMENT '答对一题奖励积分数量',
  `medal` text COMMENT '勋章设置',
  `share_integral` int(11) DEFAULT NULL COMMENT '每次分享可得积分',
  `sms_accessKeyId` varchar(255) DEFAULT NULL COMMENT '短信accesskeyid',
  `sms_accessKeySecret` varchar(255) DEFAULT NULL COMMENT '短信accesskeysecret',
  `about` text COMMENT '关于我们',
  `wechat_number` varchar(255) DEFAULT NULL COMMENT '商家微信号',
  `standard` int(11) DEFAULT '5' COMMENT '每日答题达标数量',
  `pass` varchar(255) DEFAULT NULL,
  `good` varchar(255) DEFAULT NULL,
  `excellent` varchar(255) DEFAULT NULL,
  `randoms` varchar(255) DEFAULT NULL,
  `randoms_icon` varchar(255) DEFAULT NULL,
  `randoms_rule` varchar(255) DEFAULT NULL,
  `notdone` varchar(255) DEFAULT NULL,
  `notdone_icon` varchar(255) DEFAULT NULL,
  `notdone_rule` varchar(255) DEFAULT NULL,
  `qhig` varchar(255) DEFAULT NULL,
  `qhig_icon` varchar(255) DEFAULT NULL,
  `qhig_rule` varchar(255) DEFAULT NULL,
  `qint` varchar(255) DEFAULT NULL,
  `qint_icon` varchar(255) DEFAULT NULL,
  `qint_rule` varchar(255) DEFAULT NULL,
  `qhot` varchar(255) DEFAULT NULL,
  `qhot_icon` varchar(255) DEFAULT NULL,
  `qhot_rule` varchar(255) DEFAULT NULL,
  `qdiff` varchar(255) DEFAULT NULL,
  `qdiff_icon` varchar(255) DEFAULT NULL,
  `qdiff_rule` varchar(255) DEFAULT NULL,
  `countdown` varchar(255) DEFAULT NULL COMMENT '事件名称',
  `countdowntime` datetime DEFAULT NULL COMMENT '时间点',
  `time_display` tinyint(1) DEFAULT '1' COMMENT '倒计时显示',
  `student_open` tinyint(1) DEFAULT '1' COMMENT '学生开启 1开启',
  `freepoolnum` int(11) DEFAULT '0' COMMENT '题库体验题数',
  `freeknowledgenum` int(11) DEFAULT '0' COMMENT '知识点体验章数',
  `info_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否必须完善信息1是',
  `app_id` varchar(50) NOT NULL COMMENT '微信公众公众号Appid',
  `app_secret` varchar(50) NOT NULL COMMENT '微信公众SERECT',
  `IOS` tinyint(1) NOT NULL DEFAULT '2' COMMENT '1开启 2关闭',
  `customer_service` varchar(255) NOT NULL COMMENT '客服二维码',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='基础设置表';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_share_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `weid` int(11) DEFAULT '0',
  `uid` int(11) NOT NULL,
  `num` int(11) DEFAULT NULL,
  `istatus` tinyint(2) DEFAULT '1',
  `day` date DEFAULT NULL COMMENT '记录哪一天',
  `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_son_simple` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `weid` varchar(150) NOT NULL,
  `son_title` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_test` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `type` tinyint(1) NOT NULL COMMENT '试题类型',
  `title` varchar(255) NOT NULL COMMENT '试题题目 仅在列表显示 试卷内不显示',
  `libraryid` int(11) DEFAULT '0' COMMENT '题库id',
  `question` text NOT NULL COMMENT '题目',
  `qimage` text COMMENT '试题图片',
  `qaudio` text COMMENT '问题音频',
  `a_type` tinyint(1) DEFAULT '0' COMMENT '选项类型',
  `option` text COMMENT '选项',
  `rightkey` text NOT NULL COMMENT '正确答案',
  `analysis` text NOT NULL COMMENT '答案解析',
  `aimage` text COMMENT '解析图片',
  `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识',
  `createtime` int(11) NOT NULL COMMENT '创建时间',
  `anum` int(11) DEFAULT '0' COMMENT '本题答题次数 仅考试',
  `rnum` int(11) DEFAULT '0' COMMENT '正确回答次数 仅考试',
  `level` tinyint(1) DEFAULT '1' COMMENT '难度等级',
  `qvideo` text COMMENT '问题视频',
  `analysis_audio` text COMMENT '音频解析',
  `knowledge` text COMMENT '所属知识点类别',
  `type_classification` text COMMENT '类型分类',
  `q_year` text COMMENT '年份',
  `pid` int(11) DEFAULT '0' COMMENT '问题父id',
  `son_status` int(1) DEFAULT NULL COMMENT '语音题是否加了小题',
  `display` tinyint(1) DEFAULT '1' COMMENT '1-显示2-不显示',
  `son_simple` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`),
  KEY `idx_type` (`type`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='试题表';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_test_type` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `name` varchar(255) NOT NULL COMMENT '试题库名称',
  `pid` int(11) DEFAULT '0' COMMENT '默认0为顶级分类',
  `gpid` int(11) DEFAULT '0' COMMENT '默认0',
  `price` decimal(10,2) DEFAULT '0.00',
  `status` tinyint(1) DEFAULT '1' COMMENT '题库状态',
  `is_student` tinyint(1) DEFAULT '0' COMMENT '学员专享 1是',
  `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识',
  `createtime` int(11) NOT NULL COMMENT '创建时间',
  `display_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='试题库表';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_type_cate` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `name` varchar(255) NOT NULL COMMENT '分类名称',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态 1 显示 2不显示',
  `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识',
  `createtime` int(11) NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`),
  KEY `idx_name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='类型分类表';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `openid` varchar(255) NOT NULL COMMENT '用户标识',
  `unionid` varchar(255) DEFAULT NULL,
  `nickname` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '用户昵称 可保存特殊符号',
  `headimg` varchar(255) DEFAULT NULL COMMENT '用户头像',
  `name` varchar(50) DEFAULT NULL COMMENT '用户姓名',
  `phone` varchar(11) DEFAULT NULL COMMENT '手机号',
  `gradeid` int(11) DEFAULT NULL COMMENT '个人信息完善页面 选择年级ID',
  `classid` int(11) DEFAULT NULL COMMENT '班级考试 参加班级的ID',
  `groupid` int(11) DEFAULT NULL COMMENT '固定人群组考试 群组ID',
  `nativeplace` varchar(255) DEFAULT NULL COMMENT '籍贯',
  `province` varchar(255) DEFAULT NULL COMMENT '省',
  `city` varchar(255) DEFAULT NULL COMMENT '市',
  `county` varchar(255) DEFAULT NULL COMMENT '县',
  `ismember` tinyint(1) DEFAULT '2' COMMENT '是否是会员  1 是会员 2不是',
  `password` varchar(255) DEFAULT NULL COMMENT '用户登录密码',
  `member_endtime` varchar(255) DEFAULT NULL COMMENT '会员到期时间 ',
  `status` tinyint(1) DEFAULT '1' COMMENT '是否拉黑 ',
  `last_login_time` int(11) NOT NULL COMMENT '最近一次登录时间',
  `integral` int(11) DEFAULT '0' COMMENT '用户积分数',
  `balance` decimal(8,2) DEFAULT '0.00' COMMENT '用户余额',
  `qrcode` varchar(255) DEFAULT NULL COMMENT '用户二维码路径',
  `pid` int(11) DEFAULT '0' COMMENT '用户自己注册 为0  扫描其他人二维码 为二维码人的ID',
  `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识',
  `createtime` int(11) NOT NULL COMMENT '创建时间',
  `id_card` varchar(255) DEFAULT NULL COMMENT '身份证号',
  `student_id` varchar(200) DEFAULT NULL COMMENT '学号',
  `school` varchar(255) DEFAULT NULL COMMENT '学校',
  `level` int(11) DEFAULT '0' COMMENT '用户等级',
  `grade` varchar(255) DEFAULT NULL COMMENT '年级',
  `count_day` int(11) DEFAULT '0' COMMENT '累计天数',
  `is_band` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否绑定微信 1是0否',
  `h5_openid` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`),
  KEY `idx_openid` (`openid`),
  KEY `idx_unionid` (`unionid`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='用户信息表';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_user_collection_praction` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `uid` int(11) NOT NULL COMMENT '用户ID',
  `testid` int(11) NOT NULL COMMENT '试题ID',
  `test_type` tinyint(1) NOT NULL COMMENT '试题类型',
  `istatus` tinyint(1) DEFAULT '1' COMMENT '删除状态',
  `createtime` int(11) NOT NULL COMMENT '创建时间',
  `iscollect` int(11) DEFAULT '2',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`),
  KEY `idx_uid` (`uid`),
  KEY `idx_testid` (`testid`),
  KEY `idx_test_type` (`test_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='收藏';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_user_doexam` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `uid` int(11) NOT NULL COMMENT '用户ID',
  `examid` int(11) NOT NULL COMMENT '已发布的试卷  考试 或练习的ID',
  `franction` int(11) DEFAULT '0' COMMENT '得分情况',
  `usetime` varchar(20) DEFAULT '0' COMMENT '考试用时',
  `level` varchar(255) DEFAULT NULL,
  `istatus` tinyint(1) DEFAULT '1' COMMENT '删除状态',
  `createtime` int(11) NOT NULL COMMENT '交卷时间',
  `recordid` int(11) NOT NULL COMMENT '考试记录id',
  `evaluation` tinyint(1) NOT NULL DEFAULT '2' COMMENT '1已评2未评默认2 3批改中',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`),
  KEY `idx_uid` (`uid`),
  KEY `idx_examid` (`examid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户参加全真考试表';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_user_doother_exam` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `uid` int(11) NOT NULL COMMENT '用户ID',
  `recordid` int(11) NOT NULL COMMENT '区分是哪一次考试',
  `franction` int(11) DEFAULT '0' COMMENT '得分情况',
  `usetime` varchar(20) DEFAULT '0' COMMENT '考试用时',
  `level` varchar(255) DEFAULT NULL,
  `istatus` tinyint(1) DEFAULT '1' COMMENT '删除状态',
  `createtime` int(11) NOT NULL COMMENT '交卷时间',
  `type` tinyint(1) DEFAULT NULL COMMENT '类型2-优先未做3-智能考试',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`),
  KEY `idx_uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户参加其他考试表';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_user_doother_exam_answer` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `uid` int(11) NOT NULL COMMENT '用户ID',
  `recordid` int(11) NOT NULL COMMENT '区分是哪一次考试',
  `testid` int(11) NOT NULL COMMENT '试题id',
  `test_type` tinyint(1) NOT NULL COMMENT '试题类型',
  `uanswer` text COMMENT '用户答案',
  `franction` int(11) DEFAULT '0' COMMENT '得分情况',
  `isright` tinyint(1) NOT NULL COMMENT '是否正确',
  `ischeck` tinyint(1) DEFAULT '1' COMMENT '是否批改 默认为已批该',
  `istatus` tinyint(1) DEFAULT '1' COMMENT '删除状态',
  `createtime` int(11) NOT NULL COMMENT '创建时间',
  `type` int(1) DEFAULT NULL COMMENT '类型2-优先未做3-智能考试',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户其他考试答题记录表';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_user_exam_answer` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `uid` int(11) NOT NULL COMMENT '用户ID',
  `examid` int(11) NOT NULL COMMENT '已发布的试卷  考试 或练习的ID',
  `testid` int(11) NOT NULL COMMENT '试题id',
  `test_type` tinyint(1) NOT NULL COMMENT '试题类型',
  `uanswer` text COMMENT '用户答案',
  `franction` int(11) DEFAULT '0' COMMENT '得分情况',
  `isright` tinyint(1) NOT NULL COMMENT '是否正确',
  `ischeck` tinyint(1) DEFAULT '1' COMMENT '是否批改 默认为已批该',
  `istatus` tinyint(1) DEFAULT '1' COMMENT '删除状态',
  `createtime` int(11) NOT NULL COMMENT '创建时间',
  `recordid` int(11) DEFAULT NULL COMMENT '考试记录id',
  `type` int(1) DEFAULT NULL COMMENT '类型只有1-全真',
  `simple_score` int(8) DEFAULT NULL COMMENT '简答题评分',
  `comments` text NOT NULL COMMENT '简答题评语',
  `simple_evaluation` tinyint(1) NOT NULL DEFAULT '2' COMMENT '1已批改默认2未3批改中',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户参加全真考试表';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_user_formid` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `uid` int(11) NOT NULL COMMENT '用户ID',
  `formid` varchar(255) NOT NULL,
  `istatus` tinyint(1) DEFAULT '1' COMMENT '删除状态',
  `createtime` int(11) NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`),
  KEY `idx_uid` (`uid`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='formid表';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_user_gift` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `giftid` int(11) NOT NULL,
  `createtime` int(11) NOT NULL,
  `status` tinyint(2) DEFAULT '0',
  `updatetime` int(11) DEFAULT NULL,
  `consignee_name` varchar(255) DEFAULT NULL COMMENT '收货人姓名',
  `consignee_phone` varchar(255) DEFAULT NULL COMMENT '收货人电话',
  `consignee_address` varchar(255) DEFAULT NULL COMMENT '收货人地址',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`),
  KEY `idx_uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_user_knowledge_cate` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户id',
  `cate` int(11) DEFAULT '0' COMMENT '知识点id',
  `createtime` int(11) NOT NULL COMMENT '创建时间',
  `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户知识点库';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_user_member` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `status` tinyint(1) DEFAULT '2' COMMENT '是否开启购买会员',
  `scale` decimal(8,2) DEFAULT '1.00' COMMENT '折扣比例',
  `info` text COMMENT '详细信息',
  `price` decimal(8,2) DEFAULT '0.00' COMMENT 'VIP单月价格',
  `istui` int(11) DEFAULT '0' COMMENT '推荐购买的',
  `istatus` tinyint(1) DEFAULT '1' COMMENT '删除状态',
  `createtime` int(11) NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='会员设置表';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_user_pool` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户id',
  `poolid` int(11) DEFAULT '0' COMMENT '题库id',
  `createtime` int(11) NOT NULL COMMENT '创建时间',
  `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识',
  `paperid` int(11) NOT NULL DEFAULT '0' COMMENT '试卷id',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户题库';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_user_qhigh` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `user_id` int(11) NOT NULL COMMENT '用户ID',
  `question_id` int(11) NOT NULL COMMENT '试题ID',
  `istatus` tinyint(1) DEFAULT '1' COMMENT '删除状态',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='记录高频上次退出的题id';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_user_qintensive` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `user_id` int(11) NOT NULL COMMENT '用户ID',
  `question_id` int(11) NOT NULL COMMENT '试题ID',
  `istatus` tinyint(1) DEFAULT '1' COMMENT '删除状态',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='记录精编上次退出的题id';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_user_qtype` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `weid` int(11) DEFAULT '0',
  `uid` int(11) NOT NULL,
  `type_id` int(11) NOT NULL,
  `last_id` int(11) DEFAULT NULL,
  `istatus` tinyint(2) DEFAULT '1',
  `createtime` int(11) DEFAULT NULL COMMENT '时间',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='记录题型退出时题下标';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_user_read` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `uid` int(11) NOT NULL COMMENT '用户ID',
  `noticeid` int(11) NOT NULL COMMENT '公告 活动 文章 ID',
  `istatus` tinyint(1) DEFAULT '1' COMMENT '删除状态',
  `createtime` int(11) NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='用户阅读公告 文章 活动表';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_user_special` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `weid` int(11) DEFAULT '0',
  `uid` int(11) NOT NULL,
  `special_id` int(11) NOT NULL,
  `last_id` int(11) DEFAULT NULL,
  `istatus` tinyint(2) DEFAULT '1',
  `createtime` int(11) DEFAULT NULL COMMENT '时间',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='记录知识点退出时题下标';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_user_spequence` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `user_id` int(11) NOT NULL COMMENT '用户ID',
  `question_id` int(11) NOT NULL COMMENT '下标ID',
  `istatus` tinyint(1) DEFAULT '1' COMMENT '删除状态',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='记录顺序上次退出的下标id';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_user_wrong_praction` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `uid` int(11) NOT NULL COMMENT '用户ID',
  `testid` int(11) NOT NULL COMMENT '试题ID',
  `test_type` tinyint(1) NOT NULL COMMENT '试题类型',
  `uanswer` text COMMENT '用户答案',
  `istatus` tinyint(1) DEFAULT '1' COMMENT '删除状态',
  `createtime` int(11) NOT NULL COMMENT '创建时间',
  `iscollect` int(11) DEFAULT '2',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`),
  KEY `idx_uid` (`uid`),
  KEY `idx_testid` (`testid`),
  KEY `idx_test_type` (`test_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='错题集,错题收藏';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_watermark` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `type` tinyint(1) NOT NULL COMMENT '1个人信息 2为自定义',
  `open` tinyint(1) NOT NULL DEFAULT '2' COMMENT '1打开水印 2关闭水印',
  `content` varchar(1024) NOT NULL COMMENT '水印内容',
  `size` int(11) NOT NULL COMMENT '字体大小',
  `rotate` int(11) NOT NULL COMMENT '旋转度数',
  `transparent` int(11) NOT NULL COMMENT '透明度',
  `local_type` tinyint(1) NOT NULL COMMENT '1预设 2为自定义 生效位置类型',
  `presupposition` tinyint(1) NOT NULL COMMENT '预设类型',
  `horizontal` int(11) NOT NULL COMMENT '水平距离',
  `vertical` int(11) NOT NULL COMMENT '垂直距离',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='水印配置表';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_wxtpl` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `tplid` varchar(255) NOT NULL,
  `keyword1` varchar(255) DEFAULT NULL,
  `keyword2` varchar(255) DEFAULT NULL,
  `keyword3` varchar(255) DEFAULT NULL,
  `istatus` tinyint(1) DEFAULT '1' COMMENT '删除状态',
  `createtime` int(11) NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_weid` (`weid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='模板消息表';


CREATE TABLE IF NOT EXISTS `ims_goouc_fullexam_xuesheng` (
  `xuesheng_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `weid` int(10) unsigned NOT NULL,
  `uidht` int(10) unsigned NOT NULL,
  `school_id` int(10) unsigned NOT NULL,
  `nianfen_id` int(10) unsigned NOT NULL,
  `banji_id` int(10) unsigned NOT NULL,
  `banjixs_id` int(10) unsigned NOT NULL,
  `xiaozu_id` int(10) unsigned NOT NULL,
  `xiaozuxs_id` int(10) unsigned NOT NULL,
  `sflx` int(10) unsigned NOT NULL,
  `bjcsjf` float(13,2) NOT NULL DEFAULT '0.00',
  `bjzf` float(13,2) NOT NULL DEFAULT '0.00',
  `displayorder` tinyint(3) unsigned NOT NULL,
  `student_name` char(20) DEFAULT NULL,
  `pic` text NOT NULL,
  `sex` text NOT NULL,
  `jiguan` text NOT NULL,
  `minzu` text NOT NULL,
  `sfzhm` text NOT NULL,
  `gxuehao` char(25) DEFAULT NULL,
  `xxuehao` char(25) DEFAULT NULL,
  `zxxuehao` char(25) DEFAULT NULL,
  `student_img` char(60) DEFAULT NULL,
  `parent_name` char(20) DEFAULT NULL,
  `parent_phone` char(20) DEFAULT NULL,
  `qq` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `yzm` varchar(225) NOT NULL,
  `address` varchar(255) DEFAULT NULL,
  `updatetime` int(11) NOT NULL,
  `beizhu` text NOT NULL,
  `addtime` int(11) NOT NULL,
  `uid` int(11) unsigned DEFAULT '0',
  `uid1` int(11) unsigned DEFAULT '0',
  `uid2` int(11) unsigned DEFAULT '0',
  `uid3` int(11) unsigned DEFAULT '0',
  `uid4` int(11) unsigned DEFAULT '0',
  `uid5` int(11) unsigned DEFAULT '0',
  `uid6` int(11) unsigned DEFAULT '0',
  `uid7` int(11) unsigned DEFAULT '0',
  `uid8` int(11) unsigned DEFAULT '0',
  `openid` varchar(255) NOT NULL,
  `openid1` varchar(255) NOT NULL,
  `openid2` varchar(255) NOT NULL,
  `openid3` varchar(255) NOT NULL,
  `openid4` varchar(255) NOT NULL,
  `openid5` varchar(255) NOT NULL,
  `openid6` varchar(255) NOT NULL,
  `openid7` varchar(255) NOT NULL,
  `openid8` varchar(255) NOT NULL,
  `sflx1` int(10) unsigned NOT NULL,
  `sflx2` int(10) unsigned NOT NULL,
  `sflx3` int(10) unsigned NOT NULL,
  `sflx4` int(10) unsigned NOT NULL,
  `sflx5` int(10) unsigned NOT NULL,
  `sflx6` int(10) unsigned NOT NULL,
  `sflx7` int(10) unsigned NOT NULL,
  `sflx8` int(10) unsigned NOT NULL,
  `nid` int(10) unsigned NOT NULL,
  `name` varchar(50) NOT NULL,
  `parentid` int(10) unsigned NOT NULL,
  `enabled` tinyint(1) unsigned NOT NULL,
  `icon` varchar(100) NOT NULL,
  `description` varchar(100) NOT NULL,
  `styleid` int(10) unsigned NOT NULL,
  `linkurl` varchar(500) NOT NULL,
  `ishomepage` tinyint(1) NOT NULL,
  `icontype` tinyint(1) unsigned NOT NULL,
  `css` varchar(500) NOT NULL,
  PRIMARY KEY (`xuesheng_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

";
pdo_run($sql);
if(!pdo_fieldexists("goouc_fullexam_admin", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_admin")." ADD `id` mediumint(8) NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_admin", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_admin")." ADD `weid` varchar(150) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_admin", "username")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_admin")." ADD `username` varchar(255) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_admin", "password")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_admin")." ADD `password` varchar(255) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_admin", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_admin")." ADD `createtime` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_admin", "logintime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_admin")." ADD `logintime` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_admin", "is_delete")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_admin")." ADD `is_delete` tinyint(11) NOT NULL DEFAULT '1' COMMENT '0正常 1禁用';");
}
if(!pdo_fieldexists("goouc_fullexam_admin", "pcate_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_admin")." ADD `pcate_id` int(8) NOT NULL COMMENT '一级类目id';");
}
if(!pdo_fieldexists("goouc_fullexam_admin", "cate_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_admin")." ADD `cate_id` int(8) NOT NULL COMMENT '二级级类目id';");
}
if(!pdo_fieldexists("goouc_fullexam_admin", "relation_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_admin")." ADD `relation_id` text NOT NULL COMMENT '关联试卷ID';");
}
if(!pdo_fieldexists("goouc_fullexam_advert", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_advert")." ADD `id` int(11) NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_advert", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_advert")." ADD `weid` int(11) DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_advert", "homeId")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_advert")." ADD `homeId` varchar(255) COMMENT '首页广告id';");
}
if(!pdo_fieldexists("goouc_fullexam_advert", "secondId")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_advert")." ADD `secondId` varchar(255) COMMENT '解析页广告id';");
}
if(!pdo_fieldexists("goouc_fullexam_advert", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_advert")." ADD `createtime` int(11) COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_banji", "banji_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banji")." ADD `banji_id` int(10) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_banji", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banji")." ADD `weid` int(10) unsigned;");
}
if(!pdo_fieldexists("goouc_fullexam_banji", "uidht")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banji")." ADD `uidht` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_banji", "school_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banji")." ADD `school_id` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_banji", "nianfen_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banji")." ADD `nianfen_id` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_banji", "xdgl_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banji")." ADD `xdgl_id` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_banji", "nid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banji")." ADD `nid` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_banji", "name")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banji")." ADD `name` varchar(50) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_banji", "bname")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banji")." ADD `bname` varchar(50) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_banji", "parentid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banji")." ADD `parentid` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_banji", "displayorder")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banji")." ADD `displayorder` tinyint(3) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_banji", "enabled")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banji")." ADD `enabled` tinyint(1) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_banji", "icon")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banji")." ADD `icon` varchar(100) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_banji", "banjikouhao")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banji")." ADD `banjikouhao` varchar(100) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_banji", "banxun")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banji")." ADD `banxun` varchar(100) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_banji", "banjimubiao")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banji")." ADD `banjimubiao` varchar(100) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_banji", "bzrjy")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banji")." ADD `bzrjy` varchar(200) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_banji", "description")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banji")." ADD `description` varchar(200) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_banji", "styleid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banji")." ADD `styleid` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_banji", "linkurl")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banji")." ADD `linkurl` varchar(500) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_banji", "ishomepage")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banji")." ADD `ishomepage` tinyint(1) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_banji", "status")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banji")." ADD `status` int(11) DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_banji", "icontype")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banji")." ADD `icontype` tinyint(1) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_banji", "css")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banji")." ADD `css` varchar(500) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_banner", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banner")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_banner", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banner")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_banner", "title")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banner")." ADD `title` varchar(255) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_banner", "image")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banner")." ADD `image` varchar(255) NOT NULL COMMENT '图片路径 ';");
}
if(!pdo_fieldexists("goouc_fullexam_banner", "type")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banner")." ADD `type` tinyint(1) DEFAULT '1' COMMENT '图片跳转方式 1本程序跳转  2外部链接 ';");
}
if(!pdo_fieldexists("goouc_fullexam_banner", "link")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banner")." ADD `link` text COMMENT '链接';");
}
if(!pdo_fieldexists("goouc_fullexam_banner", "status")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banner")." ADD `status` tinyint(1) DEFAULT '2' COMMENT '图片状态 1 显示 2 不显示';");
}
if(!pdo_fieldexists("goouc_fullexam_banner", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banner")." ADD `createtime` int(11) NOT NULL COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_banner", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_banner")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识';");
}
if(!pdo_fieldexists("goouc_fullexam_category", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_category")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_category", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_category")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_category", "name")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_category")." ADD `name` varchar(255) NOT NULL COMMENT '分类名称';");
}
if(!pdo_fieldexists("goouc_fullexam_category", "pid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_category")." ADD `pid` varchar(255) DEFAULT '0' COMMENT '分类父级 默认为顶级分类';");
}
if(!pdo_fieldexists("goouc_fullexam_category", "order")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_category")." ADD `order` int(5) DEFAULT '0' COMMENT '分类序号  默认为0';");
}
if(!pdo_fieldexists("goouc_fullexam_category", "status")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_category")." ADD `status` tinyint(1) DEFAULT '1' COMMENT '分类核状态 1 显示 2不显示';");
}
if(!pdo_fieldexists("goouc_fullexam_category", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_category")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识';");
}
if(!pdo_fieldexists("goouc_fullexam_category", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_category")." ADD `createtime` int(11) NOT NULL COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_cdkey", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_cdkey")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_cdkey", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_cdkey")." ADD `weid` int(11) NOT NULL DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_cdkey", "cid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_cdkey")." ADD `cid` int(11) NOT NULL DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_cdkey", "code")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_cdkey")." ADD `code` varchar(255) COMMENT '题库';");
}
if(!pdo_fieldexists("goouc_fullexam_cdkey", "uid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_cdkey")." ADD `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户id 0未领取';");
}
if(!pdo_fieldexists("goouc_fullexam_cdkey", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_cdkey")." ADD `createtime` int(11) COMMENT '时间';");
}
if(!pdo_fieldexists("goouc_fullexam_cdkey", "usetime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_cdkey")." ADD `usetime` int(11) COMMENT '时间';");
}
if(!pdo_fieldexists("goouc_fullexam_cdkey", "status")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_cdkey")." ADD `status` tinyint(1) DEFAULT '1' COMMENT '状态 1未使用 2已使用';");
}
if(!pdo_fieldexists("goouc_fullexam_cdkey", "kpool")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_cdkey")." ADD `kpool` varchar(2000) COMMENT '到期时间';");
}
if(!pdo_fieldexists("goouc_fullexam_cdkey", "display")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_cdkey")." ADD `display` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1启用 2作废';");
}
if(!pdo_fieldexists("goouc_fullexam_cdkey_cate", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_cdkey_cate")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_cdkey_cate", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_cdkey_cate")." ADD `weid` int(11) NOT NULL DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_cdkey_cate", "title")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_cdkey_cate")." ADD `title` varchar(255) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_cdkey_cate", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_cdkey_cate")." ADD `createtime` int(11) COMMENT '时间';");
}
if(!pdo_fieldexists("goouc_fullexam_cdkey_cate", "qpool")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_cdkey_cate")." ADD `qpool` varchar(2000) COMMENT '题库';");
}
if(!pdo_fieldexists("goouc_fullexam_cdkey_cate", "kpool")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_cdkey_cate")." ADD `kpool` varchar(2000) COMMENT '知识库';");
}
if(!pdo_fieldexists("goouc_fullexam_cdkey_cate", "msg")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_cdkey_cate")." ADD `msg` varchar(255) COMMENT '提示信息';");
}
if(!pdo_fieldexists("goouc_fullexam_cdkey_cate", "status")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_cdkey_cate")." ADD `status` tinyint(1) DEFAULT '1' COMMENT '状态 1启用 2禁用';");
}
if(!pdo_fieldexists("goouc_fullexam_cdkey_cate", "is_delete")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_cdkey_cate")." ADD `is_delete` tinyint(1) DEFAULT '1' COMMENT '状态 1正常 2删除';");
}
if(!pdo_fieldexists("goouc_fullexam_cdkey_cate", "papers")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_cdkey_cate")." ADD `papers` varchar(2000) NOT NULL COMMENT '试卷ids';");
}
if(!pdo_fieldexists("goouc_fullexam_cdkeys", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_cdkeys")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_cdkeys", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_cdkeys")." ADD `weid` int(11) NOT NULL DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_cdkeys", "code_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_cdkeys")." ADD `code_id` int(11) NOT NULL DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_cdkeys", "kpool_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_cdkeys")." ADD `kpool_id` int(11) NOT NULL DEFAULT '0' COMMENT '绑定';");
}
if(!pdo_fieldexists("goouc_fullexam_cdkeys", "type")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_cdkeys")." ADD `type` tinyint(11) NOT NULL DEFAULT '0' COMMENT '绑定类型 1 试卷 2题库';");
}
if(!pdo_fieldexists("goouc_fullexam_exercise", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_exercise")." ADD `id` int(11) NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_exercise", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_exercise")." ADD `weid` int(11) DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_exercise", "uid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_exercise")." ADD `uid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_exercise", "testid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_exercise")." ADD `testid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_exercise", "test_type")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_exercise")." ADD `test_type` int(11);");
}
if(!pdo_fieldexists("goouc_fullexam_exercise", "uanswer")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_exercise")." ADD `uanswer` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_exercise", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_exercise")." ADD `istatus` tinyint(2) DEFAULT '1';");
}
if(!pdo_fieldexists("goouc_fullexam_exercise", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_exercise")." ADD `createtime` int(11) COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_exercise", "isright")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_exercise")." ADD `isright` tinyint(1) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_feedback", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_feedback")." ADD `id` int(11) NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_feedback", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_feedback")." ADD `weid` int(11) DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_feedback", "uid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_feedback")." ADD `uid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_feedback", "testid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_feedback")." ADD `testid` int(11);");
}
if(!pdo_fieldexists("goouc_fullexam_feedback", "relation")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_feedback")." ADD `relation` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_feedback", "content")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_feedback")." ADD `content` text;");
}
if(!pdo_fieldexists("goouc_fullexam_feedback", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_feedback")." ADD `istatus` tinyint(2) DEFAULT '1';");
}
if(!pdo_fieldexists("goouc_fullexam_feedback", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_feedback")." ADD `createtime` int(11) COMMENT '时间';");
}
if(!pdo_fieldexists("goouc_fullexam_gift", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_gift")." ADD `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '礼品id';");
}
if(!pdo_fieldexists("goouc_fullexam_gift", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_gift")." ADD `weid` int(11) unsigned NOT NULL DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_gift", "name")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_gift")." ADD `name` varchar(100) NOT NULL COMMENT '礼品名称';");
}
if(!pdo_fieldexists("goouc_fullexam_gift", "price")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_gift")." ADD `price` int(11) NOT NULL DEFAULT '100' COMMENT '礼品市场价格';");
}
if(!pdo_fieldexists("goouc_fullexam_gift", "coins")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_gift")." ADD `coins` int(11) NOT NULL DEFAULT '500' COMMENT '礼品所需金币';");
}
if(!pdo_fieldexists("goouc_fullexam_gift", "image")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_gift")." ADD `image` varchar(255) NOT NULL COMMENT '礼品图片';");
}
if(!pdo_fieldexists("goouc_fullexam_gift", "about")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_gift")." ADD `about` text NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_index_btn", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_index_btn")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_index_btn", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_index_btn")." ADD `weid` int(11) NOT NULL DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_index_btn", "doid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_index_btn")." ADD `doid` int(11) NOT NULL DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_index_btn", "title")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_index_btn")." ADD `title` varchar(255) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_index_btn", "icon")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_index_btn")." ADD `icon` varchar(255) COMMENT '图片路径 ';");
}
if(!pdo_fieldexists("goouc_fullexam_index_btn", "status")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_index_btn")." ADD `status` tinyint(1) DEFAULT '1' COMMENT '图片状态 1 显示 2 不显示';");
}
if(!pdo_fieldexists("goouc_fullexam_index_btn", "sort")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_index_btn")." ADD `sort` int(11) DEFAULT '0' COMMENT '排序';");
}
if(!pdo_fieldexists("goouc_fullexam_index_btn", "types")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_index_btn")." ADD `types` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1模块功能 2题库';");
}
if(!pdo_fieldexists("goouc_fullexam_index_btn", "library_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_index_btn")." ADD `library_id` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_knowledge", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_knowledge")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_knowledge", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_knowledge")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_knowledge", "one")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_knowledge")." ADD `one` int(11) DEFAULT '0' COMMENT '分类1';");
}
if(!pdo_fieldexists("goouc_fullexam_knowledge", "two")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_knowledge")." ADD `two` int(11) DEFAULT '0' COMMENT '分类2';");
}
if(!pdo_fieldexists("goouc_fullexam_knowledge", "three")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_knowledge")." ADD `three` int(11) DEFAULT '0' COMMENT '分类3';");
}
if(!pdo_fieldexists("goouc_fullexam_knowledge", "title")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_knowledge")." ADD `title` varchar(255) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_knowledge", "content")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_knowledge")." ADD `content` text NOT NULL COMMENT '公告内容 ';");
}
if(!pdo_fieldexists("goouc_fullexam_knowledge", "status")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_knowledge")." ADD `status` tinyint(1) DEFAULT '2' COMMENT '状态 1显示 2不显示';");
}
if(!pdo_fieldexists("goouc_fullexam_knowledge", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_knowledge")." ADD `createtime` int(11) NOT NULL COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_knowledge", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_knowledge")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识';");
}
if(!pdo_fieldexists("goouc_fullexam_knowledge_cate", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_knowledge_cate")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_knowledge_cate", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_knowledge_cate")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_knowledge_cate", "name")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_knowledge_cate")." ADD `name` varchar(255) NOT NULL COMMENT '知识点名称';");
}
if(!pdo_fieldexists("goouc_fullexam_knowledge_cate", "type")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_knowledge_cate")." ADD `type` int(11) DEFAULT '1' COMMENT '分类 1刷知识点 2考前必备';");
}
if(!pdo_fieldexists("goouc_fullexam_knowledge_cate", "pid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_knowledge_cate")." ADD `pid` int(11) DEFAULT '0' COMMENT '默认0为顶级分类';");
}
if(!pdo_fieldexists("goouc_fullexam_knowledge_cate", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_knowledge_cate")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识';");
}
if(!pdo_fieldexists("goouc_fullexam_knowledge_cate", "status")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_knowledge_cate")." ADD `status` tinyint(1) DEFAULT '1' COMMENT '显示隐藏';");
}
if(!pdo_fieldexists("goouc_fullexam_knowledge_cate", "price")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_knowledge_cate")." ADD `price` decimal(10,2) DEFAULT '0.00';");
}
if(!pdo_fieldexists("goouc_fullexam_knowledge_cate", "create_time")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_knowledge_cate")." ADD `create_time` int(11) NOT NULL COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_notice", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_notice")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_notice", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_notice")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_notice", "type")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_notice")." ADD `type` tinyint(1) NOT NULL COMMENT '公告类型';");
}
if(!pdo_fieldexists("goouc_fullexam_notice", "title")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_notice")." ADD `title` varchar(255) NOT NULL COMMENT '公告标题';");
}
if(!pdo_fieldexists("goouc_fullexam_notice", "content")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_notice")." ADD `content` text NOT NULL COMMENT '公告内容 ';");
}
if(!pdo_fieldexists("goouc_fullexam_notice", "image")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_notice")." ADD `image` varchar(255) COMMENT '活动公告的图片';");
}
if(!pdo_fieldexists("goouc_fullexam_notice", "readnum")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_notice")." ADD `readnum` int(11) DEFAULT '0' COMMENT '阅读量';");
}
if(!pdo_fieldexists("goouc_fullexam_notice", "status")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_notice")." ADD `status` tinyint(1) DEFAULT '2' COMMENT '公告状态 1 显示 2 不显示';");
}
if(!pdo_fieldexists("goouc_fullexam_notice", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_notice")." ADD `createtime` int(11) NOT NULL COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_notice", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_notice")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识';");
}
if(!pdo_fieldexists("goouc_fullexam_notice", "video_audio_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_notice")." ADD `video_audio_id` varchar(255) COMMENT '音/视频ID';");
}
if(!pdo_fieldexists("goouc_fullexam_notice", "pcate")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_notice")." ADD `pcate` int(11) COMMENT '文章所属分类';");
}
if(!pdo_fieldexists("goouc_fullexam_notice", "ccate")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_notice")." ADD `ccate` int(11) COMMENT '文章所属子分类';");
}
if(!pdo_fieldexists("goouc_fullexam_notice", "article_type")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_notice")." ADD `article_type` tinyint(1) COMMENT '文章的类型1文章2视频';");
}
if(!pdo_fieldexists("goouc_fullexam_order", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_order")." ADD `id` int(11) NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_order", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_order")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_order", "type")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_order")." ADD `type` int(11) NOT NULL COMMENT '购买类型 1购买考试 2VIP购买 ';");
}
if(!pdo_fieldexists("goouc_fullexam_order", "out_trade_no")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_order")." ADD `out_trade_no` varchar(255) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_order", "userid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_order")." ADD `userid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_order", "openid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_order")." ADD `openid` varchar(255) COMMENT '购买者的openid';");
}
if(!pdo_fieldexists("goouc_fullexam_order", "order_status")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_order")." ADD `order_status` tinyint(1) NOT NULL COMMENT '订单状态 0未支付1已支付';");
}
if(!pdo_fieldexists("goouc_fullexam_order", "all_money")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_order")." ADD `all_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '总金额';");
}
if(!pdo_fieldexists("goouc_fullexam_order", "true_money")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_order")." ADD `true_money` decimal(10,2) NOT NULL COMMENT '实付款';");
}
if(!pdo_fieldexists("goouc_fullexam_order", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_order")." ADD `createtime` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_order", "paytime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_order")." ADD `paytime` int(11);");
}
if(!pdo_fieldexists("goouc_fullexam_order", "msg")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_order")." ADD `msg` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_order", "dataid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_order")." ADD `dataid` int(11);");
}
if(!pdo_fieldexists("goouc_fullexam_order", "transaction_sn")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_order")." ADD `transaction_sn` varchar(255) COMMENT '第三方流水号';");
}
if(!pdo_fieldexists("goouc_fullexam_order", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_order")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '订单删除标识';");
}
if(!pdo_fieldexists("goouc_fullexam_paper", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_paper")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_paper", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_paper")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_paper", "title")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_paper")." ADD `title` varchar(255) NOT NULL COMMENT '试卷标题';");
}
if(!pdo_fieldexists("goouc_fullexam_paper", "type")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_paper")." ADD `type` tinyint(1) DEFAULT '1' COMMENT '试卷类型';");
}
if(!pdo_fieldexists("goouc_fullexam_paper", "franction")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_paper")." ADD `franction` text NOT NULL COMMENT '每个题型有多少  每个题多少分';");
}
if(!pdo_fieldexists("goouc_fullexam_paper", "total_franction")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_paper")." ADD `total_franction` int(4) DEFAULT '0' COMMENT '试卷总分值';");
}
if(!pdo_fieldexists("goouc_fullexam_paper", "status")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_paper")." ADD `status` int(1) DEFAULT '2' COMMENT '试卷状态 默认为2 待完善试卷 1 已完善试卷';");
}
if(!pdo_fieldexists("goouc_fullexam_paper", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_paper")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识';");
}
if(!pdo_fieldexists("goouc_fullexam_paper", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_paper")." ADD `createtime` int(11) NOT NULL COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_paper", "dnum")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_paper")." ADD `dnum` int(11) DEFAULT '0' COMMENT '做题人数';");
}
if(!pdo_fieldexists("goouc_fullexam_paper", "displayorder")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_paper")." ADD `displayorder` int(10) DEFAULT '0' COMMENT '显示顺序';");
}
if(!pdo_fieldexists("goouc_fullexam_paper", "price")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_paper")." ADD `price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '试卷价格默认0';");
}
if(!pdo_fieldexists("goouc_fullexam_paper", "times")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_paper")." ADD `times` int(8) NOT NULL COMMENT '试卷时间单位分';");
}
if(!pdo_fieldexists("goouc_fullexam_paper", "is_repeat")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_paper")." ADD `is_repeat` tinyint(1) NOT NULL DEFAULT '2' COMMENT '重复答题 1可以 2否';");
}
if(!pdo_fieldexists("goouc_fullexam_paper_test", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_paper_test")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_paper_test", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_paper_test")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_paper_test", "paperid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_paper_test")." ADD `paperid` varchar(255) NOT NULL COMMENT '试卷标题';");
}
if(!pdo_fieldexists("goouc_fullexam_paper_test", "testid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_paper_test")." ADD `testid` int(11) NOT NULL COMMENT '试题ID';");
}
if(!pdo_fieldexists("goouc_fullexam_paper_test", "test_type")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_paper_test")." ADD `test_type` int(11) NOT NULL COMMENT '题型类型';");
}
if(!pdo_fieldexists("goouc_fullexam_paper_test", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_paper_test")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识';");
}
if(!pdo_fieldexists("goouc_fullexam_paper_test", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_paper_test")." ADD `createtime` int(11) NOT NULL COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_phonecode", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_phonecode")." ADD `id` int(11) NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_phonecode", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_phonecode")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_phonecode", "phone")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_phonecode")." ADD `phone` varchar(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_phonecode", "code")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_phonecode")." ADD `code` int(11) NOT NULL COMMENT '手机验证码';");
}
if(!pdo_fieldexists("goouc_fullexam_phonecode", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_phonecode")." ADD `createtime` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_q_year", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_q_year")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_q_year", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_q_year")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_q_year", "name")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_q_year")." ADD `name` varchar(255) NOT NULL COMMENT '年份名称';");
}
if(!pdo_fieldexists("goouc_fullexam_q_year", "status")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_q_year")." ADD `status` tinyint(1) DEFAULT '1' COMMENT '状态 1 显示 2不显示';");
}
if(!pdo_fieldexists("goouc_fullexam_q_year", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_q_year")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识';");
}
if(!pdo_fieldexists("goouc_fullexam_q_year", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_q_year")." ADD `createtime` int(11) NOT NULL COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_school", "school_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_school")." ADD `school_id` int(11) NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_school", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_school")." ADD `weid` int(11);");
}
if(!pdo_fieldexists("goouc_fullexam_school", "school_name")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_school")." ADD `school_name` varchar(200);");
}
if(!pdo_fieldexists("goouc_fullexam_school", "school_logo")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_school")." ADD `school_logo` varchar(200);");
}
if(!pdo_fieldexists("goouc_fullexam_school", "school_info_intro")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_school")." ADD `school_info_intro` text COMMENT '学校描述';");
}
if(!pdo_fieldexists("goouc_fullexam_school", "addtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_school")." ADD `addtime` int(11);");
}
if(!pdo_fieldexists("goouc_fullexam_school", "mu_str")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_school")." ADD `mu_str` varchar(30);");
}
if(!pdo_fieldexists("goouc_fullexam_school", "status")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_school")." ADD `status` tinyint(1) DEFAULT '1';");
}
if(!pdo_fieldexists("goouc_fullexam_school", "line_status")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_school")." ADD `line_status` tinyint(1) DEFAULT '1';");
}
if(!pdo_fieldexists("goouc_fullexam_school", "cookbook_status")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_school")." ADD `cookbook_status` tinyint(1) DEFAULT '1';");
}
if(!pdo_fieldexists("goouc_fullexam_school", "class_notice_status")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_school")." ADD `class_notice_status` tinyint(1) DEFAULT '1' COMMENT '班级公告是否需要审核；1=》不需要；2=》需要';");
}
if(!pdo_fieldexists("goouc_fullexam_school", "school_type")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_school")." ADD `school_type` tinyint(1) DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_school", "host_url")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_school")." ADD `host_url` text COMMENT '官网地址';");
}
if(!pdo_fieldexists("goouc_fullexam_school", "on_school")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_school")." ADD `on_school` tinyint(1) unsigned DEFAULT '0' COMMENT '在校天数';");
}
if(!pdo_fieldexists("goouc_fullexam_school", "begin_day")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_school")." ADD `begin_day` tinyint(1) unsigned DEFAULT '0' COMMENT '开始上课周数';");
}
if(!pdo_fieldexists("goouc_fullexam_school", "am_much")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_school")." ADD `am_much` tinyint(1) unsigned DEFAULT '0' COMMENT '上午课数';");
}
if(!pdo_fieldexists("goouc_fullexam_school", "pm_much")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_school")." ADD `pm_much` tinyint(1) unsigned DEFAULT '0' COMMENT '下午课数';");
}
if(!pdo_fieldexists("goouc_fullexam_school", "ye_much")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_school")." ADD `ye_much` tinyint(1) unsigned DEFAULT '0' COMMENT '晚上课数';");
}
if(!pdo_fieldexists("goouc_fullexam_school", "line_type")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_school")." ADD `line_type` text COMMENT '班级圈类别';");
}
if(!pdo_fieldexists("goouc_fullexam_school", "appointment")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_school")." ADD `appointment` text COMMENT '预约类别';");
}
if(!pdo_fieldexists("goouc_fullexam_school", "parents")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_school")." ADD `parents` tinyint(1) DEFAULT '3' COMMENT '学生可绑定家长数';");
}
if(!pdo_fieldexists("goouc_fullexam_school", "add_time")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_school")." ADD `add_time` int(11) unsigned DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "mchid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `mchid` varchar(50) COMMENT '微信支付商户ID';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "pay_secret")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `pay_secret` varchar(50) COMMENT '支付密匙';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "pay_open")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `pay_open` tinyint(1) DEFAULT '0' COMMENT '支付开启 1开启';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "signcertpath")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `signcertpath` varchar(255) COMMENT '商户CERT证书路径';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "signkeypath")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `signkeypath` varchar(255) COMMENT '商户KEY证书路径';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "AccessKeyId")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `AccessKeyId` varchar(255) COMMENT '阿里云账号';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "AccessKeySecret")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `AccessKeySecret` varchar(255) COMMENT '阿里云秘钥';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "SignName")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `SignName` varchar(255) COMMENT '阿里云短信签名';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "TemplateCode")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `TemplateCode` varchar(255) COMMENT '阿里云验证码模板id';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "RegionId")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `RegionId` varchar(255) COMMENT '阿里云视频点播区域名';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "banner_height")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `banner_height` int(11) DEFAULT '232' COMMENT '轮播图高';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "shareupper")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `shareupper` int(11) DEFAULT '0' COMMENT '每日分享获得积分上限';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "share_title")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `share_title` varchar(255) COMMENT '分享标题';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "is_display")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `is_display` tinyint(1) DEFAULT '1' COMMENT '公告是否显示';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "display_num")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `display_num` int(11) DEFAULT '5' COMMENT '公告显示条数';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "use_integral_num")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `use_integral_num` int(10) COMMENT '高频题消耗积分个数';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "franction")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `franction` text COMMENT '每个题型有多少每题多少分';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "paper_time")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `paper_time` int(11) COMMENT '考试时长单位(分)';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "reward_integral")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `reward_integral` int(11) COMMENT '答对一题奖励积分数量';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "medal")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `medal` text COMMENT '勋章设置';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "share_integral")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `share_integral` int(11) COMMENT '每次分享可得积分';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "sms_accessKeyId")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `sms_accessKeyId` varchar(255) COMMENT '短信accesskeyid';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "sms_accessKeySecret")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `sms_accessKeySecret` varchar(255) COMMENT '短信accesskeysecret';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "about")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `about` text COMMENT '关于我们';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "wechat_number")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `wechat_number` varchar(255) COMMENT '商家微信号';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "standard")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `standard` int(11) DEFAULT '5' COMMENT '每日答题达标数量';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "pass")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `pass` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "good")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `good` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "excellent")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `excellent` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "randoms")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `randoms` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "randoms_icon")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `randoms_icon` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "randoms_rule")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `randoms_rule` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "notdone")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `notdone` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "notdone_icon")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `notdone_icon` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "notdone_rule")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `notdone_rule` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "qhig")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `qhig` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "qhig_icon")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `qhig_icon` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "qhig_rule")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `qhig_rule` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "qint")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `qint` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "qint_icon")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `qint_icon` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "qint_rule")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `qint_rule` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "qhot")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `qhot` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "qhot_icon")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `qhot_icon` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "qhot_rule")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `qhot_rule` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "qdiff")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `qdiff` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "qdiff_icon")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `qdiff_icon` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "qdiff_rule")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `qdiff_rule` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "countdown")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `countdown` varchar(255) COMMENT '事件名称';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "countdowntime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `countdowntime` datetime COMMENT '时间点';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "time_display")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `time_display` tinyint(1) DEFAULT '1' COMMENT '倒计时显示';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "student_open")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `student_open` tinyint(1) DEFAULT '1' COMMENT '学生开启 1开启';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "freepoolnum")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `freepoolnum` int(11) DEFAULT '0' COMMENT '题库体验题数';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "freeknowledgenum")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `freeknowledgenum` int(11) DEFAULT '0' COMMENT '知识点体验章数';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "info_status")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `info_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否必须完善信息1是';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "app_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `app_id` varchar(50) NOT NULL COMMENT '微信公众公众号Appid';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "app_secret")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `app_secret` varchar(50) NOT NULL COMMENT '微信公众SERECT';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "IOS")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `IOS` tinyint(1) NOT NULL DEFAULT '2' COMMENT '1开启 2关闭';");
}
if(!pdo_fieldexists("goouc_fullexam_setting", "customer_service")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_setting")." ADD `customer_service` varchar(255) NOT NULL COMMENT '客服二维码';");
}
if(!pdo_fieldexists("goouc_fullexam_share_record", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_share_record")." ADD `id` int(11) NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_share_record", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_share_record")." ADD `weid` int(11) DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_share_record", "uid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_share_record")." ADD `uid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_share_record", "num")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_share_record")." ADD `num` int(11);");
}
if(!pdo_fieldexists("goouc_fullexam_share_record", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_share_record")." ADD `istatus` tinyint(2) DEFAULT '1';");
}
if(!pdo_fieldexists("goouc_fullexam_share_record", "day")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_share_record")." ADD `day` date COMMENT '记录哪一天';");
}
if(!pdo_fieldexists("goouc_fullexam_share_record", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_share_record")." ADD `createtime` int(11) COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_son_simple", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_son_simple")." ADD `id` int(11) NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_son_simple", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_son_simple")." ADD `weid` varchar(150) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_son_simple", "son_title")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_son_simple")." ADD `son_title` varchar(255) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_test", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_test", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_test", "type")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `type` tinyint(1) NOT NULL COMMENT '试题类型';");
}
if(!pdo_fieldexists("goouc_fullexam_test", "title")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `title` varchar(255) NOT NULL COMMENT '试题题目 仅在列表显示 试卷内不显示';");
}
if(!pdo_fieldexists("goouc_fullexam_test", "libraryid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `libraryid` int(11) DEFAULT '0' COMMENT '题库id';");
}
if(!pdo_fieldexists("goouc_fullexam_test", "question")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `question` text NOT NULL COMMENT '题目';");
}
if(!pdo_fieldexists("goouc_fullexam_test", "qimage")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `qimage` text COMMENT '试题图片';");
}
if(!pdo_fieldexists("goouc_fullexam_test", "qaudio")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `qaudio` text COMMENT '问题音频';");
}
if(!pdo_fieldexists("goouc_fullexam_test", "a_type")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `a_type` tinyint(1) DEFAULT '0' COMMENT '选项类型';");
}
if(!pdo_fieldexists("goouc_fullexam_test", "option")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `option` text COMMENT '选项';");
}
if(!pdo_fieldexists("goouc_fullexam_test", "rightkey")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `rightkey` text NOT NULL COMMENT '正确答案';");
}
if(!pdo_fieldexists("goouc_fullexam_test", "analysis")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `analysis` text NOT NULL COMMENT '答案解析';");
}
if(!pdo_fieldexists("goouc_fullexam_test", "aimage")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `aimage` text COMMENT '解析图片';");
}
if(!pdo_fieldexists("goouc_fullexam_test", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识';");
}
if(!pdo_fieldexists("goouc_fullexam_test", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `createtime` int(11) NOT NULL COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_test", "anum")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `anum` int(11) DEFAULT '0' COMMENT '本题答题次数 仅考试';");
}
if(!pdo_fieldexists("goouc_fullexam_test", "rnum")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `rnum` int(11) DEFAULT '0' COMMENT '正确回答次数 仅考试';");
}
if(!pdo_fieldexists("goouc_fullexam_test", "level")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `level` tinyint(1) DEFAULT '1' COMMENT '难度等级';");
}
if(!pdo_fieldexists("goouc_fullexam_test", "qvideo")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `qvideo` text COMMENT '问题视频';");
}
if(!pdo_fieldexists("goouc_fullexam_test", "analysis_audio")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `analysis_audio` text COMMENT '音频解析';");
}
if(!pdo_fieldexists("goouc_fullexam_test", "knowledge")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `knowledge` text COMMENT '所属知识点类别';");
}
if(!pdo_fieldexists("goouc_fullexam_test", "type_classification")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `type_classification` text COMMENT '类型分类';");
}
if(!pdo_fieldexists("goouc_fullexam_test", "q_year")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `q_year` text COMMENT '年份';");
}
if(!pdo_fieldexists("goouc_fullexam_test", "pid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `pid` int(11) DEFAULT '0' COMMENT '问题父id';");
}
if(!pdo_fieldexists("goouc_fullexam_test", "son_status")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `son_status` int(1) COMMENT '语音题是否加了小题';");
}
if(!pdo_fieldexists("goouc_fullexam_test", "display")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `display` tinyint(1) DEFAULT '1' COMMENT '1-显示2-不显示';");
}
if(!pdo_fieldexists("goouc_fullexam_test", "son_simple")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test")." ADD `son_simple` int(11) NOT NULL DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_test_type", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test_type")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_test_type", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test_type")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_test_type", "name")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test_type")." ADD `name` varchar(255) NOT NULL COMMENT '试题库名称';");
}
if(!pdo_fieldexists("goouc_fullexam_test_type", "pid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test_type")." ADD `pid` int(11) DEFAULT '0' COMMENT '默认0为顶级分类';");
}
if(!pdo_fieldexists("goouc_fullexam_test_type", "gpid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test_type")." ADD `gpid` int(11) DEFAULT '0' COMMENT '默认0';");
}
if(!pdo_fieldexists("goouc_fullexam_test_type", "price")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test_type")." ADD `price` decimal(10,2) DEFAULT '0.00';");
}
if(!pdo_fieldexists("goouc_fullexam_test_type", "status")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test_type")." ADD `status` tinyint(1) DEFAULT '1' COMMENT '题库状态';");
}
if(!pdo_fieldexists("goouc_fullexam_test_type", "is_student")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test_type")." ADD `is_student` tinyint(1) DEFAULT '0' COMMENT '学员专享 1是';");
}
if(!pdo_fieldexists("goouc_fullexam_test_type", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test_type")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识';");
}
if(!pdo_fieldexists("goouc_fullexam_test_type", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test_type")." ADD `createtime` int(11) NOT NULL COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_test_type", "display_order")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_test_type")." ADD `display_order` int(11) NOT NULL DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_type_cate", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_type_cate")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_type_cate", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_type_cate")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_type_cate", "name")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_type_cate")." ADD `name` varchar(255) NOT NULL COMMENT '分类名称';");
}
if(!pdo_fieldexists("goouc_fullexam_type_cate", "status")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_type_cate")." ADD `status` tinyint(1) DEFAULT '1' COMMENT '状态 1 显示 2不显示';");
}
if(!pdo_fieldexists("goouc_fullexam_type_cate", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_type_cate")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识';");
}
if(!pdo_fieldexists("goouc_fullexam_type_cate", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_type_cate")." ADD `createtime` int(11) NOT NULL COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_user", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_user", "openid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `openid` varchar(255) NOT NULL COMMENT '用户标识';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "unionid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `unionid` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_user", "nickname")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `nickname` varchar(255) COMMENT '用户昵称 可保存特殊符号';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "headimg")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `headimg` varchar(255) COMMENT '用户头像';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "name")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `name` varchar(50) COMMENT '用户姓名';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "phone")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `phone` varchar(11) COMMENT '手机号';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "gradeid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `gradeid` int(11) COMMENT '个人信息完善页面 选择年级ID';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "classid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `classid` int(11) COMMENT '班级考试 参加班级的ID';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "groupid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `groupid` int(11) COMMENT '固定人群组考试 群组ID';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "nativeplace")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `nativeplace` varchar(255) COMMENT '籍贯';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "province")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `province` varchar(255) COMMENT '省';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "city")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `city` varchar(255) COMMENT '市';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "county")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `county` varchar(255) COMMENT '县';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "ismember")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `ismember` tinyint(1) DEFAULT '2' COMMENT '是否是会员  1 是会员 2不是';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "password")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `password` varchar(255) COMMENT '用户登录密码';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "member_endtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `member_endtime` varchar(255) COMMENT '会员到期时间 ';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "status")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `status` tinyint(1) DEFAULT '1' COMMENT '是否拉黑 ';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "last_login_time")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `last_login_time` int(11) NOT NULL COMMENT '最近一次登录时间';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "integral")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `integral` int(11) DEFAULT '0' COMMENT '用户积分数';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "balance")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `balance` decimal(8,2) DEFAULT '0.00' COMMENT '用户余额';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "qrcode")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `qrcode` varchar(255) COMMENT '用户二维码路径';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "pid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `pid` int(11) DEFAULT '0' COMMENT '用户自己注册 为0  扫描其他人二维码 为二维码人的ID';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `createtime` int(11) NOT NULL COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "id_card")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `id_card` varchar(255) COMMENT '身份证号';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "student_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `student_id` varchar(200) COMMENT '学号';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "school")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `school` varchar(255) COMMENT '学校';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "level")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `level` int(11) DEFAULT '0' COMMENT '用户等级';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "grade")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `grade` varchar(255) COMMENT '年级';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "count_day")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `count_day` int(11) DEFAULT '0' COMMENT '累计天数';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "is_band")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `is_band` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否绑定微信 1是0否';");
}
if(!pdo_fieldexists("goouc_fullexam_user", "h5_openid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user")." ADD `h5_openid` varchar(255) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_user_collection_praction", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_collection_praction")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_user_collection_praction", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_collection_praction")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_user_collection_praction", "uid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_collection_praction")." ADD `uid` int(11) NOT NULL COMMENT '用户ID';");
}
if(!pdo_fieldexists("goouc_fullexam_user_collection_praction", "testid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_collection_praction")." ADD `testid` int(11) NOT NULL COMMENT '试题ID';");
}
if(!pdo_fieldexists("goouc_fullexam_user_collection_praction", "test_type")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_collection_praction")." ADD `test_type` tinyint(1) NOT NULL COMMENT '试题类型';");
}
if(!pdo_fieldexists("goouc_fullexam_user_collection_praction", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_collection_praction")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '删除状态';");
}
if(!pdo_fieldexists("goouc_fullexam_user_collection_praction", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_collection_praction")." ADD `createtime` int(11) NOT NULL COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_user_collection_praction", "iscollect")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_collection_praction")." ADD `iscollect` int(11) DEFAULT '2';");
}
if(!pdo_fieldexists("goouc_fullexam_user_doexam", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doexam")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_user_doexam", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doexam")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_user_doexam", "uid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doexam")." ADD `uid` int(11) NOT NULL COMMENT '用户ID';");
}
if(!pdo_fieldexists("goouc_fullexam_user_doexam", "examid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doexam")." ADD `examid` int(11) NOT NULL COMMENT '已发布的试卷  考试 或练习的ID';");
}
if(!pdo_fieldexists("goouc_fullexam_user_doexam", "franction")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doexam")." ADD `franction` int(11) DEFAULT '0' COMMENT '得分情况';");
}
if(!pdo_fieldexists("goouc_fullexam_user_doexam", "usetime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doexam")." ADD `usetime` varchar(20) DEFAULT '0' COMMENT '考试用时';");
}
if(!pdo_fieldexists("goouc_fullexam_user_doexam", "level")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doexam")." ADD `level` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_user_doexam", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doexam")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '删除状态';");
}
if(!pdo_fieldexists("goouc_fullexam_user_doexam", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doexam")." ADD `createtime` int(11) NOT NULL COMMENT '交卷时间';");
}
if(!pdo_fieldexists("goouc_fullexam_user_doexam", "recordid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doexam")." ADD `recordid` int(11) NOT NULL COMMENT '考试记录id';");
}
if(!pdo_fieldexists("goouc_fullexam_user_doexam", "evaluation")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doexam")." ADD `evaluation` tinyint(1) NOT NULL DEFAULT '2' COMMENT '1已评2未评默认2 3批改中';");
}
if(!pdo_fieldexists("goouc_fullexam_user_doother_exam", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doother_exam")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_user_doother_exam", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doother_exam")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_user_doother_exam", "uid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doother_exam")." ADD `uid` int(11) NOT NULL COMMENT '用户ID';");
}
if(!pdo_fieldexists("goouc_fullexam_user_doother_exam", "recordid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doother_exam")." ADD `recordid` int(11) NOT NULL COMMENT '区分是哪一次考试';");
}
if(!pdo_fieldexists("goouc_fullexam_user_doother_exam", "franction")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doother_exam")." ADD `franction` int(11) DEFAULT '0' COMMENT '得分情况';");
}
if(!pdo_fieldexists("goouc_fullexam_user_doother_exam", "usetime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doother_exam")." ADD `usetime` varchar(20) DEFAULT '0' COMMENT '考试用时';");
}
if(!pdo_fieldexists("goouc_fullexam_user_doother_exam", "level")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doother_exam")." ADD `level` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_user_doother_exam", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doother_exam")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '删除状态';");
}
if(!pdo_fieldexists("goouc_fullexam_user_doother_exam", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doother_exam")." ADD `createtime` int(11) NOT NULL COMMENT '交卷时间';");
}
if(!pdo_fieldexists("goouc_fullexam_user_doother_exam", "type")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doother_exam")." ADD `type` tinyint(1) COMMENT '类型2-优先未做3-智能考试';");
}
if(!pdo_fieldexists("goouc_fullexam_user_doother_exam_answer", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doother_exam_answer")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_user_doother_exam_answer", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doother_exam_answer")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_user_doother_exam_answer", "uid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doother_exam_answer")." ADD `uid` int(11) NOT NULL COMMENT '用户ID';");
}
if(!pdo_fieldexists("goouc_fullexam_user_doother_exam_answer", "recordid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doother_exam_answer")." ADD `recordid` int(11) NOT NULL COMMENT '区分是哪一次考试';");
}
if(!pdo_fieldexists("goouc_fullexam_user_doother_exam_answer", "testid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doother_exam_answer")." ADD `testid` int(11) NOT NULL COMMENT '试题id';");
}
if(!pdo_fieldexists("goouc_fullexam_user_doother_exam_answer", "test_type")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doother_exam_answer")." ADD `test_type` tinyint(1) NOT NULL COMMENT '试题类型';");
}
if(!pdo_fieldexists("goouc_fullexam_user_doother_exam_answer", "uanswer")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doother_exam_answer")." ADD `uanswer` text COMMENT '用户答案';");
}
if(!pdo_fieldexists("goouc_fullexam_user_doother_exam_answer", "franction")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doother_exam_answer")." ADD `franction` int(11) DEFAULT '0' COMMENT '得分情况';");
}
if(!pdo_fieldexists("goouc_fullexam_user_doother_exam_answer", "isright")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doother_exam_answer")." ADD `isright` tinyint(1) NOT NULL COMMENT '是否正确';");
}
if(!pdo_fieldexists("goouc_fullexam_user_doother_exam_answer", "ischeck")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doother_exam_answer")." ADD `ischeck` tinyint(1) DEFAULT '1' COMMENT '是否批改 默认为已批该';");
}
if(!pdo_fieldexists("goouc_fullexam_user_doother_exam_answer", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doother_exam_answer")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '删除状态';");
}
if(!pdo_fieldexists("goouc_fullexam_user_doother_exam_answer", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doother_exam_answer")." ADD `createtime` int(11) NOT NULL COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_user_doother_exam_answer", "type")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_doother_exam_answer")." ADD `type` int(1) COMMENT '类型2-优先未做3-智能考试';");
}
if(!pdo_fieldexists("goouc_fullexam_user_exam_answer", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_exam_answer")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_user_exam_answer", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_exam_answer")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_user_exam_answer", "uid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_exam_answer")." ADD `uid` int(11) NOT NULL COMMENT '用户ID';");
}
if(!pdo_fieldexists("goouc_fullexam_user_exam_answer", "examid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_exam_answer")." ADD `examid` int(11) NOT NULL COMMENT '已发布的试卷  考试 或练习的ID';");
}
if(!pdo_fieldexists("goouc_fullexam_user_exam_answer", "testid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_exam_answer")." ADD `testid` int(11) NOT NULL COMMENT '试题id';");
}
if(!pdo_fieldexists("goouc_fullexam_user_exam_answer", "test_type")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_exam_answer")." ADD `test_type` tinyint(1) NOT NULL COMMENT '试题类型';");
}
if(!pdo_fieldexists("goouc_fullexam_user_exam_answer", "uanswer")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_exam_answer")." ADD `uanswer` text COMMENT '用户答案';");
}
if(!pdo_fieldexists("goouc_fullexam_user_exam_answer", "franction")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_exam_answer")." ADD `franction` int(11) DEFAULT '0' COMMENT '得分情况';");
}
if(!pdo_fieldexists("goouc_fullexam_user_exam_answer", "isright")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_exam_answer")." ADD `isright` tinyint(1) NOT NULL COMMENT '是否正确';");
}
if(!pdo_fieldexists("goouc_fullexam_user_exam_answer", "ischeck")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_exam_answer")." ADD `ischeck` tinyint(1) DEFAULT '1' COMMENT '是否批改 默认为已批该';");
}
if(!pdo_fieldexists("goouc_fullexam_user_exam_answer", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_exam_answer")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '删除状态';");
}
if(!pdo_fieldexists("goouc_fullexam_user_exam_answer", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_exam_answer")." ADD `createtime` int(11) NOT NULL COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_user_exam_answer", "recordid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_exam_answer")." ADD `recordid` int(11) COMMENT '考试记录id';");
}
if(!pdo_fieldexists("goouc_fullexam_user_exam_answer", "type")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_exam_answer")." ADD `type` int(1) COMMENT '类型只有1-全真';");
}
if(!pdo_fieldexists("goouc_fullexam_user_exam_answer", "simple_score")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_exam_answer")." ADD `simple_score` int(8) COMMENT '简答题评分';");
}
if(!pdo_fieldexists("goouc_fullexam_user_exam_answer", "comments")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_exam_answer")." ADD `comments` text NOT NULL COMMENT '简答题评语';");
}
if(!pdo_fieldexists("goouc_fullexam_user_exam_answer", "simple_evaluation")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_exam_answer")." ADD `simple_evaluation` tinyint(1) NOT NULL DEFAULT '2' COMMENT '1已批改默认2未3批改中';");
}
if(!pdo_fieldexists("goouc_fullexam_user_formid", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_formid")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_user_formid", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_formid")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_user_formid", "uid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_formid")." ADD `uid` int(11) NOT NULL COMMENT '用户ID';");
}
if(!pdo_fieldexists("goouc_fullexam_user_formid", "formid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_formid")." ADD `formid` varchar(255) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_user_formid", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_formid")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '删除状态';");
}
if(!pdo_fieldexists("goouc_fullexam_user_formid", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_formid")." ADD `createtime` int(11) NOT NULL COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_user_gift", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_gift")." ADD `id` int(11) NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_user_gift", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_gift")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_user_gift", "uid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_gift")." ADD `uid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_user_gift", "giftid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_gift")." ADD `giftid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_user_gift", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_gift")." ADD `createtime` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_user_gift", "status")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_gift")." ADD `status` tinyint(2) DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_user_gift", "updatetime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_gift")." ADD `updatetime` int(11);");
}
if(!pdo_fieldexists("goouc_fullexam_user_gift", "consignee_name")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_gift")." ADD `consignee_name` varchar(255) COMMENT '收货人姓名';");
}
if(!pdo_fieldexists("goouc_fullexam_user_gift", "consignee_phone")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_gift")." ADD `consignee_phone` varchar(255) COMMENT '收货人电话';");
}
if(!pdo_fieldexists("goouc_fullexam_user_gift", "consignee_address")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_gift")." ADD `consignee_address` varchar(255) COMMENT '收货人地址';");
}
if(!pdo_fieldexists("goouc_fullexam_user_knowledge_cate", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_knowledge_cate")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_user_knowledge_cate", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_knowledge_cate")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_user_knowledge_cate", "uid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_knowledge_cate")." ADD `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户id';");
}
if(!pdo_fieldexists("goouc_fullexam_user_knowledge_cate", "cate")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_knowledge_cate")." ADD `cate` int(11) DEFAULT '0' COMMENT '知识点id';");
}
if(!pdo_fieldexists("goouc_fullexam_user_knowledge_cate", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_knowledge_cate")." ADD `createtime` int(11) NOT NULL COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_user_knowledge_cate", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_knowledge_cate")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识';");
}
if(!pdo_fieldexists("goouc_fullexam_user_member", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_member")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_user_member", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_member")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_user_member", "status")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_member")." ADD `status` tinyint(1) DEFAULT '2' COMMENT '是否开启购买会员';");
}
if(!pdo_fieldexists("goouc_fullexam_user_member", "scale")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_member")." ADD `scale` decimal(8,2) DEFAULT '1.00' COMMENT '折扣比例';");
}
if(!pdo_fieldexists("goouc_fullexam_user_member", "info")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_member")." ADD `info` text COMMENT '详细信息';");
}
if(!pdo_fieldexists("goouc_fullexam_user_member", "price")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_member")." ADD `price` decimal(8,2) DEFAULT '0.00' COMMENT 'VIP单月价格';");
}
if(!pdo_fieldexists("goouc_fullexam_user_member", "istui")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_member")." ADD `istui` int(11) DEFAULT '0' COMMENT '推荐购买的';");
}
if(!pdo_fieldexists("goouc_fullexam_user_member", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_member")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '删除状态';");
}
if(!pdo_fieldexists("goouc_fullexam_user_member", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_member")." ADD `createtime` int(11) NOT NULL COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_user_pool", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_pool")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_user_pool", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_pool")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_user_pool", "uid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_pool")." ADD `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户id';");
}
if(!pdo_fieldexists("goouc_fullexam_user_pool", "poolid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_pool")." ADD `poolid` int(11) DEFAULT '0' COMMENT '题库id';");
}
if(!pdo_fieldexists("goouc_fullexam_user_pool", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_pool")." ADD `createtime` int(11) NOT NULL COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_user_pool", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_pool")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '是否删除的标识';");
}
if(!pdo_fieldexists("goouc_fullexam_user_pool", "paperid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_pool")." ADD `paperid` int(11) NOT NULL DEFAULT '0' COMMENT '试卷id';");
}
if(!pdo_fieldexists("goouc_fullexam_user_qhigh", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_qhigh")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_user_qhigh", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_qhigh")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_user_qhigh", "user_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_qhigh")." ADD `user_id` int(11) NOT NULL COMMENT '用户ID';");
}
if(!pdo_fieldexists("goouc_fullexam_user_qhigh", "question_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_qhigh")." ADD `question_id` int(11) NOT NULL COMMENT '试题ID';");
}
if(!pdo_fieldexists("goouc_fullexam_user_qhigh", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_qhigh")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '删除状态';");
}
if(!pdo_fieldexists("goouc_fullexam_user_qhigh", "create_time")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_qhigh")." ADD `create_time` int(11) NOT NULL COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_user_qintensive", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_qintensive")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_user_qintensive", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_qintensive")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_user_qintensive", "user_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_qintensive")." ADD `user_id` int(11) NOT NULL COMMENT '用户ID';");
}
if(!pdo_fieldexists("goouc_fullexam_user_qintensive", "question_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_qintensive")." ADD `question_id` int(11) NOT NULL COMMENT '试题ID';");
}
if(!pdo_fieldexists("goouc_fullexam_user_qintensive", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_qintensive")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '删除状态';");
}
if(!pdo_fieldexists("goouc_fullexam_user_qintensive", "create_time")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_qintensive")." ADD `create_time` int(11) NOT NULL COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_user_qtype", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_qtype")." ADD `id` int(11) NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_user_qtype", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_qtype")." ADD `weid` int(11) DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_user_qtype", "uid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_qtype")." ADD `uid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_user_qtype", "type_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_qtype")." ADD `type_id` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_user_qtype", "last_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_qtype")." ADD `last_id` int(11);");
}
if(!pdo_fieldexists("goouc_fullexam_user_qtype", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_qtype")." ADD `istatus` tinyint(2) DEFAULT '1';");
}
if(!pdo_fieldexists("goouc_fullexam_user_qtype", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_qtype")." ADD `createtime` int(11) COMMENT '时间';");
}
if(!pdo_fieldexists("goouc_fullexam_user_read", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_read")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_user_read", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_read")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_user_read", "uid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_read")." ADD `uid` int(11) NOT NULL COMMENT '用户ID';");
}
if(!pdo_fieldexists("goouc_fullexam_user_read", "noticeid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_read")." ADD `noticeid` int(11) NOT NULL COMMENT '公告 活动 文章 ID';");
}
if(!pdo_fieldexists("goouc_fullexam_user_read", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_read")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '删除状态';");
}
if(!pdo_fieldexists("goouc_fullexam_user_read", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_read")." ADD `createtime` int(11) NOT NULL COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_user_special", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_special")." ADD `id` int(11) NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_user_special", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_special")." ADD `weid` int(11) DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_user_special", "uid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_special")." ADD `uid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_user_special", "special_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_special")." ADD `special_id` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_user_special", "last_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_special")." ADD `last_id` int(11);");
}
if(!pdo_fieldexists("goouc_fullexam_user_special", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_special")." ADD `istatus` tinyint(2) DEFAULT '1';");
}
if(!pdo_fieldexists("goouc_fullexam_user_special", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_special")." ADD `createtime` int(11) COMMENT '时间';");
}
if(!pdo_fieldexists("goouc_fullexam_user_spequence", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_spequence")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_user_spequence", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_spequence")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_user_spequence", "user_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_spequence")." ADD `user_id` int(11) NOT NULL COMMENT '用户ID';");
}
if(!pdo_fieldexists("goouc_fullexam_user_spequence", "question_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_spequence")." ADD `question_id` int(11) NOT NULL COMMENT '下标ID';");
}
if(!pdo_fieldexists("goouc_fullexam_user_spequence", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_spequence")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '删除状态';");
}
if(!pdo_fieldexists("goouc_fullexam_user_spequence", "create_time")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_spequence")." ADD `create_time` int(11) NOT NULL COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_user_wrong_praction", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_wrong_praction")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_user_wrong_praction", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_wrong_praction")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_user_wrong_praction", "uid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_wrong_praction")." ADD `uid` int(11) NOT NULL COMMENT '用户ID';");
}
if(!pdo_fieldexists("goouc_fullexam_user_wrong_praction", "testid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_wrong_praction")." ADD `testid` int(11) NOT NULL COMMENT '试题ID';");
}
if(!pdo_fieldexists("goouc_fullexam_user_wrong_praction", "test_type")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_wrong_praction")." ADD `test_type` tinyint(1) NOT NULL COMMENT '试题类型';");
}
if(!pdo_fieldexists("goouc_fullexam_user_wrong_praction", "uanswer")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_wrong_praction")." ADD `uanswer` text COMMENT '用户答案';");
}
if(!pdo_fieldexists("goouc_fullexam_user_wrong_praction", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_wrong_praction")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '删除状态';");
}
if(!pdo_fieldexists("goouc_fullexam_user_wrong_praction", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_wrong_praction")." ADD `createtime` int(11) NOT NULL COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_user_wrong_praction", "iscollect")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_user_wrong_praction")." ADD `iscollect` int(11) DEFAULT '2';");
}
if(!pdo_fieldexists("goouc_fullexam_watermark", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_watermark")." ADD `id` int(11) NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_watermark", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_watermark")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_watermark", "type")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_watermark")." ADD `type` tinyint(1) NOT NULL COMMENT '1个人信息 2为自定义';");
}
if(!pdo_fieldexists("goouc_fullexam_watermark", "open")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_watermark")." ADD `open` tinyint(1) NOT NULL DEFAULT '2' COMMENT '1打开水印 2关闭水印';");
}
if(!pdo_fieldexists("goouc_fullexam_watermark", "content")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_watermark")." ADD `content` varchar(1024) NOT NULL COMMENT '水印内容';");
}
if(!pdo_fieldexists("goouc_fullexam_watermark", "size")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_watermark")." ADD `size` int(11) NOT NULL COMMENT '字体大小';");
}
if(!pdo_fieldexists("goouc_fullexam_watermark", "rotate")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_watermark")." ADD `rotate` int(11) NOT NULL COMMENT '旋转度数';");
}
if(!pdo_fieldexists("goouc_fullexam_watermark", "transparent")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_watermark")." ADD `transparent` int(11) NOT NULL COMMENT '透明度';");
}
if(!pdo_fieldexists("goouc_fullexam_watermark", "local_type")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_watermark")." ADD `local_type` tinyint(1) NOT NULL COMMENT '1预设 2为自定义 生效位置类型';");
}
if(!pdo_fieldexists("goouc_fullexam_watermark", "presupposition")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_watermark")." ADD `presupposition` tinyint(1) NOT NULL COMMENT '预设类型';");
}
if(!pdo_fieldexists("goouc_fullexam_watermark", "horizontal")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_watermark")." ADD `horizontal` int(11) NOT NULL COMMENT '水平距离';");
}
if(!pdo_fieldexists("goouc_fullexam_watermark", "vertical")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_watermark")." ADD `vertical` int(11) NOT NULL COMMENT '垂直距离';");
}
if(!pdo_fieldexists("goouc_fullexam_wxtpl", "id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_wxtpl")." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_wxtpl", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_wxtpl")." ADD `weid` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_wxtpl", "type")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_wxtpl")." ADD `type` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_wxtpl", "tplid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_wxtpl")." ADD `tplid` varchar(255) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_wxtpl", "keyword1")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_wxtpl")." ADD `keyword1` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_wxtpl", "keyword2")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_wxtpl")." ADD `keyword2` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_wxtpl", "keyword3")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_wxtpl")." ADD `keyword3` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_wxtpl", "istatus")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_wxtpl")." ADD `istatus` tinyint(1) DEFAULT '1' COMMENT '删除状态';");
}
if(!pdo_fieldexists("goouc_fullexam_wxtpl", "createtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_wxtpl")." ADD `createtime` int(11) NOT NULL COMMENT '创建时间';");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "xuesheng_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `xuesheng_id` int(10) unsigned NOT NULL AUTO_INCREMENT;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "weid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `weid` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "uidht")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `uidht` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "school_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `school_id` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "nianfen_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `nianfen_id` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "banji_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `banji_id` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "banjixs_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `banjixs_id` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "xiaozu_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `xiaozu_id` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "xiaozuxs_id")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `xiaozuxs_id` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "sflx")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `sflx` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "bjcsjf")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `bjcsjf` float(13,2) NOT NULL DEFAULT '0.00';");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "bjzf")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `bjzf` float(13,2) NOT NULL DEFAULT '0.00';");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "displayorder")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `displayorder` tinyint(3) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "student_name")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `student_name` char(20);");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "pic")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `pic` text NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "sex")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `sex` text NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "jiguan")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `jiguan` text NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "minzu")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `minzu` text NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "sfzhm")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `sfzhm` text NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "gxuehao")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `gxuehao` char(25);");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "xxuehao")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `xxuehao` char(25);");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "zxxuehao")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `zxxuehao` char(25);");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "student_img")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `student_img` char(60);");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "parent_name")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `parent_name` char(20);");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "parent_phone")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `parent_phone` char(20);");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "qq")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `qq` varchar(255) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "phone")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `phone` varchar(255) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "yzm")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `yzm` varchar(225) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "address")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `address` varchar(255);");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "updatetime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `updatetime` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "beizhu")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `beizhu` text NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "addtime")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `addtime` int(11) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "uid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `uid` int(11) unsigned DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "uid1")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `uid1` int(11) unsigned DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "uid2")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `uid2` int(11) unsigned DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "uid3")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `uid3` int(11) unsigned DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "uid4")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `uid4` int(11) unsigned DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "uid5")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `uid5` int(11) unsigned DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "uid6")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `uid6` int(11) unsigned DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "uid7")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `uid7` int(11) unsigned DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "uid8")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `uid8` int(11) unsigned DEFAULT '0';");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "openid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `openid` varchar(255) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "openid1")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `openid1` varchar(255) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "openid2")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `openid2` varchar(255) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "openid3")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `openid3` varchar(255) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "openid4")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `openid4` varchar(255) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "openid5")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `openid5` varchar(255) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "openid6")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `openid6` varchar(255) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "openid7")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `openid7` varchar(255) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "openid8")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `openid8` varchar(255) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "sflx1")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `sflx1` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "sflx2")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `sflx2` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "sflx3")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `sflx3` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "sflx4")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `sflx4` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "sflx5")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `sflx5` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "sflx6")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `sflx6` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "sflx7")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `sflx7` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "sflx8")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `sflx8` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "nid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `nid` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "name")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `name` varchar(50) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "parentid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `parentid` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "enabled")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `enabled` tinyint(1) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "icon")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `icon` varchar(100) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "description")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `description` varchar(100) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "styleid")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `styleid` int(10) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "linkurl")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `linkurl` varchar(500) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "ishomepage")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `ishomepage` tinyint(1) NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "icontype")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `icontype` tinyint(1) unsigned NOT NULL;");
}
if(!pdo_fieldexists("goouc_fullexam_xuesheng", "css")) {
 pdo_query("ALTER TABLE ".tablename("goouc_fullexam_xuesheng")." ADD `css` varchar(500) NOT NULL;");
}
