-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Mar 22, 2026 at 08:52 PM -- Server version: 10.4.32-MariaDB -- PHP Version: 8.2.12 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: `inventory_apriori` -- -- -------------------------------------------------------- -- -- Table structure for table `cache` -- CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cache_locks` -- CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `detail_transaksi` -- CREATE TABLE `detail_transaksi` ( `id` bigint(20) UNSIGNED NOT NULL, `transaksi_id` bigint(20) UNSIGNED NOT NULL, `produk_id` bigint(20) UNSIGNED NOT NULL, `jumlah` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) NOT NULL, `connection` text NOT NULL, `queue` text NOT NULL, `payload` longtext NOT NULL, `exception` longtext NOT NULL, `failed_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `jobs` -- CREATE TABLE `jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `queue` varchar(255) NOT NULL, `payload` longtext NOT NULL, `attempts` tinyint(3) UNSIGNED NOT NULL, `reserved_at` int(10) UNSIGNED DEFAULT NULL, `available_at` int(10) UNSIGNED NOT NULL, `created_at` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `job_batches` -- CREATE TABLE `job_batches` ( `id` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `total_jobs` int(11) NOT NULL, `pending_jobs` int(11) NOT NULL, `failed_jobs` int(11) NOT NULL, `failed_job_ids` longtext NOT NULL, `options` mediumtext DEFAULT NULL, `cancelled_at` int(11) DEFAULT NULL, `created_at` int(11) NOT NULL, `finished_at` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '0001_01_01_000000_create_users_table', 1), (2, '0001_01_01_000001_create_cache_table', 1), (3, '0001_01_01_000002_create_jobs_table', 1), (4, '2026_03_06_091338_create_produk_table', 1), (5, '2026_03_06_091407_create_transaksi_table', 1), (6, '2026_03_06_091432_create_detail_transaksi_table', 1), (7, '2026_03_06_091922_create_transaksi_hasil_apriori', 2), (8, '2026_03_06_115840_add_produk_to_transaksi_table', 3), (9, '2026_03_06_132322_add_trx_id_to_transaksi_table', 4), (10, '2026_03_17_164839_add_username_to_users_table', 5); -- -------------------------------------------------------- -- -- Table structure for table `password_reset_tokens` -- CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `produk` -- CREATE TABLE `produk` ( `id` bigint(20) UNSIGNED NOT NULL, `nama_produk` varchar(255) NOT NULL, `kategori` varchar(255) NOT NULL, `harga` int(11) NOT NULL, `stok` int(11) NOT NULL, `expired_at` date 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 for table `produk` -- INSERT INTO `produk` (`id`, `nama_produk`, `kategori`, `harga`, `stok`, `expired_at`, `created_at`, `updated_at`) VALUES (1, 'Karung 25kg', 'Karung', 2500, 5, NULL, '2026-03-06 02:59:16', '2026-03-20 21:47:39'), (2, 'Indomie Goreng', 'Makanan', 2500, 25, '2026-03-31', '2026-03-06 03:04:26', '2026-03-22 12:38:18'), (3, 'Teh Gelas', 'Minuman', 2000, 35, '2026-03-19', '2026-03-06 04:48:20', '2026-03-06 10:04:28'), (4, 'Kopi Robusta 500gr', 'Kopi', 85000, 20, '2027-03-06', '2026-03-06 04:50:07', '2026-03-22 09:48:29'), (7, '[Sachet] Susu Dancow Coklat', 'Minuman', 2500, 35, '2027-08-21', '2026-03-20 20:53:36', '2026-03-20 20:55:09'), (8, '[Sachet] Susu Dancow Vanilla', 'Minuman', 2500, 50, '2026-03-28', '2026-03-20 20:54:07', '2026-03-22 12:39:03'), (9, '[Sachet] Nutrisari Jeruk Peras', 'Minuman', 2000, 50, '2027-06-21', '2026-03-20 20:54:46', '2026-03-20 20:55:35'), (10, 'Aqua Botol Kecil 330ml', 'Minuman', 3000, 75, '2026-04-16', '2026-03-20 20:58:10', '2026-03-22 12:40:15'), (11, 'Aqua Botol Sedang 600ml', 'Minuman', 5000, 100, '2028-10-03', '2026-03-20 20:58:48', '2026-03-20 20:58:48'), (12, 'Aqua Botol Besar 1L', 'Minuman', 8000, 35, '2029-03-21', '2026-03-20 20:59:20', '2026-03-20 20:59:20'), (13, 'Le Minerale Kecil 330ml', 'Minuman', 3000, 40, '2028-06-21', '2026-03-20 21:01:14', '2026-03-20 21:01:14'), (14, 'Le Minerale Sedang 600ml', 'Minuman', 5000, 45, '2028-06-21', '2026-03-20 21:01:45', '2026-03-20 21:01:45'), (15, 'Le Minerale Besar 1L', 'Minuman', 10000, 34, '2029-03-07', '2026-03-20 21:02:45', '2026-03-20 21:02:45'), (16, 'Mie Eko', 'Makanan', 13000, 12, '2027-07-30', '2026-03-20 21:03:31', '2026-03-20 21:03:31'), (17, 'Sarimi', 'Makanan', 2500, 40, '2029-07-23', '2026-03-20 21:09:50', '2026-03-20 21:09:50'), (18, 'Indomie', 'Makanan', 2500, 25, '2029-10-16', '2026-03-20 21:10:19', '2026-03-20 21:10:19'), (19, 'Minyak Kita 1L', 'Sembako', 19000, 24, '2029-06-06', '2026-03-20 21:13:50', '2026-03-20 21:13:50'), (20, 'Minyak Fortune 500ml', 'Sembako', 13000, 21, '2029-07-31', '2026-03-20 21:16:42', '2026-03-21 05:11:06'), (21, 'Mila Tepung Terigu 1kg', 'Sembako', 12000, 24, '2029-06-21', '2026-03-20 21:17:16', '2026-03-20 21:17:16'), (22, '[Sachet] Shampoo Sunsilk', 'Kebersihan & Perawatan', 1000, 60, '2028-02-09', '2026-03-20 21:18:36', '2026-03-20 21:18:36'), (23, '[Sachet] Shampoo Clear', 'Kebersihan & Perawatan', 1000, 30, '2028-06-05', '2026-03-20 21:20:01', '2026-03-20 21:20:01'), (24, '[Sachet] Shampoo Lifebuoy', 'Kebersihan & Perawatan', 1000, 26, '2029-05-29', '2026-03-20 21:20:41', '2026-03-20 21:20:41'), (25, '[Sachet] Deterjen Downy', 'Kebersihan & Perawatan', 2500, 45, '2028-10-26', '2026-03-20 21:21:44', '2026-03-20 21:21:44'), (26, '[Sachet] Deterjen Rinso', 'Kebersihan & Perawatan', 2500, 39, '2029-06-25', '2026-03-20 21:22:23', '2026-03-20 21:22:23'), (27, 'Tisu Jolie', 'Kebersihan & Perawatan', 10000, 24, NULL, '2026-03-20 21:23:05', '2026-03-20 21:23:05'), (29, 'Ayudes', 'Karton', 3000, 112, NULL, '2026-03-20 23:45:44', '2026-03-20 23:45:44'), (30, 'SGM', 'Karton', 7000, 50, NULL, '2026-03-20 23:46:03', '2026-03-20 23:46:03'), (31, 'Fortune', 'Karton', 7000, 25, NULL, '2026-03-20 23:46:22', '2026-03-20 23:46:22'), (32, 'Bimoli', 'Karton', 8000, 15, NULL, '2026-03-21 04:00:35', '2026-03-21 04:00:35'), (33, 'Mamypoko', 'Karton', 8000, 38, NULL, '2026-03-21 04:01:10', '2026-03-21 04:01:10'), (34, 'Amor', 'Karton', 10000, 21, NULL, '2026-03-21 04:01:31', '2026-03-21 04:01:31'), (35, 'Dji Sam Soe Hitam', 'Karton', 12000, 26, NULL, '2026-03-21 04:02:17', '2026-03-21 04:02:17'), (36, 'Indoceria', 'Karton', 15000, 49, NULL, '2026-03-21 04:02:44', '2026-03-21 04:02:44'), (37, 'GG Merah', 'Karton', 15000, 34, NULL, '2026-03-21 04:03:06', '2026-03-21 04:03:06'), (38, 'GG 12', 'Karton', 20000, 57, NULL, '2026-03-21 04:03:28', '2026-03-21 04:03:28'), (39, 'GG 16', 'Karton', 20000, 45, NULL, '2026-03-21 04:03:43', '2026-03-21 04:03:43'), (40, 'GG Kaleng', 'Karton', 25000, 65, NULL, '2026-03-21 04:04:03', '2026-03-21 04:04:03'), (41, 'GG Putih International', 'Karton', 15000, 48, NULL, '2026-03-21 04:04:44', '2026-03-21 04:04:44'), (42, 'Marlboro', 'Karton', 8000, 24, NULL, '2026-03-21 04:05:01', '2026-03-21 04:05:01'), (43, 'GG Merah Lebar', 'Karton', 20000, 36, NULL, '2026-03-21 04:05:22', '2026-03-21 04:05:22'), (44, '[Pack] Gelas Pop Ice 12\" 14\" 16\"', 'Perlengkapan', 16500, 5, NULL, '2026-03-21 04:08:56', '2026-03-21 04:08:56'), (45, '[Pack] Gelas Kecil', 'Perlengkapan', 10000, 10, NULL, '2026-03-21 04:09:25', '2026-03-21 04:09:25'), (46, '[Pack] Gelas Agar-agar', 'Perlengkapan', 15000, 7, NULL, '2026-03-21 04:10:00', '2026-03-21 04:10:00'), (47, '[Pack] Sedotan Pop Ice', 'Perlengkapan', 25000, 10, NULL, '2026-03-21 04:10:45', '2026-03-21 04:10:45'), (48, '[Pack] Sedotan Biasa Warna', 'Perlengkapan', 4000, 20, NULL, '2026-03-21 04:11:19', '2026-03-21 04:11:19'), (49, '[Bungkus] Kopi Kapal Api 30gr', 'Minuman', 6000, 37, '2027-03-17', '2026-03-21 04:58:09', '2026-03-21 05:01:27'), (50, '[Bungkus] Kopi Kapal Api 60gr', 'Minuman', 12000, 23, '2027-05-18', '2026-03-21 04:58:38', '2026-03-21 05:01:11'), (51, '[Bungkus] Goodday Cappucino', 'Minuman', 3000, 25, '2029-06-07', '2026-03-21 05:00:56', '2026-03-21 05:00:56'), (52, '[Bungkus] Luwak White Kopi', 'Minuman', 2000, 34, '2028-07-06', '2026-03-21 05:02:15', '2026-03-21 05:02:15'), (53, '[Bungkus] Tembakau Kecil', 'Tembakau', 11000, 26, NULL, '2026-03-21 05:05:32', '2026-03-21 05:05:32'), (54, '[Bungkus] Tembakau Besar', 'Tembakau', 22000, 34, NULL, '2026-03-21 05:06:11', '2026-03-21 05:06:11'), (55, '[Bungkus] Gula Pasir 1kg', 'Sembako', 20000, 12, '2028-07-18', '2026-03-21 05:08:36', '2026-03-21 05:08:36'), (56, 'Gulaku Gula Pasir 1kg', 'Sembako', 22000, 23, '2029-11-15', '2026-03-21 05:09:03', '2026-03-21 05:09:03'), (57, 'Minyak Bimoli 1L', 'Sembako', 22000, 23, '2028-06-06', '2026-03-21 05:10:27', '2026-03-21 05:10:27'), (58, '[Karton] Aqua Sedang', 'Minuman', 65000, 50, '2028-07-07', '2026-03-21 05:11:56', '2026-03-21 05:11:56'), (59, '[Karton] Aqua Besar', 'Minuman', 75000, 23, '2029-11-07', '2026-03-21 05:12:24', '2026-03-21 05:12:24'), (60, '[Karton] Ayudes', 'Minuman', 24000, 41, '2029-10-09', '2026-03-21 05:12:57', '2026-03-21 05:12:57'), (61, '[Bungkus] Plastik Tipis Kecil', 'Perlengkapan', 2000, 15, NULL, '2026-03-22 09:51:20', '2026-03-22 09:51:20'), (62, '[Bungkus] Plastik Putih 1kg', 'Perlengkapan', 4000, 15, NULL, '2026-03-22 09:51:44', '2026-03-22 09:51:44'), (63, '[Bungkus] Plastik Garis', 'Perlengkapan', 6000, 25, NULL, '2026-03-22 09:52:09', '2026-03-22 09:52:09'), (64, '[Bungkus] Plastik Hitam Tipis', 'Perlengkapan', 7000, 23, NULL, '2026-03-22 09:52:27', '2026-03-22 09:52:27'), (65, '[Bungkus] Plastik Hitam/Merah', 'Perlengkapan', 18000, 13, NULL, '2026-03-22 09:53:27', '2026-03-22 09:53:27'), (66, '[Pack] Sendok Makan', 'Perlengkapan', 15000, 6, NULL, '2026-03-22 09:54:43', '2026-03-22 09:54:43'), (67, '[Pack] Sendok Bebek', 'Perlengkapan', 12000, 13, NULL, '2026-03-22 09:55:37', '2026-03-22 09:55:37'), (68, '[Pack] Kertas Tembakau', 'Perlengkapan', 50000, 3, NULL, '2026-03-22 09:56:50', '2026-03-22 09:56:50'), (69, '[Pack] Amor', 'Tembakau', 160000, 12, NULL, '2026-03-22 09:58:10', '2026-03-22 09:58:10'), (70, '[Bungkus] Amor', 'Tembakau', 9000, 35, NULL, '2026-03-22 09:58:30', '2026-03-22 09:58:30'), (71, '[Pack] Tembakau Kuning', 'Tembakau', 110000, 29, NULL, '2026-03-22 09:59:04', '2026-03-22 09:59:04'), (72, 'Tali Rafia 1Kg', 'Tali Rafia', 30000, 15, NULL, '2026-03-22 10:00:31', '2026-03-22 10:00:31'), (73, 'Tali Rafia 1/2 Kg', 'Tali Rafia', 20000, 13, NULL, '2026-03-22 10:00:56', '2026-03-22 10:00:56'), (74, '[Pack] Kantong Sampah Kecil', 'Perlengkapan', 50000, 15, NULL, '2026-03-22 10:01:49', '2026-03-22 10:01:49'), (75, '[Pack] Kantong Sampah Besar', 'Perlengkapan', 150000, 12, NULL, '2026-03-22 10:02:14', '2026-03-22 10:02:14'), (76, 'Beras Bulir 5Kg', 'Beras', 100000, 10, NULL, '2026-03-22 10:03:34', '2026-03-22 10:03:34'), (77, 'Beras Bulir 10Kg', 'Beras', 180000, 13, NULL, '2026-03-22 10:04:42', '2026-03-22 10:04:42'), (78, 'Beras Bulir 25Kg', 'Beras', 425000, 5, NULL, '2026-03-22 10:05:15', '2026-03-22 10:05:15'), (79, 'Beras Durian 25Kg', 'Beras', 355000, 15, NULL, '2026-03-22 10:05:48', '2026-03-22 10:05:48'), (80, '[Bungkus] Kertas Tembakau', 'Perlengkapan', 1000, 50, NULL, '2026-03-22 10:06:50', '2026-03-22 10:06:50'), (81, 'Esse Change Double', 'Rokok', 42000, 12, NULL, '2026-03-22 10:19:19', '2026-03-22 10:19:19'), (82, 'Glory', 'Rokok', 22000, 34, NULL, '2026-03-22 10:19:31', '2026-03-22 10:19:31'), (83, 'Country', 'Rokok', 30000, 14, NULL, '2026-03-22 10:19:53', '2026-03-22 10:36:46'), (84, 'Dio Kretek', 'Rokok', 9000, 16, NULL, '2026-03-22 10:20:12', '2026-03-22 10:20:12'), (85, 'LA Ice Purple', 'Rokok', 34000, 23, NULL, '2026-03-22 10:20:39', '2026-03-22 10:20:39'), (86, 'LA Bold 16', 'Rokok', 30000, 21, NULL, '2026-03-22 10:20:50', '2026-03-22 10:33:08'), (87, 'Gudang Garam Filter', 'Rokok', 26000, 15, NULL, '2026-03-22 10:21:15', '2026-03-22 10:21:15'), (88, 'Gudang Garam Merah 12', 'Rokok', 16000, 23, NULL, '2026-03-22 10:21:40', '2026-03-22 10:21:40'), (89, 'Gudang Garam Merah 16', 'Rokok', 19000, 12, NULL, '2026-03-22 10:21:57', '2026-03-22 10:21:57'), (90, 'LA Bold 20', 'Rokok', 37000, 23, NULL, '2026-03-22 10:33:48', '2026-03-22 10:34:02'), (91, 'GG Mild', 'Rokok', 31000, 12, NULL, '2026-03-22 10:34:32', '2026-03-22 10:34:32'), (92, 'Sampoerna 16', 'Rokok', 36000, 12, NULL, '2026-03-22 10:34:52', '2026-03-22 10:35:04'); -- -------------------------------------------------------- -- -- Table structure for table `sessions` -- CREATE TABLE `sessions` ( `id` varchar(255) NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` text DEFAULT NULL, `payload` longtext NOT NULL, `last_activity` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sessions` -- INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('NPiAu61kK3QoX2fj1H4jYTcUyIIqNdy44qjgSMqt', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'YTo0OntzOjk6Il9wcmV2aW91cyI7YToyOntzOjM6InVybCI7czoyOToiaHR0cDovLzEyNy4wLjAuMTo4MDAwL2FwcmlvcmkiO3M6NToicm91dGUiO047fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NjoiX3Rva2VuIjtzOjQwOiJRYWN0ZXBac09zdmFyT1FLeDRPaHl6N3BPc2ZBemt3bHRSYVhoZ05UIjtzOjU6ImxvZ2luIjtiOjE7fQ==', 1774208723); -- -------------------------------------------------------- -- -- Table structure for table `transaksi` -- CREATE TABLE `transaksi` ( `id` bigint(20) UNSIGNED NOT NULL, `trx_id` varchar(255) NOT NULL, `tanggal` date NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `produk` text DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `transaksi` -- INSERT INTO `transaksi` (`id`, `trx_id`, `tanggal`, `created_at`, `updated_at`, `produk`) VALUES (6, 'TRX001', '2025-06-24', '2026-03-22 09:49:32', '2026-03-22 09:49:32', 'Karung 25kg,Aqua Botol Sedang 600ml,Le Minerale Sedang 600ml,Kopi Robusta 500gr,[Bungkus] Gula Pasir 1kg,[Sachet] Shampoo Clear,SGM,Fortune,Bimoli,GG Merah Lebar'), (7, 'TRX002', '2025-06-25', '2026-03-22 09:50:21', '2026-03-22 09:50:21', 'Karung 25kg,Aqua Botol Besar 1L,[Bungkus] Goodday Cappucino,[Bungkus] Luwak White Kopi,Kopi Robusta 500gr,Minyak Fortune 500ml,Mila Tepung Terigu 1kg,[Sachet] Shampoo Clear,[Sachet] Shampoo Lifebuoy,Mamypoko,Dji Sam Soe Hitam,GG 12,[Bungkus] Tembakau Kecil'), (8, 'TRX003', '2025-06-26', '2026-03-22 10:08:24', '2026-03-22 10:08:24', 'Indomie Goreng,Mie Eko,Teh Gelas,[Sachet] Nutrisari Jeruk Peras,Aqua Botol Sedang 600ml,[Bungkus] Kopi Kapal Api 30gr,[Bungkus] Goodday Cappucino,[Karton] Aqua Sedang,[Karton] Ayudes,Kopi Robusta 500gr,Mila Tepung Terigu 1kg,[Bungkus] Gula Pasir 1kg,Minyak Bimoli 1L,[Sachet] Deterjen Rinso,Tisu Jolie,Fortune,Bimoli,GG 16,GG Merah Lebar,[Pack] Gelas Pop Ice 12\" 14\" 16\",[Bungkus] Plastik Tipis Kecil,[Pack] Kertas Tembakau,[Pack] Kantong Sampah Kecil,[Bungkus] Kertas Tembakau,[Bungkus] Amor,Tali Rafia 1/2 Kg'), (9, 'TRX004', '2025-06-27', '2026-03-22 10:09:39', '2026-03-22 10:09:39', 'Karung 25kg,Kopi Robusta 500gr,Minyak Kita 1L,Gulaku Gula Pasir 1kg,[Sachet] Shampoo Sunsilk,[Sachet] Shampoo Clear,SGM,Fortune,Bimoli,Dji Sam Soe Hitam,Marlboro,[Bungkus] Plastik Putih 1kg,[Bungkus] Plastik Garis,[Pack] Kantong Sampah Kecil,[Bungkus] Kertas Tembakau,[Pack] Tembakau Kuning'), (10, 'TRX005', '2025-06-28', '2026-03-22 10:10:38', '2026-03-22 10:10:38', 'Karung 25kg,Teh Gelas,[Sachet] Nutrisari Jeruk Peras,Aqua Botol Sedang 600ml,[Karton] Ayudes,Kopi Robusta 500gr,Tisu Jolie,Bimoli,Indoceria,[Bungkus] Plastik Tipis Kecil,[Pack] Kertas Tembakau,[Pack] Tembakau Kuning,Tali Rafia 1Kg'), (11, 'TRX006', '2025-06-29', '2026-03-22 10:11:19', '2026-03-22 10:11:19', 'Karung 25kg,Kopi Robusta 500gr,Mamypoko,GG Kaleng,[Bungkus] Kertas Tembakau,[Bungkus] Amor'), (12, 'TRX007', '2025-06-30', '2026-03-22 10:12:14', '2026-03-22 10:12:14', 'Karung 25kg,Sarimi,Teh Gelas,[Sachet] Susu Dancow Vanilla,[Sachet] Nutrisari Jeruk Peras,Aqua Botol Besar 1L,[Bungkus] Kopi Kapal Api 60gr,[Bungkus] Goodday Cappucino,[Karton] Aqua Sedang,[Karton] Ayudes,Kopi Robusta 500gr,Mila Tepung Terigu 1kg,Gulaku Gula Pasir 1kg,Minyak Bimoli 1L,[Sachet] Shampoo Lifebuoy,SGM,Mamypoko,GG Merah,GG 12,GG Putih International,[Bungkus] Plastik Garis'), (13, 'TRX008', '2025-07-01', '2026-03-22 10:14:08', '2026-03-22 10:14:08', 'Karung 25kg,[Karton] Ayudes,Kopi Robusta 500gr,[Sachet] Deterjen Rinso,Fortune,Bimoli,GG Kaleng,GG Merah Lebar,[Pack] Kantong Sampah Kecil,[Pack] Kantong Sampah Besar,[Bungkus] Kertas Tembakau,[Bungkus] Tembakau Kecil,[Bungkus] Amor,Beras Bulir 5Kg'), (14, 'TRX009', '2025-07-02', '2026-03-22 10:15:27', '2026-03-22 10:15:27', 'Karung 25kg,Sarimi,Indomie,Teh Gelas,Aqua Botol Sedang 600ml,Le Minerale Sedang 600ml,[Bungkus] Kopi Kapal Api 60gr,[Karton] Aqua Sedang,[Karton] Ayudes,Kopi Robusta 500gr,Minyak Fortune 500ml,[Sachet] Shampoo Sunsilk,[Sachet] Shampoo Clear,Ayudes,SGM,Fortune,Amor,Dji Sam Soe Hitam,GG Merah Lebar,[Pack] Gelas Pop Ice 12\" 14\" 16\",[Pack] Sedotan Pop Ice,[Pack] Sedotan Biasa Warna,[Bungkus] Plastik Tipis Kecil,[Bungkus] Plastik Garis,[Bungkus] Kertas Tembakau,[Bungkus] Tembakau Kecil'), (15, 'TRX010', '2025-07-03', '2026-03-22 10:16:27', '2026-03-22 10:17:02', 'Karung 25kg,Mie Eko,Le Minerale Sedang 600ml,[Bungkus] Kopi Kapal Api 60gr,[Bungkus] Goodday Cappucino,[Bungkus] Luwak White Kopi,[Karton] Ayudes,Kopi Robusta 500gr,Minyak Kita 1L,[Sachet] Shampoo Lifebuoy,[Sachet] Deterjen Downy,Tisu Jolie,Indoceria,GG Putih International,[Pack] Kertas Tembakau,[Bungkus] Amor,Tali Rafia 1/2 Kg'), (16, 'TRX011', '2025-07-04', '2026-03-22 10:17:59', '2026-03-22 10:17:59', 'Karung 25kg,Teh Gelas,Mila Tepung Terigu 1kg,[Bungkus] Gula Pasir 1kg,[Sachet] Deterjen Rinso,GG Merah,GG Kaleng,[Bungkus] Kertas Tembakau,[Bungkus] Tembakau Kecil'), (17, 'TRX012', '2025-07-05', '2026-03-22 10:37:32', '2026-03-22 10:37:32', 'Karung 25kg,Indomie Goreng,Teh Gelas,Aqua Botol Sedang 600ml,Aqua Botol Besar 1L,Le Minerale Sedang 600ml,[Bungkus] Kopi Kapal Api 60gr,[Karton] Ayudes,Kopi Robusta 500gr,Minyak Kita 1L,Mila Tepung Terigu 1kg,Bimoli,Mamypoko,GG Kaleng,[Bungkus] Kertas Tembakau,[Bungkus] Amor,Esse Change Double,Glory,Country'), (18, 'TRX013', '2025-07-06', '2026-03-22 10:38:22', '2026-03-22 10:38:22', 'Karung 25kg,Teh Gelas,Aqua Botol Besar 1L,[Karton] Ayudes,Kopi Robusta 500gr,[Sachet] Shampoo Sunsilk,Fortune,Amor,[Bungkus] Plastik Tipis Kecil,[Pack] Kantong Sampah Besar,[Bungkus] Kertas Tembakau,[Bungkus] Tembakau Kecil,LA Ice Purple,Sampoerna 16'), (19, 'TRX014', '2025-07-07', '2026-03-22 10:39:43', '2026-03-22 10:39:43', 'Karung 25kg,Mie Eko,[Karton] Ayudes,Kopi Robusta 500gr,[Bungkus] Gula Pasir 1kg,[Sachet] Shampoo Clear,[Sachet] Deterjen Downy,Mamypoko,Dji Sam Soe Hitam,Indoceria,GG Merah,Marlboro,[Pack] Kertas Tembakau,[Bungkus] Kertas Tembakau,[Bungkus] Tembakau Kecil,[Bungkus] Tembakau Besar,[Pack] Amor,Tali Rafia 1Kg,LA Ice Purple,LA Bold 16,Gudang Garam Merah 16,LA Bold 20,Sampoerna 16'), (20, 'TRX015', '2025-07-08', '2026-03-22 10:40:34', '2026-03-22 10:40:34', 'Karung 25kg,Le Minerale Sedang 600ml,[Karton] Ayudes,Kopi Robusta 500gr,GG 16,[Pack] Kantong Sampah Kecil,[Bungkus] Kertas Tembakau,[Bungkus] Tembakau Kecil,Glory,Country'), (21, 'TRX016', '2025-07-09', '2026-03-22 10:41:09', '2026-03-22 10:41:09', 'Karung 25kg,Mie Eko,Aqua Botol Sedang 600ml,Le Minerale Sedang 600ml,[Karton] Ayudes,Mila Tepung Terigu 1kg,Tisu Jolie,Marlboro,[Bungkus] Kertas Tembakau,[Bungkus] Tembakau Kecil,Tali Rafia 1/2 Kg,Country'), (22, 'TRX017', '2025-07-10', '2026-03-22 10:42:01', '2026-03-22 10:42:01', 'Karung 25kg,[Sachet] Nutrisari Jeruk Peras,Aqua Botol Sedang 600ml,[Bungkus] Kopi Kapal Api 60gr,[Bungkus] Goodday Cappucino,[Karton] Ayudes,[Bungkus] Gula Pasir 1kg,Minyak Bimoli 1L,[Sachet] Deterjen Rinso,Amor,Marlboro,GG Merah Lebar,[Pack] Sedotan Pop Ice,[Bungkus] Kertas Tembakau,[Bungkus] Amor,Tali Rafia 1/2 Kg,Dio Kretek,LA Ice Purple,LA Bold 16'), (23, 'TRX018', '2025-07-11', '2026-03-22 10:42:50', '2026-03-22 10:42:50', 'Karung 25kg,Aqua Botol Besar 1L,[Karton] Ayudes,Kopi Robusta 500gr,[Bungkus] Gula Pasir 1kg,[Sachet] Shampoo Clear,GG Kaleng,[Pack] Gelas Kecil,[Pack] Kertas Tembakau,[Pack] Tembakau Kuning,Tali Rafia 1Kg,Esse Change Double,LA Ice Purple,Gudang Garam Merah 12'), (24, 'TRX019', '2025-07-12', '2026-03-22 11:28:38', '2026-03-22 11:28:38', 'Karung 25kg,[Karton] Ayudes,Kopi Robusta 500gr,Indoceria,GG 16,[Pack] Kantong Sampah Besar,[Bungkus] Kertas Tembakau,[Bungkus] Tembakau Besar,Tali Rafia 1/2 Kg,Country'), (25, 'TRX020', '2025-07-13', '2026-03-22 11:29:58', '2026-03-22 11:29:58', 'Karung 25kg,Sarimi,Indomie,Teh Gelas,[Sachet] Susu Dancow Vanilla,Aqua Botol Sedang 600ml,Le Minerale Sedang 600ml,[Karton] Ayudes,Mila Tepung Terigu 1kg,Amor,GG 12,[Bungkus] Plastik Tipis Kecil,[Bungkus] Plastik Garis,[Bungkus] Plastik Hitam Tipis,[Pack] Kertas Tembakau,[Pack] Kantong Sampah Kecil,[Pack] Tembakau Kuning,Esse Change Double,Gudang Garam Merah 12,LA Bold 20'), (26, 'TRX021', '2025-07-15', '2026-03-22 11:31:48', '2026-03-22 11:32:01', 'Aqua Botol Kecil 330ml,Kopi Robusta 500gr,Minyak Fortune 500ml,Tisu Jolie,Bimoli,Dji Sam Soe Hitam,Indoceria,GG Merah Lebar,[Pack] Sedotan Biasa Warna,[Bungkus] Plastik Hitam Tipis,[Pack] Kertas Tembakau,[Pack] Amor,Tali Rafia 1/2 Kg,Beras Bulir 5Kg,Gudang Garam Merah 16'), (27, 'TRX022', '2025-07-14', '2026-03-22 11:31:48', '2026-03-22 11:31:48', 'Aqua Botol Kecil 330ml,Kopi Robusta 500gr,Minyak Fortune 500ml,Tisu Jolie,Bimoli,Dji Sam Soe Hitam,Indoceria,GG Merah Lebar,[Pack] Sedotan Biasa Warna,[Bungkus] Plastik Hitam Tipis,[Pack] Kertas Tembakau,[Pack] Amor,Tali Rafia 1/2 Kg,Beras Bulir 5Kg,Gudang Garam Merah 16'), (28, 'TRX023', '2025-07-16', '2026-03-22 11:32:50', '2026-03-22 11:32:50', 'Karung 25kg,Kopi Robusta 500gr,Minyak Fortune 500ml,[Sachet] Deterjen Downy,[Sachet] Deterjen Rinso,Bimoli,Mamypoko,GG 16,GG Putih International,[Pack] Tembakau Kuning,Tali Rafia 1/2 Kg'), (29, 'TRX024', '2025-07-17', '2026-03-22 11:34:03', '2026-03-22 11:34:03', 'Karung 25kg,[Sachet] Susu Dancow Coklat,[Bungkus] Kopi Kapal Api 60gr,[Bungkus] Luwak White Kopi,[Karton] Ayudes,Kopi Robusta 500gr,Minyak Fortune 500ml,Mila Tepung Terigu 1kg,Minyak Bimoli 1L,Tisu Jolie,Ayudes,Bimoli,Mamypoko,GG 12,[Pack] Gelas Pop Ice 12\" 14\" 16\",[Bungkus] Plastik Tipis Kecil,[Pack] Kantong Sampah Kecil,[Bungkus] Kertas Tembakau,[Bungkus] Tembakau Kecil,[Bungkus] Tembakau Besar,[Bungkus] Amor'), (30, 'TRX025', '2025-07-18', '2026-03-22 11:35:27', '2026-03-22 11:35:27', 'Karung 25kg,Indomie Goreng,Le Minerale Sedang 600ml,[Bungkus] Kopi Kapal Api 60gr,[Karton] Aqua Sedang,[Karton] Ayudes,Kopi Robusta 500gr,SGM,[Pack] Gelas Agar-agar,[Pack] Sedotan Pop Ice,[Pack] Kantong Sampah Kecil,[Pack] Kantong Sampah Besar,Tali Rafia 1Kg,Tali Rafia 1/2 Kg,Esse Change Double,Gudang Garam Merah 16,GG Mild,Sampoerna 16'); -- -------------------------------------------------------- -- -- Table structure for table `transaksi_hasil_apriori` -- CREATE TABLE `transaksi_hasil_apriori` ( `id` bigint(20) UNSIGNED NOT NULL, `antecedent` varchar(255) NOT NULL, `consequent` varchar(255) NOT NULL, `support` double NOT NULL, `confidence` double NOT NULL, `lift` double NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `transaksi_hasil_apriori` -- INSERT INTO `transaksi_hasil_apriori` (`id`, `antecedent`, `consequent`, `support`, `confidence`, `lift`) VALUES (1, 'Karung 25kg', 'Kopi Robusta 500gr', 72, 81.818181818182, 0.97402597402597), (2, 'Kopi Robusta 500gr', 'Karung 25kg', 72, 85.714285714286, 0.97402597402597), (3, 'Aqua Botol Sedang 600ml', 'Karung 25kg', 28, 87.5, 0.99431818181818), (4, 'Aqua Botol Sedang 600ml', 'Le Minerale Sedang 600ml', 20, 62.5, 1.953125), (5, 'Le Minerale Sedang 600ml', 'Aqua Botol Sedang 600ml', 20, 62.5, 1.953125), (6, 'Aqua Botol Sedang 600ml', 'Kopi Robusta 500gr', 20, 62.5, 0.74404761904762), (7, 'Fortune', 'Karung 25kg', 20, 83.333333333333, 0.9469696969697), (8, 'Fortune', 'Kopi Robusta 500gr', 24, 100, 1.1904761904762), (9, 'Bimoli', 'Karung 25kg', 28, 70, 0.79545454545455), (10, 'Bimoli', 'Kopi Robusta 500gr', 40, 100, 1.1904761904762), (11, 'Bimoli', 'GG Merah Lebar', 20, 50, 1.7857142857143), (12, 'GG Merah Lebar', 'Bimoli', 20, 71.428571428571, 1.7857142857143), (13, 'GG Merah Lebar', 'Kopi Robusta 500gr', 24, 85.714285714286, 1.0204081632653), (14, 'Aqua Botol Besar 1L', 'Karung 25kg', 20, 100, 1.1363636363636), (15, 'Aqua Botol Besar 1L', 'Kopi Robusta 500gr', 20, 100, 1.1904761904762), (16, 'Dji Sam Soe Hitam', 'Kopi Robusta 500gr', 24, 100, 1.1904761904762), (17, 'Aqua Botol Sedang 600ml', 'Teh Gelas', 20, 62.5, 1.953125), (18, 'Teh Gelas', 'Aqua Botol Sedang 600ml', 20, 62.5, 1.953125), (19, 'Aqua Botol Sedang 600ml', '[Karton] Ayudes', 28, 87.5, 1.2867647058824), (20, 'Aqua Botol Sedang 600ml', '[Bungkus] Kertas Tembakau', 20, 62.5, 1.1160714285714), (21, 'Kopi Robusta 500gr', '[Karton] Ayudes', 56, 66.666666666667, 0.98039215686274), (22, '[Karton] Ayudes', 'Kopi Robusta 500gr', 56, 82.352941176471, 0.98039215686274), (23, 'Kopi Robusta 500gr', '[Bungkus] Kertas Tembakau', 44, 52.380952380952, 0.93537414965986), (24, '[Bungkus] Kertas Tembakau', 'Kopi Robusta 500gr', 44, 78.571428571429, 0.93537414965986), (25, 'Fortune', '[Bungkus] Kertas Tembakau', 20, 83.333333333333, 1.4880952380952), (26, 'Bimoli', '[Karton] Ayudes', 20, 50, 0.73529411764706), (27, 'Bimoli', 'Tisu Jolie', 20, 50, 1.7857142857143), (28, 'Tisu Jolie', 'Bimoli', 20, 71.428571428571, 1.7857142857143), (29, 'Bimoli', '[Bungkus] Kertas Tembakau', 20, 50, 0.89285714285714), (30, 'Mila Tepung Terigu 1kg', 'Teh Gelas', 20, 62.5, 1.953125), (31, 'Teh Gelas', 'Mila Tepung Terigu 1kg', 20, 62.5, 1.953125), (32, 'Mila Tepung Terigu 1kg', '[Karton] Ayudes', 24, 75, 1.1029411764706), (33, 'Mila Tepung Terigu 1kg', '[Bungkus] Kertas Tembakau', 20, 62.5, 1.1160714285714), (34, 'Teh Gelas', '[Karton] Ayudes', 28, 87.5, 1.2867647058824), (35, 'Teh Gelas', '[Bungkus] Plastik Tipis Kecil', 20, 62.5, 2.6041666666667), (36, '[Bungkus] Plastik Tipis Kecil', 'Teh Gelas', 20, 83.333333333333, 2.6041666666667), (37, 'Teh Gelas', '[Bungkus] Kertas Tembakau', 20, 62.5, 1.1160714285714), (38, 'Tisu Jolie', '[Karton] Ayudes', 20, 71.428571428571, 1.0504201680672), (39, 'Tisu Jolie', '[Pack] Kertas Tembakau', 20, 71.428571428571, 2.2321428571429), (40, '[Pack] Kertas Tembakau', 'Tisu Jolie', 20, 62.5, 2.2321428571429), (41, '[Bungkus] Plastik Tipis Kecil', '[Karton] Ayudes', 24, 100, 1.4705882352941), (42, '[Bungkus] Kertas Tembakau', '[Karton] Ayudes', 44, 78.571428571429, 1.1554621848739), (43, '[Karton] Ayudes', '[Bungkus] Kertas Tembakau', 44, 64.705882352941, 1.1554621848739), (44, '[Bungkus] Amor', '[Karton] Ayudes', 24, 85.714285714286, 1.2605042016807), (45, '[Bungkus] Amor', '[Bungkus] Kertas Tembakau', 24, 85.714285714286, 1.530612244898), (46, 'Tali Rafia 1/2 Kg', '[Karton] Ayudes', 24, 66.666666666667, 0.98039215686274), (47, 'Tali Rafia 1/2 Kg', 'Tisu Jolie', 20, 55.555555555556, 1.984126984127), (48, 'Tisu Jolie', 'Tali Rafia 1/2 Kg', 20, 71.428571428571, 1.984126984127), (49, 'Karung 25kg', '[Bungkus] Kertas Tembakau', 52, 59.090909090909, 1.0551948051948), (50, '[Bungkus] Kertas Tembakau', 'Karung 25kg', 52, 92.857142857143, 1.0551948051948), (51, 'Karung 25kg', '[Karton] Ayudes', 64, 72.727272727273, 1.0695187165775), (52, '[Karton] Ayudes', 'Karung 25kg', 64, 94.117647058824, 1.0695187165775), (53, 'Indoceria', 'Kopi Robusta 500gr', 24, 100, 1.1904761904762), (54, 'Indoceria', '[Pack] Kertas Tembakau', 20, 83.333333333333, 2.6041666666667), (55, '[Pack] Kertas Tembakau', 'Indoceria', 20, 62.5, 2.6041666666667), (56, 'GG Kaleng', 'Karung 25kg', 20, 100, 1.1363636363636), (57, '[Bungkus] Kopi Kapal Api 60gr', '[Karton] Ayudes', 28, 100, 1.4705882352941), (58, '[Bungkus] Tembakau Kecil', '[Karton] Ayudes', 28, 77.777777777778, 1.1437908496732), (59, '[Bungkus] Kertas Tembakau', '[Bungkus] Tembakau Kecil', 32, 57.142857142857, 1.5873015873016), (60, '[Bungkus] Tembakau Kecil', '[Bungkus] Kertas Tembakau', 32, 88.888888888889, 1.5873015873016), (61, 'Le Minerale Sedang 600ml', '[Karton] Ayudes', 28, 87.5, 1.2867647058824); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `username` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `remember_token` varchar(100) 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 for table `users` -- INSERT INTO `users` (`id`, `username`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'admin', 'admin', '', NULL, '$2y$12$0NsovkkIbzq96BnCXVDneeXI0LxykZoEpUdjo1isPUbvyxmdI6b1K', NULL, NULL, '2026-03-17 09:59:37'); -- -- Indexes for dumped tables -- -- -- Indexes for table `cache` -- ALTER TABLE `cache` ADD PRIMARY KEY (`key`), ADD KEY `cache_expiration_index` (`expiration`); -- -- Indexes for table `cache_locks` -- ALTER TABLE `cache_locks` ADD PRIMARY KEY (`key`), ADD KEY `cache_locks_expiration_index` (`expiration`); -- -- Indexes for table `detail_transaksi` -- ALTER TABLE `detail_transaksi` ADD PRIMARY KEY (`id`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `jobs` -- ALTER TABLE `jobs` ADD PRIMARY KEY (`id`), ADD KEY `jobs_queue_index` (`queue`); -- -- Indexes for table `job_batches` -- ALTER TABLE `job_batches` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` ADD PRIMARY KEY (`email`); -- -- Indexes for table `produk` -- ALTER TABLE `produk` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `nama_produk` (`nama_produk`); -- -- Indexes for table `sessions` -- ALTER TABLE `sessions` ADD PRIMARY KEY (`id`), ADD KEY `sessions_user_id_index` (`user_id`), ADD KEY `sessions_last_activity_index` (`last_activity`); -- -- Indexes for table `transaksi` -- ALTER TABLE `transaksi` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `transaksi_trx_id_unique` (`trx_id`); -- -- Indexes for table `transaksi_hasil_apriori` -- ALTER TABLE `transaksi_hasil_apriori` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`), ADD UNIQUE KEY `users_username_unique` (`username`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `detail_transaksi` -- ALTER TABLE `detail_transaksi` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `jobs` -- ALTER TABLE `jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `produk` -- ALTER TABLE `produk` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=93; -- -- AUTO_INCREMENT for table `transaksi` -- ALTER TABLE `transaksi` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31; -- -- AUTO_INCREMENT for table `transaksi_hasil_apriori` -- ALTER TABLE `transaksi_hasil_apriori` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; 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 */;