首页 > 编程学习 > Python 伪造数据的sql脚本

Python 伪造数据的sql脚本

发布时间:2022/9/15 15:44:40
-- ----------------------------
-- 角色管理 初始化
-- Table structure for permission_role
-- ----------------------------
-- DROP TABLE IF EXISTS `permission_role`;
-- CREATE TABLE `permission_role` (
--   `id` int(11) NOT NULL AUTO_INCREMENT,
--   `description` longtext,
--   `creator` varchar(255) DEFAULT NULL,
--   `modifier` varchar(255) DEFAULT NULL,
--   `update_datetime` datetime(6) DEFAULT NULL,
--   `create_datetime` datetime(6) DEFAULT NULL,
--   `roleName` varchar(64) NOT NULL,
--   `roleKey` varchar(64) NOT NULL,
--   `roleSort` int(11) NOT NULL,
--   `status` varchar(8) NOT NULL,
--   `admin` tinyint(1) NOT NULL,
--   `dataScope` varchar(8) NOT NULL,
--   `remark` longtext,
--   PRIMARY KEY (`id`)
-- ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of permission_role
-- ----------------------------
INSERT INTO `permission_role` (id, description, modifier, update_datetime, create_datetime, roleName, roleKey, roleSort, status, admin, dataScope, remark, creator_id, dept_belong_id) VALUES (1, '', 'admin', '2021-02-27 08:48:23.225361', '2021-02-27 08:48:08.064911', '超级管理员', 'admin', 1, '1', 1, '2', NULL, 1, 1);
INSERT INTO `permission_role` (id, description, modifier, update_datetime, create_datetime, roleName, roleKey, roleSort, status, admin, dataScope, remark, creator_id, dept_belong_id) VALUES (2, '', 'admin', '2021-02-27 08:49:05.149632', '2021-02-27 08:48:47.317214', '普通角色', 'common', 2, '1', 0, '2', NULL, 1, 1);

-- ----------------------------
-- Table structure for permission_role_dept
-- ----------------------------
-- DROP TABLE IF EXISTS `permission_role_dept`;
-- CREATE TABLE `permission_role_dept` (
--   `id` int(11) NOT NULL AUTO_INCREMENT,
--   `role_id` int(11) NOT NULL,
--   `dept_id` int(11) NOT NULL,
--   PRIMARY KEY (`id`),
--   UNIQUE KEY `permission_role_dept_role_id_dept_id_1d89afeb_uniq` (`role_id`,`dept_id`),
--   KEY `permission_role_dept_role_id_99a9f232` (`role_id`) USING BTREE,
--   KEY `permission_role_dept_dept_id_cbe9076a` (`dept_id`) USING BTREE
-- ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of permission_role_dept
-- ----------------------------
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (1, 1, 1);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (2, 1, 2);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (3, 1, 3);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (4, 1, 4);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (5, 1, 5);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (6, 1, 6);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (7, 1, 7);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (8, 1, 8);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (9, 1, 9);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (10, 1, 10);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (11, 1, 11);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (12, 1, 12);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (13, 1, 13);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (14, 1, 14);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (15, 1, 15);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (16, 1, 16);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (17, 2, 1);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (18, 2, 2);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (19, 2, 3);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (20, 2, 4);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (21, 2, 5);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (22, 2, 6);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (23, 2, 7);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (24, 2, 8);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (25, 2, 9);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (26, 2, 10);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (27, 2, 11);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (28, 2, 12);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (29, 2, 13);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (30, 2, 14);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (31, 2, 15);
INSERT INTO `permission_role_dept` (id, role_id, dept_id) VALUES (32, 2, 16);

-- ----------------------------
-- Table structure for permission_role_menu
-- ----------------------------
-- DROP TABLE IF EXISTS `permission_role_menu`;
-- CREATE TABLE `permission_role_menu` (
--   `id` int(11) NOT NULL AUTO_INCREMENT,
--   `role_id` int(11) NOT NULL,
--   `menu_id` int(11) NOT NULL,
--   PRIMARY KEY (`id`),
--   UNIQUE KEY `permission_role_menu_role_id_menu_id_bb9e5441_uniq` (`role_id`,`menu_id`),
--   KEY `permission_role_menu_role_id_33541d2b` (`role_id`) USING BTREE,
--   KEY `permission_role_menu_menu_id_0c24555f` (`menu_id`) USING BTREE
-- ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of permission_role_menu
-- ----------------------------
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (1, 1, 1);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (2, 1, 2);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (3, 1, 3);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (4, 1, 4);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (5, 1, 5);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (6, 1, 6);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (7, 1, 7);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (8, 1, 8);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (9, 1, 9);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (10, 1, 10);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (11, 2, 1);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (12, 2, 2);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (13, 2, 3);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (14, 2, 4);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (15, 2, 5);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (16, 2, 6);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (17, 2, 7);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (18, 2, 8);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (19, 2, 9);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (20, 2, 10);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (21, 1, 11);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (22, 1, 13);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (23, 1, 14);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (24, 1, 15);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (25, 1, 16);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (26, 1, 17);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (27, 1, 18);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (28, 1, 19);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (29, 1, 20);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (30, 1, 21);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (31, 1, 22);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (32, 1, 23);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (33, 1, 24);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (34, 1, 25);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (35, 1, 26);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (36, 1, 27);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (37, 1, 28);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (38, 1, 29);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (39, 1, 30);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (40, 1, 31);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (41, 1, 32);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (42, 1, 33);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (43, 1, 34);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (44, 1, 35);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (45, 1, 36);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (46, 1, 37);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (47, 1, 38);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (48, 1, 39);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (49, 1, 40);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (50, 1, 41);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (51, 1, 42);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (52, 1, 43);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (53, 1, 44);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (54, 1, 45);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (55, 1, 46);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (56, 1, 47);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (57, 1, 48);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (58, 1, 49);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (59, 1, 50);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (60, 1, 51);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (61, 1, 52);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (62, 1, 53);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (63, 1, 54);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (64, 1, 55);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (65, 1, 56);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (66, 1, 57);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (67, 1, 58);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (68, 1, 59);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (69, 1, 60);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (74, 1, 61);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (75, 1, 62);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (76, 1, 63);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (70, 1, 64);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (71, 1, 65);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (79, 1, 66);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (80, 1, 70);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (81, 1, 71);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (82, 1, 72);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (83, 1, 73);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (84, 1, 74);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (85, 1, 75);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (86, 1, 76);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (72, 1, 77);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (73, 1, 78);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (92, 1, 79);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (93, 1, 80);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (94, 1, 81);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (88, 1, 82);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (89, 1, 83);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (77, 1, 85);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (78, 1, 86);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (95, 1, 87);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (96, 1, 88);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (97, 1, 90);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (98, 1, 91);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (99, 2, 97);
INSERT INTO `permission_role_menu` (id, role_id, menu_id) VALUES (100, 1, 97);

 

Copyright © 2010-2022 mfbz.cn 版权所有 |关于我们| 联系方式|豫ICP备15888888号