代码拉取完成，页面将自动刷新
Fork 仓库
加载中
确定同步？
同步操作将从 simple/美业管理平台（新） 强制同步，此操作会覆盖自 Fork 仓库以来所做的任何修改，且无法恢复！！！
确定后同步将在后台操作，完成时将刷新页面，请耐心等待。
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269
/*
Navicat MySQL Data Transfer
Source Server : 本地
Source Server Version : 80012
Source Host : localhost:3306
Source Database : meirong_new
Target Server Type : MYSQL
Target Server Version : 80012
File Encoding : 65001
Date: 2020-10-27 13:54:12
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for hisi_account
-- ----------------------------
DROP TABLE IF EXISTS `hisi_account`;
CREATE TABLE `hisi_account` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL COMMENT '账户名称',
`suoshu` varchar(255) NOT NULL COMMENT '所属：人名或者开户行',
`account` varchar(255) NOT NULL COMMENT '账号',
`bak` text COMMENT '描述',
`weigh` int(5) NOT NULL DEFAULT '50' COMMENT '排序',
`ctime` int(11) NOT NULL,
`mtime` int(11) NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态(0禁用，1正常)',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='账户表';
-- ----------------------------
-- Records of hisi_account
-- ----------------------------
INSERT INTO `hisi_account` VALUES ('10', '中信银行2115#', '中信银行经济技术开发区支行', '62176111111111111', '', '50', '1591254650', '1591254650', '1');
INSERT INTO `hisi_account` VALUES ('11', '威海银行6177#', '商业银行股份有限公司分行营业部', '62310206222222222', '', '50', '1591254715', '1591254715', '1');
INSERT INTO `hisi_account` VALUES ('0', '会员卡', '会员卡，此项不能删除！！', '会员卡，此项不能删除！！', '会员卡，此项不能删除！！此项不能删除！！此项不能删除！！', '50', '1582271214', '1582271214', '1');
INSERT INTO `hisi_account` VALUES ('12', '广发银行7610#', '广发银行', '62146243323333333330', '', '50', '1591254778', '1591254778', '1');
INSERT INTO `hisi_account` VALUES ('9', '系统初始化', '系统初始化', '系统初始化', '系统初始化，请勿删除、修改', '50', '1591146230', '1591146828', '1');
INSERT INTO `hisi_account` VALUES ('13', '对公账户1612#', '商业银行股份有限公司', '817966666666666612', '', '50', '1591254843', '1591254843', '1');
INSERT INTO `hisi_account` VALUES ('14', '招行对公账户0802#', '招商银行股份有限公司', '535955555555552', '', '50', '1591254948', '1591254948', '1');
INSERT INTO `hisi_account` VALUES ('15', '建行对公账户0371#', '建设银行开发区', '3705016666666671', '', '50', '1591255162', '1591255162', '1');
INSERT INTO `hisi_account` VALUES ('16', '天津银行信用卡1102#', '尹力', '6224277777777777772', '15号账单日9号还款', '50', '1591255223', '1591255636', '1');
INSERT INTO `hisi_account` VALUES ('17', '平安银行信用卡0107#', '尹力', '622158888888880107', '3号账单21号还款', '50', '1591255305', '1591255598', '1');
INSERT INTO `hisi_account` VALUES ('18', '建设银行信用卡1181#', '尹力', '43674888888888181', '7号账单27号还款', '50', '1591255358', '1591255358', '1');
INSERT INTO `hisi_account` VALUES ('19', '中信银行信用卡2375#', '尹力', '4099999999999999962375', '', '50', '1591255424', '1591255424', '1');
INSERT INTO `hisi_account` VALUES ('20', '民生银行信用卡6141#', '付玲', '6226444444444444446141', '7号账单日27号还款', '50', '1591255495', '1591255495', '1');
INSERT INTO `hisi_account` VALUES ('21', '理财扣款', '理财扣款', '', '', '50', '1591255534', '1591255534', '1');
INSERT INTO `hisi_account` VALUES ('22', '其他', '尹力', '00', '', '1', '1591769461', '1593743939', '1');
INSERT INTO `hisi_account` VALUES ('23', '其他-花意空间', '挂账费用', '', '挂账费用', '50', '1593591665', '1593591665', '1');
INSERT INTO `hisi_account` VALUES ('24', '美团', '美团', '美团', '', '50', '1594802824', '1594802845', '1');
-- ----------------------------
-- Table structure for hisi_achievements
-- ----------------------------
DROP TABLE IF EXISTS `hisi_achievements`;
CREATE TABLE `hisi_achievements` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`admin_id` int(11) unsigned NOT NULL COMMENT '管理员',
`user_id` int(11) NOT NULL COMMENT '会员',
`project` varchar(255) DEFAULT NULL COMMENT '项目名称，产品名称，充值',
`num` int(11) NOT NULL DEFAULT '1',
`price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '消费金额',
`shougong` decimal(10,2) NOT NULL DEFAULT '0.00',
`settlement` varchar(255) DEFAULT '现金' COMMENT '计算方式',
`shop_id` int(11) NOT NULL,
`admin_type` varchar(255) DEFAULT '顾问' COMMENT '员工身份',
`proportion` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '提成比例',
`createtime` datetime NOT NULL,
`sn` varchar(255) DEFAULT NULL,
`bak` varchar(1000) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=46579 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='绩效表';
-- ----------------------------
-- Records of hisi_achievements
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_aftermarket_card
-- ----------------------------
DROP TABLE IF EXISTS `hisi_aftermarket_card`;
CREATE TABLE `hisi_aftermarket_card` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) unsigned NOT NULL,
`price` decimal(10,2) NOT NULL DEFAULT '0.00',
`adviser_id` int(11) NOT NULL COMMENT '顾问',
`technician_ids` varchar(255) DEFAULT NULL COMMENT '美容师',
`sn` varchar(255) NOT NULL COMMENT '编号',
`account_id` int(11) NOT NULL COMMENT '支出账户',
`cashier_id` int(11) NOT NULL COMMENT '前台',
`shop_id` int(11) NOT NULL COMMENT '门店',
`finance_id` int(11) DEFAULT NULL COMMENT '财务',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态1=待审核，2=通过，不通过',
`createtime` int(11) NOT NULL COMMENT '创建时间',
`type` tinyint(2) NOT NULL DEFAULT '1' COMMENT '类型：1=会员卡，2=赠送会员卡',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='退会员卡表';
-- ----------------------------
-- Records of hisi_aftermarket_card
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_aftermarket_liao
-- ----------------------------
DROP TABLE IF EXISTS `hisi_aftermarket_liao`;
CREATE TABLE `hisi_aftermarket_liao` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) unsigned NOT NULL,
`price` decimal(10,2) NOT NULL DEFAULT '0.00',
`adviser_id` int(11) NOT NULL COMMENT '顾问',
`technician_ids` varchar(255) DEFAULT NULL COMMENT '美容师',
`sn` varchar(255) NOT NULL COMMENT '编号',
`account_id` int(11) NOT NULL COMMENT '支出账户',
`cashier_id` int(11) NOT NULL COMMENT '前台',
`shop_id` int(11) NOT NULL COMMENT '门店',
`finance_id` int(11) DEFAULT NULL COMMENT '财务',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态1=待审核，2=通过，不通过',
`createtime` int(11) NOT NULL COMMENT '创建时间',
`multiple` text COMMENT '疗程卡',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=637 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='退产品表';
-- ----------------------------
-- Records of hisi_aftermarket_liao
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_aftermarket_product
-- ----------------------------
DROP TABLE IF EXISTS `hisi_aftermarket_product`;
CREATE TABLE `hisi_aftermarket_product` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) unsigned NOT NULL,
`price` decimal(10,2) NOT NULL DEFAULT '0.00',
`adviser_id` int(11) NOT NULL COMMENT '顾问',
`technician_ids` varchar(255) DEFAULT NULL COMMENT '美容师',
`sn` varchar(255) NOT NULL COMMENT '编号',
`account_id` int(11) NOT NULL COMMENT '支出账户',
`cashier_id` int(11) NOT NULL COMMENT '前台',
`shop_id` int(11) NOT NULL COMMENT '门店',
`finance_id` int(11) DEFAULT NULL COMMENT '财务',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态1=待审核，2=通过，不通过',
`createtime` int(11) NOT NULL COMMENT '创建时间',
`products` text COMMENT '产品',
`leixing` int(1) NOT NULL DEFAULT '1' COMMENT '类型 1正常售后退货 ，2 寄存单退货',
`d_id` int(10) DEFAULT '0' COMMENT '寄存单id，类型等于2生效',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='退产品表';
-- ----------------------------
-- Records of hisi_aftermarket_product
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_allocation
-- ----------------------------
DROP TABLE IF EXISTS `hisi_allocation`;
CREATE TABLE `hisi_allocation` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`sn` varchar(255) NOT NULL,
`a_warehouse` int(11) NOT NULL COMMENT '调出仓库',
`b_warehouse` int(11) NOT NULL COMMENT '调入仓库',
`a_id` int(11) NOT NULL COMMENT '调出人',
`b_id` int(11) DEFAULT NULL COMMENT '接收人',
`product_json` text COMMENT '产品',
`bak` varchar(255) DEFAULT NULL COMMENT '备注',
`createtime` int(11) NOT NULL,
`a_shop` int(11) NOT NULL COMMENT '出库门店',
`b_shop` int(11) NOT NULL COMMENT '接收门店',
`intime` int(11) DEFAULT NULL COMMENT '入库时间',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态：1=待审核；2=通过；3=不通过',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=907 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='调拨单';
-- ----------------------------
-- Records of hisi_allocation
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_arrival
-- ----------------------------
DROP TABLE IF EXISTS `hisi_arrival`;
CREATE TABLE `hisi_arrival` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`sn` varchar(255) NOT NULL COMMENT '订单编号',
`admin_id` int(11) NOT NULL COMMENT '操作员',
`warehouse_id` int(11) NOT NULL COMMENT '仓库',
`product_json` text COMMENT '产品',
`bak` varchar(255) DEFAULT NULL COMMENT '备注',
`finance_id` int(11) DEFAULT NULL COMMENT '审核财务',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态1=待审核；2=通过，3打回',
`createtime` int(11) NOT NULL COMMENT '创建时间',
`shop_id` int(11) NOT NULL COMMENT '门店',
`updatetime` int(11) DEFAULT NULL,
`out_type` tinyint(5) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='直接入库单';
-- ----------------------------
-- Records of hisi_arrival
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_bank_interturn
-- ----------------------------
DROP TABLE IF EXISTS `hisi_bank_interturn`;
CREATE TABLE `hisi_bank_interturn` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`a_account` int(11) NOT NULL COMMENT '转出',
`b_account` int(11) NOT NULL COMMENT '转入',
`bak` varchar(255) NOT NULL,
`price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '金额',
`createtime` int(11) NOT NULL,
`updatetime` int(11) NOT NULL,
`sn` varchar(255) NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='银行转账';
-- ----------------------------
-- Records of hisi_bank_interturn
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_brand
-- ----------------------------
DROP TABLE IF EXISTS `hisi_brand`;
CREATE TABLE `hisi_brand` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '品牌ID',
`name` varchar(255) NOT NULL COMMENT '品牌名称',
`weigh` int(6) NOT NULL DEFAULT '50' COMMENT '排序',
`createtime` int(11) NOT NULL COMMENT '创建时间',
`updatetime` int(11) NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of hisi_brand
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_cate
-- ----------------------------
DROP TABLE IF EXISTS `hisi_cate`;
CREATE TABLE `hisi_cate` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) unsigned DEFAULT '0',
`name` varchar(100) DEFAULT '',
`status` tinyint(1) DEFAULT '1' COMMENT '0隐藏，1显示',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of hisi_cate
-- ----------------------------
INSERT INTO `hisi_cate` VALUES ('1', '0', '一级分类A', '1');
INSERT INTO `hisi_cate` VALUES ('2', '0', '国际', '1');
INSERT INTO `hisi_cate` VALUES ('3', '1', '二级分类', '1');
INSERT INTO `hisi_cate` VALUES ('4', '1', '科技资讯', '1');
INSERT INTO `hisi_cate` VALUES ('9', '2', '科技资讯', '1');
INSERT INTO `hisi_cate` VALUES ('10', '2', '数码资讯', '1');
INSERT INTO `hisi_cate` VALUES ('11', '2', '股市资讯', '1');
INSERT INTO `hisi_cate` VALUES ('13', '3', '三级分类1', '1');
-- ----------------------------
-- Table structure for hisi_category
-- ----------------------------
DROP TABLE IF EXISTS `hisi_category`;
CREATE TABLE `hisi_category` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) unsigned DEFAULT '0',
`name` varchar(100) DEFAULT '',
`status` tinyint(1) DEFAULT '1' COMMENT '0隐藏，1显示',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of hisi_category
-- ----------------------------
INSERT INTO `hisi_category` VALUES ('27', '0', '面部产品', '1');
INSERT INTO `hisi_category` VALUES ('28', '0', '身体产品', '1');
INSERT INTO `hisi_category` VALUES ('29', '27', '院装面部产品', '1');
INSERT INTO `hisi_category` VALUES ('30', '27', '客装面部产品', '1');
INSERT INTO `hisi_category` VALUES ('31', '28', '院装身体产品', '1');
INSERT INTO `hisi_category` VALUES ('32', '28', '客装身体产品', '1');
INSERT INTO `hisi_category` VALUES ('33', '0', '仪器', '1');
INSERT INTO `hisi_category` VALUES ('34', '0', '消耗品', '1');
INSERT INTO `hisi_category` VALUES ('36', '0', '其他', '1');
INSERT INTO `hisi_category` VALUES ('37', '0', '私密产品', '1');
INSERT INTO `hisi_category` VALUES ('38', '0', '礼品', '1');
-- ----------------------------
-- Table structure for hisi_classofreim
-- ----------------------------
DROP TABLE IF EXISTS `hisi_classofreim`;
CREATE TABLE `hisi_classofreim` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) unsigned DEFAULT '0',
`name` varchar(100) DEFAULT '',
`status` tinyint(1) DEFAULT '1' COMMENT '0隐藏，1显示',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='报销分类';
-- ----------------------------
-- Records of hisi_classofreim
-- ----------------------------
INSERT INTO `hisi_classofreim` VALUES ('18', '0', '电话费', '1');
INSERT INTO `hisi_classofreim` VALUES ('19', '18', '电话费', '1');
INSERT INTO `hisi_classofreim` VALUES ('20', '18', '手机补助', '1');
INSERT INTO `hisi_classofreim` VALUES ('21', '0', '办公费', '1');
INSERT INTO `hisi_classofreim` VALUES ('22', '21', '网络费用', '1');
INSERT INTO `hisi_classofreim` VALUES ('23', '21', '办公用品', '1');
INSERT INTO `hisi_classofreim` VALUES ('24', '21', '文件资料邮寄费', '1');
INSERT INTO `hisi_classofreim` VALUES ('25', '0', '差旅费', '1');
INSERT INTO `hisi_classofreim` VALUES ('26', '25', '住宿费（房费）', '1');
INSERT INTO `hisi_classofreim` VALUES ('27', '25', '飞机票费', '1');
INSERT INTO `hisi_classofreim` VALUES ('28', '25', '出租车费', '1');
INSERT INTO `hisi_classofreim` VALUES ('29', '0', '日常费用', '1');
INSERT INTO `hisi_classofreim` VALUES ('30', '29', '鲜花', '1');
INSERT INTO `hisi_classofreim` VALUES ('31', '29', '通讯费', '1');
INSERT INTO `hisi_classofreim` VALUES ('32', '29', '快递费', '1');
INSERT INTO `hisi_classofreim` VALUES ('33', '0', '管理费用', '1');
INSERT INTO `hisi_classofreim` VALUES ('34', '33', '工资', '1');
INSERT INTO `hisi_classofreim` VALUES ('35', '33', '会议费', '1');
INSERT INTO `hisi_classofreim` VALUES ('36', '33', '社保', '1');
INSERT INTO `hisi_classofreim` VALUES ('37', '33', '福利费', '1');
INSERT INTO `hisi_classofreim` VALUES ('38', '0', '财务费用', '1');
INSERT INTO `hisi_classofreim` VALUES ('39', '38', '手续费', '1');
INSERT INTO `hisi_classofreim` VALUES ('40', '33', '电费', '1');
INSERT INTO `hisi_classofreim` VALUES ('41', '0', '营业费用', '1');
INSERT INTO `hisi_classofreim` VALUES ('42', '41', '业务招待费', '1');
INSERT INTO `hisi_classofreim` VALUES ('43', '41', '顾客赠送', '1');
INSERT INTO `hisi_classofreim` VALUES ('44', '41', '店内日常费用', '1');
INSERT INTO `hisi_classofreim` VALUES ('45', '29', '水果', '1');
INSERT INTO `hisi_classofreim` VALUES ('46', '29', '点心杂粮等', '1');
INSERT INTO `hisi_classofreim` VALUES ('47', '41', '老师餐费车费等', '1');
INSERT INTO `hisi_classofreim` VALUES ('48', '41', '活动费用', '1');
INSERT INTO `hisi_classofreim` VALUES ('49', '33', '车辆使用费', '1');
INSERT INTO `hisi_classofreim` VALUES ('50', '41', '维修费', '1');
INSERT INTO `hisi_classofreim` VALUES ('51', '33', '装修费', '1');
INSERT INTO `hisi_classofreim` VALUES ('52', '41', '干洗费', '1');
INSERT INTO `hisi_classofreim` VALUES ('53', '33', '物业费', '1');
INSERT INTO `hisi_classofreim` VALUES ('54', '33', '水费', '1');
INSERT INTO `hisi_classofreim` VALUES ('55', '33', '取暖费', '1');
INSERT INTO `hisi_classofreim` VALUES ('56', '33', '房租', '1');
INSERT INTO `hisi_classofreim` VALUES ('57', '41', '广告宣传费', '1');
INSERT INTO `hisi_classofreim` VALUES ('58', '33', '股金分红', '1');
INSERT INTO `hisi_classofreim` VALUES ('59', '33', '考试报名费', '1');
-- ----------------------------
-- Table structure for hisi_course
-- ----------------------------
DROP TABLE IF EXISTS `hisi_course`;
CREATE TABLE `hisi_course` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL COMMENT '卡名',
`course_json` text NOT NULL COMMENT '会员卡配置',
`price` decimal(10,2) DEFAULT '0.00' COMMENT '价格',
`sort` int(5) NOT NULL DEFAULT '10' COMMENT '排序',
`createtime` int(11) NOT NULL,
`updatetime` int(11) NOT NULL,
`status` tinyint(4) DEFAULT '1' COMMENT '状态：1=启用，0=禁用',
`type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '卡类型：1=储值卡，2=疗程卡，3=产品卡',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=150 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='疗程卡';
-- ----------------------------
-- Records of hisi_course
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_deposit
-- ----------------------------
DROP TABLE IF EXISTS `hisi_deposit`;
CREATE TABLE `hisi_deposit` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) unsigned NOT NULL COMMENT '用户',
`product_id` int(11) unsigned NOT NULL COMMENT '产品',
`num` decimal(11,2) NOT NULL DEFAULT '1.00' COMMENT '数量',
`address` varchar(255) DEFAULT NULL COMMENT '存放位置',
`admin_id` int(11) DEFAULT NULL COMMENT '负责人',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '寄存状态：1=寄存，2=领取，3=部分领取',
`createtime` int(11) NOT NULL COMMENT '创建时间',
`updatetime` int(11) NOT NULL COMMENT '更新时间',
`bak` text COMMENT '备注',
`shop_id` int(11) NOT NULL COMMENT '门店',
`take_log` text COMMENT '领取记录',
`sn` varchar(255) DEFAULT NULL COMMENT '订单编号',
`warehouse_id` int(10) DEFAULT NULL COMMENT '仓库',
`price` decimal(10,2) NOT NULL COMMENT '售价',
`unit_price` decimal(10,2) NOT NULL COMMENT '成本价',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1047 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='寄存单';
-- ----------------------------
-- Records of hisi_deposit
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_deposit_log
-- ----------------------------
DROP TABLE IF EXISTS `hisi_deposit_log`;
CREATE TABLE `hisi_deposit_log` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`product_id` int(11) NOT NULL,
`product_num_l` decimal(11,2) NOT NULL COMMENT '领取数量',
`product_name` varchar(255) DEFAULT NULL COMMENT '产品名称',
`d_id` int(11) NOT NULL COMMENT '寄存单id',
`user_name` varchar(255) DEFAULT NULL COMMENT '用户名',
`createtime` datetime DEFAULT NULL COMMENT '创建时间',
`user_id` int(11) DEFAULT NULL,
`product_num_s` varchar(255) DEFAULT NULL COMMENT '领取之前的数量',
`remark` varchar(255) DEFAULT NULL,
`ware_id` int(10) DEFAULT NULL COMMENT '出货仓库',
`unit_price` decimal(10,2) NOT NULL COMMENT '成本价',
`type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '类型：1=领取，2=退货',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=169 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='寄存单记录';
-- ----------------------------
-- Records of hisi_deposit_log
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_developer_versions
-- ----------------------------
DROP TABLE IF EXISTS `hisi_developer_versions`;
CREATE TABLE `hisi_developer_versions` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '类型：1模块，2插件，3模板',
`app_name` varchar(100) NOT NULL DEFAULT '' COMMENT '应用code',
`app_version` varchar(30) NOT NULL DEFAULT '' COMMENT '应用版本号',
`update_log` text COMMENT '应用更新日志',
`update_file` text COMMENT '更新文件记录',
`delete_file` text COMMENT '删除文件记录',
`update_sql` text COMMENT '更新sql',
`install_package` varchar(255) DEFAULT '' COMMENT '安装包',
`upgrade_package` varchar(255) DEFAULT '' COMMENT '升级包',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '发布状态：1已发布，0待发布',
`ctime` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='[开发助手] 版本记录';
-- ----------------------------
-- Records of hisi_developer_versions
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_direct
-- ----------------------------
DROP TABLE IF EXISTS `hisi_direct`;
CREATE TABLE `hisi_direct` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`sn` varchar(255) NOT NULL COMMENT '订单编号',
`admin_id` int(11) NOT NULL COMMENT '操作员',
`warehouse_id` int(11) NOT NULL COMMENT '仓库',
`product_json` text COMMENT '产品',
`bak` varchar(255) DEFAULT NULL COMMENT '备注',
`finance_id` int(11) DEFAULT NULL COMMENT '审核财务',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态1=待审核；2=通过，3打回',
`createtime` int(11) NOT NULL COMMENT '创建时间',
`shop_id` int(11) NOT NULL COMMENT '门店',
`updatetime` int(11) DEFAULT NULL,
`out_type` tinyint(5) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=348 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='直接出库';
-- ----------------------------
-- Records of hisi_direct
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_directtype
-- ----------------------------
DROP TABLE IF EXISTS `hisi_directtype`;
CREATE TABLE `hisi_directtype` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`createtime` int(11) NOT NULL,
`updatetime` int(11) NOT NULL,
`sort` int(5) NOT NULL DEFAULT '5',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='出库类型';
-- ----------------------------
-- Records of hisi_directtype
-- ----------------------------
INSERT INTO `hisi_directtype` VALUES ('1', '礼品出库', '1582984790', '1582984790', '5');
INSERT INTO `hisi_directtype` VALUES ('2', '购买入库', '1583037675', '1583037675', '5');
INSERT INTO `hisi_directtype` VALUES ('3', '赠送入库', '1584064844', '1584064844', '5');
INSERT INTO `hisi_directtype` VALUES ('4', '销售出库', '1584064857', '1584064857', '5');
INSERT INTO `hisi_directtype` VALUES ('5', '内耗出库', '1584064868', '1584064868', '5');
INSERT INTO `hisi_directtype` VALUES ('6', '赠送出库', '1584064895', '1584064895', '5');
INSERT INTO `hisi_directtype` VALUES ('7', '盘盈出库', '1589168040', '1589168040', '5');
INSERT INTO `hisi_directtype` VALUES ('8', '购买退回', '1595213336', '1595213336', '5');
-- ----------------------------
-- Table structure for hisi_example_category
-- ----------------------------
DROP TABLE IF EXISTS `hisi_example_category`;
CREATE TABLE `hisi_example_category` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) unsigned DEFAULT '0',
`name` varchar(100) DEFAULT '',
`status` tinyint(1) DEFAULT '1' COMMENT '0隐藏，1显示',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of hisi_example_category
-- ----------------------------
INSERT INTO `hisi_example_category` VALUES ('1', '0', '国内', '1');
INSERT INTO `hisi_example_category` VALUES ('2', '0', '国际', '1');
INSERT INTO `hisi_example_category` VALUES ('3', '1', '地方资讯', '1');
INSERT INTO `hisi_example_category` VALUES ('4', '1', '科技资讯', '1');
INSERT INTO `hisi_example_category` VALUES ('5', '1', '汽车资讯', '1');
INSERT INTO `hisi_example_category` VALUES ('6', '1', '教育资讯', '1');
INSERT INTO `hisi_example_category` VALUES ('7', '1', '财经新闻', '1');
INSERT INTO `hisi_example_category` VALUES ('8', '1', '数码资讯', '1');
INSERT INTO `hisi_example_category` VALUES ('9', '2', '科技资讯', '1');
INSERT INTO `hisi_example_category` VALUES ('10', '2', '数码资讯', '1');
INSERT INTO `hisi_example_category` VALUES ('11', '2', '股市资讯', '1');
INSERT INTO `hisi_example_category` VALUES ('12', '3', '北京', '1');
INSERT INTO `hisi_example_category` VALUES ('13', '3', '上海', '1');
INSERT INTO `hisi_example_category` VALUES ('14', '3', '重庆', '1');
INSERT INTO `hisi_example_category` VALUES ('15', '3', '广东', '1');
INSERT INTO `hisi_example_category` VALUES ('17', '1', '体育资讯', '1');
-- ----------------------------
-- Table structure for hisi_example_news
-- ----------------------------
DROP TABLE IF EXISTS `hisi_example_news`;
CREATE TABLE `hisi_example_news` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`cid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '分类ID',
`title` varchar(100) DEFAULT '' COMMENT '标题',
`author` varchar(50) DEFAULT '' COMMENT '作者',
`source` varchar(255) DEFAULT '' COMMENT '来源',
`img` varchar(255) DEFAULT '' COMMENT '图片',
`content` text COMMENT '内容',
`ctime` int(10) unsigned NOT NULL COMMENT '创建时间',
`mtime` int(10) unsigned NOT NULL COMMENT '修改时间',
`status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态(0隐藏，1显示)',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of hisi_example_news
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_ingredient_xxxx
-- ----------------------------
DROP TABLE IF EXISTS `hisi_ingredient_xxxx`;
CREATE TABLE `hisi_ingredient_xxxx` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`project_id` int(11) NOT NULL COMMENT '项目id',
`project_num` int(11) DEFAULT NULL COMMENT '项目数量',
`product_id` int(11) DEFAULT NULL COMMENT '产品',
`product_num` int(11) DEFAULT NULL COMMENT '产品数量',
`unit` int(11) DEFAULT NULL COMMENT '单位',
`warehouse_id` int(11) DEFAULT NULL COMMENT '仓库',
`shop_id` int(11) NOT NULL COMMENT '门店',
`sub_id` int(11) NOT NULL COMMENT '操作单',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='配料库';
-- ----------------------------
-- Records of hisi_ingredient_xxxx
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_jobs
-- ----------------------------
DROP TABLE IF EXISTS `hisi_jobs`;
CREATE TABLE `hisi_jobs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`queue` varchar(255) NOT NULL,
`payload` longtext NOT NULL,
`attempts` tinyint(3) unsigned NOT NULL,
`reserved` tinyint(3) unsigned NOT NULL,
`reserved_at` int(10) unsigned DEFAULT NULL,
`available_at` int(10) unsigned NOT NULL,
`created_at` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of hisi_jobs
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_other_type
-- ----------------------------
DROP TABLE IF EXISTS `hisi_other_type`;
CREATE TABLE `hisi_other_type` (
`id` int(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL COMMENT '类型名称',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='其他收付款级别';
-- ----------------------------
-- Records of hisi_other_type
-- ----------------------------
INSERT INTO `hisi_other_type` VALUES ('3', '借款');
INSERT INTO `hisi_other_type` VALUES ('5', '入股股金');
INSERT INTO `hisi_other_type` VALUES ('6', '资金周转');
INSERT INTO `hisi_other_type` VALUES ('7', '储蓄金');
INSERT INTO `hisi_other_type` VALUES ('8', 'PK金');
-- ----------------------------
-- Table structure for hisi_product
-- ----------------------------
DROP TABLE IF EXISTS `hisi_product`;
CREATE TABLE `hisi_product` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '产品ID',
`name` varchar(255) NOT NULL COMMENT '产品名称',
`coded` varchar(255) DEFAULT NULL COMMENT '产品编码',
`supplier_id` int(11) DEFAULT NULL COMMENT '供应商',
`category_id` int(10) NOT NULL COMMENT '产品所属分类',
`brand_id` int(10) NOT NULL COMMENT '产品所属品牌',
`specs` decimal(10,2) unsigned NOT NULL COMMENT '规格',
`unit_id` int(10) NOT NULL COMMENT '单位',
`decomposition_id` int(10) NOT NULL COMMENT '分解单位',
`weigh` int(10) NOT NULL DEFAULT '50' COMMENT '排序',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态:1=正常,2=隐藏',
`createtime` int(11) NOT NULL COMMENT '创建时间',
`updatetime` int(11) NOT NULL COMMENT '更新时间',
`price1` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '成本价',
`price2` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '售价',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=651 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of hisi_product
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_product_order
-- ----------------------------
DROP TABLE IF EXISTS `hisi_product_order`;
CREATE TABLE `hisi_product_order` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL COMMENT '用户',
`shop_id` int(11) DEFAULT NULL,
`cashier_id` int(11) NOT NULL COMMENT '收银',
`finance_id` int(11) DEFAULT NULL COMMENT '财务',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '''当前进度:1=库管开单，2=完成,3=作废，4=收银结算，5=财务审核',
`createtime` int(11) NOT NULL COMMENT '创建时间',
`updatetime` int(11) NOT NULL COMMENT '更新时间',
`sn` varchar(255) DEFAULT NULL COMMENT '订单编号',
`goods` text COMMENT '产品',
`ware_admin` int(10) DEFAULT NULL COMMENT '库管',
`is_repair` int(2) NOT NULL DEFAULT '0' COMMENT '是否补录：0：否，1：是',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=757 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='产品订单表';
-- ----------------------------
-- Records of hisi_product_order
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_project
-- ----------------------------
DROP TABLE IF EXISTS `hisi_project`;
CREATE TABLE `hisi_project` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '项目ID',
`name` varchar(255) NOT NULL COMMENT '项目名称',
`cost` float(10,2) NOT NULL COMMENT '成本价',
`price` float(10,2) NOT NULL COMMENT '消售价',
`weigh` int(5) DEFAULT NULL COMMENT '排序',
`createtime` int(11) NOT NULL COMMENT '创建时间',
`updatetime` int(11) NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=140 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='项目表';
-- ----------------------------
-- Records of hisi_project
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_project_product
-- ----------------------------
DROP TABLE IF EXISTS `hisi_project_product`;
CREATE TABLE `hisi_project_product` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`project_id` int(10) unsigned NOT NULL COMMENT '项目ID',
`product_id` int(10) unsigned NOT NULL COMMENT '产品ID',
`category_number` decimal(10,2) NOT NULL COMMENT '产品数量',
`is_volume` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否分解使用:1=是,2=否',
`createtime` int(11) NOT NULL COMMENT '创建时间',
`updatetime` int(11) NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=448 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='项目产品表';
-- ----------------------------
-- Records of hisi_project_product
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_purchase
-- ----------------------------
DROP TABLE IF EXISTS `hisi_purchase`;
CREATE TABLE `hisi_purchase` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`sn` varchar(255) NOT NULL COMMENT '订单编号',
`admin_id` int(11) NOT NULL COMMENT '采购员',
`warehouse_id` int(11) NOT NULL COMMENT '仓库',
`product_json` text COMMENT '产品',
`bak` varchar(255) DEFAULT NULL COMMENT '备注',
`finance_id` int(11) DEFAULT NULL COMMENT '审核财务',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态1=待审核；2=通过，3打回',
`createtime` int(11) NOT NULL COMMENT '创建时间',
`shop_id` int(11) NOT NULL COMMENT '门店',
`updatetime` int(11) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=236 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='采购单';
-- ----------------------------
-- Records of hisi_purchase
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_reim
-- ----------------------------
DROP TABLE IF EXISTS `hisi_reim`;
CREATE TABLE `hisi_reim` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`sn` varchar(255) NOT NULL COMMENT '订单编号',
`class_id` int(11) NOT NULL COMMENT '分类',
`shop_id` int(11) NOT NULL COMMENT '门店',
`title` varchar(255) NOT NULL COMMENT '报销内容',
`price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '金额',
`admin_id` int(11) NOT NULL COMMENT '提交人',
`bak` text COMMENT '备注',
`createtime` int(11) DEFAULT NULL COMMENT '创建时间',
`usetime` int(11) DEFAULT NULL COMMENT '费用产生日期',
`status` int(255) DEFAULT '1' COMMENT '状态：1=待审核，2=通过审核，3=无效',
`account_id` int(11) DEFAULT NULL COMMENT '支出账户',
`finance_id` int(11) DEFAULT NULL COMMENT '审核人',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=448 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='报销单';
-- ----------------------------
-- Records of hisi_reim
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_room
-- ----------------------------
DROP TABLE IF EXISTS `hisi_room`;
CREATE TABLE `hisi_room` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '房间ID',
`shop_id` int(10) unsigned NOT NULL COMMENT '门店ID',
`name` varchar(255) NOT NULL COMMENT '房间名称',
`createtime` int(11) NOT NULL COMMENT '创建时间',
`weigh` int(6) NOT NULL DEFAULT '50' COMMENT '排序',
`updatetime` int(11) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of hisi_room
-- ----------------------------
INSERT INTO `hisi_room` VALUES ('9', '8', 'V1', '1591583885', '1', '1591583885');
INSERT INTO `hisi_room` VALUES ('10', '8', 'V2', '1591583898', '2', '1591583898');
INSERT INTO `hisi_room` VALUES ('11', '8', 'V3', '1591583911', '3', '1591583961');
INSERT INTO `hisi_room` VALUES ('12', '8', 'V5', '1591583927', '4', '1591583953');
INSERT INTO `hisi_room` VALUES ('13', '8', 'V6', '1591583943', '5', '1591583943');
INSERT INTO `hisi_room` VALUES ('14', '8', 'V7', '1591583978', '6', '1591583978');
INSERT INTO `hisi_room` VALUES ('15', '8', 'V8', '1591584009', '7', '1591584009');
INSERT INTO `hisi_room` VALUES ('16', '8', 'V9', '1591584022', '8', '1591584022');
INSERT INTO `hisi_room` VALUES ('17', '8', 'V10', '1591584043', '9', '1591584043');
INSERT INTO `hisi_room` VALUES ('18', '8', '瑶浴间', '1591584071', '11', '1591584071');
INSERT INTO `hisi_room` VALUES ('19', '1', '澜悦', '1591584723', '12', '1591584865');
INSERT INTO `hisi_room` VALUES ('20', '1', '澜馨', '1591584807', '13', '1591584874');
INSERT INTO `hisi_room` VALUES ('21', '1', '澜涵', '1591584831', '14', '1591584882');
INSERT INTO `hisi_room` VALUES ('22', '1', '澜轩', '1591585228', '15', '1591585228');
INSERT INTO `hisi_room` VALUES ('23', '1', '澜沁', '1591585252', '16', '1591585252');
INSERT INTO `hisi_room` VALUES ('24', '1', '澜香', '1591585276', '17', '1591585276');
INSERT INTO `hisi_room` VALUES ('25', '1', '澜庭', '1591585296', '18', '1591585296');
INSERT INTO `hisi_room` VALUES ('26', '1', '悦颜', '1591585347', '19', '1591585347');
INSERT INTO `hisi_room` VALUES ('27', '1', '悦容', '1591585367', '20', '1591585367');
INSERT INTO `hisi_room` VALUES ('28', '1', '悦灵', '1591585390', '21', '1591585390');
INSERT INTO `hisi_room` VALUES ('29', '1', '悦心', '1591585413', '22', '1591585413');
INSERT INTO `hisi_room` VALUES ('30', '1', '悦己', '1591585436', '23', '1591585436');
INSERT INTO `hisi_room` VALUES ('31', '1', '悦情', '1591585475', '24', '1591585475');
INSERT INTO `hisi_room` VALUES ('32', '1', '悦色', '1591585488', '25', '1591585488');
INSERT INTO `hisi_room` VALUES ('33', '1', '悦梦', '1591585531', '26', '1591585531');
INSERT INTO `hisi_room` VALUES ('34', '1', '瑶浴间', '1591585549', '27', '1591585549');
INSERT INTO `hisi_room` VALUES ('35', '7', '澜庭', '1591588717', '28', '1591588717');
INSERT INTO `hisi_room` VALUES ('36', '7', '悦心', '1591588740', '29', '1591588740');
INSERT INTO `hisi_room` VALUES ('37', '7', '悦情', '1591588755', '30', '1591588755');
INSERT INTO `hisi_room` VALUES ('38', '7', '悦己', '1591588770', '31', '1591588770');
INSERT INTO `hisi_room` VALUES ('39', '7', '悦色', '1591588785', '32', '1591588785');
INSERT INTO `hisi_room` VALUES ('40', '7', '悦容', '1591588812', '33', '1591588812');
INSERT INTO `hisi_room` VALUES ('41', '7', '悦颜', '1591588828', '34', '1591588828');
-- ----------------------------
-- Table structure for hisi_shop
-- ----------------------------
DROP TABLE IF EXISTS `hisi_shop`;
CREATE TABLE `hisi_shop` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '店铺ID',
`name` varchar(255) NOT NULL COMMENT '门店名称',
`phone` varchar(100) NOT NULL COMMENT '联系电话',
`create_date` date NOT NULL COMMENT '创店时间',
`address` varchar(100) NOT NULL COMMENT '店铺地址',
`weigh` int(11) NOT NULL DEFAULT '100' COMMENT '排序',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态:1=正常,2=禁用',
`createtime` int(11) NOT NULL COMMENT '系统创建时间',
`updatetime` int(11) NOT NULL COMMENT '最后一次更新',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of hisi_shop
-- ----------------------------
INSERT INTO `hisi_shop` VALUES ('1', '澜悦新时代店', '6839777', '2011-11-20', '开发区新时代小区', '1', '1', '1577429014', '1591322506');
INSERT INTO `hisi_shop` VALUES ('7', '澜悦台湾村店', '6808999', '2013-04-28', '莱山区红旗东路', '100', '1', '1591322564', '1591322564');
INSERT INTO `hisi_shop` VALUES ('8', '澜悦大成门店', '6189777', '2019-11-20', '芝罘区大成门店', '100', '1', '1591322616', '1591322616');
INSERT INTO `hisi_shop` VALUES ('9', '澜悦SPA总部', '15615852877', '0000-00-00', '芝罘区南大街153号', '100', '1', '1591323138', '1591323138');
-- ----------------------------
-- Table structure for hisi_stock
-- ----------------------------
DROP TABLE IF EXISTS `hisi_stock`;
CREATE TABLE `hisi_stock` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`product_id` int(11) DEFAULT NULL COMMENT '产品id',
`product_num` decimal(10,2) DEFAULT NULL COMMENT '产品数量',
`product_name` varchar(255) DEFAULT NULL COMMENT '产品名称',
`shop_id` int(11) DEFAULT NULL,
`sn` varchar(255) DEFAULT NULL COMMENT '单号',
`type` char(20) NOT NULL DEFAULT '出库' COMMENT '库存单类型：出库，入库',
`detailed_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '出库明细类型：1=项目出库，2=产品出库，3=调拨出库，4=出库单出库，5=调拨入库，6采购入库,7=其他出库，8=其他入库',
`user_id` int(11) DEFAULT NULL COMMENT '使用会员',
`warehouse_id` int(11) NOT NULL COMMENT '仓库',
`createtime` int(11) DEFAULT NULL COMMENT '创建时间',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态：0=不计数，1=计数',
`bak` text COMMENT '备注',
`updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
`unit_price` decimal(10,2) DEFAULT '0.00' COMMENT '单价',
`price` decimal(10,2) DEFAULT '0.00' COMMENT '售价',
`begin_num` decimal(10,2) NOT NULL COMMENT '期初数量',
`end_num` decimal(10,2) NOT NULL COMMENT '期末数量',
`begin_price` decimal(10,2) NOT NULL COMMENT '期初金额',
`end_price` decimal(10,2) NOT NULL COMMENT '期末金额',
PRIMARY KEY (`id`) USING BTREE,
KEY `product_id` (`product_id`),
KEY `shop_id` (`shop_id`),
KEY `type` (`type`),
KEY `status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=121625 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='库存明细';
-- ----------------------------
-- Records of hisi_stock
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_subscribe
-- ----------------------------
DROP TABLE IF EXISTS `hisi_subscribe`;
CREATE TABLE `hisi_subscribe` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '预约单ID',
`user_id` int(10) NOT NULL DEFAULT '0' COMMENT '会员',
`shop_id` int(10) NOT NULL COMMENT '店铺ID',
`room_id` int(10) NOT NULL COMMENT '房间ID',
`adviser_id` int(10) unsigned NOT NULL COMMENT '顾问',
`technician_ids` varchar(255) DEFAULT NULL COMMENT '美容师',
`project_ids` varchar(255) NOT NULL COMMENT '项目',
`appointment_time` datetime NOT NULL COMMENT '预约时间',
`cashier_id` int(11) NOT NULL COMMENT '收银',
`remarks` text COMMENT '备注',
`createtime` int(11) NOT NULL COMMENT '创建时间',
`updatetime` int(11) DEFAULT NULL,
`skin_text` text COMMENT '皮肤现状',
`problem` text COMMENT '今日需解决的问题',
`operate_detail` text COMMENT '操作注意细节',
`sug_goods` text COMMENT '建议居家用品',
`status` tinyint(4) NOT NULL DEFAULT '5' COMMENT '当前进度:0=顾问开单,1=库管配料,2=前台结算,3=财务审核,4=完成,5=预约,6=疑问单',
`warehouse_admin` int(11) DEFAULT NULL COMMENT '库管',
`finance_id` int(11) DEFAULT NULL COMMENT '财务',
`sn` varchar(255) NOT NULL COMMENT '单号',
`account_id` int(11) DEFAULT NULL COMMENT '收款账户',
`project_data` text COMMENT '项目',
`product_data` text COMMENT '项目所有产品',
`buy_product` text COMMENT '购买的产品',
`service_price` decimal(10,2) DEFAULT '0.00',
`product_price` decimal(10,2) DEFAULT '0.00',
`zong_price` decimal(10,2) DEFAULT '0.00',
`recharge` text COMMENT '充值金额，做记录用，不计入统计',
`card_data` text COMMENT '疗程卡记录，不计入统计',
`time1` int(11) DEFAULT NULL COMMENT '预约单开单时间',
`time2` int(11) DEFAULT NULL COMMENT '预约到店时间',
`time3` int(11) DEFAULT NULL COMMENT '顾问开单时间',
`time4` int(11) DEFAULT NULL COMMENT '库管开单时间',
`time5` int(11) DEFAULT NULL COMMENT '收银开单时间',
`time6` int(11) DEFAULT NULL COMMENT '财务审核时间',
`is_repair` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否补录 0 否 1是',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10863 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='预约表';
-- ----------------------------
-- Records of hisi_subscribe
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_supplier
-- ----------------------------
DROP TABLE IF EXISTS `hisi_supplier`;
CREATE TABLE `hisi_supplier` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '供应商ID',
`name` varchar(255) NOT NULL COMMENT '供应商名称',
`contacts` varchar(255) NOT NULL COMMENT '联系人',
`phone` varchar(20) DEFAULT NULL COMMENT '联系电话',
`fax` varchar(255) DEFAULT NULL COMMENT '传真',
`address` varchar(255) DEFAULT NULL COMMENT '地址',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态:1=正常,2=删除',
`createtime` int(11) NOT NULL COMMENT '创建时间',
`updatetime` int(11) NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='供应商表';
-- ----------------------------
-- Records of hisi_supplier
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_supplier_money
-- ----------------------------
DROP TABLE IF EXISTS `hisi_supplier_money`;
CREATE TABLE `hisi_supplier_money` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`supplier_id` int(11) NOT NULL COMMENT '供应商',
`account_id` int(11) NOT NULL,
`price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '金额',
`bak` varchar(255) DEFAULT NULL COMMENT '备注',
`createtime` datetime NOT NULL,
`sn` varchar(255) DEFAULT NULL,
`out_in` tinyint(2) NOT NULL DEFAULT '1' COMMENT '进出账：1=充值，2=消费',
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态：1=通过，0=待审核，-1=返回修改',
`tj_id` int(10) DEFAULT '1' COMMENT '提交的财务id',
`sh_id` int(10) DEFAULT '1' COMMENT '审核财务id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1123 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='供应商转账记录';
-- ----------------------------
-- Records of hisi_supplier_money
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_system_annex
-- ----------------------------
DROP TABLE IF EXISTS `hisi_system_annex`;
CREATE TABLE `hisi_system_annex` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '关联的数据ID',
`type` varchar(20) NOT NULL DEFAULT '' COMMENT '类型',
`group` varchar(100) NOT NULL DEFAULT 'sys' COMMENT '文件分组',
`file` varchar(255) NOT NULL COMMENT '上传文件',
`hash` varchar(64) NOT NULL COMMENT '文件hash值',
`size` decimal(12,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '附件大小KB',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '使用状态(0未使用，1已使用)',
`ctime` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `hash` (`hash`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='[系统] 上传附件';
-- ----------------------------
-- Records of hisi_system_annex
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_system_annex_group
-- ----------------------------
DROP TABLE IF EXISTS `hisi_system_annex_group`;
CREATE TABLE `hisi_system_annex_group` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL COMMENT '附件分组',
`count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '附件数量',
`size` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '附件大小kb',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='[系统] 附件分组';
-- ----------------------------
-- Records of hisi_system_annex_group
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_system_balance_log
-- ----------------------------
DROP TABLE IF EXISTS `hisi_system_balance_log`;
CREATE TABLE `hisi_system_balance_log` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`sn` varchar(255) NOT NULL COMMENT '订单号',
`type` tinyint(4) NOT NULL COMMENT '进出账类型1 => ''项目收入'',2 => ''产品收入'',3 => ''充值收入'',4=报销单支出;5=供应商采购；6=银行转出，7=银行转入;8=充值疗程卡,9=退卡支出，10=退款支出，11=退产品支出',
`account_id` int(11) NOT NULL COMMENT '账户',
`price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '金额',
`createtime` int(11) NOT NULL COMMENT '创建时间',
`updatetime` int(11) NOT NULL COMMENT '更新时间',
`is_effective` tinyint(4) DEFAULT '1' COMMENT '是否有效 1=有效，2=无效',
`user_id` int(11) DEFAULT NULL COMMENT '用户id',
`cate` tinyint(4) NOT NULL DEFAULT '1' COMMENT '类型：1=入账；2=出账',
`bak` varchar(255) DEFAULT NULL COMMENT '备注',
`other_type` tinyint(5) DEFAULT NULL COMMENT '其他收付款类型',
`shop_id` int(11) NOT NULL DEFAULT '9',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2390 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of hisi_system_balance_log
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_system_config
-- ----------------------------
DROP TABLE IF EXISTS `hisi_system_config`;
CREATE TABLE `hisi_system_config` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`system` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否为系统配置(1是，0否)',
`group` varchar(20) NOT NULL DEFAULT 'base' COMMENT '分组',
`title` varchar(20) NOT NULL COMMENT '配置标题',
`name` varchar(50) NOT NULL COMMENT '配置名称，由英文字母和下划线组成',
`value` text NOT NULL COMMENT '配置值',
`type` varchar(20) NOT NULL DEFAULT 'input' COMMENT '配置类型()',
`options` text NOT NULL COMMENT '配置项(选项名:选项值)',
`url` varchar(255) NOT NULL DEFAULT '' COMMENT '文件上传接口',
`tips` varchar(255) NOT NULL COMMENT '配置提示',
`sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
`status` tinyint(1) unsigned NOT NULL COMMENT '状态',
`ctime` int(10) unsigned NOT NULL DEFAULT '0',
`mtime` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='[系统] 系统配置';
-- ----------------------------
-- Records of hisi_system_config
-- ----------------------------
INSERT INTO `hisi_system_config` VALUES ('1', '1', 'sys', '扩展配置分组', 'config_group', 'printing:打印', 'array', ' ', '', '请按如下格式填写：<br>键值:键名<br>键值:键名<br><span style="color:#f00">键值只能为英文、数字、下划线</span>', '2', '1', '1492140215', '1596098061');
INSERT INTO `hisi_system_config` VALUES ('13', '1', 'base', '网站域名', 'site_domain', '', 'input', '', '', '', '2', '1', '1492140215', '1492140215');
INSERT INTO `hisi_system_config` VALUES ('14', '1', 'upload', '图片上传大小限制', 'upload_image_size', '0', 'input', '', '', '单位：KB，0表示不限制大小', '3', '1', '1490841797', '1491040778');
INSERT INTO `hisi_system_config` VALUES ('15', '1', 'upload', '允许上传图片格式', 'upload_image_ext', 'jpg,png,gif,jpeg,ico', 'input', '', '', '多个格式请用英文逗号（,）隔开', '4', '1', '1490842130', '1491040778');
INSERT INTO `hisi_system_config` VALUES ('16', '1', 'upload', '缩略图裁剪方式', 'thumb_type', '2', 'select', '1:等比例缩放\r\n2:缩放后填充\r\n3:居中裁剪\r\n4:左上角裁剪\r\n5:右下角裁剪\r\n6:固定尺寸缩放\r\n', '', '', '5', '1', '1490842450', '1491040778');
INSERT INTO `hisi_system_config` VALUES ('17', '1', 'upload', '图片水印开关', 'image_watermark', '1', 'switch', '0:关闭\r\n1:开启', '', '', '6', '1', '1490842583', '1491040778');
INSERT INTO `hisi_system_config` VALUES ('18', '1', 'upload', '图片水印图', 'image_watermark_pic', '', 'image', '', '', '', '7', '1', '1490842679', '1491040778');
INSERT INTO `hisi_system_config` VALUES ('19', '1', 'upload', '图片水印透明度', 'image_watermark_opacity', '50', 'input', '', '', '可设置值为0~100，数字越小，透明度越高', '8', '1', '1490857704', '1491040778');
INSERT INTO `hisi_system_config` VALUES ('20', '1', 'upload', '图片水印图位置', 'image_watermark_location', '9', 'select', '7:左下角\r\n1:左上角\r\n4:左居中\r\n9:右下角\r\n3:右上角\r\n6:右居中\r\n2:上居中\r\n8:下居中\r\n5:居中', '', '', '9', '1', '1490858228', '1491040778');
INSERT INTO `hisi_system_config` VALUES ('21', '1', 'upload', '文件上传大小限制', 'upload_file_size', '0', 'input', '', '', '单位：KB，0表示不限制大小', '1', '1', '1490859167', '1491040778');
INSERT INTO `hisi_system_config` VALUES ('22', '1', 'upload', '允许上传文件格式', 'upload_file_ext', 'doc,docx,xls,xlsx,ppt,pptx,pdf,wps,txt,rar,zip,csv', 'input', '', '', '多个格式请用英文逗号（,）隔开', '2', '1', '1490859246', '1491040778');
INSERT INTO `hisi_system_config` VALUES ('23', '1', 'upload', '文字水印开关', 'text_watermark', '0', 'switch', '0:关闭\r\n1:开启', '', '', '10', '1', '1490860872', '1491040778');
INSERT INTO `hisi_system_config` VALUES ('24', '1', 'upload', '文字水印内容', 'text_watermark_content', '', 'input', '', '', '', '11', '1', '1490861005', '1491040778');
INSERT INTO `hisi_system_config` VALUES ('25', '1', 'upload', '文字水印字体', 'text_watermark_font', '', 'file', '', '', '不上传将使用系统默认字体', '12', '1', '1490861117', '1491040778');
INSERT INTO `hisi_system_config` VALUES ('26', '1', 'upload', '文字水印字体大小', 'text_watermark_size', '20', 'input', '', '', '单位：px(像素)', '13', '1', '1490861204', '1491040778');
INSERT INTO `hisi_system_config` VALUES ('27', '1', 'upload', '文字水印颜色', 'text_watermark_color', '#000000', 'input', '', '', '文字水印颜色，格式:#000000', '14', '1', '1490861482', '1491040778');
INSERT INTO `hisi_system_config` VALUES ('28', '1', 'upload', '文字水印位置', 'text_watermark_location', '7', 'select', '7:左下角\r\n1:左上角\r\n4:左居中\r\n9:右下角\r\n3:右上角\r\n6:右居中\r\n2:上居中\r\n8:下居中\r\n5:居中', '', '', '11', '1', '1490861718', '1491040778');
INSERT INTO `hisi_system_config` VALUES ('29', '1', 'upload', '缩略图尺寸', 'thumb_size', '300x300;500x500', 'input', '', '', '为空则不生成，生成 500x500 的缩略图，则填写 500x500，多个规格填写参考 300x300;500x500;800x800', '4', '1', '1490947834', '1491040778');
INSERT INTO `hisi_system_config` VALUES ('30', '1', 'sys', '开发模式', 'app_debug', '1', 'switch', '0:关闭\r\n1:开启', '', '<strong class="red">生产环境下一定要关闭此配置</strong>', '3', '1', '1491005004', '1492093874');
INSERT INTO `hisi_system_config` VALUES ('31', '1', 'sys', '页面Trace', 'app_trace', '0', 'switch', '0:关闭\r\n1:开启', '', '<strong class="red">生产环境下一定要关闭此配置</strong>', '4', '1', '1491005081', '1492093874');
INSERT INTO `hisi_system_config` VALUES ('33', '1', 'sys', '富文本编辑器', 'editor', 'umeditor', 'select', 'ueditor:UEditor\r\numeditor:UMEditor\r\nkindeditor:KindEditor\r\nckeditor:CKEditor', '', '', '0', '1', '1491142648', '1492140215');
INSERT INTO `hisi_system_config` VALUES ('35', '1', 'databases', '备份目录', 'backup_path', './backup/database/', 'input', '', '', '数据库备份路径,路径必须以 / 结尾', '0', '1', '1491881854', '1491965974');
INSERT INTO `hisi_system_config` VALUES ('36', '1', 'databases', '备份分卷大小', 'part_size', '20971520', 'input', '', '', '用于限制压缩后的分卷最大长度。单位：B；建议设置20M', '0', '1', '1491881975', '1491965974');
INSERT INTO `hisi_system_config` VALUES ('37', '1', 'databases', '备份压缩开关', 'compress', '1', 'switch', '0:关闭\r\n1:开启', '', '压缩备份文件需要PHP环境支持gzopen,gzwrite函数', '0', '1', '1491882038', '1491965974');
INSERT INTO `hisi_system_config` VALUES ('38', '1', 'databases', '备份压缩级别', 'compress_level', '4', 'radio', '1:最低\r\n4:一般\r\n9:最高', '', '数据库备份文件的压缩级别，该配置在开启压缩时生效', '0', '1', '1491882154', '1491965974');
INSERT INTO `hisi_system_config` VALUES ('39', '1', 'base', '网站状态', 'site_status', '1', 'switch', '0:关闭\r\n1:开启', '', '站点关闭后将不能访问，后台可正常登录', '1', '1', '1492049460', '1494690024');
INSERT INTO `hisi_system_config` VALUES ('40', '1', 'sys', '后台管理路径', 'admin_path', 'admin.php', 'input', '', '', '必须以.php为后缀', '1', '1', '1492139196', '1492140215');
INSERT INTO `hisi_system_config` VALUES ('41', '1', 'base', '网站标题', 'site_title', '美容后台管理系统', 'input', '', '', '网站标题是体现一个网站的主旨，要做到主题突出、标题简洁、连贯等特点，建议不超过28个字', '6', '1', '1492502354', '1494695131');
INSERT INTO `hisi_system_config` VALUES ('42', '1', 'base', '网站关键词', 'site_keywords', '美容后台管理系统', 'input', '', '', '网页内容所包含的核心搜索关键词，多个关键字请用英文逗号","分隔', '7', '1', '1494690508', '1494690780');
INSERT INTO `hisi_system_config` VALUES ('43', '1', 'base', '网站描述', 'site_description', '', 'textarea', '', '', '网页的描述信息，搜索引擎采纳后，作为搜索结果中的页面摘要显示，建议不超过80个字', '8', '1', '1494690669', '1494691075');
INSERT INTO `hisi_system_config` VALUES ('44', '1', 'base', 'ICP备案信息', 'site_icp', '', 'input', '', '', '请填写ICP备案号，用于展示在网站底部，ICP备案官网：<a href="http://www.miibeian.gov.cn" target="_blank">http://www.miibeian.gov.cn</a>', '9', '1', '1494691721', '1494692046');
INSERT INTO `hisi_system_config` VALUES ('45', '1', 'base', '站点统计代码', 'site_statis', '', 'textarea', '', '', '第三方流量统计代码，前台调用时请先用 htmlspecialchars_decode函数转义输出', '10', '1', '1494691959', '1494694797');
INSERT INTO `hisi_system_config` VALUES ('46', '1', 'base', '网站名称', 'site_name', '美容后台管理系统', 'input', '', '', '将显示在浏览器窗口标题等位置', '3', '1', '1494692103', '1494694680');
INSERT INTO `hisi_system_config` VALUES ('47', '1', 'base', '网站LOGO', 'site_logo', '', 'image', '', '', '网站LOGO图片', '4', '1', '1494692345', '1494693235');
INSERT INTO `hisi_system_config` VALUES ('48', '1', 'base', '网站图标', 'site_favicon', '', 'image', '', '/system/annex/favicon', '又叫网站收藏夹图标，它显示位于浏览器的地址栏或者标题前面，<strong class="red">.ico格式</strong>，<a href="https://www.baidu.com/s?ie=UTF-8&wd=favicon" target="_blank">点此了解网站图标</a>', '5', '1', '1494692781', '1494693966');
INSERT INTO `hisi_system_config` VALUES ('49', '1', 'base', '手机网站', 'wap_site_status', '1', 'switch', '0:关闭\r\n1:开启', '', '如果有手机网站，请设置为开启状态，否则只显示PC网站', '2', '1', '1498405436', '1498405436');
INSERT INTO `hisi_system_config` VALUES ('50', '1', 'sys', '云端推送', 'cloud_push', '0', 'switch', '0:关闭\r\n1:开启', '', '关闭之后，无法通过云端推送安装扩展', '5', '1', '1504250320', '1504250320');
INSERT INTO `hisi_system_config` VALUES ('51', '1', 'base', '手机网站域名', 'wap_domain', '', 'input', '', '', '手机访问将自动跳转至此域名，示例：http://m.domain.com', '2', '1', '1504304776', '1504304837');
INSERT INTO `hisi_system_config` VALUES ('52', '1', 'sys', '多语言支持', 'multi_language', '0', 'switch', '0:关闭\r\n1:开启', '', '开启后你可以自由上传多种语言包', '6', '1', '1506532211', '1506532211');
INSERT INTO `hisi_system_config` VALUES ('53', '1', 'sys', '后台白名单验证', 'admin_whitelist_verify', '0', 'switch', '0:禁用\r\n1:启用', '', '禁用后不存在的菜单节点将不在提示', '7', '1', '1542012232', '1542012321');
INSERT INTO `hisi_system_config` VALUES ('54', '1', 'sys', '系统日志保留', 'system_log_retention', '30', 'input', '', '', '单位天，系统将自动清除 ? 天前的系统日志', '8', '1', '1542013958', '1542014158');
INSERT INTO `hisi_system_config` VALUES ('55', '1', 'upload', '上传驱动', 'upload_driver', 'local', 'select', 'local:本地上传', '', '资源上传驱动设置', '0', '1', '1558599270', '1558618703');
INSERT INTO `hisi_system_config` VALUES ('56', '0', 'printing', '操作单-标题', 'print_caozuo_title', '澜悦顾问单', 'input', '', '', '', '0', '1', '1596098135', '1596098135');
INSERT INTO `hisi_system_config` VALUES ('57', '0', 'printing', '操作单-logo', 'print_caozuo_logo', '/upload/sys/image/8d/9e3b49e5824de5b553030f96b4b119.jpg', 'image', '', '', '', '0', '1', '1596098192', '1596098192');
INSERT INTO `hisi_system_config` VALUES ('58', '0', 'printing', '产品单-标题', 'print_product_title', '澜悦产品单', 'input', '', '', '', '0', '1', '1596101089', '1596101089');
INSERT INTO `hisi_system_config` VALUES ('59', '0', 'printing', '产品单-logo', 'print_product_logo', '/upload/sys/image/8d/9e3b49e5824de5b553030f96b4b119.jpg', 'image', '', '', '', '0', '1', '1596101161', '1596101161');
INSERT INTO `hisi_system_config` VALUES ('60', '0', 'printing', '寄存单-标题', 'print_jicun_title', '寄存出库单', 'input', '', '', '', '0', '1', '1596101370', '1596101370');
INSERT INTO `hisi_system_config` VALUES ('61', '0', 'printing', '寄存单-logo', 'print_jicun_logo', '/upload/sys/image/8d/9e3b49e5824de5b553030f96b4b119.jpg', 'image', '', '', '', '0', '1', '1596157485', '1596157485');
INSERT INTO `hisi_system_config` VALUES ('62', '0', 'printing', '报销单-标题', 'print_baoxiao_title', '报销单', 'input', '', '', '', '0', '1', '1596157646', '1596157646');
INSERT INTO `hisi_system_config` VALUES ('63', '0', 'printing', '报销单-logo', 'print_baoxiao_logo', '/upload/sys/image/8d/9e3b49e5824de5b553030f96b4b119.jpg', 'image', '', '', '', '0', '1', '1596157683', '1596157683');
INSERT INTO `hisi_system_config` VALUES ('64', '0', 'printing', '疗程充值-标题', 'print_lccz_title', '澜悦充值单', 'input', '', '', '', '0', '1', '1596157828', '1596157828');
INSERT INTO `hisi_system_config` VALUES ('65', '0', 'printing', '疗程充值-logo', 'print_lccz_logo', '/upload/sys/image/8d/9e3b49e5824de5b553030f96b4b119.jpg', 'image', '', '', '', '0', '1', '1596157860', '1596157860');
INSERT INTO `hisi_system_config` VALUES ('66', '0', 'printing', '会员卡充值-标题', 'print_hykcz_title', '澜悦充值单', 'input', '', '', '', '0', '1', '1596157972', '1596157972');
INSERT INTO `hisi_system_config` VALUES ('67', '0', 'printing', '会员卡充值-logo', 'print_hykcz_logo', '/upload/sys/image/8d/9e3b49e5824de5b553030f96b4b119.jpg', 'image', '', '', '', '0', '1', '1596158001', '1596158001');
INSERT INTO `hisi_system_config` VALUES ('68', '0', 'printing', '售后单-标题', 'print_sh_title', '澜悦售后单', 'input', '', '', '', '0', '1', '1596158583', '1596158583');
INSERT INTO `hisi_system_config` VALUES ('69', '0', 'printing', '售后单-logo', 'print_sh_logo', '/upload/sys/image/8d/9e3b49e5824de5b553030f96b4b119.jpg', 'image', '', '', '', '0', '1', '1596158625', '1596158625');
-- ----------------------------
-- Table structure for hisi_system_hook
-- ----------------------------
DROP TABLE IF EXISTS `hisi_system_hook`;
CREATE TABLE `hisi_system_hook` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`system` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '系统插件',
`name` varchar(50) NOT NULL DEFAULT '' COMMENT '钩子名称',
`source` varchar(50) NOT NULL DEFAULT '' COMMENT '钩子来源[plugins.插件名，module.模块名]',
`intro` varchar(200) NOT NULL DEFAULT '' COMMENT '钩子简介',
`status` tinyint(1) unsigned NOT NULL DEFAULT '1',
`ctime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
`mtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='[系统] 钩子表';
-- ----------------------------
-- Records of hisi_system_hook
-- ----------------------------
INSERT INTO `hisi_system_hook` VALUES ('1', '1', 'system_admin_index', '', '后台首页', '1', '1490885108', '1490885108');
INSERT INTO `hisi_system_hook` VALUES ('2', '1', 'system_admin_tips', '', '后台所有页面提示', '1', '1490713165', '1490885137');
INSERT INTO `hisi_system_hook` VALUES ('3', '1', 'system_annex_upload', '', '附件上传钩子，可扩展上传到第三方存储', '1', '1490884242', '1490885121');
INSERT INTO `hisi_system_hook` VALUES ('4', '1', 'system_member_login', '', '会员登陆成功之后的动作', '1', '1490885108', '1490885108');
INSERT INTO `hisi_system_hook` VALUES ('5', '1', 'system_member_register', '', '会员注册成功后的动作', '1', '1512610518', '1512610518');
INSERT INTO `hisi_system_hook` VALUES ('6', '0', 'user_login', 'module.user', '会员登陆成功之后的动作', '1', '1581406963', '1581406963');
INSERT INTO `hisi_system_hook` VALUES ('7', '0', 'user_register', 'module.user', '会员注册成功后的动作', '1', '1581406963', '1581406963');
INSERT INTO `hisi_system_hook` VALUES ('8', '0', 'user_delete', 'module.user', '会员删除成功后的动作', '1', '1581406963', '1581406963');
-- ----------------------------
-- Table structure for hisi_system_hook_plugins
-- ----------------------------
DROP TABLE IF EXISTS `hisi_system_hook_plugins`;
CREATE TABLE `hisi_system_hook_plugins` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`hook` varchar(32) NOT NULL COMMENT '钩子id',
`plugins` varchar(32) NOT NULL COMMENT '插件标识',
`ctime` int(11) unsigned NOT NULL DEFAULT '0',
`mtime` int(11) unsigned NOT NULL DEFAULT '0',
`sort` int(11) unsigned NOT NULL DEFAULT '0',
`status` tinyint(2) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='[系统] 钩子-插件对应表';
-- ----------------------------
-- Records of hisi_system_hook_plugins
-- ----------------------------
INSERT INTO `hisi_system_hook_plugins` VALUES ('1', 'system_admin_index', 'hisiphp', '1509380301', '1509380301', '0', '1');
-- ----------------------------
-- Table structure for hisi_system_language
-- ----------------------------
DROP TABLE IF EXISTS `hisi_system_language`;
CREATE TABLE `hisi_system_language` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '' COMMENT '语言包名称',
`code` varchar(20) NOT NULL DEFAULT '' COMMENT '编码',
`locale` varchar(255) NOT NULL DEFAULT '' COMMENT '本地浏览器语言编码',
`icon` varchar(30) NOT NULL DEFAULT '' COMMENT '图标',
`pack` varchar(100) NOT NULL DEFAULT '' COMMENT '上传的语言包',
`sort` tinyint(2) unsigned NOT NULL DEFAULT '1',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `code` (`code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='[系统] 语言包';
-- ----------------------------
-- Records of hisi_system_language
-- ----------------------------
INSERT INTO `hisi_system_language` VALUES ('1', '简体中文', 'zh-cn', 'zh-CN,zh-CN.UTF-8,zh-cn', '', '1', '1', '1');
-- ----------------------------
-- Table structure for hisi_system_log
-- ----------------------------
DROP TABLE IF EXISTS `hisi_system_log`;
CREATE TABLE `hisi_system_log` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`title` varchar(100) DEFAULT '',
`url` varchar(200) DEFAULT '',
`param` text,
`remark` varchar(255) DEFAULT '',
`count` int(10) unsigned NOT NULL DEFAULT '1',
`ip` varchar(128) DEFAULT '',
`ctime` int(10) unsigned NOT NULL DEFAULT '0',
`mtime` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=64683 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='[系统] 操作日志';
-- ----------------------------
-- Records of hisi_system_log
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_system_menu
-- ----------------------------
DROP TABLE IF EXISTS `hisi_system_menu`;
CREATE TABLE `hisi_system_menu` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(5) unsigned NOT NULL DEFAULT '0' COMMENT '管理员ID(快捷菜单专用)',
`pid` int(10) unsigned NOT NULL DEFAULT '0',
`module` varchar(20) NOT NULL COMMENT '模块名或插件名，插件名格式:plugins.插件名',
`title` varchar(20) NOT NULL COMMENT '菜单标题',
`icon` varchar(80) NOT NULL DEFAULT 'aicon ai-shezhi' COMMENT '菜单图标',
`url` varchar(200) NOT NULL COMMENT '链接地址(模块/控制器/方法)',
`param` varchar(200) NOT NULL DEFAULT '' COMMENT '扩展参数',
`target` varchar(20) NOT NULL DEFAULT '_self' COMMENT '打开方式(_blank,_self)',
`sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
`debug` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '开发模式可见',
`system` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否为系统菜单，系统菜单不可删除',
`nav` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否为菜单显示，1显示0不显示',
`status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态1显示，0隐藏',
`ctime` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=332 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='[系统] 管理菜单';
-- ----------------------------
-- Records of hisi_system_menu
-- ----------------------------
INSERT INTO `hisi_system_menu` VALUES ('1', '0', '0', 'system', '首页', '', 'system/index', '', '_self', '0', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('2', '0', '0', 'system', '系统', '', 'system/system', '', '_self', '1', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('3', '0', '0', 'system', '插件', 'aicon ai-shezhi', 'system/plugins', '', '_self', '2', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('4', '0', '1', 'system', '快捷菜单', 'aicon ai-caidan', 'system/quick', '', '_self', '0', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('5', '0', '3', 'system', '插件列表', 'aicon ai-mokuaiguanli', 'system/plugins', '', '_self', '0', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('6', '0', '2', 'system', '系统基础', 'aicon ai-gongneng', 'system/system', '', '_self', '1', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('7', '0', '17', 'system', '导入主题SQL', '', 'system/module/exeSql', '', '_self', '10', '0', '1', '0', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('8', '0', '2', 'system', '系统扩展', 'aicon ai-shezhi', 'system/extend', '', '_self', '3', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('9', '0', '4', 'system', '预留占位', '', '', '', '_self', '4', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('10', '0', '6', 'system', '系统设置', 'aicon ai-icon01', 'system/system/index', '', '_self', '1', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('11', '0', '6', 'system', '配置管理', 'aicon ai-peizhiguanli', 'system/config/index', '', '_self', '2', '1', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('12', '0', '6', 'system', '系统菜单', 'aicon ai-systemmenu', 'system/menu/index', '', '_self', '3', '1', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('13', '0', '6', 'system', '管理员角色', '', 'system/user/role', '', '_self', '4', '0', '1', '0', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('14', '0', '6', 'system', '系统管理员', 'aicon ai-tubiao05', 'system/user/index', '', '_self', '5', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('15', '0', '6', 'system', '系统日志', 'aicon ai-xitongrizhi-tiaoshi', 'system/log/index', '', '_self', '7', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('16', '0', '6', 'system', '附件管理', '', 'system/annex/index', '', '_self', '8', '0', '1', '0', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('17', '0', '8', 'system', '本地模块', 'aicon ai-mokuaiguanli1', 'system/module/index', '', '_self', '1', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('18', '0', '8', 'system', '本地插件', 'aicon ai-chajianguanli', 'system/plugins/index', '', '_self', '2', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('19', '0', '8', 'system', '插件钩子', 'aicon ai-icon-test', 'system/hook/index', '', '_self', '3', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('20', '0', '4', 'system', '预留占位', '', '', '', '_self', '1', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('21', '0', '4', 'system', '预留占位', '', '', '', '_self', '2', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('22', '0', '4', 'system', '预留占位', '', '', '', '_self', '1', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('23', '0', '4', 'system', '预留占位', '', '', '', '_self', '2', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('24', '0', '4', 'system', '后台首页', '', 'system/index/index', '', '_self', '100', '0', '1', '0', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('25', '0', '4', 'system', '清空缓存', '', 'system/index/clear', '', '_self', '2', '0', '1', '0', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('26', '0', '12', 'system', '添加菜单', '', 'system/menu/add', '', '_self', '1', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('27', '0', '12', 'system', '修改菜单', '', 'system/menu/edit', '', '_self', '2', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('28', '0', '12', 'system', '删除菜单', '', 'system/menu/del', '', '_self', '3', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('29', '0', '12', 'system', '状态设置', '', 'system/menu/status', '', '_self', '4', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('30', '0', '12', 'system', '排序设置', '', 'system/menu/sort', '', '_self', '5', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('31', '0', '12', 'system', '添加快捷菜单', '', 'system/menu/quick', '', '_self', '6', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('32', '0', '12', 'system', '导出菜单', '', 'system/menu/export', '', '_self', '7', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('33', '0', '13', 'system', '添加角色', '', 'system/user/addrole', '', '_self', '1', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('34', '0', '13', 'system', '修改角色', '', 'system/user/editrole', '', '_self', '2', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('35', '0', '13', 'system', '删除角色', '', 'system/user/delrole', '', '_self', '3', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('36', '0', '13', 'system', '状态设置', '', 'system/user/statusRole', '', '_self', '4', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('37', '0', '14', 'system', '添加管理员', '', 'system/user/adduser', '', '_self', '1', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('38', '0', '14', 'system', '修改管理员', '', 'system/user/edituser', '', '_self', '2', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('39', '0', '14', 'system', '删除管理员', '', 'system/user/deluser', '', '_self', '3', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('40', '0', '14', 'system', '状态设置', '', 'system/user/status', '', '_self', '4', '0', '1', '0', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('41', '0', '4', 'system', '个人信息设置', '', 'system/user/info', '', '_self', '5', '0', '1', '0', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('42', '0', '18', 'system', '安装插件', '', 'system/plugins/install', '', '_self', '1', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('43', '0', '18', 'system', '卸载插件', '', 'system/plugins/uninstall', '', '_self', '2', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('44', '0', '18', 'system', '删除插件', '', 'system/plugins/del', '', '_self', '3', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('45', '0', '18', 'system', '状态设置', '', 'system/plugins/status', '', '_self', '4', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('46', '0', '18', 'system', '生成插件', '', 'system/plugins/design', '', '_self', '5', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('47', '0', '18', 'system', '运行插件', '', 'system/plugins/run', '', '_self', '6', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('48', '0', '18', 'system', '更新插件', '', 'system/plugins/update', '', '_self', '7', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('49', '0', '18', 'system', '插件配置', '', 'system/plugins/setting', '', '_self', '8', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('50', '0', '19', 'system', '添加钩子', '', 'system/hook/add', '', '_self', '1', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('51', '0', '19', 'system', '修改钩子', '', 'system/hook/edit', '', '_self', '2', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('52', '0', '19', 'system', '删除钩子', '', 'system/hook/del', '', '_self', '3', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('53', '0', '19', 'system', '状态设置', '', 'system/hook/status', '', '_self', '4', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('54', '0', '19', 'system', '插件排序', '', 'system/hook/sort', '', '_self', '5', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('55', '0', '11', 'system', '添加配置', '', 'system/config/add', '', '_self', '1', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('56', '0', '11', 'system', '修改配置', '', 'system/config/edit', '', '_self', '2', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('57', '0', '11', 'system', '删除配置', '', 'system/config/del', '', '_self', '3', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('58', '0', '11', 'system', '状态设置', '', 'system/config/status', '', '_self', '4', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('59', '0', '11', 'system', '排序设置', '', 'system/config/sort', '', '_self', '5', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('60', '0', '10', 'system', '基础配置', '', 'system/system/index', 'group=base', '_self', '1', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('61', '0', '10', 'system', '系统配置', '', 'system/system/index', 'group=sys', '_self', '2', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('62', '0', '10', 'system', '上传配置', '', 'system/system/index', 'group=upload', '_self', '3', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('63', '0', '10', 'system', '开发配置', '', 'system/system/index', 'group=develop', '_self', '4', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('64', '0', '17', 'system', '生成模块', '', 'system/module/design', '', '_self', '6', '1', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('65', '0', '17', 'system', '安装模块', '', 'system/module/install', '', '_self', '1', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('66', '0', '17', 'system', '卸载模块', '', 'system/module/uninstall', '', '_self', '2', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('67', '0', '17', 'system', '状态设置', '', 'system/module/status', '', '_self', '3', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('68', '0', '17', 'system', '设置默认模块', '', 'system/module/setdefault', '', '_self', '4', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('69', '0', '17', 'system', '删除模块', '', 'system/module/del', '', '_self', '5', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('70', '0', '4', 'system', '预留占位', '', '', '', '_self', '1', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('71', '0', '4', 'system', '预留占位', '', '', '', '_self', '2', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('72', '0', '4', 'system', '预留占位', '', '', '', '_self', '3', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('73', '0', '4', 'system', '预留占位', '', '', '', '_self', '4', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('74', '0', '4', 'system', '预留占位', '', '', '', '_self', '5', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('75', '0', '4', 'system', '预留占位', '', '', '', '_self', '0', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('76', '0', '4', 'system', '预留占位', '', '', '', '_self', '0', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('77', '0', '4', 'system', '预留占位', '', '', '', '_self', '0', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('78', '0', '16', 'system', '附件上传', '', 'system/annex/upload', '', '_self', '1', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('79', '0', '16', 'system', '删除附件', '', 'system/annex/del', '', '_self', '2', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('80', '0', '8', 'system', '框架升级', 'aicon ai-iconfontshengji', 'system/upgrade/index', '', '_self', '4', '0', '1', '1', '1', '1491352728');
INSERT INTO `hisi_system_menu` VALUES ('81', '0', '80', 'system', '获取升级列表', '', 'system/upgrade/lists', '', '_self', '0', '0', '1', '1', '1', '1491353504');
INSERT INTO `hisi_system_menu` VALUES ('82', '0', '80', 'system', '安装升级包', '', 'system/upgrade/install', '', '_self', '0', '0', '1', '1', '1', '1491353568');
INSERT INTO `hisi_system_menu` VALUES ('83', '0', '80', 'system', '下载升级包', '', 'system/upgrade/download', '', '_self', '0', '0', '1', '1', '1', '1491395830');
INSERT INTO `hisi_system_menu` VALUES ('84', '0', '6', 'system', '数据库管理', 'aicon ai-shujukuguanli', 'system/database/index', '', '_self', '6', '0', '1', '1', '1', '1491461136');
INSERT INTO `hisi_system_menu` VALUES ('85', '0', '84', 'system', '备份数据库', '', 'system/database/export', '', '_self', '0', '0', '1', '1', '1', '1491461250');
INSERT INTO `hisi_system_menu` VALUES ('86', '0', '84', 'system', '恢复数据库', '', 'system/database/import', '', '_self', '0', '0', '1', '1', '1', '1491461315');
INSERT INTO `hisi_system_menu` VALUES ('87', '0', '84', 'system', '优化数据库', '', 'system/database/optimize', '', '_self', '0', '0', '1', '1', '1', '1491467000');
INSERT INTO `hisi_system_menu` VALUES ('88', '0', '84', 'system', '删除备份', '', 'system/database/del', '', '_self', '0', '0', '1', '1', '1', '1491467058');
INSERT INTO `hisi_system_menu` VALUES ('89', '0', '84', 'system', '修复数据库', '', 'system/database/repair', '', '_self', '0', '0', '1', '1', '1', '1491880879');
INSERT INTO `hisi_system_menu` VALUES ('90', '0', '21', 'system', '设置默认等级', '', 'system/member/setdefault', '', '_self', '0', '0', '1', '1', '1', '1491966585');
INSERT INTO `hisi_system_menu` VALUES ('91', '0', '10', 'system', '数据库配置', '', 'system/system/index', 'group=databases', '_self', '5', '0', '1', '0', '1', '1492072213');
INSERT INTO `hisi_system_menu` VALUES ('92', '0', '17', 'system', '模块打包', '', 'system/module/package', '', '_self', '7', '0', '1', '1', '1', '1492134693');
INSERT INTO `hisi_system_menu` VALUES ('93', '0', '18', 'system', '插件打包', '', 'system/plugins/package', '', '_self', '0', '0', '1', '1', '1', '1492134743');
INSERT INTO `hisi_system_menu` VALUES ('94', '0', '17', 'system', '主题管理', '', 'system/module/theme', '', '_self', '8', '0', '1', '1', '1', '1492433470');
INSERT INTO `hisi_system_menu` VALUES ('95', '0', '17', 'system', '设置默认主题', '', 'system/module/setdefaulttheme', '', '_self', '9', '0', '1', '1', '1', '1492433618');
INSERT INTO `hisi_system_menu` VALUES ('96', '0', '17', 'system', '删除主题', '', 'system/module/deltheme', '', '_self', '10', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('97', '0', '6', 'system', '语言包管理', '', 'system/language/index', '', '_self', '9', '0', '1', '0', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('98', '0', '97', 'system', '添加语言包', '', 'system/language/add', '', '_self', '100', '0', '1', '0', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('99', '0', '97', 'system', '修改语言包', '', 'system/language/edit', '', '_self', '100', '0', '1', '0', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('100', '0', '97', 'system', '删除语言包', '', 'system/language/del', '', '_self', '100', '0', '1', '0', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('101', '0', '97', 'system', '排序设置', '', 'system/language/sort', '', '_self', '100', '0', '1', '0', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('102', '0', '97', 'system', '状态设置', '', 'system/language/status', '', '_self', '100', '0', '1', '0', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('103', '0', '16', 'system', '收藏夹图标上传', '', 'system/annex/favicon', '', '_self', '3', '0', '1', '0', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('104', '0', '17', 'system', '导入模块', '', 'system/module/import', '', '_self', '11', '0', '1', '0', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('105', '0', '4', 'system', '后台首页', '', 'system/index/welcome', '', '_self', '100', '0', '1', '0', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('106', '0', '4', 'system', '布局切换', '', 'system/user/iframe', '', '_self', '100', '0', '1', '0', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('107', '0', '15', 'system', '删除日志', '', 'system/log/del', 'table=admin_log', '_self', '100', '0', '1', '0', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('108', '0', '15', 'system', '清空日志', '', 'system/log/clear', '', '_self', '100', '0', '1', '0', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('109', '0', '17', 'system', '编辑模块', '', 'system/module/edit', '', '_self', '100', '0', '1', '0', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('110', '0', '17', 'system', '模块图标上传', '', 'system/module/icon', '', '_self', '100', '0', '1', '0', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('111', '0', '18', 'system', '导入插件', '', 'system/plugins/import', '', '_self', '100', '0', '1', '0', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('112', '0', '4', 'system', '钩子插件状态', '', 'system/hook/hookPluginsStatus', '', '_self', '100', '0', '1', '0', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('113', '0', '4', 'system', '设置主题', '', 'system/user/setTheme', '', '_self', '100', '0', '1', '0', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('114', '0', '8', 'system', '应用市场', 'aicon ai-app-store', 'system/store/index', '', '_self', '0', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('115', '0', '114', 'system', '安装应用', '', 'system/store/install', '', '_self', '0', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('116', '0', '21', 'system', '重置密码', '', 'system/member/resetPwd', '', '_self', '6', '0', '1', '1', '1', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('117', '0', '4', 'system', '预留占位', '', '', '', '_self', '100', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('118', '0', '4', 'system', '预留占位', '', '', '', '_self', '100', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('119', '0', '4', 'system', '预留占位', '', '', '', '_self', '100', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('120', '0', '4', 'system', '预留占位', '', '', '', '_self', '100', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('121', '0', '4', 'system', '预留占位', '', '', '', '_self', '100', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('122', '0', '4', 'system', '预留占位', '', '', '', '_self', '100', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('123', '0', '4', 'system', '预留占位', '', '', '', '_self', '100', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('124', '0', '4', 'system', '预留占位', '', '', '', '_self', '100', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('125', '0', '4', 'system', '预留占位', '', '', '', '_self', '100', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('126', '0', '4', 'system', '预留占位', '', '', '', '_self', '100', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('127', '0', '4', 'system', '预留占位', '', '', '', '_self', '100', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('128', '0', '4', 'system', '预留占位', '', '', '', '_self', '100', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('129', '0', '4', 'system', '预留占位', '', '', '', '_self', '100', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('130', '0', '4', 'system', '预留占位', '', '', '', '_self', '100', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('131', '0', '4', 'system', '预留占位', '', '', '', '_self', '100', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('132', '0', '4', 'system', '预留占位', '', '', '', '_self', '100', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('133', '0', '4', 'system', '预留占位', '', '', '', '_self', '100', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('134', '0', '4', 'system', '预留占位', '', '', '', '_self', '100', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('135', '0', '4', 'system', '预留占位', '', '', '', '_self', '100', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('136', '0', '4', 'system', '预留占位', '', '', '', '_self', '100', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('137', '0', '4', 'system', '预留占位', '', '', '', '_self', '100', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('138', '0', '4', 'system', '预留占位', '', '', '', '_self', '100', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('139', '0', '4', 'system', '预留占位', '', '', '', '_self', '100', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('140', '0', '4', 'system', '预留占位', '', '', '', '_self', '100', '0', '1', '1', '0', '1490315067');
INSERT INTO `hisi_system_menu` VALUES ('141', '0', '0', 'developer', '开发助手', 'aicon ai-shezhi', 'developer', '', '_self', '100', '0', '0', '1', '0', '1581406908');
INSERT INTO `hisi_system_menu` VALUES ('142', '0', '141', 'developer', '应用中心', 'aicon ai-shezhi', 'developer/index', '', '_self', '0', '0', '0', '1', '1', '1581406908');
INSERT INTO `hisi_system_menu` VALUES ('143', '0', '142', 'developer', '模块列表', 'aicon ai-caidan', 'developer/module/index', '', '_self', '0', '0', '0', '1', '1', '1581406908');
INSERT INTO `hisi_system_menu` VALUES ('144', '0', '143', 'developer', '设计模块', '', 'developer/module/design', '', '_self', '0', '0', '0', '0', '1', '1581406908');
INSERT INTO `hisi_system_menu` VALUES ('145', '0', '143', 'developer', '版本管理', '', 'developer/module/versions', '', '_self', '0', '0', '0', '0', '1', '1581406908');
INSERT INTO `hisi_system_menu` VALUES ('146', '0', '143', 'developer', '发布新版本', '', 'developer/module/addVersion', '', '_self', '0', '0', '0', '0', '1', '1581406908');
INSERT INTO `hisi_system_menu` VALUES ('147', '0', '143', 'developer', '修改版本', '', 'developer/module/editVersion', '', '_self', '0', '0', '0', '0', '1', '1581406908');
INSERT INTO `hisi_system_menu` VALUES ('148', '0', '143', 'developer', '版本打包', '', 'developer/module/package', '', '_self', '0', '0', '0', '0', '1', '1581406908');
INSERT INTO `hisi_system_menu` VALUES ('149', '0', '143', 'developer', '版本状态', '', 'developer/module/status', 'table=developer_versions', '_self', '0', '0', '0', '0', '1', '1581406908');
INSERT INTO `hisi_system_menu` VALUES ('150', '0', '143', 'developer', '删除版本', '', 'developer/module/delVersion', '', '_self', '0', '0', '0', '0', '1', '1581406908');
INSERT INTO `hisi_system_menu` VALUES ('151', '0', '143', 'developer', '生成模块', '', 'developer/module/build', '', '_self', '0', '0', '0', '0', '1', '1581406908');
INSERT INTO `hisi_system_menu` VALUES ('152', '0', '143', 'developer', '图标上传', '', 'developer/module/icon', '', '_self', '0', '0', '0', '0', '1', '1581406908');
INSERT INTO `hisi_system_menu` VALUES ('153', '0', '142', 'developer', '插件列表', 'aicon ai-caidan', 'developer/plugins/index', '', '_self', '0', '0', '0', '1', '1', '1581406908');
INSERT INTO `hisi_system_menu` VALUES ('154', '0', '153', 'developer', '设计插件', '', 'developer/plugins/design', '', '_self', '0', '0', '0', '0', '1', '1581406908');
INSERT INTO `hisi_system_menu` VALUES ('155', '0', '153', 'developer', '版本管理', '', 'developer/plugins/versions', '', '_self', '0', '0', '0', '0', '1', '1581406908');
INSERT INTO `hisi_system_menu` VALUES ('156', '0', '153', 'developer', '发布新版本', '', 'developer/plugins/addVersion', '', '_self', '0', '0', '0', '0', '1', '1581406908');
INSERT INTO `hisi_system_menu` VALUES ('157', '0', '153', 'developer', '修改版本', '', 'developer/plugins/editVersion', '', '_self', '0', '0', '0', '0', '1', '1581406908');
INSERT INTO `hisi_system_menu` VALUES ('158', '0', '153', 'developer', '版本打包', '', 'developer/plugins/package', '', '_self', '0', '0', '0', '0', '1', '1581406908');
INSERT INTO `hisi_system_menu` VALUES ('159', '0', '153', 'developer', '版本状态', '', 'developer/plugins/status', 'table=developer_versions', '_self', '0', '0', '0', '0', '1', '1581406908');
INSERT INTO `hisi_system_menu` VALUES ('160', '0', '153', 'developer', '删除版本', '', 'developer/plugins/delVersion', '', '_self', '0', '0', '0', '0', '1', '1581406908');
INSERT INTO `hisi_system_menu` VALUES ('161', '0', '153', 'developer', '生成插件', '', 'developer/plugins/build', '', '_self', '0', '0', '0', '0', '1', '1581406908');
INSERT INTO `hisi_system_menu` VALUES ('162', '0', '153', 'developer', '图标上传', '', 'developer/plugins/icon', '', '_self', '0', '0', '0', '0', '1', '1581406908');
INSERT INTO `hisi_system_menu` VALUES ('163', '0', '0', 'user', '会员', 'hs-icon hs-icon-vip', 'user', '', '_self', '3', '0', '0', '1', '1', '1581406963');
INSERT INTO `hisi_system_menu` VALUES ('164', '0', '163', 'user', '会员管理', 'hs-icon hs-icon-users', 'user/index', '', '_self', '2', '0', '1', '1', '1', '1581406963');
INSERT INTO `hisi_system_menu` VALUES ('165', '0', '164', 'user', '会员分组', '', 'user/group/index', '', '_self', '1', '0', '1', '1', '0', '1581406963');
INSERT INTO `hisi_system_menu` VALUES ('166', '0', '165', 'user', '添加分组', '', 'user/group/add', '', '_self', '0', '0', '1', '1', '1', '1581406963');
INSERT INTO `hisi_system_menu` VALUES ('167', '0', '165', 'user', '修改分组', '', 'user/group/edit', '', '_self', '0', '0', '1', '1', '1', '1581406963');
INSERT INTO `hisi_system_menu` VALUES ('168', '0', '165', 'user', '删除分组', '', 'user/group/del', '', '_self', '0', '0', '1', '1', '1', '1581406963');
INSERT INTO `hisi_system_menu` VALUES ('169', '0', '165', 'user', '设置默认分组', '', 'user/group/setDefault', '', '_self', '0', '0', '1', '1', '1', '1581406963');
INSERT INTO `hisi_system_menu` VALUES ('170', '0', '164', 'user', '会员列表', '', 'user/index/index', '', '_self', '2', '0', '1', '1', '1', '1581406963');
INSERT INTO `hisi_system_menu` VALUES ('171', '0', '170', 'user', '添加会员', '', 'user/index/add', '', '_self', '1', '0', '1', '1', '1', '1581406963');
INSERT INTO `hisi_system_menu` VALUES ('172', '0', '170', 'user', '修改会员', '', 'user/index/edit', '', '_self', '2', '0', '1', '1', '1', '1581406963');
INSERT INTO `hisi_system_menu` VALUES ('173', '0', '170', 'user', '删除会员', '', 'user/index/del', '', '_self', '3', '0', '1', '1', '1', '1581406963');
INSERT INTO `hisi_system_menu` VALUES ('174', '0', '170', 'user', '状态设置', '', 'user/index/status', '', '_self', '4', '0', '1', '1', '1', '1581406963');
INSERT INTO `hisi_system_menu` VALUES ('175', '0', '170', 'user', '[弹窗]会员选择', '', 'user/index/pop', '', '_self', '5', '0', '1', '1', '1', '1581406963');
INSERT INTO `hisi_system_menu` VALUES ('176', '0', '170', 'user', '重置密码', '', 'user/index/resetPwd', '', '_self', '6', '0', '1', '1', '1', '1581406963');
INSERT INTO `hisi_system_menu` VALUES ('177', '0', '0', 'shouyin', '收银管理', 'aicon ai-shezhi', 'shouyin', '', '_self', '4', '0', '0', '1', '1', '1581665287');
INSERT INTO `hisi_system_menu` VALUES ('178', '0', '0', 'shop', '店铺管理', 'aicon ai-shezhi', 'shop', '', '_self', '5', '0', '0', '1', '1', '1581665362');
INSERT INTO `hisi_system_menu` VALUES ('179', '0', '178', 'shop', '分店管理', 'aicon ai-shouye', 'shop', '', '_self', '0', '0', '0', '1', '1', '1581665508');
INSERT INTO `hisi_system_menu` VALUES ('180', '0', '179', 'shop', '分店列表', '', 'shop/index/index', '', '_self', '0', '0', '0', '1', '1', '1581665570');
INSERT INTO `hisi_system_menu` VALUES ('181', '0', '0', 'example', '示例模块', 'aicon ai-shezhi', 'example', '', '_self', '100', '0', '0', '1', '0', '1581667458');
INSERT INTO `hisi_system_menu` VALUES ('182', '0', '181', 'example', '新闻管理', 'aicon ai-shezhi', 'example/index', '', '_self', '0', '0', '0', '1', '1', '1581667458');
INSERT INTO `hisi_system_menu` VALUES ('183', '0', '182', 'example', '新闻分类', 'aicon ai-shezhi', 'example/category/index', '', '_self', '0', '0', '0', '1', '1', '1581667458');
INSERT INTO `hisi_system_menu` VALUES ('184', '0', '183', 'example', '添加分类', '', 'example/category/add', '', '_self', '0', '0', '0', '1', '1', '1581667458');
INSERT INTO `hisi_system_menu` VALUES ('185', '0', '183', 'example', '修改分类', '', 'example/category/edit', '', '_self', '0', '0', '0', '1', '1', '1581667458');
INSERT INTO `hisi_system_menu` VALUES ('186', '0', '183', 'example', '删除分类', '', 'example/category/del', '', '_self', '0', '0', '0', '1', '1', '1581667458');
INSERT INTO `hisi_system_menu` VALUES ('187', '0', '183', 'example', '状态设置', '', 'example/category/status', 'table=example_category', '_self', '0', '0', '0', '1', '1', '1581667458');
INSERT INTO `hisi_system_menu` VALUES ('188', '0', '182', 'example', '新闻列表', 'aicon ai-shezhi', 'example/index/index', '', '_self', '1', '0', '0', '1', '1', '1581667458');
INSERT INTO `hisi_system_menu` VALUES ('189', '0', '188', 'example', '添加新闻', '', 'example/index/add', '', '_self', '0', '0', '0', '1', '1', '1581667458');
INSERT INTO `hisi_system_menu` VALUES ('190', '0', '188', 'example', '修改新闻', '', 'example/index/edit', '', '_self', '0', '0', '0', '1', '1', '1581667458');
INSERT INTO `hisi_system_menu` VALUES ('191', '0', '188', 'example', '删除新闻', '', 'example/index/del', '', '_self', '0', '0', '0', '1', '1', '1581667458');
INSERT INTO `hisi_system_menu` VALUES ('192', '0', '188', 'example', '状态设置', '', 'example/index/status', '', '_self', '0', '0', '0', '1', '1', '1581667458');
INSERT INTO `hisi_system_menu` VALUES ('193', '0', '10', 'example', '示例模块配置', 'aicon ai-shezhi', 'system/system/index', 'group=example', '_self', '100', '0', '0', '1', '1', '1581667458');
INSERT INTO `hisi_system_menu` VALUES ('194', '0', '196', 'system', '计量单位', 'aicon ai-icon-test', 'product/unit/index', '', '_self', '0', '0', '0', '1', '1', '1581669782');
INSERT INTO `hisi_system_menu` VALUES ('195', '0', '0', 'product', '产品管理', 'aicon ai-shezhi', 'product', '', '_self', '6', '0', '0', '1', '1', '1581678223');
INSERT INTO `hisi_system_menu` VALUES ('196', '0', '195', 'product', '产品管理', 'aicon ai-gongneng', 'product', '', '_self', '0', '0', '0', '1', '1', '1581678273');
INSERT INTO `hisi_system_menu` VALUES ('197', '0', '196', 'product', '产品列表', 'aicon ai-caidan', 'product/index/index', '', '_self', '0', '0', '0', '1', '1', '1581678334');
INSERT INTO `hisi_system_menu` VALUES ('198', '0', '196', 'product', '产品分类', 'aicon ai-caidan', 'product/category/index', '', '_self', '0', '0', '0', '1', '1', '1581678548');
INSERT INTO `hisi_system_menu` VALUES ('199', '0', '196', 'product', '产品品牌', 'aicon ai-caidan', 'product/brand/index', '', '_self', '0', '0', '0', '1', '1', '1581678603');
INSERT INTO `hisi_system_menu` VALUES ('200', '0', '254', 'product', '供应商', 'aicon ai-caidan', 'product/supplier/index', '', '_self', '0', '0', '0', '1', '1', '1581678649');
INSERT INTO `hisi_system_menu` VALUES ('201', '0', '195', 'product', '项目管理', 'aicon ai-mokuaiguanli1', 'project', '', '_self', '0', '0', '0', '1', '1', '1581739279');
INSERT INTO `hisi_system_menu` VALUES ('202', '0', '201', 'product', '项目分类', 'aicon ai-caidan', 'product/cate/index', '', '_self', '0', '0', '0', '1', '0', '1581739414');
INSERT INTO `hisi_system_menu` VALUES ('203', '0', '201', 'product', '项目列表', 'aicon ai-caidan', 'product/project/index', '', '_self', '0', '0', '0', '1', '1', '1581739444');
INSERT INTO `hisi_system_menu` VALUES ('204', '0', '179', 'shop', '房间管理', 'aicon ai-caidan', 'shop/room/index', '', '_self', '0', '0', '0', '1', '1', '1581750083');
INSERT INTO `hisi_system_menu` VALUES ('205', '0', '0', 'warehouse', '仓库', 'aicon ai-shezhi', 'warehouse', '', '_self', '7', '0', '0', '1', '1', '1581754707');
INSERT INTO `hisi_system_menu` VALUES ('206', '0', '205', 'warehouse', '仓库设置', 'aicon ai-xitongrizhi-tiaoshi', 'warehousr', '', '_self', '0', '0', '0', '1', '1', '1581754823');
INSERT INTO `hisi_system_menu` VALUES ('207', '0', '206', 'warehouse', '仓库列表', 'aicon ai-caidan', 'warehouse/index/index', '', '_self', '0', '0', '0', '1', '1', '1581754920');
INSERT INTO `hisi_system_menu` VALUES ('208', '0', '177', 'shouyin', '预约管理', 'aicon ai-mokuaiguanli1', 'shouyin', '', '_self', '0', '0', '0', '1', '1', '1581763377');
INSERT INTO `hisi_system_menu` VALUES ('209', '0', '208', 'shouyin', '预约单', 'aicon ai-caidan', 'shouyin/subscribe/index', 'state=1', '_self', '0', '0', '0', '1', '1', '1581763462');
INSERT INTO `hisi_system_menu` VALUES ('210', '0', '208', 'shouyin', '操作单', 'aicon ai-caidan', 'shouyin/subscribe/index', 'state=0', '_self', '0', '0', '0', '1', '1', '1581763515');
INSERT INTO `hisi_system_menu` VALUES ('211', '0', '0', 'finance', '财务管理', 'aicon ai-shezhi', 'finance', '', '_self', '8', '0', '0', '1', '1', '1582047126');
INSERT INTO `hisi_system_menu` VALUES ('212', '0', '211', 'finance', '账户管理', 'aicon ai-mokuaiguanli1', 'finance', '', '_self', '0', '0', '0', '1', '1', '1582047211');
INSERT INTO `hisi_system_menu` VALUES ('213', '0', '212', 'finance', '账户列表', 'aicon ai-caidan', 'finance/account/index', '', '_self', '0', '0', '0', '1', '1', '1582047272');
INSERT INTO `hisi_system_menu` VALUES ('214', '0', '177', 'shouyin', '充值', 'aicon ai-mokuaiguanli1', 'recharge', '', '_self', '0', '0', '0', '1', '1', '1582101780');
INSERT INTO `hisi_system_menu` VALUES ('215', '0', '214', 'shouyin', '会员卡充值', 'aicon ai-caidan', 'shouyin/recharge/index', '', '_self', '0', '0', '0', '1', '1', '1582101864');
INSERT INTO `hisi_system_menu` VALUES ('216', '0', '214', 'shouyin', '疗程/产品设置', 'aicon ai-caidan', 'shouyin/course/index', '', '_self', '0', '0', '0', '1', '1', '1582102083');
INSERT INTO `hisi_system_menu` VALUES ('217', '0', '214', 'shouyin', '疗程/产品充值', 'aicon ai-caidan', 'shouyin/treatment/index', '', '_self', '0', '0', '0', '1', '1', '1582102640');
INSERT INTO `hisi_system_menu` VALUES ('218', '0', '209', 'shouyin', '添加', '', 'shouyin/subscribe/add', '', '_self', '0', '0', '0', '0', '1', '1582350005');
INSERT INTO `hisi_system_menu` VALUES ('219', '0', '209', 'shouyin', '开单', '', 'shouyin/subscribe/kaidan', '', '_self', '0', '0', '0', '0', '1', '1582352207');
INSERT INTO `hisi_system_menu` VALUES ('220', '0', '209', 'shouyin', '修改', '', 'shouyin/subscribe/edit', '', '_self', '0', '0', '0', '0', '1', '1582352286');
INSERT INTO `hisi_system_menu` VALUES ('221', '0', '209', 'shouyin', '删除', '', 'shouyin/subscribe/del', '', '_self', '0', '0', '0', '1', '1', '1582352388');
INSERT INTO `hisi_system_menu` VALUES ('222', '0', '210', 'shouyin', '顾问开单', '', 'shouyin/subscribe/gwkd', '', '_self', '0', '0', '0', '0', '1', '1582353004');
INSERT INTO `hisi_system_menu` VALUES ('223', '0', '210', 'shouyin', '库管开单', '', 'shouyin/subscribe/kgkd', '', '_self', '0', '0', '0', '0', '1', '1582353068');
INSERT INTO `hisi_system_menu` VALUES ('224', '0', '210', 'shouyin', '收银结算', '', 'shouyin/subscribe/sykd', '', '_self', '0', '0', '0', '0', '1', '1582353119');
INSERT INTO `hisi_system_menu` VALUES ('225', '0', '210', 'shouyin', '财务审核', '', 'shouyin/subscribe/cwsh', '', '_self', '0', '0', '0', '0', '1', '1582353159');
INSERT INTO `hisi_system_menu` VALUES ('226', '0', '210', 'shouyin', '修改', '', 'shouyin/subscribe/edit', '', '_self', '0', '0', '0', '0', '1', '1582353542');
INSERT INTO `hisi_system_menu` VALUES ('227', '0', '215', 'shouyin', '充值', '', 'shouyin/recharge/add', '', '_self', '0', '0', '0', '0', '1', '1582353657');
INSERT INTO `hisi_system_menu` VALUES ('228', '0', '215', 'shouyin', '余额充值列表', '', 'shouyin/recharge/index', '', '_self', '0', '0', '0', '0', '1', '1582353747');
INSERT INTO `hisi_system_menu` VALUES ('229', '0', '208', 'shouyin', '产品单', 'aicon ai-caidan', 'shouyin/product/index', '', '_self', '0', '0', '0', '1', '1', '1582354198');
INSERT INTO `hisi_system_menu` VALUES ('230', '0', '170', 'user', '余额详情', '', 'user/index/getbalancelist', '', '_self', '0', '0', '0', '0', '1', '1582433272');
INSERT INTO `hisi_system_menu` VALUES ('231', '0', '170', 'user', '会员卡详情', '', 'user/index/getcardlist', '', '_self', '0', '0', '0', '0', '1', '1582434498');
INSERT INTO `hisi_system_menu` VALUES ('232', '0', '170', 'user', '产品购买记录', '', 'user/index/getproductlist', '', '_self', '0', '0', '0', '0', '1', '1582434554');
INSERT INTO `hisi_system_menu` VALUES ('233', '0', '170', 'user', '项目消费', '', 'user/index/getprojectlist', '', '_self', '0', '0', '0', '0', '1', '1582434574');
INSERT INTO `hisi_system_menu` VALUES ('234', '0', '208', 'shouyin', '寄存单', 'aicon ai-caidan', 'shouyin/deposit/index', '', '_self', '0', '0', '0', '1', '1', '1582567963');
INSERT INTO `hisi_system_menu` VALUES ('235', '0', '212', 'finance', '报销分类', 'aicon ai-caidan', 'finance/classofreim/index', '', '_self', '0', '0', '0', '1', '1', '1582615059');
INSERT INTO `hisi_system_menu` VALUES ('236', '0', '208', 'shouyin', '报销单', 'aicon ai-caidan', 'shouyin/reim/index', '', '_self', '0', '0', '0', '1', '1', '1582615123');
INSERT INTO `hisi_system_menu` VALUES ('237', '0', '206', 'warehouse', '仓库明细', 'aicon ai-caidan', 'warehouse/stock/index', '', '_self', '0', '0', '0', '1', '1', '1582632876');
INSERT INTO `hisi_system_menu` VALUES ('238', '0', '206', 'warehouse', '实时库存', 'aicon ai-caidan', 'warehouse/stock/real', '', '_self', '0', '0', '0', '1', '1', '1582696514');
INSERT INTO `hisi_system_menu` VALUES ('239', '0', '205', 'warehouse', '入库', 'aicon ai-shujukuguanli', 'warehouse', '', '_self', '0', '0', '0', '1', '1', '1582719799');
INSERT INTO `hisi_system_menu` VALUES ('240', '0', '239', 'warehouse', '采购入库', 'aicon ai-caidan', 'warehouse/purchase/index', '', '_self', '0', '0', '0', '1', '1', '1582719867');
INSERT INTO `hisi_system_menu` VALUES ('241', '0', '205', 'warehouse', '出库', 'aicon ai-shujukuguanli', 'chuku', '', '_self', '0', '0', '0', '1', '1', '1582721734');
INSERT INTO `hisi_system_menu` VALUES ('242', '0', '241', 'warehouse', '调拨单', 'aicon ai-caidan', 'warehouse/allocation/index', '', '_self', '0', '0', '0', '1', '1', '1582724749');
INSERT INTO `hisi_system_menu` VALUES ('243', '0', '254', 'finance', '采购充值', 'aicon ai-caidan', 'finance/pay/supplier', '', '_self', '0', '0', '0', '1', '1', '1582900884');
INSERT INTO `hisi_system_menu` VALUES ('244', '0', '247', 'warehouse', '配料库明细', 'aicon ai-caidan', 'warehouse/stock/decompose', '', '_self', '0', '0', '0', '1', '1', '1582978875');
INSERT INTO `hisi_system_menu` VALUES ('245', '0', '246', 'warehouse', '商品库明细', 'aicon ai-caidan', 'warehouse/stock/always', '', '_self', '0', '0', '0', '1', '1', '1582979742');
INSERT INTO `hisi_system_menu` VALUES ('246', '0', '205', 'warehouse', '商品库', 'aicon ai-gongneng', 'always', '', '_self', '0', '0', '0', '1', '1', '1582979832');
INSERT INTO `hisi_system_menu` VALUES ('247', '0', '205', 'warehouse', '配料库', 'aicon ai-mokuaiguanli1', 'decompose', '', '_self', '0', '0', '0', '1', '1', '1582979866');
INSERT INTO `hisi_system_menu` VALUES ('248', '0', '239', 'warehouse', '其他入库', 'aicon ai-caidan', 'warehouse/arrival/index', '', '_self', '0', '0', '0', '1', '1', '1582981990');
INSERT INTO `hisi_system_menu` VALUES ('249', '0', '241', 'warehouse', '直接出库', 'aicon ai-caidan', 'warehouse/direct/index', '', '_self', '0', '0', '0', '1', '1', '1582982550');
INSERT INTO `hisi_system_menu` VALUES ('250', '0', '206', 'warehouse', '出库类型', 'aicon ai-caidan', 'warehouse/directtype/index', '', '_self', '0', '0', '0', '1', '1', '1582983627');
INSERT INTO `hisi_system_menu` VALUES ('251', '0', '247', 'warehouse', '实时库存', 'aicon ai-caidan', 'warehouse/stock/realInventory', '', '_self', '0', '0', '0', '1', '1', '1582985823');
INSERT INTO `hisi_system_menu` VALUES ('252', '0', '246', 'warehouse', '实时库存', 'aicon ai-caidan', 'warehouse/stock/realzong', '', '_self', '0', '0', '0', '1', '1', '1582986597');
INSERT INTO `hisi_system_menu` VALUES ('253', '0', '254', 'finance', '供应商账单', 'aicon ai-caidan', 'finance/supplier/bill', '', '_self', '0', '0', '0', '1', '1', '1583042656');
INSERT INTO `hisi_system_menu` VALUES ('254', '0', '211', 'finance', '供应商', 'aicon ai-gongneng', 'Supplier', '', '_self', '0', '0', '0', '1', '1', '1583046946');
INSERT INTO `hisi_system_menu` VALUES ('255', '0', '212', 'finance', '账户明细', 'aicon ai-caidan', 'finance/systemBalance/index', '', '_self', '0', '0', '0', '1', '1', '1583047537');
INSERT INTO `hisi_system_menu` VALUES ('256', '0', '212', 'finance', '银行转账', 'aicon ai-caidan', 'finance/bank/index', '', '_self', '0', '0', '0', '1', '1', '1583065481');
INSERT INTO `hisi_system_menu` VALUES ('257', '0', '211', 'finance', '绩效', 'aicon ai-caidan', 'finance', '', '_self', '0', '0', '0', '1', '1', '1583133535');
INSERT INTO `hisi_system_menu` VALUES ('258', '0', '257', 'finance', '绩效明细', 'aicon ai-caidan', 'finance/Achievements/ledger', '', '_self', '0', '0', '0', '1', '1', '1583133889');
INSERT INTO `hisi_system_menu` VALUES ('259', '0', '177', 'shouyin', '售后', 'aicon ai-gongneng', 'Aftermarket', '', '_self', '0', '0', '0', '1', '1', '1583425940');
INSERT INTO `hisi_system_menu` VALUES ('260', '0', '259', 'shouyin', '退疗程卡', 'aicon ai-caidan', 'shouyin/Aftermarket/refund', '', '_self', '0', '0', '0', '1', '1', '1583426070');
INSERT INTO `hisi_system_menu` VALUES ('261', '0', '259', 'shouyin', '退会员卡', 'aicon ai-caidan', 'shouyin/Aftermarket/card', '', '_self', '0', '0', '0', '1', '1', '1583426151');
INSERT INTO `hisi_system_menu` VALUES ('262', '0', '259', 'shouyin', '退产品', 'aicon ai-caidan', 'shouyin/Aftermarket/product', '', '_self', '0', '0', '0', '1', '1', '1583426181');
INSERT INTO `hisi_system_menu` VALUES ('263', '1', '4', 'warehouse', '实时库存', 'aicon ai-caidan', 'warehouse/stock/realzong', '', '_self', '0', '0', '0', '1', '1', '1583997740');
INSERT INTO `hisi_system_menu` VALUES ('264', '1', '4', 'user', '会员列表', '', 'user/index/index', '', '_self', '2', '0', '0', '1', '1', '1584063000');
INSERT INTO `hisi_system_menu` VALUES ('265', '1', '4', 'shouyin', '产品单', 'aicon ai-caidan', 'shouyin/product/index', '', '_self', '0', '0', '0', '1', '1', '1584065929');
INSERT INTO `hisi_system_menu` VALUES ('266', '1', '4', 'warehouse', '采购入库', 'aicon ai-caidan', 'warehouse/purchase/index', '', '_self', '0', '0', '0', '1', '1', '1584067032');
INSERT INTO `hisi_system_menu` VALUES ('267', '0', '164', 'user', '会员卡记录', 'aicon ai-caidan', 'user/Records/balance', '', '_self', '0', '0', '0', '1', '1', '1584461886');
INSERT INTO `hisi_system_menu` VALUES ('268', '0', '164', 'user', '疗程卡记录', 'aicon ai-caidan', 'user/Records/card', '', '_self', '0', '0', '0', '1', '1', '1584462011');
INSERT INTO `hisi_system_menu` VALUES ('269', '0', '164', 'user', '产品记录', 'aicon ai-caidan', 'user/Records/product', '', '_self', '0', '0', '0', '1', '1', '1584462076');
INSERT INTO `hisi_system_menu` VALUES ('270', '0', '164', 'user', '操作单记录', 'aicon ai-caidan', 'user/Records/project', '', '_self', '0', '0', '0', '1', '1', '1584462141');
INSERT INTO `hisi_system_menu` VALUES ('271', '1', '4', 'warehouse', '总库明细', 'aicon ai-caidan', 'warehouse/stock/always', '', '_self', '0', '0', '0', '1', '1', '1584667451');
INSERT INTO `hisi_system_menu` VALUES ('272', '1', '4', 'shouyin', '预约单', 'aicon ai-caidan', 'shouyin/subscribe/index', 'state=1', '_self', '0', '0', '0', '1', '1', '1585038568');
INSERT INTO `hisi_system_menu` VALUES ('273', '0', '212', 'finance', '其他收付款', 'aicon ai-caidan', 'finance/otherPay/index', '', '_self', '0', '0', '0', '1', '1', '1585121392');
INSERT INTO `hisi_system_menu` VALUES ('274', '0', '208', 'shouyin', '报销单审核', 'aicon ai-clear', 'shouyin/reim/edit', '', '_self', '0', '0', '0', '0', '1', '1585191611');
INSERT INTO `hisi_system_menu` VALUES ('275', '0', '212', 'finance', '报销单', 'aicon ai-caidan', 'shouyin/reim/index', '', '_self', '0', '0', '0', '1', '1', '1585192114');
INSERT INTO `hisi_system_menu` VALUES ('276', '0', '211', 'finance', '仓库报表', 'aicon ai-gongneng', 'stock', '', '_self', '0', '0', '0', '1', '0', '1585203922');
INSERT INTO `hisi_system_menu` VALUES ('277', '0', '276', 'finance', '总库明细', 'aicon ai-caidan', 'finance/stock/always', '', '_self', '0', '0', '0', '1', '0', '1585203993');
INSERT INTO `hisi_system_menu` VALUES ('278', '0', '276', 'finance', '配料库明细', 'aicon ai-caidan', 'finance/stock/decompose', '', '_self', '0', '0', '0', '1', '0', '1585204240');
INSERT INTO `hisi_system_menu` VALUES ('279', '0', '276', 'finance', '总库库存', 'aicon ai-caidan', 'finance/stock/realzong', '', '_self', '0', '0', '0', '1', '0', '1585204296');
INSERT INTO `hisi_system_menu` VALUES ('280', '0', '276', 'finance', '配料库库存', 'aicon ai-caidan', 'finance/stock/realinventory', '', '_self', '0', '0', '0', '1', '0', '1585204335');
INSERT INTO `hisi_system_menu` VALUES ('281', '0', '214', 'shouyin', '会员卡转账', 'aicon ai-caidan', 'shouyin/transfer/index', '', '_self', '0', '0', '0', '1', '0', '1585211840');
INSERT INTO `hisi_system_menu` VALUES ('282', '0', '0', 'report', '报表', 'aicon ai-shezhi', 'report', '', '_self', '9', '0', '0', '1', '1', '1585277427');
INSERT INTO `hisi_system_menu` VALUES ('283', '0', '282', 'report', '会员报表', 'aicon ai-gongneng', 'report', '', '_self', '0', '0', '0', '1', '1', '1585277548');
INSERT INTO `hisi_system_menu` VALUES ('284', '0', '282', 'report', '仓库报表', 'aicon ai-gongneng', 'warehouse', '', '_self', '0', '0', '0', '1', '1', '1585277733');
INSERT INTO `hisi_system_menu` VALUES ('285', '0', '282', 'report', '财务报表', 'aicon ai-gongneng', 'report', '', '_self', '0', '0', '0', '1', '1', '1585277766');
INSERT INTO `hisi_system_menu` VALUES ('286', '0', '283', 'report', '会员卡消费报表', 'aicon ai-caidan', 'user/records/balance', '', '_self', '0', '0', '0', '1', '1', '1585277858');
INSERT INTO `hisi_system_menu` VALUES ('287', '0', '283', 'report', '疗程卡消费报表', 'aicon ai-caidan', 'user/records/card', '', '_self', '0', '0', '0', '1', '1', '1585277900');
INSERT INTO `hisi_system_menu` VALUES ('288', '0', '283', 'report', '产品销售报表', 'aicon ai-caidan', 'user/records/product', '', '_self', '0', '0', '0', '1', '1', '1585277979');
INSERT INTO `hisi_system_menu` VALUES ('289', '0', '283', 'report', '项目消费报表', 'aicon ai-caidan', 'user/records/project', '', '_self', '0', '0', '0', '1', '1', '1585278038');
INSERT INTO `hisi_system_menu` VALUES ('290', '0', '284', 'report', '仓库明细', 'aicon ai-caidan', 'finance/stock/always', '', '_self', '0', '0', '0', '1', '1', '1585363056');
INSERT INTO `hisi_system_menu` VALUES ('291', '0', '284', 'report', '配料库明细', 'aicon ai-caidan', 'finance/stock/decompose', '', '_self', '0', '0', '0', '1', '0', '1585363084');
INSERT INTO `hisi_system_menu` VALUES ('292', '0', '284', 'report', '总库库存', 'aicon ai-caidan', 'finance/stock/realzong', '', '_self', '0', '0', '0', '1', '1', '1585363115');
INSERT INTO `hisi_system_menu` VALUES ('293', '0', '284', 'report', '配料库库存', 'aicon ai-caidan', 'finance/stock/realinventory', '', '_self', '0', '0', '0', '1', '1', '1585363156');
INSERT INTO `hisi_system_menu` VALUES ('294', '0', '285', 'report', '账户明细', 'aicon ai-caidan', 'finance/systemBalance/index', '', '_self', '0', '0', '0', '1', '1', '1585363239');
INSERT INTO `hisi_system_menu` VALUES ('295', '0', '285', 'report', '银行转账', 'aicon ai-caidan', 'finance/bank/index', '', '_self', '0', '0', '0', '1', '1', '1585363268');
INSERT INTO `hisi_system_menu` VALUES ('296', '0', '285', 'report', '其他收付款', 'aicon ai-caidan', 'finance/otherPay/index', '', '_self', '0', '0', '0', '1', '1', '1585363300');
INSERT INTO `hisi_system_menu` VALUES ('297', '0', '285', 'report', '报销单', 'aicon ai-caidan', 'shouyin/reim/index', '', '_self', '0', '0', '0', '1', '1', '1585363330');
INSERT INTO `hisi_system_menu` VALUES ('298', '0', '285', 'report', '供应商账单', 'aicon ai-caidan', 'finance/supplier/bill', '', '_self', '0', '0', '0', '1', '1', '1585363451');
INSERT INTO `hisi_system_menu` VALUES ('299', '1', '4', 'finance', '供应商账单', 'aicon ai-caidan', 'finance/supplier/bill', '', '_self', '0', '0', '0', '1', '1', '1585712135');
INSERT INTO `hisi_system_menu` VALUES ('300', '0', '211', 'finance', '成本', 'aicon ai-gongneng', 'finance', '', '_self', '0', '0', '0', '1', '1', '1588043753');
INSERT INTO `hisi_system_menu` VALUES ('301', '0', '300', 'finance', '项目', '', 'finance/chengben/project', '', '_self', '0', '0', '0', '1', '1', '1588043809');
INSERT INTO `hisi_system_menu` VALUES ('302', '0', '300', 'finance', '产品', '', 'finance/chengben/product', '', '_self', '0', '0', '0', '1', '1', '1588043842');
INSERT INTO `hisi_system_menu` VALUES ('303', '0', '212', 'finance', '其他收付款类型', 'aicon ai-caidan', 'finance/otherType/index', '', '_self', '0', '0', '0', '1', '1', '1588814566');
INSERT INTO `hisi_system_menu` VALUES ('304', '0', '210', 'shouyin', '打印', '', 'shouyin/subscribe/cwsh', 'xx=2', '_self', '0', '0', '0', '0', '1', '1589508010');
INSERT INTO `hisi_system_menu` VALUES ('305', '1', '4', 'shouyin', '操作单', 'aicon ai-caidan', 'shouyin/subscribe/index', 'state=0', '_self', '0', '0', '0', '1', '1', '1589790604');
INSERT INTO `hisi_system_menu` VALUES ('306', '0', '240', 'warehouse', '采购开单', '', 'warehouse/purchase/add', '', '_self', '0', '0', '0', '0', '1', '1589957272');
INSERT INTO `hisi_system_menu` VALUES ('307', '0', '240', 'warehouse', '采购审核', '', 'warehouse/purchase/edit', '', '_self', '0', '0', '0', '0', '1', '1589957387');
INSERT INTO `hisi_system_menu` VALUES ('308', '0', '248', 'warehouse', '添加入库', '', 'warehouse/arrival/add', '', '_self', '0', '0', '0', '0', '1', '1589958369');
INSERT INTO `hisi_system_menu` VALUES ('309', '0', '248', 'warehouse', '审核', '', 'warehouse/arrival/edit', '', '_self', '0', '0', '0', '0', '1', '1589958435');
INSERT INTO `hisi_system_menu` VALUES ('310', '0', '242', 'warehouse', '新增', '', 'warehouse/allocation/add', '', '_self', '0', '0', '0', '0', '1', '1589958536');
INSERT INTO `hisi_system_menu` VALUES ('311', '0', '242', 'warehouse', '审核', '', 'warehouse/allocation/check', '', '_self', '0', '0', '0', '1', '1', '1589958605');
INSERT INTO `hisi_system_menu` VALUES ('312', '0', '249', 'warehouse', '新增', '', 'warehouse/direct/add', '', '_self', '0', '0', '0', '0', '1', '1589958650');
INSERT INTO `hisi_system_menu` VALUES ('313', '0', '249', 'warehouse', '审核', '', 'warehouse/direct/edit', '', '_self', '0', '0', '0', '0', '1', '1589958702');
INSERT INTO `hisi_system_menu` VALUES ('314', '1', '4', 'product', '产品品牌', 'aicon ai-caidan', 'product/brand/index', '', '_self', '0', '0', '0', '1', '1', '1590130267');
INSERT INTO `hisi_system_menu` VALUES ('315', '1', '4', 'user', '会员卡详情', '', 'user/index/getcardlist', '', '_self', '0', '0', '0', '0', '1', '1590133407');
INSERT INTO `hisi_system_menu` VALUES ('316', '0', '164', 'user', '项目剩余数量', 'aicon ai-caidan', 'user/records/cardsy', '', '_self', '0', '0', '0', '1', '1', '1590371023');
INSERT INTO `hisi_system_menu` VALUES ('317', '0', '2', 'system', '期初数据', 'aicon ai-daoru', 'qichu', '', '_self', '0', '0', '0', '1', '1', '1590976148');
INSERT INTO `hisi_system_menu` VALUES ('318', '0', '317', 'system', '疗程卡', 'aicon ai-iconfontshengji', 'system/begin/user_card_view', '', '_self', '0', '0', '0', '1', '1', '1590977462');
INSERT INTO `hisi_system_menu` VALUES ('319', '0', '317', 'system', '银行余额', 'aicon ai-iconfontshengji', 'system/begin/bank_balance_view', '', '_self', '0', '0', '0', '1', '1', '1590977508');
INSERT INTO `hisi_system_menu` VALUES ('320', '0', '317', 'system', '供应商余额', 'aicon ai-iconfontshengji', 'system/begin/supplier_balance_view', '', '_self', '0', '0', '0', '1', '1', '1590977563');
INSERT INTO `hisi_system_menu` VALUES ('321', '0', '317', 'system', '库存', 'aicon ai-iconfontshengji', 'system/begin/stock_view', '', '_self', '0', '0', '0', '1', '1', '1590977612');
INSERT INTO `hisi_system_menu` VALUES ('322', '0', '317', 'system', '寄存', 'aicon ai-iconfontshengji', 'system/begin/deposit_view', '', '_self', '0', '0', '0', '1', '1', '1590977666');
INSERT INTO `hisi_system_menu` VALUES ('323', '1', '4', 'product', '产品列表', 'aicon ai-caidan', 'product/index/index', '', '_self', '0', '0', '0', '1', '1', '1591063977');
INSERT INTO `hisi_system_menu` VALUES ('324', '0', '229', 'shouyin', '新增', '', 'shouyin/product/add', '', '_self', '0', '0', '0', '0', '1', '1593653841');
INSERT INTO `hisi_system_menu` VALUES ('325', '0', '229', 'shouyin', '库管开单', '', 'shouyin/product/kgkd', '', '_self', '0', '0', '0', '0', '1', '1593654135');
INSERT INTO `hisi_system_menu` VALUES ('326', '0', '229', 'shouyin', '收银结算', '', 'shouyin/product/sykd', '', '_self', '0', '0', '0', '0', '1', '1593654151');
INSERT INTO `hisi_system_menu` VALUES ('327', '0', '229', 'shouyin', '财务审核', '', 'shouyin/product/cwsh', '', '_self', '0', '0', '0', '0', '1', '1593654166');
INSERT INTO `hisi_system_menu` VALUES ('328', '1', '4', 'finance', '产品', '', 'finance/chengben/product', '', '_self', '0', '0', '0', '1', '1', '1593828904');
INSERT INTO `hisi_system_menu` VALUES ('329', '1', '4', 'shouyin', '退疗程卡', 'aicon ai-caidan', 'shouyin/Aftermarket/refund', '', '_self', '0', '0', '0', '1', '1', '1595323553');
INSERT INTO `hisi_system_menu` VALUES ('330', '1', '4', 'finance', '项目', '', 'finance/chengben/project', '', '_self', '0', '0', '0', '1', '1', '1597989158');
INSERT INTO `hisi_system_menu` VALUES ('331', '1', '4', 'shouyin', '寄存单', 'aicon ai-caidan', 'shouyin/deposit/index', '', '_self', '0', '0', '0', '1', '1', '1602314509');
-- ----------------------------
-- Table structure for hisi_system_menu_lang
-- ----------------------------
DROP TABLE IF EXISTS `hisi_system_menu_lang`;
CREATE TABLE `hisi_system_menu_lang` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`menu_id` int(11) unsigned NOT NULL DEFAULT '0',
`title` varchar(120) NOT NULL DEFAULT '' COMMENT '标题',
`lang` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '语言包',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=271 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='[系统] 管理菜单语言包';
-- ----------------------------
-- Records of hisi_system_menu_lang
-- ----------------------------
INSERT INTO `hisi_system_menu_lang` VALUES ('131', '1', '首页', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('132', '2', '系统', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('133', '3', '插件', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('134', '4', '快捷菜单', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('135', '5', '插件列表', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('136', '6', '系统基础', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('137', '7', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('138', '8', '系统扩展', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('139', '9', '开发专用', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('140', '10', '系统设置', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('141', '11', '配置管理', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('142', '12', '系统菜单', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('143', '13', '管理员角色', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('144', '14', '系统管理员', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('145', '15', '系统日志', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('146', '16', '附件管理', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('147', '17', '本地模块', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('148', '18', '本地插件', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('149', '19', '插件钩子', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('150', '20', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('151', '21', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('152', '22', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('153', '23', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('154', '24', '后台首页', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('155', '25', '清空缓存', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('156', '26', '添加菜单', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('157', '27', '修改菜单', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('158', '28', '删除菜单', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('159', '29', '状态设置', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('160', '30', '排序设置', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('161', '31', '添加快捷菜单', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('162', '32', '导出菜单', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('163', '33', '添加角色', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('164', '34', '修改角色', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('165', '35', '删除角色', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('166', '36', '状态设置', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('167', '37', '添加管理员', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('168', '38', '修改管理员', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('169', '39', '删除管理员', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('170', '40', '状态设置', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('171', '41', '个人信息设置', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('172', '42', '安装插件', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('173', '43', '卸载插件', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('174', '44', '删除插件', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('175', '45', '状态设置', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('176', '46', '生成插件', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('177', '47', '运行插件', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('178', '48', '更新插件', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('179', '49', '插件配置', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('180', '50', '添加钩子', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('181', '51', '修改钩子', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('182', '52', '删除钩子', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('183', '53', '状态设置', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('184', '54', '插件排序', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('185', '55', '添加配置', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('186', '56', '修改配置', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('187', '57', '删除配置', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('188', '58', '状态设置', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('189', '59', '排序设置', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('190', '60', '基础配置', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('191', '61', '系统配置', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('192', '62', '上传配置', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('193', '63', '开发配置', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('194', '64', '生成模块', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('195', '65', '安装模块', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('196', '66', '卸载模块', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('197', '67', '状态设置', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('198', '68', '设置默认模块', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('199', '69', '删除模块', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('200', '70', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('201', '71', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('202', '72', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('203', '73', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('204', '74', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('205', '75', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('206', '76', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('207', '77', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('208', '78', '附件上传', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('209', '79', '删除附件', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('210', '80', '框架升级', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('211', '81', '获取升级列表', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('212', '82', '安装升级包', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('213', '83', '下载升级包', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('214', '84', '数据库管理', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('215', '85', '备份数据库', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('216', '86', '恢复数据库', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('217', '87', '优化数据库', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('218', '88', '删除备份', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('219', '89', '修复数据库', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('220', '90', '设置默认等级', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('221', '91', '数据库配置', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('222', '92', '模块打包', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('223', '93', '插件打包', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('224', '94', '主题管理', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('225', '95', '设置默认主题', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('226', '96', '删除主题', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('227', '97', '语言包管理', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('228', '98', '添加语言包', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('229', '99', '修改语言包', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('230', '100', '删除语言包', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('231', '101', '排序设置', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('232', '102', '状态设置', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('233', '103', '收藏夹图标上传', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('234', '104', '导入模块', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('235', '105', '后台首页', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('236', '106', '布局切换', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('237', '107', '删除日志', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('238', '108', '清空日志', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('239', '109', '编辑模块', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('240', '110', '模块图标上传', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('241', '111', '导入插件', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('242', '112', '钩子插件状态', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('243', '113', '设置主题', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('244', '114', '应用市场', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('245', '115', '安装应用', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('246', '116', '重置密码', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('247', '117', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('248', '118', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('249', '119', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('250', '120', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('251', '121', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('252', '122', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('253', '123', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('254', '124', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('255', '125', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('256', '126', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('257', '127', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('258', '128', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('259', '129', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('260', '130', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('261', '131', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('262', '132', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('263', '133', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('264', '134', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('265', '135', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('266', '136', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('267', '137', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('268', '138', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('269', '139', '预留占位', '1');
INSERT INTO `hisi_system_menu_lang` VALUES ('270', '140', '预留占位', '1');
-- ----------------------------
-- Table structure for hisi_system_module
-- ----------------------------
DROP TABLE IF EXISTS `hisi_system_module`;
CREATE TABLE `hisi_system_module` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`system` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '系统模块',
`name` varchar(50) NOT NULL COMMENT '模块名(英文)',
`identifier` varchar(100) NOT NULL COMMENT '模块标识(模块名(字母).开发者标识.module)',
`title` varchar(50) NOT NULL COMMENT '模块标题',
`intro` varchar(255) NOT NULL COMMENT '模块简介',
`author` varchar(100) NOT NULL COMMENT '作者',
`icon` varchar(80) NOT NULL DEFAULT 'aicon ai-mokuaiguanli' COMMENT '图标',
`version` varchar(20) NOT NULL COMMENT '版本号',
`url` varchar(255) NOT NULL COMMENT '链接',
`sort` int(5) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0未安装，1未启用，2已启用',
`default` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '默认模块(只能有一个)',
`config` text NOT NULL COMMENT '配置',
`app_id` varchar(30) NOT NULL DEFAULT '0' COMMENT '应用市场ID(0本地)',
`app_keys` varchar(200) DEFAULT '' COMMENT '应用秘钥',
`theme` varchar(50) NOT NULL DEFAULT 'default' COMMENT '主题模板',
`ctime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
`mtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `name` (`name`) USING BTREE,
UNIQUE KEY `identifier` (`identifier`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='[系统] 模块';
-- ----------------------------
-- Records of hisi_system_module
-- ----------------------------
INSERT INTO `hisi_system_module` VALUES ('1', '1', 'system', 'system.hisiphp.module', '系统管理模块', '系统核心模块，用于后台各项管理功能模块及功能拓展', 'HisiPHP官方出品', '', '1.0.0', 'http://www.hisiphp.com', '0', '2', '0', '', '0', '', 'default', '1489998096', '1489998096');
INSERT INTO `hisi_system_module` VALUES ('2', '1', 'index', 'index.hisiphp.module', '默认模块', '推荐使用扩展模块作为默认首页。', 'HisiPHP官方出品', '', '1.0.0', 'http://www.hisiphp.com', '0', '2', '0', '', '0', '', 'default', '1489998096', '1489998096');
INSERT INTO `hisi_system_module` VALUES ('3', '1', 'install', 'install.hisiphp.module', '系统安装模块', '系统安装模块，勿动。', 'HisiPHP官方出品', '', '1.0.0', 'http://www.hisiphp.com', '0', '2', '0', '', '0', '', 'default', '1489998096', '1489998096');
INSERT INTO `hisi_system_module` VALUES ('4', '0', 'developer', 'developer.1000016.module.2000015', '开发助手', '为您提供了模块、插件可视化设计，还支持一键打包应用', 'HisiPHP', '/static/developer/developer.png', '1.0.1', 'http://www.hisiphp.com', '0', '2', '0', '', '0', 'c2520af02c36f4275e9d432be8f73199', 'default', '1581406908', '1581406908');
INSERT INTO `hisi_system_module` VALUES ('5', '0', 'user', 'user.1000020.module.2000019', '会员', '', 'hisiphp', '/static/user/user.png', '1.0.2', 'http://www.hisiphp.com', '0', '2', '0', '', '0', 'bfd805b089822383b14ed4b4849ae5d8', 'default', '1581406963', '1581406963');
INSERT INTO `hisi_system_module` VALUES ('6', '0', 'shouyin', 'shouyin.qinty_net.module', '收银管理', '收银板块', 'qinty.net', '/static/shouyin/shouyin.png', '1.0.0', 'www.qinty.net', '0', '2', '0', '', '0', '', 'default', '1581665287', '1581665287');
INSERT INTO `hisi_system_module` VALUES ('7', '0', 'shop', 'shou,qinty_net.module', '店铺管理', '店铺管理', 'qinty.net', '/static/shop/shop.png', '1.0.0', 'www.qinty.net', '0', '2', '0', '', '0', '', 'default', '1581665362', '1581665362');
INSERT INTO `hisi_system_module` VALUES ('8', '0', 'example', 'example.1000017.module.2000016', '示例模块', '这是一个开发示例模块，里面集成了后台开发和前台开发示例，仅供参考学习，您可以随时删除此模块。', 'hisiphp', '/static/example/example.png', '1.0.1', 'http://www.hisiphp.com', '0', '1', '0', '[{\"sort\":100,\"title\":\"AppID\",\"name\":\"app_id\",\"type\":\"input\",\"options\":\"\",\"value\":\"\",\"tips\":\"\\u793a\\u4f8b\\u914d\\u7f6e\"},{\"sort\":101,\"title\":\"AppSecret\",\"name\":\"secret\",\"type\":\"input\",\"options\":\"\",\"value\":\"\",\"tips\":\"\\u793a\\u4f8b\\u914d\\u7f6e\"}]', '0', 'e227021c7bae4d2ea806ce89a89b383e', 'default', '1581667458', '1581667458');
INSERT INTO `hisi_system_module` VALUES ('9', '0', 'product', 'product.qinty_net.module', '产品管理', '', 'qinty.net', '/static/product/product.png', '1.0.0', 'www.qinty.net', '0', '2', '0', '', '0', '', 'default', '1581678223', '1581678223');
INSERT INTO `hisi_system_module` VALUES ('10', '0', 'warehouse', 'warehouse.qinty_net.module', '仓库', '仓库管理，进销存', 'qinty.net', '/static/warehouse/warehouse.png', '1.0.0', 'www.qinty.net', '0', '2', '0', '', '0', '', 'default', '1581754707', '1581754707');
INSERT INTO `hisi_system_module` VALUES ('11', '0', 'finance', 'finance.qinty_net.module', '财务管理', '', 'qinty.net', '/static/finance/finance.png', '1.0.0', 'www.qinty.net', '0', '2', '0', '', '0', '', 'default', '1582047126', '1582047126');
INSERT INTO `hisi_system_module` VALUES ('12', '0', 'report', 'report.qinty_net.module', '报表', '', 'qinty.net', '/static/report/report.png', '1.0.0', 'www.qinty.net', '0', '2', '0', '', '0', '', 'default', '1585277427', '1585277427');
-- ----------------------------
-- Table structure for hisi_system_plugins
-- ----------------------------
DROP TABLE IF EXISTS `hisi_system_plugins`;
CREATE TABLE `hisi_system_plugins` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`system` tinyint(1) unsigned NOT NULL DEFAULT '0',
`name` varchar(32) NOT NULL COMMENT '插件名称(英文)',
`title` varchar(32) NOT NULL COMMENT '插件标题',
`icon` varchar(64) NOT NULL COMMENT '图标',
`intro` text NOT NULL COMMENT '插件简介',
`author` varchar(32) NOT NULL COMMENT '作者',
`url` varchar(255) NOT NULL COMMENT '作者主页',
`version` varchar(16) NOT NULL DEFAULT '' COMMENT '版本号',
`identifier` varchar(64) NOT NULL DEFAULT '' COMMENT '插件唯一标识符',
`config` text NOT NULL COMMENT '插件配置',
`app_id` varchar(30) NOT NULL DEFAULT '0' COMMENT '来源(0本地)',
`app_keys` varchar(200) DEFAULT '' COMMENT '应用秘钥',
`ctime` int(10) unsigned NOT NULL DEFAULT '0',
`mtime` int(10) unsigned NOT NULL DEFAULT '0',
`sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='[系统] 插件表';
-- ----------------------------
-- Records of hisi_system_plugins
-- ----------------------------
INSERT INTO `hisi_system_plugins` VALUES ('1', '1', 'hisiphp', '系统基础信息', '/static/plugins/hisiphp/hisiphp.png', '后台首页展示系统基础信息和开发团队信息', 'HisiPHP', 'http://www.hisiphp.com', '1.0.0', 'hisiphp.hisiphp.plugins', '', '0', '', '1509379331', '1509379331', '0', '2');
-- ----------------------------
-- Table structure for hisi_system_role
-- ----------------------------
DROP TABLE IF EXISTS `hisi_system_role`;
CREATE TABLE `hisi_system_role` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL COMMENT '角色名称',
`intro` varchar(200) NOT NULL COMMENT '角色简介',
`auth` text NOT NULL COMMENT '角色权限',
`ctime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
`mtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
`status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='[系统] 管理角色';
-- ----------------------------
-- Records of hisi_system_role
-- ----------------------------
INSERT INTO `hisi_system_role` VALUES ('1', '超级管理员', '拥有系统最高权限', '0', '1489411760', '0', '1');
INSERT INTO `hisi_system_role` VALUES ('2', '系统管理员', '拥有系统管理员权限', '[\"1\",\"4\",\"25\",\"24\",\"2\",\"6\",\"10\",\"60\",\"61\",\"62\",\"63\",\"91\",\"11\",\"55\",\"56\",\"57\",\"58\",\"59\",\"12\",\"26\",\"27\",\"28\",\"29\",\"30\",\"31\",\"32\",\"13\",\"33\",\"34\",\"35\",\"36\",\"14\",\"37\",\"38\",\"39\",\"40\",\"41\",\"16\",\"78\",\"79\",\"84\",\"85\",\"86\",\"87\",\"88\",\"89\",\"7\",\"20\",\"75\",\"76\",\"77\",\"21\",\"90\",\"70\",\"71\",\"72\",\"73\",\"74\",\"8\",\"17\",\"65\",\"66\",\"67\",\"68\",\"94\",\"95\",\"18\",\"42\",\"43\",\"45\",\"47\",\"48\",\"49\",\"19\",\"80\",\"81\",\"82\",\"83\",\"9\",\"22\",\"23\",\"3\",\"5\"]', '1489411760', '1507731116', '1');
INSERT INTO `hisi_system_role` VALUES ('4', '前台', '前台', '{\"0\":\"1\",\"1\":\"4\",\"2\":\"24\",\"3\":\"25\",\"4\":\"41\",\"5\":\"105\",\"6\":\"106\",\"7\":\"112\",\"8\":\"113\",\"80\":\"163\",\"81\":\"164\",\"82\":\"170\",\"83\":\"171\",\"84\":\"172\",\"85\":\"173\",\"86\":\"174\",\"87\":\"175\",\"88\":\"176\",\"89\":\"230\",\"90\":\"231\",\"91\":\"232\",\"92\":\"233\",\"93\":\"267\",\"94\":\"268\",\"95\":\"269\",\"96\":\"270\",\"97\":\"316\",\"98\":\"177\",\"99\":\"208\",\"100\":\"209\",\"101\":\"218\",\"102\":\"219\",\"103\":\"220\",\"104\":\"221\",\"105\":\"210\",\"108\":\"224\",\"111\":\"304\",\"112\":\"229\",\"113\":\"324\",\"114\":\"325\",\"115\":\"326\",\"117\":\"234\",\"118\":\"236\",\"120\":\"214\",\"121\":\"215\",\"122\":\"227\",\"123\":\"228\",\"125\":\"217\",\"126\":\"259\",\"127\":\"260\",\"128\":\"261\",\"129\":\"262\"}', '1581762171', '1597973448', '1');
INSERT INTO `hisi_system_role` VALUES ('5', '库管', '库管', '{\"0\":\"1\",\"1\":\"4\",\"2\":\"24\",\"3\":\"25\",\"4\":\"41\",\"5\":\"105\",\"6\":\"106\",\"8\":\"113\",\"96\":\"177\",\"97\":\"208\",\"103\":\"210\",\"105\":\"223\",\"110\":\"229\",\"112\":\"325\",\"140\":\"205\",\"146\":\"239\",\"147\":\"240\",\"148\":\"306\",\"150\":\"248\",\"151\":\"308\",\"153\":\"241\",\"154\":\"242\",\"155\":\"310\",\"157\":\"249\",\"158\":\"312\",\"160\":\"246\",\"161\":\"245\",\"162\":\"252\",\"163\":\"247\",\"164\":\"244\",\"165\":\"251\"}', '1581762204', '1593654198', '1');
INSERT INTO `hisi_system_role` VALUES ('6', '顾问', '顾问', '{\"0\":\"1\",\"1\":\"4\",\"2\":\"24\",\"3\":\"25\",\"4\":\"41\",\"5\":\"105\",\"6\":\"106\",\"7\":\"112\",\"8\":\"113\",\"9\":\"263\",\"10\":\"264\",\"11\":\"265\",\"13\":\"271\",\"14\":\"272\",\"16\":\"305\",\"18\":\"315\",\"21\":\"329\",\"22\":\"330\",\"81\":\"163\",\"82\":\"164\",\"83\":\"170\",\"84\":\"171\",\"85\":\"172\",\"86\":\"173\",\"87\":\"174\",\"88\":\"175\",\"89\":\"176\",\"90\":\"230\",\"91\":\"231\",\"92\":\"232\",\"93\":\"233\",\"94\":\"267\",\"95\":\"268\",\"96\":\"269\",\"97\":\"270\",\"98\":\"316\",\"99\":\"177\",\"100\":\"208\",\"101\":\"209\",\"102\":\"218\",\"103\":\"219\",\"104\":\"220\",\"105\":\"221\",\"106\":\"210\",\"107\":\"222\",\"109\":\"224\",\"111\":\"226\",\"112\":\"304\",\"113\":\"229\",\"114\":\"324\",\"116\":\"326\",\"118\":\"234\",\"119\":\"236\",\"121\":\"214\",\"122\":\"215\",\"123\":\"227\",\"124\":\"228\",\"126\":\"217\",\"127\":\"259\",\"128\":\"260\",\"129\":\"261\",\"130\":\"262\",\"131\":\"178\",\"132\":\"179\",\"134\":\"204\",\"143\":\"205\",\"163\":\"246\",\"164\":\"245\",\"165\":\"252\",\"187\":\"282\",\"188\":\"283\",\"189\":\"286\",\"190\":\"287\",\"191\":\"288\",\"192\":\"289\"}', '1581762238', '1599267984', '1');
INSERT INTO `hisi_system_role` VALUES ('7', '美容师', '美容师', '{\"0\":\"1\",\"1\":\"4\",\"2\":\"24\",\"3\":\"25\",\"4\":\"41\",\"5\":\"105\",\"6\":\"106\",\"7\":\"112\",\"8\":\"113\",\"124\":\"163\",\"125\":\"164\",\"126\":\"170\",\"127\":\"171\",\"128\":\"172\",\"129\":\"173\",\"130\":\"174\",\"131\":\"175\",\"132\":\"176\"}', '1581765571', '1581765571', '1');
INSERT INTO `hisi_system_role` VALUES ('8', '财务', '财务', '{\"0\":\"1\",\"1\":\"4\",\"2\":\"24\",\"3\":\"25\",\"4\":\"41\",\"5\":\"105\",\"6\":\"106\",\"8\":\"113\",\"69\":\"163\",\"70\":\"164\",\"71\":\"170\",\"72\":\"171\",\"73\":\"172\",\"74\":\"173\",\"75\":\"174\",\"76\":\"175\",\"77\":\"176\",\"78\":\"230\",\"79\":\"231\",\"80\":\"232\",\"81\":\"233\",\"82\":\"267\",\"83\":\"268\",\"84\":\"269\",\"85\":\"270\",\"86\":\"177\",\"87\":\"208\",\"88\":\"209\",\"89\":\"218\",\"90\":\"219\",\"91\":\"220\",\"92\":\"221\",\"93\":\"210\",\"97\":\"225\",\"98\":\"226\",\"100\":\"229\",\"101\":\"234\",\"102\":\"236\",\"103\":\"274\",\"104\":\"214\",\"105\":\"215\",\"106\":\"227\",\"107\":\"228\",\"108\":\"216\",\"109\":\"217\",\"110\":\"259\",\"111\":\"260\",\"112\":\"261\",\"113\":\"262\",\"114\":\"178\",\"115\":\"179\",\"116\":\"180\",\"117\":\"204\",\"118\":\"195\",\"119\":\"196\",\"120\":\"194\",\"121\":\"197\",\"122\":\"198\",\"123\":\"199\",\"124\":\"201\",\"125\":\"203\",\"126\":\"205\",\"127\":\"206\",\"128\":\"207\",\"129\":\"250\",\"130\":\"239\",\"131\":\"240\",\"132\":\"306\",\"133\":\"307\",\"134\":\"248\",\"135\":\"308\",\"136\":\"309\",\"137\":\"241\",\"138\":\"242\",\"139\":\"310\",\"140\":\"311\",\"141\":\"249\",\"142\":\"312\",\"143\":\"313\",\"144\":\"246\",\"145\":\"245\",\"146\":\"252\",\"147\":\"247\",\"148\":\"244\",\"149\":\"251\",\"150\":\"211\",\"151\":\"212\",\"152\":\"213\",\"153\":\"235\",\"154\":\"255\",\"155\":\"256\",\"156\":\"273\",\"157\":\"275\",\"158\":\"303\",\"159\":\"254\",\"160\":\"200\",\"161\":\"243\",\"162\":\"253\",\"163\":\"257\",\"164\":\"258\",\"165\":\"300\",\"166\":\"301\",\"167\":\"302\",\"168\":\"282\",\"169\":\"283\",\"170\":\"286\",\"171\":\"287\",\"172\":\"288\",\"173\":\"289\",\"174\":\"284\",\"175\":\"290\",\"176\":\"291\",\"177\":\"292\",\"178\":\"293\",\"179\":\"285\",\"180\":\"294\",\"181\":\"295\",\"182\":\"296\",\"183\":\"297\",\"184\":\"298\"}', '1582301598', '1589958829', '1');
INSERT INTO `hisi_system_role` VALUES ('9', '店长', '店长', '{\"81\":\"163\",\"82\":\"164\",\"83\":\"170\",\"84\":\"171\",\"85\":\"172\",\"86\":\"173\",\"87\":\"174\",\"88\":\"175\",\"89\":\"176\",\"90\":\"230\",\"91\":\"231\",\"92\":\"232\",\"93\":\"233\",\"94\":\"267\",\"95\":\"268\",\"96\":\"269\",\"97\":\"270\",\"98\":\"316\",\"99\":\"177\",\"100\":\"208\",\"101\":\"209\",\"102\":\"218\",\"103\":\"219\",\"104\":\"220\",\"105\":\"221\",\"106\":\"210\",\"107\":\"222\",\"108\":\"223\",\"109\":\"224\",\"111\":\"226\",\"112\":\"304\",\"113\":\"229\",\"114\":\"324\",\"116\":\"326\",\"118\":\"234\",\"119\":\"236\",\"121\":\"214\",\"122\":\"215\",\"123\":\"227\",\"124\":\"228\",\"126\":\"217\",\"127\":\"259\",\"128\":\"260\",\"129\":\"261\",\"130\":\"262\",\"131\":\"178\",\"132\":\"179\",\"134\":\"204\",\"143\":\"205\",\"163\":\"246\",\"164\":\"245\",\"165\":\"252\",\"166\":\"247\",\"167\":\"244\",\"168\":\"251\",\"187\":\"282\",\"188\":\"283\",\"189\":\"286\",\"190\":\"287\",\"191\":\"288\",\"192\":\"289\"}', '1592879643', '1599267454', '1');
INSERT INTO `hisi_system_role` VALUES ('10', '大区经理', '大区经理', '[\"1\",\"4\",\"24\",\"25\",\"41\",\"105\",\"106\",\"112\",\"113\",\"263\",\"264\",\"265\",\"266\",\"271\",\"272\",\"299\",\"305\",\"314\",\"315\",\"323\",\"328\",\"329\",\"330\",\"2\",\"6\",\"10\",\"60\",\"61\",\"62\",\"63\",\"91\",\"193\",\"11\",\"55\",\"56\",\"57\",\"58\",\"59\",\"12\",\"26\",\"27\",\"28\",\"29\",\"30\",\"31\",\"32\",\"13\",\"33\",\"34\",\"35\",\"36\",\"14\",\"37\",\"38\",\"39\",\"40\",\"15\",\"107\",\"108\",\"16\",\"78\",\"79\",\"103\",\"84\",\"85\",\"86\",\"87\",\"88\",\"89\",\"97\",\"98\",\"99\",\"100\",\"101\",\"102\",\"317\",\"318\",\"319\",\"320\",\"321\",\"322\",\"163\",\"164\",\"170\",\"171\",\"172\",\"173\",\"174\",\"175\",\"176\",\"230\",\"231\",\"232\",\"233\",\"267\",\"268\",\"269\",\"270\",\"316\",\"177\",\"208\",\"209\",\"218\",\"219\",\"220\",\"221\",\"210\",\"222\",\"223\",\"224\",\"225\",\"226\",\"304\",\"229\",\"324\",\"325\",\"326\",\"327\",\"234\",\"236\",\"274\",\"214\",\"215\",\"227\",\"228\",\"216\",\"217\",\"259\",\"260\",\"261\",\"262\",\"178\",\"179\",\"180\",\"204\",\"195\",\"196\",\"194\",\"197\",\"198\",\"199\",\"201\",\"203\",\"205\",\"206\",\"207\",\"237\",\"238\",\"250\",\"239\",\"240\",\"306\",\"307\",\"248\",\"308\",\"309\",\"241\",\"242\",\"310\",\"311\",\"249\",\"312\",\"313\",\"246\",\"245\",\"252\",\"247\",\"244\",\"251\",\"211\",\"212\",\"213\",\"235\",\"255\",\"256\",\"273\",\"275\",\"303\",\"254\",\"200\",\"243\",\"253\",\"257\",\"258\",\"300\",\"301\",\"302\",\"282\",\"283\",\"286\",\"287\",\"288\",\"289\",\"284\",\"290\",\"292\",\"293\",\"285\",\"294\",\"295\",\"296\",\"297\",\"298\"]', '1599525406', '1600917374', '1');
INSERT INTO `hisi_system_role` VALUES ('11', '总经理', '', '[\"1\",\"4\",\"24\",\"25\",\"41\",\"105\",\"106\",\"112\",\"113\",\"263\",\"264\",\"265\",\"266\",\"271\",\"272\",\"299\",\"305\",\"314\",\"315\",\"323\",\"328\",\"329\",\"330\",\"2\",\"6\",\"10\",\"60\",\"61\",\"62\",\"63\",\"91\",\"193\",\"11\",\"55\",\"56\",\"57\",\"58\",\"59\",\"12\",\"26\",\"27\",\"28\",\"29\",\"30\",\"31\",\"32\",\"13\",\"33\",\"34\",\"35\",\"36\",\"14\",\"37\",\"38\",\"39\",\"40\",\"15\",\"107\",\"108\",\"16\",\"78\",\"79\",\"103\",\"84\",\"85\",\"86\",\"87\",\"88\",\"89\",\"97\",\"98\",\"99\",\"100\",\"101\",\"102\",\"317\",\"318\",\"319\",\"320\",\"321\",\"322\",\"163\",\"164\",\"170\",\"171\",\"172\",\"173\",\"174\",\"175\",\"176\",\"230\",\"231\",\"232\",\"233\",\"267\",\"268\",\"269\",\"270\",\"316\",\"177\",\"208\",\"209\",\"218\",\"219\",\"220\",\"221\",\"210\",\"222\",\"223\",\"224\",\"225\",\"226\",\"304\",\"229\",\"324\",\"325\",\"326\",\"327\",\"234\",\"236\",\"274\",\"214\",\"215\",\"227\",\"228\",\"216\",\"217\",\"259\",\"260\",\"261\",\"262\",\"178\",\"179\",\"180\",\"204\",\"195\",\"196\",\"194\",\"197\",\"198\",\"199\",\"201\",\"203\",\"205\",\"206\",\"207\",\"237\",\"238\",\"250\",\"239\",\"240\",\"306\",\"307\",\"248\",\"308\",\"309\",\"241\",\"242\",\"310\",\"311\",\"249\",\"312\",\"313\",\"246\",\"245\",\"252\",\"247\",\"244\",\"251\",\"211\",\"212\",\"213\",\"235\",\"255\",\"256\",\"273\",\"275\",\"303\",\"254\",\"200\",\"243\",\"253\",\"257\",\"258\",\"300\",\"301\",\"302\",\"282\",\"283\",\"286\",\"287\",\"288\",\"289\",\"284\",\"290\",\"292\",\"293\",\"285\",\"294\",\"295\",\"296\",\"297\",\"298\"]', '1601002189', '1601002189', '1');
-- ----------------------------
-- Table structure for hisi_system_user
-- ----------------------------
DROP TABLE IF EXISTS `hisi_system_user`;
CREATE TABLE `hisi_system_user` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL COMMENT '用户名',
`password` varchar(64) NOT NULL,
`nick` varchar(50) NOT NULL COMMENT '昵称',
`mobile` varchar(11) NOT NULL,
`email` varchar(50) NOT NULL COMMENT '邮箱',
`auth` text NOT NULL COMMENT '权限',
`iframe` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0默认，1框架',
`theme` varchar(50) NOT NULL DEFAULT 'default' COMMENT '主题',
`status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态',
`last_login_ip` varchar(128) NOT NULL COMMENT '最后登陆IP',
`last_login_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后登陆时间',
`ctime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
`mtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
`shop_id` int(11) DEFAULT '0' COMMENT '门店',
`type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '职位:0=管理员,1=区域经理,2=店长,3=前台,4=库管,5=顾问,6=财务,7=美容师',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='[系统] 管理用户';
-- ----------------------------
-- Records of hisi_system_user
-- ----------------------------
INSERT INTO `hisi_system_user` VALUES ('1', 'admin', '$2y$10$XCwmdU4i4RgKkfYkxN3Zc.LFa6f9nEuncnCW9ha7K9//ikER3LJJ.', '超级管理员', '', '', '', '0', '1', '1', '113.124.208.194', '1603679315', '1581406806', '1599621228', '0', '0');
INSERT INTO `hisi_system_user` VALUES ('2', 'lcj123', '$2y$10$gXayuwPzbAXvkYRTwwjdv.Qno9rU6.sC/yw18rZkpRrhZJpB2.xgO', '刘翠洁', '13666666666', '1@qq.com', '', '0', 'default', '1', '101.24.122.131', '1589508495', '1581762701', '1591596846', '1', '7');
INSERT INTO `hisi_system_user` VALUES ('3', 'ln123', '$2y$10$WPbV9eVpG04dilUOwkSeYOcB/7L.tgAKFMwEwDilHNal0WPC3dDey', '李娜', '13511111111', '12@qq.com', '', '0', '1', '1', '27.217.11.171', '1599807559', '1581765435', '1591585085', '1', '5');
INSERT INTO `hisi_system_user` VALUES ('5', 'gxm123', '$2y$10$TwCn2waMA/S1YnRtpbqjme6fvDsGZuESRnwLATbrciDN/AV8N4xNC', '宫秀梅', '13333333333', '33@qq.com', '', '0', 'default', '1', '127.0.0.1', '0', '1581765618', '1591585117', '1', '7');
INSERT INTO `hisi_system_user` VALUES ('6', 'yp123', '$2y$10$TZKYxkoo7iMRRJCS647fWOH2MD3vl5j4VS0NJqoSGUrWAE3m/s926', '于盼', '13311112222', '44@qq.com', '', '0', 'default', '1', '127.0.0.1', '0', '1581765667', '1591585149', '7', '7');
INSERT INTO `hisi_system_user` VALUES ('7', 'xnn123', '$2y$10$PuNmXutD9l0Qm2dDD8RNou/OLo29o2UN4ZdAn4wpuXpWO8pEt8jom', '许牛牛', '13311221122', '13@qq.com', '', '0', 'default', '1', '127.0.0.1', '0', '1581765717', '1591595411', '8', '2');
INSERT INTO `hisi_system_user` VALUES ('8', 'th123', '$2y$10$LvyUcQGUxBjbfD22jjUdW.MGE3PEcndQ/YcBNr28yWRc1oqvA561S', '唐慧', '13522222233', '2211@qq.com', '', '0', 'default', '1', '27.213.44.72', '1598084782', '1581842716', '1591585285', '8', '5');
INSERT INTO `hisi_system_user` VALUES ('9', 'lmy123', '$2y$10$VecN5YJ9afDV0abvWCHaTOwpDVGtJgynV4HFpmY.FJk8/Csmpq9CK', '鲁明月', '13222221111', 'guwen@qq.com', '', '1', 'default', '1', '218.59.115.6', '1603508738', '1581842751', '1591585250', '8', '5');
INSERT INTO `hisi_system_user` VALUES ('10', 'ljj123', '$2y$10$EomOCag/BJi8yO.XzWb0f.bo79/tpdkkHzs/bMN.ajRb1fqDTwEp.', '刘静静', '13512343214', 'liusanpao@qq.com', '', '0', 'default', '1', '101.24.122.131', '1589333874', '1582301523', '1591596891', '1', '7');
INSERT INTO `hisi_system_user` VALUES ('11', 'sh123', '$2y$10$Adwp9VdB90fueKIAiQU2deV8y8d5/E1Vx1SJQgw1MBL50oJ/f74ju', '宋贺', '', '', '', '0', 'default', '1', '27.213.44.107', '0', '1584604379', '1591585372', '7', '7');
INSERT INTO `hisi_system_user` VALUES ('12', 'sxy123', '$2y$10$IXPneD8dvzQjETJjDlFcG.YZuhlpf3307OsSArsKTLqA3f4Q6I.ZS', '隋晓艳', '', '', '', '0', 'default', '1', '27.213.44.107', '0', '1584604818', '1591585409', '7', '7');
INSERT INTO `hisi_system_user` VALUES ('13', 'zcw123', '$2y$10$aZr0qq/LTJMcondg/HTxpedZr7DjVrllXoHyCl8kgUUzhMFiczuvu', '张春微', '', '', '', '0', 'default', '1', '27.213.44.72', '1596868886', '1584604915', '1591585435', '7', '7');
INSERT INTO `hisi_system_user` VALUES ('14', 'jy123', '$2y$10$wQBbXs5i4ifTZBBC9i2wd.POFk5OhCCvURR/.RL63WRU/O3aSC5R2', '姜妍', '', '', '', '0', 'default', '1', '119.180.92.111', '1599884805', '1584605001', '1591585461', '7', '5');
INSERT INTO `hisi_system_user` VALUES ('15', 'zxy123', '$2y$10$QUpLaGob5CuODc.gaiHkReRJSueZ/dAaBB..GXiX9dmO8oGXNrpPW', '赵欣羽', '', '', '', '0', 'default', '1', '27.213.44.107', '0', '1584605094', '1591585501', '7', '7');
INSERT INTO `hisi_system_user` VALUES ('16', 'ty123', '$2y$10$r2SXKPb7pUnJo2SfSthOHup2GoiW4Ee1nKkteMOvTjNEtkLvnzC5.', '唐英', '', '', '', '0', '9', '1', '123.130.148.82', '1603095258', '1584605646', '1591585517', '7', '3');
INSERT INTO `hisi_system_user` VALUES ('17', 'lmj123', '$2y$10$BhFQoZHYv8lUm4B1qmTadu6T128qPPKscKBKSBo/kUNm.wAhHo0U2', '柳萌君', '', '', '', '0', 'default', '1', '123.130.148.82', '1603603144', '1584605685', '1591585545', '7', '4');
INSERT INTO `hisi_system_user` VALUES ('18', 'csy', '$2y$10$uFmPlfw8g0p3Hkxxwu3zl.Ex4CfDBjq4xk7KQC.ma05kfpCLeATq2', '陈淑一', '', '', '', '0', 'default', '1', '27.217.253.21', '1599030611', '1584606164', '1599030690', '7', '6');
INSERT INTO `hisi_system_user` VALUES ('20', 'xxq123', '$2y$10$08CiZOtQZ1e8J0CP4E3TSOWKIMV4rATvRP/xmgI2tgd2uhTkR8mxC', '徐晓庆', '12345678910', '', '', '0', 'default', '1', '27.217.11.171', '1603183554', '1589355542', '1590130910', '1', '4');
INSERT INTO `hisi_system_user` VALUES ('21', 'mj123', '$2y$10$OY7prmy5xwtk/dmrTzQegezeitlLcy2jVxT3PkmLV1XK41w1nHWqW', '苗俊', '', '', '', '0', '9', '1', '27.217.11.171', '1603259974', '1589355580', '1589358157', '1', '3');
INSERT INTO `hisi_system_user` VALUES ('22', 'lyp123', '$2y$10$zjFVAwSZplKARayUsPdZ8u5IadkFsaAD4ppZVDhddGgloKlOwtyT.', '梁艳萍', '', '', '', '0', 'default', '1', '60.212.11.73', '1598343795', '1589355627', '1591585560', '1', '5');
INSERT INTO `hisi_system_user` VALUES ('23', 'ssq123', '$2y$10$7JdD91PAd0jNwTv1nQyrfOk9GZFcQJ7PqYmR7kkXg0uYJLsYm2Hdy', '孙少芹', '', '', '', '0', 'default', '1', '27.217.253.21', '1599029705', '1589355660', '1589359944', '1', '6');
INSERT INTO `hisi_system_user` VALUES ('24', 'yxq123', '$2y$10$dPUBCzFeDRTCk7cetDulD.FXuAH9.eCF2ZYAesEnKajRHxy3ixKm.', '衣晓庆', '', '', '', '0', 'default', '1', '123.130.1.77', '1589356829', '1589356774', '1589356774', '1', '7');
INSERT INTO `hisi_system_user` VALUES ('25', 'wyz123', '$2y$10$55Uatj/uDkICotPenYJ5QeZEmm7piVwFkP0LEDXNoRpef4/IDRoYW', '王雅贞', '', '', '', '0', 'default', '1', '123.130.1.77', '0', '1589356801', '1589357340', '1', '7');
INSERT INTO `hisi_system_user` VALUES ('26', 'sy123', '$2y$10$WLs4Z2QhwGl3QUS4JHiWYuhMPwp7UoE1tRuR3TaQQeNLjTKHv1FKu', '孙钰', '', '', '', '0', 'default', '1', '218.59.115.6', '1603281675', '1589358191', '1603331253', '8', '3');
INSERT INTO `hisi_system_user` VALUES ('27', 'mlh123', '$2y$10$un9W288J58ioebOcecpBouQcunmabU/TI/p9wGmPdTaVp4pDe7p4y', '马丽慧', '', '', '', '0', 'default', '1', '218.59.115.6', '1603276070', '1589792785', '1591585612', '8', '4');
INSERT INTO `hisi_system_user` VALUES ('28', 'liujuanjuan', '$2y$10$/FVphhJVpHVgdJ.MFPkKXuEWYONujY6GceiX3lOYwyubvg9hQVrA6', '刘娟娟', '', '', '', '0', 'default', '1', '27.213.49.122', '0', '1591586322', '1591596830', '1', '7');
INSERT INTO `hisi_system_user` VALUES ('29', 'swj123', '$2y$10$YIS.eRoYtCNeeq9hYN0tVOJlJIGehi7I1A.H6.IDO9wGCzc7Jf5IG', '宋伟娟', '', '', '', '0', 'default', '1', '27.213.49.122', '0', '1591587871', '1591595352', '1', '7');
INSERT INTO `hisi_system_user` VALUES ('30', 'dje123', '$2y$10$pG5dCin9oqsgKJfywc0oIufSzWsIQ//bAdYHhcyZcCQu7a/9Dqfe.', '杜金娥', '', '', '', '0', 'default', '1', '27.213.49.122', '0', '1591587908', '1591595367', '1', '7');
INSERT INTO `hisi_system_user` VALUES ('31', 'syp123', '$2y$10$VK8R1kwRKNJaVru4AmK9g.1iKZ1WAEhvxtwml8QDi75ElGtv2PEUm', '孙元平', '', '', '', '0', 'default', '1', '27.213.49.122', '0', '1591588180', '1591595340', '8', '7');
INSERT INTO `hisi_system_user` VALUES ('32', 'lww123', '$2y$10$FPnCFYHtn3BYG8osVZi3GemFqDGjCm7ZbxRxEdoBkNRzOpOv1hrrO', '李伟伟', '', '', '', '0', 'default', '1', '27.213.49.122', '0', '1591588206', '1591595327', '8', '7');
INSERT INTO `hisi_system_user` VALUES ('33', 'zm123', '$2y$10$.U4EsMMiRspR9xP7KoQNvO4soxLkPus3aPYTL9NlRfdHhZUwRPZgy', '朱敏', '', '', '', '0', 'default', '1', '27.213.49.122', '0', '1591588242', '1591595313', '8', '7');
INSERT INTO `hisi_system_user` VALUES ('34', 'psl123', '$2y$10$IZyYYkkFGCGHF.PzsF3bqe1eWAsOMvwYzrUVoFiq80Oet9.d2uOI6', '逄淑丽', '', '', '', '0', 'default', '1', '27.213.49.122', '0', '1591588269', '1591595300', '8', '7');
INSERT INTO `hisi_system_user` VALUES ('35', 'lxs123', '$2y$10$znthonIoCBwFx.xJvnc42eImYlm3Liib1st9PdBM2x48kG3n33Aza', '卢晓珊', '', '', '', '0', 'default', '1', '27.213.49.122', '0', '1591588292', '1591595287', '8', '7');
INSERT INTO `hisi_system_user` VALUES ('36', 'LXL123', '$2y$10$vJRCUQqUsiuV4YhkgyRVRu4PmE7ksyiVcS4xjfMBbDb1u4Ljm55ey', '李香丽', '', '', '', '0', 'default', '1', '113.124.208.147', '0', '1591595253', '1591595253', '8', '7');
INSERT INTO `hisi_system_user` VALUES ('38', 'wh123', '$2y$10$I/b93UcWnOxOVNpfQdLJye/b0YxizPDCKmwTXkqm9BhAcACJ87mle', '王华', '', '', '', '0', 'default', '1', '27.213.49.122', '0', '1591752404', '1591752834', '8', '7');
INSERT INTO `hisi_system_user` VALUES ('39', 'guwen', '$2y$10$19S1KDyAa7GyYykbQfFLX.PbirQwHXEObwC0sTyjMSDhcKhaXnLxa', '顾问', '', '', '', '0', 'default', '1', '27.213.72.87', '0', '1592645497', '1592645497', '1', '5');
INSERT INTO `hisi_system_user` VALUES ('40', 'mrs', '$2y$10$0bVkDYtR8FRPr5YK0s7rs.uBdzNWikw/YAhu0E4/KmK3qupUFzJMu', '美容师', '', '', '', '0', 'default', '1', '27.213.72.87', '0', '1592646052', '1592646052', '1', '7');
INSERT INTO `hisi_system_user` VALUES ('41', 'qj123', '$2y$10$GSw/Ohzka5Ty2YUSRdSo.e4SqwwMBv7MoNbppGfSoMJ4/pJtx4Ev6', '曲娟', '', '', '', '0', 'default', '1', '27.213.49.122', '1592899995', '1592875517', '1592875960', '7', '5');
INSERT INTO `hisi_system_user` VALUES ('42', 'sjh1234', '$2y$10$V2wsmCM9kCefGNYQxr3KaehyflKIHOSXyRCq.jUgV9xr5k9y1jO7K', '孙佳慧(美容师）', '', '', '', '0', 'default', '1', '27.213.49.122', '0', '1592876620', '1592879305', '7', '7');
INSERT INTO `hisi_system_user` VALUES ('43', 'jy1234', '$2y$10$se43onDwct83ZXhE5/Ke6OLqErvkj203l4oq6YSognvF8lbzlQ3vC', '姜妍（美容师）', '', '', '', '0', 'default', '1', '27.213.49.122', '0', '1592879177', '1592879177', '7', '7');
INSERT INTO `hisi_system_user` VALUES ('44', 'qj1234', '$2y$10$thcrTHydoFREhKqKT2zL8eaScqapVPAAhpkyFUHv3E7c2q3xwKguW', '曲娟（美容师）', '', '', '', '0', 'default', '1', '27.213.49.122', '0', '1592879713', '1592879713', '7', '7');
INSERT INTO `hisi_system_user` VALUES ('45', 'mrs123', '$2y$10$ssEJRpAyMl9hXGaTMQ0.VeHPKgx.l5JnWO.2TFygbkuroHg0SMY3K', '美容师(台湾村）', '', '', '', '0', 'default', '1', '27.213.49.122', '0', '1592901163', '1592901163', '7', '7');
INSERT INTO `hisi_system_user` VALUES ('46', 'lina', '$2y$10$mE3ssD.OnGnGrleQgWaUpuUGNDXAf2t25pbfBKTgR1ckiKiALFMra', '李娜（美容师）', '', '', '', '0', 'default', '1', '27.213.72.87', '0', '1592987855', '1592987855', '1', '7');
INSERT INTO `hisi_system_user` VALUES ('47', 'liangyanping', '$2y$10$2z/qsZr8TKHmF5ctukeXZ.Et/6ukzDh1j6AjPhJ3LiomqCQ5LXlke', '梁艳平（美容师）', '', '', '', '0', 'default', '1', '27.213.72.87', '0', '1592987921', '1592987921', '1', '7');
INSERT INTO `hisi_system_user` VALUES ('48', 'dmeirongshi', '$2y$10$Jye0IKWtG4xvgIZYbWAjwO0mW5OyDJNUinWnUnfE9qwRZm3ytk4HC', 'D美容师', '', '', '', '0', 'default', '1', '123.130.158.87', '0', '1593067391', '1593067391', '8', '7');
INSERT INTO `hisi_system_user` VALUES ('49', 'th1234', '$2y$10$DysOgU/mbuGCPsSsCgLoZOf7LRv9PL841v4MYQVbJo0am1R0pg4a2', '唐慧（美容师）', '', '', '', '0', 'default', '1', '27.213.49.122', '0', '1593565259', '1593565259', '8', '7');
INSERT INTO `hisi_system_user` VALUES ('50', 'xnn1234', '$2y$10$AujBm9ev.onBMyoqSHLzpudhxQ8guMC10YehgzLrlvsgI1DNlBk2C', '许牛牛（美容师）', '', '', '', '0', 'default', '1', '27.213.49.122', '0', '1593565316', '1593565316', '8', '7');
INSERT INTO `hisi_system_user` VALUES ('51', 'lml1234', '$2y$10$kCBcOk3EedRbH4/Ou6Vw/OAap5wTHOIckA6IKFjAi0BvWHgy98bBe', '鲁明月（美容师）', '', '', '', '0', 'default', '1', '27.213.49.122', '0', '1593566246', '1593566246', '8', '7');
INSERT INTO `hisi_system_user` VALUES ('52', 'sj123', '$2y$10$451GmUV1UMe.2aSGEAWPieJ7QuVcnrw4u8ibaZ6zVYAnRvWnVpZvW', '孙静', '', '', '', '0', 'default', '1', '27.216.197.140', '0', '1595051607', '1595051607', '8', '7');
INSERT INTO `hisi_system_user` VALUES ('53', 'xjj123', '$2y$10$Rv1gtjBc5OX/9GBFT/j94uOhL2E60wP/dRIJyT36wYrxQ9iDTaF/m', '徐金菊(店经理）', '', '', '', '0', 'default', '1', '123.130.148.82', '1603271882', '1595208744', '1599267388', '7', '2');
INSERT INTO `hisi_system_user` VALUES ('54', 'xjj1234', '$2y$10$6qCTI0Dt.9aEYgGtL7DAfeYY8fCVlfmM464q7nP/AbJdP91OMZBUG', '徐金菊（美容师）', '', '', '', '0', 'default', '1', '27.216.197.140', '0', '1595208812', '1595208812', '7', '7');
INSERT INTO `hisi_system_user` VALUES ('55', 'wrx', '$2y$10$kkBZnkUuM5CgKX0j38MMzuIA8nAjUX.zmFF1IkxAQNxFMcdTxNtl2', '王汝星', '', '', '', '0', 'default', '1', '60.212.11.73', '0', '1595323022', '1595323022', '1', '7');
INSERT INTO `hisi_system_user` VALUES ('56', 'sxy1234', '$2y$10$EzMle81RP5UQ0xvGZXqCQe2nxVhLnGq20JlnbmTCDxv0PjuxZaWz.', '隋晓艳（大成门）', '', '', '', '0', 'default', '1', '27.216.197.140', '0', '1595387585', '1595387585', '8', '7');
INSERT INTO `hisi_system_user` VALUES ('57', 'lxl1234', '$2y$10$zmvy1wBiXv7jVi3yD8i/.Oo1eZK2/.Tbn.OTsf2r0Fll64amF2ntK', '李香丽(台湾村）', '', '', '', '0', 'default', '1', '27.216.197.140', '0', '1595467121', '1595467121', '7', '7');
INSERT INTO `hisi_system_user` VALUES ('58', 'wyn123', '$2y$10$pjyzQuZfsrW.uoTjNmFcWOqBSTeh9l9xWFHdIbpS8OXPF8c8iQfjO', '王艺宁(台湾村）', '', '', '', '0', 'default', '1', '27.216.197.140', '0', '1595467168', '1595467168', '7', '7');
INSERT INTO `hisi_system_user` VALUES ('59', 'hm', '$2y$10$mmAjb2y6dEAPzrwyTz.nIeOvcZzgF47qLjoMu7Ejdrx8taHPmic..', '侯敏', '', '', '', '0', 'default', '1', '60.212.11.73', '0', '1595491727', '1595491727', '1', '7');
INSERT INTO `hisi_system_user` VALUES ('60', 'sj1234', '$2y$10$2gyj2mrP4.NgX785Q2bRPOBobJLEj4k.12xNM0DwmpReRQtGQ2li2', '孙静台湾村店', '', '', '', '0', 'default', '1', '27.216.197.140', '0', '1595580153', '1595580153', '7', '7');
INSERT INTO `hisi_system_user` VALUES ('61', 'sj12345', '$2y$10$9Ntb2VRJUyE5pCLKeap5duLIJgik803Zq9DoPGM0pBEFBmho.h.yi', '孙静（开发区）', '', '', '', '0', 'default', '1', '27.216.197.140', '0', '1595580193', '1595580208', '1', '7');
INSERT INTO `hisi_system_user` VALUES ('62', 'hm123', '$2y$10$OTnCHkDqM4A/jfW.t82VnuqL8gcZOAMpGlepOJiSurzpTjpFPdFei', '侯敏台湾村', '', '', '', '0', 'default', '1', '27.216.197.140', '0', '1595906507', '1595906507', '7', '7');
INSERT INTO `hisi_system_user` VALUES ('63', 'myj123', '$2y$10$5tEflmhvkZzEu.DXrwplpuLskQIqPEevanDPChpb9qotXwwOMrDK6', '孟彦君', '', '', '', '0', 'default', '1', '27.216.197.140', '0', '1595906534', '1595906534', '7', '7');
INSERT INTO `hisi_system_user` VALUES ('64', 'smx123', '$2y$10$HGlbNx.bB4QArf5W4DrLo.zaqbYDwHOBKL7IXgXoLI.2wBmcyeoOa', '孙铭霞', '', '', '', '0', 'default', '1', '27.216.197.140', '0', '1595906570', '1595906570', '7', '7');
INSERT INTO `hisi_system_user` VALUES ('65', 'cw123', '$2y$10$RovLSrAjovb0e6N3dyQnd.awdn7Dl3T9ouPV/4BTIntPsqbNBKhUK', '财务', '', '', '', '0', 'default', '1', '27.216.197.140', '0', '1596094102', '1596094102', '9', '3');
INSERT INTO `hisi_system_user` VALUES ('66', 'cw1234', '$2y$10$FhCAqYFSFW5Ox8qCGvtkOupEd/f8yd4t2rgJtM5x9A.tX8354vN5S', '库管', '', '', '', '0', 'default', '1', '27.216.197.140', '0', '1596094367', '1596094367', '9', '4');
INSERT INTO `hisi_system_user` VALUES ('67', 'sjh123', '$2y$10$a3m3gHehzLalZO3mJfYu6.1oN7kZPKVjbG3HuIMRp3e7l6h2afO3a', '孙佳慧', '', '', '', '0', 'default', '1', '60.212.11.73', '1598429888', '1597130364', '1599267261', '1', '2');
INSERT INTO `hisi_system_user` VALUES ('68', 'sjhcc', '$2y$10$tlm2UHcqi4LzVEVktvsUwOdkaZTFyqMs9MTV35mgZm.3z43x9fOpC', 'CC', '', '', '', '0', 'default', '1', '112.237.24.139', '0', '1597290750', '1597290750', '1', '7');
INSERT INTO `hisi_system_user` VALUES ('69', 'klj123', '$2y$10$aFq7ozSJyz1NvlvllxGRu.Yz0bVEJr5b6yTIHr68nn7Hfglqv2xFm', '孔令娟', '', '', '', '0', 'default', '1', '27.217.253.21', '1599030760', '1599030746', '1599030746', '9', '6');
INSERT INTO `hisi_system_user` VALUES ('70', 'xjj12345', '$2y$10$hyVDDdLv7qWFymhWhTjVCe8C/xPeoMJxI3fRjg0Acut5kc6fFWUhy', '徐金菊（顾问）', '', '', '', '0', 'default', '1', '27.217.253.21', '0', '1599269397', '1599269397', '7', '5');
INSERT INTO `hisi_system_user` VALUES ('71', 'sxq123', '$2y$10$2/Ktvqlu6AXB6NAQDCNca.g8f0uaPbOKos94fuGEPJC27rgr8IRqO', '隋晓庆', '', '', '', '0', 'default', '1', '27.217.11.171', '1603437400', '1599525565', '1599530828', '1', '0');
INSERT INTO `hisi_system_user` VALUES ('72', 'jzy123', '$2y$10$kdvuS6yBaaQOQr9tKszzceYZfEXxW1J.XCxqIHOmXKe5ErIatbKVa', '姬子妤', '', '', '', '0', 'default', '1', '113.124.208.194', '0', '1602898763', '1602898763', '7', '7');
-- ----------------------------
-- Table structure for hisi_system_user_role
-- ----------------------------
DROP TABLE IF EXISTS `hisi_system_user_role`;
CREATE TABLE `hisi_system_user_role` (
`user_id` int(11) unsigned NOT NULL,
`role_id` int(10) unsigned DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='管理员角色索引';
-- ----------------------------
-- Records of hisi_system_user_role
-- ----------------------------
INSERT INTO `hisi_system_user_role` VALUES ('24', '7');
INSERT INTO `hisi_system_user_role` VALUES ('25', '7');
INSERT INTO `hisi_system_user_role` VALUES ('21', '4');
INSERT INTO `hisi_system_user_role` VALUES ('23', '8');
INSERT INTO `hisi_system_user_role` VALUES ('20', '5');
INSERT INTO `hisi_system_user_role` VALUES ('3', '6');
INSERT INTO `hisi_system_user_role` VALUES ('3', '7');
INSERT INTO `hisi_system_user_role` VALUES ('5', '7');
INSERT INTO `hisi_system_user_role` VALUES ('6', '7');
INSERT INTO `hisi_system_user_role` VALUES ('9', '6');
INSERT INTO `hisi_system_user_role` VALUES ('9', '7');
INSERT INTO `hisi_system_user_role` VALUES ('8', '6');
INSERT INTO `hisi_system_user_role` VALUES ('8', '7');
INSERT INTO `hisi_system_user_role` VALUES ('11', '7');
INSERT INTO `hisi_system_user_role` VALUES ('12', '7');
INSERT INTO `hisi_system_user_role` VALUES ('13', '7');
INSERT INTO `hisi_system_user_role` VALUES ('14', '6');
INSERT INTO `hisi_system_user_role` VALUES ('14', '7');
INSERT INTO `hisi_system_user_role` VALUES ('15', '7');
INSERT INTO `hisi_system_user_role` VALUES ('16', '4');
INSERT INTO `hisi_system_user_role` VALUES ('17', '5');
INSERT INTO `hisi_system_user_role` VALUES ('22', '6');
INSERT INTO `hisi_system_user_role` VALUES ('22', '7');
INSERT INTO `hisi_system_user_role` VALUES ('27', '5');
INSERT INTO `hisi_system_user_role` VALUES ('36', '7');
INSERT INTO `hisi_system_user_role` VALUES ('35', '7');
INSERT INTO `hisi_system_user_role` VALUES ('34', '7');
INSERT INTO `hisi_system_user_role` VALUES ('33', '7');
INSERT INTO `hisi_system_user_role` VALUES ('32', '7');
INSERT INTO `hisi_system_user_role` VALUES ('31', '7');
INSERT INTO `hisi_system_user_role` VALUES ('29', '7');
INSERT INTO `hisi_system_user_role` VALUES ('30', '7');
INSERT INTO `hisi_system_user_role` VALUES ('7', '7');
INSERT INTO `hisi_system_user_role` VALUES ('28', '7');
INSERT INTO `hisi_system_user_role` VALUES ('2', '7');
INSERT INTO `hisi_system_user_role` VALUES ('10', '7');
INSERT INTO `hisi_system_user_role` VALUES ('38', '7');
INSERT INTO `hisi_system_user_role` VALUES ('39', '6');
INSERT INTO `hisi_system_user_role` VALUES ('40', '7');
INSERT INTO `hisi_system_user_role` VALUES ('41', '6');
INSERT INTO `hisi_system_user_role` VALUES ('41', '7');
INSERT INTO `hisi_system_user_role` VALUES ('43', '7');
INSERT INTO `hisi_system_user_role` VALUES ('42', '7');
INSERT INTO `hisi_system_user_role` VALUES ('44', '7');
INSERT INTO `hisi_system_user_role` VALUES ('45', '7');
INSERT INTO `hisi_system_user_role` VALUES ('46', '7');
INSERT INTO `hisi_system_user_role` VALUES ('47', '7');
INSERT INTO `hisi_system_user_role` VALUES ('48', '7');
INSERT INTO `hisi_system_user_role` VALUES ('49', '7');
INSERT INTO `hisi_system_user_role` VALUES ('50', '7');
INSERT INTO `hisi_system_user_role` VALUES ('51', '7');
INSERT INTO `hisi_system_user_role` VALUES ('52', '7');
INSERT INTO `hisi_system_user_role` VALUES ('54', '7');
INSERT INTO `hisi_system_user_role` VALUES ('55', '7');
INSERT INTO `hisi_system_user_role` VALUES ('56', '7');
INSERT INTO `hisi_system_user_role` VALUES ('57', '7');
INSERT INTO `hisi_system_user_role` VALUES ('58', '7');
INSERT INTO `hisi_system_user_role` VALUES ('59', '7');
INSERT INTO `hisi_system_user_role` VALUES ('60', '7');
INSERT INTO `hisi_system_user_role` VALUES ('61', '7');
INSERT INTO `hisi_system_user_role` VALUES ('62', '7');
INSERT INTO `hisi_system_user_role` VALUES ('63', '7');
INSERT INTO `hisi_system_user_role` VALUES ('64', '7');
INSERT INTO `hisi_system_user_role` VALUES ('65', '8');
INSERT INTO `hisi_system_user_role` VALUES ('66', '5');
INSERT INTO `hisi_system_user_role` VALUES ('68', '7');
INSERT INTO `hisi_system_user_role` VALUES ('18', '8');
INSERT INTO `hisi_system_user_role` VALUES ('69', '8');
INSERT INTO `hisi_system_user_role` VALUES ('67', '9');
INSERT INTO `hisi_system_user_role` VALUES ('53', '9');
INSERT INTO `hisi_system_user_role` VALUES ('70', '6');
INSERT INTO `hisi_system_user_role` VALUES ('71', '10');
INSERT INTO `hisi_system_user_role` VALUES ('72', '7');
INSERT INTO `hisi_system_user_role` VALUES ('26', '4');
-- ----------------------------
-- Table structure for hisi_token
-- ----------------------------
DROP TABLE IF EXISTS `hisi_token`;
CREATE TABLE `hisi_token` (
`token` varchar(128) NOT NULL DEFAULT '' COMMENT 'Token',
`tag` varchar(50) DEFAULT '' COMMENT '标签',
`value` varchar(30) NOT NULL DEFAULT '' COMMENT '映射的值',
`create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
`expire_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '过期时间',
PRIMARY KEY (`token`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='token表';
-- ----------------------------
-- Records of hisi_token
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_unit
-- ----------------------------
DROP TABLE IF EXISTS `hisi_unit`;
CREATE TABLE `hisi_unit` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '单位ID',
`name` varchar(100) NOT NULL COMMENT '单位名称',
`weigh` int(11) NOT NULL COMMENT '排序',
`createtime` int(11) NOT NULL COMMENT '系统添加时间',
`updatetime` int(11) NOT NULL COMMENT '系统更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of hisi_unit
-- ----------------------------
INSERT INTO `hisi_unit` VALUES ('1', 'kg', '1', '1577698501', '1581689823');
INSERT INTO `hisi_unit` VALUES ('2', 'g', '2', '1577698515', '1577698515');
INSERT INTO `hisi_unit` VALUES ('3', 'L', '3', '1577754449', '1577754449');
INSERT INTO `hisi_unit` VALUES ('4', 'ml', '4', '1577754465', '1577754465');
INSERT INTO `hisi_unit` VALUES ('5', '套', '6', '1577754509', '1577754509');
INSERT INTO `hisi_unit` VALUES ('6', '箱', '5', '1577754527', '1603443733');
INSERT INTO `hisi_unit` VALUES ('7', '瓶', '7', '1577754543', '1577754543');
INSERT INTO `hisi_unit` VALUES ('8', '包', '8', '1577754551', '1577754551');
INSERT INTO `hisi_unit` VALUES ('9', '袋', '9', '1577754561', '1577754561');
INSERT INTO `hisi_unit` VALUES ('10', '件', '10', '1577754579', '1577754579');
INSERT INTO `hisi_unit` VALUES ('13', '支', '50', '1589170360', '1589170360');
INSERT INTO `hisi_unit` VALUES ('14', '盒', '50', '1589170445', '1589170445');
INSERT INTO `hisi_unit` VALUES ('15', '本', '50', '1589175517', '1602654852');
INSERT INTO `hisi_unit` VALUES ('16', '桶', '50', '1590462354', '1590462354');
INSERT INTO `hisi_unit` VALUES ('17', '片', '50', '1591065960', '1591065960');
INSERT INTO `hisi_unit` VALUES ('18', '次', '50', '1591066361', '1591066361');
INSERT INTO `hisi_unit` VALUES ('19', '个', '14', '1591171112', '1591171112');
INSERT INTO `hisi_unit` VALUES ('20', '台', '50', '1591255120', '1591255120');
INSERT INTO `hisi_unit` VALUES ('21', '条', '50', '1591255455', '1591255455');
INSERT INTO `hisi_unit` VALUES ('22', '卷', '50', '1591350971', '1591350971');
INSERT INTO `hisi_unit` VALUES ('23', '双', '50', '1591413216', '1591413216');
-- ----------------------------
-- Table structure for hisi_user
-- ----------------------------
DROP TABLE IF EXISTS `hisi_user`;
CREATE TABLE `hisi_user` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`group_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员分组ID',
`nick` varchar(50) NOT NULL DEFAULT '' COMMENT '昵称',
`username` varchar(30) NOT NULL DEFAULT '' COMMENT '用户名',
`mobile` bigint(11) unsigned NOT NULL DEFAULT '0' COMMENT '手机号',
`email` varchar(50) NOT NULL DEFAULT '' COMMENT '邮箱',
`password` varchar(128) NOT NULL DEFAULT '' COMMENT '密码',
`salt` varchar(16) NOT NULL DEFAULT '' COMMENT '密码混淆',
`money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '可用金额',
`frozen_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '冻结金额',
`income` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '收入统计',
`expend` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '开支统计',
`exper` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '经验值',
`integral` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '积分',
`frozen_integral` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '冻结积分',
`sex` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '性别(1男，0女)',
`avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '头像',
`last_login_ip` varchar(128) NOT NULL DEFAULT '' COMMENT '最后登陆IP',
`last_login_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后登陆时间',
`login_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '登陆次数',
`expire_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '到期时间(0永久)',
`status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态(0禁用，1正常)',
`ctime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
`mtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
`vx` varchar(255) DEFAULT NULL COMMENT '微信',
`birthday` int(11) DEFAULT NULL COMMENT '生日',
`height` char(10) DEFAULT '0' COMMENT '身高',
`weight` char(10) DEFAULT '0' COMMENT '体重',
`shop_id` int(11) DEFAULT NULL,
`sb_card` varchar(255) DEFAULT NULL COMMENT '会员卡号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1006332 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='[系统] 会员表';
-- ----------------------------
-- Records of hisi_user
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_user_balance
-- ----------------------------
DROP TABLE IF EXISTS `hisi_user_balance`;
CREATE TABLE `hisi_user_balance` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL COMMENT '用户',
`price1` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '充值金额',
`price2` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '赠送金额',
`cashier_id` int(11) NOT NULL COMMENT '收银',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态：1=开单，2=审核通过，3=审核不通过',
`createtime` int(11) NOT NULL COMMENT '创建时间',
`updatetime` int(11) NOT NULL COMMENT '更新时间',
`finance_id` int(11) DEFAULT NULL COMMENT '财务id',
`adviser_id` int(11) DEFAULT NULL COMMENT '顾问',
`technician_id` char(255) DEFAULT NULL COMMENT '美容师',
`sn` varchar(255) NOT NULL COMMENT '单号',
`shop_id` int(11) DEFAULT NULL,
`account_id` int(11) NOT NULL COMMENT '充值账户',
`bak` text COMMENT '备注',
`price` decimal(10,2) NOT NULL COMMENT '实际支付金额',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=342 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='用户充值余额敏明细表';
-- ----------------------------
-- Records of hisi_user_balance
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_user_balance_log
-- ----------------------------
DROP TABLE IF EXISTS `hisi_user_balance_log`;
CREATE TABLE `hisi_user_balance_log` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) unsigned NOT NULL COMMENT '用户id',
`type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '金额增加：1=增加，2=购买项目使用，3=购买产品使用，4=购买会疗程卡;5=销售退回',
`price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '金额',
`sn` varchar(255) DEFAULT NULL COMMENT '订单号',
`createtime` int(11) NOT NULL COMMENT '创建时间',
`is_give` tinyint(2) NOT NULL DEFAULT '1' COMMENT '是否赠送：1=否，2=是',
`updatetime` int(11) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11626 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of hisi_user_balance_log
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_user_card
-- ----------------------------
DROP TABLE IF EXISTS `hisi_user_card`;
CREATE TABLE `hisi_user_card` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL COMMENT '用户',
`course_id` int(10) NOT NULL DEFAULT '0' COMMENT '会员卡ID',
`cashier_id` int(11) NOT NULL COMMENT '收银',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态：1=开单，2=审核通过，3=审核不通过',
`createtime` int(11) NOT NULL COMMENT '创建时间',
`updatetime` int(11) NOT NULL COMMENT '更新时间',
`finance_id` int(11) DEFAULT NULL COMMENT '财务id',
`adviser_id` int(11) DEFAULT NULL COMMENT '顾问',
`technician_id` char(255) DEFAULT NULL COMMENT '美容师',
`sn` varchar(255) NOT NULL COMMENT '单号',
`shop_id` int(11) DEFAULT NULL,
`account_id` int(11) NOT NULL COMMENT '充值账户',
`price1` decimal(10,2) DEFAULT NULL COMMENT '价格',
`bak` text COMMENT '备注',
`num` decimal(10,2) NOT NULL DEFAULT '1.00' COMMENT '数量',
`q1` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '实交',
`q2` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '欠款',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=21043 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='用户充值会员卡明细表';
-- ----------------------------
-- Records of hisi_user_card
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_user_card_detail_log
-- ----------------------------
DROP TABLE IF EXISTS `hisi_user_card_detail_log`;
CREATE TABLE `hisi_user_card_detail_log` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(11) NOT NULL,
`cid` int(10) NOT NULL COMMENT '项目id',
`price` decimal(10,2) NOT NULL COMMENT '价格',
`start_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '期初数量',
`use_num` int(10) unsigned NOT NULL DEFAULT '1' COMMENT '使用数量',
`end_num` int(10) unsigned NOT NULL COMMENT '剩余数量',
`type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '类型：1=买入，2=使用，3=退卡，4=赠送',
`createtime` int(11) NOT NULL COMMENT '创建时间',
`course_id` int(10) NOT NULL COMMENT '疗程卡id',
`cate` tinyint(1) NOT NULL DEFAULT '1' COMMENT '分类：1=项目；2=产品',
`sn` varchar(255) DEFAULT NULL COMMENT '订单号 关联使用',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11986 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='疗程卡消费记录';
-- ----------------------------
-- Records of hisi_user_card_detail_log
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_user_card_log
-- ----------------------------
DROP TABLE IF EXISTS `hisi_user_card_log`;
CREATE TABLE `hisi_user_card_log` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) unsigned NOT NULL COMMENT '用户id',
`pid` int(10) NOT NULL DEFAULT '0' COMMENT '项目或者产品的id',
`sn` varchar(255) DEFAULT NULL COMMENT '订单号',
`createtime` int(11) NOT NULL COMMENT '创建时间',
`updatetime` int(11) DEFAULT NULL,
`type` int(11) NOT NULL DEFAULT '1' COMMENT '是否使用：1=项目，2=产品，',
`use` int(11) NOT NULL DEFAULT '1' COMMENT '是否使用：1=未使用，2=已使用,3=销售退回',
`use_sn` varchar(255) DEFAULT NULL COMMENT '使用的订单',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=29209 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of hisi_user_card_log
-- ----------------------------
-- ----------------------------
-- Table structure for hisi_user_group
-- ----------------------------
DROP TABLE IF EXISTS `hisi_user_group`;
CREATE TABLE `hisi_user_group` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(80) NOT NULL COMMENT '等级名称',
`min_exper` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最小经验值',
`max_exper` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最大经验值',
`discount` int(2) unsigned NOT NULL DEFAULT '100' COMMENT '折扣率(%)',
`intro` varchar(255) NOT NULL COMMENT '等级简介',
`default` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '默认等级',
`expire` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员有效期(天)',
`status` tinyint(1) unsigned NOT NULL DEFAULT '1',
`ctime` int(10) unsigned NOT NULL DEFAULT '0',
`mtime` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='[系统] 会员等级';
-- ----------------------------
-- Records of hisi_user_group
-- ----------------------------
INSERT INTO `hisi_user_group` VALUES ('1', '注册会员', '0', '0', '100', '', '1', '0', '1', '0', '1545105600');
-- ----------------------------
-- Table structure for hisi_warehouse
-- ----------------------------
DROP TABLE IF EXISTS `hisi_warehouse`;
CREATE TABLE `hisi_warehouse` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`shop_id` int(10) unsigned NOT NULL COMMENT '门店ID',
`name` varchar(100) NOT NULL COMMENT '仓库名称',
`weigh` int(10) unsigned NOT NULL DEFAULT '100' COMMENT '排序',
`createtime` int(11) NOT NULL COMMENT '系统创建时间',
`updatetime` int(11) unsigned NOT NULL COMMENT '系统更新时间',
`type` tinyint(4) DEFAULT '0' COMMENT '是否配料库:1=配料库,0=总库',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of hisi_warehouse
-- ----------------------------
INSERT INTO `hisi_warehouse` VALUES ('16', '1', '澜悦新时代前台库', '50', '1591325917', '1591325917', '0');
INSERT INTO `hisi_warehouse` VALUES ('17', '1', '澜悦新时代配料库', '50', '1591325933', '1591325933', '1');
INSERT INTO `hisi_warehouse` VALUES ('18', '7', '澜悦台湾村总库', '50', '1591325953', '1591326023', '0');
INSERT INTO `hisi_warehouse` VALUES ('19', '7', '澜悦台湾村前台库', '50', '1591325969', '1591326011', '0');
INSERT INTO `hisi_warehouse` VALUES ('20', '7', '澜悦台湾村配料库', '50', '1591325984', '1591326179', '1');
INSERT INTO `hisi_warehouse` VALUES ('21', '8', '澜悦大成门总库', '50', '1591326205', '1591326205', '0');
INSERT INTO `hisi_warehouse` VALUES ('22', '8', '澜悦大成门前台库', '50', '1591326220', '1591326220', '0');
INSERT INTO `hisi_warehouse` VALUES ('15', '1', '澜悦新时代总库', '50', '1591325900', '1591325900', '0');
INSERT INTO `hisi_warehouse` VALUES ('23', '8', '澜悦大成门配料库', '50', '1591326237', '1591326237', '1');
INSERT INTO `hisi_warehouse` VALUES ('24', '9', '澜悦总库', '50', '1591326256', '1591326256', '0');
举报
请认真填写举报原因，尽可能描述详细。
请选择举报类型
误判申诉
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化