158 lines
8.6 KiB
SQL
158 lines
8.6 KiB
SQL
/*
|
|
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;
|