--
-- File generated with SQLiteStudio v3.4.3 on Mon Jun 19 17:13:32 2023
--
-- Text encoding used: System
--
PRAGMA foreign_keys = off;
BEGIN TRANSACTION;

-- Table: ccvisitApp_leadstatus
DROP TABLE IF EXISTS ccvisitApp_leadstatus;

CREATE TABLE IF NOT EXISTS ccvisitApp_leadstatus (
    id            INTEGER       NOT NULL
                                PRIMARY KEY AUTOINCREMENT,
    lead_status   VARCHAR (3)   NOT NULL
                                UNIQUE,
    color_code    VARCHAR (100),
    is_reschedule BOOL          NOT NULL,
    is_cancel     BOOL          NOT NULL
);

INSERT INTO ccvisitApp_leadstatus (
                                      id,
                                      lead_status,
                                      color_code,
                                      is_reschedule,
                                      is_cancel
                                  )
                                  VALUES (
                                      1,
                                      '1N',
                                      '#fbfb04',
                                      0,
                                      0
                                  );

INSERT INTO ccvisitApp_leadstatus (
                                      id,
                                      lead_status,
                                      color_code,
                                      is_reschedule,
                                      is_cancel
                                  )
                                  VALUES (
                                      2,
                                      '2AW',
                                      '#ff6600',
                                      0,
                                      0
                                  );

INSERT INTO ccvisitApp_leadstatus (
                                      id,
                                      lead_status,
                                      color_code,
                                      is_reschedule,
                                      is_cancel
                                  )
                                  VALUES (
                                      3,
                                      '3C',
                                      '#04ac54',
                                      0,
                                      0
                                  );

INSERT INTO ccvisitApp_leadstatus (
                                      id,
                                      lead_status,
                                      color_code,
                                      is_reschedule,
                                      is_cancel
                                  )
                                  VALUES (
                                      4,
                                      '4NA',
                                      '#ac7498',
                                      0,
                                      0
                                  );

INSERT INTO ccvisitApp_leadstatus (
                                      id,
                                      lead_status,
                                      color_code,
                                      is_reschedule,
                                      is_cancel
                                  )
                                  VALUES (
                                      5,
                                      '5CR',
                                      '#7434a4',
                                      0,
                                      0
                                  );

INSERT INTO ccvisitApp_leadstatus (
                                      id,
                                      lead_status,
                                      color_code,
                                      is_reschedule,
                                      is_cancel
                                  )
                                  VALUES (
                                      6,
                                      '6RS',
                                      '#0473c3',
                                      1,
                                      0
                                  );

INSERT INTO ccvisitApp_leadstatus (
                                      id,
                                      lead_status,
                                      color_code,
                                      is_reschedule,
                                      is_cancel
                                  )
                                  VALUES (
                                      7,
                                      '7C',
                                      '#fb0404',
                                      0,
                                      1);

-- Index: sqlite_autoindex_ccvisitApp_leadstatus_1
DROP INDEX IF EXISTS sqlite_autoindex_ccvisitApp_leadstatus_1;

CREATE UNIQUE INDEX IF NOT EXISTS sqlite_autoindex_ccvisitApp_leadstatus_1 ON ccvisitApp_leadstatus (
    lead_status COLLATE BINARY
);


COMMIT TRANSACTION;
PRAGMA foreign_keys = on;
