Subversion Repositories SmartDukaan

Rev

Rev 36644 | Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
36642 ranu 1 
CREATE TABLE user.lead_live_location
2 
(
3 
    id                 INT AUTO_INCREMENT PRIMARY KEY,
4 
    lead_id            INT         NOT NULL,
5 
    latitude           DOUBLE      NOT NULL,
6 
    longitude          DOUBLE      NOT NULL,
7 
    image_document_id  INT,
8 
    mobile_number      VARCHAR(15) NOT NULL,
9 
    status             VARCHAR(20) NOT NULL DEFAULT 'PENDING',
10 
    reviewed_by        INT                  DEFAULT 0,
11 
    reviewed_timestamp DATETIME,
12 
    submission_count   INT         NOT NULL DEFAULT 1,
13 
    remark             VARCHAR(500),
14 
    created_timestamp  DATETIME    NOT NULL,
15 
    updated_timestamp  DATETIME    NOT NULL,
16 
    INDEX idx_ll_lead_id (lead_id),
17 
    INDEX idx_ll_lead_status (lead_id, status)
18 
);