1 Star 0 Fork 2

兜里有糖 / TpMeCMS

forked from 小和 / TpMeCMS 
Create your Gitee Account
Explore and code with more than 6 million developers,Free private repositories !:)
Sign up
Clone or Download
TpMeCMS1.0.sql 97.02 KB
Copy Edit Web IDE Raw Blame History
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324
/*
Navicat Premium Data Transfer
Source Server : 云shang
Source Server Type : MySQL
Source Server Version : 50733
Source Host : yunshang.he4966.cn:3306
Source Schema : yunshang
Target Server Type : MySQL
Target Server Version : 50733
File Encoding : 65001
Date: 24/06/2021 08:36:20
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for he_admin
-- ----------------------------
DROP TABLE IF EXISTS `he_admin`;
CREATE TABLE `he_admin` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`username` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '用户名',
`nickname` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '昵称',
`password` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '密码',
`salt` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '密码盐',
`avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '头像',
`email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '电子邮箱',
`loginfailure` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '失败次数',
`logintime` int(10) DEFAULT NULL COMMENT '登录时间',
`loginip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '登录IP',
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
`token` varchar(59) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'Session标识',
`status` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'normal' COMMENT '状态',
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='管理员表';
-- ----------------------------
-- Records of he_admin
-- ----------------------------
BEGIN;
INSERT INTO `he_admin` VALUES (1, 'admin', 'Admin', '23dda9d2a045bd9aa3853a612587520d', '21ffe0', '/assets/img/avatar.png', 'admin@admin.com', 0, 1624279994, '58.214.61.39', 1491635035, 1624279994, '2d00d7c2-6e89-4fe1-8e92-53605571e9be', 'normal');
COMMIT;
-- ----------------------------
-- Table structure for he_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `he_admin_log`;
CREATE TABLE `he_admin_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`admin_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '管理员ID',
`username` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '管理员名字',
`url` varchar(1500) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '操作页面',
`title` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '日志标题',
`content` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '内容',
`ip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'IP',
`useragent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'User-Agent',
`createtime` int(10) DEFAULT NULL COMMENT '操作时间',
PRIMARY KEY (`id`),
KEY `name` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=480 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='管理员日志表';
-- ----------------------------
-- Records of he_admin_log
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for he_apply
-- ----------------------------
DROP TABLE IF EXISTS `he_apply`;
CREATE TABLE `he_apply` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ltd_name` varchar(20) NOT NULL COMMENT '企业名称',
`main` varchar(50) DEFAULT '' COMMENT '主营项目',
`hzqj` varchar(255) DEFAULT '' COMMENT '合作前景',
`name` varchar(10) DEFAULT '' COMMENT '联系人姓名',
`tel` varchar(15) NOT NULL DEFAULT '' COMMENT '联系电话',
`addr` varchar(255) DEFAULT '' COMMENT '企业地址',
`email` varchar(30) DEFAULT '' COMMENT '邮箱',
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
`deletetime` int(10) DEFAULT NULL COMMENT '删除时间',
`memo` varchar(100) DEFAULT '' COMMENT '备注',
`content` text COMMENT '内容',
`status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '状态:1=未读,2=已读',
`uid` int(10) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`id`),
KEY `status` (`ltd_name`,`status`),
KEY `channel` (`ltd_name`,`id`),
KEY `weigh` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8mb4 COMMENT='企业合作申请';
-- ----------------------------
-- Records of he_apply
-- ----------------------------
BEGIN;
INSERT INTO `he_apply` VALUES (111, '九鼎石业', '1', '2', 'xiaohe', '19983297340', '江阴市惠山区', '496631085@qq.com', 1624419281, NULL, NULL, '', '阿达SD', '1', 2);
COMMIT;
-- ----------------------------
-- Table structure for he_area
-- ----------------------------
DROP TABLE IF EXISTS `he_area`;
CREATE TABLE `he_area` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`pid` int(10) DEFAULT NULL COMMENT '父id',
`shortname` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '简称',
`name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称',
`mergename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '全称',
`level` tinyint(4) DEFAULT NULL COMMENT '层级 0 1 2 省市区县',
`pinyin` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '拼音',
`code` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '长途区号',
`zip` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮编',
`first` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '首字母',
`lng` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '经度',
`lat` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '纬度',
PRIMARY KEY (`id`),
KEY `pid` (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='地区表';
-- ----------------------------
-- Records of he_area
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for he_article
-- ----------------------------
DROP TABLE IF EXISTS `he_article`;
CREATE TABLE `he_article` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`cate_id` int(10) unsigned NOT NULL COMMENT '栏目ID',
`model_id` int(10) DEFAULT '0' COMMENT '模型ID',
`admin_id` int(10) unsigned DEFAULT '0' COMMENT '管理员ID',
`title` varchar(255) DEFAULT '' COMMENT '文章标题',
`flag` varchar(100) DEFAULT '' COMMENT '标志',
`style` varchar(100) DEFAULT '' COMMENT '样式',
`image` varchar(255) DEFAULT '' COMMENT '缩略图',
`images` varchar(1500) DEFAULT '' COMMENT '组图',
`seotitle` varchar(255) DEFAULT '' COMMENT 'SEO标题',
`keywords` varchar(255) DEFAULT '' COMMENT '关键字',
`description` varchar(255) DEFAULT '' COMMENT '描述',
`tags` varchar(255) DEFAULT '' COMMENT 'TAG',
`weigh` int(10) DEFAULT NULL,
`views` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览次数',
`comments` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '评论次数',
`likes` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点赞数',
`dislikes` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点踩数',
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
`publishtime` int(10) DEFAULT NULL COMMENT '发布时间',
`deletetime` int(10) DEFAULT NULL COMMENT '删除时间',
`memo` varchar(100) DEFAULT '' COMMENT '备注',
`status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '状态:1=正常,2=隐藏',
`content` text COMMENT '内容',
PRIMARY KEY (`id`),
KEY `status` (`cate_id`,`status`),
KEY `channel` (`cate_id`,`weigh`,`id`),
KEY `weigh` (`weigh`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8mb4 COMMENT='内容管理';
-- ----------------------------
-- Records of he_article
-- ----------------------------
BEGIN;
INSERT INTO `he_article` VALUES (110, 38, 0, 0, 'TpMeCMS', '', '', '', '', '', '', '', '', 110, 0, 0, 0, 0, 1623734419, 1623734419, 1623734396, NULL, '', '1', NULL);
COMMIT;
-- ----------------------------
-- Table structure for he_attachment
-- ----------------------------
DROP TABLE IF EXISTS `he_attachment`;
CREATE TABLE `he_attachment` (
`id` int(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`admin_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '管理员ID',
`user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
`url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '物理路径',
`imagewidth` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '宽度',
`imageheight` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '高度',
`imagetype` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '图片类型',
`imageframes` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '图片帧数',
`filename` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '文件名称',
`filesize` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
`mimetype` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'mime类型',
`extparam` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '透传数据',
`createtime` int(10) DEFAULT NULL COMMENT '创建日期',
`updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
`uploadtime` int(10) DEFAULT NULL COMMENT '上传时间',
`storage` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'local' COMMENT '存储位置',
`sha1` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '文件 sha1编码',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='附件表';
-- ----------------------------
-- Records of he_attachment
-- ----------------------------
BEGIN;
INSERT INTO `he_attachment` VALUES (1, 1, 0, '/assets/img/qrcode.png', '150', '150', 'png', 0, 'qrcode.png', 21859, 'image/png', '', 1491635035, 1491635035, 1491635035, 'local', '17163603d0263e4838b9387ff2cd4877e8b018f6');
INSERT INTO `he_attachment` VALUES (2, 1, 0, '/uploads/20210622/a572d67db33e94f6dc8dd2e908c03ff2.jpg', '258', '258', 'jpg', 0, 'qrcode_for_gh_6f8842475043_258.jpg', 27557, 'image/jpeg', '', 1624348450, 1624348450, 1624348450, 'local', 'a9ea481cdc67e3dc4989f3f346206032337b0096');
COMMIT;
-- ----------------------------
-- Table structure for he_auth_group
-- ----------------------------
DROP TABLE IF EXISTS `he_auth_group`;
CREATE TABLE `he_auth_group` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父组别',
`name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '组名',
`rules` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '规则ID',
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
`status` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '状态',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='分组表';
-- ----------------------------
-- Records of he_auth_group
-- ----------------------------
BEGIN;
INSERT INTO `he_auth_group` VALUES (1, 0, 'Admin group', '*', 1491635035, 1491635035, 'normal');
INSERT INTO `he_auth_group` VALUES (2, 1, 'Second group', '13,14,16,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,40,41,42,43,44,45,46,47,48,49,50,55,56,57,58,59,60,61,62,63,64,65,1,9,10,11,7,6,8,2,4,5', 1491635035, 1491635035, 'normal');
INSERT INTO `he_auth_group` VALUES (3, 2, 'Third group', '1,4,9,10,11,13,14,15,16,17,40,41,42,43,44,45,46,47,48,49,50,55,56,57,58,59,60,61,62,63,64,65,5', 1491635035, 1491635035, 'normal');
INSERT INTO `he_auth_group` VALUES (4, 1, 'Second group 2', '1,4,13,14,15,16,17,55,56,57,58,59,60,61,62,63,64,65', 1491635035, 1491635035, 'normal');
INSERT INTO `he_auth_group` VALUES (5, 2, 'Third group 2', '1,2,6,7,8,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34', 1491635035, 1491635035, 'normal');
COMMIT;
-- ----------------------------
-- Table structure for he_auth_group_access
-- ----------------------------
DROP TABLE IF EXISTS `he_auth_group_access`;
CREATE TABLE `he_auth_group_access` (
`uid` int(10) unsigned NOT NULL COMMENT '会员ID',
`group_id` int(10) unsigned NOT NULL COMMENT '级别ID',
UNIQUE KEY `uid_group_id` (`uid`,`group_id`),
KEY `uid` (`uid`),
KEY `group_id` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='权限分组表';
-- ----------------------------
-- Records of he_auth_group_access
-- ----------------------------
BEGIN;
INSERT INTO `he_auth_group_access` VALUES (1, 1);
COMMIT;
-- ----------------------------
-- Table structure for he_auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `he_auth_rule`;
CREATE TABLE `he_auth_rule` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` enum('menu','file') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'file' COMMENT 'menu为菜单,file为权限节点',
`pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父ID',
`name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '规则名称',
`title` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '规则名称',
`icon` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '图标',
`url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '规则URL',
`condition` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '条件',
`remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '备注',
`ismenu` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否为菜单',
`menutype` enum('addtabs','blank','dialog','ajax') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '菜单类型',
`extend` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '扩展属性',
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
`weigh` int(10) NOT NULL DEFAULT '0' COMMENT '权重',
`status` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '状态',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`) USING BTREE,
KEY `pid` (`pid`),
KEY `weigh` (`weigh`)
) ENGINE=InnoDB AUTO_INCREMENT=285 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='节点表';
-- ----------------------------
-- Records of he_auth_rule
-- ----------------------------
BEGIN;
INSERT INTO `he_auth_rule` VALUES (1, 'file', 0, 'dashboard', 'Dashboard', 'fa fa-dashboard', '', '', 'Dashboard tips', 1, NULL, '', 1491635035, 1491635035, 143, 'normal');
INSERT INTO `he_auth_rule` VALUES (2, 'file', 0, 'general', 'General', 'fa fa-cogs', '', '', '', 1, NULL, '', 1491635035, 1491635035, 137, 'normal');
INSERT INTO `he_auth_rule` VALUES (3, 'file', 0, 'category', '分类管理', 'fa fa-leaf', '', '', 'Category tips', 1, 'addtabs', '', 1491635035, 1624280138, 119, 'hidden');
INSERT INTO `he_auth_rule` VALUES (4, 'file', 0, 'addon', 'Addon', 'fa fa-rocket', '', '', 'Addon tips', 1, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (5, 'file', 0, 'auth', 'Auth', 'fa fa-group', '', '', '', 1, NULL, '', 1491635035, 1491635035, 99, 'normal');
INSERT INTO `he_auth_rule` VALUES (6, 'file', 2, 'general/config', 'Config', 'fa fa-cog', '', '', 'Config tips', 1, NULL, '', 1491635035, 1491635035, 60, 'normal');
INSERT INTO `he_auth_rule` VALUES (7, 'file', 2, 'general/attachment', 'Attachment', 'fa fa-file-image-o', '', '', 'Attachment tips', 1, NULL, '', 1491635035, 1491635035, 53, 'normal');
INSERT INTO `he_auth_rule` VALUES (8, 'file', 2, 'general/profile', 'Profile', 'fa fa-user', '', '', '', 1, NULL, '', 1491635035, 1491635035, 34, 'normal');
INSERT INTO `he_auth_rule` VALUES (9, 'file', 5, 'auth/admin', 'Admin', 'fa fa-user', '', '', 'Admin tips', 1, NULL, '', 1491635035, 1491635035, 118, 'normal');
INSERT INTO `he_auth_rule` VALUES (10, 'file', 5, 'auth/adminlog', 'Admin log', 'fa fa-list-alt', '', '', 'Admin log tips', 1, NULL, '', 1491635035, 1491635035, 113, 'normal');
INSERT INTO `he_auth_rule` VALUES (11, 'file', 5, 'auth/group', 'Group', 'fa fa-group', '', '', 'Group tips', 1, NULL, '', 1491635035, 1491635035, 109, 'normal');
INSERT INTO `he_auth_rule` VALUES (12, 'file', 5, 'auth/rule', 'Rule', 'fa fa-bars', '', '', 'Rule tips', 1, NULL, '', 1491635035, 1491635035, 104, 'normal');
INSERT INTO `he_auth_rule` VALUES (13, 'file', 1, 'dashboard/index', 'View', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 136, 'normal');
INSERT INTO `he_auth_rule` VALUES (14, 'file', 1, 'dashboard/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 135, 'normal');
INSERT INTO `he_auth_rule` VALUES (15, 'file', 1, 'dashboard/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 133, 'normal');
INSERT INTO `he_auth_rule` VALUES (16, 'file', 1, 'dashboard/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 134, 'normal');
INSERT INTO `he_auth_rule` VALUES (17, 'file', 1, 'dashboard/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 132, 'normal');
INSERT INTO `he_auth_rule` VALUES (18, 'file', 6, 'general/config/index', 'View', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 52, 'normal');
INSERT INTO `he_auth_rule` VALUES (19, 'file', 6, 'general/config/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 51, 'normal');
INSERT INTO `he_auth_rule` VALUES (20, 'file', 6, 'general/config/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 50, 'normal');
INSERT INTO `he_auth_rule` VALUES (21, 'file', 6, 'general/config/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 49, 'normal');
INSERT INTO `he_auth_rule` VALUES (22, 'file', 6, 'general/config/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 48, 'normal');
INSERT INTO `he_auth_rule` VALUES (23, 'file', 7, 'general/attachment/index', 'View', 'fa fa-circle-o', '', '', 'Attachment tips', 0, NULL, '', 1491635035, 1491635035, 59, 'normal');
INSERT INTO `he_auth_rule` VALUES (24, 'file', 7, 'general/attachment/select', 'Select attachment', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 58, 'normal');
INSERT INTO `he_auth_rule` VALUES (25, 'file', 7, 'general/attachment/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 57, 'normal');
INSERT INTO `he_auth_rule` VALUES (26, 'file', 7, 'general/attachment/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 56, 'normal');
INSERT INTO `he_auth_rule` VALUES (27, 'file', 7, 'general/attachment/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 55, 'normal');
INSERT INTO `he_auth_rule` VALUES (28, 'file', 7, 'general/attachment/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 54, 'normal');
INSERT INTO `he_auth_rule` VALUES (29, 'file', 8, 'general/profile/index', 'View', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 33, 'normal');
INSERT INTO `he_auth_rule` VALUES (30, 'file', 8, 'general/profile/update', 'Update profile', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 32, 'normal');
INSERT INTO `he_auth_rule` VALUES (31, 'file', 8, 'general/profile/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 31, 'normal');
INSERT INTO `he_auth_rule` VALUES (32, 'file', 8, 'general/profile/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 30, 'normal');
INSERT INTO `he_auth_rule` VALUES (33, 'file', 8, 'general/profile/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 29, 'normal');
INSERT INTO `he_auth_rule` VALUES (34, 'file', 8, 'general/profile/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 28, 'normal');
INSERT INTO `he_auth_rule` VALUES (35, 'file', 3, 'category/index', 'View', 'fa fa-circle-o', '', '', 'Category tips', 0, NULL, '', 1491635035, 1491635035, 142, 'normal');
INSERT INTO `he_auth_rule` VALUES (36, 'file', 3, 'category/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 141, 'normal');
INSERT INTO `he_auth_rule` VALUES (37, 'file', 3, 'category/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 140, 'normal');
INSERT INTO `he_auth_rule` VALUES (38, 'file', 3, 'category/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 139, 'normal');
INSERT INTO `he_auth_rule` VALUES (39, 'file', 3, 'category/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 138, 'normal');
INSERT INTO `he_auth_rule` VALUES (40, 'file', 9, 'auth/admin/index', 'View', 'fa fa-circle-o', '', '', 'Admin tips', 0, NULL, '', 1491635035, 1491635035, 117, 'normal');
INSERT INTO `he_auth_rule` VALUES (41, 'file', 9, 'auth/admin/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 116, 'normal');
INSERT INTO `he_auth_rule` VALUES (42, 'file', 9, 'auth/admin/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 115, 'normal');
INSERT INTO `he_auth_rule` VALUES (43, 'file', 9, 'auth/admin/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 114, 'normal');
INSERT INTO `he_auth_rule` VALUES (44, 'file', 10, 'auth/adminlog/index', 'View', 'fa fa-circle-o', '', '', 'Admin log tips', 0, NULL, '', 1491635035, 1491635035, 112, 'normal');
INSERT INTO `he_auth_rule` VALUES (45, 'file', 10, 'auth/adminlog/detail', 'Detail', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 111, 'normal');
INSERT INTO `he_auth_rule` VALUES (46, 'file', 10, 'auth/adminlog/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 110, 'normal');
INSERT INTO `he_auth_rule` VALUES (47, 'file', 11, 'auth/group/index', 'View', 'fa fa-circle-o', '', '', 'Group tips', 0, NULL, '', 1491635035, 1491635035, 108, 'normal');
INSERT INTO `he_auth_rule` VALUES (48, 'file', 11, 'auth/group/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 107, 'normal');
INSERT INTO `he_auth_rule` VALUES (49, 'file', 11, 'auth/group/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 106, 'normal');
INSERT INTO `he_auth_rule` VALUES (50, 'file', 11, 'auth/group/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 105, 'normal');
INSERT INTO `he_auth_rule` VALUES (51, 'file', 12, 'auth/rule/index', 'View', 'fa fa-circle-o', '', '', 'Rule tips', 0, NULL, '', 1491635035, 1491635035, 103, 'normal');
INSERT INTO `he_auth_rule` VALUES (52, 'file', 12, 'auth/rule/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 102, 'normal');
INSERT INTO `he_auth_rule` VALUES (53, 'file', 12, 'auth/rule/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 101, 'normal');
INSERT INTO `he_auth_rule` VALUES (54, 'file', 12, 'auth/rule/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 100, 'normal');
INSERT INTO `he_auth_rule` VALUES (55, 'file', 4, 'addon/index', 'View', 'fa fa-circle-o', '', '', 'Addon tips', 0, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (56, 'file', 4, 'addon/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (57, 'file', 4, 'addon/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (58, 'file', 4, 'addon/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (59, 'file', 4, 'addon/downloaded', 'Local addon', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (60, 'file', 4, 'addon/state', 'Update state', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (63, 'file', 4, 'addon/config', 'Setting', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (64, 'file', 4, 'addon/refresh', 'Refresh', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (65, 'file', 4, 'addon/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (66, 'file', 0, 'user', 'User', 'fa fa-list', '', '', '', 1, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (67, 'file', 66, 'user/user', 'User', 'fa fa-user', '', '', '', 1, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (68, 'file', 67, 'user/user/index', 'View', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (69, 'file', 67, 'user/user/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (70, 'file', 67, 'user/user/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (71, 'file', 67, 'user/user/del', 'Del', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (72, 'file', 67, 'user/user/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (73, 'file', 66, 'user/group', 'User group', 'fa fa-users', '', '', '', 1, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (74, 'file', 73, 'user/group/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (75, 'file', 73, 'user/group/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (76, 'file', 73, 'user/group/index', 'View', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (77, 'file', 73, 'user/group/del', 'Del', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (78, 'file', 73, 'user/group/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (79, 'file', 66, 'user/rule', 'User rule', 'fa fa-circle-o', '', '', '', 1, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (80, 'file', 79, 'user/rule/index', 'View', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (81, 'file', 79, 'user/rule/del', 'Del', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (82, 'file', 79, 'user/rule/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (83, 'file', 79, 'user/rule/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (84, 'file', 79, 'user/rule/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (85, 'file', 0, 'command', '在线命令管理', 'fa fa-terminal', '', '', '', 1, 'addtabs', '', 1623724193, 1624424971, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (86, 'file', 85, 'command/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623724193, 1623724193, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (87, 'file', 85, 'command/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623724193, 1623724193, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (88, 'file', 85, 'command/detail', '详情', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623724193, 1623724193, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (89, 'file', 85, 'command/execute', '运行', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623724193, 1623724193, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (90, 'file', 85, 'command/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623724193, 1623724193, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (91, 'file', 85, 'command/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623724193, 1623724193, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (92, 'file', 0, 'cate', '栏目管理', 'fa fa-list-ol', '', '', '', 1, 'addtabs', '', 1623724295, 1624280174, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (93, 'file', 92, 'cate/import', 'Import', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623724295, 1623724295, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (94, 'file', 92, 'cate/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623724295, 1623724295, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (95, 'file', 92, 'cate/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623724295, 1623724295, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (96, 'file', 92, 'cate/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623724295, 1623724295, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (97, 'file', 92, 'cate/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623724295, 1623724295, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (98, 'file', 92, 'cate/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623724295, 1623724295, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (99, 'file', 0, 'article', '内容管理', 'fa fa-circle-o', '', '', '', 1, 'addtabs', '', 1623734077, 1624280197, 0, 'hidden');
INSERT INTO `he_auth_rule` VALUES (100, 'file', 99, 'article/import', 'Import', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623734077, 1623734077, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (101, 'file', 99, 'article/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623734077, 1623734077, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (102, 'file', 99, 'article/recyclebin', '回收站', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623734077, 1623734077, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (103, 'file', 99, 'article/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623734077, 1623734077, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (104, 'file', 99, 'article/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623734077, 1623734077, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (105, 'file', 99, 'article/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623734077, 1623734077, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (106, 'file', 99, 'article/destroy', '真实删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623734077, 1623734077, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (107, 'file', 99, 'article/restore', '还原', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623734077, 1623734077, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (108, 'file', 99, 'article/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623734077, 1623734077, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (109, 'file', 0, 'video', '视频下载', 'fa fa-file-video-o', '', '', '', 1, 'addtabs', '', 1624003896, 1624280360, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (110, 'file', 109, 'video/import', 'Import', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624003896, 1624003896, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (111, 'file', 109, 'video/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624003896, 1624003896, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (112, 'file', 109, 'video/recyclebin', '回收站', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624003896, 1624003896, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (113, 'file', 109, 'video/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624003896, 1624003896, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (114, 'file', 109, 'video/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624003896, 1624003896, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (115, 'file', 109, 'video/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624003896, 1624003896, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (116, 'file', 109, 'video/destroy', '真实删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624003896, 1624003896, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (117, 'file', 109, 'video/restore', '还原', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624003896, 1624003896, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (118, 'file', 109, 'video/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624003896, 1624003896, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (119, 'file', 0, 'teacher', '教师风采', 'fa fa-user-secret', '', '', '', 1, 'addtabs', '', 1624003998, 1624280343, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (120, 'file', 119, 'teacher/import', 'Import', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624003998, 1624003998, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (121, 'file', 119, 'teacher/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624003998, 1624003998, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (122, 'file', 119, 'teacher/recyclebin', '回收站', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624003998, 1624003998, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (123, 'file', 119, 'teacher/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624003998, 1624003998, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (124, 'file', 119, 'teacher/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624003998, 1624003998, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (125, 'file', 119, 'teacher/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624003998, 1624003998, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (126, 'file', 119, 'teacher/destroy', '真实删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624003998, 1624003998, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (127, 'file', 119, 'teacher/restore', '还原', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624003998, 1624003998, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (128, 'file', 119, 'teacher/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624003998, 1624003998, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (129, 'file', 0, 'file', '文件下载', 'fa fa-file-word-o', '', '', '', 1, 'addtabs', '', 1624238566, 1624280322, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (130, 'file', 129, 'file/import', 'Import', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624238566, 1624238566, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (131, 'file', 129, 'file/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624238566, 1624238566, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (132, 'file', 129, 'file/recyclebin', '回收站', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624238566, 1624238566, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (133, 'file', 129, 'file/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624238566, 1624238566, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (134, 'file', 129, 'file/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624238566, 1624238566, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (135, 'file', 129, 'file/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624238566, 1624238566, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (136, 'file', 129, 'file/destroy', '真实删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624238566, 1624238566, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (137, 'file', 129, 'file/restore', '还原', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624238566, 1624238566, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (138, 'file', 129, 'file/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624238566, 1624238566, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (139, 'file', 0, 'software', '软件下载', 'fa fa-apple', '', '', '', 1, 'addtabs', '', 1624238586, 1624280298, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (140, 'file', 139, 'software/import', 'Import', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624238586, 1624238586, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (141, 'file', 139, 'software/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624238586, 1624238586, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (142, 'file', 139, 'software/recyclebin', '回收站', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624238586, 1624238586, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (143, 'file', 139, 'software/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624238586, 1624238586, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (144, 'file', 139, 'software/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624238586, 1624238586, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (145, 'file', 139, 'software/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624238586, 1624238586, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (146, 'file', 139, 'software/destroy', '真实删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624238586, 1624238586, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (147, 'file', 139, 'software/restore', '还原', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624238586, 1624238586, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (148, 'file', 139, 'software/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624238586, 1624238586, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (149, 'file', 0, 'page', '单页管理', 'fa fa-pagelines', '', '', '', 1, 'addtabs', '', 1624239501, 1624280279, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (150, 'file', 149, 'page/import', 'Import', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624239501, 1624239501, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (151, 'file', 149, 'page/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624239501, 1624239501, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (152, 'file', 149, 'page/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624239501, 1624239501, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (153, 'file', 149, 'page/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624239501, 1624239501, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (154, 'file', 149, 'page/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624239501, 1624239501, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (155, 'file', 149, 'page/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624239501, 1624239501, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (156, 'file', 0, 'news', '信息动态', 'fa fa-newspaper-o', '', '', '', 1, 'addtabs', '', 1624262915, 1624280266, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (157, 'file', 156, 'news/import', 'Import', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624262915, 1624262915, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (158, 'file', 156, 'news/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624262915, 1624262915, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (159, 'file', 156, 'news/recyclebin', '回收站', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624262915, 1624262915, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (160, 'file', 156, 'news/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624262915, 1624262915, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (161, 'file', 156, 'news/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624262915, 1624262915, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (162, 'file', 156, 'news/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624262915, 1624262915, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (163, 'file', 156, 'news/destroy', '真实删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624262915, 1624262915, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (164, 'file', 156, 'news/restore', '还原', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624262915, 1624262915, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (165, 'file', 156, 'news/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624262915, 1624262915, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (166, 'file', 0, 'classcate', '课程分类', 'fa fa-circle-o', '', '', '', 1, NULL, '', 1624425003, 1624425003, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (167, 'file', 166, 'classcate/import', 'Import', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624425003, 1624425003, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (168, 'file', 166, 'classcate/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624425003, 1624425003, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (169, 'file', 166, 'classcate/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624425003, 1624425003, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (170, 'file', 166, 'classcate/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624425003, 1624425003, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (171, 'file', 166, 'classcate/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624425003, 1624425003, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (172, 'file', 166, 'classcate/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624425003, 1624425003, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (173, 'file', 0, 'classes', '课程列管理', 'fa fa-circle-o', '', '', '', 1, NULL, '', 1624425266, 1624425266, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (174, 'file', 173, 'classes/import', 'Import', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624425266, 1624425266, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (175, 'file', 173, 'classes/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624425266, 1624425266, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (176, 'file', 173, 'classes/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624425266, 1624425266, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (177, 'file', 173, 'classes/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624425266, 1624425266, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (178, 'file', 173, 'classes/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624425266, 1624425266, 0, 'normal');
INSERT INTO `he_auth_rule` VALUES (179, 'file', 173, 'classes/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624425266, 1624425266, 0, 'normal');
COMMIT;
-- ----------------------------
-- Table structure for he_cate
-- ----------------------------
DROP TABLE IF EXISTS `he_cate`;
CREATE TABLE `he_cate` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` enum('channel','page','link','list') DEFAULT NULL COMMENT '类型',
`model_id` int(10) unsigned DEFAULT '0' COMMENT '模型ID',
`parent_id` int(10) unsigned DEFAULT '0' COMMENT '父ID',
`name` varchar(30) DEFAULT '' COMMENT '栏目名称',
`image` varchar(100) DEFAULT '' COMMENT '图片',
`flag` varchar(100) DEFAULT '' COMMENT '标志',
`seotitle` varchar(255) DEFAULT '' COMMENT 'SEO标题',
`keywords` varchar(255) DEFAULT '' COMMENT '关键字',
`description` varchar(255) DEFAULT '' COMMENT '描述',
`outlink` varchar(255) DEFAULT '' COMMENT '链接',
`items` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '文章数量',
`weigh` int(10) DEFAULT NULL,
`tpl` varchar(100) DEFAULT '' COMMENT '栏目页模板',
`listtpl` varchar(100) DEFAULT '' COMMENT '列表页模板',
`showtpl` varchar(100) DEFAULT '' COMMENT '详情页模板',
`pagesize` smallint(5) NOT NULL DEFAULT '10' COMMENT '分页大小',
`isnav_switch` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否导航显示',
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
`status` enum('1','2') DEFAULT '1' COMMENT '状态:1=正常,2=隐藏',
`diyname` varchar(100) DEFAULT NULL COMMENT '自定义名称',
`table_name` varchar(255) DEFAULT NULL COMMENT '数据库表名',
PRIMARY KEY (`id`),
KEY `weigh` (`weigh`,`id`),
KEY `parent_id` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COMMENT='栏目管理';
-- ----------------------------
-- Records of he_cate
-- ----------------------------
BEGIN;
INSERT INTO `he_cate` VALUES (1, 'page', 0, 54, '企业合作申请', '/cms/images/hzkv.jpg', '', '', '', '课程和实训平台实现从基础、应用、算法到计算机视觉、语音识别、自然语言处理、大数据分析等领域的覆盖,有效解决了职业学校及社会不同层次人员对人工智能学习的需求。', '', 0, 52, '', 'apply', 'show', 10, 1, 1623724763, 1624068399, '1', 'apply', 'he_admin');
INSERT INTO `he_cate` VALUES (38, 'list', 0, 0, '教师风采', '/cms/images/5.jpg', '', '', '', '', '', 0, 59, '', 'teacher', 'show', 8, 1, 1623726601, 1624066560, '1', 'teacher', 'he_teacher');
INSERT INTO `he_cate` VALUES (41, 'list', 0, 0, '课程中心', '/cms/images/kcpic.jpg', '', '', '', '', '', 0, 58, '', 'course', 'show', 6, 1, 1623726784, 1624065745, '1', 'course', 'he_course');
INSERT INTO `he_cate` VALUES (42, 'list', 0, 0, '资源中心', '/cms/images/kcpic.jpg', '', '', '', '', '', 0, 56, '', '', 'show', 10, 1, 1623726909, 1623726909, '1', '', NULL);
INSERT INTO `he_cate` VALUES (44, 'link', 0, 42, '实训平台入口', '/cms/images/kcpic.jpg', '', '', '', '', 'https://www.baidu.com/', 0, 49, '', 'company', 'show', 10, 1, 1623727069, 1623922239, '1', 'shixun', NULL);
INSERT INTO `he_cate` VALUES (45, 'list', 0, 42, '其他资料下载', '/cms/images/kcpic.jpg', '', '', '', '', '', 0, 28, '', '', 'show', 10, 1, 1623727132, 1623727852, '1', 'qita', NULL);
INSERT INTO `he_cate` VALUES (47, 'list', 0, 45, '视频下', '', '', '', '', '', '', 0, 53, '', 'video', 'show', 10, 1, 1623750574, 1623980221, '1', '123', 'he_video');
INSERT INTO `he_cate` VALUES (50, 'list', 0, 45, '文件下载', '', '', '', '', '', '', 0, 50, '', 'file', 'show', 10, 1, 1623750615, 1623750615, '1', '12', 'he_file');
INSERT INTO `he_cate` VALUES (52, 'page', 0, 0, 'TpMeCms介绍', '/cms/images/about-1.jpg', '', '', '', 'TpMeCms依托江苏省模式识别与计算智能工程实验室的高水平师资队伍及其丰富的产教融合经验来打造一套体系完备的人工智能教育课程体系与实训平台。课程和实训平台实现从基础、应用、算法到计算机视觉、语音识别、自然语言处理、大数据分析等领域的覆盖,有效解决了职业学校及社会不同层次人员对人工智能学习的需求。', '', 0, 60, '', 'about', 'about', 1, 1, 1624065594, 1624431241, '1', 'about', 'he_page');
INSERT INTO `he_cate` VALUES (54, 'list', 0, 0, '强强联合', '/cms/images/hzkv.jpg', '', '', '', '', '', 0, 50, '', 'company', 'show', 12, 1, 1624066078, 1624067434, '1', 'company', 'he_company');
INSERT INTO `he_cate` VALUES (55, 'list', 0, 54, '合作单位介绍', '/cms/images/hzkv.jpg', '', '', '', '', '', 0, 49, '', 'company', 'show', 12, 1, 1624066078, 1624067223, '1', 'company2', 'he_company');
INSERT INTO `he_cate` VALUES (56, 'list', 0, 0, '用户中心', '', '', '', '', '', '', 0, 40, '', 'line', 'show', 10, 1, 1624068510, 1624068910, '1', '', 'he_user');
INSERT INTO `he_cate` VALUES (57, 'page', 0, 56, '线上报名', '', '', '', '', '', '', 0, 54, '', 'line', 'signup', 10, 1, 1624068623, 1624068623, '1', 'line', 'he_line');
INSERT INTO `he_cate` VALUES (58, 'list', 0, 56, '体验评价', '', '', '', '', '', '', 0, 53, '', 'evaluate', 'show', 10, 1, 1624068689, 1624068689, '1', 'evaluate', 'he_evaluate');
INSERT INTO `he_cate` VALUES (59, 'list', 0, 0, '信息动态', '', '', '', '', '', '', 0, 28, '', 'news', 'show', 7, 1, 1624068742, 1624263135, '1', 'news', 'he_news');
INSERT INTO `he_cate` VALUES (60, 'list', 0, 45, '软件下载', '', '', '', '', '', '', 0, 60, '', 'software', 'show', 10, 1, 1624238540, 1624238540, '1', 'software', 'he_software');
COMMIT;
-- ----------------------------
-- Table structure for he_category
-- ----------------------------
DROP TABLE IF EXISTS `he_category`;
CREATE TABLE `he_category` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父ID',
`type` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '栏目类型',
`name` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '',
`nickname` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '',
`flag` set('hot','index','recommend') COLLATE utf8mb4_unicode_ci DEFAULT '',
`image` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '图片',
`keywords` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '关键字',
`description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '描述',
`diyname` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '自定义名称',
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
`weigh` int(10) NOT NULL DEFAULT '0' COMMENT '权重',
`status` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '状态',
PRIMARY KEY (`id`),
KEY `weigh` (`weigh`,`id`),
KEY `pid` (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='分类表';
-- ----------------------------
-- Records of he_category
-- ----------------------------
BEGIN;
INSERT INTO `he_category` VALUES (1, 0, 'page', '官方新闻', 'news', 'recommend', '/assets/img/qrcode.png', '', '', 'news', 1491635035, 1491635035, 1, 'normal');
INSERT INTO `he_category` VALUES (2, 0, 'page', '移动应用', 'mobileapp', 'hot', '/assets/img/qrcode.png', '', '', 'mobileapp', 1491635035, 1491635035, 2, 'normal');
INSERT INTO `he_category` VALUES (3, 2, 'page', '微信公众号', 'wechatpublic', 'index', '/assets/img/qrcode.png', '', '', 'wechatpublic', 1491635035, 1491635035, 3, 'normal');
INSERT INTO `he_category` VALUES (4, 2, 'page', 'Android开发', 'android', 'recommend', '/assets/img/qrcode.png', '', '', 'android', 1491635035, 1491635035, 4, 'normal');
INSERT INTO `he_category` VALUES (5, 0, 'page', '软件产品', 'software', 'recommend', '/assets/img/qrcode.png', '', '', 'software', 1491635035, 1491635035, 5, 'normal');
INSERT INTO `he_category` VALUES (6, 5, 'page', '网站建站', 'website', 'recommend', '/assets/img/qrcode.png', '', '', 'website', 1491635035, 1491635035, 6, 'normal');
INSERT INTO `he_category` VALUES (7, 5, 'page', '企业管理软件', 'company', 'index', '/assets/img/qrcode.png', '', '', 'company', 1491635035, 1491635035, 7, 'normal');
INSERT INTO `he_category` VALUES (8, 6, 'page', 'PC端', 'website-pc', 'recommend', '/assets/img/qrcode.png', '', '', 'website-pc', 1491635035, 1491635035, 8, 'normal');
INSERT INTO `he_category` VALUES (9, 6, 'page', '移动端', 'website-mobile', 'recommend', '/assets/img/qrcode.png', '', '', 'website-mobile', 1491635035, 1491635035, 9, 'normal');
INSERT INTO `he_category` VALUES (10, 7, 'page', 'CRM系统 ', 'company-crm', 'recommend', '/assets/img/qrcode.png', '', '', 'company-crm', 1491635035, 1491635035, 10, 'normal');
INSERT INTO `he_category` VALUES (11, 7, 'page', 'SASS平台软件', 'company-sass', 'recommend', '/assets/img/qrcode.png', '', '', 'company-sass', 1491635035, 1491635035, 11, 'normal');
INSERT INTO `he_category` VALUES (12, 0, 'test', 'TpMeCMS1', 'test1', 'recommend', '/assets/img/qrcode.png', '', '', 'test1', 1491635035, 1491635035, 12, 'normal');
INSERT INTO `he_category` VALUES (13, 0, 'test', 'TpMeCMS2', 'test2', 'recommend', '/assets/img/qrcode.png', '', '', 'test2', 1491635035, 1491635035, 13, 'normal');
COMMIT;
-- ----------------------------
-- Table structure for he_classcate
-- ----------------------------
DROP TABLE IF EXISTS `he_classcate`;
CREATE TABLE `he_classcate` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`catename` varchar(30) DEFAULT NULL COMMENT '分类名',
`weigh` int(10) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='课程分类';
-- ----------------------------
-- Records of he_classcate
-- ----------------------------
BEGIN;
INSERT INTO `he_classcate` VALUES (1, '人工智能-初级工程师', 1);
INSERT INTO `he_classcate` VALUES (2, '人工智能-中级工程师', 2);
INSERT INTO `he_classcate` VALUES (3, '人工智能-高级工程师', 3);
COMMIT;
-- ----------------------------
-- Table structure for he_classes
-- ----------------------------
DROP TABLE IF EXISTS `he_classes`;
CREATE TABLE `he_classes` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`classcate_id` int(10) DEFAULT NULL COMMENT '课程分类id',
`name` varchar(30) DEFAULT NULL COMMENT '课程名',
`weigh` int(10) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='课程列表';
-- ----------------------------
-- Records of he_classes
-- ----------------------------
BEGIN;
INSERT INTO `he_classes` VALUES (1, 1, 'python基础', 1);
INSERT INTO `he_classes` VALUES (2, 1, '数学基础(一)', 2);
INSERT INTO `he_classes` VALUES (3, 2, 'python采集数据', 3);
INSERT INTO `he_classes` VALUES (4, 3, 'AI智能应用', 4);
INSERT INTO `he_classes` VALUES (5, 3, '机器学习基础与应用', 5);
COMMIT;
-- ----------------------------
-- Table structure for he_command
-- ----------------------------
DROP TABLE IF EXISTS `he_command`;
CREATE TABLE `he_command` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`type` varchar(30) NOT NULL DEFAULT '' COMMENT '类型',
`params` varchar(1500) NOT NULL DEFAULT '' COMMENT '参数',
`command` varchar(1500) NOT NULL DEFAULT '' COMMENT '命令',
`content` text COMMENT '返回结果',
`executetime` int(10) unsigned DEFAULT NULL COMMENT '执行时间',
`createtime` int(10) unsigned DEFAULT NULL COMMENT '创建时间',
`updatetime` int(10) unsigned DEFAULT NULL COMMENT '更新时间',
`status` enum('successed','failured') NOT NULL DEFAULT 'failured' COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 COMMENT='在线命令表';
-- ----------------------------
-- Records of he_command
-- ----------------------------
BEGIN;
INSERT INTO `he_command` VALUES (1, 'crud', '[\"--force=1\",\"--table=he_cate\",\"--fields=id,name,image,tpl,isnav,createtime,status\"]', 'php think crud --force=1 --table=he_cate --fields=id,name,image,tpl,isnav,createtime,status', 'Build Successed', 1623724286, 1623724286, 1623724286, 'successed');
COMMIT;
-- ----------------------------
-- Table structure for he_company
-- ----------------------------
DROP TABLE IF EXISTS `he_company`;
CREATE TABLE `he_company` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT '' COMMENT '文章标题',
`image` varchar(255) DEFAULT '' COMMENT '缩略图',
`images` varchar(1500) DEFAULT '' COMMENT '组图',
`seotitle` varchar(255) DEFAULT '' COMMENT 'SEO标题',
`keywords` varchar(255) DEFAULT '' COMMENT '关键字',
`description` varchar(255) DEFAULT '' COMMENT '描述',
`tags` varchar(255) DEFAULT '' COMMENT 'TAG',
`weigh` int(10) DEFAULT NULL,
`views` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览次数',
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
`publishtime` int(10) DEFAULT NULL COMMENT '发布时间',
`deletetime` int(10) DEFAULT NULL COMMENT '删除时间',
`memo` varchar(100) DEFAULT '' COMMENT '备注',
`content` text COMMENT '内容',
`status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '状态:1=正常,2=隐藏',
PRIMARY KEY (`id`),
KEY `status` (`status`),
KEY `channel` (`weigh`,`id`),
KEY `weigh` (`weigh`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8mb4 COMMENT='合作单位介绍';
-- ----------------------------
-- Records of he_company
-- ----------------------------
BEGIN;
INSERT INTO `he_company` VALUES (1, 'TpMeCMS22', '/cms/images/services-1.jpg', '/cms/images/services-1.jpg', '', '', 'TpMeCMS', '', 0, 0, NULL, 1624004225, NULL, NULL, '', 'TpMeCMSTpMeCMSTpMeCMS', '1');
INSERT INTO `he_company` VALUES (111, '联系我们', '/cms/images/services-1.jpg', '/cms/images/services-1.jpg', '/cms/images/services-1.jpg', '/cms/images/services-1.jpg', '/cms/images/services-1.jpg', '', 111, 0, 1624004284, 1624004284, 1624004236, NULL, '', '<p>/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-<b>1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg</b><br></p>', '1');
COMMIT;
-- ----------------------------
-- Table structure for he_config
-- ----------------------------
DROP TABLE IF EXISTS `he_config`;
CREATE TABLE `he_config` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '变量名',
`group` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '分组',
`title` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '变量标题',
`tip` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '变量描述',
`type` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '类型:string,text,int,bool,array,datetime,date,file',
`value` text COLLATE utf8mb4_unicode_ci COMMENT '变量值',
`content` text COLLATE utf8mb4_unicode_ci COMMENT '变量字典数据',
`rule` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '验证规则',
`extend` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '扩展属性',
`setting` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '配置',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统配置';
-- ----------------------------
-- Records of he_config
-- ----------------------------
BEGIN;
INSERT INTO `he_config` VALUES (1, 'name', 'basic', 'Site name', '请填写站点名称', 'string', 'TpMeCms', '', 'required', '', NULL);
INSERT INTO `he_config` VALUES (2, 'beian', 'basic', 'Beian', '粤ICP备15000000号-1', 'string', '苏ICP备18048854号', '', '', '', NULL);
INSERT INTO `he_config` VALUES (3, 'cdnurl', 'basic', 'Cdn url', '如果全站静态资源使用第三方云储存请配置该值', 'string', '', '', '', '', NULL);
INSERT INTO `he_config` VALUES (4, 'version', 'basic', 'Version', '如果静态资源有变动请重新配置该值', 'string', '1.0.1', '', 'required', '', NULL);
INSERT INTO `he_config` VALUES (5, 'timezone', 'basic', 'Timezone', '', 'string', 'Asia/Shanghai', '', 'required', '', NULL);
INSERT INTO `he_config` VALUES (6, 'forbiddenip', 'basic', 'Forbidden ip', '一行一条记录', 'text', '', '', '', '', NULL);
INSERT INTO `he_config` VALUES (7, 'languages', 'basic', 'Languages', '', 'array', '{\"backend\":\"zh-cn\",\"frontend\":\"zh-cn\"}', '', 'required', '', NULL);
INSERT INTO `he_config` VALUES (8, 'fixedpage', 'basic', 'Fixed page', '请尽量输入左侧菜单栏存在的链接', 'string', 'dashboard', '', 'required', '', NULL);
INSERT INTO `he_config` VALUES (9, 'categorytype', 'dictionary', 'Category type', '', 'array', '{\"default\":\"Default\",\"page\":\"Page\",\"article\":\"Article\",\"test\":\"Test\"}', '', '', '', NULL);
INSERT INTO `he_config` VALUES (10, 'configgroup', 'dictionary', 'Config group', '', 'array', '{\"basic\":\"Basic\",\"email\":\"Email\",\"dictionary\":\"Dictionary\",\"user\":\"User\",\"example\":\"Example\",\"weixin\":\"Weixin\"}', '', '', '', NULL);
INSERT INTO `he_config` VALUES (11, 'mail_type', 'email', 'Mail type', '选择邮件发送方式', 'select', '1', '[\"请选择\",\"SMTP\"]', '', '', '');
INSERT INTO `he_config` VALUES (12, 'mail_smtp_host', 'email', 'Mail smtp host', '错误的配置发送邮件会导致服务器超时', 'string', 'smtp.qq.com', '', '', '', '');
INSERT INTO `he_config` VALUES (13, 'mail_smtp_port', 'email', 'Mail smtp port', '(不加密默认25,SSL默认465,TLS默认587)', 'string', '465', '', '', '', '');
INSERT INTO `he_config` VALUES (14, 'mail_smtp_user', 'email', 'Mail smtp user', '(填写完整用户名)', 'string', '10000', '', '', '', '');
INSERT INTO `he_config` VALUES (15, 'mail_smtp_pass', 'email', 'Mail smtp password', '(填写您的密码或授权码)', 'string', 'password', '', '', '', '');
INSERT INTO `he_config` VALUES (16, 'mail_verify_type', 'email', 'Mail vertify type', '(SMTP验证方式[推荐SSL])', 'select', '2', '[\"\",\"TLS\",\"SSL\"]', '', '', '');
INSERT INTO `he_config` VALUES (17, 'mail_from', 'email', 'Mail from', '', 'string', '10000@qq.com', '', '', '', '');
INSERT INTO `he_config` VALUES (18, 'app_id', 'weixin', '小程序Appid', '小程序Appid', 'string', 'wx4966310850000000', '', '', '', NULL);
INSERT INTO `he_config` VALUES (19, 'secret', 'weixin', '小程序密匙', '小程序密匙secret', 'string', 'xxxxxxxxxxxxxxxxxxxxxxxxx', '', '', '', NULL);
INSERT INTO `he_config` VALUES (20, 'mch_id', 'weixin', '微信商户号', '微信商户号', 'string', '1679466040', '', '', '', NULL);
INSERT INTO `he_config` VALUES (21, 'key', 'weixin', 'API 密钥', '微信商户号密匙', 'string', 'xxxxxxxxxxxxxxxxxxxxxx', '', '', '', NULL);
INSERT INTO `he_config` VALUES (22, 'wx_app_id', 'weixin', '公众号Appid', '微信公众号Appid', 'string', 'wxe8ed1781937ff05c', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
INSERT INTO `he_config` VALUES (23, 'wx_secret', 'weixin', '公众号密匙', '微信公众号的密匙', 'string', 'de073be26de9bf6866de10c19fd04b72', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
INSERT INTO `he_config` VALUES (24, 'tel', 'basic', '联系手机', '联系手机号码', 'string', '19999999999', '', 'mobile', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
INSERT INTO `he_config` VALUES (25, 'index_url', 'basic', '网站首页地址', '网站首页地址', 'string', '/cms/index/index', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
INSERT INTO `he_config` VALUES (26, 'wxqr_img', 'weixin', '公众号二维码', '关注微信公众号二维码', 'image', '/uploads/20210622/a572d67db33e94f6dc8dd2e908c03ff2.jpg', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
INSERT INTO `he_config` VALUES (27, 'addr', 'basic', '联系地址', '联系地址', 'string', '无锡市新吴区菱湖大道200号', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
INSERT INTO `he_config` VALUES (28, 'addr2', 'basic', '联系地址2', '联系地址2', 'string', '中国传感网国际创新园E2-103-1113', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
INSERT INTO `he_config` VALUES (29, 'email', 'basic', '邮箱', '邮箱地址', 'string', 'sale@unientr.com', '', 'email', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
INSERT INTO `he_config` VALUES (30, 'banquan', 'basic', '版权', '底部版权信息', 'string', 'TpMeCms © 2021 版权所有', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
INSERT INTO `he_config` VALUES (31, 'technical_support', 'basic', '技术支持', '技术支持', 'string', '技术支持:TpMeCMS', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
COMMIT;
-- ----------------------------
-- Table structure for he_course
-- ----------------------------
DROP TABLE IF EXISTS `he_course`;
CREATE TABLE `he_course` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`cate_id` int(10) unsigned NOT NULL COMMENT '栏目ID',
`title` varchar(255) DEFAULT '' COMMENT '文章标题',
`image` varchar(255) DEFAULT '' COMMENT '缩略图',
`images` varchar(1500) DEFAULT '' COMMENT '组图',
`seotitle` varchar(255) DEFAULT '' COMMENT 'SEO标题',
`keywords` varchar(255) DEFAULT '' COMMENT '关键字',
`description` varchar(255) DEFAULT '' COMMENT '描述',
`tags` varchar(255) DEFAULT '' COMMENT 'TAG',
`weigh` int(10) DEFAULT NULL,
`views` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览次数',
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
`publishtime` int(10) DEFAULT NULL COMMENT '发布时间',
`deletetime` int(10) DEFAULT NULL COMMENT '删除时间',
`memo` varchar(100) DEFAULT '' COMMENT '备注',
`content` text COMMENT '内容',
`status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '状态:1=正常,2=隐藏',
PRIMARY KEY (`id`),
KEY `status` (`cate_id`,`status`),
KEY `channel` (`cate_id`,`weigh`,`id`),
KEY `weigh` (`weigh`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8mb4 COMMENT='课程中心';
-- ----------------------------
-- Records of he_course
-- ----------------------------
BEGIN;
INSERT INTO `he_course` VALUES (1, 38, 'kezcheng', '/cms/images/news-8.jpg', '/cms/images/news-8.jpg', '', '', 'TpMeCMS', '', 0, 0, NULL, 1624004225, NULL, NULL, '', 'TpMeCMSTpMeCMSTpMeCMS', '1');
INSERT INTO `he_course` VALUES (111, 38, '联系我们', '/cms/images/news-8.jpg', '/cms/images/news-8.jpg', '/cms/images/services-1.jpg', '/cms/images/services-1.jpg', '/cms/images/services-1.jpg', '', 111, 1, 1624004284, 1624004284, 1624004236, NULL, '', '<p>/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-<b>1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg</b><br></p>', '1');
COMMIT;
-- ----------------------------
-- Table structure for he_ems
-- ----------------------------
DROP TABLE IF EXISTS `he_ems`;
CREATE TABLE `he_ems` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`event` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '事件',
`email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '邮箱',
`code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '验证码',
`times` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '验证次数',
`ip` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'IP',
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='邮箱验证码表';
-- ----------------------------
-- Records of he_ems
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for he_evaluate
-- ----------------------------
DROP TABLE IF EXISTS `he_evaluate`;
CREATE TABLE `he_evaluate` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL COMMENT '标题',
`name` varchar(10) DEFAULT '' COMMENT '姓名',
`image` varchar(255) DEFAULT '' COMMENT '头像',
`images` varchar(1500) DEFAULT '' COMMENT '组图',
`seotitle` varchar(255) DEFAULT '' COMMENT 'SEO标题',
`keywords` varchar(255) DEFAULT '' COMMENT '关键字',
`description` varchar(255) DEFAULT '' COMMENT '描述',
`tags` varchar(255) DEFAULT '' COMMENT 'TAG',
`weigh` int(10) DEFAULT NULL,
`views` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览次数',
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
`publishtime` int(10) DEFAULT NULL COMMENT '发布时间',
`deletetime` int(10) DEFAULT NULL COMMENT '删除时间',
`memo` varchar(100) DEFAULT '' COMMENT '备注',
`content` text COMMENT '内容',
`status` enum('1','2') NOT NULL DEFAULT '2' COMMENT '状态:1=正常,2=隐藏',
`email` varchar(20) DEFAULT NULL COMMENT '邮箱',
`reply` varchar(255) DEFAULT NULL COMMENT '回复',
`reply_time` int(10) unsigned DEFAULT NULL COMMENT '回复时间',
`read_status` enum('1','2','3') DEFAULT '1' COMMENT '处理状态:1=待处理,2=通过,3=拒绝',
`uid` int(10) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`id`),
KEY `status` (`status`),
KEY `channel` (`weigh`,`id`),
KEY `weigh` (`weigh`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=utf8mb4 COMMENT='体验评价';
-- ----------------------------
-- Records of he_evaluate
-- ----------------------------
BEGIN;
INSERT INTO `he_evaluate` VALUES (1, NULL, 'TpMeCMS22', '/cms/images/services-1.jpg', '/cms/images/services-1.jpg', '', '', 'TpMeCMS', '', 0, 0, NULL, 1624004225, NULL, NULL, '', '、博士生导师牵头组成高水平师资队伍,项目得到教育部学校建设规划发展中心在未来教育人工智能方向的支持。', '1', '', '培训团队由十几名教授、博士生导师牵头组成高水平师资队伍,项目得到教育部学校建设规划发展中心在未来教育人工智能方向的支持。', 1621004284, '1', NULL);
INSERT INTO `he_evaluate` VALUES (111, NULL, '联系我们', '/cms/images/services-1.jpg', '/cms/images/services-1.jpg', '/cms/images/services-1.jpg', '/cms/images/services-1.jpg', '/cms/images/services-1.jpg', '', 111, 0, 1624004284, 1624004284, 1624004236, NULL, '', '培训团队由十几名教授、博士生导师牵头组成高水平师资队伍,项目得到教育部学校建设规划发展中心在未来教育人工智能方向的支持。', '1', NULL, '可以', 1624004284, '1', NULL);
INSERT INTO `he_evaluate` VALUES (112, '', 'xiaohe', '', '', '', '', '', '', NULL, 0, 1624414132, NULL, NULL, NULL, '', 'adsasd', '2', 'asasd@qq.com', NULL, NULL, '1', 2);
INSERT INTO `he_evaluate` VALUES (113, '', '1', '', '', '', '', '', '', NULL, 0, 1624414461, NULL, NULL, NULL, '', '爱仕达', '2', 'xiaohe2@qq.com', NULL, NULL, '1', 2);
COMMIT;
-- ----------------------------
-- Table structure for he_file
-- ----------------------------
DROP TABLE IF EXISTS `he_file`;
CREATE TABLE `he_file` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT '' COMMENT '文章标题',
`image` varchar(255) DEFAULT '' COMMENT '缩略图',
`images` varchar(1500) DEFAULT '' COMMENT '组图',
`seotitle` varchar(255) DEFAULT '' COMMENT 'SEO标题',
`keywords` varchar(255) DEFAULT '' COMMENT '关键字',
`description` varchar(255) DEFAULT '' COMMENT '描述',
`tags` varchar(255) DEFAULT '' COMMENT 'TAG',
`weigh` int(10) DEFAULT NULL,
`views` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览次数',
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
`publishtime` int(10) DEFAULT NULL COMMENT '发布时间',
`deletetime` int(10) DEFAULT NULL COMMENT '删除时间',
`memo` varchar(100) DEFAULT '' COMMENT '备注',
`file` varchar(255) DEFAULT NULL COMMENT '文件',
`status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '状态:1=正常,2=隐藏',
PRIMARY KEY (`id`),
KEY `status` (`status`),
KEY `channel` (`weigh`,`id`),
KEY `weigh` (`weigh`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8mb4 COMMENT='文件下载';
-- ----------------------------
-- Records of he_file
-- ----------------------------
BEGIN;
INSERT INTO `he_file` VALUES (1, 'TpMeCMS', '/cms/images/services-1.jpg', '/cms/images/services-1.jpg', '', '', 'TpMeCMS', '', NULL, 1, NULL, NULL, NULL, NULL, '', 'TpMeCMSTpMeCMSTpMeCMS', '1');
COMMIT;
-- ----------------------------
-- Table structure for he_line
-- ----------------------------
DROP TABLE IF EXISTS `he_line`;
CREATE TABLE `he_line` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(30) DEFAULT NULL COMMENT '姓名',
`tel` varchar(15) DEFAULT NULL COMMENT '电话',
`email` varchar(32) DEFAULT '' COMMENT '邮箱',
`year` int(3) DEFAULT NULL COMMENT '年龄',
`card` varchar(50) DEFAULT '' COMMENT '证件号',
`sex` enum('0','1','2') DEFAULT '0' COMMENT '性别:1=男,2=女,0=未知',
`weigh` int(10) DEFAULT NULL,
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
`deletetime` int(10) DEFAULT NULL COMMENT '删除时间',
`memo` varchar(100) DEFAULT '' COMMENT '备注',
`school` varchar(20) DEFAULT NULL COMMENT '学校名称',
`status` enum('1','2') DEFAULT '1' COMMENT '状态:1=未读,2=已读',
`work` varchar(15) DEFAULT NULL COMMENT '工作状态',
`uid` int(10) DEFAULT NULL COMMENT '用户id',
`classes_ids` varchar(255) DEFAULT NULL COMMENT '课程id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=utf8mb4 COMMENT='在线报名';
-- ----------------------------
-- Records of he_line
-- ----------------------------
BEGIN;
INSERT INTO `he_line` VALUES (112, 'xiaohe', '19983297340', 'xiaohe2@qq.com', 5, '4234', '1', NULL, 1624429565, NULL, NULL, '', '爱仕达', '1', '在校', 2, '5,4,3,2,1');
INSERT INTO `he_line` VALUES (113, 'xiaohe', '19983297340', 'xiaohe2@qq.com', 19, '4234', '1', NULL, 1624429585, NULL, NULL, '', '爱仕达', '1', '在职', 2, '5,4');
COMMIT;
-- ----------------------------
-- Table structure for he_news
-- ----------------------------
DROP TABLE IF EXISTS `he_news`;
CREATE TABLE `he_news` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT '' COMMENT '文章标题',
`image` varchar(255) DEFAULT '' COMMENT '缩略图',
`images` varchar(1500) DEFAULT '' COMMENT '组图',
`seotitle` varchar(255) DEFAULT '' COMMENT 'SEO标题',
`keywords` varchar(255) DEFAULT '' COMMENT '关键字',
`description` varchar(255) DEFAULT '' COMMENT '描述',
`tags` varchar(255) DEFAULT '' COMMENT 'TAG',
`weigh` int(10) DEFAULT NULL,
`views` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览次数',
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
`publishtime` int(10) DEFAULT NULL COMMENT '发布时间',
`deletetime` int(10) DEFAULT NULL COMMENT '删除时间',
`memo` varchar(100) DEFAULT '' COMMENT '备注',
`content` text COMMENT '内容',
`status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '状态:1=正常,2=隐藏',
PRIMARY KEY (`id`),
KEY `status` (`status`),
KEY `channel` (`weigh`,`id`),
KEY `weigh` (`weigh`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=utf8mb4 COMMENT='信息动态';
-- ----------------------------
-- Records of he_news
-- ----------------------------
BEGIN;
INSERT INTO `he_news` VALUES (1, 'TpMeCMS22', '/cms/images/services-1.jpg', '/cms/images/services-1.jpg', '', '', 'TpMeCMS', '小米智能,xiao', 0, 2, NULL, 1624004225, NULL, NULL, '', 'TpMeCMSTpMeCMSTpMeCMS', '1');
INSERT INTO `he_news` VALUES (111, '联系我们', '/cms/images/services-2.jpg', '/cms/images/services-1.jpg', '/cms/images/services-1.jpg', '/cms/images/services-1.jpg', '/cms/images/services-1.jpg', '标签,分割', 111, 1, 1624004284, 1624004284, 1624004236, NULL, '', '<p>/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-<b>1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg</b><br></p>', '1');
INSERT INTO `he_news` VALUES (112, '员工列表', '/cms/images/news-2.jpg', '/cms/images/services-1.jpg', 'International standard laboratory', '公共服务平台关键字', '/cms/images/services-1.jpg', '', 112, 3, 1624263266, 1624263266, 1624263230, NULL, '', '<p>zheshi miaos&nbsp;</p>', '1');
COMMIT;
-- ----------------------------
-- Table structure for he_page
-- ----------------------------
DROP TABLE IF EXISTS `he_page`;
CREATE TABLE `he_page` (
`id` int(8) unsigned NOT NULL AUTO_INCREMENT,
`cate_id` tinyint(10) unsigned NOT NULL DEFAULT '0' COMMENT '栏目',
`title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
`content` text NOT NULL COMMENT '内容',
`description` varchar(255) DEFAULT NULL COMMENT '简介',
`createtime` int(11) DEFAULT NULL,
`updatetime` int(11) unsigned DEFAULT '0' COMMENT '更新时间',
`weigh` int(10) DEFAULT '50',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='单页管理';
-- ----------------------------
-- Records of he_page
-- ----------------------------
BEGIN;
INSERT INTO `he_page` VALUES (2, 52, '学校定位:人工智能教育与服务引擎', '<p><span style=\"color: rgb(119, 119, 119); font-family: &quot;Open Sans&quot;, sans-serif; font-size: 17px;\">TpMeCms依托江苏省模式识别与计算智能工程实验室的高水平师资队伍及其丰富的产教融合经验来打造一套体系完备的人工智能教育课程体系与实训平台。课程和实训平台实现从基础、应用、算法到计算机视觉、语音识别、自然语言处理、大数据分析等领域的覆盖,有效解决了职业学校及社会不同层次人员对人工智能学习的需求。</span><br></p>\r\n', '', 1580966471, 1624239577, 11);
COMMIT;
-- ----------------------------
-- Table structure for he_sms
-- ----------------------------
DROP TABLE IF EXISTS `he_sms`;
CREATE TABLE `he_sms` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`event` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '事件',
`mobile` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '手机号',
`code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '验证码',
`times` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '验证次数',
`ip` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'IP',
`createtime` int(10) unsigned DEFAULT '0' COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短信验证码表';
-- ----------------------------
-- Records of he_sms
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for he_software
-- ----------------------------
DROP TABLE IF EXISTS `he_software`;
CREATE TABLE `he_software` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT '' COMMENT '文章标题',
`image` varchar(255) DEFAULT '' COMMENT '缩略图',
`images` varchar(1500) DEFAULT '' COMMENT '组图',
`seotitle` varchar(255) DEFAULT '' COMMENT 'SEO标题',
`keywords` varchar(255) DEFAULT '' COMMENT '关键字',
`description` varchar(255) DEFAULT '' COMMENT '描述',
`tags` varchar(255) DEFAULT '' COMMENT 'TAG',
`weigh` int(10) DEFAULT NULL,
`views` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览次数',
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
`publishtime` int(10) DEFAULT NULL COMMENT '发布时间',
`deletetime` int(10) DEFAULT NULL COMMENT '删除时间',
`memo` varchar(100) DEFAULT '' COMMENT '备注',
`file` varchar(255) DEFAULT NULL COMMENT '文件',
`status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '状态:1=正常,2=隐藏',
PRIMARY KEY (`id`),
KEY `status` (`status`),
KEY `channel` (`weigh`,`id`),
KEY `weigh` (`weigh`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8mb4 COMMENT='软件下载';
-- ----------------------------
-- Records of he_software
-- ----------------------------
BEGIN;
INSERT INTO `he_software` VALUES (1, 'TpMeCMS', '/cms/images/s01.jpg', '', '', '', 'TpMeCMS', '', 0, 0, NULL, 1624238640, NULL, NULL, '', '/cms/images/s01.jpg', '1');
COMMIT;
-- ----------------------------
-- Table structure for he_teacher
-- ----------------------------
DROP TABLE IF EXISTS `he_teacher`;
CREATE TABLE `he_teacher` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`cate_id` int(10) unsigned NOT NULL COMMENT '栏目ID',
`title` varchar(255) DEFAULT '' COMMENT '文章标题',
`image` varchar(255) DEFAULT '' COMMENT '缩略图',
`images` varchar(1500) DEFAULT '' COMMENT '组图',
`seotitle` varchar(255) DEFAULT '' COMMENT 'SEO标题',
`keywords` varchar(255) DEFAULT '' COMMENT '关键字',
`description` varchar(255) DEFAULT '' COMMENT '描述',
`tags` varchar(255) DEFAULT '' COMMENT 'TAG',
`weigh` int(10) DEFAULT NULL,
`views` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览次数',
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
`publishtime` int(10) DEFAULT NULL COMMENT '发布时间',
`deletetime` int(10) DEFAULT NULL COMMENT '删除时间',
`memo` varchar(100) DEFAULT '' COMMENT '备注',
`content` text COMMENT '内容',
`status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '状态:1=正常,2=隐藏',
PRIMARY KEY (`id`),
KEY `status` (`cate_id`,`status`),
KEY `channel` (`cate_id`,`weigh`,`id`),
KEY `weigh` (`weigh`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8mb4 COMMENT='教师风采';
-- ----------------------------
-- Records of he_teacher
-- ----------------------------
BEGIN;
INSERT INTO `he_teacher` VALUES (1, 38, 'TpMeCMS22', '/cms/images/services-1.jpg', '/cms/images/services-1.jpg', '', '', 'TpMeCMS', '', 0, 1, NULL, 1624004225, NULL, NULL, '', 'TpMeCMSTpMeCMSTpMeCMS', '1');
INSERT INTO `he_teacher` VALUES (111, 38, '联系我们', '/cms/images/services-1.jpg', '/cms/images/services-1.jpg', '/cms/images/services-1.jpg', '/cms/images/services-1.jpg', '/cms/images/services-1.jpg', '', 111, 1, 1624004284, 1624004284, 1624004236, NULL, '', '<p>/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-<b>1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg/cms/images/services-1.jpg</b><br></p>', '1');
COMMIT;
-- ----------------------------
-- Table structure for he_test
-- ----------------------------
DROP TABLE IF EXISTS `he_test`;
CREATE TABLE `he_test` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`admin_id` int(10) NOT NULL DEFAULT '0' COMMENT '管理员ID',
`category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '分类ID(单选)',
`category_ids` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '分类ID(多选)',
`week` enum('monday','tuesday','wednesday') COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '星期(单选):monday=星期一,tuesday=星期二,wednesday=星期三',
`flag` set('hot','index','recommend') COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '标志(多选):hot=热门,index=首页,recommend=推荐',
`genderdata` enum('male','female') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'male' COMMENT '性别(单选):male=男,female=女',
`hobbydata` set('music','reading','swimming') COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '爱好(多选):music=音乐,reading=读书,swimming=游泳',
`title` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '标题',
`content` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '内容',
`image` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '图片',
`images` varchar(1500) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '图片组',
`attachfile` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '附件',
`keywords` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '关键字',
`description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '描述',
`city` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '省市',
`json` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '配置:key=名称,value=值',
`price` float(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '价格',
`views` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点击',
`startdate` date DEFAULT NULL COMMENT '开始日期',
`activitytime` datetime DEFAULT NULL COMMENT '活动时间(datetime)',
`year` year(4) DEFAULT NULL COMMENT '年',
`times` time DEFAULT NULL COMMENT '时间',
`refreshtime` int(10) DEFAULT NULL COMMENT '刷新时间(int)',
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
`deletetime` int(10) DEFAULT NULL COMMENT '删除时间',
`weigh` int(10) NOT NULL DEFAULT '0' COMMENT '权重',
`switch` tinyint(1) NOT NULL DEFAULT '0' COMMENT '开关',
`status` enum('normal','hidden') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'normal' COMMENT '状态',
`state` enum('0','1','2') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1' COMMENT '状态值:0=禁用,1=正常,2=推荐',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='TpMeCMS表';
-- ----------------------------
-- Records of he_test
-- ----------------------------
BEGIN;
INSERT INTO `he_test` VALUES (1, 0, 12, '12,13', 'monday', 'hot,index', 'male', 'music,reading', '我是一篇TpMeCMS文章', '<p>我是TpMeCMS内容</p>', '/assets/img/avatar.png', '/assets/img/avatar.png,/assets/img/qrcode.png', '/assets/img/avatar.png', '关键字', '描述', '广西壮族自治区/百色市/平果县', '{\"a\":\"1\",\"b\":\"2\"}', 0.00, 0, '2017-07-10', '2017-07-10 18:24:45', 2017, '18:24:45', 1491635035, 1491635035, 1491635035, NULL, 0, 1, 'normal', '1');
COMMIT;
-- ----------------------------
-- Table structure for he_user
-- ----------------------------
DROP TABLE IF EXISTS `he_user`;
CREATE TABLE `he_user` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`group_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '组别ID',
`username` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '用户名',
`nickname` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '昵称',
`password` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '密码',
`salt` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '密码盐',
`email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '电子邮箱',
`mobile` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '手机号',
`avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '头像',
`level` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '等级',
`gender` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '性别',
`birthday` date DEFAULT NULL COMMENT '生日',
`bio` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '格言',
`money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '余额',
`score` int(10) NOT NULL DEFAULT '0' COMMENT '积分',
`successions` int(10) unsigned NOT NULL DEFAULT '1' COMMENT '连续登录天数',
`maxsuccessions` int(10) unsigned NOT NULL DEFAULT '1' COMMENT '最大连续登录天数',
`prevtime` int(10) DEFAULT NULL COMMENT '上次登录时间',
`logintime` int(10) DEFAULT NULL COMMENT '登录时间',
`loginip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '登录IP',
`loginfailure` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '失败次数',
`joinip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '加入IP',
`jointime` int(10) DEFAULT NULL COMMENT '加入时间',
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
`token` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'Token',
`status` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '状态',
`verification` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '验证',
`wx_openid` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '微信openid',
`openid` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '小程序openid',
`unionid` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '开放平台',
`sex` enum('0','1','2') COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT '性别:1=男,2=女,0=未知',
`city` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '城市',
PRIMARY KEY (`id`),
KEY `username` (`username`),
KEY `email` (`email`),
KEY `mobile` (`mobile`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='会员表';
-- ----------------------------
-- Records of he_user
-- ----------------------------
BEGIN;
INSERT INTO `he_user` VALUES (1, 1, 'admin', NULL, 'bdeb7f516365ce5b9ddaa0b3311f12e9', 'f75ae9', 'admin@163.com', '13888888888', NULL, 0, 0, '2017-04-08', '', 0.00, 0, 1, 1, 1491635035, 1624415185, '127.0.0.1', 0, '127.0.0.1', 1491635035, 0, 1491635035, '', 'normal', '', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `he_user` VALUES (2, 1, '19983297340', '199****7340', '5da755359b921bd7564eaef2302995f4', 'O9R0sD', '496631085@qq.com', '19983297340', '', 1, 0, NULL, '', 0.00, 0, 2, 2, 1624348054, 1624413771, '114.223.143.173', 0, '114.223.143.173', 1624344349, NULL, 1624413771, '', 'normal', '', '1111111', '', NULL, '0', NULL);
INSERT INTO `he_user` VALUES (3, 0, '', 'XiaoHe', '', '', '', '', 'https://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eodRMTpFTAbqibaib5rqmRQZFMeD1PMX20n5VtMMMibYRUM0mrOzWfcial5TRNCU2ia7ksmD8RsYW8xBUA/132', 0, 0, NULL, '', 0.00, 0, 1, 1, NULL, 1624419887, '', 0, '', NULL, NULL, NULL, '', 'normal', '', NULL, 'o2n8_6fh0TfnF3pngecOLdW1k7lU', NULL, '1', '成都');
COMMIT;
-- ----------------------------
-- Table structure for he_user_group
-- ----------------------------
DROP TABLE IF EXISTS `he_user_group`;
CREATE TABLE `he_user_group` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '组名',
`rules` text COLLATE utf8mb4_unicode_ci COMMENT '权限节点',
`createtime` int(10) DEFAULT NULL COMMENT '添加时间',
`updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
`status` enum('normal','hidden') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '状态',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='会员组表';
-- ----------------------------
-- Records of he_user_group
-- ----------------------------
BEGIN;
INSERT INTO `he_user_group` VALUES (1, '默认组', '1,2,3,4,5,6,7,8,9,10,11,12', 1491635035, 1491635035, 'normal');
COMMIT;
-- ----------------------------
-- Table structure for he_user_money_log
-- ----------------------------
DROP TABLE IF EXISTS `he_user_money_log`;
CREATE TABLE `he_user_money_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
`money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '变更余额',
`before` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '变更前余额',
`after` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '变更后余额',
`memo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '备注',
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='会员余额变动表';
-- ----------------------------
-- Records of he_user_money_log
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for he_user_rule
-- ----------------------------
DROP TABLE IF EXISTS `he_user_rule`;
CREATE TABLE `he_user_rule` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) DEFAULT NULL COMMENT '父ID',
`name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称',
`title` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '标题',
`remark` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
`ismenu` tinyint(1) DEFAULT NULL COMMENT '是否菜单',
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
`weigh` int(10) DEFAULT '0' COMMENT '权重',
`status` enum('normal','hidden') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '状态',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='会员规则表';
-- ----------------------------
-- Records of he_user_rule
-- ----------------------------
BEGIN;
INSERT INTO `he_user_rule` VALUES (1, 0, 'index', 'Frontend', '', 1, 1491635035, 1491635035, 1, 'normal');
INSERT INTO `he_user_rule` VALUES (2, 0, 'api', 'API Interface', '', 1, 1491635035, 1491635035, 2, 'normal');
INSERT INTO `he_user_rule` VALUES (3, 1, 'user', 'User Module', '', 1, 1491635035, 1491635035, 12, 'normal');
INSERT INTO `he_user_rule` VALUES (4, 2, 'user', 'User Module', '', 1, 1491635035, 1491635035, 11, 'normal');
INSERT INTO `he_user_rule` VALUES (5, 3, 'index/user/login', 'Login', '', 0, 1491635035, 1491635035, 5, 'normal');
INSERT INTO `he_user_rule` VALUES (6, 3, 'index/user/register', 'Register', '', 0, 1491635035, 1491635035, 7, 'normal');
INSERT INTO `he_user_rule` VALUES (7, 3, 'index/user/index', 'User Center', '', 0, 1491635035, 1491635035, 9, 'normal');
INSERT INTO `he_user_rule` VALUES (8, 3, 'index/user/profile', 'Profile', '', 0, 1491635035, 1491635035, 4, 'normal');
INSERT INTO `he_user_rule` VALUES (9, 4, 'api/user/login', 'Login', '', 0, 1491635035, 1491635035, 6, 'normal');
INSERT INTO `he_user_rule` VALUES (10, 4, 'api/user/register', 'Register', '', 0, 1491635035, 1491635035, 8, 'normal');
INSERT INTO `he_user_rule` VALUES (11, 4, 'api/user/index', 'User Center', '', 0, 1491635035, 1491635035, 10, 'normal');
INSERT INTO `he_user_rule` VALUES (12, 4, 'api/user/profile', 'Profile', '', 0, 1491635035, 1491635035, 3, 'normal');
COMMIT;
-- ----------------------------
-- Table structure for he_user_score_log
-- ----------------------------
DROP TABLE IF EXISTS `he_user_score_log`;
CREATE TABLE `he_user_score_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
`score` int(10) NOT NULL DEFAULT '0' COMMENT '变更积分',
`before` int(10) NOT NULL DEFAULT '0' COMMENT '变更前积分',
`after` int(10) NOT NULL DEFAULT '0' COMMENT '变更后积分',
`memo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '备注',
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='会员积分变动表';
-- ----------------------------
-- Records of he_user_score_log
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for he_user_token
-- ----------------------------
DROP TABLE IF EXISTS `he_user_token`;
CREATE TABLE `he_user_token` (
`token` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Token',
`user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
`expiretime` int(10) DEFAULT NULL COMMENT '过期时间',
PRIMARY KEY (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='会员Token表';
-- ----------------------------
-- Records of he_user_token
-- ----------------------------
BEGIN;
INSERT INTO `he_user_token` VALUES ('3b55cbaf4dfa411a293f083469c46080289f69a3', 2, 1624344349, 1626936349);
COMMIT;
-- ----------------------------
-- Table structure for he_version
-- ----------------------------
DROP TABLE IF EXISTS `he_version`;
CREATE TABLE `he_version` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`oldversion` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '旧版本号',
`newversion` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '新版本号',
`packagesize` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '包大小',
`content` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '升级内容',
`downloadurl` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '下载地址',
`enforce` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '强制更新',
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
`weigh` int(10) NOT NULL DEFAULT '0' COMMENT '权重',
`status` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='版本表';
-- ----------------------------
-- Records of he_version
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for he_video
-- ----------------------------
DROP TABLE IF EXISTS `he_video`;
CREATE TABLE `he_video` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`cate_id` int(10) unsigned NOT NULL COMMENT '栏目ID',
`title` varchar(255) DEFAULT '' COMMENT '文章标题',
`image` varchar(255) DEFAULT '' COMMENT '缩略图',
`images` varchar(1500) DEFAULT '' COMMENT '组图',
`seotitle` varchar(255) DEFAULT '' COMMENT 'SEO标题',
`keywords` varchar(255) DEFAULT '' COMMENT '关键字',
`description` varchar(255) DEFAULT '' COMMENT '描述',
`tags` varchar(255) DEFAULT '' COMMENT 'TAG',
`weigh` int(10) DEFAULT NULL,
`views` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览次数',
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
`publishtime` int(10) DEFAULT NULL COMMENT '发布时间',
`deletetime` int(10) DEFAULT NULL COMMENT '删除时间',
`memo` varchar(100) DEFAULT '' COMMENT '备注',
`content` text COMMENT '内容',
`status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '状态:1=正常,2=隐藏',
PRIMARY KEY (`id`),
KEY `status` (`cate_id`,`status`),
KEY `channel` (`cate_id`,`weigh`,`id`),
KEY `weigh` (`weigh`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8mb4 COMMENT='视频下载';
-- ----------------------------
-- Records of he_video
-- ----------------------------
BEGIN;
INSERT INTO `he_video` VALUES (1, 38, 'TpMeCMS', '/cms/images/services-1.jpg', '/cms/images/services-1.jpg', '', '', 'TpMeCMS', '', NULL, 2, NULL, NULL, NULL, NULL, '', 'TpMeCMSTpMeCMSTpMeCMS', '1');
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;

Comment ( 0 )

Sign in for post a comment

PHP
1
https://toscode.gitee.com/cdbozhi/tp-me-cms.git
git@toscode.gitee.com:cdbozhi/tp-me-cms.git
cdbozhi
tp-me-cms
TpMeCMS
master

Search