sys_role_data_permission.sql 620 B

1234567891011
  1. CREATE TABLE `sys_role_data_permission` (
  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` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  5. `create_by` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  6. `create_time` datetime NOT NULL,
  7. `last_update_by` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  8. `last_update_time` bigint NOT NULL,
  9. `del_flag` int NOT NULL,
  10. PRIMARY KEY (`id`)
  11. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;