-- =============================================
-- Agency Vending - Database Setup
-- =============================================
-- Execute this SQL in your database
-- The tables are required for the player-owned machines system
--
-- NOTE: The tables are also created automatically on first
-- resource start. This SQL is optional for manual setup.
-- =============================================

CREATE TABLE IF NOT EXISTS `agency_vending_machines` (
    `id` INT AUTO_INCREMENT PRIMARY KEY,
    `owner` VARCHAR(50) NOT NULL,
    `type` VARCHAR(50) NOT NULL,
    `coords` TEXT NOT NULL,
    `heading` FLOAT NOT NULL DEFAULT 0,
    `earnings` FLOAT NOT NULL DEFAULT 0
);

CREATE TABLE IF NOT EXISTS `agency_vending_stock` (
    `machine_id` INT NOT NULL,
    `slot` VARCHAR(10) NOT NULL,
    `stock` INT NOT NULL DEFAULT 0,
    `price` FLOAT NOT NULL DEFAULT 0,
    PRIMARY KEY (`machine_id`, `slot`)
);

CREATE TABLE IF NOT EXISTS `agency_vending_spawned` (
    `id` INT AUTO_INCREMENT PRIMARY KEY,
    `type` VARCHAR(50) NOT NULL,
    `model` VARCHAR(100) NOT NULL,
    `coords` TEXT NOT NULL,
    `heading` FLOAT NOT NULL DEFAULT 0,
    `spawned_by` VARCHAR(50) NOT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
