Page History

if not exists (select * from pat_display_layout_functions where description = 'DMS')
INSERT INTO pat_display_layout_functions
            (layout_type,
             pat_or_maint,
             id,
             parent_id,
             description,
             action,
             sort_sw,
             parent_sort_sw)
VALUES     (1,
            'B',
            16,
            0,
            'DMS',
            'dms',
            1,
            14);
 
UPDATE pat_display_layout_functions
 SET    sort_sw = 15
 WHERE  layout_type = 1
       AND id = 12;
UPDATE pat_display_layout_functions
 SET    sort_sw = 16
 WHERE  layout_type = 1
       AND id = 14;
UPDATE pat_display_layout_functions
 SET    sort_sw = 17
 WHERE  layout_type = 1
       AND id = 15;
 
if not exists (select * from mandata_projectlog where project_id = 3501)
INSERT INTO mandata_projectlog
            (project_id,
             execution_date,
             customer_id,
             status)
VALUES     (3501,
            CURRENT_TIMESTAMP,
            13,
            1); 
 
if not exists (select * from PAT_CONFIGURATION where configuration_id = 313) 
INSERT INTO PAT_CONFIGURATION (configuration_id,label,description,type,string_value,maintained_by_patrix,group_flag) 
VALUES (313,'Installation ID','Installation ID',2,'<enter id here>',1,7);

if not exists (select * from PAT_CONFIGURATION where configuration_id=314)
INSERT INTO PAT_CONFIGURATION(configuration_id,label,description,type,string_value,maintained_by_patrix,group_flag)
VALUES(314,'Open documents using PINXDesktop','Open documents using PINXDesktop',3,'FALSE',1,7)

if not exists (select * from PAT_CONFIGURATION where configuration_id = 315) 
INSERT INTO PAT_CONFIGURATION (configuration_id,label,description,type,string_value,maintained_by_patrix,group_flag) 
VALUES (315,'Nuxeo hostname and port','Nuxeo hostname and port',2,'hostname:port',1,7);

if not exists (select * from PAT_CONFIGURATION where configuration_id = 318) 
INSERT INTO PAT_CONFIGURATION (configuration_id,label,description,type,string_value,maintained_by_patrix,group_flag) 
VALUES (318,'Enable checksums for case numbers','Enable checksums for case numbers',3,'TRUE',1,7);
 
if not exists (select * from PAT_CONFIGURATION where configuration_id = 325) 
INSERT INTO PAT_CONFIGURATION (configuration_id,label,description,type,string_value,maintained_by_patrix,group_flag) 
VALUES (325,'Use NuxeoLib.dll','Use NuxeoLib.dll',3,'FALSE',1,7);