admin_grid_views.sql 1.1 KB

123456789101112131415161718
  1. -- ******************************************************************
  2. -- 表 kku_admin_grid_views 的创建SQL
  3. -- 对应的Model: App\Module\System\Models\AdminGridView
  4. -- 警告: 此文件由系统自动生成,禁止手动修改!
  5. -- ******************************************************************
  6. DROP TABLE IF EXISTS `kku_admin_grid_views`;
  7. CREATE TABLE `kku_admin_grid_views` (
  8. `id` int NOT NULL AUTO_INCREMENT,
  9. `admin_id` int NOT NULL COMMENT '操作的Admin ID',
  10. `type1` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  11. `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '视图标题',
  12. `router_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '路由名字',
  13. `p1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '参数1',
  14. `updated_at` datetime NOT NULL COMMENT '更新 时间戳',
  15. `created_at` datetime NOT NULL COMMENT '创建 时间戳',
  16. PRIMARY KEY (`id`) USING BTREE
  17. ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='后台 - 表格视图';