/* Navicat Premium Data Transfer Source Server : SBGL Source Server Type : MySQL Source Server Version : 80015 Source Host : frpgz1.idcfengye.com:10007 Source Schema : ngtools Target Server Type : MySQL Target Server Version : 80015 File Encoding : 65001 Date: 25/09/2019 20:56:36 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for field_name -- ---------------------------- DROP TABLE IF EXISTS `field_name`; CREATE TABLE `field_name` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Field_Text` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `Field_Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, PRIMARY KEY (`ID`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 410 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of field_name -- ---------------------------- INSERT INTO `field_name` VALUES (1, 'ID', '序号'); INSERT INTO `field_name` VALUES (2, 'Menu_ID', '菜单序号'); INSERT INTO `field_name` VALUES (3, 'Menu_Name', '菜单名称'); INSERT INTO `field_name` VALUES (4, 'Menu_Url', '站内地址'); INSERT INTO `field_name` VALUES (5, 'Parent_ID', '上一级序号'); INSERT INTO `field_name` VALUES (6, 'ShowOrder', '显示顺序'); INSERT INTO `field_name` VALUES (7, 'iconCls', '显示图标'); INSERT INTO `field_name` VALUES (9, 'user_accord', '用户账号'); INSERT INTO `field_name` VALUES (10, 'user_name', '用户姓名'); INSERT INTO `field_name` VALUES (11, 'password', '用户密码'); INSERT INTO `field_name` VALUES (12, 'ORG_ID', '单位序号'); INSERT INTO `field_name` VALUES (13, 'state', '状态'); INSERT INTO `field_name` VALUES (14, 'role', '角色'); INSERT INTO `field_name` VALUES (15, 'authority', '权限'); INSERT INTO `field_name` VALUES (16, 'phoneNo', '电话号码'); INSERT INTO `field_name` VALUES (19, 'ORG_Name', '单位名称'); INSERT INTO `field_name` VALUES (20, 'ORG_PARENT_ID', '上级单位'); INSERT INTO `field_name` VALUES (21, 'ORG_TYPE', '单位类型'); INSERT INTO `field_name` VALUES (23, 'Device_Type_ID', '设备类型序号'); INSERT INTO `field_name` VALUES (24, 'Device_Type_Name', '设备类型名称'); INSERT INTO `field_name` VALUES (315, 'JD_SBBZ', '设备标志'); INSERT INTO `field_name` VALUES (316, 'JD_ZBH', '自编号'); INSERT INTO `field_name` VALUES (317, 'JD_SBLB', '设备类别'); INSERT INTO `field_name` VALUES (318, 'JD_SBMC', '设备名称'); INSERT INTO `field_name` VALUES (319, 'JD_JDDM', '机动代码'); INSERT INTO `field_name` VALUES (320, 'JD_SBXZ', '设备现状'); INSERT INTO `field_name` VALUES (321, 'JD_ZYDW', '在用单位'); -- ---------------------------- -- Table structure for ngcom -- ---------------------------- DROP TABLE IF EXISTS `ngcom`; CREATE TABLE `ngcom` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `qyd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `qysj` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `NGCom` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, PRIMARY KEY (`ID`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for organization -- ---------------------------- DROP TABLE IF EXISTS `organization`; CREATE TABLE `organization` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `ORG_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `ORG_Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `ORG_PARENT_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `ORG_TYPE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, PRIMARY KEY (`ID`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of organization -- ---------------------------- INSERT INTO `organization` VALUES (1, 'MS01', '天然气公司', 'MS00', '分公司'); INSERT INTO `organization` VALUES (2, 'MS0101', '输气一站', 'MS01', '站场'); INSERT INTO `organization` VALUES (3, 'MS010101', '进站总计量', 'MS0101', '计量点'); -- ---------------------------- -- Table structure for system_menu -- ---------------------------- DROP TABLE IF EXISTS `system_menu`; CREATE TABLE `system_menu` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Menu_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '菜单序号', `Menu_Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '菜单名称', `Menu_Url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '连接地址', `Parent_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '上级菜单序号', `ShowOrder` int(255) DEFAULT NULL COMMENT '显示顺序', `iconCls` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '图标名称', PRIMARY KEY (`ID`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 64 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of system_menu -- ---------------------------- INSERT INTO `system_menu` VALUES (1, 'M01', '流量计算', '', 'M00', 0, ''); INSERT INTO `system_menu` VALUES (2, 'M02', '压缩因子', NULL, 'M00', 1, NULL); INSERT INTO `system_menu` VALUES (3, 'M03', '物性参数', NULL, 'M00', 2, NULL); INSERT INTO `system_menu` VALUES (4, 'M10', '系统设置', NULL, 'M00', 10, NULL); INSERT INTO `system_menu` VALUES (5, 'M1001', '功能菜单', 'Pages/Z_System/system_Menu.aspx', 'M10', 0, NULL); INSERT INTO `system_menu` VALUES (46, 'M0101', '差压式流量计', 'Pages/A_FLowCal/orifice.aspx', 'M01', 0, ''); INSERT INTO `system_menu` VALUES (47, 'M0201', '单个计算', 'Pages/B_YSYZ/Z_singleCal.aspx', 'M02', 0, ''); INSERT INTO `system_menu` VALUES (48, 'M0202', '表格计算', 'Pages/B_YSYZ/Z_Table_Cal.aspx', 'M02', 1, ''); INSERT INTO `system_menu` VALUES (49, 'M11', 'CNG计算', '', 'M00', 3, ''); INSERT INTO `system_menu` VALUES (50, 'M0304', '声速计算', 'Pages/C_CSJS/SOS_Cal.aspx', 'M03', 3, ''); INSERT INTO `system_menu` VALUES (51, 'M0305', '密度计算', 'Pages/C_CSJS/md_Cal.aspx', 'M03', 0, ''); INSERT INTO `system_menu` VALUES (52, 'M0306', '热值计算', 'Pages/C_CSJS/RZ_Cal.aspx', 'M03', 1, ''); INSERT INTO `system_menu` VALUES (53, 'M0307', '临界流函数计算', 'Pages/C_CSJS/Cxh_Cal.aspx', 'M03', 2, ''); INSERT INTO `system_menu` VALUES (54, 'M0309', '含碳量计算', 'Pages/C_CSJS/Htl_Cal.aspx', 'M03', 4, ''); INSERT INTO `system_menu` VALUES (55, 'M0310', '其他参数计算', 'Pages/C_CSJS/QT_Cal.aspx', 'M03', 6, ''); INSERT INTO `system_menu` VALUES (56, 'M0310', '爆炸极限计算', 'Pages/C_CSJS/bzjx_Cal.aspx', 'M03', 5, ''); INSERT INTO `system_menu` VALUES (57, 'M1101', '管束车计算', 'Pages/D_CNG/gsc_Cal.aspx', 'M11', 0, ''); INSERT INTO `system_menu` VALUES (58, 'M1102', '装卸车计算', 'Pages/D_CNG/zxc_Cal.aspx', 'M11', 1, ''); INSERT INTO `system_menu` VALUES (60, 'M1003', '管束车管理', '', 'M10', 2, ''); INSERT INTO `system_menu` VALUES (61, 'M1004', '计量点管理', '', 'M10', 1, ''); INSERT INTO `system_menu` VALUES (62, 'M0102', '速度式流量计', 'Pages/A_FLowCal/suduCal.aspx', 'M01', 1, ''); INSERT INTO `system_menu` VALUES (63, 'M0103', '音速喷嘴', 'Pages/A_FLowCal/pzCal.aspx', 'M01', 2, ''); -- ---------------------------- -- Table structure for user -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `ID` int(255) NOT NULL AUTO_INCREMENT, `user_accord` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `ORG_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `role` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `authority` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `phoneNo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, PRIMARY KEY (`ID`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of user -- ---------------------------- INSERT INTO `user` VALUES (3, 'Admin', 'Admin', '123456', 'MS01', 'Activex', '', '', ''); SET FOREIGN_KEY_CHECKS = 1;