Fetch the repository succeeded.
Fork this repository
Loading
Sync repository?
This action will force synchronization from simple/美业管理平台（新）, which will overwrite any changes that you have made since you forked the repository, and can not be recovered!!!
Synchronous operation will process in the background and will refresh the page when finishing processing. Please be patient.
Clone/Download
Prompt
To download the code, please copy the following command and execute it in the terminal
To ensure that your submitted code identity is correctly recognized by Gitee, please execute the following command.
When using the SSH protocol for the first time to clone or push code, follow the prompts below to complete the SSH configuration.
1
Generate RSA keys.
2
Obtain the content of the RSA public key and configure it in SSH Public Keys
To use SVN on Gitee, please visit the usage guide
When using the HTTPS protocol, the command line will prompt for account and password verification as follows. For security reasons, Gitee recommends configure and use personal access tokens instead of login passwords for cloning, pushing, and other operations.
Username for 'https://gitee.com': userName
Password for 'https://userName@gitee.com':
#
Private Token
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#', '中信银行烟台经济技术开发区支行', '6217682600032115', '', '50', '1591254650', '1591254650', '1');
INSERT INTO `hisi_account` VALUES ('11', '威海银行6177#', '威海市商业银行股份有限公司烟台分行营业部', '6231020601000006177', '', '50', '1591254715', '1591254715', '1');
INSERT INTO `hisi_account` VALUES ('0', '会员卡', '会员卡，此项不能删除！！', '会员卡，此项不能删除！！', '会员卡，此项不能删除！！此项不能删除！！此项不能删除！！', '50', '1582271214', '1582271214', '1');
INSERT INTO `hisi_account` VALUES ('12', '广发银行7610#', '广发银行', '6214624321000127610', '', '50', '1591254778', '1591254778', '1');
INSERT INTO `hisi_account` VALUES ('9', '系统初始化', '系统初始化', '系统初始化', '系统初始化，请勿删除、修改', '50', '1591146230', '1591146828', '1');
INSERT INTO `hisi_account` VALUES ('13', '威海银行对公账户1612#', '威海市商业银行股份有限公司烟台分行', '817950001421001612', '', '50', '1591254843', '1591254843', '1');
INSERT INTO `hisi_account` VALUES ('14', '澜悦健康招行对公账户0802#', '招商银行股份有限公司烟台南大街支行', '535903511010802', '', '50', '1591254948', '1591254948', '1');
INSERT INTO `hisi_account` VALUES ('15', '澜悦健康建行对公账户0371#', '建设银行开发区泰山路支行', '37050166665200000371', '', '50', '1591255162', '1591255162', '1');
INSERT INTO `hisi_account` VALUES ('16', '天津银行信用卡1102#', '尹力', '6224269992111102', '15号账单日9号还款', '50', '1591255223', '1591255636', '1');
INSERT INTO `hisi_account` VALUES ('17', '平安银行信用卡0107#', '尹力', '6221570097810107', '3号账单21号还款', '50', '1591255305', '1591255598', '1');
INSERT INTO `hisi_account` VALUES ('18', '建设银行信用卡1181#', '尹力', '4367455065061181', '7号账单27号还款', '50', '1591255358', '1591255358', '1');
INSERT INTO `hisi_account` VALUES ('19', '中信银行信用卡2375#', '尹力', '4033930029762375', '', '50', '1591255424', '1591255424', '1');
INSERT INTO `hisi_account` VALUES ('20', '民生银行信用卡6141#', '付玲', '6226230024726141', '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');
Report
Please fill in the reason for the report carefully. Provide as detailed a description as possible.
Please select a report type
误判申诉
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化