mysql权限脚本_权限管理系统 mysql 数据脚本

1 # SQL-Front 5.1 (Build 4.16)2

3 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE*/;4 /*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'*/;5 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES*/;6 /*!40103 SET SQL_NOTES='ON'*/;7 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS*/;8 /*!40014 SET UNIQUE_CHECKS=0*/;9 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS*/;10 /*!40014 SET FOREIGN_KEY_CHECKS=0*/;11

12

13 # Host: localhost Database: pms14 # ------------------------------------------------------

15 # Server version 5.5.28

16

17 DROP DATABASE IF EXISTS`pms`;18 CREATE DATABASE `pms` /*!40100 DEFAULT CHARACTER SET utf8*/;19 USE`pms`;20

21 #22 # Source for tabletb_pms_area23 #24

25 DROP TABLE IF EXISTS`tb_pms_area`;26 CREATE TABLE`tb_pms_area` (27 `AREA_ID` varchar(555) NOT NULL,28 `AREA_NAME` varchar(555) DEFAULT NULL,29 `AREA_DESC` varchar(399) DEFAULT NULL,30 `PARENT_AREA_ID` varchar(555) DEFAULT NULL,31 `SORT_ORDER` int(11) DEFAULT '0'

32 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;33

34 #35 # Dumping data for tabletb_pms_area36 #37

38 LOCK TABLES `tb_pms_area` WRITE;39 /*!40000 ALTER TABLE `tb_pms_area` DISABLE KEYS*/;40 /*!40000 ALTER TABLE `tb_pms_area` ENABLE KEYS*/;41 UNLOCK TABLES;42

43 #44 # Source for tabletb_pms_group45 #46

47 DROP TABLE IF EXISTS`tb_pms_group`;48 CREATE TABLE`tb_pms_group` (49 `F_GROUPID` varchar(200) DEFAULT NULL,50 `F_GROUPNAME` varchar(555) DEFAULT NULL,51 `F_FLAG` int(11) DEFAULT NULL,52 `F_AREA_ID` varchar(333) DEFAULT NULL,53 `F_GROUPDESC` varchar(1000) DEFAULT NULL

54 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;55

56 #57 # Dumping data for tabletb_pms_group58 #59

60 LOCK TABLES `tb_pms_group` WRITE;61 /*!40000 ALTER TABLE `tb_pms_group` DISABLE KEYS*/;62 /*!40000 ALTER TABLE `tb_pms_group` ENABLE KEYS*/;63 UNLOCK TABLES;64

65 #66 # Source for tabletb_pms_group_role67 #68

69 DROP TABLE IF EXISTS`tb_pms_group_role`;70 CREATE TABLE`tb_pms_group_role` (71 `F_groupID` varchar(200) NOT NULL,72 `F_ROLEID` varchar(200) NOT NULL

73 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;74

75 #76 # Dumping data for tabletb_pms_group_role77 #78

79 LOCK TABLES `tb_pms_group_role` WRITE;80 /*!40000 ALTER TABLE `tb_pms_group_role` DISABLE KEYS*/;81 /*!40000 ALTER TABLE `tb_pms_group_role` ENABLE KEYS*/;82 UNLOCK TABLES;83

84 #85 # Source for tabletb_pms_module86 #87

88 DROP TABLE IF EXISTS`tb_pms_module`;89 CREATE TABLE`tb_pms_module` (90 `MOD_ID` varchar(888) NOT NULL,91 `MOD_PARENTID` varchar(888) DEFAULT NULL,92 `MOD_NAME` varchar(201) DEFAULT NULL,93 `MOD_TYPE` int(11) DEFAULT NULL,94 `MOD_DESC` varchar(755) DEFAULT NULL,95 `MOD_URL` varchar(755) DEFAULT NULL,96 `MOD_COUNTER` int(11) NOT NULL DEFAULT '0',97 `MOD_ORDER` int(11) DEFAULT NULL

98 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;99

100 #101 # Dumping data for tabletb_pms_module102 #103

104 LOCK TABLES `tb_pms_module` WRITE;105 /*!40000 ALTER TABLE `tb_pms_module` DISABLE KEYS*/;106 /*!40000 ALTER TABLE `tb_pms_module` ENABLE KEYS*/;107 UNLOCK TABLES;108

109 #110 # Source for tabletb_pms_role111 #112

113 DROP TABLE IF EXISTS`tb_pms_role`;114 CREATE TABLE`tb_pms_role` (115 `F_ROLEID` varchar(200) NOT NULL,116 `F_NAME` varchar(201) NOT NULL,117 `F_DESC` varchar(1000) DEFAULT NULL,118 `F_status` int(11) DEFAULT NULL,119 `F_createDate` date DEFAULT NULL

120 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;121

122 #123 # Dumping data for tabletb_pms_role124 #125

126 LOCK TABLES `tb_pms_role` WRITE;127 /*!40000 ALTER TABLE `tb_pms_role` DISABLE KEYS*/;128 /*!40000 ALTER TABLE `tb_pms_role` ENABLE KEYS*/;129 UNLOCK TABLES;130

131 #132 # Source for tabletb_pms_role_module133 #134

135 DROP TABLE IF EXISTS`tb_pms_role_module`;136 CREATE TABLE`tb_pms_role_module` (137 `MOD_ID` varchar(200) NOT NULL,138 `F_ROLEID` varchar(200) NOT NULL

139 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;140

141 #142 # Dumping data for tabletb_pms_role_module143 #144

145 LOCK TABLES `tb_pms_role_module` WRITE;146 /*!40000 ALTER TABLE `tb_pms_role_module` DISABLE KEYS*/;147 /*!40000 ALTER TABLE `tb_pms_role_module` ENABLE KEYS*/;148 UNLOCK TABLES;149

150 #151 # Source for tabletb_pms_user152 #153

154 DROP TABLE IF EXISTS`tb_pms_user`;155 CREATE TABLE`tb_pms_user` (156 `F_USERID` varchar(200) DEFAULT NULL,157 `F_NAME` varchar(200) DEFAULT NULL,158 `F_EMAIL` varchar(200) DEFAULT NULL,159 `F_MOBILE` varchar(200) DEFAULT NULL,160 `F_PASSWORD` varchar(100) DEFAULT NULL,161 `F_FLAG` int(11) DEFAULT NULL,162 `F_REGISTERTIME` date DEFAULT NULL,163 `F_LASTLOGIN` date DEFAULT NULL,164 `F_AREAID` varchar(100) DEFAULT NULL,165 `F_LEVEL_ID` int(11) DEFAULT NULL,166 `F_HOSTID` varchar(100) DEFAULT NULL,167 `F_ISLOCK` int(11) DEFAULT NULL,168 `F_LOCKDATEBEGIN` date DEFAULT NULL,169 `IF_SUPERUSER` varchar(2) DEFAULT NULL,170 `F_LASTMODIFY` date DEFAULT NULL

171 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;172

173 #174 # Dumping data for tabletb_pms_user175 #176

177 LOCK TABLES `tb_pms_user` WRITE;178 /*!40000 ALTER TABLE `tb_pms_user` DISABLE KEYS*/;179 /*!40000 ALTER TABLE `tb_pms_user` ENABLE KEYS*/;180 UNLOCK TABLES;181

182 #183 # Source for tabletb_pms_user_group184 #185

186 DROP TABLE IF EXISTS`tb_pms_user_group`;187 CREATE TABLE`tb_pms_user_group` (188 `F_USERID` varchar(200) NOT NULL,189 `F_GROUPID` varchar(200) NOT NULL

190 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;191

192 #193 # Dumping data for tabletb_pms_user_group194 #195

196 LOCK TABLES `tb_pms_user_group` WRITE;197 /*!40000 ALTER TABLE `tb_pms_user_group` DISABLE KEYS*/;198 /*!40000 ALTER TABLE `tb_pms_user_group` ENABLE KEYS*/;199 UNLOCK TABLES;200

201 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS*/;202 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS*/;203 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES*/;204 /*!40101 SET SQL_MODE=@OLD_SQL_MODE*/;