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);