JBPM5工作流数据库表结构

where r.fkeyid = object_id('dbo.I18NText') and = 'FK2349686B8046A239')
alter table dbo.I18NText
drop constraint FK2349686B8046A239
go
if exists (select 1
alter table dbo.Escalation
drop constraint FK67B2C6B5C7A04C70
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
alter table dbo.I18NText
drop constraint FK2349686BD488CEEB
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
/*==============================================================*/
/* DBMS name: Microsoft SQL Server 2008 */
/* Created on: 2012-11-19 17:36:24 */
where r.fkeyid = object_id('dbo.BooleanExpression') and = 'FKE3D208C0AFB75F7D')
alter table dbo.BooleanExpression
drop constraint FKE3D208C0AFB75F7D
alter table dbo.Deadline
drop constraint FK21DF3E7827ABEB8A
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('dbo.Delegation_delegates') and = 'FK47485D572C122ED2')
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('dbo.Notification') and = 'FK2D45DD0B3E0890B')
where r.fkeyid = object_id('dbo.Deadline') and = 'FK21DF3E78684BACA3')
alter table dbo.Deadline
drop constraint FK21DF3E78684BACA3
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('dbo.I18NText') and = 'FK2349686B3330F6D9')
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('dbo.Attachment') and = 'FK1C93543F21826D9')
where r.fkeyid = object_id('dbo.Attachment') and = 'FK1C935438EF5F064')
alter table dbo.Attachment
drop constraint FK1C935438EF5F064
go
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('dbo.I18NText') and = 'FK2349686BD488CEEB')
alter table dbo.Attachment
drop constraint FK1C93543F21826D9
go if exists源自(select 1 from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
/*==============================================================*/
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
alter table dbo.I18NText
drop constraint FK2349686B69B21EE8
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('dbo.Delegation_delegates') and = 'FK47485D5736B2F154')
alter table dbo.Delegation_delegates
drop constraint FK47485D5736B2F154
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('dbo.I18NText') and = 'FK2349686B98B62B')
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('dbo.Escalation') and = 'FK67B2C6B5C7A04C70')
where r.fkeyid = object_id('dbo.I18NText') and = 'FK2349686B2162DFB4')
alter table dbo.I18NText
drop constraint FK2349686B2162DFB4
go
if exists (select 1
alter table dbo.I18NText
drop constraint FK2349686B98B62B
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('dbo.I18NText') and = 'FK2349686BF952CEE4')
alter table dbo.I18NText
drop constraint FK2349686BF952CEE4
go
if exists (select 1
where r.fkeyid = object_id('dbo.I18NText') and = 'FK2349686BB2FA6B18')
alter table dbo.I18NText
drop constraint FK2349686BB2FA6B18