InsertSequence.sql

insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(BIOBJ_ID)+1 from SBI_OBJECTS),1),'SBI_OBJECTS');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(OBJ_NOTE_ID)+1 from SBI_OBJECT_NOTES),1) ,'SBI_OBJECT_NOTES');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(OBJ_PAR_ID)+1 from SBI_OBJ_PAR),1) ,'SBI_OBJ_PAR');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(OBJ_TEMP_ID)+1 from SBI_OBJECT_TEMPLATES),1) ,'SBI_OBJECT_TEMPLATES');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(SNAP_ID)+1 from SBI_SNAPSHOTS),1) ,'SBI_SNAPSHOTS');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(SUBOBJ_ID)+1 from SBI_SUBOBJECTS),1) ,'SBI_SUBOBJECTS');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(VP_ID)+1 from SBI_VIEWPOINTS),1) ,'SBI_VIEWPOINTS');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(FUNCT_ID)+1 from SBI_FUNCTIONS),1) ,'SBI_FUNCTIONS');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(PAR_ID)+1 from SBI_PARAMETERS),1) ,'SBI_PARAMETERS');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(USE_ID)+1 from SBI_PARUSE),1) ,'SBI_PARUSE');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(CHECK_ID)+1 from SBI_CHECKS),1) ,'SBI_CHECKS');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(LOV_ID)+1 from SBI_LOV),1) ,'SBI_LOV');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(ID)+1 from SBI_CONFIG),1) ,'SBI_CONFIG');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(BIN_ID)+1 from SBI_BINARY_CONTENTS),1) ,'SBI_BINARY_CONTENTS');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(VALUE_ID)+1 from SBI_DOMAINS),1) ,'SBI_DOMAINS');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(EXT_ROLE_ID)+1 from SBI_EXT_ROLES),1) ,'SBI_EXT_ROLES');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(USER_FUNCT_ID)+1 from SBI_USER_FUNC),1) ,'SBI_USER_FUNC');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(ENGINE_ID)+1 from SBI_ENGINES),1) ,'SBI_ENGINES');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(ID)+1 from SBI_EVENTS),1) ,'SBI_EVENTS');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(ID)+1 from SBI_EVENTS_LOG),1) ,'SBI_EVENTS_LOG');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(ID)+1 from SBI_REMEMBER_ME),1) ,'SBI_REMEMBER_ME');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(ID)+1 from SBI_KPI_VALUE),1) ,'SBI_KPI_VALUE');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(ID)+1 from SBI_AUDIT),1) ,'SBI_AUDIT');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(ATTRIBUTE_ID)+1 from SBI_ATTRIBUTE),1) ,'SBI_ATTRIBUTE');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(ID)+1 from SBI_USER) ,1),'SBI_USER');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(DS_ID)+1 from SBI_DATA_SET),1) ,'SBI_DATA_SET');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(DS_ID)+1 from SBI_DATA_SOURCE),1) ,'SBI_DATA_SOURCE');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(DL_ID)+1 from SBI_DIST_LIST),1) ,'SBI_DIST_LIST');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(REL_ID)+1 from SBI_DIST_LIST_OBJECTS),1) ,'SBI_DIST_LIST_OBJECTS');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(DLU_ID)+1 from SBI_DIST_LIST_USER) ,1),'SBI_DIST_LIST_USER');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(OBJ_METACONTENT_ID)+1 from SBI_OBJ_METACONTENTS),1) ,'SBI_OBJ_METACONTENTS');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(OBJ_META_ID)+1 from SBI_OBJ_METADATA),1) ,'SBI_OBJ_METADATA');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(MENU_ID)+1 from SBI_MENU) ,1),'SBI_MENU');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(PROGRESS_THREAD_ID)+1 from SBI_PROGRESS_THREAD) ,1),'SBI_PROGRESS_THREAD');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(SOURCE_ID)+1 from SBI_META_SOURCE) ,1),'SBI_META_SOURCE');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(TABLE_ID)+1 from SBI_META_TABLE) ,1),'SBI_META_TABLE');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(COLUMN_ID)+1 from SBI_META_TABLE_COLUMN) ,1),'SBI_META_TABLE_COLUMN');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(BC_ID)+1 from SBI_META_BC) ,1),'SBI_META_BC');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(ATTRIBUTE_ID)+1 from SBI_META_BC_ATTRIBUTE) ,1),'SBI_META_BC_ATTRIBUTE');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(JOB_ID)+1 from SBI_META_JOB) ,1),'SBI_META_JOB');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(DS_TABLE_REL_ID)+1 from SBI_META_DATASET_REL) ,1),'SBI_META_DATASET_REL');
insert into hibernate_sequences(next_val,sequence_name) values (ifnull((select max(DOC_TABLE_REL_ID)+1 from SBI_META_DOCUMENT_REL) ,1),'SBI_META_DOCUMENT_REL');