users.sql 937 B

1234567891011121314151617
  1. -- ******************************************************************
  2. -- 表 kku_users 的创建SQL
  3. -- 对应的Model: App\Module\User\Models\User
  4. -- 警告: 此文件由系统自动生成,禁止手动修改!
  5. -- ******************************************************************
  6. DROP TABLE IF EXISTS `kku_users`;
  7. CREATE TABLE `kku_users` (
  8. `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  9. `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  10. `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  11. `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  12. `created_at` timestamp NULL DEFAULT NULL,
  13. `updated_at` timestamp NULL DEFAULT NULL,
  14. `status2` tinyint DEFAULT '1' COMMENT '状态',
  15. PRIMARY KEY (`id`) USING BTREE
  16. ) ENGINE=InnoDB AUTO_INCREMENT=38901 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;