text: drop table DB_WCT.ABSTRACT_TARGET cascade constraints;
  drop table DB_WCT.AGENCY cascade constraints;
  drop table DB_WCT.ANNOTATIONS cascade constraints;
  drop table DB_WCT.ARC_HARVEST_FILE cascade constraints;
  drop table DB_WCT.ARC_HARVEST_RESOURCE cascade constraints;
  drop table DB_WCT.ARC_HARVEST_RESULT cascade constraints;
  drop table DB_WCT.AUTHORISING_AGENT cascade constraints;
  drop table DB_WCT.BANDWIDTH_RESTRICTIONS cascade constraints;
  drop table DB_WCT.DUBLIN_CORE cascade constraints;
  drop table DB_WCT.GROUP_MEMBER cascade constraints;
  drop table DB_WCT.HARVEST_RESOURCE cascade constraints;
  drop table DB_WCT.HARVEST_RESULT cascade constraints;
  drop table DB_WCT.HARVEST_STATUS cascade constraints;
  drop table DB_WCT.NOTIFICATION cascade constraints;
  drop table DB_WCT.PERMISSION cascade constraints;
  drop table DB_WCT.PERMISSION_EXCLUSION cascade constraints;
  drop table DB_WCT.PERMISSION_TEMPLATE cascade constraints;
  drop table DB_WCT.PERMISSION_URLPATTERN cascade constraints;
  drop table DB_WCT.PO_EXCLUSION_URI cascade constraints;
  drop table DB_WCT.PO_INCLUSION_URI cascade constraints;
  drop table DB_WCT.PROFILE cascade constraints;
  drop table DB_WCT.PROFILE_BASIC_CREDENTIALS cascade constraints;
  drop table DB_WCT.PROFILE_CREDENTIALS cascade constraints;
  drop table DB_WCT.PROFILE_FORM_CREDENTIALS cascade constraints;
  drop table DB_WCT.PROFILE_OVERRIDES cascade constraints;
  drop table DB_WCT.ROLE_PRIVILEGE cascade constraints;
  drop table DB_WCT.SCHEDULE cascade constraints;
  drop table DB_WCT.SEED cascade constraints;
  drop table DB_WCT.SEED_PERMISSION cascade constraints;
  drop table DB_WCT.SITE cascade constraints;
  drop table DB_WCT.SITE_AUTH_AGENCY cascade constraints;
  drop table DB_WCT.TARGET cascade constraints;
  drop table DB_WCT.TARGET_GROUP cascade constraints;
  drop table DB_WCT.TARGET_INSTANCE cascade constraints;
  drop table DB_WCT.TASK cascade constraints;
  drop table DB_WCT.URL_PATTERN cascade constraints;
  drop table DB_WCT.URL_PERMISSION_MAPPING cascade constraints;
  drop table DB_WCT.USER_ROLE cascade constraints;
  drop table DB_WCT.WCTAUDIT cascade constraints;
  drop table DB_WCT.WCTROLE cascade constraints;
  drop table DB_WCT.WCTUSER cascade constraints;
  drop table DB_WCT.WCT_LOGON_DURATION cascade constraints;
  drop table DB_WCT.
              ID_GENERATOR
           cascade constraints;
  create table DB_WCT.ABSTRACT_TARGET (AT_OID number(19,0) not null, AT_DESC varchar2(255 char), AT_NAME varchar2(255 char) unique, AT_OWNER_ID number(19,0), AT_PROF_OVERRIDE_OID number(19,0), AT_STATE number(10,0), T_PROFILE_ID number(19,0), AT_OBJECT_TYPE number(10,0), AT_CREATION_DATE TIMESTAMP(9), AT_REFERENCE varchar2(255 char), AT_PROFILE_NOTE varchar2(255 char), AT_DUBLIN_CORE_OID number(19,0), primary key (AT_OID));
  create table DB_WCT.AGENCY (AGC_OID number(19,0) not null, AGC_NAME varchar2(80 char) not null unique, AGC_ADDRESS varchar2(255 char) not null, AGC_LOGO_URL varchar2(255 char), AGC_URL varchar2(255 char), AGC_EMAIL varchar2(80 char), AGC_FAX varchar2(20 char), AGC_PHONE varchar2(20 char), primary key (AGC_OID));
  create table DB_WCT.ANNOTATIONS (AN_OID number(19,0) not null, AN_DATE timestamp not null, AN_NOTE varchar2(1000 char) not null, AN_USER_OID number(19,0) not null, AN_OBJ_OID number(19,0) not null, AN_OBJ_TYPE varchar2(500 char) not null, primary key (AN_OID));
  create table DB_WCT.ARC_HARVEST_FILE (AHF_OID number(19,0) not null, AHF_COMPRESSED number(1,0) not null, AHF_NAME varchar2(100 char) not null unique, AHF_ARC_HARVEST_RESULT_ID number(19,0), primary key (AHF_OID));
  create table DB_WCT.ARC_HARVEST_RESOURCE (AHRC_HARVEST_RESOURCE_OID number(19,0) not null, AHRC_RESOURCE_LENGTH number(19,0) not null, AHRC_RESOURCE_OFFSET number(19,0) not null, AHRC_ARC_FILE_NAME varchar2(100 char) not null, AHRC_COMPRESSED_YN number(1,0) not null, primary key (AHRC_HARVEST_RESOURCE_OID));
  create table DB_WCT.ARC_HARVEST_RESULT (AHRS_HARVEST_RESULT_OID number(19,0) not null, primary key (AHRS_HARVEST_RESULT_OID));
  create table DB_WCT.AUTHORISING_AGENT (AA_OID number(19,0) not null, AA_NAME varchar2(255 char) unique, AA_ADRESS varchar2(2048 char), AA_CONTACT varchar2(255 char), AA_EMAIL varchar2(255 char), AA_PHONE_NUMBER varchar2(32 char), AA_DESC varchar2(2048 char), primary key (AA_OID));
  create table DB_WCT.BANDWIDTH_RESTRICTIONS (BR_OID number(19,0) not null, BR_BANDWIDTH number(19,0) not null, BR_DAY varchar2(9 char) not null, BR_END_TIME timestamp not null, BR_START_TIME timestamp not null, primary key (BR_OID));
  create table DB_WCT.DUBLIN_CORE (DC_OID number(19,0) not null, DC_CONTRIBUTOR varchar2(255 char), DC_COVERAGE varchar2(255 char), DC_CREATOR varchar2(255 char), DC_DESCRIPTION varchar2(2000 char), DC_FORMAT varchar2(255 char), DC_IDENTIFIER varchar2(255 char), DC_IDENTIFIER_ISBN varchar2(13 char), DC_IDENTIFIER_ISSN varchar2(9 char), DC_LANGUAGE varchar2(255 char), DC_PUBLISHER varchar2(255 char), DC_RELATION varchar2(255 char), DC_SOURCE varchar2(255 char), DC_SUBJECT varchar2(2000 char), DC_TITLE varchar2(255 char), DC_TYPE varchar2(50 char), primary key (DC_OID));
  create table DB_WCT.GROUP_MEMBER (AT_OID number(19,0) not null, GM_CHILD_ID number(19,0), GM_PARENT_ID number(19,0), primary key (AT_OID));
  create table DB_WCT.HARVEST_RESOURCE (HRC_OID number(19,0) not null, HRC_LENGTH number(19,0), HRC_NAME varchar2(1020 char) not null, HRC_HARVEST_RESULT_OID number(19,0), primary key (HRC_OID));
  create table DB_WCT.HARVEST_RESULT (HR_OID number(19,0) not null, HR_HARVEST_NO number(10,0), HR_TARGET_INSTANCE_ID number(19,0), HR_PROVENANCE_NOTE varchar2(1024 char) not null, HR_CREATED_DATE timestamp, HR_CREATED_BY_ID number(19,0), HR_STATE number(10,0), HR_INDEX number(10,0), primary key (HR_OID));
  create table DB_WCT.HARVEST_STATUS (HS_OID number(19,0) not null, HS_AVG_KB double precision, HS_AVG_URI double precision, HS_DATA_AMOUNT number(19,0), HS_ELAPSED_TIME number(19,0), HS_JOB_NAME varchar2(500 char), HS_STATUS varchar2(255 char), HS_URLS_DOWN number(19,0), HS_URLS_FAILED number(19,0), HS_ALERTS number(10,0), primary key (HS_OID));
  create table DB_WCT.NOTIFICATION (NOT_OID number(19,0) not null, NOT_MESSAGE varchar2(2000 char), NOT_USR_OID number(19,0) not null, NOT_SENDER varchar2(80 char) not null, NOT_SENT_DATE timestamp(9), NOT_SUBJECT varchar2(255 char) not null, primary key (NOT_OID));
  create table DB_WCT.PERMISSION (PE_OID number(19,0) not null, PE_ACCESS_STATUS varchar2(255 char), PE_APPROVED_YN number(1,0), PE_AVAILABLE_YN number(1,0), PE_COPYRIGHT_STATEMENT varchar2(2048 char), PE_COPYRIGHT_URL varchar2(2048 char), PE_CREATION_DATE TIMESTAMP(9), PE_END_DATE TIMESTAMP(9), PE_NOTES clob, PE_OPEN_ACCESS_DATE TIMESTAMP(9), PE_PERMISSION_GRANTED_DATE TIMESTAMP(9), PE_PERMISSION_REQUESTED_DATE TIMESTAMP(9), PE_SPECIAL_REQUIREMENTS varchar2(2048 char), PE_START_DATE TIMESTAMP(9), PE_STATUS number(10,0), PE_AUTH_AGENT_ID number(19,0), PE_SITE_ID number(19,0), PE_QUICK_PICK number(1,0), PE_DISPLAY_NAME varchar2(32 char), PE_OWNING_AGENCY_ID number(19,0), PE_FILE_REFERENCE varchar2(255 char), primary key (PE_OID));
  create table DB_WCT.PERMISSION_EXCLUSION (PEX_OID number(19,0) not null, PEX_REASON varchar2(255 char), PEX_URL varchar2(1024 char), PEX_PERMISSION_OID number(19,0), PEX_INDEX number(10,0), primary key (PEX_OID));
  create table DB_WCT.PERMISSION_TEMPLATE (PRT_OID number(19,0) not null, PRT_AGC_OID number(19,0) not null, PRT_TEMPLATE_TEXT clob not null, PRT_TEMPLATE_NAME varchar2(80 char) not null, PRT_TEMPLATE_TYPE varchar2(40 char) not null, PRT_TEMPLATE_DESC varchar2(255 char), primary key (PRT_OID));
  create table DB_WCT.PERMISSION_URLPATTERN (PU_URLPATTERN_ID number(19,0) not null, PU_PERMISSION_ID number(19,0) not null, primary key (PU_URLPATTERN_ID, PU_PERMISSION_ID));
  create table DB_WCT.PO_EXCLUSION_URI (PEU_PROF_OVER_OID number(19,0) not null, PEU_FILTER varchar2(255 char), PEU_IX number(10,0) not null, primary key (PEU_PROF_OVER_OID, PEU_IX));
  create table DB_WCT.PO_INCLUSION_URI (PEU_PROF_OVER_OID number(19,0) not null, PEU_FILTER varchar2(255 char), PEU_IX number(10,0) not null, primary key (PEU_PROF_OVER_OID, PEU_IX));
  create table DB_WCT.PROFILE (P_OID number(19,0) not null, P_VERSION number(10,0) not null, P_DESC varchar2(255 char), P_NAME varchar2(255 char), P_PROFILE_STRING clob, P_PROFILE_LEVEL number(10,0), P_STATUS number(10,0), P_DEFAULT number(1,0), P_AGECNY_OID number(19,0), primary key (P_OID));
  create table DB_WCT.PROFILE_BASIC_CREDENTIALS (PBC_PC_OID number(19,0) not null, PBC_REALM varchar2(255 char), primary key (PBC_PC_OID));
  create table DB_WCT.PROFILE_CREDENTIALS (PC_OID number(19,0) not null, PC_DOMAIN varchar2(255 char), PC_PASSWORD varchar2(255 char), PC_USERNAME varchar2(255 char), PC_PROFILE_OVERIDE_OID number(19,0), PC_INDEX number(10,0), primary key (PC_OID));
  create table DB_WCT.PROFILE_FORM_CREDENTIALS (PRC_PC_OID number(19,0) not null, PFC_METHOD varchar2(4 char), PFC_LOGIN_URI varchar2(255 char), PFC_PASSWORD_FIELD varchar2(255 char), PFC_USERNAME_FIELD varchar2(255 char), primary key (PRC_PC_OID));
  create table DB_WCT.PROFILE_OVERRIDES (PO_OID number(19,0) not null, PO_EXCL_MIME_TYPES varchar2(255 char), PO_MAX_BYES number(19,0), PO_MAX_DOCS number(19,0), PO_MAX_HOPS number(10,0), PO_MAX_PATH_DEPTH number(10,0), PO_MAX_TIME_SEC number(19,0), PO_ROBOTS_POLICY varchar2(10 char), PO_OR_CREDENTIALS number(1,0), PO_OR_EXCL_MIME_TYPES number(1,0), PO_OR_EXCLUSION_URI number(1,0), PO_OR_INCLUSION_URI number(1,0), PO_OR_MAX_BYTES number(1,0), PO_OR_MAX_DOCS number(1,0), PO_OR_MAX_HOPS number(1,0), PO_OR_MAX_PATH_DEPTH number(1,0), PO_OR_MAX_TIME_SEC number(1,0), PO_OR_ROBOTS_POLICY number(1,0), primary key (PO_OID));
  create table DB_WCT.ROLE_PRIVILEGE (PRV_OID number(19,0) not null, PRV_CODE varchar2(40 char) not null, PRV_ROLE_OID number(19,0), PRV_SCOPE number(10,0) not null, primary key (PRV_OID));
  create table DB_WCT.SCHEDULE (S_OID number(19,0) not null, S_CRON varchar2(255 char) not null, S_START TIMESTAMP(9) not null, S_END TIMESTAMP(9), S_TARGET_ID number(19,0), S_TYPE number(10,0) not null, S_OWNER_OID number(19,0), S_NEXT_SCHEDULE_TIME TIMESTAMP(9), S_ABSTRACT_TARGET_ID number(19,0), primary key (S_OID));
  create table DB_WCT.SEED (S_OID number(19,0) not null, S_SEED varchar2(1024 char), S_TARGET_ID number(19,0), S_PRIMARY number(1,0), primary key (S_OID));
  create table DB_WCT.SEED_PERMISSION (SP_SEED_ID number(19,0) not null, SP_PERMISSION_ID number(19,0) not null, primary key (SP_SEED_ID, SP_PERMISSION_ID));
  create table DB_WCT.SITE (ST_OID number(19,0) not null, ST_TITLE varchar2(255 char) not null unique, ST_DESC varchar2(255 char), ST_LIBRARY_ORDER_NO varchar2(32 char), ST_NOTES clob, ST_PUBLISHED number(1,0) not null, ST_ACTIVE number(1,0) not null, primary key (ST_OID));
  create table DB_WCT.SITE_AUTH_AGENCY (SA_SITE_ID number(19,0) not null, SA_AGENT_ID number(19,0) not null, primary key (SA_SITE_ID, SA_AGENT_ID));
  create table DB_WCT.TARGET (T_AT_OID number(19,0) not null, T_RUN_ON_APPROVAL number(1,0), T_EVALUATION_NOTE varchar2(255 char), T_SELECTION_DATE TIMESTAMP(9), T_SELECTION_NOTE varchar2(255 char), T_SELECTION_TYPE varchar2(255 char), T_HARVEST_TYPE varchar2(255 char), primary key (T_AT_OID));
  create table DB_WCT.TARGET_GROUP (TG_AT_OID number(19,0) not null, TG_SIP_TYPE number(10,0), TG_START_DATE DATE, TG_END_DATE DATE, TG_OWNERSHIP_METADATA varchar2(255 char), TG_TYPE varchar2(255 char), primary key (TG_AT_OID));
  create table DB_WCT.TARGET_INSTANCE (TI_OID number(19,0) not null, TI_VERSION number(10,0) not null, TI_SCHEDULE_ID number(19,0), TI_TARGET_ID number(19,0), TI_PRIORITY number(10,0) not null, TI_SCHEDULED_TIME TIMESTAMP(9) not null, TI_STATE varchar2(50 char) not null, TI_BANDWIDTH_PERCENT number(10,0), TI_ALLOCATED_BANDWIDTH number(19,0), TI_START_TIME timestamp, TI_OWNER_ID number(19,0), TI_DISPLAY_ORDER number(10,0), TI_PROF_OVERRIDE_OID number(19,0), TI_PURGED number(1,0) not null, TI_ARCHIVE_ID varchar2(40 char) unique, TI_REFERENCE varchar2(255 char), primary key (TI_OID));
  create table DB_WCT.TASK (TSK_OID number(19,0) not null, TSK_USR_OID number(19,0), TSK_MESSAGE varchar2(2000 char), TSK_SENDER varchar2(80 char) not null, TSK_SENT_DATE timestamp(9), TSK_SUBJECT varchar2(255 char) not null, TSK_PRIVILEGE varchar2(40 char), TSK_AGC_OID number(19,0) not null, TSK_MSG_TYPE varchar2(40 char) not null, TSK_RESOURCE_OID number(19,0) not null, TSK_RESOURCE_TYPE varchar2(80 char) not null, primary key (TSK_OID));
  create table DB_WCT.URL_PATTERN (UP_OID number(19,0) not null, UP_PATTERN varchar2(2048 char), UP_SITE_ID number(19,0), primary key (UP_OID));
  create table DB_WCT.URL_PERMISSION_MAPPING (UPM_OID number(19,0) not null, UPM_PERMISSION_ID number(19,0), UPM_URL_PATTERN_ID number(19,0), UPM_DOMAIN varchar2(1024 char), primary key (UPM_OID));
  create table DB_WCT.USER_ROLE (URO_USR_OID number(19,0) not null, URO_ROL_OID number(19,0) not null, primary key (URO_USR_OID, URO_ROL_OID));
  create table DB_WCT.WCTAUDIT (AUD_OID number(19,0) not null, AUD_ACTION varchar2(40 char) not null, AUD_DATE TIMESTAMP(9) not null, AUD_FIRSTNAME varchar2(50 char), AUD_LASTNAME varchar2(50 char), AUD_MESSAGE varchar2(2000 char) not null, AUD_SUBJECT_TYPE varchar2(255 char) not null, AUD_USERNAME varchar2(80 char), AUD_USER_OID number(19,0), AUD_SUBJECT_OID number(19,0), AUD_AGENCY_OID number(19,0), primary key (AUD_OID));
  create table DB_WCT.WCTROLE (ROL_OID number(19,0) not null, ROL_DESCRIPTION varchar2(255 char), ROL_NAME varchar2(80 char) not null, ROL_AGENCY_OID number(19,0) not null, primary key (ROL_OID));
  create table DB_WCT.WCTUSER (USR_OID number(19,0) not null, USR_ACTIVE number(1,0) not null, USR_ADDRESS varchar2(200 char), USR_EMAIL varchar2(100 char) not null, USR_EXTERNAL_AUTH number(1,0) not null, USR_FIRSTNAME varchar2(50 char) not null, USR_FORCE_PWD_CHANGE number(1,0) not null, USR_LASTNAME varchar2(50 char) not null, USR_NOTIFY_BY_EMAIL number(1,0) not null, USR_PASSWORD varchar2(255 char), USR_PHONE varchar2(16 char), USR_TITLE varchar2(10 char), USR_USERNAME varchar2(80 char) not null unique, USR_AGC_OID number(19,0) not null, USR_DEACTIVATE_DATE TIMESTAMP(9), primary key (USR_OID));
  create table DB_WCT.WCT_LOGON_DURATION (LOGDUR_OID number(19,0) not null, LOGDUR_DURATION number(19,0), LOGDUR_LOGON_TIME TIMESTAMP(9) not null, LOGDUR_LOGOUT_TIME TIMESTAMP(9), LOGDUR_USERNAME varchar2(80 char), LOGDUR_USER_OID number(19,0) not null, LOGDUR_USER_REALNAME varchar2(100 char), LOGDUR_SESSION_ID varchar2(32 char) not null, primary key (LOGDUR_OID));
  alter table DB_WCT.ABSTRACT_TARGET add constraint FK_AT_DUBLIN_CORE_OID foreign key (AT_DUBLIN_CORE_OID) references DB_WCT.DUBLIN_CORE;
  alter table DB_WCT.ABSTRACT_TARGET add constraint FK_T_PROF_OVERRIDE_OID foreign key (AT_PROF_OVERRIDE_OID) references DB_WCT.PROFILE_OVERRIDES;
  alter table DB_WCT.ABSTRACT_TARGET add constraint FKB6DD784E5C2C497 foreign key (AT_OWNER_ID) references DB_WCT.WCTUSER;
  alter table DB_WCT.ABSTRACT_TARGET add constraint FKB6DD784E3A83A603 foreign key (T_PROFILE_ID) references DB_WCT.PROFILE;
  alter table DB_WCT.ANNOTATIONS add constraint FK_NOTE_USER_OID foreign key (AN_USER_OID) references DB_WCT.WCTUSER;
  alter table DB_WCT.ARC_HARVEST_FILE add constraint FK_AHR_ARC_HARVEST_RESULT_ID foreign key (AHF_ARC_HARVEST_RESULT_ID) references DB_WCT.ARC_HARVEST_RESULT;
  alter table DB_WCT.ARC_HARVEST_RESOURCE add constraint FK6D84FEB12FF8F14B foreign key (AHRC_HARVEST_RESOURCE_OID) references DB_WCT.HARVEST_RESOURCE;
  alter table DB_WCT.ARC_HARVEST_RESULT add constraint FKE39C5380C88A38D9 foreign key (AHRS_HARVEST_RESULT_OID) references DB_WCT.HARVEST_RESULT;
  alter table DB_WCT.GROUP_MEMBER add constraint FK_GM_PARENT_ID foreign key (GM_PARENT_ID) references DB_WCT.TARGET_GROUP;
  alter table DB_WCT.GROUP_MEMBER add constraint FK_GM_CHILD_ID foreign key (GM_CHILD_ID) references DB_WCT.ABSTRACT_TARGET;
  alter table DB_WCT.HARVEST_RESOURCE add constraint FK5BA2B04431A1C148 foreign key (HRC_HARVEST_RESULT_OID) references DB_WCT.HARVEST_RESULT;
  alter table DB_WCT.HARVEST_RESULT add constraint FK_HR_CREATED_BY_ID foreign key (HR_CREATED_BY_ID) references DB_WCT.WCTUSER;
  alter table DB_WCT.HARVEST_RESULT add constraint FK_HRC_TARGET_INSTANCE_ID foreign key (HR_TARGET_INSTANCE_ID) references DB_WCT.TARGET_INSTANCE;
  alter table DB_WCT.PERMISSION add constraint FKFE0FB1CFEE52493C foreign key (PE_AUTH_AGENT_ID) references DB_WCT.AUTHORISING_AGENT;
  alter table DB_WCT.PERMISSION add constraint FKFE0FB1CFA1E5D89A foreign key (PE_OWNING_AGENCY_ID) references DB_WCT.AGENCY;
  alter table DB_WCT.PERMISSION add constraint FK_PE_SITE_ID foreign key (PE_SITE_ID) references DB_WCT.SITE;
  alter table DB_WCT.PERMISSION_EXCLUSION add constraint FK2DB3C33EB558CEC7 foreign key (PEX_PERMISSION_OID) references DB_WCT.PERMISSION;
  alter table DB_WCT.PERMISSION_TEMPLATE add constraint FK_TEMPLATE_AGENCY_OID foreign key (PRT_AGC_OID) references DB_WCT.AGENCY;
  alter table DB_WCT.PERMISSION_URLPATTERN add constraint PU_FK_1 foreign key (PU_URLPATTERN_ID) references DB_WCT.URL_PATTERN;
  alter table DB_WCT.PERMISSION_URLPATTERN add constraint PU_FK_2 foreign key (PU_PERMISSION_ID) references DB_WCT.PERMISSION;
  alter table DB_WCT.PO_EXCLUSION_URI add constraint FKFF4AB0FBBC3C926 foreign key (PEU_PROF_OVER_OID) references DB_WCT.PROFILE_OVERRIDES;
  alter table DB_WCT.PO_INCLUSION_URI add constraint FK6C665549BC3C926 foreign key (PEU_PROF_OVER_OID) references DB_WCT.PROFILE_OVERRIDES;
  alter table DB_WCT.PROFILE add constraint FK_P_AGENCY_OID foreign key (P_AGECNY_OID) references DB_WCT.AGENCY;
  alter table DB_WCT.PROFILE_BASIC_CREDENTIALS add constraint FKE72A5AF5BD9AB61 foreign key (PBC_PC_OID) references DB_WCT.PROFILE_CREDENTIALS;
  alter table DB_WCT.PROFILE_CREDENTIALS add constraint FK317A252682C63D7F foreign key (PC_PROFILE_OVERIDE_OID) references DB_WCT.PROFILE_OVERRIDES;
  alter table DB_WCT.PROFILE_FORM_CREDENTIALS add constraint FK6B1303D750209B71 foreign key (PRC_PC_OID) references DB_WCT.PROFILE_CREDENTIALS;
  alter table DB_WCT.ROLE_PRIVILEGE add constraint FK_PRIV_ROLE_OID foreign key (PRV_ROLE_OID) references DB_WCT.WCTROLE;
  alter table DB_WCT.SCHEDULE add constraint FK50C8297BE49544D foreign key (S_ABSTRACT_TARGET_ID) references DB_WCT.ABSTRACT_TARGET;
  alter table DB_WCT.SCHEDULE add constraint FK_S_OWNER_OID foreign key (S_OWNER_OID) references DB_WCT.WCTUSER;
  alter table DB_WCT.SCHEDULE add constraint FK_S_TARGET_ID foreign key (S_TARGET_ID) references DB_WCT.ABSTRACT_TARGET;
  alter table DB_WCT.SEED add constraint FK_SEED_TARGET_ID foreign key (S_TARGET_ID) references DB_WCT.TARGET;
  alter table DB_WCT.SEED_PERMISSION add constraint FK9659805D68A4F4BA foreign key (SP_SEED_ID) references DB_WCT.SEED;
  alter table DB_WCT.SEED_PERMISSION add constraint FK_SP_PERMISSION_ID foreign key (SP_PERMISSION_ID) references DB_WCT.PERMISSION;
  alter table DB_WCT.SITE_AUTH_AGENCY add constraint FKDF808D84C049BBEB foreign key (SA_SITE_ID) references DB_WCT.SITE;
  alter table DB_WCT.SITE_AUTH_AGENCY add constraint FK_SA_AGENT_ID foreign key (SA_AGENT_ID) references DB_WCT.AUTHORISING_AGENT;
  alter table DB_WCT.TARGET add constraint FK931165917947B83E foreign key (T_AT_OID) references DB_WCT.ABSTRACT_TARGET;
  alter table DB_WCT.TARGET_GROUP add constraint FKB444963161DABD5F foreign key (TG_AT_OID) references DB_WCT.ABSTRACT_TARGET;
  alter table DB_WCT.TARGET_INSTANCE add constraint FK_TI_TARGET_ID foreign key (TI_TARGET_ID) references DB_WCT.ABSTRACT_TARGET;
  alter table DB_WCT.TARGET_INSTANCE add constraint FK_TI_USER_ID foreign key (TI_OWNER_ID) references DB_WCT.WCTUSER;
  alter table DB_WCT.TARGET_INSTANCE add constraint FK_TI_PROF_OVERRIDE_OID foreign key (TI_PROF_OVERRIDE_OID) references DB_WCT.PROFILE_OVERRIDES;
  alter table DB_WCT.TARGET_INSTANCE add constraint FK_TI_SCHEDULE_ID foreign key (TI_SCHEDULE_ID) references DB_WCT.SCHEDULE;
  alter table DB_WCT.TASK add constraint FK_TASK_AGENCY_OID foreign key (TSK_AGC_OID) references DB_WCT.AGENCY;
  alter table DB_WCT.URL_PATTERN add constraint FK_UP_SITE_ID foreign key (UP_SITE_ID) references DB_WCT.SITE;
  alter table DB_WCT.URL_PERMISSION_MAPPING add constraint FK_UPM_URL_PATTERN_ID foreign key (UPM_URL_PATTERN_ID) references DB_WCT.URL_PATTERN;
  alter table DB_WCT.URL_PERMISSION_MAPPING add constraint FK_UPM_PERMISSION_ID foreign key (UPM_PERMISSION_ID) references DB_WCT.PERMISSION;
  alter table DB_WCT.USER_ROLE add constraint FK_USERROLE_TO_USER foreign key (URO_USR_OID) references DB_WCT.WCTUSER;
  alter table DB_WCT.USER_ROLE add constraint FK_USERROLE_TO_ROLE foreign key (URO_ROL_OID) references DB_WCT.WCTROLE;
  alter table DB_WCT.WCTROLE add constraint FK_ROLE_AGENCY_OID foreign key (ROL_AGENCY_OID) references DB_WCT.AGENCY;
  alter table DB_WCT.WCTUSER add constraint FK_USER_AGENCY_OID foreign key (USR_AGC_OID) references DB_WCT.AGENCY;
  create table DB_WCT.
              ID_GENERATOR
           ( 
              IG_TYPE
           varchar2(255 char),  
              IG_VALUE
           number(10,0) ) ;
  