-- MySQL dump 10.13 Distrib 8.0.44, for Linux (x86_64) -- -- Host: localhost Database: luckywheel -- ------------------------------------------------------ -- Server version 8.0.44-0ubuntu0.22.04.2 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `danh_sach_giai_thuong` -- DROP TABLE IF EXISTS `danh_sach_giai_thuong`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `danh_sach_giai_thuong` ( `ma_giai_thuong` bigint unsigned NOT NULL AUTO_INCREMENT, `noi_dung` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `hinh_anh` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `so_thu_tu` int NOT NULL DEFAULT '0', `ma_so_nhan_giai` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ten_nguoi_nhan_giai` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phan_loai_khach` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ma_so_nhan_giai_thuc_te` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ten_nguoi_nhan_giai_thuc_te` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `da_nhan_giai` tinyint NOT NULL DEFAULT '0', `thoi_gian_cho` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`ma_giai_thuong`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `danh_sach_giai_thuong` -- LOCK TABLES `danh_sach_giai_thuong` WRITE; /*!40000 ALTER TABLE `danh_sach_giai_thuong` DISABLE KEYS */; INSERT INTO `danh_sach_giai_thuong` VALUES (1,'Giải Nhất',NULL,1,'0009',NULL,NULL,NULL,NULL,1,NULL,'2026-01-07 21:11:07','2026-01-09 03:28:15'),(2,'Giải Nhì',NULL,2,NULL,NULL,NULL,'NV002','Trần Thị B',1,NULL,'2026-01-07 21:11:07','2026-01-09 02:46:45'),(3,'Giải Ba',NULL,3,NULL,NULL,'1',NULL,NULL,1,NULL,'2026-01-07 21:11:07','2026-01-09 03:27:05'),(4,'Giải Tư',NULL,4,NULL,NULL,'1',NULL,NULL,1,NULL,'2026-01-07 21:11:07','2026-01-09 03:27:16'),(5,'Giải Năm',NULL,5,'01008','01008',NULL,'01008','01008',1,NULL,'2026-01-07 21:11:07','2026-01-09 03:29:51'),(6,'Giải Sáu',NULL,6,'001','Lê Văn C',NULL,'001','Lê Văn C',1,NULL,'2026-01-07 21:11:07','2026-01-09 03:07:23'),(7,'Giải Bảy',NULL,7,NULL,NULL,NULL,'NV003','Lê Văn C',1,NULL,'2026-01-07 21:11:07','2026-01-08 18:22:03'),(8,'Giải Tám',NULL,8,NULL,NULL,NULL,'KH002','Hoàng Văn E',1,NULL,'2026-01-07 21:11:07','2026-01-08 18:21:41'),(9,'Giải Chín',NULL,9,NULL,NULL,NULL,'KH001','Phạm Thị D',1,NULL,'2026-01-07 21:11:07','2026-01-08 17:48:43'),(10,'Giải Mười',NULL,10,NULL,NULL,NULL,'NV001','Nguyễn Văn A',1,NULL,'2026-01-07 21:11:07','2026-01-08 17:47:26'),(11,'Giải 11',NULL,12,NULL,NULL,'1',NULL,NULL,1,NULL,'2026-01-09 03:24:38','2026-01-09 03:26:07'); /*!40000 ALTER TABLE `danh_sach_giai_thuong` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `danh_sach_nguoi_dung` -- DROP TABLE IF EXISTS `danh_sach_nguoi_dung`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `danh_sach_nguoi_dung` ( `id_nguoi_dung` bigint unsigned NOT NULL AUTO_INCREMENT, `ma_nguoi_dung` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `ten_nguoi_dung` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `loai_nguoi_dung` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id_nguoi_dung`), UNIQUE KEY `danh_sach_nguoi_dung_ma_nguoi_dung_unique` (`ma_nguoi_dung`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `danh_sach_nguoi_dung` -- LOCK TABLES `danh_sach_nguoi_dung` WRITE; /*!40000 ALTER TABLE `danh_sach_nguoi_dung` DISABLE KEYS */; INSERT INTO `danh_sach_nguoi_dung` VALUES (1,'NV001','Nguyễn Văn A','Nhân viên','2026-01-08 04:11:33','2026-01-08 04:11:33'),(2,'NV002','Trần Thị B','Nhân viên','2026-01-08 04:11:33','2026-01-08 04:11:33'),(3,'NV003','Lê Văn C','Nhân viên','2026-01-08 04:11:33','2026-01-08 04:11:33'),(4,'KH001','Phạm Thị D','Khách hàng','2026-01-08 04:11:33','2026-01-08 04:11:33'),(5,'KH002','Hoàng Văn E','Khách hàng','2026-01-08 04:11:33','2026-01-08 04:11:33'); /*!40000 ALTER TABLE `danh_sach_nguoi_dung` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `failed_jobs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `failed_jobs` -- LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `migrations` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2019_08_19_000000_create_failed_jobs_table',1),(4,'2019_12_14_000001_create_personal_access_tokens_table',1),(5,'2024_12_11_040120_create_notifications_table',1),(6,'2026_01_08_040853_create_danh_sach_giai_thuong_table',2),(7,'2026_01_08_040907_create_danh_sach_nguoi_dung_table',2); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `notifications` -- DROP TABLE IF EXISTS `notifications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `notifications` ( `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `notifiable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `notifiable_id` bigint unsigned NOT NULL, `data` text COLLATE utf8mb4_unicode_ci NOT NULL, `read_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `notifications` -- LOCK TABLES `notifications` WRITE; /*!40000 ALTER TABLE `notifications` DISABLE KEYS */; /*!40000 ALTER TABLE `notifications` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_resets` -- DROP TABLE IF EXISTS `password_resets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `password_resets` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_resets` -- LOCK TABLES `password_resets` WRITE; /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */; /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `personal_access_tokens` -- DROP TABLE IF EXISTS `personal_access_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `personal_access_tokens` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci, `last_used_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `personal_access_tokens_token_unique` (`token`), KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `personal_access_tokens` -- LOCK TABLES `personal_access_tokens` WRITE; /*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `users` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'Admin','admin@luckywheel.com',NULL,'$2y$10$i7VBicpsTi4wLs8y/po6eO4BJyJzqCVYZE26vfzkmC.rm/SxqWXxq',NULL,'2026-01-07 21:11:44','2026-01-07 21:11:44'); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-01-11 9:02:56