USE [BPMREPO]
GO
/****** Object:  Table [dbo].[KBSECURITY]    Script Date: 16/02/2018 02:47:09 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[KBSECURITY]') AND type in (N'U'))
DROP TABLE [dbo].[KBSECURITY]
GO
/****** Object:  Table [dbo].[COLLABORATION_ARCHIVE]    Script Date: 16/02/2018 02:47:09 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[COLLABORATION_ARCHIVE]') AND type in (N'U'))
DROP TABLE [dbo].[COLLABORATION_ARCHIVE]
GO
/****** Object:  Table [dbo].[COLLABORATION]    Script Date: 16/02/2018 02:47:09 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[COLLABORATION]') AND type in (N'U'))
DROP TABLE [dbo].[COLLABORATION]
GO
/****** Object:  Table [dbo].[COLLABORATION]    Script Date: 16/02/2018 02:47:09 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[COLLABORATION]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[COLLABORATION](
	[ID] [nchar](50) NULL,
	[PARENTID] [nchar](50) NULL,
	[MERGEID] [nchar](50) NULL,
	[TEMPID] [nchar](256) NULL,
	[MAPVERSION] [float] NULL,
	[TYPE] [int] NULL,
	[SUBVERSION] [int] NULL,
	[PROPS] [int] NULL,
	[NAME] [nchar](48) NULL,
	[VERSION] [int] NULL,
	[LABEL] [nchar](256) NULL,
	[COMMENTS] [nchar](512) NULL,
	[STATUS] [int] NULL,
	[LOCKED] [int] NULL,
	[OWNER] [nchar](100) NULL,
	[SOURCE] [nchar](50) NULL,
	[DATECREATED] [datetime] NULL,
	[LASTMODIFIED] [datetime] NULL,
	[HASNOTES] [int] NULL,
	[DATA] [image] NULL,
	[TEMPDATA] [image] NULL,
	[NOTES] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[COLLABORATION_ARCHIVE]    Script Date: 16/02/2018 02:47:09 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[COLLABORATION_ARCHIVE]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[COLLABORATION_ARCHIVE](
	[ID] [nchar](50) NULL,
	[PARENTID] [nchar](50) NULL,
	[MERGEID] [nchar](50) NULL,
	[TEMPID] [nchar](256) NULL,
	[MAPVERSION] [float] NULL,
	[TYPE] [int] NULL,
	[SUBVERSION] [int] NULL,
	[PROPS] [int] NULL,
	[NAME] [nchar](48) NULL,
	[VERSION] [int] NULL,
	[LABEL] [nchar](256) NULL,
	[COMMENTS] [nchar](512) NULL,
	[STATUS] [int] NULL,
	[LOCKED] [int] NULL,
	[OWNER] [nchar](100) NULL,
	[SOURCE] [nchar](50) NULL,
	[DATECREATED] [datetime] NULL,
	[LASTMODIFIED] [datetime] NULL,
	[HASNOTES] [int] NULL,
	[DATA] [image] NULL,
	[TEMPDATA] [image] NULL,
	[NOTES] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[KBSECURITY]    Script Date: 16/02/2018 02:47:09 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[KBSECURITY]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[KBSECURITY](
	[ID] [nchar](50) NULL,
	[NAME] [nchar](48) NULL,
	[TYPE] [int] NULL,
	[RIGHTS] [int] NULL
) ON [PRIMARY]
END
GO