-- ==========================================================
-- ERODE AUTOMOBILES + GARAGE ERP
-- Complete MySQL Production Database Schema
-- Version: 2.6.0
-- ==========================================================

SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS settings;
DROP TABLE IF EXISTS service_reminders;
DROP TABLE IF EXISTS sms_logs;
DROP TABLE IF EXISTS whatsapp_logs;
DROP TABLE IF EXISTS notifications;
DROP TABLE IF EXISTS expenses;
DROP TABLE IF EXISTS ledger_entries;
DROP TABLE IF EXISTS accounts;
DROP TABLE IF EXISTS payments;
DROP TABLE IF EXISTS invoice_items;
DROP TABLE IF EXISTS invoices;
DROP TABLE IF EXISTS purchase_items;
DROP TABLE IF EXISTS purchases;
DROP TABLE IF EXISTS purchase_orders;
DROP TABLE IF EXISTS suppliers;
DROP TABLE IF EXISTS branch_transfers;
DROP TABLE IF EXISTS stock_transactions;
DROP TABLE IF EXISTS parts;
DROP TABLE IF EXISTS part_categories;
DROP TABLE IF EXISTS customer_feedbacks;
DROP TABLE IF EXISTS quality_checks;
DROP TABLE IF EXISTS estimate_items;
DROP TABLE IF EXISTS service_estimates;
DROP TABLE IF EXISTS job_status_history;
DROP TABLE IF EXISTS job_card_labour;
DROP TABLE IF EXISTS job_card_parts;
DROP TABLE IF EXISTS job_card_complaints;
DROP TABLE IF EXISTS job_cards;
DROP TABLE IF EXISTS vehicle_inspections;
DROP TABLE IF EXISTS service_bookings;
DROP TABLE IF EXISTS vehicle_sales;
DROP TABLE IF EXISTS quotations;
DROP TABLE IF EXISTS lead_followups;
DROP TABLE IF EXISTS leads;
DROP TABLE IF EXISTS vehicle_inventory;
DROP TABLE IF EXISTS vehicle_models;
DROP TABLE IF EXISTS vehicle_brands;
DROP TABLE IF EXISTS customer_vehicles;
DROP TABLE IF EXISTS customers;
DROP TABLE IF EXISTS audit_logs;
DROP TABLE IF EXISTS login_history;
DROP TABLE IF EXISTS users;
DROP TABLE IF EXISTS role_permissions;
DROP TABLE IF EXISTS permissions;
DROP TABLE IF EXISTS roles;
DROP TABLE IF EXISTS branches;

CREATE TABLE branches (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    code VARCHAR(50) NOT NULL,
    address TEXT,
    city VARCHAR(100) DEFAULT 'Erode',
    state VARCHAR(100) DEFAULT 'Tamil Nadu',
    pincode VARCHAR(20) DEFAULT '638001',
    phone VARCHAR(50),
    email VARCHAR(100),
    gstin VARCHAR(50),
    is_active TINYINT DEFAULT 1,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE roles (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    slug VARCHAR(100) NOT NULL UNIQUE,
    description VARCHAR(255),
    is_system TINYINT DEFAULT 0,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE permissions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    slug VARCHAR(100) NOT NULL UNIQUE,
    category VARCHAR(100) NOT NULL,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE role_permissions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    role_id INT NOT NULL,
    permission_id INT NOT NULL,
    INDEX (role_id),
    INDEX (permission_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    branch_id INT DEFAULT 1,
    role_id INT NOT NULL,
    name VARCHAR(255) NOT NULL,
    email VARCHAR(191) NOT NULL UNIQUE,
    mobile VARCHAR(50) NOT NULL UNIQUE,
    username VARCHAR(100) NOT NULL UNIQUE,
    password VARCHAR(255) NOT NULL,
    api_token VARCHAR(255),
    avatar VARCHAR(255),
    specialization VARCHAR(255),
    hourly_rate DECIMAL(15, 2) DEFAULT 0.00,
    status VARCHAR(50) DEFAULT 'active',
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    INDEX (role_id),
    INDEX (branch_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE login_history (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT,
    ip_address VARCHAR(100),
    user_agent TEXT,
    status VARCHAR(50),
    branch_id INT,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE audit_logs (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT,
    branch_id INT,
    module VARCHAR(100) NOT NULL,
    action VARCHAR(100) NOT NULL,
    record_id INT,
    old_value LONGTEXT,
    new_value LONGTEXT,
    ip_address VARCHAR(100),
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE customers (
    id INT AUTO_INCREMENT PRIMARY KEY,
    branch_id INT DEFAULT 1,
    customer_code VARCHAR(100) UNIQUE,
    name VARCHAR(255) NOT NULL,
    mobile VARCHAR(50) NOT NULL,
    whatsapp VARCHAR(50),
    email VARCHAR(100),
    address TEXT,
    city VARCHAR(100) DEFAULT 'Erode',
    gstin VARCHAR(50),
    pan VARCHAR(50),
    source VARCHAR(100) DEFAULT 'Walk-in',
    loyalty_points INT DEFAULT 0,
    outstanding_balance DECIMAL(15, 2) DEFAULT 0.00,
    status VARCHAR(50) DEFAULT 'active',
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    INDEX (mobile)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE customer_vehicles (
    id INT AUTO_INCREMENT PRIMARY KEY,
    customer_id INT NOT NULL,
    reg_number VARCHAR(100) NOT NULL,
    brand VARCHAR(100) NOT NULL,
    model VARCHAR(100) NOT NULL,
    variant VARCHAR(100),
    fuel_type VARCHAR(50) DEFAULT 'Petrol',
    transmission VARCHAR(50) DEFAULT 'Manual',
    model_year INT,
    color VARCHAR(50),
    engine_number VARCHAR(100),
    chassis_number VARCHAR(100),
    current_km INT DEFAULT 0,
    last_service_date DATETIME,
    next_service_due DATETIME,
    insurance_expiry DATETIME,
    puc_expiry DATETIME,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    INDEX (customer_id),
    INDEX (reg_number)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE vehicle_brands (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL UNIQUE,
    logo VARCHAR(255),
    country VARCHAR(100) DEFAULT 'India',
    is_active TINYINT DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE vehicle_models (
    id INT AUTO_INCREMENT PRIMARY KEY,
    brand_id INT NOT NULL,
    name VARCHAR(100) NOT NULL,
    category VARCHAR(100) DEFAULT 'SUV',
    fuel_types VARCHAR(100) DEFAULT 'Petrol,Diesel',
    is_active TINYINT DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE vehicle_inventory (
    id INT AUTO_INCREMENT PRIMARY KEY,
    branch_id INT DEFAULT 1,
    vin VARCHAR(100) UNIQUE,
    brand VARCHAR(100) NOT NULL,
    model VARCHAR(100) NOT NULL,
    variant VARCHAR(100) NOT NULL,
    color VARCHAR(100) NOT NULL,
    fuel_type VARCHAR(50) NOT NULL,
    transmission VARCHAR(50) NOT NULL,
    model_year INT NOT NULL,
    engine_number VARCHAR(100),
    chassis_number VARCHAR(100),
    purchase_date DATE,
    supplier_id INT,
    purchase_price DECIMAL(15, 2) NOT NULL,
    extra_expenses DECIMAL(15, 2) DEFAULT 0.00,
    landing_cost DECIMAL(15, 2) NOT NULL,
    ex_showroom_price DECIMAL(15, 2) NOT NULL,
    min_selling_price DECIMAL(15, 2) NOT NULL,
    selling_price DECIMAL(15, 2) NOT NULL,
    gst_rate DECIMAL(5, 2) DEFAULT 28.00,
    status VARCHAR(50) DEFAULT 'AVAILABLE',
    stock_age_days INT DEFAULT 0,
    images LONGTEXT,
    features LONGTEXT,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE leads (
    id INT AUTO_INCREMENT PRIMARY KEY,
    branch_id INT DEFAULT 1,
    lead_code VARCHAR(100) UNIQUE,
    customer_id INT,
    name VARCHAR(255) NOT NULL,
    mobile VARCHAR(50) NOT NULL,
    email VARCHAR(100),
    interested_in VARCHAR(100) DEFAULT 'Vehicle Purchase',
    brand_preference VARCHAR(100),
    model_preference VARCHAR(100),
    budget_range VARCHAR(100),
    source VARCHAR(100) DEFAULT 'Walk-in',
    stage VARCHAR(50) DEFAULT 'NEW',
    assigned_to INT,
    notes LONGTEXT,
    next_followup_date DATE,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE quotations (
    id INT AUTO_INCREMENT PRIMARY KEY,
    branch_id INT DEFAULT 1,
    quotation_number VARCHAR(100) UNIQUE NOT NULL,
    lead_id INT,
    customer_id INT NOT NULL,
    vehicle_id INT,
    vehicle_details VARCHAR(255),
    ex_showroom_price DECIMAL(15, 2) NOT NULL,
    gst_amount DECIMAL(15, 2) DEFAULT 0.00,
    tcs_amount DECIMAL(15, 2) DEFAULT 0.00,
    registration_charges DECIMAL(15, 2) DEFAULT 0.00,
    insurance_charges DECIMAL(15, 2) DEFAULT 0.00,
    accessories_charges DECIMAL(15, 2) DEFAULT 0.00,
    fastag_charges DECIMAL(15, 2) DEFAULT 500.00,
    extended_warranty DECIMAL(15, 2) DEFAULT 0.00,
    discount_amount DECIMAL(15, 2) DEFAULT 0.00,
    final_on_road_price DECIMAL(15, 2) NOT NULL,
    valid_until DATE,
    status VARCHAR(50) DEFAULT 'ACTIVE',
    created_by INT,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE service_bookings (
    id INT AUTO_INCREMENT PRIMARY KEY,
    branch_id INT DEFAULT 1,
    booking_number VARCHAR(100) UNIQUE NOT NULL,
    customer_id INT,
    customer_name VARCHAR(255) NOT NULL,
    mobile VARCHAR(50) NOT NULL,
    whatsapp VARCHAR(50),
    vehicle_number VARCHAR(100) NOT NULL,
    brand VARCHAR(100) NOT NULL,
    model VARCHAR(100) NOT NULL,
    fuel_type VARCHAR(50) DEFAULT 'Petrol',
    current_km INT DEFAULT 0,
    service_type VARCHAR(100) NOT NULL,
    complaint_description LONGTEXT,
    preferred_date DATE NOT NULL,
    preferred_time VARCHAR(50) NOT NULL,
    pickup_required TINYINT DEFAULT 0,
    onsite_service TINYINT DEFAULT 0,
    address TEXT,
    image_urls LONGTEXT,
    status VARCHAR(50) DEFAULT 'CONFIRMED',
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE job_cards (
    id INT AUTO_INCREMENT PRIMARY KEY,
    branch_id INT DEFAULT 1,
    job_card_number VARCHAR(100) UNIQUE NOT NULL,
    booking_id INT,
    inspection_id INT,
    customer_id INT NOT NULL,
    vehicle_id INT NOT NULL,
    service_type VARCHAR(100) NOT NULL,
    priority VARCHAR(50) DEFAULT 'NORMAL',
    status VARCHAR(50) DEFAULT 'WAITING_INSPECTION',
    service_advisor_id INT NOT NULL,
    technician_id INT,
    promised_date DATE,
    promised_time VARCHAR(50),
    internal_deadline DATETIME,
    start_time DATETIME,
    completion_time DATETIME,
    delivery_time DATETIME,
    delay_reason VARCHAR(255),
    estimated_parts_cost DECIMAL(15, 2) DEFAULT 0.00,
    estimated_labour_cost DECIMAL(15, 2) DEFAULT 0.00,
    estimated_total DECIMAL(15, 2) DEFAULT 0.00,
    actual_parts_cost DECIMAL(15, 2) DEFAULT 0.00,
    actual_labour_cost DECIMAL(15, 2) DEFAULT 0.00,
    final_amount DECIMAL(15, 2) DEFAULT 0.00,
    customer_approval_status VARCHAR(50) DEFAULT 'PENDING',
    customer_approval_time DATETIME,
    customer_signature LONGTEXT,
    is_repeat_comeback TINYINT DEFAULT 0,
    previous_job_card_id INT,
    technician_notes LONGTEXT,
    qr_token VARCHAR(100),
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    INDEX (status),
    INDEX (vehicle_id),
    INDEX (customer_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE job_card_complaints (
    id INT AUTO_INCREMENT PRIMARY KEY,
    job_card_id INT NOT NULL,
    complaint LONGTEXT NOT NULL,
    action_taken LONGTEXT,
    status VARCHAR(50) DEFAULT 'PENDING',
    INDEX (job_card_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE job_card_parts (
    id INT AUTO_INCREMENT PRIMARY KEY,
    job_card_id INT NOT NULL,
    part_id INT NOT NULL,
    part_name VARCHAR(255) NOT NULL,
    part_code VARCHAR(100) NOT NULL,
    quantity INT NOT NULL DEFAULT 1,
    unit_price DECIMAL(15, 2) NOT NULL,
    gst_rate DECIMAL(5, 2) DEFAULT 18.00,
    gst_amount DECIMAL(15, 2) DEFAULT 0.00,
    total_amount DECIMAL(15, 2) NOT NULL,
    status VARCHAR(50) DEFAULT 'REQUESTED',
    issued_by INT,
    issued_at DATETIME,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
    INDEX (job_card_id),
    INDEX (part_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE job_card_labour (
    id INT AUTO_INCREMENT PRIMARY KEY,
    job_card_id INT NOT NULL,
    description VARCHAR(255) NOT NULL,
    sac_code VARCHAR(50) DEFAULT '998729',
    hours DECIMAL(5, 2) DEFAULT 1.0,
    rate_per_hour DECIMAL(15, 2) NOT NULL,
    gst_rate DECIMAL(5, 2) DEFAULT 18.00,
    gst_amount DECIMAL(15, 2) DEFAULT 0.00,
    total_amount DECIMAL(15, 2) NOT NULL,
    technician_id INT,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
    INDEX (job_card_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE parts (
    id INT AUTO_INCREMENT PRIMARY KEY,
    branch_id INT DEFAULT 1,
    category_id INT NOT NULL,
    part_code VARCHAR(100) UNIQUE NOT NULL,
    barcode VARCHAR(100) UNIQUE,
    part_name VARCHAR(255) NOT NULL,
    brand VARCHAR(100) NOT NULL,
    compatible_models VARCHAR(255),
    oem_number VARCHAR(100),
    hsn_code VARCHAR(50) DEFAULT '8708',
    supplier_id INT,
    purchase_cost DECIMAL(15, 2) NOT NULL,
    dealer_cost DECIMAL(15, 2) NOT NULL,
    selling_price DECIMAL(15, 2) NOT NULL,
    mrp DECIMAL(15, 2) NOT NULL,
    gst_rate DECIMAL(5, 2) DEFAULT 18.00,
    current_stock INT DEFAULT 0,
    min_stock_level INT DEFAULT 5,
    max_stock_level INT DEFAULT 100,
    rack_location VARCHAR(100) DEFAULT 'A-01',
    `condition` VARCHAR(50) DEFAULT 'GOOD_STOCK',
    status VARCHAR(50) DEFAULT 'active',
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    INDEX (category_id),
    INDEX (barcode),
    INDEX (part_code)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE invoices (
    id INT AUTO_INCREMENT PRIMARY KEY,
    branch_id INT DEFAULT 1,
    invoice_number VARCHAR(100) UNIQUE NOT NULL,
    invoice_type VARCHAR(50) NOT NULL,
    customer_id INT NOT NULL,
    job_card_id INT,
    vehicle_sale_id INT,
    invoice_date DATE NOT NULL,
    due_date DATE,
    subtotal DECIMAL(15, 2) NOT NULL,
    parts_total DECIMAL(15, 2) DEFAULT 0.00,
    labour_total DECIMAL(15, 2) DEFAULT 0.00,
    discount_amount DECIMAL(15, 2) DEFAULT 0.00,
    cgst_amount DECIMAL(15, 2) DEFAULT 0.00,
    sgst_amount DECIMAL(15, 2) DEFAULT 0.00,
    igst_amount DECIMAL(15, 2) DEFAULT 0.00,
    tax_amount DECIMAL(15, 2) DEFAULT 0.00,
    round_off DECIMAL(15, 2) DEFAULT 0.00,
    grand_total DECIMAL(15, 2) NOT NULL,
    paid_amount DECIMAL(15, 2) DEFAULT 0.00,
    outstanding_amount DECIMAL(15, 2) DEFAULT 0.00,
    payment_status VARCHAR(50) DEFAULT 'UNPAID',
    is_gst TINYINT DEFAULT 1,
    upi_qr_string VARCHAR(255),
    notes TEXT,
    created_by INT NOT NULL,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    INDEX (customer_id),
    INDEX (invoice_number)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE accounts (
    id INT AUTO_INCREMENT PRIMARY KEY,
    branch_id INT DEFAULT 1,
    account_code VARCHAR(50) UNIQUE NOT NULL,
    account_name VARCHAR(255) NOT NULL,
    account_type VARCHAR(50) NOT NULL,
    sub_type VARCHAR(50),
    opening_balance DECIMAL(15, 2) DEFAULT 0.00,
    current_balance DECIMAL(15, 2) DEFAULT 0.00,
    is_active TINYINT DEFAULT 1,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE ledger_entries (
    id INT AUTO_INCREMENT PRIMARY KEY,
    branch_id INT DEFAULT 1,
    account_id INT NOT NULL,
    transaction_date DATE NOT NULL,
    voucher_type VARCHAR(50) NOT NULL,
    voucher_no VARCHAR(100) NOT NULL,
    debit DECIMAL(15, 2) DEFAULT 0.00,
    credit DECIMAL(15, 2) DEFAULT 0.00,
    balance DECIMAL(15, 2) DEFAULT 0.00,
    narration TEXT,
    created_by INT NOT NULL,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
    INDEX (account_id),
    INDEX (transaction_date)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

SET FOREIGN_KEY_CHECKS = 1;