-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Waktu pembuatan: 13 Nov 2024 pada 13.07 -- Versi server: 8.3.0 -- Versi PHP: 8.1.29 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!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 */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `wamd_2` -- -- -------------------------------------------------------- -- -- Struktur dari tabel `autoreplies` -- CREATE TABLE `autoreplies` ( `id` bigint UNSIGNED NOT NULL, `user_id` bigint UNSIGNED NOT NULL, `device_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `keyword` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `type_keyword` enum('Equal','Contain') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Equal', `type` enum('text','button','image','template','list','media','vcard','location','sticker') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `reply` json NOT NULL, `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `reply_when` enum('Group','Personal','All') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'All', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `is_quoted` tinyint(1) NOT NULL DEFAULT '0', `is_read` tinyint(1) DEFAULT '0', `is_typing` tinyint(1) DEFAULT '0', `delay` int DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `blasts` -- CREATE TABLE `blasts` ( `id` bigint UNSIGNED NOT NULL, `user_id` bigint UNSIGNED NOT NULL, `sender` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `campaign_id` bigint UNSIGNED NOT NULL, `receiver` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `message` json NOT NULL, `type` enum('text','button','image','template','list','media','vcard','location','sticker') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `status` enum('failed','success','pending') COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `campaigns` -- CREATE TABLE `campaigns` ( `id` bigint UNSIGNED NOT NULL, `user_id` bigint UNSIGNED NOT NULL, `device_id` bigint UNSIGNED NOT NULL, `phonebook_id` bigint UNSIGNED NOT NULL, `delay` int NOT NULL DEFAULT '10', `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `status` enum('waiting','processing','failed','completed','paused') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'waiting', `message` json NOT NULL, `schedule` datetime DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `contacts` -- CREATE TABLE `contacts` ( `id` bigint UNSIGNED NOT NULL, `user_id` bigint UNSIGNED NOT NULL, `tag_id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `devices` -- CREATE TABLE `devices` ( `id` bigint UNSIGNED NOT NULL, `user_id` bigint UNSIGNED NOT NULL, `body` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `webhook` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` enum('Connected','Disconnect') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Disconnect', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `message_sent` bigint NOT NULL DEFAULT '0', `wh_read` tinyint(1) DEFAULT '0', `wh_typing` tinyint(1) DEFAULT '0', `delay` int DEFAULT '0', `set_available` tinyint(1) DEFAULT '1', `gptkey` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `geminikey` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reject_call` tinyint(1) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data untuk tabel `devices` -- -- -------------------------------------------------------- -- -- Struktur dari tabel `message_histories` -- CREATE TABLE `message_histories` ( `id` bigint UNSIGNED NOT NULL, `user_id` bigint UNSIGNED NOT NULL, `device_id` bigint UNSIGNED NOT NULL, `number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `message` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` json NOT NULL, `status` enum('success','failed') COLLATE utf8mb4_unicode_ci NOT NULL, `send_by` enum('api','web') COLLATE utf8mb4_unicode_ci NOT NULL, `note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data untuk tabel `message_histories` -- -- -------------------------------------------------------- -- -- Struktur dari tabel `migrations` -- CREATE TABLE `migrations` ( `id` int UNSIGNED NOT NULL, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data untuk tabel `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2014_10_12_000000_create_users_table', 1), (2, '2022_02_15_090711_create_numbers_table', 1), (3, '2022_02_18_125542_create_autoreplies_table', 1), (4, '2022_02_18_142742_create_tags_table', 1), (5, '2022_02_19_142504_create_contacts_table', 1), (6, '2022_07_23_163942_create_campaigns_table', 1), (7, '2022_07_23_172710_create_blasts_table', 1), (8, '2022_10_16_194044_add_column_to_autoreplies_table', 1), (9, '2023_02_22_135833_add_status_column_to_autoreplies_table', 1), (10, '2023_02_26_090658_add_is_quoted_column_to_autoreplies_table', 1), (11, '2023_02_27_102221_create_message_histories_table', 1), (12, '2023_02_27_112543_add_message_sent_column_to_device_table', 1); -- -------------------------------------------------------- -- -- Struktur dari tabel `tags` -- CREATE TABLE `tags` ( `id` bigint UNSIGNED NOT NULL, `user_id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `users` -- CREATE TABLE `users` ( `id` bigint UNSIGNED NOT NULL, `username` 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, `api_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `chunk_blast` int NOT NULL, `level` enum('admin','user') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'user', `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `limit_device` int NOT NULL DEFAULT '0', `active_subscription` enum('inactive','active','lifetime','trial') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive', `subscription_expired` datetime DEFAULT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data untuk tabel `users` -- -- -- Indexes for dumped tables -- -- -- Indeks untuk tabel `autoreplies` -- ALTER TABLE `autoreplies` ADD PRIMARY KEY (`id`), ADD KEY `autoreplies_user_id_foreign` (`user_id`); -- -- Indeks untuk tabel `blasts` -- ALTER TABLE `blasts` ADD PRIMARY KEY (`id`), ADD KEY `blasts_user_id_foreign` (`user_id`), ADD KEY `blasts_campaign_id_foreign` (`campaign_id`); -- -- Indeks untuk tabel `campaigns` -- ALTER TABLE `campaigns` ADD PRIMARY KEY (`id`), ADD KEY `campaigns_user_id_foreign` (`user_id`), ADD KEY `campaigns_device_id_foreign` (`device_id`), ADD KEY `campaigns_phonebook_id_foreign` (`phonebook_id`); -- -- Indeks untuk tabel `contacts` -- ALTER TABLE `contacts` ADD PRIMARY KEY (`id`), ADD KEY `contacts_tag_id_foreign` (`tag_id`); -- -- Indeks untuk tabel `devices` -- ALTER TABLE `devices` ADD PRIMARY KEY (`id`), ADD KEY `devices_user_id_foreign` (`user_id`); -- -- Indeks untuk tabel `message_histories` -- ALTER TABLE `message_histories` ADD PRIMARY KEY (`id`), ADD KEY `message_histories_user_id_foreign` (`user_id`), ADD KEY `message_histories_device_id_foreign` (`device_id`); -- -- Indeks untuk tabel `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `tags` -- ALTER TABLE `tags` ADD PRIMARY KEY (`id`), ADD KEY `tags_user_id_foreign` (`user_id`); -- -- Indeks untuk tabel `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- AUTO_INCREMENT untuk tabel yang dibuang -- -- -- AUTO_INCREMENT untuk tabel `autoreplies` -- ALTER TABLE `autoreplies` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT untuk tabel `blasts` -- ALTER TABLE `blasts` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `campaigns` -- ALTER TABLE `campaigns` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `contacts` -- ALTER TABLE `contacts` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `devices` -- ALTER TABLE `devices` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT untuk tabel `message_histories` -- ALTER TABLE `message_histories` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT untuk tabel `migrations` -- ALTER TABLE `migrations` MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT untuk tabel `tags` -- ALTER TABLE `tags` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `users` -- ALTER TABLE `users` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables) -- -- -- Ketidakleluasaan untuk tabel `autoreplies` -- ALTER TABLE `autoreplies` ADD CONSTRAINT `autoreplies_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Ketidakleluasaan untuk tabel `blasts` -- ALTER TABLE `blasts` ADD CONSTRAINT `blasts_campaign_id_foreign` FOREIGN KEY (`campaign_id`) REFERENCES `campaigns` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `blasts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Ketidakleluasaan untuk tabel `campaigns` -- ALTER TABLE `campaigns` ADD CONSTRAINT `campaigns_device_id_foreign` FOREIGN KEY (`device_id`) REFERENCES `devices` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `campaigns_phonebook_id_foreign` FOREIGN KEY (`phonebook_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `campaigns_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Ketidakleluasaan untuk tabel `contacts` -- ALTER TABLE `contacts` ADD CONSTRAINT `contacts_tag_id_foreign` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE; -- -- Ketidakleluasaan untuk tabel `devices` -- ALTER TABLE `devices` ADD CONSTRAINT `devices_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Ketidakleluasaan untuk tabel `message_histories` -- ALTER TABLE `message_histories` ADD CONSTRAINT `message_histories_device_id_foreign` FOREIGN KEY (`device_id`) REFERENCES `devices` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `message_histories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Ketidakleluasaan untuk tabel `tags` -- ALTER TABLE `tags` ADD CONSTRAINT `tags_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; COMMIT; /*!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 */;