DROP TABLE IF EXISTS LKUP_CD_START_BASES
;
CREATE TABLE LKUP_CD_START_BASES (
       VALUE_CD			 INTEGER
      ,SHORTNAME_TX 		 VARCHAR(8)
      ,LONGNAME_TX 		 VARCHAR(30)
      ,DESCRIPTION_TX 		 VARCHAR(255) 
)
;

INSERT INTO LKUP_CD_START_BASES ( VALUE_CD, SHORTNAME_TX, LONGNAME_TX, DESCRIPTION_TX ) 
VALUES ( 0, '000', 'EMPTY', NULL )
; 
INSERT INTO LKUP_CD_START_BASES ( VALUE_CD, SHORTNAME_TX, LONGNAME_TX, DESCRIPTION_TX ) 
VALUES ( 1, '100', '1B ONLY', NULL )
; 
INSERT INTO LKUP_CD_START_BASES ( VALUE_CD, SHORTNAME_TX, LONGNAME_TX, DESCRIPTION_TX ) 
VALUES ( 2, '010', '2B ONLY', NULL )
; 
INSERT INTO LKUP_CD_START_BASES ( VALUE_CD, SHORTNAME_TX, LONGNAME_TX, DESCRIPTION_TX ) 
VALUES ( 3, '110', '1B & 2B', NULL )
; 
INSERT INTO LKUP_CD_START_BASES ( VALUE_CD, SHORTNAME_TX, LONGNAME_TX, DESCRIPTION_TX ) 
VALUES ( 4, '001', '3B ONLY', NULL )
; 
INSERT INTO LKUP_CD_START_BASES ( VALUE_CD, SHORTNAME_TX, LONGNAME_TX, DESCRIPTION_TX ) 
VALUES ( 5, '101', '1B & 3B', NULL )
; 
INSERT INTO LKUP_CD_START_BASES ( VALUE_CD, SHORTNAME_TX, LONGNAME_TX, DESCRIPTION_TX ) 
VALUES ( 6, '011', '2B & 3B', NULL )
; 
INSERT INTO LKUP_CD_START_BASES ( VALUE_CD, SHORTNAME_TX, LONGNAME_TX, DESCRIPTION_TX ) 
VALUES ( 7, '111', 'LOADED', NULL )
;