Subversion Repositories SmartDukaan

CREATE TABLE user.lead_visit_approval
(
    id                 INT AUTO_INCREMENT PRIMARY KEY,
    lead_id            INT         NOT NULL,
    assigned_to        INT         NOT NULL,
    requested_by       INT         NOT NULL,
    beat_plan_group_id VARCHAR(100),
    beat_date          DATE        NOT NULL,
    beat_name          VARCHAR(200),
    schedule_timestamp DATETIME,
    status             VARCHAR(20) NOT NULL DEFAULT 'PENDING',
    approved_by        INT                  DEFAULT 0,
    approved_timestamp DATETIME,
    remark             VARCHAR(500),
    created_timestamp  DATETIME    NOT NULL,
    updated_timestamp  DATETIME    NOT NULL,
    INDEX idx_lva_lead (lead_id),
    INDEX idx_lva_status (status),
    INDEX idx_lva_assigned (assigned_to, status)
);

-- Geo Review menu
INSERT INTO auth.menu (display_text, description, parent_menu_id, sequence, action_class)
VALUES ('Geo Review', 'Review lead geolocation submissions', 175, 4, 'geo-review');

-- Visit Approvals menu (Sales L3+ only)
INSERT INTO auth.menu (display_text, description, parent_menu_id, sequence, action_class)
VALUES ('Visit Approvals', 'Approve lead visit requests', 175, 5, 'visit-approvals');