GO
਍ഀഀ
CREATE TABLE [dbo].[tblCaseTypes] (
਍ऀ嬀䌀愀猀攀吀礀瀀攀倀䬀崀 嬀椀渀琀崀 䤀䐀䔀一吀䤀吀夀 ⠀㄀Ⰰ ㄀⤀ 一伀吀 一唀䰀䰀 Ⰰഀഀ
     [CaseTypeName] [nvarchar] (32) ,

    START WITH 1 MAXVALUE 2.0E9 MINVALUE 1 NOCYCLE
    CACHE 200 ORDER;
CREATE TABLE jforum_banlist (
    banlist_id NUMBER(10),
    user_id NUMBER(10) DEFAULT 0,

ALTER TABLE SHKProcesses DROP FOREIGN KEY SHKProcesses_ProcessDefinition ;
ALTER TABLE SHKProcesses DROP FOREIGN KEY SHKProcesses_State ;
ALTER TABLE SHKProcessRequesters DROP FOREIGN KEY SHKProcessRequesters_ActivityRequester ;

ALTER TABLE LSREGOLAMARKETING ADD (
  FOREIGN KEY (IDCLASSEDINAMICA) 
    REFERENCES SAIBAPPL.CLASSIDINAMICHE (IDCLASSEDINAMICA));

ALTER TABLE XPDLData DROP FOREIGN KEY XPDLData_XPDL ;
ALTER TABLE XPDLHistoryData DROP FOREIGN KEY XPDLHistoryData_XPDLHistory ;
ALTER TABLE XPDLReferences DROP FOREIGN KEY XPDLReferences_ReferringXPDL ;

alter table JBPM_ACTION drop foreign key FK_ACTION_EVENT;
alter table JBPM_ACTION drop foreign key FK_ACTION_EXPTHDL;
alter table JBPM_ACTION drop foreign key FK_ACTION_PROCDEF;

alter table JBPM_ACTION drop foreign key FK_ACTION_EVENT;
alter table JBPM_ACTION drop foreign key FK_ACTION_EXPTHDL;
alter table JBPM_ACTION drop foreign key FK_ACTION_PROCDEF;

alter table JBPM_ACTION drop foreign key FK_ACTION_EVENT;
alter table JBPM_ACTION drop foreign key FK_ACTION_EXPTHDL;
alter table JBPM_ACTION drop foreign key FK_ACTION_PROCDEF;

alter table JBPM_ACTION drop foreign key FK_ACTION_EVENT;
alter table JBPM_ACTION drop foreign key FK_ACTION_EXPTHDL;
alter table JBPM_ACTION drop foreign key FK_ACTION_PROCDEF;

alter table JBPM_ACTION drop foreign key FK_ACTION_EVENT;
alter table JBPM_ACTION drop foreign key FK_ACTION_EXPTHDL;
alter table JBPM_ACTION drop foreign key FK_ACTION_PROCDEF;

alter table JBPM_ACTION drop foreign key FK_ACTION_EVENT;
alter table JBPM_ACTION drop foreign key FK_ACTION_EXPTHDL;
alter table JBPM_ACTION drop foreign key FK_ACTION_PROCDEF;

ALTER TABLE LSREGOLAMARKETING ADD (
  FOREIGN KEY (IDCLASSEDINAMICA) 
    REFERENCES SAIBAPPL.CLASSIDINAMICHE (IDCLASSEDINAMICA));

ALTER TABLE SHKUserGroupTable DROP FOREIGN KEY SHKUserGroupTable_userid ;
ALTER TABLE SHKUserGroupTable DROP FOREIGN KEY SHKUserGroupTable_groupid ;
ALTER TABLE SHKGroupGroupTable DROP FOREIGN KEY SHKGroupGroupTable_sub_gid ;

ALTER TABLE ProcLevelParticipant DROP FOREIGN KEY ProcLevelParticipant_PROCESSOID ;
ALTER TABLE PackLevelParticipant DROP FOREIGN KEY PackLevelParticipant_PACKAGEOID ;
ALTER TABLE XPDLParticipantProcess DROP FOREIGN KEY XPDLParticipantProcess_PACKAGEOID ;

ALTER TABLE SHKProcesses ADD CONSTRAINT SHKProcesses_Proc2 FOREIGN KEY (ProcessDefinition) REFERENCES SHKProcessDefinitions...  
ALTER TABLE SHKProcesses ADD CONSTRAINT SHKProcesses_State FOREIGN KEY (State) REFERENCES SHKProcessStates (oid) ;
ALTER TABLE SHKProcessRequesters ADD CONSTRAINT SHKProcessRequest6 FOREIGN KEY (ActivityRequester) REFERENCES SHKActivities...  

SET FOREIGN_KEY_CHECKS=0;
ALTER TABLE `document_fields_link` DROP FOREIGN KEY `document_fields_link_ibfk_1`;
ALTER TABLE document_fields_link DROP COLUMN document_id;

SET FOREIGN_KEY_CHECKS=0;
ALTER TABLE `document_fields_link` DROP FOREIGN KEY `document_fields_link_ibfk_1`;
ALTER TABLE document_fields_link DROP COLUMN document_id;

SET FOREIGN_KEY_CHECKS=0;
ALTER TABLE `document_fields_link` DROP FOREIGN KEY `document_fields_link_ibfk_1`;
ALTER TABLE document_fields_link DROP COLUMN document_id;

SET FOREIGN_KEY_CHECKS=0;
ALTER TABLE `document_fields_link` DROP FOREIGN KEY `document_fields_link_ibfk_1`;
ALTER TABLE document_fields_link DROP COLUMN document_id;

SET FOREIGN_KEY_CHECKS=0;
ALTER TABLE `document_fields_link` DROP FOREIGN KEY `document_fields_link_ibfk_1`;
ALTER TABLE document_fields_link DROP COLUMN document_id;

SET FOREIGN_KEY_CHECKS=0;
ALTER TABLE `document_fields_link` DROP FOREIGN KEY `document_fields_link_ibfk_1`;
ALTER TABLE document_fields_link DROP COLUMN document_id;

SET FOREIGN_KEY_CHECKS=0;
ALTER TABLE `document_fields_link` DROP FOREIGN KEY `document_fields_link_ibfk_1`;
ALTER TABLE document_fields_link DROP COLUMN document_id;

SET FOREIGN_KEY_CHECKS=0;
ALTER TABLE `document_fields_link` DROP FOREIGN KEY `document_fields_link_ibfk_1`;
ALTER TABLE document_fields_link DROP COLUMN document_id;

SET FOREIGN_KEY_CHECKS=0;
ALTER TABLE `document_fields_link` DROP FOREIGN KEY `document_fields_link_ibfk_1`;
ALTER TABLE document_fields_link DROP COLUMN document_id;

SET FOREIGN_KEY_CHECKS=0;
ALTER TABLE `document_fields_link` DROP FOREIGN KEY `document_fields_link_ibfk_1`;
ALTER TABLE document_fields_link DROP COLUMN document_id;