CREATE TABLE `inventoryItems` (
	`id` int AUTO_INCREMENT NOT NULL,
	`sku` varchar(80) NOT NULL,
	`name` varchar(160) NOT NULL,
	`category` enum('aktif','pasif') NOT NULL,
	`unit` varchar(40) NOT NULL DEFAULT 'unit',
	`stockOnHand` int NOT NULL DEFAULT 0,
	`minStock` int NOT NULL DEFAULT 0,
	`status` enum('aktif','nonaktif') NOT NULL DEFAULT 'aktif',
	`locationLabel` varchar(180),
	`latitude` varchar(32),
	`longitude` varchar(32),
	`notes` text,
	`createdBy` int NOT NULL,
	`updatedBy` int NOT NULL,
	`createdAt` timestamp NOT NULL DEFAULT (now()),
	`updatedAt` timestamp NOT NULL DEFAULT (now()) ON UPDATE CURRENT_TIMESTAMP,
	CONSTRAINT `inventoryItems_id` PRIMARY KEY(`id`),
	CONSTRAINT `inventoryItems_sku_unique` UNIQUE(`sku`)
);
--> statement-breakpoint
CREATE TABLE `inventoryTransactions` (
	`id` int AUTO_INCREMENT NOT NULL,
	`itemId` int NOT NULL,
	`type` enum('masuk','keluar','penyesuaian') NOT NULL,
	`quantity` int NOT NULL,
	`purpose` enum('psb','mtc','gudang','kantor','lainnya') NOT NULL DEFAULT 'lainnya',
	`locationLabel` varchar(180),
	`latitude` varchar(32),
	`longitude` varchar(32),
	`referenceNumber` varchar(100),
	`notes` text,
	`createdBy` int NOT NULL,
	`createdAt` timestamp NOT NULL DEFAULT (now()),
	CONSTRAINT `inventoryTransactions_id` PRIMARY KEY(`id`)
);
--> statement-breakpoint
ALTER TABLE `users` MODIFY COLUMN `role` enum('user','admin','psb','mtc') NOT NULL DEFAULT 'user';