-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jun 20, 2024 at 08:43 PM -- Server version: 8.0.30 -- PHP Version: 8.1.10 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: `akunansi_baru` -- -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint UNSIGNED NOT NULL, `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `log_activites` -- CREATE TABLE `log_activites` ( `id` bigint UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int UNSIGNED NOT NULL, `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2014_10_12_000000_create_users_table', 1), (2, '2014_10_12_100000_create_password_resets_table', 1), (3, '2019_08_19_000000_create_failed_jobs_table', 1), (4, '2019_12_14_000001_create_personal_access_tokens_table', 1), (5, '2023_07_08_072603_create_websites_table', 2), (6, '2023_09_05_073014_create_log_activites_table', 2), (7, '2024_05_21_093802_add_kode_transaksi_to_tbl_transaksi_table', 2), (8, '2024_05_21_202127_create_suppliers_table', 2), (9, '2024_05_25_115057_add_payment_method_to_tbl_transaksi', 3); -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `uuid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `isUsed` int NOT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `password_resets` -- INSERT INTO `password_resets` (`uuid`, `email`, `token`, `isUsed`, `created_at`) VALUES ('2a16b010-a96a-4d16-b579-52dc50f3ff89', 'yonatanagave@gmail.com', '976871b0646b2c055ffc6a6408048ba6', 0, '2023-12-28 14:56:29'), ('74f0ae01-1d0f-487a-b4bd-49d91dd1783b', 'officialnuzulzaif124@gmail.com', '985a92a858cec0a0c8024444af20f01c', 0, '2024-04-02 13:58:33'), ('8c40d1a7-a6c8-4d05-9ffa-08be157e4261', 'officialnuzulzaif124@gmail.com', 'f915b09ae1f430cc98b9942dfa470480', 0, '2024-04-02 14:03:16'), ('ddf0b068-d7a7-4d84-bdcc-db2ad60dcef1', 'localvalorants@gmail.com', '27e668f86a14cc8d4eb980ccc430888e', 1, '2023-09-18 07:05:45'), ('ed5ec1c1-b9a8-4b2c-8c9f-91811dcf3aa1', 'localvalorants@gmail.com', '33790bd44168c13461111d0e9de6a8ee', 0, '2023-09-19 06:17:59'), ('f63c96d5-7f55-4da2-baf6-c3412d7e023c', 'officialnuzulzaif124@gmail.com', '4a81a4838bfb11fb29345021ea8cf23c', 0, '2024-04-02 13:53:34'); -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint UNSIGNED NOT NULL, `tokenable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint UNSIGNED NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text CHARACTER SET utf8mb4 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; -- -------------------------------------------------------- -- -- Table structure for table `suppliers` -- CREATE TABLE `suppliers` ( `id` bigint UNSIGNED NOT NULL, `nama_supplier` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `nama_produk` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `jumlah` int NOT NULL, `harga` decimal(15,2) NOT NULL, `payment_method` 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; -- -- Dumping data for table `suppliers` -- INSERT INTO `suppliers` (`id`, `nama_supplier`, `nama_produk`, `jumlah`, `harga`, `payment_method`, `created_at`, `updated_at`) VALUES (29, 'Pak Yudi', 'Kayu Kelapa 8x12 (5 meter)', 8, '90000.00', 'cash', '2024-05-31 22:52:07', '2024-05-31 22:52:07'), (30, 'Pt tongas abadi', 'kayu Reng 2x3 (3 meter) (25 biji)', 3, '70000.00', 'hutang', '2024-05-31 22:52:31', '2024-05-31 22:52:31'), (31, 'Pak Yudi', 'Kayu Kelapa 8x12 (5 meter)', 9, '100000.00', 'cash', '2024-06-03 04:18:02', '2024-06-03 04:18:02'), (32, 'Pak Ely', 'Kayu Kelapa 8x12 (5 meter)', 15, '15000.00', 'hutang', '2024-06-03 04:38:03', '2024-06-03 04:38:03'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_akun` -- CREATE TABLE `tbl_akun` ( `id` int NOT NULL, `nama_akun` varchar(100) DEFAULT NULL, `kode_akun` varchar(5) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_akun` -- INSERT INTO `tbl_akun` (`id`, `nama_akun`, `kode_akun`) VALUES (1, 'Kas', '110'), (2, 'Piutang Usaha', '120'), (3, 'Persediaan', '140'), (9, 'Pendapatan Penjualan', '510'), (14, 'Hutang Usaha', '113'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_jurnal` -- CREATE TABLE `tbl_jurnal` ( `id` int NOT NULL, `no_reff` varchar(255) NOT NULL, `keterangan` varchar(255) DEFAULT NULL, `waktu_transaksi` date DEFAULT NULL, `nominal` int UNSIGNED DEFAULT NULL, `tipe` enum('d','k') DEFAULT NULL, `id_akun` int UNSIGNED DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_jurnal` -- INSERT INTO `tbl_jurnal` (`id`, `no_reff`, `keterangan`, `waktu_transaksi`, `nominal`, `tipe`, `id_akun`, `created_at`, `updated_at`) VALUES (96, 's6UtIr4FUP', 'Pembelian persediaan dari supplier Pak Yudi', '2024-06-01', 720000, 'd', 3, '2024-06-01 05:52:07', '2024-06-01 05:52:07'), (97, 's6UtIr4FUP', 'Pembayaran tunai untuk pembelian persediaan dari supplier Pak Yudi', '2024-06-01', 720000, 'k', 1, '2024-06-01 05:52:07', '2024-06-01 05:52:07'), (98, 'MsUY5e2Dzr', 'Pembelian persediaan dari supplier Pt tongas abadi', '2024-06-01', 210000, 'd', 3, '2024-06-01 05:52:31', '2024-06-01 05:52:31'), (99, 'MsUY5e2Dzr', 'Hutang untuk pembelian persediaan dari supplier Pt tongas abadi', '2024-06-01', 210000, 'k', 14, '2024-06-01 05:52:31', '2024-06-01 05:52:31'), (100, 'Lz2ffGMzVI', 'Pembelian Kayu Kelapa 8x12 (5 meter)', '2024-06-01', 600000, 'd', 1, '2024-06-01 05:53:05', '2024-06-01 05:53:05'), (101, 'Lz2ffGMzVI', 'Pembayaran Kayu Kelapa 8x12 (5 meter)', '2024-06-01', 600000, 'k', 9, '2024-06-01 05:53:05', '2024-06-01 05:53:05'), (102, 'gu61iBA0Qr', 'Pembelian kayu Reng 2x3 (3 meter) (25 biji)', '2024-06-01', 900000, 'd', 1, '2024-06-01 05:53:17', '2024-06-01 05:53:17'), (103, 'gu61iBA0Qr', 'Pembayaran kayu Reng 2x3 (3 meter) (25 biji)', '2024-06-01', 900000, 'k', 9, '2024-06-01 05:53:17', '2024-06-01 05:53:17'), (104, 'rzO7zgzdPQ', 'Pembelian Kayu Kelapa 8x12 (5 meter)', '2024-06-01', 200000, 'd', 2, '2024-06-01 05:53:29', '2024-06-01 05:53:29'), (105, 'rzO7zgzdPQ', 'Pembayaran Kayu Kelapa 8x12 (5 meter)', '2024-06-01', 200000, 'k', 9, '2024-06-01 05:53:29', '2024-06-01 05:53:29'), (106, 'FkHRYrfRvw', 'Pembelian Kayu Kelapa 8x12 (5 meter)', '2024-06-03', 200000, 'd', 1, '2024-06-03 11:16:35', '2024-06-03 11:16:35'), (107, 'FkHRYrfRvw', 'Pembayaran Kayu Kelapa 8x12 (5 meter)', '2024-06-03', 200000, 'k', 9, '2024-06-03 11:16:35', '2024-06-03 11:16:35'), (108, 'CO28dIHuIc', 'Pembelian persediaan dari supplier Pak Yudi', '2024-06-03', 900000, 'd', 3, '2024-06-03 11:18:02', '2024-06-03 11:18:02'), (109, 'CO28dIHuIc', 'Pembayaran tunai untuk pembelian persediaan dari supplier Pak Yudi', '2024-06-03', 900000, 'k', 1, '2024-06-03 11:18:02', '2024-06-03 11:18:02'), (110, 'yZNabk4v71', 'Pembelian persediaan dari supplier Pak Ely', '2024-06-03', 225000, 'd', 3, '2024-06-03 11:38:03', '2024-06-03 11:38:03'), (111, 'yZNabk4v71', 'Hutang untuk pembelian persediaan dari supplier Pak Ely', '2024-06-03', 225000, 'k', 14, '2024-06-03 11:38:03', '2024-06-03 11:38:03'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_log_activity` -- CREATE TABLE `tbl_log_activity` ( `uid` char(40) NOT NULL, `logType` int NOT NULL DEFAULT '1' COMMENT '1: Login\r\n2: General', `causedBy` int NOT NULL, `performedOn` varchar(50) NOT NULL, `withContent` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_log_activity` -- INSERT INTO `tbl_log_activity` (`uid`, `logType`, `causedBy`, `performedOn`, `withContent`, `created_at`) VALUES ('04270d70-eb96-469e-826b-f13970842025', 1, 1, '2024-05-29 23:01:02', '{\"status\":\"add\",\"text\":\"Login as Administrator\",\"ip_address\":\"127.0.0.1\",\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/125.0.0.0 Safari\\/537.36\",\"time\":\"2024-05-29 23:01:02\"}', '2024-05-29 23:01:02'), ('0713b192-db5a-423d-a76f-249dd50895d4', 1, 1, '2024-05-30 00:01:04', '{\"status\":\"add\",\"text\":\"Login as Administrator\",\"ip_address\":\"127.0.0.1\",\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/125.0.0.0 Safari\\/537.36 Edg\\/125.0.0.0\",\"time\":\"2024-05-30 00:01:04\"}', '2024-05-30 00:01:04'), ('09d11538-6034-45f6-9500-c080e27f36c3', 1, 1, '2024-06-01 05:19:48', '{\"status\":\"add\",\"text\":\"Login as Administrator\",\"ip_address\":\"127.0.0.1\",\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/125.0.0.0 Safari\\/537.36 Edg\\/125.0.0.0\",\"time\":\"2024-06-01 05:19:48\"}', '2024-06-01 05:19:48'), ('1d6723ef-3465-49bf-afa4-6cdabfdeb534', 1, 1, '2024-05-28 10:38:55', '{\"status\":\"add\",\"text\":\"Login as Administrator\",\"ip_address\":\"127.0.0.1\",\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/125.0.0.0 Safari\\/537.36 Edg\\/125.0.0.0\",\"time\":\"2024-05-28 10:38:55\"}', '2024-05-28 10:38:55'), ('3811ca4a-e642-4697-b9d8-3ca9f8278bf8', 1, 1, '2024-05-26 22:55:29', '{\"status\":\"add\",\"text\":\"Login as Administrator\",\"ip_address\":\"127.0.0.1\",\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/125.0.0.0 Safari\\/537.36 Edg\\/125.0.0.0\",\"time\":\"2024-05-26 22:55:29\"}', '2024-05-26 22:55:29'), ('49927ef8-9114-4394-8ea9-05e0475ae415', 1, 1, '2024-06-03 01:29:37', '{\"status\":\"add\",\"text\":\"Login as Administrator\",\"ip_address\":\"127.0.0.1\",\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/125.0.0.0 Safari\\/537.36 Edg\\/125.0.0.0\",\"time\":\"2024-06-03 01:29:37\"}', '2024-06-03 01:29:37'), ('521e99d3-cf1c-4be0-bab2-fda7da27f2c9', 1, 1, '2024-05-31 07:38:22', '{\"status\":\"add\",\"text\":\"Login as Administrator\",\"ip_address\":\"127.0.0.1\",\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/125.0.0.0 Safari\\/537.36 Edg\\/125.0.0.0\",\"time\":\"2024-05-31 07:38:22\"}', '2024-05-31 07:38:22'), ('5adfe78d-3e27-46e9-8ff3-721e3c0d3b22', 1, 1, '2024-05-27 11:15:36', '{\"status\":\"add\",\"text\":\"Login as Administrator\",\"ip_address\":\"127.0.0.1\",\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/125.0.0.0 Safari\\/537.36 Edg\\/125.0.0.0\",\"time\":\"2024-05-27 11:15:35\"}', '2024-05-27 11:15:36'), ('5c3e6063-6316-4762-9ee7-c9c6577fa655', 1, 1, '2024-06-03 06:32:17', '{\"status\":\"add\",\"text\":\"Login as Administrator\",\"ip_address\":\"127.0.0.1\",\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/125.0.0.0 Safari\\/537.36 Edg\\/125.0.0.0\",\"time\":\"2024-06-03 06:32:17\"}', '2024-06-03 06:32:17'), ('63c66fca-b55a-4b04-9f3b-e7732704a0df', 1, 1, '2024-05-31 05:14:19', '{\"status\":\"add\",\"text\":\"Login as Administrator\",\"ip_address\":\"127.0.0.1\",\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/125.0.0.0 Safari\\/537.36 Edg\\/125.0.0.0\",\"time\":\"2024-05-31 05:14:19\"}', '2024-05-31 05:14:19'), ('7500b6ac-2957-4381-b644-153c1c94b1a3', 1, 1, '2024-06-03 06:24:28', '{\"status\":\"add\",\"text\":\"Login as Administrator\",\"ip_address\":\"127.0.0.1\",\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/125.0.0.0 Safari\\/537.36 Edg\\/125.0.0.0\",\"time\":\"2024-06-03 06:24:28\"}', '2024-06-03 06:24:28'), ('7b35a812-de97-49f0-a7b1-1b990ef40e04', 1, 2, '2024-05-25 11:22:49', '{\"status\":\"add\",\"text\":\"Login as Muhammad Zidan Prasetyo\",\"ip_address\":\"127.0.0.1\",\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/125.0.0.0 Safari\\/537.36 Edg\\/125.0.0.0\",\"time\":\"2024-05-25 11:22:49\"}', '2024-05-25 11:22:49'), ('99da6b29-153f-4f98-804c-d20f440148ce', 1, 1, '2024-05-21 20:40:24', '{\"status\":\"add\",\"text\":\"Login as Administrator\",\"ip_address\":\"127.0.0.1\",\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/125.0.0.0 Safari\\/537.36 Edg\\/125.0.0.0\",\"time\":\"2024-05-21 20:40:24\"}', '2024-05-21 20:40:24'), ('9f08a731-d34a-480a-9fc0-5f24c44de928', 1, 1, '2024-06-03 10:58:57', '{\"status\":\"add\",\"text\":\"Login as Administrator\",\"ip_address\":\"127.0.0.1\",\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/125.0.0.0 Safari\\/537.36 Edg\\/125.0.0.0\",\"time\":\"2024-06-03 10:58:57\"}', '2024-06-03 10:58:57'), ('a702df4c-a565-4f67-8f48-e1491537c5a7', 1, 1, '2024-05-27 22:48:08', '{\"status\":\"add\",\"text\":\"Login as Administrator\",\"ip_address\":\"127.0.0.1\",\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/125.0.0.0 Safari\\/537.36 Edg\\/125.0.0.0\",\"time\":\"2024-05-27 22:48:07\"}', '2024-05-27 22:48:08'), ('ad74772c-6fed-4df8-a655-63e9fa9fa00e', 1, 1, '2024-05-31 19:04:20', '{\"status\":\"add\",\"text\":\"Login as Administrator\",\"ip_address\":\"127.0.0.1\",\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/125.0.0.0 Safari\\/537.36 Edg\\/125.0.0.0\",\"time\":\"2024-05-31 19:04:20\"}', '2024-05-31 19:04:20'), ('aeae2a7f-c89b-4d8b-8656-ea4b99c7a5a2', 1, 1, '2024-05-31 13:53:50', '{\"status\":\"add\",\"text\":\"Login as Administrator\",\"ip_address\":\"127.0.0.1\",\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/125.0.0.0 Safari\\/537.36 Edg\\/125.0.0.0\",\"time\":\"2024-05-31 13:53:50\"}', '2024-05-31 13:53:50'), ('b9b99746-d777-43e2-8b8a-8c3633769736', 1, 1, '2024-05-22 06:06:17', '{\"status\":\"add\",\"text\":\"Login as Administrator\",\"ip_address\":\"127.0.0.1\",\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/125.0.0.0 Safari\\/537.36 Edg\\/125.0.0.0\",\"time\":\"2024-05-22 06:06:16\"}', '2024-05-22 06:06:17'), ('c3eca9ae-c11f-4115-99ca-bb1261ddcc7e', 1, 1, '2024-05-26 09:06:08', '{\"status\":\"add\",\"text\":\"Login as Administrator\",\"ip_address\":\"127.0.0.1\",\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/125.0.0.0 Safari\\/537.36 Edg\\/125.0.0.0\",\"time\":\"2024-05-26 09:06:08\"}', '2024-05-26 09:06:08'), ('d3d07638-8691-4044-a240-5a4d8ca9b66f', 1, 1, '2024-05-22 19:26:57', '{\"status\":\"add\",\"text\":\"Login as Administrator\",\"ip_address\":\"127.0.0.1\",\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/125.0.0.0 Safari\\/537.36 Edg\\/125.0.0.0\",\"time\":\"2024-05-22 19:26:57\"}', '2024-05-22 19:26:57'), ('d4598a65-e6b5-440c-8d98-da7ad591ff81', 1, 1, '2024-05-27 07:38:43', '{\"status\":\"add\",\"text\":\"Login as Administrator\",\"ip_address\":\"127.0.0.1\",\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/125.0.0.0 Safari\\/537.36 Edg\\/125.0.0.0\",\"time\":\"2024-05-27 07:38:43\"}', '2024-05-27 07:38:43'), ('e8970f69-8e8d-4ea9-8f03-b27dbd0308a2', 1, 1, '2024-05-28 06:55:22', '{\"status\":\"add\",\"text\":\"Login as Administrator\",\"ip_address\":\"127.0.0.1\",\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/125.0.0.0 Safari\\/537.36 Edg\\/125.0.0.0\",\"time\":\"2024-05-28 06:55:22\"}', '2024-05-28 06:55:22'), ('ee8db0db-9f80-4166-a09a-22e73d094ba7', 1, 1, '2024-06-03 10:22:44', '{\"status\":\"add\",\"text\":\"Login as Administrator\",\"ip_address\":\"127.0.0.1\",\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/125.0.0.0 Safari\\/537.36 Edg\\/125.0.0.0\",\"time\":\"2024-06-03 10:22:44\"}', '2024-06-03 10:22:44'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_produk` -- CREATE TABLE `tbl_produk` ( `id` int NOT NULL, `name` varchar(255) NOT NULL, `stok` int NOT NULL, `price` double NOT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_produk` -- INSERT INTO `tbl_produk` (`id`, `name`, `stok`, `price`, `created_at`, `updated_at`) VALUES (12, 'Kayu Kelapa 8x12 (5 meter)', 28, 100000, '2024-05-31 07:57:15', '2024-06-03 11:38:03'), (13, 'kayu Reng 2x3 (3 meter) (25 biji)', 10, 100000, '2024-05-31 19:06:34', '2024-06-01 05:53:17'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_role` -- CREATE TABLE `tbl_role` ( `id` int NOT NULL, `name` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_role` -- INSERT INTO `tbl_role` (`id`, `name`) VALUES (1, 'Administrator'), (2, 'User'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_transaksi` -- CREATE TABLE `tbl_transaksi` ( `id` int NOT NULL, `id_product` int NOT NULL, `qty` int NOT NULL, `total` double NOT NULL, `payment_method` varchar(255) NOT NULL DEFAULT 'cash', `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_transaksi` -- INSERT INTO `tbl_transaksi` (`id`, `id_product`, `qty`, `total`, `payment_method`, `created_at`, `updated_at`) VALUES (34, 12, 6, 600000, 'cash', '2024-06-01 05:53:05', '2024-06-01 05:53:05'), (35, 13, 9, 900000, 'cash', '2024-06-01 05:53:17', '2024-06-01 05:53:17'), (36, 12, 2, 200000, 'hutang', '2024-06-01 05:53:29', '2024-06-01 05:53:29'), (37, 12, 2, 200000, 'cash', '2024-06-03 11:16:35', '2024-06-03 11:16:35'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_users` -- CREATE TABLE `tbl_users` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `email_verified_token` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `level` int DEFAULT '3', `phone` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `status` int NOT NULL DEFAULT '3' COMMENT '1: Active, 2: Non Active, 3: Deactivated, 4: Not Verified', `thumbnail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `tbl_users` -- INSERT INTO `tbl_users` (`id`, `name`, `username`, `email`, `email_verified_at`, `email_verified_token`, `password`, `level`, `phone`, `status`, `thumbnail`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'Administrator', 'admin', 'admin@tugas.com', NULL, NULL, '$2y$10$/326LL0MKwXcpSG9hVQlkuSrhQHnVkH6cB2Pvqi7VidQhcZQbqJQi', 1, NULL, 1, '', NULL, '2022-06-09 23:01:32', '2024-03-25 05:36:47'), (2, 'Muhammad Zidan Prasetyo', 'test664', 'test@example.com', NULL, NULL, '$2y$10$ibR1GlQ6LfcghInmVf8HCOFmFC.2f6Hley7PzeOFEWDmH3wXWEuUa', 1, NULL, 1, NULL, NULL, '2024-05-25 04:22:41', '2024-05-25 04:22:41'); -- -------------------------------------------------------- -- -- Table structure for table `websites` -- CREATE TABLE `websites` ( `id` bigint UNSIGNED NOT 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 -- -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `log_activites` -- ALTER TABLE `log_activites` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD PRIMARY KEY (`uuid`), ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `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`); -- -- Indexes for table `suppliers` -- ALTER TABLE `suppliers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_akun` -- ALTER TABLE `tbl_akun` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_jurnal` -- ALTER TABLE `tbl_jurnal` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_log_activity` -- ALTER TABLE `tbl_log_activity` ADD PRIMARY KEY (`uid`); -- -- Indexes for table `tbl_produk` -- ALTER TABLE `tbl_produk` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_role` -- ALTER TABLE `tbl_role` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_transaksi` -- ALTER TABLE `tbl_transaksi` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_users` -- ALTER TABLE `tbl_users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_username_unique` (`username`); -- -- Indexes for table `websites` -- ALTER TABLE `websites` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `log_activites` -- ALTER TABLE `log_activites` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `suppliers` -- ALTER TABLE `suppliers` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33; -- -- AUTO_INCREMENT for table `tbl_akun` -- ALTER TABLE `tbl_akun` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `tbl_jurnal` -- ALTER TABLE `tbl_jurnal` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=112; -- -- AUTO_INCREMENT for table `tbl_produk` -- ALTER TABLE `tbl_produk` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `tbl_role` -- ALTER TABLE `tbl_role` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `tbl_transaksi` -- ALTER TABLE `tbl_transaksi` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38; -- -- AUTO_INCREMENT for table `tbl_users` -- ALTER TABLE `tbl_users` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `websites` -- ALTER TABLE `websites` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; 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 */;