-- Database Backup
-- Generated: 2026-03-02 07:16:55
-- Database: u1596772_erkagraphia


-- Table: cash_modals
CREATE TABLE `cash_modals` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `amount` decimal(15,2) NOT NULL,
  `modal_date` date NOT NULL,
  `type` enum('initial','topup') NOT NULL DEFAULT 'topup',
  `account` enum('petty','cash','bank') NOT NULL DEFAULT 'petty',
  `notes` text DEFAULT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cash_modals_user_id_foreign` (`user_id`),
  CONSTRAINT `cash_modals_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: cash_mutations
CREATE TABLE `cash_mutations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `amount` decimal(15,2) NOT NULL,
  `mutation_date` date NOT NULL,
  `from_account` enum('petty','cash','bank') NOT NULL,
  `to_account` enum('petty','cash','bank') NOT NULL,
  `notes` text DEFAULT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cash_mutations_user_id_foreign` (`user_id`),
  CONSTRAINT `cash_mutations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: customers
CREATE TABLE `customers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `member_type` enum('umum','studio') NOT NULL DEFAULT 'umum',
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `customers` (`id`, `name`, `member_type`, `phone`, `email`, `address`, `created_at`, `updated_at`) VALUES ('1', 'tester', 'studio', '08990799960', NULL, NULL, '2026-02-14 09:01:16', '2026-02-14 09:01:16');
INSERT INTO `customers` (`id`, `name`, `member_type`, `phone`, `email`, `address`, `created_at`, `updated_at`) VALUES ('2', 'mas Bambang', 'umum', '0899079996-0', NULL, NULL, '2026-02-28 08:30:34', '2026-02-28 08:30:34');

-- Table: deposits
CREATE TABLE `deposits` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `amount` decimal(15,2) NOT NULL,
  `deposit_date` date NOT NULL,
  `bank_name` varchar(255) DEFAULT NULL,
  `payment_account_id` bigint(20) unsigned DEFAULT NULL,
  `reference_number` varchar(255) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `deposits_created_by_foreign` (`created_by`),
  KEY `deposits_payment_account_id_foreign` (`payment_account_id`),
  CONSTRAINT `deposits_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `deposits_payment_account_id_foreign` FOREIGN KEY (`payment_account_id`) REFERENCES `payment_accounts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: employees
CREATE TABLE `employees` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `gender` enum('L','P') NOT NULL DEFAULT 'L',
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `position` varchar(255) NOT NULL,
  `join_date` date NOT NULL,
  `base_salary` decimal(12,2) NOT NULL DEFAULT 0.00,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `employees_employee_id_unique` (`employee_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: expense_categories
CREATE TABLE `expense_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `expense_categories` (`id`, `name`, `description`, `is_active`, `created_at`, `updated_at`) VALUES ('1', 'Listrik', 'Tagihan listrik bulanan', '1', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `expense_categories` (`id`, `name`, `description`, `is_active`, `created_at`, `updated_at`) VALUES ('2', 'Token Listrik', 'Isi ulang token listrik', '1', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `expense_categories` (`id`, `name`, `description`, `is_active`, `created_at`, `updated_at`) VALUES ('3', 'PDAM/Air', 'Tagihan air bulanan', '1', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `expense_categories` (`id`, `name`, `description`, `is_active`, `created_at`, `updated_at`) VALUES ('4', 'Internet', 'Tagihan internet/wifi', '1', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `expense_categories` (`id`, `name`, `description`, `is_active`, `created_at`, `updated_at`) VALUES ('5', 'Kasbon Karyawan', 'Pinjaman karyawan', '1', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `expense_categories` (`id`, `name`, `description`, `is_active`, `created_at`, `updated_at`) VALUES ('7', 'Bensin/Transport', 'Biaya transportasi dan bensin', '1', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `expense_categories` (`id`, `name`, `description`, `is_active`, `created_at`, `updated_at`) VALUES ('8', 'Peralatan Kantor', 'ATK dan peralatan kecil', '1', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `expense_categories` (`id`, `name`, `description`, `is_active`, `created_at`, `updated_at`) VALUES ('9', 'Maintenance Mesin', 'Perawatan mesin cetak', '1', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `expense_categories` (`id`, `name`, `description`, `is_active`, `created_at`, `updated_at`) VALUES ('10', 'Sewa Tempat', 'Biaya sewa bulanan', '1', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `expense_categories` (`id`, `name`, `description`, `is_active`, `created_at`, `updated_at`) VALUES ('11', 'Paket/Pengiriman', 'Ongkir dan COD', '1', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `expense_categories` (`id`, `name`, `description`, `is_active`, `created_at`, `updated_at`) VALUES ('12', 'Ambil Modal', 'Penarikan modal pemilik', '1', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `expense_categories` (`id`, `name`, `description`, `is_active`, `created_at`, `updated_at`) VALUES ('13', 'Lain-lain', 'Pengeluaran lainnya', '1', '2026-02-09 13:27:05', '2026-02-09 13:27:05');

-- Table: expenses
CREATE TABLE `expenses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `expense_category_id` bigint(20) unsigned NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `expense_date` date NOT NULL,
  `description` text DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `expenses_expense_category_id_foreign` (`expense_category_id`),
  KEY `expenses_created_by_foreign` (`created_by`),
  CONSTRAINT `expenses_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `expenses_expense_category_id_foreign` FOREIGN KEY (`expense_category_id`) REFERENCES `expense_categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: failed_jobs
CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: jobs
CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: machine_material
CREATE TABLE `machine_material` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `machine_id` bigint(20) unsigned NOT NULL,
  `material_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `machine_material_machine_id_material_id_unique` (`machine_id`,`material_id`),
  KEY `machine_material_material_id_foreign` (`material_id`),
  CONSTRAINT `machine_material_machine_id_foreign` FOREIGN KEY (`machine_id`) REFERENCES `machines` (`id`) ON DELETE CASCADE,
  CONSTRAINT `machine_material_material_id_foreign` FOREIGN KEY (`material_id`) REFERENCES `materials` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: machine_material_category
CREATE TABLE `machine_material_category` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `machine_id` bigint(20) unsigned NOT NULL,
  `material_category_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `machine_category_unique` (`machine_id`,`material_category_id`),
  KEY `machine_material_category_material_category_id_foreign` (`material_category_id`),
  CONSTRAINT `machine_material_category_machine_id_foreign` FOREIGN KEY (`machine_id`) REFERENCES `machines` (`id`) ON DELETE CASCADE,
  CONSTRAINT `machine_material_category_material_category_id_foreign` FOREIGN KEY (`material_category_id`) REFERENCES `material_categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `machine_material_category` (`id`, `machine_id`, `material_category_id`) VALUES ('1', '1', '4');

-- Table: machines
CREATE TABLE `machines` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `cost_per_click` decimal(12,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `machines` (`id`, `name`, `description`, `is_active`, `cost_per_click`, `created_at`, `updated_at`) VALUES ('1', 'Versant 3100 press', NULL, '1', '700.00', '2026-02-15 09:04:05', '2026-02-15 09:04:05');

-- Table: material_categories
CREATE TABLE `material_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `material_categories` (`id`, `name`, `description`, `is_active`, `created_at`, `updated_at`) VALUES ('1', 'Outdoor', 'Bahan banner dan spanduk', '1', '2026-02-09 13:27:05', '2026-02-12 21:19:34');
INSERT INTO `material_categories` (`id`, `name`, `description`, `is_active`, `created_at`, `updated_at`) VALUES ('2', 'Indoor', 'Berbagai jenis sticker meteran', '1', '2026-02-09 13:27:05', '2026-02-12 21:20:37');
INSERT INTO `material_categories` (`id`, `name`, `description`, `is_active`, `created_at`, `updated_at`) VALUES ('4', 'Versant', 'Art paper, HVS, karton', '1', '2026-02-09 13:27:05', '2026-02-12 21:19:57');
INSERT INTO `material_categories` (`id`, `name`, `description`, `is_active`, `created_at`, `updated_at`) VALUES ('7', 'Lainnya', 'Material lainnya', '1', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `material_categories` (`id`, `name`, `description`, `is_active`, `created_at`, `updated_at`) VALUES ('8', 'Jasa', 'Semua jasa, jasa cutting besar/kecil , jasa finishing idcard dll.', '1', '2026-02-12 21:12:38', '2026-02-12 21:23:51');

-- Table: material_prices
CREATE TABLE `material_prices` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `material_id` bigint(20) unsigned NOT NULL,
  `member_type` enum('umum','studio') NOT NULL DEFAULT 'umum',
  `sisi` tinyint(4) NOT NULL DEFAULT 1 COMMENT 'Jumlah sisi cetak: 1 atau 2',
  `min_qty` int(11) NOT NULL DEFAULT 1 COMMENT 'Qty minimal (inclusive)',
  `max_qty` int(11) DEFAULT NULL COMMENT 'Qty maksimal (inclusive), null = unlimited',
  `price` decimal(15,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `material_prices_material_id_sisi_min_qty_index` (`material_id`,`sisi`,`min_qty`),
  CONSTRAINT `material_prices_material_id_foreign` FOREIGN KEY (`material_id`) REFERENCES `materials` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=869 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('231', '70', 'umum', '1', '1', NULL, '0.00', '2026-02-18 14:10:42', '2026-02-18 14:10:42');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('232', '70', 'studio', '1', '1', NULL, '0.00', '2026-02-18 14:10:42', '2026-02-18 14:10:42');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('345', '94', 'umum', '1', '1', NULL, '0.00', '2026-02-18 14:45:41', '2026-02-18 14:45:41');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('346', '94', 'studio', '1', '1', NULL, '0.00', '2026-02-18 14:45:41', '2026-02-18 14:45:41');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('527', '79', 'umum', '1', '1', NULL, '160000.00', '2026-02-19 11:07:11', '2026-02-19 11:07:11');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('528', '79', 'studio', '1', '1', NULL, '160000.00', '2026-02-19 11:07:11', '2026-02-19 11:07:11');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('613', '62', 'umum', '1', '1', NULL, '115000.00', '2026-03-01 09:24:17', '2026-03-01 09:24:17');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('614', '62', 'studio', '1', '1', NULL, '115000.00', '2026-03-01 09:24:17', '2026-03-01 09:24:17');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('615', '47', 'umum', '1', '1', '25', '2600.00', '2026-03-01 09:24:30', '2026-03-01 09:24:30');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('616', '47', 'studio', '1', '1', '25', '2600.00', '2026-03-01 09:24:30', '2026-03-01 09:24:30');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('617', '47', 'umum', '1', '25', NULL, '2400.00', '2026-03-01 09:24:30', '2026-03-01 09:24:30');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('618', '47', 'studio', '1', '25', NULL, '2400.00', '2026-03-01 09:24:30', '2026-03-01 09:24:30');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('619', '47', 'umum', '2', '1', '25', '3800.00', '2026-03-01 09:24:30', '2026-03-01 09:24:30');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('620', '47', 'studio', '2', '1', '25', '3800.00', '2026-03-01 09:24:30', '2026-03-01 09:24:30');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('621', '47', 'umum', '2', '25', NULL, '3600.00', '2026-03-01 09:24:30', '2026-03-01 09:24:30');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('622', '47', 'studio', '2', '25', NULL, '3600.00', '2026-03-01 09:24:30', '2026-03-01 09:24:30');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('623', '48', 'umum', '1', '1', '25', '2700.00', '2026-03-01 09:24:43', '2026-03-01 09:24:43');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('624', '48', 'studio', '1', '1', '25', '2700.00', '2026-03-01 09:24:43', '2026-03-01 09:24:43');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('625', '48', 'umum', '1', '25', NULL, '2500.00', '2026-03-01 09:24:43', '2026-03-01 09:24:43');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('626', '48', 'studio', '1', '25', NULL, '2500.00', '2026-03-01 09:24:43', '2026-03-01 09:24:43');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('627', '48', 'umum', '2', '1', '25', '3900.00', '2026-03-01 09:24:43', '2026-03-01 09:24:43');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('628', '48', 'studio', '2', '1', '25', '3900.00', '2026-03-01 09:24:43', '2026-03-01 09:24:43');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('629', '48', 'umum', '2', '25', NULL, '3700.00', '2026-03-01 09:24:43', '2026-03-01 09:24:43');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('630', '48', 'studio', '2', '25', NULL, '3700.00', '2026-03-01 09:24:43', '2026-03-01 09:24:43');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('631', '49', 'umum', '1', '1', '25', '2900.00', '2026-03-01 09:24:54', '2026-03-01 09:24:54');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('632', '49', 'studio', '1', '1', '25', '2900.00', '2026-03-01 09:24:54', '2026-03-01 09:24:54');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('633', '49', 'umum', '1', '25', NULL, '2700.00', '2026-03-01 09:24:54', '2026-03-01 09:24:54');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('634', '49', 'studio', '1', '25', NULL, '2700.00', '2026-03-01 09:24:54', '2026-03-01 09:24:54');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('635', '49', 'umum', '2', '1', '25', '4100.00', '2026-03-01 09:24:54', '2026-03-01 09:24:54');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('636', '49', 'studio', '2', '1', '25', '4100.00', '2026-03-01 09:24:54', '2026-03-01 09:24:54');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('637', '49', 'umum', '2', '25', NULL, '3900.00', '2026-03-01 09:24:54', '2026-03-01 09:24:54');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('638', '49', 'studio', '2', '25', NULL, '3900.00', '2026-03-01 09:24:54', '2026-03-01 09:24:54');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('639', '50', 'umum', '1', '1', '25', '3300.00', '2026-03-01 09:25:09', '2026-03-01 09:25:09');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('640', '50', 'studio', '1', '1', '25', '3300.00', '2026-03-01 09:25:09', '2026-03-01 09:25:09');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('641', '50', 'umum', '1', '25', NULL, '3100.00', '2026-03-01 09:25:09', '2026-03-01 09:25:09');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('642', '50', 'studio', '1', '25', NULL, '3100.00', '2026-03-01 09:25:09', '2026-03-01 09:25:09');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('643', '50', 'umum', '2', '1', '25', '4100.00', '2026-03-01 09:25:09', '2026-03-01 09:25:09');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('644', '50', 'studio', '2', '1', '25', '4100.00', '2026-03-01 09:25:09', '2026-03-01 09:25:09');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('645', '50', 'umum', '2', '25', NULL, '3900.00', '2026-03-01 09:25:09', '2026-03-01 09:25:09');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('646', '50', 'studio', '2', '25', NULL, '3900.00', '2026-03-01 09:25:09', '2026-03-01 09:25:09');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('647', '44', 'umum', '1', '1', '25', '2200.00', '2026-03-01 09:25:21', '2026-03-01 09:25:21');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('648', '44', 'studio', '1', '1', '25', '2200.00', '2026-03-01 09:25:21', '2026-03-01 09:25:21');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('649', '44', 'umum', '1', '25', NULL, '3200.00', '2026-03-01 09:25:21', '2026-03-01 09:25:21');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('650', '44', 'studio', '1', '25', NULL, '3200.00', '2026-03-01 09:25:21', '2026-03-01 09:25:21');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('651', '44', 'umum', '2', '1', '25', '3400.00', '2026-03-01 09:25:21', '2026-03-01 09:25:21');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('652', '44', 'studio', '2', '1', '25', '3400.00', '2026-03-01 09:25:21', '2026-03-01 09:25:21');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('653', '45', 'umum', '1', '1', '25', '2300.00', '2026-03-01 09:25:34', '2026-03-01 09:25:34');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('654', '45', 'studio', '1', '1', '25', '2300.00', '2026-03-01 09:25:34', '2026-03-01 09:25:34');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('655', '45', 'umum', '1', '25', NULL, '2100.00', '2026-03-01 09:25:34', '2026-03-01 09:25:34');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('656', '45', 'studio', '1', '25', NULL, '2100.00', '2026-03-01 09:25:34', '2026-03-01 09:25:34');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('657', '45', 'umum', '2', '1', '25', '3500.00', '2026-03-01 09:25:34', '2026-03-01 09:25:34');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('658', '45', 'studio', '2', '1', '25', '3500.00', '2026-03-01 09:25:34', '2026-03-01 09:25:34');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('659', '45', 'umum', '2', '25', NULL, '3200.00', '2026-03-01 09:25:34', '2026-03-01 09:25:34');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('660', '45', 'studio', '2', '25', NULL, '3200.00', '2026-03-01 09:25:34', '2026-03-01 09:25:34');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('669', '46', 'umum', '1', '1', '25', '2600.00', '2026-03-01 09:26:10', '2026-03-01 09:26:10');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('670', '46', 'studio', '1', '1', '25', '26000.00', '2026-03-01 09:26:10', '2026-03-01 09:26:10');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('671', '46', 'umum', '1', '25', NULL, '2400.00', '2026-03-01 09:26:10', '2026-03-01 09:26:10');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('672', '46', 'studio', '1', '25', NULL, '2400.00', '2026-03-01 09:26:10', '2026-03-01 09:26:10');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('673', '46', 'umum', '2', '1', '25', '3700.00', '2026-03-01 09:26:10', '2026-03-01 09:26:10');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('674', '46', 'studio', '2', '1', '25', '3700.00', '2026-03-01 09:26:10', '2026-03-01 09:26:10');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('675', '46', 'umum', '2', '25', NULL, '3500.00', '2026-03-01 09:26:10', '2026-03-01 09:26:10');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('676', '46', 'studio', '2', '25', NULL, '3500.00', '2026-03-01 09:26:10', '2026-03-01 09:26:10');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('677', '55', 'umum', '1', '1', '25', '3000.00', '2026-03-01 09:26:22', '2026-03-01 09:26:22');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('678', '55', 'studio', '1', '1', '25', '3000.00', '2026-03-01 09:26:22', '2026-03-01 09:26:22');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('679', '55', 'umum', '1', '25', NULL, '2800.00', '2026-03-01 09:26:22', '2026-03-01 09:26:22');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('680', '55', 'studio', '1', '25', NULL, '2800.00', '2026-03-01 09:26:22', '2026-03-01 09:26:22');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('681', '55', 'umum', '2', '1', '25', '4200.00', '2026-03-01 09:26:22', '2026-03-01 09:26:22');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('682', '55', 'studio', '2', '1', '25', '4200.00', '2026-03-01 09:26:22', '2026-03-01 09:26:22');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('683', '55', 'umum', '2', '25', NULL, '4000.00', '2026-03-01 09:26:22', '2026-03-01 09:26:22');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('684', '55', 'studio', '2', '25', NULL, '4000.00', '2026-03-01 09:26:22', '2026-03-01 09:26:22');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('685', '89', 'umum', '1', '1', NULL, '70000.00', '2026-03-01 09:26:39', '2026-03-01 09:26:39');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('686', '89', 'studio', '1', '1', NULL, '70000.00', '2026-03-01 09:26:39', '2026-03-01 09:26:39');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('687', '77', 'umum', '1', '1', NULL, '145000.00', '2026-03-01 09:26:50', '2026-03-01 09:26:50');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('688', '77', 'studio', '1', '1', NULL, '145000.00', '2026-03-01 09:26:50', '2026-03-01 09:26:50');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('689', '76', 'umum', '1', '1', NULL, '25000.00', '2026-03-01 09:27:07', '2026-03-01 09:27:07');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('690', '76', 'studio', '1', '1', NULL, '25000.00', '2026-03-01 09:27:07', '2026-03-01 09:27:07');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('691', '54', 'umum', '1', '1', '25', '3000.00', '2026-03-01 09:27:23', '2026-03-01 09:27:23');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('692', '54', 'studio', '1', '1', '25', '3000.00', '2026-03-01 09:27:23', '2026-03-01 09:27:23');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('693', '54', 'umum', '1', '25', NULL, '2800.00', '2026-03-01 09:27:23', '2026-03-01 09:27:23');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('694', '54', 'studio', '1', '25', NULL, '2800.00', '2026-03-01 09:27:23', '2026-03-01 09:27:23');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('695', '54', 'umum', '2', '1', '25', '4000.00', '2026-03-01 09:27:23', '2026-03-01 09:27:23');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('696', '54', 'studio', '2', '1', '25', '4000.00', '2026-03-01 09:27:23', '2026-03-01 09:27:23');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('697', '54', 'umum', '2', '25', NULL, '3800.00', '2026-03-01 09:27:23', '2026-03-01 09:27:23');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('698', '54', 'studio', '2', '25', NULL, '3800.00', '2026-03-01 09:27:23', '2026-03-01 09:27:23');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('703', '91', 'umum', '1', '1', '25', '2500.00', '2026-03-01 09:28:07', '2026-03-01 09:28:07');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('704', '91', 'studio', '1', '1', '25', '2500.00', '2026-03-01 09:28:07', '2026-03-01 09:28:07');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('705', '91', 'umum', '1', '25', NULL, '2300.00', '2026-03-01 09:28:07', '2026-03-01 09:28:07');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('706', '91', 'studio', '1', '25', NULL, '2300.00', '2026-03-01 09:28:07', '2026-03-01 09:28:07');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('707', '99', 'umum', '1', '1', NULL, '10000.00', '2026-03-01 09:28:51', '2026-03-01 09:28:51');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('708', '99', 'studio', '1', '1', NULL, '10000.00', '2026-03-01 09:28:51', '2026-03-01 09:28:51');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('709', '92', 'umum', '1', '1', '25', '2500.00', '2026-03-01 09:29:02', '2026-03-01 09:29:02');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('710', '92', 'studio', '1', '1', '25', '2500.00', '2026-03-01 09:29:02', '2026-03-01 09:29:02');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('711', '92', 'umum', '1', '25', NULL, '2300.00', '2026-03-01 09:29:02', '2026-03-01 09:29:02');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('712', '92', 'studio', '1', '25', NULL, '2300.00', '2026-03-01 09:29:02', '2026-03-01 09:29:02');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('713', '98', 'umum', '1', '1', NULL, '10000.00', '2026-03-01 09:29:21', '2026-03-01 09:29:21');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('714', '98', 'studio', '1', '1', NULL, '100000.00', '2026-03-01 09:29:21', '2026-03-01 09:29:21');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('715', '78', 'umum', '1', '1', NULL, '130000.00', '2026-03-01 09:29:36', '2026-03-01 09:29:36');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('716', '78', 'studio', '1', '1', NULL, '130000.00', '2026-03-01 09:29:36', '2026-03-01 09:29:36');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('717', '102', 'umum', '1', '1', NULL, '800000.00', '2026-03-01 09:29:48', '2026-03-01 09:29:48');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('718', '102', 'studio', '1', '1', NULL, '800000.00', '2026-03-01 09:29:48', '2026-03-01 09:29:48');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('719', '85', 'umum', '1', '1', NULL, '15000.00', '2026-03-01 09:30:07', '2026-03-01 09:30:07');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('720', '85', 'studio', '1', '1', NULL, '15000.00', '2026-03-01 09:30:07', '2026-03-01 09:30:07');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('723', '86', 'umum', '1', '1', NULL, '25000.00', '2026-03-01 09:31:00', '2026-03-01 09:31:00');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('724', '86', 'studio', '1', '1', NULL, '25000.00', '2026-03-01 09:31:00', '2026-03-01 09:31:00');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('725', '88', 'umum', '1', '1', NULL, '45000.00', '2026-03-01 09:31:20', '2026-03-01 09:31:20');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('726', '88', 'studio', '1', '1', NULL, '45000.00', '2026-03-01 09:31:20', '2026-03-01 09:31:20');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('727', '87', 'umum', '1', '1', NULL, '30000.00', '2026-03-01 09:31:39', '2026-03-01 09:31:39');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('728', '87', 'studio', '1', '1', NULL, '30000.00', '2026-03-01 09:31:39', '2026-03-01 09:31:39');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('729', '51', 'umum', '1', '1', '25', '1800.00', '2026-03-01 09:31:59', '2026-03-01 09:31:59');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('730', '51', 'studio', '1', '1', '25', '1800.00', '2026-03-01 09:31:59', '2026-03-01 09:31:59');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('731', '51', 'umum', '1', '25', NULL, '1600.00', '2026-03-01 09:31:59', '2026-03-01 09:31:59');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('732', '51', 'studio', '1', '25', NULL, '1600.00', '2026-03-01 09:31:59', '2026-03-01 09:31:59');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('733', '51', 'umum', '2', '1', '25', '3000.00', '2026-03-01 09:31:59', '2026-03-01 09:31:59');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('734', '51', 'studio', '2', '1', '25', '3000.00', '2026-03-01 09:31:59', '2026-03-01 09:31:59');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('735', '51', 'umum', '2', '25', NULL, '2800.00', '2026-03-01 09:31:59', '2026-03-01 09:31:59');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('736', '51', 'studio', '2', '25', NULL, '2800.00', '2026-03-01 09:31:59', '2026-03-01 09:31:59');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('737', '75', 'umum', '1', '1', NULL, '100000.00', '2026-03-01 09:32:20', '2026-03-01 09:32:20');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('738', '75', 'studio', '1', '1', NULL, '100000.00', '2026-03-01 09:32:20', '2026-03-01 09:32:20');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('739', '90', 'umum', '1', '1', '25', '1800.00', '2026-03-01 09:32:52', '2026-03-01 09:32:52');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('740', '90', 'studio', '1', '1', '25', '1800.00', '2026-03-01 09:32:52', '2026-03-01 09:32:52');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('741', '90', 'umum', '1', '25', NULL, '1600.00', '2026-03-01 09:32:52', '2026-03-01 09:32:52');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('742', '90', 'studio', '1', '25', NULL, '1600.00', '2026-03-01 09:32:52', '2026-03-01 09:32:52');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('743', '90', 'umum', '2', '1', '25', '3000.00', '2026-03-01 09:32:52', '2026-03-01 09:32:52');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('744', '90', 'studio', '2', '1', '25', '3000.00', '2026-03-01 09:32:52', '2026-03-01 09:32:52');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('745', '90', 'umum', '2', '25', NULL, '2800.00', '2026-03-01 09:32:52', '2026-03-01 09:32:52');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('746', '90', 'studio', '2', '25', NULL, '2800.00', '2026-03-01 09:32:52', '2026-03-01 09:32:52');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('747', '97', 'umum', '1', '1', NULL, '15000.00', '2026-03-01 09:33:29', '2026-03-01 09:33:29');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('748', '97', 'studio', '1', '1', NULL, '15000.00', '2026-03-01 09:33:29', '2026-03-01 09:33:29');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('749', '69', 'umum', '1', '1', '25', '2500.00', '2026-03-01 09:33:56', '2026-03-01 09:33:56');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('750', '69', 'studio', '1', '1', '25', '2500.00', '2026-03-01 09:33:56', '2026-03-01 09:33:56');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('751', '69', 'umum', '1', '25', NULL, '2300.00', '2026-03-01 09:33:56', '2026-03-01 09:33:56');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('752', '69', 'studio', '1', '25', NULL, '2300.00', '2026-03-01 09:33:56', '2026-03-01 09:33:56');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('753', '95', 'umum', '1', '1', NULL, '15000.00', '2026-03-01 09:34:20', '2026-03-01 09:34:20');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('754', '95', 'studio', '1', '1', NULL, '15000.00', '2026-03-01 09:34:20', '2026-03-01 09:34:20');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('755', '96', 'umum', '1', '1', NULL, '2500.00', '2026-03-01 09:34:38', '2026-03-01 09:34:38');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('756', '96', 'studio', '1', '1', NULL, '2500.00', '2026-03-01 09:34:38', '2026-03-01 09:34:38');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('757', '84', 'umum', '1', '1', NULL, '30000.00', '2026-03-01 09:34:54', '2026-03-01 09:34:54');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('758', '84', 'studio', '1', '1', NULL, '30000.00', '2026-03-01 09:34:54', '2026-03-01 09:34:54');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('759', '83', 'umum', '1', '1', NULL, '30000.00', '2026-03-01 09:35:12', '2026-03-01 09:35:12');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('760', '83', 'studio', '1', '1', NULL, '30000.00', '2026-03-01 09:35:12', '2026-03-01 09:35:12');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('761', '100', 'umum', '1', '1', NULL, '0.00', '2026-03-01 09:39:05', '2026-03-01 09:39:05');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('762', '100', 'studio', '1', '1', NULL, '0.00', '2026-03-01 09:39:05', '2026-03-01 09:39:05');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('771', '52', 'umum', '1', '1', '25', '2800.00', '2026-03-01 09:40:41', '2026-03-01 09:40:41');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('772', '52', 'studio', '1', '1', '25', '2800.00', '2026-03-01 09:40:41', '2026-03-01 09:40:41');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('773', '52', 'umum', '1', '25', NULL, '2600.00', '2026-03-01 09:40:41', '2026-03-01 09:40:41');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('774', '52', 'studio', '1', '25', NULL, '2600.00', '2026-03-01 09:40:41', '2026-03-01 09:40:41');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('775', '52', 'umum', '2', '1', '25', '4000.00', '2026-03-01 09:40:41', '2026-03-01 09:40:41');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('776', '52', 'studio', '2', '1', '25', '4000.00', '2026-03-01 09:40:41', '2026-03-01 09:40:41');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('777', '52', 'umum', '2', '25', NULL, '3800.00', '2026-03-01 09:40:41', '2026-03-01 09:40:41');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('778', '52', 'studio', '2', '25', NULL, '3800.00', '2026-03-01 09:40:41', '2026-03-01 09:40:41');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('779', '93', 'umum', '1', '1', NULL, '0.00', '2026-03-01 09:40:58', '2026-03-01 09:40:58');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('780', '93', 'studio', '1', '1', NULL, '0.00', '2026-03-01 09:40:58', '2026-03-01 09:40:58');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('781', '68', 'umum', '1', '1', '25', '1500.00', '2026-03-01 09:41:35', '2026-03-01 09:41:35');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('782', '68', 'studio', '1', '1', '25', '1500.00', '2026-03-01 09:41:35', '2026-03-01 09:41:35');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('783', '68', 'umum', '1', '25', NULL, '1300.00', '2026-03-01 09:41:35', '2026-03-01 09:41:35');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('784', '68', 'studio', '1', '25', NULL, '1300.00', '2026-03-01 09:41:35', '2026-03-01 09:41:35');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('785', '68', 'umum', '2', '1', '25', '3000.00', '2026-03-01 09:41:35', '2026-03-01 09:41:35');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('786', '68', 'studio', '2', '1', '25', '3000.00', '2026-03-01 09:41:35', '2026-03-01 09:41:35');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('787', '68', 'umum', '2', '25', NULL, '2800.00', '2026-03-01 09:41:35', '2026-03-01 09:41:35');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('788', '68', 'studio', '2', '25', NULL, '2800.00', '2026-03-01 09:41:35', '2026-03-01 09:41:35');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('797', '67', 'umum', '1', '1', '25', '1500.00', '2026-03-01 09:42:45', '2026-03-01 09:42:45');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('798', '67', 'studio', '1', '1', '25', '1500.00', '2026-03-01 09:42:45', '2026-03-01 09:42:45');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('799', '67', 'umum', '1', '25', NULL, '1300.00', '2026-03-01 09:42:45', '2026-03-01 09:42:45');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('800', '67', 'studio', '1', '25', NULL, '1300.00', '2026-03-01 09:42:45', '2026-03-01 09:42:45');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('801', '67', 'umum', '2', '1', '25', '3000.00', '2026-03-01 09:42:45', '2026-03-01 09:42:45');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('802', '67', 'studio', '2', '1', '25', '3000.00', '2026-03-01 09:42:45', '2026-03-01 09:42:45');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('803', '67', 'umum', '2', '25', NULL, '2800.00', '2026-03-01 09:42:45', '2026-03-01 09:42:45');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('804', '67', 'studio', '2', '25', NULL, '2800.00', '2026-03-01 09:42:45', '2026-03-01 09:42:45');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('807', '81', 'umum', '1', '1', NULL, '0.00', '2026-03-01 09:43:26', '2026-03-01 09:43:26');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('808', '81', 'studio', '1', '1', NULL, '0.00', '2026-03-01 09:43:26', '2026-03-01 09:43:26');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('809', '53', 'umum', '1', '1', '25', '3200.00', '2026-03-01 09:43:45', '2026-03-01 09:43:45');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('810', '53', 'studio', '1', '1', '25', '3200.00', '2026-03-01 09:43:45', '2026-03-01 09:43:45');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('811', '53', 'umum', '1', '25', NULL, '3000.00', '2026-03-01 09:43:45', '2026-03-01 09:43:45');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('812', '53', 'studio', '1', '25', NULL, '3000.00', '2026-03-01 09:43:45', '2026-03-01 09:43:45');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('813', '53', 'umum', '2', '1', '25', '4200.00', '2026-03-01 09:43:45', '2026-03-01 09:43:45');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('814', '53', 'studio', '2', '1', '25', '4200.00', '2026-03-01 09:43:45', '2026-03-01 09:43:45');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('815', '53', 'umum', '2', '25', NULL, '4000.00', '2026-03-01 09:43:45', '2026-03-01 09:43:45');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('816', '53', 'studio', '2', '25', NULL, '4000.00', '2026-03-01 09:43:45', '2026-03-01 09:43:45');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('817', '63', 'umum', '1', '1', NULL, '115000.00', '2026-03-01 09:44:11', '2026-03-01 09:44:11');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('818', '63', 'studio', '1', '1', NULL, '115000.00', '2026-03-01 09:44:11', '2026-03-01 09:44:11');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('819', '82', 'umum', '1', '1', NULL, '0.00', '2026-03-01 09:47:16', '2026-03-01 09:47:16');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('820', '82', 'studio', '1', '1', NULL, '0.00', '2026-03-01 09:47:16', '2026-03-01 09:47:16');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('821', '101', 'umum', '1', '1', NULL, '95000.00', '2026-03-01 10:04:31', '2026-03-01 10:04:31');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('822', '101', 'studio', '1', '1', NULL, '95000.00', '2026-03-01 10:04:31', '2026-03-01 10:04:31');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('823', '80', 'umum', '1', '1', NULL, '0.00', '2026-03-01 10:06:42', '2026-03-01 10:06:42');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('824', '80', 'studio', '1', '1', NULL, '0.00', '2026-03-01 10:06:42', '2026-03-01 10:06:42');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('825', '61', 'umum', '1', '1', NULL, '0.00', '2026-03-01 10:07:07', '2026-03-01 10:07:07');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('826', '61', 'studio', '1', '1', NULL, '0.00', '2026-03-01 10:07:07', '2026-03-01 10:07:07');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('827', '59', 'umum', '1', '1', '25', '8100.00', '2026-03-01 10:07:25', '2026-03-01 10:07:25');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('828', '59', 'studio', '1', '1', '25', '8100.00', '2026-03-01 10:07:25', '2026-03-01 10:07:25');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('829', '59', 'umum', '1', '25', NULL, '7900.00', '2026-03-01 10:07:25', '2026-03-01 10:07:25');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('830', '59', 'studio', '1', '25', NULL, '7900.00', '2026-03-01 10:07:25', '2026-03-01 10:07:25');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('831', '60', 'umum', '1', '1', '25', '8100.00', '2026-03-01 10:07:46', '2026-03-01 10:07:46');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('832', '60', 'studio', '1', '1', '25', '8100.00', '2026-03-01 10:07:46', '2026-03-01 10:07:46');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('833', '60', 'umum', '1', '25', NULL, '7900.00', '2026-03-01 10:07:46', '2026-03-01 10:07:46');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('834', '60', 'studio', '1', '25', NULL, '7900.00', '2026-03-01 10:07:46', '2026-03-01 10:07:46');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('835', '66', 'umum', '1', '1', NULL, '0.00', '2026-03-01 10:08:21', '2026-03-01 10:08:21');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('836', '66', 'studio', '1', '1', NULL, '0.00', '2026-03-01 10:08:21', '2026-03-01 10:08:21');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('839', '64', 'umum', '1', '1', NULL, '0.00', '2026-03-01 10:09:04', '2026-03-01 10:09:04');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('840', '64', 'studio', '1', '1', NULL, '0.00', '2026-03-01 10:09:04', '2026-03-01 10:09:04');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('841', '58', 'umum', '1', '1', '25', '3300.00', '2026-03-01 10:09:28', '2026-03-01 10:09:28');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('842', '58', 'studio', '1', '1', '25', '3300.00', '2026-03-01 10:09:28', '2026-03-01 10:09:28');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('843', '58', 'umum', '1', '25', NULL, '3100.00', '2026-03-01 10:09:28', '2026-03-01 10:09:28');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('844', '58', 'studio', '1', '25', NULL, '3100.00', '2026-03-01 10:09:28', '2026-03-01 10:09:28');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('847', '72', 'umum', '1', '1', NULL, '0.00', '2026-03-01 10:10:15', '2026-03-01 10:10:15');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('848', '72', 'studio', '1', '1', NULL, '0.00', '2026-03-01 10:10:15', '2026-03-01 10:10:15');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('849', '56', 'umum', '1', '1', '25', '7000.00', '2026-03-01 10:10:34', '2026-03-01 10:10:34');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('850', '56', 'studio', '1', '1', '25', '7000.00', '2026-03-01 10:10:34', '2026-03-01 10:10:34');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('853', '74', 'umum', '1', '1', NULL, '0.00', '2026-03-01 10:11:53', '2026-03-01 10:11:53');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('854', '74', 'studio', '1', '1', NULL, '0.00', '2026-03-01 10:11:53', '2026-03-01 10:11:53');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('855', '71', 'umum', '1', '1', NULL, '0.00', '2026-03-01 10:12:18', '2026-03-01 10:12:18');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('856', '71', 'studio', '1', '1', NULL, '0.00', '2026-03-01 10:12:18', '2026-03-01 10:12:18');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('861', '57', 'umum', '1', '1', '25', '3300.00', '2026-03-01 10:18:31', '2026-03-01 10:18:31');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('862', '57', 'studio', '1', '1', '25', '3300.00', '2026-03-01 10:18:31', '2026-03-01 10:18:31');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('863', '57', 'umum', '1', '25', NULL, '3100.00', '2026-03-01 10:18:31', '2026-03-01 10:18:31');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('864', '57', 'studio', '1', '25', NULL, '3100.00', '2026-03-01 10:18:31', '2026-03-01 10:18:31');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('865', '65', 'umum', '1', '1', NULL, '0.00', '2026-03-01 10:19:39', '2026-03-01 10:19:39');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('866', '65', 'studio', '1', '1', NULL, '0.00', '2026-03-01 10:19:39', '2026-03-01 10:19:39');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('867', '73', 'umum', '1', '1', NULL, '0.00', '2026-03-01 10:22:07', '2026-03-01 10:22:07');
INSERT INTO `material_prices` (`id`, `material_id`, `member_type`, `sisi`, `min_qty`, `max_qty`, `price`, `created_at`, `updated_at`) VALUES ('868', '73', 'studio', '1', '1', NULL, '0.00', '2026-03-01 10:22:07', '2026-03-01 10:22:07');

-- Table: materials
CREATE TABLE `materials` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `category_id` bigint(20) unsigned DEFAULT NULL,
  `base_price` decimal(15,2) NOT NULL DEFAULT 0.00,
  `unit` varchar(255) NOT NULL DEFAULT 'pcs',
  `stock` decimal(15,2) NOT NULL DEFAULT 0.00,
  `min_stock` decimal(15,2) NOT NULL DEFAULT 0.00,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `track_clicks` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `materials_category_id_foreign` (`category_id`),
  CONSTRAINT `materials_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `material_categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('44', 'ART PAPPER 120 GSM', '4', '2200.00', 'lembar', '700.00', '100.00', '1', '1', '2026-02-17 21:27:33', '2026-03-01 09:25:21');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('45', 'ART PAPPER 150 GSM', '4', '2300.00', 'lembar', '1395.00', '0.00', '1', '1', '2026-02-18 02:49:31', '2026-03-01 07:34:22');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('46', 'ART PAPPER 190 GSM', '4', '2600.00', 'lembar', '375.00', '100.00', '1', '1', '2026-02-18 11:51:07', '2026-03-01 09:25:47');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('47', 'ART KARTON  210 GSM', '4', '2600.00', 'lembar', '375.00', '100.00', '1', '1', '2026-02-18 11:55:20', '2026-03-01 09:24:30');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('48', 'ART KARTON 230 GSM', '4', '2700.00', 'lembar', '750.00', '100.00', '1', '1', '2026-02-18 11:57:29', '2026-03-01 09:24:42');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('49', 'ART KARTON 260 GSM', '4', '2900.00', 'lembar', '229.00', '100.00', '1', '1', '2026-02-18 11:57:53', '2026-03-01 09:24:54');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('50', 'ART KARTON 310 GSM', '4', '3300.00', 'lembar', '300.00', '100.00', '1', '1', '2026-02-18 12:02:31', '2026-03-01 09:25:09');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('51', 'HVS 80 GSM', '4', '1800.00', 'lembar', '1000.00', '100.00', '1', '1', '2026-02-18 12:04:07', '2026-03-01 09:31:59');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('52', 'KERTAS BC PUTIH', '4', '2800.00', 'lembar', '225.00', '100.00', '1', '1', '2026-02-18 12:05:47', '2026-03-01 09:39:52');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('53', 'LINEN', '4', '3200.00', 'lembar', '220.00', '100.00', '1', '1', '2026-02-18 12:07:53', '2026-03-01 09:43:45');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('54', 'CONCORD', '4', '3000.00', 'lembar', '480.00', '100.00', '1', '1', '2026-02-18 12:09:51', '2026-03-01 09:27:23');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('55', 'ASTER', '4', '2900.00', 'lembar', '345.00', '100.00', '1', '1', '2026-02-18 12:11:33', '2026-03-01 09:26:22');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('56', 'MASTER', '4', '7000.00', 'lembar', '31.00', '1.00', '1', '0', '2026-02-18 12:12:41', '2026-03-01 10:10:34');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('57', 'STICKER CHROMO', '4', '3300.00', 'lembar', '35535.00', '1.00', '1', '0', '2026-02-18 12:13:58', '2026-03-01 10:12:42');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('58', 'STICKER CHROMO HVS', '4', '3100.00', 'lembar', '2914.00', '1.00', '1', '0', '2026-02-18 12:15:13', '2026-03-01 10:09:28');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('59', 'STICKER VINLY A3', '4', '8100.00', 'lembar', '3250.00', '1.00', '1', '0', '2026-02-18 13:53:59', '2026-03-01 10:07:25');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('60', 'STICKER VINLY A3 TRANSFARANT', '4', '8100.00', 'lembar', '1085.00', '1.00', '1', '0', '2026-02-18 13:55:26', '2026-03-01 10:07:46');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('61', 'STICKER VINLY METERAN', '2', '70000.00', 'm2', '680.00', '1.00', '1', '0', '2026-02-18 13:57:37', '2026-03-01 10:07:07');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('62', 'ALBATROS', '2', '115000.00', 'm2', '135.00', '10.00', '1', '0', '2026-02-18 13:58:14', '2026-03-01 09:24:17');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('63', 'LUSTER', '2', '115000.00', 'm2', '180.00', '1.00', '1', '0', '2026-02-18 13:58:54', '2026-03-01 09:44:11');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('64', 'STICKER HOLOGRAM', '2', '150000.00', 'm2', '55.00', '1.00', '1', '0', '2026-02-18 13:59:44', '2026-03-01 10:08:41');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('65', 'PET BACKLIT DUTRANS', '2', '130000.00', 'm2', '35.00', '1.00', '1', '0', '2026-02-18 14:00:37', '2026-03-01 10:19:39');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('66', 'STICKER ONE WAY', '2', '95000.00', 'm2', '40.00', '1.00', '1', '0', '2026-02-18 14:05:20', '2026-03-01 10:08:21');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('67', 'LAMINASI A3 MATTE', '4', '1500.00', 'pcs', '7500.00', '1.00', '1', '0', '2026-02-18 14:07:03', '2026-03-01 09:42:09');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('68', 'LAMINASI A3 GLOSSY', '4', '1500.00', 'pcs', '1250.00', '100.00', '1', '0', '2026-02-18 14:08:32', '2026-03-01 09:41:35');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('69', 'JASA CETAK ID CARD', '4', '2500.00', 'lembar', '1.00', '1.00', '1', '1', '2026-02-18 14:09:43', '2026-03-01 09:33:56');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('70', 'STANDING Y BENNER 60 X 160 CM', '2', '35000.00', 'pcs', '27.00', '0.00', '1', '0', '2026-02-18 14:10:42', '2026-03-01 07:10:32');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('71', 'STANDING Y BENNER 80 X 180', '2', '45000.00', 'pcs', '21.00', '1.00', '1', '0', '2026-02-18 14:11:11', '2026-03-01 10:09:47');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('72', 'ROOL UP 60 X 160 CM', '2', '150000.00', 'pcs', '1.00', '1.00', '1', '0', '2026-02-18 14:11:59', '2026-03-01 10:10:15');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('73', 'ROOL UP 80 X 180/200 CM', '2', '150000.00', 'pcs', '7.00', '1.00', '1', '0', '2026-02-18 14:12:51', '2026-03-01 10:11:33');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('74', 'STANDING TRIPOD BENNER TIFE T', '2', '125000.00', 'pcs', '3.00', '1.00', '1', '0', '2026-02-18 14:13:43', '2026-03-01 10:11:53');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('75', 'IMPRABOARD', '2', '100000.00', 'm2', '0.00', '1.00', '1', '0', '2026-02-18 14:24:22', '2026-03-01 09:32:20');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('76', 'CLOTH BENNER', '2', '25000.00', 'm2', '95.00', '1.00', '1', '0', '2026-02-18 14:25:04', '2026-03-01 09:27:07');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('77', 'CANVAS MATE 380 GSM', '2', '145000.00', 'm2', '47.00', '1.00', '1', '0', '2026-02-18 14:25:50', '2026-03-01 09:26:50');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('78', 'DOOR FRAME STANDAR', '2', '130000.00', 'pcs', '0.00', '1.00', '1', '0', '2026-02-18 14:26:30', '2026-03-01 09:29:36');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('79', 'DOOR FRAME WATER TANK', '2', '160000.00', 'pcs', '1.00', '0.00', '1', '0', '2026-02-18 14:26:58', '2026-03-01 07:16:12');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('80', 'STICKER VINLY METERAN CHINA', '2', '50000.00', 'm2', '120.00', '1.00', '1', '0', '2026-02-18 14:27:41', '2026-03-01 10:06:42');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('81', 'LAMINASI METERAN MATTE', '2', '15000.00', 'm2', '490.00', '1.00', '1', '0', '2026-02-18 14:28:53', '2026-03-01 09:43:26');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('82', 'LAMINASI METERAN GLOSSY', '2', '15000.00', 'm2', '820.00', '1.00', '1', '0', '2026-02-18 14:29:37', '2026-03-01 09:43:05');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('83', 'JASA LAMINASI MATTE', '2', '30000.00', 'm2', '0.00', '1.00', '1', '0', '2026-02-18 14:30:13', '2026-03-01 09:35:12');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('84', 'JASA LAMINASI GLOSSY', '2', '30000.00', 'm2', '0.00', '1.00', '1', '0', '2026-02-18 14:30:41', '2026-03-01 09:34:54');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('85', 'FLEKSI BENNER 280 GSM', '1', '15000.00', 'm2', '692.00', '1.00', '1', '0', '2026-02-18 14:33:09', '2026-03-01 09:30:07');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('86', 'FLEKSI BENNER 340 GSM', '1', '25000.00', 'm2', '90.00', '1.00', '1', '0', '2026-02-18 14:33:41', '2026-03-01 09:30:31');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('87', 'FLEKSI BENNER 440 GSM WHITE', '1', '30000.00', 'm2', '265.00', '1.00', '1', '0', '2026-02-18 14:34:17', '2026-03-01 09:31:39');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('88', 'FLEKSI BENNER 440 GSM BO', '1', '45000.00', 'm2', '95.00', '1.00', '1', '0', '2026-02-18 14:34:46', '2026-03-01 09:31:20');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('89', 'BACKLIT BENNER 510 GSM', '1', '70000.00', 'm2', '160.00', '1.00', '1', '0', '2026-02-18 14:35:21', '2026-03-01 09:26:39');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('90', 'JASA CETAK A3', '4', '1800.00', 'lembar', '0.00', '1.00', '1', '1', '2026-02-18 14:38:26', '2026-03-01 09:32:52');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('91', 'CUTTING A3 KIS CUT', '4', '2500.00', 'lembar', '100000000000.00', '1.00', '1', '0', '2026-02-18 14:39:31', '2026-03-01 10:24:21');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('92', 'CUTTING A3 DIE CUT', '4', '2500.00', 'LEMBAR', '100000000000.00', '1.00', '1', '0', '2026-02-18 14:40:20', '2026-03-01 10:25:30');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('93', 'KLEM KALENDER', '4', '700.00', 'pcs', '750.00', '1.00', '1', '0', '2026-02-18 14:45:06', '2026-03-01 09:40:58');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('94', 'LAMINASI KERAS A4', '4', '2000.00', 'lembar', '50.00', '0.00', '1', '0', '2026-02-18 14:45:41', '2026-03-01 08:23:39');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('95', 'JASA CETAK ID CARD BAHAN RK', '4', '15000.00', 'lembar', '0.00', '1.00', '1', '1', '2026-02-18 14:46:52', '2026-03-01 09:34:20');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('96', 'JASA FINISHING ID CARD', '4', '2500.00', 'lembar', '0.00', '1.00', '1', '0', '2026-02-18 14:47:34', '2026-03-01 09:34:38');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('97', 'JASA CETAK BAHAN OSCAR', '1', '15000.00', 'm2', '0.00', '1.00', '1', '0', '2026-02-18 14:48:05', '2026-03-01 09:33:29');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('98', 'CUTTING KISS CUT METERAN', '8', '10000.00', 'm2', '10000000000.00', '1.00', '1', '0', '2026-02-27 13:46:12', '2026-03-01 10:26:05');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('99', 'CUTTING DIE CUT METERAN', '8', '10000.00', 'm2', '10000000000.00', '1.00', '1', '0', '2026-02-27 13:46:38', '2026-03-01 10:26:45');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('100', 'JASA POTONG', '8', '15000.00', 'kg', '0.00', '1.00', '1', '0', '2026-02-27 13:51:08', '2026-03-01 09:39:05');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('101', 'STICKER VINLY TRANSFARANT  METERAN', '2', '95000.00', 'M2', '60.00', '1.00', '1', '0', '2026-02-28 16:39:20', '2026-03-01 10:04:31');
INSERT INTO `materials` (`id`, `name`, `category_id`, `base_price`, `unit`, `stock`, `min_stock`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('102', 'EVENT DESK', '2', '800000.00', 'pcs', '1.00', '1.00', '1', '0', '2026-03-01 07:22:24', '2026-03-01 09:29:48');

-- Table: migrations
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('1', '0001_01_01_000000_create_users_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('2', '0001_01_01_000001_create_cache_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('3', '0001_01_01_000002_create_jobs_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('4', '2024_01_01_000001_add_role_to_users_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('5', '2024_01_01_000002_create_orders_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('6', '2024_01_01_000003_create_materials_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('7', '2024_01_01_000004_create_settings_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('8', '2026_01_30_010905_create_permission_tables', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('9', '2026_01_30_014026_create_customers_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('10', '2026_01_30_014034_add_customer_id_to_orders_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('11', '2026_01_30_100001_create_products_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('12', '2026_01_30_100002_create_order_items_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('13', '2026_01_30_100003_modify_orders_for_multi_items', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('14', '2026_01_30_100004_create_product_material_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('15', '2026_01_30_120000_add_track_clicks_to_products_and_materials', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('16', '2026_02_07_214900_add_member_type_to_customers_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('17', '2026_02_07_221200_create_employees_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('18', '2026_02_07_221201_create_salaries_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('19', '2026_02_07_223400_add_stock_to_materials_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('20', '2026_02_07_223401_create_purchases_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('21', '2026_02_07_223402_create_expense_categories_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('22', '2026_02_07_223403_create_expenses_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('23', '2026_02_07_225000_create_suppliers_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('24', '2026_02_08_000001_add_pickup_status_to_orders_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('25', '2026_02_08_000002_create_material_categories_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('26', '2026_02_08_000003_create_stock_movements_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('27', '2026_02_08_000004_add_category_id_to_materials_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('28', '2026_02_08_000005_create_deposits_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('29', '2026_02_08_000006_create_units_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('30', '2026_02_09_020000_create_payments_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('31', '2026_02_09_020001_add_partial_status_to_orders_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('32', '2026_02_09_025400_add_is_credit_to_orders_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('33', '2026_02_09_100000_add_production_status_to_order_items_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('34', '2026_02_09_100001_create_cash_modals_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('35', '2026_02_09_100002_create_cash_mutations_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('36', '2026_02_09_123128_create_payment_accounts_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('37', '2026_02_09_123241_add_payment_account_id_to_payments_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('38', '2026_02_09_132207_add_payment_account_id_to_deposits_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('39', '2026_02_09_133337_add_payment_fields_to_purchases_table', '2');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('40', '2026_02_09_133340_create_purchase_payments_table', '2');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('41', '2026_02_10_000001_add_cancellation_to_orders_and_items', '3');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('42', '2026_02_10_000002_create_order_cancellation_requests_table', '3');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('43', '2026_02_10_000003_add_spv_to_users_role_enum', '4');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('44', '2026_02_14_220000_create_machines_table', '5');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('45', '2026_02_14_220001_create_machine_material_category_table', '6');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('46', '2026_02_14_220002_create_machine_material_table', '7');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('47', '2026_02_15_000001_create_material_prices_table', '8');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('48', '2026_02_15_000002_add_sisi_to_order_items_table', '9');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('49', '2026_02_15_003000_add_cost_per_click_to_machines_table', '10');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('50', '2026_02_12_135100_change_users_role_to_varchar', '11');

-- Table: model_has_permissions
CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: model_has_roles
CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ('1', 'App\\Models\\User', '1');
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ('2', 'App\\Models\\User', '2');
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ('3', 'App\\Models\\User', '3');
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ('3', 'App\\Models\\User', '4');
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ('3', 'App\\Models\\User', '12');
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ('3', 'App\\Models\\User', '15');
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ('3', 'App\\Models\\User', '19');
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ('3', 'App\\Models\\User', '20');
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ('3', 'App\\Models\\User', '23');
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ('4', 'App\\Models\\User', '5');
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ('5', 'App\\Models\\User', '6');
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ('5', 'App\\Models\\User', '7');
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ('5', 'App\\Models\\User', '9');
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ('5', 'App\\Models\\User', '10');
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ('5', 'App\\Models\\User', '13');
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ('5', 'App\\Models\\User', '14');
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ('5', 'App\\Models\\User', '17');
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ('5', 'App\\Models\\User', '18');
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ('5', 'App\\Models\\User', '21');
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ('5', 'App\\Models\\User', '22');
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ('5', 'App\\Models\\User', '24');
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ('5', 'App\\Models\\User', '25');
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ('5', 'App\\Models\\User', '26');
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ('6', 'App\\Models\\User', '8');
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ('6', 'App\\Models\\User', '11');
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ('7', 'App\\Models\\User', '16');

-- Table: order_cancellation_requests
CREATE TABLE `order_cancellation_requests` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned NOT NULL,
  `order_item_id` bigint(20) unsigned DEFAULT NULL,
  `type` enum('order','item') NOT NULL,
  `requested_by` bigint(20) unsigned NOT NULL,
  `reason` text NOT NULL,
  `status` enum('pending','approved','rejected') NOT NULL DEFAULT 'pending',
  `reviewed_by` bigint(20) unsigned DEFAULT NULL,
  `reviewed_at` timestamp NULL DEFAULT NULL,
  `review_notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_cancellation_requests_order_item_id_foreign` (`order_item_id`),
  KEY `order_cancellation_requests_requested_by_foreign` (`requested_by`),
  KEY `order_cancellation_requests_reviewed_by_foreign` (`reviewed_by`),
  KEY `order_cancellation_requests_status_index` (`status`),
  KEY `order_cancellation_requests_order_id_status_index` (`order_id`,`status`),
  CONSTRAINT `order_cancellation_requests_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `order_cancellation_requests_order_item_id_foreign` FOREIGN KEY (`order_item_id`) REFERENCES `order_items` (`id`) ON DELETE CASCADE,
  CONSTRAINT `order_cancellation_requests_requested_by_foreign` FOREIGN KEY (`requested_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `order_cancellation_requests_reviewed_by_foreign` FOREIGN KEY (`reviewed_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: order_items
CREATE TABLE `order_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned NOT NULL,
  `product_id` bigint(20) unsigned DEFAULT NULL,
  `product_name` varchar(255) NOT NULL,
  `material_id` bigint(20) unsigned DEFAULT NULL,
  `material_name` varchar(255) DEFAULT NULL,
  `file_name` varchar(255) NOT NULL,
  `file_path` varchar(255) DEFAULT NULL,
  `size_description` varchar(255) NOT NULL,
  `size_value` decimal(10,4) NOT NULL DEFAULT 1.0000,
  `size_unit` varchar(255) NOT NULL DEFAULT 'm2',
  `qty` int(11) NOT NULL DEFAULT 1,
  `sisi` tinyint(4) NOT NULL DEFAULT 1 COMMENT 'Jumlah sisi cetak',
  `base_price` decimal(15,2) NOT NULL DEFAULT 0.00,
  `calculated_price` decimal(15,2) NOT NULL DEFAULT 0.00,
  `subtotal` decimal(15,2) NOT NULL DEFAULT 0.00,
  `finishing_note` text DEFAULT NULL,
  `production_status` varchar(255) NOT NULL DEFAULT 'pending',
  `item_started_at` timestamp NULL DEFAULT NULL,
  `item_finished_at` timestamp NULL DEFAULT NULL,
  `is_cancelled` tinyint(1) NOT NULL DEFAULT 0,
  `cancelled_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `cancelled_by` bigint(20) unsigned DEFAULT NULL,
  `cancel_reason` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_items_product_id_foreign` (`product_id`),
  KEY `order_items_material_id_foreign` (`material_id`),
  KEY `order_items_order_id_index` (`order_id`),
  KEY `order_items_cancelled_by_foreign` (`cancelled_by`),
  KEY `order_items_is_cancelled_index` (`is_cancelled`),
  CONSTRAINT `order_items_cancelled_by_foreign` FOREIGN KEY (`cancelled_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `order_items_material_id_foreign` FOREIGN KEY (`material_id`) REFERENCES `materials` (`id`) ON DELETE SET NULL,
  CONSTRAINT `order_items_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `order_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: orders
CREATE TABLE `orders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `invoice_number` varchar(255) NOT NULL,
  `customer_id` bigint(20) unsigned DEFAULT NULL,
  `customer_name` varchar(255) NOT NULL,
  `customer_phone` varchar(255) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `total_price` decimal(15,2) NOT NULL,
  `paid_amount` decimal(15,2) NOT NULL DEFAULT 0.00,
  `change_amount` decimal(15,2) NOT NULL DEFAULT 0.00,
  `payment_status` enum('unpaid','partial','paid') DEFAULT 'unpaid',
  `is_credit` tinyint(1) NOT NULL DEFAULT 0,
  `paid_at` timestamp NULL DEFAULT NULL,
  `production_status` enum('pending','proses_cetak','finishing','selesai') NOT NULL DEFAULT 'pending',
  `pickup_status` enum('not_picked_up','picked_up') NOT NULL DEFAULT 'not_picked_up',
  `picked_up_at` timestamp NULL DEFAULT NULL,
  `started_at` timestamp NULL DEFAULT NULL,
  `finished_at` timestamp NULL DEFAULT NULL,
  `designer_id` bigint(20) unsigned NOT NULL,
  `cashier_id` bigint(20) unsigned DEFAULT NULL,
  `operator_id` bigint(20) unsigned DEFAULT NULL,
  `spk_printed` tinyint(1) NOT NULL DEFAULT 0,
  `spk_printed_at` timestamp NULL DEFAULT NULL,
  `is_cancelled` tinyint(1) NOT NULL DEFAULT 0,
  `cancelled_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `cancelled_by` bigint(20) unsigned DEFAULT NULL,
  `cancel_reason` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `orders_invoice_number_unique` (`invoice_number`),
  KEY `orders_designer_id_foreign` (`designer_id`),
  KEY `orders_cashier_id_foreign` (`cashier_id`),
  KEY `orders_operator_id_foreign` (`operator_id`),
  KEY `orders_payment_status_index` (`payment_status`),
  KEY `orders_production_status_index` (`production_status`),
  KEY `orders_created_at_index` (`created_at`),
  KEY `orders_customer_id_foreign` (`customer_id`),
  KEY `orders_pickup_status_index` (`pickup_status`),
  KEY `orders_cancelled_by_foreign` (`cancelled_by`),
  KEY `orders_is_cancelled_index` (`is_cancelled`),
  CONSTRAINT `orders_cancelled_by_foreign` FOREIGN KEY (`cancelled_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `orders_cashier_id_foreign` FOREIGN KEY (`cashier_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `orders_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE SET NULL,
  CONSTRAINT `orders_designer_id_foreign` FOREIGN KEY (`designer_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `orders_operator_id_foreign` FOREIGN KEY (`operator_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: payment_accounts
CREATE TABLE `payment_accounts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `type` enum('bank','ewallet') NOT NULL,
  `provider` varchar(255) NOT NULL,
  `account_number` varchar(255) NOT NULL,
  `account_holder` varchar(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `payment_accounts` (`id`, `name`, `type`, `provider`, `account_number`, `account_holder`, `is_active`, `created_at`, `updated_at`) VALUES ('8', 'BCA', 'bank', 'BCA', '2920858026', 'Raden Cik Awang', '1', '2026-02-12 18:17:51', '2026-02-27 13:35:53');
INSERT INTO `payment_accounts` (`id`, `name`, `type`, `provider`, `account_number`, `account_holder`, `is_active`, `created_at`, `updated_at`) VALUES ('10', 'Mandiri', 'bank', 'Mandiri', '1120005038182', 'Raden Cik Awang', '1', '2026-02-27 13:36:18', '2026-02-27 13:36:18');

-- Table: payments
CREATE TABLE `payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `payment_method` varchar(255) NOT NULL DEFAULT 'cash',
  `payment_account_id` bigint(20) unsigned DEFAULT NULL,
  `proof_path` varchar(255) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `cashier_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `payments_cashier_id_foreign` (`cashier_id`),
  KEY `payments_order_id_index` (`order_id`),
  KEY `payments_created_at_index` (`created_at`),
  KEY `payments_payment_account_id_foreign` (`payment_account_id`),
  CONSTRAINT `payments_cashier_id_foreign` FOREIGN KEY (`cashier_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `payments_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `payments_payment_account_id_foreign` FOREIGN KEY (`payment_account_id`) REFERENCES `payment_accounts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: permissions
CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('1', 'manage users', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('2', 'create orders', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('3', 'process payments', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('4', 'update production', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('5', 'view reports', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('6', 'view click reports', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('7', 'print spk', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('8', 'management access', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('9', 'view customers', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('10', 'create customers', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('11', 'edit customers', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('12', 'delete customers', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('13', 'view products', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('14', 'create products', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('15', 'edit products', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('16', 'delete products', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('17', 'view units', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('18', 'manage units', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('19', 'view suppliers', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('20', 'manage suppliers', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('21', 'view finance', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('22', 'manage deposits', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('23', 'view stock', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('24', 'manage stock', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('25', 'view materials', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('26', 'manage materials', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('27', 'view expenses', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('28', 'manage expenses', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('29', 'view employees', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('30', 'create employees', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('31', 'edit employees', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('32', 'delete employees', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('33', 'view salaries', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('34', 'create salaries', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('35', 'edit salaries', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('36', 'delete salaries', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('37', 'manage backups', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('38', 'manage payment accounts', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('39', 'request cancellations', 'web', '2026-02-10 01:47:14', '2026-02-10 01:47:14');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('40', 'approve cancellations', 'web', '2026-02-10 01:47:14', '2026-02-10 01:47:14');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('41', 'view orders', 'web', '2026-02-10 08:23:29', '2026-02-10 08:23:29');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('42', 'view machines', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('43', 'manage machines', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');

-- Table: product_material
CREATE TABLE `product_material` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint(20) unsigned NOT NULL,
  `material_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `product_material_product_id_material_id_unique` (`product_id`,`material_id`),
  KEY `product_material_material_id_foreign` (`material_id`),
  CONSTRAINT `product_material_material_id_foreign` FOREIGN KEY (`material_id`) REFERENCES `materials` (`id`) ON DELETE CASCADE,
  CONSTRAINT `product_material_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('87', '21', '44', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('88', '21', '45', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('89', '21', '47', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('90', '21', '48', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('91', '21', '49', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('92', '21', '50', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('93', '21', '46', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('94', '21', '55', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('95', '21', '54', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('96', '21', '51', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('97', '21', '52', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('98', '21', '53', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('99', '21', '56', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('100', '21', '58', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('101', '21', '59', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('102', '21', '60', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('103', '21', '57', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('104', '23', '89', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('106', '23', '85', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('107', '23', '86', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('108', '23', '87', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('109', '23', '88', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('110', '22', '64', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('111', '22', '66', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('112', '22', '80', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('113', '22', '61', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('114', '22', '65', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('115', '22', '63', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('116', '22', '77', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('117', '23', '97', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('118', '22', '76', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('119', '22', '78', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('120', '22', '79', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('121', '22', '75', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('122', '22', '83', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('123', '22', '84', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('124', '22', '82', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('125', '22', '81', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('126', '22', '72', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('127', '22', '74', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('128', '22', '73', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('129', '22', '70', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('130', '22', '71', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('131', '21', '90', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('132', '21', '69', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('133', '21', '96', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('134', '21', '95', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('135', '21', '93', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('136', '21', '67', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('137', '21', '68', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('138', '21', '94', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('139', '22', '62', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('140', '24', '92', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('141', '24', '91', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('142', '24', '99', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('143', '24', '98', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('144', '22', '101', NULL, NULL);

-- Table: products
CREATE TABLE `products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `unit_id` bigint(20) unsigned DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `track_clicks` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `products_code_unique` (`code`),
  KEY `products_is_active_index` (`is_active`),
  KEY `products_unit_id_foreign` (`unit_id`),
  CONSTRAINT `products_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `products` (`id`, `name`, `code`, `description`, `unit_id`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('21', 'Versant', 'VR0001', NULL, NULL, '1', '1', '2026-02-17 11:16:10', '2026-02-17 11:16:10');
INSERT INTO `products` (`id`, `name`, `code`, `description`, `unit_id`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('22', 'Indoor', 'ID0001', NULL, NULL, '1', '0', '2026-02-17 11:16:29', '2026-02-17 11:16:29');
INSERT INTO `products` (`id`, `name`, `code`, `description`, `unit_id`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('23', 'Outdoor', 'OD0001', NULL, NULL, '1', '0', '2026-02-17 11:16:49', '2026-02-17 11:16:49');
INSERT INTO `products` (`id`, `name`, `code`, `description`, `unit_id`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('24', 'Jasa', 'CUTA3', NULL, NULL, '1', '0', '2026-02-27 13:44:32', '2026-02-27 13:44:32');

-- Table: purchase_payments
CREATE TABLE `purchase_payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `purchase_id` bigint(20) unsigned NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `payment_date` date NOT NULL,
  `proof` varchar(255) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `purchase_payments_purchase_id_foreign` (`purchase_id`),
  KEY `purchase_payments_created_by_foreign` (`created_by`),
  CONSTRAINT `purchase_payments_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `purchase_payments_purchase_id_foreign` FOREIGN KEY (`purchase_id`) REFERENCES `purchases` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `purchase_payments` (`id`, `purchase_id`, `amount`, `payment_date`, `proof`, `notes`, `created_by`, `created_at`, `updated_at`) VALUES ('1', '1', '250000.00', '2026-02-25', NULL, 'Pembayaran lunas', '1', '2026-02-25 14:29:53', '2026-02-25 14:29:53');

-- Table: purchases
CREATE TABLE `purchases` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `material_id` bigint(20) unsigned NOT NULL,
  `purchase_date` date NOT NULL,
  `quantity` decimal(15,2) NOT NULL,
  `unit_price` decimal(15,2) NOT NULL DEFAULT 0.00,
  `total_price` decimal(15,2) NOT NULL DEFAULT 0.00,
  `paid_amount` decimal(15,2) NOT NULL DEFAULT 0.00,
  `payment_status` enum('unpaid','partial','paid') NOT NULL DEFAULT 'paid',
  `type` enum('satuan','meteran') NOT NULL DEFAULT 'satuan',
  `supplier` varchar(255) DEFAULT NULL,
  `supplier_id` bigint(20) unsigned DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `purchases_material_id_foreign` (`material_id`),
  KEY `purchases_created_by_foreign` (`created_by`),
  KEY `purchases_supplier_id_foreign` (`supplier_id`),
  CONSTRAINT `purchases_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `purchases_material_id_foreign` FOREIGN KEY (`material_id`) REFERENCES `materials` (`id`) ON DELETE CASCADE,
  CONSTRAINT `purchases_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `purchases` (`id`, `material_id`, `purchase_date`, `quantity`, `unit_price`, `total_price`, `paid_amount`, `payment_status`, `type`, `supplier`, `supplier_id`, `notes`, `created_by`, `created_at`, `updated_at`) VALUES ('1', '47', '2026-02-25', '500.00', '500.00', '250000.00', '250000.00', 'paid', 'satuan', NULL, NULL, NULL, '1', '2026-02-25 14:29:53', '2026-02-25 14:29:53');

-- Table: role_has_permissions
CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('1', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('1', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('2', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('2', '3');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('2', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('2', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('3', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('3', '4');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('3', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('3', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('4', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('4', '5');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('4', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('4', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('5', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('5', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('5', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('5', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('6', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('6', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('6', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('6', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('7', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('7', '3');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('7', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('7', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('8', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('9', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('9', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('9', '3');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('9', '4');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('9', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('9', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('10', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('10', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('10', '3');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('10', '4');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('10', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('10', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('11', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('11', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('11', '4');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('11', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('11', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('12', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('12', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('12', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('12', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('13', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('13', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('13', '3');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('13', '4');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('13', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('13', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('14', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('14', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('14', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('15', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('15', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('15', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('16', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('16', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('16', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('17', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('17', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('17', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('17', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('18', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('18', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('18', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('19', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('19', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('19', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('19', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('20', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('20', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('20', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('21', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('21', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('21', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('21', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('22', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('22', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('22', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('22', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('23', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('23', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('23', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('23', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('24', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('24', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('24', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('25', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('25', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('25', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('25', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('26', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('26', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('26', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('27', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('27', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('27', '4');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('27', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('27', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('28', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('28', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('28', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('28', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('29', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('29', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('29', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('29', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('30', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('30', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('30', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('31', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('31', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('31', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('32', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('32', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('32', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('33', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('33', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('33', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('33', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('34', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('34', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('34', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('35', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('35', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('35', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('36', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('36', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('36', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('37', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('37', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('37', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('38', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('38', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('38', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('38', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('39', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('39', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('39', '3');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('39', '4');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('39', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('39', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('40', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('40', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('40', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('40', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('41', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('41', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('41', '3');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('41', '4');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('41', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('41', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('42', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('43', '1');

-- Table: roles
CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('1', 'developer', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('2', 'owner', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('3', 'designer', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('4', 'kasir', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('5', 'operator', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('6', 'spv', 'web', '2026-02-10 01:47:14', '2026-02-10 01:47:14');
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('7', 'Administrasi', 'web', '2026-02-27 01:29:49', '2026-02-27 01:29:49');

-- Table: salaries
CREATE TABLE `salaries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `period` varchar(255) NOT NULL,
  `base_salary` decimal(12,2) NOT NULL DEFAULT 0.00,
  `allowance` decimal(12,2) NOT NULL DEFAULT 0.00,
  `overtime` decimal(12,2) NOT NULL DEFAULT 0.00,
  `bonus` decimal(12,2) NOT NULL DEFAULT 0.00,
  `deduction` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total` decimal(12,2) NOT NULL DEFAULT 0.00,
  `notes` text DEFAULT NULL,
  `status` enum('draft','paid') NOT NULL DEFAULT 'draft',
  `paid_at` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `salaries_employee_id_period_unique` (`employee_id`,`period`),
  CONSTRAINT `salaries_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- 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,
  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;

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('4VULnd0vyiLEc19RIllzEFNgGLgN4HgWmEsT8n5i', '26', '182.253.63.6', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoidmg5clc1THRzM3FIZkoxSjFnZjEyem53d0JWbGhEUDJzSEtoOTRQTCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjI6Imh0dHBzOi8vcG9zLmVya2FncmFwaGlhLmNvbS9vcGVyYXRvci9kYXNoYm9hcmQvbGl2ZT9zaW5jZV9pZD0wIjt9czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MjY7fQ==', '1772410614');
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('55tm6E6eSoNyVwuaJXPZW9HKiKHE8YGLiOLoY83v', '1', '103.87.228.98', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiS2NrYTJ6aEFkcXIwQkFrdVlsVkc1TEFzcTZRS2tnalUxVlNkU09GTiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vcG9zLmVya2FncmFwaGlhLmNvbS9iYWNrdXBzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9', '1772410613');

-- Table: stock_movements
CREATE TABLE `stock_movements` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `material_id` bigint(20) unsigned NOT NULL,
  `type` enum('in','out','damaged','adjustment') NOT NULL,
  `quantity` decimal(15,2) NOT NULL,
  `unit_price` decimal(15,2) NOT NULL DEFAULT 0.00,
  `total_price` decimal(15,2) NOT NULL DEFAULT 0.00,
  `reference_type` varchar(255) DEFAULT NULL,
  `reference_id` bigint(20) unsigned DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `stock_movements_user_id_foreign` (`user_id`),
  KEY `stock_movements_material_id_type_index` (`material_id`,`type`),
  KEY `stock_movements_reference_type_reference_id_index` (`reference_type`,`reference_id`),
  CONSTRAINT `stock_movements_material_id_foreign` FOREIGN KEY (`material_id`) REFERENCES `materials` (`id`) ON DELETE CASCADE,
  CONSTRAINT `stock_movements_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('14', '62', 'out', '6.00', '0.00', '0.00', 'App\\Models\\Order', '9', 'Order #INV-20260227-0001 - kunyuk', '1', '2026-02-27 13:56:04', '2026-02-27 13:56:04');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('15', '62', 'out', '8.00', '0.00', '0.00', 'App\\Models\\Order', '10', 'Order #INV-20260227-0002 - Fajar rk', '1', '2026-02-27 14:17:50', '2026-02-27 14:17:50');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('16', '47', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '11', 'Order #INV-20260228-0001 - xxx', '3', '2026-02-28 08:22:00', '2026-02-28 08:22:00');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('17', '47', 'out', '9.00', '0.00', '0.00', 'App\\Models\\Order', '12', 'Order #INV-20260228-0002 - aaa', '3', '2026-02-28 08:24:00', '2026-02-28 08:24:00');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('18', '62', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '13', 'Order #INV-20260228-0003 - asda', '3', '2026-02-28 08:28:34', '2026-02-28 08:28:34');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('19', '47', 'out', '111.00', '0.00', '0.00', 'App\\Models\\Order', '14', 'Order #INV-20260228-0004 - xx', '1', '2026-02-28 08:30:48', '2026-02-28 08:30:48');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('20', '47', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '15', 'Order #INV-20260228-0005 - aaaa', '1', '2026-02-28 09:19:32', '2026-02-28 09:19:32');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('21', '47', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '16', 'Order #INV-20260228-0006 - jhjh', '1', '2026-02-28 09:21:13', '2026-02-28 09:21:13');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('22', '61', 'in', '680.00', '18000.00', '12240000.00', NULL, NULL, 'prinmate', '8', '2026-02-28 16:36:25', '2026-02-28 16:36:25');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('23', '101', 'in', '60.00', '20000.00', '1200000.00', NULL, NULL, 'prinmate', '8', '2026-02-28 16:43:07', '2026-02-28 16:43:07');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('24', '64', 'in', '55.00', '45000.00', '2475000.00', NULL, NULL, 'prinmate', '8', '2026-02-28 16:43:37', '2026-02-28 16:43:37');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('25', '62', 'in', '150.00', '15000.00', '2250000.00', NULL, NULL, 'visi media', '8', '2026-02-28 16:44:25', '2026-02-28 16:44:25');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('26', '63', 'in', '180.00', '18000.00', '3240000.00', NULL, NULL, NULL, '8', '2026-02-28 16:45:11', '2026-02-28 16:45:11');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('27', '66', 'in', '40.00', '2600.00', '104000.00', NULL, NULL, 'visi media', '8', '2026-02-28 16:45:57', '2026-02-28 16:45:57');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('28', '82', 'in', '820.00', '8500.00', '6970000.00', NULL, NULL, 'prinmate', '8', '2026-02-28 16:47:11', '2026-02-28 16:47:11');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('29', '81', 'in', '490.00', '8500.00', '4165000.00', NULL, NULL, 'prinmate', '8', '2026-02-28 16:52:41', '2026-02-28 16:52:41');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('31', '65', 'in', '35.00', '45000.00', '1575000.00', NULL, NULL, 'visi media', '8', '2026-03-01 07:05:22', '2026-03-01 07:05:22');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('32', '70', 'in', '27.00', '21000.00', '567000.00', NULL, NULL, 'VISI MEDIA', '8', '2026-03-01 07:10:32', '2026-03-01 07:10:32');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('33', '71', 'in', '21.00', '35000.00', '735000.00', NULL, NULL, 'VISI MEDIA', '8', '2026-03-01 07:11:11', '2026-03-01 07:11:11');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('34', '74', 'in', '3.00', '75000.00', '225000.00', NULL, NULL, 'ONLINE', '8', '2026-03-01 07:11:52', '2026-03-01 07:11:52');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('35', '76', 'in', '95.00', '12000.00', '1140000.00', NULL, NULL, 'VISI MEDIA', '8', '2026-03-01 07:14:24', '2026-03-01 07:14:24');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('36', '77', 'in', '50.00', '35000.00', '1750000.00', NULL, NULL, 'VISI MEDIA', '8', '2026-03-01 07:15:21', '2026-03-01 07:15:21');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('37', '79', 'in', '1.00', '130000.00', '130000.00', NULL, NULL, 'VISI MEDIA', '8', '2026-03-01 07:16:12', '2026-03-01 07:16:12');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('38', '80', 'in', '120.00', '11000.00', '1320000.00', NULL, NULL, 'VISI MEDIA', '8', '2026-03-01 07:27:57', '2026-03-01 07:27:57');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('39', '85', 'in', '722.00', '5700.00', '4115400.00', NULL, NULL, 'VISI MEDIA', '8', '2026-03-01 07:28:59', '2026-03-01 07:28:59');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('40', '86', 'in', '120.00', '7700.00', '924000.00', NULL, NULL, 'VISI MEDIA', '8', '2026-03-01 07:29:33', '2026-03-01 07:29:33');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('41', '87', 'in', '265.00', '19000.00', '5035000.00', NULL, NULL, 'VISI MEDIA', '8', '2026-03-01 07:30:51', '2026-03-01 07:30:51');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('42', '88', 'in', '95.00', '18000.00', '1710000.00', NULL, NULL, NULL, '8', '2026-03-01 07:31:35', '2026-03-01 07:31:35');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('43', '89', 'in', '160.00', '21500.00', '3440000.00', NULL, NULL, NULL, '8', '2026-03-01 07:32:15', '2026-03-01 07:32:15');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('44', '44', 'in', '700.00', '365.00', '255500.00', NULL, NULL, 'INDAH SARI ABADI', '8', '2026-03-01 07:33:32', '2026-03-01 07:33:32');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('45', '45', 'in', '1395.00', '455.00', '634725.00', NULL, NULL, 'INDAH SARI ABADI', '8', '2026-03-01 07:34:22', '2026-03-01 07:34:22');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('46', '46', 'in', '375.00', '575.00', '215625.00', NULL, NULL, 'INDAH SARI ABADI', '8', '2026-03-01 07:34:57', '2026-03-01 07:34:57');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('47', '48', 'in', '750.00', '775.00', '581250.00', NULL, NULL, 'INDAH SARI ABADI', '8', '2026-03-01 07:35:44', '2026-03-01 07:35:44');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('49', '49', 'in', '230.00', '889.00', '204470.00', NULL, NULL, 'INDAH SARI ABADI', '8', '2026-03-01 07:42:54', '2026-03-01 07:42:54');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('50', '50', 'in', '300.00', '965.00', '289500.00', NULL, NULL, 'INDAH SARI ABADI', '8', '2026-03-01 07:49:34', '2026-03-01 07:49:34');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('51', '51', 'in', '1000.00', '242.00', '242000.00', NULL, NULL, 'INDAH SARI ABADI', '8', '2026-03-01 07:50:36', '2026-03-01 07:50:36');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('52', '53', 'in', '220.00', '1625.00', '357500.00', NULL, NULL, 'INDAH SARI ABADI', '8', '2026-03-01 07:51:08', '2026-03-01 07:51:08');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('53', '55', 'in', '345.00', '1088.00', '375360.00', NULL, NULL, 'INDAH SARI ABADI', '8', '2026-03-01 07:51:58', '2026-03-01 07:51:58');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('54', '56', 'in', '31.00', '3900.00', '120900.00', NULL, NULL, 'INDAH SARI ABADI', '8', '2026-03-01 07:52:23', '2026-03-01 07:52:23');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('55', '57', 'in', '35535.00', '1018.00', '36174630.00', NULL, NULL, 'DSI', '8', '2026-03-01 07:53:22', '2026-03-01 07:53:22');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('56', '58', 'in', '2914.00', '1018.00', '2966452.00', NULL, NULL, 'DSI', '8', '2026-03-01 07:54:00', '2026-03-01 07:54:00');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('57', '59', 'in', '3250.00', '2477.00', '8050250.00', NULL, NULL, 'DSI', '8', '2026-03-01 07:55:22', '2026-03-01 07:55:22');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('58', '60', 'in', '1085.00', '2477.00', '2687545.00', NULL, NULL, 'DSI', '8', '2026-03-01 07:56:05', '2026-03-01 07:56:05');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('59', '69', 'in', '1.00', '10000.00', '10000.00', NULL, NULL, 'INDAH SARI ABADI', '8', '2026-03-01 07:57:25', '2026-03-01 07:57:25');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('60', '68', 'in', '1250.00', '145.00', '181250.00', NULL, NULL, 'ONLINE', '8', '2026-03-01 08:02:23', '2026-03-01 08:02:23');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('61', '67', 'in', '7500.00', '145.00', '1087500.00', NULL, NULL, 'ONLINE', '8', '2026-03-01 08:02:59', '2026-03-01 08:02:59');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('62', '52', 'in', '225.00', '525.00', '118125.00', NULL, NULL, 'INDAH SARI ABADI', '8', '2026-03-01 08:03:31', '2026-03-01 08:03:31');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('63', '93', 'in', '750.00', '250.00', '187500.00', NULL, NULL, 'BINTANG TERANG', '8', '2026-03-01 08:04:05', '2026-03-01 08:04:05');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('64', '54', 'in', '480.00', '1425.00', '684000.00', NULL, NULL, 'INDAH SARI ABADI', '8', '2026-03-01 08:06:55', '2026-03-01 08:06:55');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('65', '102', 'in', '1.00', '460000.00', '460000.00', NULL, NULL, 'VISI MEDIA', '8', '2026-03-01 08:07:50', '2026-03-01 08:07:50');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('66', '72', 'in', '1.00', '105000.00', '105000.00', NULL, NULL, 'VISI MEDIA', '8', '2026-03-01 08:20:45', '2026-03-01 08:20:45');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('67', '73', 'in', '7.00', '130000.00', '910000.00', NULL, NULL, 'VISI MEDIA', '8', '2026-03-01 08:22:44', '2026-03-01 08:22:44');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('68', '94', 'in', '50.00', '1000.00', '50000.00', NULL, NULL, 'ONLINE', '8', '2026-03-01 08:23:39', '2026-03-01 08:23:39');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('69', '91', 'in', '100000000000.00', '0.00', '0.00', NULL, NULL, 'ONLINE', '8', '2026-03-01 10:24:21', '2026-03-01 10:24:21');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('70', '92', 'in', '100000000000.00', '0.00', '0.00', NULL, NULL, 'ONLINE', '8', '2026-03-01 10:25:30', '2026-03-01 10:25:30');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('71', '98', 'in', '10000000000.00', '0.00', '0.00', NULL, NULL, 'ONLINE', '8', '2026-03-01 10:26:05', '2026-03-01 10:26:05');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('72', '99', 'in', '10000000000.00', '0.00', '0.00', NULL, NULL, 'ONLINE', '8', '2026-03-01 10:26:45', '2026-03-01 10:26:45');

-- Table: suppliers
CREATE TABLE `suppliers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `suppliers` (`id`, `name`, `phone`, `address`, `notes`, `is_active`, `created_at`, `updated_at`) VALUES ('6', 'INDAH SARI ABADI', '123654789', 'JL. TENGKU UMAR, KEDATON. BANDAR LAMPUNG', NULL, '1', '2026-02-13 06:25:31', '2026-02-13 06:25:31');
INSERT INTO `suppliers` (`id`, `name`, `phone`, `address`, `notes`, `is_active`, `created_at`, `updated_at`) VALUES ('7', 'VISI MEDIA', NULL, 'BANDAR LAMPUNG', NULL, '1', '2026-02-28 16:34:15', '2026-02-28 16:34:15');
INSERT INTO `suppliers` (`id`, `name`, `phone`, `address`, `notes`, `is_active`, `created_at`, `updated_at`) VALUES ('8', 'PRINTMATE', NULL, 'BANDAR LAMPUNG', NULL, '1', '2026-03-01 07:06:32', '2026-03-01 07:06:32');
INSERT INTO `suppliers` (`id`, `name`, `phone`, `address`, `notes`, `is_active`, `created_at`, `updated_at`) VALUES ('9', 'IQBAL SUPLAYER', NULL, 'BAANDAR LAMPUNG', NULL, '1', '2026-03-01 07:07:50', '2026-03-01 07:07:50');
INSERT INTO `suppliers` (`id`, `name`, `phone`, `address`, `notes`, `is_active`, `created_at`, `updated_at`) VALUES ('10', 'RWC SUPLAYER TINTA', NULL, 'BANDAR LAMPUNG', NULL, '1', '2026-03-01 07:08:25', '2026-03-01 07:08:25');
INSERT INTO `suppliers` (`id`, `name`, `phone`, `address`, `notes`, `is_active`, `created_at`, `updated_at`) VALUES ('11', 'TOKO KERTAS SEJATI', NULL, 'BANDAR LAMPUNG', NULL, '1', '2026-03-01 07:09:09', '2026-03-01 07:09:09');

-- Table: units
CREATE TABLE `units` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `symbol` varchar(20) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `units` (`id`, `name`, `symbol`, `is_active`, `created_at`, `updated_at`) VALUES ('1', 'm²', 'm2', '1', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `units` (`id`, `name`, `symbol`, `is_active`, `created_at`, `updated_at`) VALUES ('2', 'pcs', 'pcs', '1', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `units` (`id`, `name`, `symbol`, `is_active`, `created_at`, `updated_at`) VALUES ('3', 'lembar', 'lbr', '1', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `units` (`id`, `name`, `symbol`, `is_active`, `created_at`, `updated_at`) VALUES ('4', 'meter', 'm', '1', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `units` (`id`, `name`, `symbol`, `is_active`, `created_at`, `updated_at`) VALUES ('5', 'roll', 'roll', '1', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `units` (`id`, `name`, `symbol`, `is_active`, `created_at`, `updated_at`) VALUES ('6', 'pak', 'pak', '1', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `units` (`id`, `name`, `symbol`, `is_active`, `created_at`, `updated_at`) VALUES ('7', 'kg', 'kg', '1', '2026-02-27 13:51:38', '2026-02-27 13:51:38');

