kku_users.sql 684 B

12345678910111213
  1. -- 表 kku_users 的创建SQL
  2. DROP TABLE IF EXISTS `kku_users`;
  3. CREATE TABLE `kku_users` (
  4. `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  5. `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  6. `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  7. `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  8. `created_at` timestamp NULL DEFAULT NULL,
  9. `updated_at` timestamp NULL DEFAULT NULL,
  10. `status2` tinyint DEFAULT '1' COMMENT '状态',
  11. PRIMARY KEY (`id`) USING BTREE
  12. ) ENGINE=InnoDB AUTO_INCREMENT=38901 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;