-- phpMyAdmin SQL Dump -- version 5.1.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost:8889 -- Waktu pembuatan: 27 Feb 2023 pada 13.40 -- Versi server: 5.7.34 -- Versi PHP: 8.0.8 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` -- -- -------------------------------------------------------- -- -- Struktur dari tabel `autoreplies` -- CREATE TABLE `autoreplies` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) 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','image','button','template','list') 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' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `blasts` -- CREATE TABLE `blasts` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `sender` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `campaign_id` bigint(20) UNSIGNED NOT NULL, `receiver` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `message` json NOT NULL, `type` enum('text','button','image','template','list') 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(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `device_id` bigint(20) UNSIGNED NOT NULL, `phonebook_id` bigint(20) UNSIGNED NOT NULL, `delay` int(11) 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(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `tag_id` bigint(20) 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(20) UNSIGNED NOT NULL, `user_id` bigint(20) 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(20) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `message_histories` -- CREATE TABLE `message_histories` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `device_id` bigint(20) UNSIGNED NOT NULL, `number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `message` varchar(255) 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; -- -------------------------------------------------------- -- -- Struktur dari tabel `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint(20) 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, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `schedules` -- CREATE TABLE `schedules` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `sender` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `numbers` json NOT NULL, `text` text COLLATE utf8mb4_unicode_ci NOT NULL, `media` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `footer` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `button1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `button2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `datetime` datetime 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 `tags` -- CREATE TABLE `tags` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) 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(20) 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(11) 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(11) 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; -- -- 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 `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`), ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`); -- -- Indeks untuk tabel `schedules` -- ALTER TABLE `schedules` ADD PRIMARY KEY (`id`), ADD KEY `schedules_user_id_foreign` (`user_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(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `blasts` -- ALTER TABLE `blasts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `campaigns` -- ALTER TABLE `campaigns` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `contacts` -- ALTER TABLE `contacts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `devices` -- ALTER TABLE `devices` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `message_histories` -- ALTER TABLE `message_histories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `schedules` -- ALTER TABLE `schedules` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `tags` -- ALTER TABLE `tags` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- 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 `schedules` -- ALTER TABLE `schedules` ADD CONSTRAINT `schedules_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 */;