权限管理系统 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: pms 14 # ------------------------------------------------------ 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 table tb_pms_area 23 # 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 table tb_pms_area 36 # 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 table tb_pms_group 45 # 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 table tb_pms_group 58 # 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 table tb_pms_group_role 67 # 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 table tb_pms_group_role 77 # 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 table tb_pms_module 86 # 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 table tb_pms_module 102 # 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 table tb_pms_role 111 # 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 table tb_pms_role 124 # 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 table tb_pms_role_module 133 # 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 table tb_pms_role_module 143 # 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 table tb_pms_user 152 # 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 table tb_pms_user 175 # 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 table tb_pms_user_group 184 # 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 table tb_pms_user_group 194 # 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 */;
智者,寡言而多行