Subversion Repositories SmartDukaan

CREATE TABLE user.lead_live_location
(
    id                 INT AUTO_INCREMENT PRIMARY KEY,
    lead_id            INT         NOT NULL,
    latitude           DOUBLE      NOT NULL,
    longitude          DOUBLE      NOT NULL,
    image_document_id  INT,
    mobile_number      VARCHAR(15) NOT NULL,
    status             VARCHAR(20) NOT NULL DEFAULT 'PENDING',
    reviewed_by        INT                  DEFAULT 0,
    reviewed_timestamp DATETIME,
    submission_count   INT         NOT NULL DEFAULT 1,
    remark             VARCHAR(500),
    created_timestamp  DATETIME    NOT NULL,
    updated_timestamp  DATETIME    NOT NULL,
    INDEX idx_ll_lead_id (lead_id),
    INDEX idx_ll_lead_status (lead_id, status)
);