CREATE TABLE TBL_LABSTUD_URINE_COLOR (
    LS_URCOLOR_ID                    INTEGER NOT NULL,
    LS_URCOLOR_DATE                  DMN_DATETIME /* DMN_DATETIME = TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL */,

-- skiped

    LS_URCOLOR_DELETED_REC           DMN_BOOL /* DMN_BOOL = SMALLINT DEFAULT 0 NOT NULL CHECK (VALUE IN (0,1)) */
);

SET BLOBFILE 'D:\Archive\Codetyphon_code\Andrology_5x\scripts\unicode_base_utf8_wo_bom_2016_01_12.lob';

UPDATE OR INSERT 
INTO TBL_LABSTUD_URINE_COLOR (LS_URCOLOR_ID, LS_URCOLOR_DATE, LS_URCOLOR_COLORNAME,
 LS_URCOLOR_NOTE, LS_URCOLOR_KIND_ACTION, LS_URCOLOR_INS_UPD_DEL_USER, LS_URCOLOR_INS_UPD_DEL_ROLE,
 LS_URCOLOR_INS_UPD_DEL_DATETIME, LS_URCOLOR_DELETED_REC) 
VALUES (1, '2016-01-08 19:24:19', 'Соломенно-жёлтый', NULL, 'I', 'SYSDBA', 'ADMINISTR', '2016-01-08 19:24:19', 0);

REINSERT (2, '2016-01-08 19:25:00', 'Темно-жёлтый', :h0_3B, 'U', 'SYSDBA', 'ADMINISTR', '2016-01-08 19:32:02', 0);

-- skiped

/******************************************************************************/
/***                              Primary keys                              ***/
/******************************************************************************/
-- skiped

ALTER TABLE TBL_LABSTUD_URINE_COLOR ADD CONSTRAINT PK_TBL_LABSTUD_URINE_COLOR PRIMARY KEY (LS_URCOLOR_ID);