-- Migration for 12 Test App Services Module

CREATE TABLE `app_service_records` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `client_name` varchar(100) NOT NULL,
    `app_name` varchar(255) NOT NULL,
    `app_link` varchar(255) DEFAULT NULL,
    `whatsapp_number` varchar(20) DEFAULT NULL,
    `refer_agent` varchar(100) DEFAULT NULL,
    `start_date` date DEFAULT NULL,
    `end_date` date DEFAULT NULL,
    `status` enum(
        'Active',
        'Completed',
        'Pending'
    ) DEFAULT 'Pending',
    `notes` text DEFAULT NULL,
    `advance_payment` decimal(10, 2) DEFAULT 0.00,
    `balance_payment` decimal(10, 2) DEFAULT 0.00,
    `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
    PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;