sys_data_permission_detail.sql 690 B

123456789101112
  1. CREATE TABLE `sys_data_permission_detail` (
  2. `id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  3. `data_permission_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  4. `role_id` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  5. `rule` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  6. `create_by` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  7. `create_time` datetime NOT NULL,
  8. `last_update_by` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  9. `last_update_time` bigint NOT NULL,
  10. `del_flag` int NOT NULL,
  11. PRIMARY KEY (`id`)
  12. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;