微教育小程序版 fm_jiaoyuwxapp 2.42.8安装更新一体包.rar

<?php pdo_query("CREATE TABLE IF NOT EXISTS `ims_wx_school_address` ( `id` int(10) NOT NULL AUTO_INCREMENT, `weid` int(11) NOT NULL, `schoolid` int(11) NOT NULL, `openid` varchar(30) NOT NULL, `name` varchar(50) NOT NULL, `phone` varchar(30) NOT NULL, `province` varchar(40) NOT NULL, `city` varchar(40) NOT NULL, `county` varchar(40) NOT NULL, `address` varchar(300) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_wx_school_allcamera` ( `id` int(10) NOT NULL AUTO_INCREMENT, `weid` int(10) NOT NULL, `schoolid` int(10) NOT NULL, `kcid` int(10) NOT NULL, `name` varchar(50) NOT NULL COMMENT '画面名称', `videopic` varchar(1000) NOT NULL COMMENT '监控地址', `videourl` varchar(1000) NOT NULL COMMENT '监控地址', `starttime1` varchar(50) NOT NULL, `endtime1` varchar(50) NOT NULL, `createtime` int(10) NOT NULL, `conet` text() COMMENT '说明', `allowpy` tinyint(1) NOT NULL DEFAULT NULL DEFAULT '1' COMMENT '1允许2拒绝', `videotype` tinyint(1) NOT NULL DEFAULT NULL DEFAULT '1' COMMENT '1公共2指定班级', `bj_id` text() COMMENT '关联班级组', `type` tinyint(1) NOT NULL COMMENT '1监控2课程直播', `click` int(10) NOT NULL COMMENT '查看量', `ssort` int(10) NOT NULL COMMENT '排序', `is_pay` tinyint(1) NOT NULL DEFAULT NULL DEFAULT '2' COMMENT '单独付费与否', `price_one` float() NOT NULL, `price_one_cun` float() NOT NULL, `price_all` float() NOT NULL, `price_all_cun` float() NOT NULL, `days` int(11) DEFAULT NULL DEFAULT '10', `is_try` tinyint(1) NOT NULL DEFAULT NULL DEFAULT '1' COMMENT '是否允许试看', `try_time` int(11) DEFAULT NULL DEFAULT '30' COMMENT '试看时间', `payweid` int(11) COMMENT '收款公众号', `starttime2` varchar(50) NOT NULL, `starttime3` varchar(50) NOT NULL, `endtime2` varchar(50) NOT NULL, `endtime3` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_wx_school_ans_remark` ( `id` int(11) NOT NULL AUTO_INCREMENT, `weid` int(11) NOT NULL, `schoolid` int(11) NOT NULL, `userid` int(11) NOT NULL, `tid` int(11) NOT NULL, `tname` varchar(30) NOT NULL, `sid` int(11) NOT NULL, `zyid` int(11) NOT NULL, `tmid` int(11) NOT NULL, `type` int(3) NOT NULL COMMENT '1是电脑创建的作业2是手机创建的作业', `content` varchar(500) NOT NULL, `createtime` int(11) NOT NULL, `audio` varchar(1000) NOT NULL, `audiotime` varchar(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_wx_school_answers` ( `id` int(10) NOT NULL AUTO_INCREMENT, `weid` int(10) NOT NULL, `schoolid` int(10) NOT NULL, `zyid` int(10) NOT NULL COMMENT '问题id', `sid` int(10) NOT NULL, `tid` int(11) NOT NULL, `userid` int(11) NOT NULL, `tmid` int(10) NOT NULL, `type` tinyint(1) NOT NULL COMMENT '1回答2单选3多选4图片5语音6视频', `MyAnswer` varchar(2000) NOT NULL, `createtime` varchar(13) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_wx_school_area` ( `id` int(10) NOT NULL AUTO_INCREMENT, `weid` int(10) NOT NULL COMMENT '所属帐号', `name` varchar(50) NOT NULL COMMENT '区域名称', `parentid` int(10) NOT NULL COMMENT '上级分类ID,0为第一级', `ssort` tinyint(3) NOT NULL COMMENT '排序', `type` char(20) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT NULL DEFAULT '1' COMMENT '显示状态', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_wx_school_banners` ( `id` int(11) NOT NULL AUTO_INCREMENT, `weid` int(11), `uniacid` int(10) NOT NULL, `schoolid` int(11), `bannername` varchar(50), `link` varchar(255), `thumb` varchar(5000) NOT NULL, `begintime` int(11) NOT NULL, `endtime` int(11) NOT NULL, `displayorder` int(11), `enabled` int(11), `leixing` int(1) NOT NULL COMMENT '0学校,1平台', `arr` text() COMMENT '列表信息', `click` varchar(1000) COMMENT '点击量', `place` tinyint(1) NOT NULL COMMENT '位置', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_wx_school_bjq` ( `id` int(10) NOT NULL AUTO_INCREMENT, `weid` int(10) NOT NULL, `schoolid` int(10) NOT NULL COMMENT '学校ID', `content` text() NOT NULL COMMENT '详细内容或评价', `uid` int(10) NOT NULL COMMENT '发布者UID', `www` varchar(30) NOT NULL, `bj_id1` int(10) NOT NULL COMMENT '班级ID1', `bj_id2` int(10) NOT NULL COMMENT '班级ID2', `bj_id3` int(10) NOT NULL COMMENT '班级ID3', `sherid` int(10) NOT NULL COMMENT '所属图文id', `shername` varchar(50) COMMENT '分享者名字', `openid` varchar(30) NOT NULL COMMENT '帖子所属openid', `isopen` tinyint(1) NOT NULL COMMENT '是否显示', `type` tinyint(1) NOT NULL COMMENT '类型0为班级圈1为评论', `createtime` int(10) NOT NULL COMMENT '创建时间', `msgtype` tinyint(1) NOT NULL DEFAULT NULL DEFAULT '1' COMMENT '1文字图片2语音3视频', `userid` int(10) NOT NULL COMMENT '发布者用户ID', `video` varchar(1000), `videoimg` varchar(1000), `plid` int(10) NOT NULL, `is_private` varchar(3) NOT NULL DEFAULT NULL DEFAULT 'N' COMMENT '禁止评论', `audio` varchar(1000) COMMENT '音频地址', `audiotime` int(10) NOT NULL COMMENT '音频时间', `link` varchar(1000) COMMENT '外链地址', `linkdesc` varchar(200) COMMENT '外链标题', `hftoname` varchar(100), `kc_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_wx_school_camerapl` ( `id` int(10) NOT NULL AUTO_INCREMENT, `weid` int(10) NOT NULL, `schoolid` int(10) NOT NULL, `carmeraid` int(10) NOT NULL COMMENT '画面ID', `userid` int(10) NOT NULL COMMENT '用户ID', `conet` text() COMMENT '内容', `bj_id` int(10) NOT NULL COMMENT '班级ID', `type` tinyint(1) NOT NULL COMMENT '1点赞2评论', `createtime` int(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_wx_school_camerask` ( `id` int(10) NOT NULL AUTO_INCREMENT, `weid` int(10) NOT NULL, `schoolid` int(10) NOT NULL, `carmeraid` int(10) NOT NULL COMMENT '画面ID', `userid` int(10) NOT NULL COMMENT '用户ID', `type` tinyint(1) NOT NULL DEFAULT NULL DEFAULT '1' COMMENT '1视频试看', `createtime` int(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_wx_school_checklog` ( `id` int(10) NOT NULL AUTO_INCREMENT, `weid` int(10) NOT NULL, `schoolid` int(10) NOT NULL, `macid` int(10) NOT NULL, `cardid` varchar(200) NOT NULL COMMENT '卡号', `sid` int(10) NOT NULL, `tid` int(10) NOT NULL, `bj_id` int(10) NOT NULL, `lat` decimal(18,10) NOT NULL DEFAULT NULL DEFAULT '0.0000000000' COMMENT '经度', `lon` decimal(18,10) NOT NULL DEFAULT NULL DEFAULT '0.0000000000' COMMENT '纬度', `temperature` varchar(10), `pic` varchar(255) COMMENT '图片', `pic2` varchar(255) COMMENT '图片2', `type` varchar(50) COMMENT '进校类型', `leixing` tinyint(1) NOT NULL COMMENT '1进校2离校3迟到4早退', `isread` tinyint(1) NOT NULL DEFAULT NULL DEFAULT '1' COMMENT '1已读2未读', `pard` tinyint(2) NOT NULL COMMENT '1本人2母亲3父亲4爷爷5奶奶6外公7外婆8叔叔9阿姨10其他11老师', `qdtid` int(11) NOT NULL COMMENT '代签老师ID', `checktype` tinyint(1) NOT NULL DEFAULT NULL DEFAULT '1' COMMENT '1刷卡2微信', `isconfirm` tinyint(1) NOT NULL DEFAULT NULL DEFAULT '1' COMMENT '1确认2拒绝', `createtime` int(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_wx_school_checkmac` ( `id` int(10) NOT NULL AUTO_INCREMENT, `weid` int(10) NOT NULL, `schoolid` int(10) NOT NULL, `macname` varchar(50) NOT NULL, `name` varchar(50) NOT NULL, `macid` varchar(200) NOT NULL COMMENT '设备编号', `banner` varchar(2000), `macset` varchar(2000), `is_on` tinyint(1) NOT NULL DEFAULT NULL DEFAULT '1' COMMENT '1启用2不启用', `type` tinyint(1) NOT