CREATE TABLE `fuel_reorder_settings` (
	`id` integer PRIMARY KEY NOT NULL,
	`reorder_point` integer NOT NULL,
	`safety_stock` integer NOT NULL,
	`target_level` integer NOT NULL,
	`lead_days` integer NOT NULL,
	`supplier` text NOT NULL,
	`auto_request` integer NOT NULL,
	`updated_at` text NOT NULL
);
CREATE TABLE `fuel_supply_requests` (
	`id` text PRIMARY KEY NOT NULL,
	`status` text NOT NULL,
	`quantity` integer NOT NULL,
	`trigger_stock` integer NOT NULL,
	`supplier` text NOT NULL,
	`expected_date` text NOT NULL,
	`created_at` text NOT NULL
);
CREATE INDEX `idx_fuel_supply_requests_status` ON `fuel_supply_requests` (`status`);