Skip to content

Instantly share code, notes, and snippets.

@defrindr

defrindr/andamant_andamantau.sql

Created June 24, 2024 02:28
Show Gist options
  • Save defrindr/0236d7266f8d65ded3d674fec496d83d to your computer and use it in GitHub Desktop.
Save defrindr/0236d7266f8d65ded3d674fec496d83d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
andamant_andamantau.sql
-- Adminer 4.8.1 MySQL 8.0.33 dump
SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
SET NAMES utf8mb4;
DROP TABLE IF EXISTS `email_change_tokens`;
CREATE TABLE `email_change_tokens` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`new_email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `expenses`;
CREATE TABLE `expenses` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`id_user` bigint unsigned NOT NULL,
`id_fund_type` bigint unsigned NOT NULL,
`notes` text COLLATE utf8mb4_unicode_ci NOT NULL,
`nominal` int NOT NULL,
`date` date NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `expenses_id_user_foreign` (`id_user`),
KEY `expenses_id_fund_type_foreign` (`id_fund_type`),
CONSTRAINT `expenses_id_fund_type_foreign` FOREIGN KEY (`id_fund_type`) REFERENCES `m_fund_type` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `expenses_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `expenses` (`id`, `id_user`, `id_fund_type`, `notes`, `nominal`, `date`, `created_at`, `updated_at`) VALUES
(3, 26, 1, 'coba', 2000, '2024-06-22', '2024-06-22 00:18:58', '2024-06-22 00:19:09');
DROP TABLE IF EXISTS `failed_jobs`;
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;
DROP TABLE IF EXISTS `highlights`;
CREATE TABLE `highlights` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci NOT NULL,
`image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`image_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`image_promo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `incomes`;
CREATE TABLE `incomes` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`id_user` bigint unsigned NOT NULL,
`id_income_type` bigint unsigned NOT NULL,
`id_transaction` bigint unsigned DEFAULT NULL,
`notes` text COLLATE utf8mb4_unicode_ci NOT NULL,
`nominal` int NOT NULL,
`date` date NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `incomes_id_user_foreign` (`id_user`),
KEY `incomes_id_income_type_foreign` (`id_income_type`),
KEY `incomes_id_transaction_foreign` (`id_transaction`),
CONSTRAINT `incomes_id_income_type_foreign` FOREIGN KEY (`id_income_type`) REFERENCES `m_income_type` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `incomes_id_transaction_foreign` FOREIGN KEY (`id_transaction`) REFERENCES `transactions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `incomes_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `incomes` (`id`, `id_user`, `id_income_type`, `id_transaction`, `notes`, `nominal`, `date`, `created_at`, `updated_at`) VALUES
(1, 26, 1, NULL, 'aaaaa', 2000, '2024-06-22', '2024-06-22 00:20:21', '2024-06-22 00:20:21');
DROP TABLE IF EXISTS `m_category_news`;
CREATE TABLE `m_category_news` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `m_category_product`;
CREATE TABLE `m_category_product` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `m_category_product` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'testing', NULL, NULL),
(2, 'testing', NULL, NULL);
DROP TABLE IF EXISTS `m_fund_type`;
CREATE TABLE `m_fund_type` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `m_fund_type` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Testing', NULL, NULL);
DROP TABLE IF EXISTS `m_income_type`;
CREATE TABLE `m_income_type` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `m_income_type` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Testing', NULL, NULL);
DROP TABLE IF EXISTS `m_label_news`;
CREATE TABLE `m_label_news` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `m_payment_type`;
CREATE TABLE `m_payment_type` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `m_payment_type` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Cash Keras', NULL, NULL);
DROP TABLE IF EXISTS `m_variants`;
CREATE TABLE `m_variants` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `migrations`;
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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2013_08_09_063935_create_user_role_table', 1),
(2, '2013_08_10_081032_create_m_fund_type_table', 1),
(3, '2013_08_10_081106_create_m_income_type_table', 1),
(4, '2013_08_10_082110_create_m_category_product_table', 1),
(5, '2013_08_10_083537_create_m_payment_type_table', 1),
(6, '2013_08_10_084751_create_user_province_table', 1),
(7, '2013_08_10_084758_create_user_city_table', 1),
(8, '2014_10_12_000000_create_users_table', 1),
(9, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(10, '2014_10_12_200000_add_two_factor_columns_to_users_table', 1),
(11, '2019_08_19_000000_create_failed_jobs_table', 1),
(12, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(13, '2023_03_17_060908_add_google_id_to_users_table', 1),
(14, '2023_07_18_041800_create_products_table', 1),
(15, '2023_07_18_163421_create_sessions_table', 1),
(16, '2023_08_10_083153_create_transactions_table', 1),
(17, '2023_08_10_083902_create_transaction_item_table', 1),
(18, '2023_08_10_084410_create_expenses_table', 1),
(19, '2023_08_10_084609_create_incomes_table', 1),
(20, '2023_09_09_143759_create_m_label_news_table', 1),
(21, '2023_09_11_082633_create_m_category_news_table', 1),
(22, '2023_09_11_082745_create_news_table', 1),
(23, '2023_09_15_135150_create_highlight_table', 1),
(24, '2023_09_29_164713_m_variants', 1),
(25, '2023_10_23_225809_create_email_change_tokens_table', 1),
(26, '2023_11_06_102704_create_transaction_status_table', 1);
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`id_user` bigint unsigned NOT NULL,
`id_category_news` bigint unsigned NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`content` text COLLATE utf8mb4_unicode_ci NOT NULL,
`image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date` date NOT NULL,
`id_label` bigint unsigned NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `news_id_user_foreign` (`id_user`),
KEY `news_id_category_news_foreign` (`id_category_news`),
KEY `news_id_label_foreign` (`id_label`),
CONSTRAINT `news_id_category_news_foreign` FOREIGN KEY (`id_category_news`) REFERENCES `m_category_news` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `news_id_label_foreign` FOREIGN KEY (`id_label`) REFERENCES `m_label_news` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `news_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `password_reset_tokens`;
CREATE TABLE `password_reset_tokens` (
`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;
DROP TABLE IF EXISTS `personal_access_tokens`;
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;
INSERT INTO `personal_access_tokens` (`id`, `tokenable_type`, `tokenable_id`, `name`, `token`, `abilities`, `last_used_at`, `expires_at`, `created_at`, `updated_at`) VALUES
(1, 'App\\Models\\User', 3, 'my-app-token', '1fdeb65671a396619da918170c3020647b851b370ef629c097d13492c5242102', '[\"*\"]', NULL, NULL, '2024-06-18 06:06:36', '2024-06-18 06:06:36'),
(2, 'App\\Models\\User', 4, 'my-app-token', 'c9aa28b3db8a61aea71add8f1f426a2a213eaab6e20b176e80cbf5feeacd0d9d', '[\"*\"]', NULL, NULL, '2024-06-18 06:08:12', '2024-06-18 06:08:12'),
(3, 'App\\Models\\User', 4, 'my-app-token', '0bd02a4d94815d21d800bce523624703e0a76ebc714d13c090a875c16f5f17a4', '[\"*\"]', NULL, NULL, '2024-06-18 06:33:33', '2024-06-18 06:33:33'),
(4, 'App\\Models\\User', 4, 'my-app-token', '49d019fcd53dc747cb3e4de6912da53044e515685a41f106db6154a2c3de1092', '[\"*\"]', NULL, NULL, '2024-06-18 07:02:13', '2024-06-18 07:02:13'),
(5, 'App\\Models\\User', 4, 'my-app-token', '91d0140bdcc723e246ec274a9db5758fac1aa6216c09c63217a6e78205fc9786', '[\"*\"]', NULL, NULL, '2024-06-18 07:02:27', '2024-06-18 07:02:27'),
(6, 'App\\Models\\User', 4, 'my-app-token', '75f02b124ce30419d8ca358dac47c864f0cafbe35a0003bca6865273b40cf842', '[\"*\"]', NULL, NULL, '2024-06-18 07:03:51', '2024-06-18 07:03:51'),
(7, 'App\\Models\\User', 4, 'my-app-token', '882f323562644d50bde2ebb83786df3f4871ac9bc95aed07509039ed6909ab4e', '[\"*\"]', NULL, NULL, '2024-06-18 07:04:00', '2024-06-18 07:04:00'),
(8, 'App\\Models\\User', 4, 'my-app-token', 'b20ad2bba7a2bf6de99df471052ea050e5254e0cd5e5af408d2bbc31606aa815', '[\"*\"]', NULL, NULL, '2024-06-18 07:04:15', '2024-06-18 07:04:15'),
(9, 'App\\Models\\User', 4, 'my-app-token', 'bdc7bdc6ba7cc547cd533d7621f87c2ad3bffce7d69c08e418cd654ae9725128', '[\"*\"]', NULL, NULL, '2024-06-18 07:07:14', '2024-06-18 07:07:14'),
(10, 'App\\Models\\User', 4, 'my-app-token', 'ff2e49334887b93fbbae3d28d968c9554194f29a36c81e3c6562d66cf50ca1d3', '[\"*\"]', NULL, NULL, '2024-06-18 07:07:21', '2024-06-18 07:07:21'),
(11, 'App\\Models\\User', 4, 'my-app-token', '8d6ad02d44595e95ce683c0b5077c55d565c5971d4002b2b35c1038c9524966d', '[\"*\"]', NULL, NULL, '2024-06-18 07:07:31', '2024-06-18 07:07:31'),
(12, 'App\\Models\\User', 4, 'my-app-token', 'f66c499f8deb31de95f38064bf16c29b9d65d6a120348f1ba511c5bb635b4154', '[\"*\"]', NULL, NULL, '2024-06-18 07:08:30', '2024-06-18 07:08:30'),
(13, 'App\\Models\\User', 4, 'my-app-token', '14347ce6e775e65a356a77a6a16db446a15feb71aa0ef5ca711dbba35b0eb13e', '[\"*\"]', NULL, NULL, '2024-06-18 07:09:01', '2024-06-18 07:09:01'),
(14, 'App\\Models\\User', 4, 'my-app-token', 'bab87d0b2e53c2bc975cd0459b7c9af6524f6e0fe11fa0479bea5e43e2cc4f9d', '[\"*\"]', NULL, NULL, '2024-06-18 07:09:25', '2024-06-18 07:09:25'),
(15, 'App\\Models\\User', 4, 'my-app-token', '226318bcf45ae62f082cbfd0106f7e7ac5dc30c6019baa7b9146908921b8a9d2', '[\"*\"]', NULL, NULL, '2024-06-18 07:14:29', '2024-06-18 07:14:29'),
(16, 'App\\Models\\User', 4, 'my-app-token', 'd932d53cca81cabbf4dcf91c975bbd03998c089fc2a6d60729db53a1bc877744', '[\"*\"]', NULL, NULL, '2024-06-18 07:15:06', '2024-06-18 07:15:06'),
(17, 'App\\Models\\User', 4, 'my-app-token', 'e61d0fa1737d877fda381d7f8deaf74996fda7cf4e0c7ea600d98cc0af2e4153', '[\"*\"]', NULL, NULL, '2024-06-18 07:15:07', '2024-06-18 07:15:07'),
(18, 'App\\Models\\User', 4, 'my-app-token', 'fec4442955f131d38a97fb99bb5b6a4e964fb86123dfc928ce79b057a7501a12', '[\"*\"]', NULL, NULL, '2024-06-18 07:15:09', '2024-06-18 07:15:09'),
(19, 'App\\Models\\User', 4, 'my-app-token', 'c62cf3fc69310da1d414c7632c9ff20de93d81983634b344152ea4843432792f', '[\"*\"]', NULL, NULL, '2024-06-18 07:18:09', '2024-06-18 07:18:09'),
(20, 'App\\Models\\User', 4, 'my-app-token', '1ae237985a4677857b884b8d733eb9ab87036f1aab71de2c0848eb5d53b1958d', '[\"*\"]', NULL, NULL, '2024-06-18 07:19:22', '2024-06-18 07:19:22'),
(21, 'App\\Models\\User', 4, 'my-app-token', '5dc328b1b05764169a45b36a2163dfbcb88dc2de847cfaf274f3377661a9b9e4', '[\"*\"]', NULL, NULL, '2024-06-18 07:19:55', '2024-06-18 07:19:55'),
(22, 'App\\Models\\User', 4, 'my-app-token', 'e76d9ef1ff4cb7603b06b58269f13b55da70e2643ec2db50fc0771a3392d9763', '[\"*\"]', NULL, NULL, '2024-06-18 07:22:27', '2024-06-18 07:22:27'),
(23, 'App\\Models\\User', 4, 'my-app-token', '3bc8d1a03f83137042b1f27ded70a2f71444ce59c2a1dd2ed62f33008e4359e0', '[\"*\"]', NULL, NULL, '2024-06-18 07:22:28', '2024-06-18 07:22:28'),
(24, 'App\\Models\\User', 4, 'my-app-token', 'e6d27fa83c24b8863000d93afe335d658fca3ff7cad251df7838129bd5e2d0aa', '[\"*\"]', NULL, NULL, '2024-06-18 07:25:21', '2024-06-18 07:25:21'),
(25, 'App\\Models\\User', 4, 'my-app-token', 'a036f6ce952d66cc9725e2f078dd070bcb7862eac24f4a7c0843b058b05504f8', '[\"*\"]', NULL, NULL, '2024-06-18 07:29:36', '2024-06-18 07:29:36'),
(26, 'App\\Models\\User', 4, 'my-app-token', 'f41f6558f84be1d088d25eb600c62ebe3a158e97bce059517f488f00f043df41', '[\"*\"]', NULL, NULL, '2024-06-18 07:29:47', '2024-06-18 07:29:47'),
(27, 'App\\Models\\User', 4, 'my-app-token', '175438ed46ae6ac2896788c5985fc2ea7b24867310d89e1b1c1343f039e90415', '[\"*\"]', NULL, NULL, '2024-06-18 07:33:22', '2024-06-18 07:33:22'),
(28, 'App\\Models\\User', 4, 'my-app-token', 'e8f4e2b32d91cd887be807ffed99faf03b533cac5d811375c141287e2e2591e0', '[\"*\"]', NULL, NULL, '2024-06-18 07:33:39', '2024-06-18 07:33:39'),
(29, 'App\\Models\\User', 4, 'my-app-token', 'c666597ba215334e358353abe74c24b701fc7e769a197c8cd8910acfa8e9f354', '[\"*\"]', NULL, NULL, '2024-06-18 07:36:31', '2024-06-18 07:36:31'),
(30, 'App\\Models\\User', 4, 'my-app-token', '9b52e1280b995b493fe6c2885209ed3aad3a9dad39990d61b7d164678eabc99c', '[\"*\"]', NULL, NULL, '2024-06-18 07:41:11', '2024-06-18 07:41:11'),
(31, 'App\\Models\\User', 4, 'my-app-token', 'e6302fe4a716706d0a01b4f42a20f149877073ff4a8d369cd9b0a92d196de28a', '[\"*\"]', NULL, NULL, '2024-06-18 07:41:31', '2024-06-18 07:41:31'),
(32, 'App\\Models\\User', 4, 'my-app-token', '6b927b07007a933fd69fb28636630ae53195cbb6c1c586a780a1f768adfa68c9', '[\"*\"]', NULL, NULL, '2024-06-18 07:41:39', '2024-06-18 07:41:39'),
(33, 'App\\Models\\User', 4, 'my-app-token', '2266db6f37351dd4cb8d2ba952aa709e999ba5026c4e63501374d04323682ba3', '[\"*\"]', NULL, NULL, '2024-06-18 07:41:47', '2024-06-18 07:41:47'),
(34, 'App\\Models\\User', 4, 'my-app-token', '937cbba9d718882dc6a9eaae214da5f3590ab5447df5720fc0b58d0cca7d5023', '[\"*\"]', NULL, NULL, '2024-06-18 07:42:04', '2024-06-18 07:42:04'),
(35, 'App\\Models\\User', 4, 'my-app-token', '00dce2e0907f75aa157ca19c6ad95f945ebe4de50e392bbba2aeace39e581989', '[\"*\"]', NULL, NULL, '2024-06-18 07:42:12', '2024-06-18 07:42:12'),
(36, 'App\\Models\\User', 4, 'my-app-token', '1fd4a177765ce945345ef111092979a6fa7f40902435fad901deb32e4edaf3a8', '[\"*\"]', NULL, NULL, '2024-06-18 07:47:05', '2024-06-18 07:47:05'),
(37, 'App\\Models\\User', 4, 'my-app-token', 'bdab0f1d8e43dc90dd7147787b370b0ff28502840417c6448ee85422ee2bd9c5', '[\"*\"]', NULL, NULL, '2024-06-18 07:49:50', '2024-06-18 07:49:50'),
(38, 'App\\Models\\User', 4, 'my-app-token', 'd4518cea8e39d19c36a5f81f494debe0ab07ea0ff2cd7b03e859f2645fddaeec', '[\"*\"]', NULL, NULL, '2024-06-18 08:54:37', '2024-06-18 08:54:37'),
(39, 'App\\Models\\User', 4, 'my-app-token', 'f36ba47a025249b79671762c2a353244d1b020ac66ab693d3ca56dfd78436652', '[\"*\"]', NULL, NULL, '2024-06-18 09:40:27', '2024-06-18 09:40:27'),
(40, 'App\\Models\\User', 4, 'my-app-token', '696bf70d9ec5c5a20eb70a0ed03af77850b3a16a04b120d2d46f91f217930968', '[\"*\"]', NULL, NULL, '2024-06-19 00:02:28', '2024-06-19 00:02:28'),
(41, 'App\\Models\\User', 4, 'my-app-token', '930d9a0034fb3300705e9d381216612d75bead723f85ef49bbded91e5f4d269f', '[\"*\"]', NULL, NULL, '2024-06-19 02:45:03', '2024-06-19 02:45:03'),
(42, 'App\\Models\\User', 4, 'my-app-token', 'c21ce6eab2fdab85057f4604fa29cf22397c2cd47dc4471ebe06be91bdf1d510', '[\"*\"]', NULL, NULL, '2024-06-19 05:02:35', '2024-06-19 05:02:35'),
(43, 'App\\Models\\User', 4, 'my-app-token', 'a5ce7fa46e2946f6fad5ce77dda604a91612ccd00cf266d3ccf30d34d4d300e1', '[\"*\"]', NULL, NULL, '2024-06-19 05:02:36', '2024-06-19 05:02:36'),
(44, 'App\\Models\\User', 4, 'my-app-token', 'ae52b2fb017392179a8bdd4569a5203eebabc050fd9615e98fdbbff82ea1b710', '[\"*\"]', NULL, NULL, '2024-06-19 05:22:42', '2024-06-19 05:22:42'),
(45, 'App\\Models\\User', 25, 'my-app-token', '9696a2dcf515cb35301d248b65096063336bcddd435b55e15fe736ea0ce634f3', '[\"*\"]', NULL, NULL, '2024-06-19 05:23:46', '2024-06-19 05:23:46'),
(46, 'App\\Models\\User', 26, 'my-app-token', '927ec0114b0064a2542f55520438e06670c5d42dd5b2ed8972527eb59c3858d3', '[\"*\"]', NULL, NULL, '2024-06-21 23:59:46', '2024-06-21 23:59:46'),
(47, 'App\\Models\\User', 26, 'my-app-token', 'fa1aed21ab1082752654ea25a192cf2352142a8bf9de592297073cf206aef7f3', '[\"*\"]', NULL, NULL, '2024-06-23 04:53:59', '2024-06-23 04:53:59'),
(48, 'App\\Models\\User', 25, 'my-app-token', 'f377fee1b787cbb4a9c575ababdaaf2f1813263e04e0798e445b51eaae9ef1a1', '[\"*\"]', NULL, NULL, '2024-06-23 04:59:54', '2024-06-23 04:59:54'),
(49, 'App\\Models\\User', 26, 'my-app-token', '8b53bb1168fd0845f2e5bba6059067e4096b3ee198e1b290870a752eff3af260', '[\"*\"]', NULL, NULL, '2024-06-23 05:00:35', '2024-06-23 05:00:35'),
(50, 'App\\Models\\User', 25, 'my-app-token', '71eba04571e1ddd7c00bac50dbc32be4abf3dde685a1d3ecd0d0b7fc61158fe4', '[\"*\"]', NULL, NULL, '2024-06-23 05:01:26', '2024-06-23 05:01:26'),
(51, 'App\\Models\\User', 26, 'my-app-token', '331a4e6da5eb0e3639562bdff53d84c4aca9797ba6c485b1507adeddf016b6f8', '[\"*\"]', NULL, NULL, '2024-06-23 07:55:00', '2024-06-23 07:55:00'),
(52, 'App\\Models\\User', 3, 'my-app-token', '7d176697bcf3665f10fc53f7a0a38be7138bc175f18804576b6ef567b0ed2ab7', '[\"*\"]', NULL, NULL, '2024-06-23 07:56:04', '2024-06-23 07:56:04');
DROP TABLE IF EXISTS `products`;
CREATE TABLE `products` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`id_user` bigint unsigned NOT NULL,
`id_category_product` bigint unsigned NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci NOT NULL,
`sku` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`status` int DEFAULT NULL,
`weight` int DEFAULT NULL,
`length` int DEFAULT NULL,
`width` int DEFAULT NULL,
`height` int DEFAULT NULL,
`price` int NOT NULL,
`cost` int DEFAULT NULL,
`stock` int NOT NULL,
`image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`image_2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`image_3` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`image_4` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`image_5` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `products_id_user_foreign` (`id_user`),
KEY `products_id_category_product_foreign` (`id_category_product`),
CONSTRAINT `products_id_category_product_foreign` FOREIGN KEY (`id_category_product`) REFERENCES `m_category_product` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `products_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `products` (`id`, `id_user`, `id_category_product`, `name`, `description`, `sku`, `status`, `weight`, `length`, `width`, `height`, `price`, `cost`, `stock`, `image`, `image_2`, `image_3`, `image_4`, `image_5`, `created_at`, `updated_at`) VALUES
(19, 26, 2, 'Test', '-', 'FKR31', NULL, NULL, NULL, NULL, NULL, 10000, 8000, 10, NULL, NULL, NULL, NULL, NULL, '2024-06-23 05:01:07', '2024-06-23 05:01:07');
DROP TABLE IF EXISTS `sessions`;
CREATE TABLE `sessions` (
`id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`user_id` bigint unsigned DEFAULT NULL,
`ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_agent` text COLLATE utf8mb4_unicode_ci,
`payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`last_activity` int NOT NULL,
PRIMARY KEY (`id`),
KEY `sessions_user_id_index` (`user_id`),
KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `transaction_item`;
CREATE TABLE `transaction_item` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`id_transaction` bigint unsigned NOT NULL,
`id_product` bigint unsigned NOT NULL,
`quantity` int NOT NULL,
`current_price` int NOT NULL,
`current_modal` int NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `transaction_item_id_transaction_foreign` (`id_transaction`),
KEY `transaction_item_id_product_foreign` (`id_product`),
CONSTRAINT `transaction_item_id_product_foreign` FOREIGN KEY (`id_product`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `transaction_item_id_transaction_foreign` FOREIGN KEY (`id_transaction`) REFERENCES `transactions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `transaction_status`;
CREATE TABLE `transaction_status` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `transactions`;
CREATE TABLE `transactions` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`id_user` bigint unsigned NOT NULL,
`id_payment_type` bigint unsigned DEFAULT NULL,
`total` bigint NOT NULL,
`transaction_date` date DEFAULT NULL,
`notes` text COLLATE utf8mb4_unicode_ci NOT NULL,
`timestamp` time DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`order_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`status` int DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `transactions_id_user_foreign` (`id_user`),
KEY `transactions_id_payment_type_foreign` (`id_payment_type`),
CONSTRAINT `transactions_id_payment_type_foreign` FOREIGN KEY (`id_payment_type`) REFERENCES `m_payment_type` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `transactions_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `transactions` (`id`, `id_user`, `id_payment_type`, `total`, `transaction_date`, `notes`, `timestamp`, `created_at`, `updated_at`, `order_code`, `source`, `status`) VALUES
(1, 4, 1, 8500000, '2024-06-18', 'Nilai uang diterima: 9000000', '07:20:43', '2024-06-19 00:13:07', '2024-06-19 00:20:43', '#2024-EAY-378', '1', 1),
(2, 26, 1, 8500000, '2024-06-22', 'Nilai uang diterima: 8500000', '07:08:13', '2024-06-22 00:02:33', '2024-06-22 00:08:13', '#2024-GVX-105', '1', 1);
DROP TABLE IF EXISTS `user_city`;
CREATE TABLE `user_city` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `user_city` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, '1', NULL, NULL),
(2, '2', NULL, NULL),
(3, '3', NULL, NULL),
(4, '4', NULL, NULL);
DROP TABLE IF EXISTS `user_province`;
CREATE TABLE `user_province` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `user_province` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Jatim', NULL, NULL),
(2, 'Jateng', NULL, NULL),
(3, 'Jabar', NULL, NULL);
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`role_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `user_role` (`id`, `role_name`, `created_at`, `updated_at`) VALUES
(1, 'Admin', NULL, NULL),
(2, 'Kasir', NULL, NULL);
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`id_role` bigint unsigned NOT NULL,
`id_province` bigint unsigned NOT NULL,
`id_city` bigint unsigned 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,
`two_factor_secret` text COLLATE utf8mb4_unicode_ci,
`two_factor_recovery_codes` text COLLATE utf8mb4_unicode_ci,
`two_factor_confirmed_at` timestamp NULL DEFAULT NULL,
`owner_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`umkm_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`umkm_description` text COLLATE utf8mb4_unicode_ci,
`instagram` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`whatsapp` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`phone_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`facebook` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`umkm_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`kecamatan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`kelurahan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`kode_pos` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`pinpoint` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`umkm_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`current_team_id` bigint unsigned DEFAULT NULL,
`profile_photo_path` varchar(2048) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`google_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `users_email_unique` (`email`),
KEY `users_id_role_foreign` (`id_role`),
KEY `users_id_province_foreign` (`id_province`),
KEY `users_id_city_foreign` (`id_city`),
CONSTRAINT `users_id_city_foreign` FOREIGN KEY (`id_city`) REFERENCES `user_city` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `users_id_province_foreign` FOREIGN KEY (`id_province`) REFERENCES `user_province` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `users_id_role_foreign` FOREIGN KEY (`id_role`) REFERENCES `user_role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `users` (`id`, `id_role`, `id_province`, `id_city`, `email`, `email_verified_at`, `password`, `two_factor_secret`, `two_factor_recovery_codes`, `two_factor_confirmed_at`, `owner_name`, `umkm_name`, `umkm_description`, `instagram`, `whatsapp`, `phone_number`, `facebook`, `umkm_email`, `address`, `kecamatan`, `kelurahan`, `kode_pos`, `pinpoint`, `umkm_image`, `remember_token`, `current_team_id`, `profile_photo_path`, `created_at`, `updated_at`, `google_id`) VALUES
(3, 1, 2, 3, '[email protected]', NULL, '$2y$10$bIDY1uMuSn0IVJlv7PqTEuoL1A2qBk65ySNu9E/aMzrRm2g0.1aCW', NULL, NULL, NULL, 'fegen', 'fegen chicken', 'juicy inside crispy outside chicken', 'fegen chicken', '087033551932', '087033551932', 'fegen w', NULL, 'jalan jeruk', NULL, NULL, NULL, NULL, 'fegen.jpg', NULL, NULL, NULL, '2024-06-18 06:06:31', '2024-06-18 06:06:31', NULL),
(4, 1, 2, 3, '[email protected]', NULL, '$2y$10$7Sgy/vNEnA7QdOlTP4X/n.DMR20Zho.fDjp1Z0ABPhK4jHBRsqRX2', NULL, NULL, NULL, 'fegen', 'fegen chicken', 'juicy inside crispy outside chicken', 'fegen chicken', '087033551932', '087033551932', 'fegen w', NULL, 'jalan jeruk', NULL, NULL, NULL, NULL, 'fegen.jpg', NULL, NULL, NULL, '2024-06-18 06:06:53', '2024-06-18 06:06:53', NULL),
(24, 1, 1, 1, '[email protected]', NULL, '$2y$10$vepCtikHg5ogsFnY577CSukNnaRKwwLciS0F5BzWK5ql5O0/eLcoa', NULL, NULL, NULL, '123123', '123123', '', '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-06-19 05:18:18', '2024-06-19 05:18:18', NULL),
(25, 2, 2, 3, '[email protected]', NULL, '$2y$10$bIDY1uMuSn0IVJlv7PqTEuoL1A2qBk65ySNu9E/aMzrRm2g0.1aCW', NULL, NULL, NULL, 'Kasir 1', 'fegen chicken', 'juicy inside crispy outside chicken', 'fegen chicken', '087033551932', '087033551932', 'fegen w', NULL, 'jalan jeruk', NULL, NULL, NULL, NULL, 'fegen.jpg', NULL, NULL, NULL, '2024-06-19 05:23:26', '2024-06-19 05:23:26', NULL),
(26, 1, 1, 1, '[email protected]', NULL, '$2y$10$bIDY1uMuSn0IVJlv7PqTEuoL1A2qBk65ySNu9E/aMzrRm2g0.1aCW', NULL, NULL, NULL, 'gabriella abigail', 'JKT48', '', '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-06-21 23:59:06', '2024-06-21 23:59:06', NULL);
-- 2024-06-24 02:27:50
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment