-- BACKUP DATABASE TERNAK LAZY
-- TANGGAL: 2026-11-11 20:27:15
SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `app_settings`;
CREATE TABLE `app_settings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`setting_key` varchar(50) NOT NULL,
`setting_value` text DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`id`),
UNIQUE KEY `setting_key` (`setting_key`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
INSERT INTO `app_settings` VALUES("1","store_name","Ternak Lazy","2026-11-10 21:54:17");
INSERT INTO `app_settings` VALUES("2","admin_name","Khazin Ganteng","2026-11-10 22:29:36");
INSERT INTO `app_settings` VALUES("3","profile_photo","profile_1794322824.png","2026-11-10 22:00:24");
DROP TABLE IF EXISTS `audit_logs`;
CREATE TABLE `audit_logs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_name` varchar(100) DEFAULT 'Admin',
`action_type` varchar(50) NOT NULL,
`description` text NOT NULL,
`ip_address` varchar(45) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
INSERT INTO `audit_logs` VALUES("1","Admin Ternak Lazy","UPDATE_PROFIL","Memperbarui profil toko: Nama Toko (Ternak Lazy), Nama Admin (Admin Ternak Lazy)","153.60.130.180","2026-11-10 22:00:24");
INSERT INTO `audit_logs` VALUES("2","Ternak Lazy","UPDATE_PROFIL","Memperbarui profil toko: Nama Toko (Ternak Lazy), Nama Admin (Ternak Lazy)","153.60.130.180","2026-11-10 22:00:42");
INSERT INTO `audit_logs` VALUES("3","Khazin Ganteng","INPUT_ORDER","Menambahkan pesanan baru Shopee #SPXIDWSDFKjskdsdfdf (Pembeli: ASER, Total Cair: Rp 45.000)","153.60.130.180","2026-11-11 02:34:18");
INSERT INTO `audit_logs` VALUES("4","Khazin Ganteng","MUTASI_STOK","Mutasi stok bahan \'Mika Smoke Nemo\' (masuk): 5 unit ()","153.60.130.180","2026-11-11 02:36:13");
INSERT INTO `audit_logs` VALUES("5","Khazin Ganteng","MUTASI_STOK","Mutasi stok bahan \'Mika Smoke Nemo\' (masuk): 5 unit ()","153.60.130.180","2026-11-11 02:36:53");
INSERT INTO `audit_logs` VALUES("6","Khazin Ganteng","MUTASI_STOK","Mutasi stok bahan \'Modul RGB Bluetooth DMX\' (keluar): 3 unit ()","146.75.132.26","2026-11-11 02:40:16");
INSERT INTO `audit_logs` VALUES("7","Khazin Ganteng","MUTASI_STOK","Mutasi stok bahan \'Modul RGB Bluetooth DMX\' (masuk): 2 unit ()","146.75.132.26","2026-11-11 02:40:54");
INSERT INTO `audit_logs` VALUES("8","Khazin Ganteng","MUTASI_STOK","Mutasi stok bahan \'Batok / Housing Aftermarket\' (keluar): 4 unit ()","153.60.141.233","2026-11-11 20:12:13");
DROP TABLE IF EXISTS `material_logs`;
CREATE TABLE `material_logs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`material_id` int(11) NOT NULL,
`type` enum('masuk','keluar','penyesuaian') NOT NULL,
`quantity` int(11) NOT NULL,
`notes` varchar(255) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
KEY `material_id` (`material_id`),
CONSTRAINT `material_logs_ibfk_1` FOREIGN KEY (`material_id`) REFERENCES `materials` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
INSERT INTO `material_logs` VALUES("1","6","masuk","12","","2026-11-10 20:31:55");
INSERT INTO `material_logs` VALUES("2","6","keluar","22","","2026-11-10 20:32:14");
INSERT INTO `material_logs` VALUES("3","1","keluar","1","Dipakai Order #SPXIDWSDFKjskdsd","2026-11-10 21:01:57");
INSERT INTO `material_logs` VALUES("4","3","keluar","1","Dipakai Order #SPXIDWSDFKjskdsd","2026-11-10 21:01:57");
INSERT INTO `material_logs` VALUES("5","5","keluar","1","Dipakai Order #SPXIDWSDFKjskdsd","2026-11-10 21:01:57");
INSERT INTO `material_logs` VALUES("6","2","keluar","1","Dipakai Order #SPXIDWSDFKjskdsd","2026-11-10 21:01:57");
INSERT INTO `material_logs` VALUES("7","6","keluar","1","Dipakai Order #SPXIDWSDFKjskdsd","2026-11-10 21:01:57");
INSERT INTO `material_logs` VALUES("8","1","keluar","1","Dipakai Order #SPXIDWSDFKjskdsd","2026-11-10 21:19:00");
INSERT INTO `material_logs` VALUES("9","5","keluar","1","Dipakai Order #SPXIDWSDFKjskdsd","2026-11-10 21:19:00");
INSERT INTO `material_logs` VALUES("10","1","keluar","1","Dipakai Order #SPXIDWSDFKjskdsd","2026-11-10 21:24:02");
INSERT INTO `material_logs` VALUES("11","5","keluar","1","Dipakai Order #SPXIDWSDFKjskdsd","2026-11-10 21:24:02");
INSERT INTO `material_logs` VALUES("12","1","keluar","1","Dipakai Order #SPXIDWSDFKjskdsd","2026-11-10 21:27:56");
INSERT INTO `material_logs` VALUES("13","5","keluar","1","Dipakai Order #SPXIDWSDFKjskdsd","2026-11-10 21:27:56");
INSERT INTO `material_logs` VALUES("14","2","keluar","1","Dipakai Order #SPXIDWSDFKjskdsd","2026-11-10 21:27:56");
INSERT INTO `material_logs` VALUES("15","6","keluar","1","Dipakai Order #SPXIDWSDFKjskdsd","2026-11-10 21:27:56");
INSERT INTO `material_logs` VALUES("16","1","keluar","1","","2026-11-10 21:57:39");
INSERT INTO `material_logs` VALUES("17","5","keluar","1","Dipakai Order #SPXIDWSDFKjskdytsd","2026-11-10 21:58:16");
INSERT INTO `material_logs` VALUES("18","2","keluar","1","Dipakai Order #SPXIDWSDFKjskdytsd","2026-11-10 21:58:16");
INSERT INTO `material_logs` VALUES("19","4","keluar","1","Dipakai Order #SPXIDWSDFKjskdytsd","2026-11-10 21:58:16");
INSERT INTO `material_logs` VALUES("20","6","keluar","1","Dipakai Order #SPXIDWSDFKjskdytsd","2026-11-10 21:58:16");
INSERT INTO `material_logs` VALUES("21","1","keluar","1","Dipakai Order #SPXIDWSDFKjskdytsdaaa","2026-11-10 22:11:39");
INSERT INTO `material_logs` VALUES("22","5","keluar","1","Dipakai Order #SPXIDWSDFKjskdytsdaaa","2026-11-10 22:11:39");
INSERT INTO `material_logs` VALUES("23","4","keluar","1","Dipakai Order #SPXIDWSDFKjskdytsdaaa","2026-11-10 22:11:39");
INSERT INTO `material_logs` VALUES("24","1","keluar","5","","2026-11-10 22:13:41");
INSERT INTO `material_logs` VALUES("25","1","masuk","1","","2026-11-10 22:17:55");
INSERT INTO `material_logs` VALUES("26","1","masuk","1","","2026-11-10 22:18:01");
INSERT INTO `material_logs` VALUES("27","6","masuk","1","","2026-11-10 22:21:37");
INSERT INTO `material_logs` VALUES("28","3","keluar","1","Dipakai Order #SPXIDWSDFKjskdsdfdf","2026-11-11 02:34:22");
INSERT INTO `material_logs` VALUES("29","2","keluar","1","Dipakai Order #SPXIDWSDFKjskdsdfdf","2026-11-11 02:34:22");
INSERT INTO `material_logs` VALUES("30","2","masuk","5","","2026-11-11 02:36:13");
INSERT INTO `material_logs` VALUES("31","2","masuk","5","","2026-11-11 02:36:53");
INSERT INTO `material_logs` VALUES("32","4","keluar","3","","2026-11-11 02:40:16");
INSERT INTO `material_logs` VALUES("33","4","masuk","2","","2026-11-11 02:40:54");
INSERT INTO `material_logs` VALUES("34","3","keluar","4","","2026-11-11 20:12:13");
DROP TABLE IF EXISTS `materials`;
CREATE TABLE `materials` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` varchar(50) NOT NULL,
`name` varchar(100) NOT NULL,
`category` varchar(50) DEFAULT 'Umum',
`image` varchar(255) DEFAULT NULL,
`unit` varchar(20) NOT NULL DEFAULT 'pcs',
`stock` int(11) NOT NULL DEFAULT 0,
`min_stock` int(11) NOT NULL DEFAULT 5,
`cost_price` decimal(12,2) NOT NULL DEFAULT 0.00,
`created_at` timestamp NULL DEFAULT current_timestamp(),
`updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`id`),
UNIQUE KEY `unique_code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
INSERT INTO `materials` VALUES("1","KDB-1","Akrilik Laser Vario 150","Umum","","set","16","5","35000.00","2026-11-10 19:57:52","2026-11-10 22:18:01");
INSERT INTO `materials` VALUES("2","KDB-2","Mika Smoke Nemo","Umum","","pcs","10","5","60000.00","2026-11-10 19:57:52","2026-11-11 02:36:53");
INSERT INTO `materials` VALUES("3","KDB-3","Batok / Housing Aftermarket","Umum","","pcs","4","5","50000.00","2026-11-10 19:57:52","2026-11-11 20:12:13");
INSERT INTO `materials` VALUES("4","KDB-4","Modul RGB Bluetooth DMX","Umum","","pcs","5","5","80000.00","2026-11-10 19:57:52","2026-11-11 02:40:54");
INSERT INTO `materials` VALUES("5","KDB-5","LED Alis AES Grade A","Umum","","pcs","9","5","45000.00","2026-11-10 19:57:52","2026-11-10 22:11:39");
INSERT INTO `materials` VALUES("6","KDB-6","Soket PNP Honda","Umum","mat_1794316933_362.png","pcs","18","5","15000.00","2026-11-10 19:57:52","2026-11-10 22:21:37");
DROP TABLE IF EXISTS `operational_costs`;
CREATE TABLE `operational_costs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`description` varchar(150) NOT NULL,
`amount` decimal(12,2) NOT NULL DEFAULT 0.00,
`expense_date` date NOT NULL,
`created_at` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
INSERT INTO `operational_costs` VALUES("1","Solasi & Bubble Wrap Packing","50000.00","2026-03-01","2026-11-10 19:57:53");
INSERT INTO `operational_costs` VALUES("2","Listrik Toko Maret","150000.00","2026-03-05","2026-11-10 19:57:53");
DROP TABLE IF EXISTS `order_materials`;
CREATE TABLE `order_materials` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`order_id` int(11) NOT NULL,
`material_id` int(11) NOT NULL,
`quantity` int(11) NOT NULL DEFAULT 1,
`subtotal_hpp` decimal(12,2) NOT NULL DEFAULT 0.00,
PRIMARY KEY (`id`),
KEY `order_id` (`order_id`),
KEY `material_id` (`material_id`),
CONSTRAINT `order_materials_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
CONSTRAINT `order_materials_ibfk_2` FOREIGN KEY (`material_id`) REFERENCES `materials` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
INSERT INTO `order_materials` VALUES("10","3","1","1","35000.00");
INSERT INTO `order_materials` VALUES("11","3","5","1","45000.00");
INSERT INTO `order_materials` VALUES("12","3","2","1","60000.00");
INSERT INTO `order_materials` VALUES("13","3","6","1","15000.00");
INSERT INTO `order_materials` VALUES("14","4","5","1","45000.00");
INSERT INTO `order_materials` VALUES("15","4","2","1","60000.00");
INSERT INTO `order_materials` VALUES("16","4","4","1","80000.00");
INSERT INTO `order_materials` VALUES("17","4","6","1","15000.00");
INSERT INTO `order_materials` VALUES("18","5","1","1","35000.00");
INSERT INTO `order_materials` VALUES("19","5","5","1","45000.00");
INSERT INTO `order_materials` VALUES("20","5","4","1","80000.00");
INSERT INTO `order_materials` VALUES("21","7","3","1","50000.00");
INSERT INTO `order_materials` VALUES("22","7","2","1","60000.00");
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`product_id` int(11) DEFAULT NULL,
`variant_id` int(11) DEFAULT NULL,
`order_code` varchar(20) NOT NULL,
`receipt_number` varchar(100) DEFAULT NULL,
`order_date` datetime NOT NULL DEFAULT current_timestamp(),
`customer_name` varchar(100) NOT NULL,
`motor_type` varchar(50) NOT NULL,
`selling_price` decimal(12,2) NOT NULL DEFAULT 0.00,
`shopee_original_price` decimal(12,2) NOT NULL DEFAULT 0.00,
`shopee_admin_fee` decimal(12,2) NOT NULL DEFAULT 0.00,
`total_hpp` decimal(12,2) NOT NULL DEFAULT 0.00,
`net_profit` decimal(12,2) NOT NULL DEFAULT 0.00,
`status` enum('Masuk','Produksi','Pengiriman','Selesai','Batal') NOT NULL DEFAULT 'Masuk',
`created_at` timestamp NULL DEFAULT current_timestamp(),
`updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`id`),
UNIQUE KEY `order_code` (`order_code`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
INSERT INTO `orders` VALUES("3","1","1","SPXIDWSDFKjskdsd","Sasasdsfarf","2026-11-10 21:27:00","Roniww","","450000.00","500000.00","50000.00","155000.00","295000.00","Produksi","2026-11-10 21:27:56","2026-11-10 21:28:32");
INSERT INTO `orders` VALUES("4","1","2","SPXIDWSDFKjskdytsd","wwwww","2026-11-01 14:57:00","Khazinh","","415989.00","450000.00","34011.00","200000.00","215989.00","Selesai","2026-11-10 21:58:16","2026-11-11 20:13:05");
INSERT INTO `orders` VALUES("5","1","1","SPXIDWSDFKjskdytsdaa","wwwww","2026-11-10 22:11:00","aaaaa","","499999.00","500000.00","1.00","160000.00","339999.00","Pengiriman","2026-11-10 22:11:39","2026-11-11 20:13:20");
INSERT INTO `orders` VALUES("7","1","2","SPXIDWSDFKjskdsdfdf","qwqwq","2026-11-11 02:33:00","ASER","","45000.00","450000.00","405000.00","110000.00","-65000.00","Produksi","2026-11-11 02:34:18","2026-11-11 20:13:27");
DROP TABLE IF EXISTS `product_variants`;
CREATE TABLE `product_variants` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`product_id` int(11) NOT NULL,
`variant_name` varchar(100) NOT NULL,
`default_price` decimal(12,2) NOT NULL DEFAULT 0.00,
PRIMARY KEY (`id`),
KEY `product_id` (`product_id`),
CONSTRAINT `product_variants_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
INSERT INTO `product_variants` VALUES("1","1","RGB BLITZ","500000.00");
INSERT INTO `product_variants` VALUES("2","1","RGB","450000.00");
DROP TABLE IF EXISTS `products`;
CREATE TABLE `products` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` varchar(50) NOT NULL,
`name` varchar(150) NOT NULL,
`category` varchar(50) DEFAULT 'General',
`image` varchar(255) DEFAULT NULL,
`description` text DEFAULT NULL,
`created_at` timestamp NULL DEFAULT current_timestamp(),
`updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`id`),
UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
INSERT INTO `products` VALUES("1","PRD-860F5","Stoplamp Lazy Vario","Vario Led Old","prd_1794319247_243.png","","2026-11-10 21:00:47","2026-11-10 21:00:47");
DROP TABLE IF EXISTS `stock_adjustments`;
CREATE TABLE `stock_adjustments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`material_id` int(11) NOT NULL,
`adjustment_type` enum('rusak','hilang','lainnya') NOT NULL,
`quantity` int(11) NOT NULL,
`reason` text DEFAULT NULL,
`created_at` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
KEY `material_id` (`material_id`),
CONSTRAINT `stock_adjustments_ibfk_1` FOREIGN KEY (`material_id`) REFERENCES `materials` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
SET FOREIGN_KEY_CHECKS=1;
