DP44/DataPRO_sql/.svn/pristine/f3/f35d3a858e553abfbcd440f9db0cf8bc622b79d0.svn-base

<EFBFBD><EFBFBD>IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_HISTORY]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] DROP CONSTRAINT [DF_MMEFigures_HISTORY]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_LAST_CHANGE]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] DROP CONSTRAINT [DF_MMEFigures_LAST_CHANGE]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_txtPath]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] DROP CONSTRAINT [DF_MMEFigures_txtPath]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_IntIDStdPath]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] DROP CONSTRAINT [DF_MMEFigures_IntIDStdPath]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_bitStdPath]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] DROP CONSTRAINT [DF_MMEFigures_bitStdPath]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_txtSortkey]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] DROP CONSTRAINT [DF_MMEFigures_txtSortkey]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_bolExpired]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] DROP CONSTRAINT [DF_MMEFigures_bolExpired]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_intVersion]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] DROP CONSTRAINT [DF_MMEFigures_intVersion]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_txtImageFile]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] DROP CONSTRAINT [DF_MMEFigures_txtImageFile]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_intPages]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] DROP CONSTRAINT [DF_MMEFigures_intPages]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_intPage]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] DROP CONSTRAINT [DF_MMEFigures_intPage]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_intAuthor]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] DROP CONSTRAINT [DF_MMEFigures_intAuthor]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_datRevision]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] DROP CONSTRAINT [DF_MMEFigures_datRevision]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_txtRemarks]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] DROP CONSTRAINT [DF_MMEFigures_txtRemarks]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_txtDescription]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] DROP CONSTRAINT [DF_MMEFigures_txtDescription]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_txtShortName]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] DROP CONSTRAINT [DF_MMEFigures_txtShortName]
END

GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MMEFigures]') AND type in (N'U'))
DROP TABLE [dbo].[MMEFigures]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MMEFigures]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[MMEFigures](
	[ID] [int] NOT NULL,
	[txtShortName] [nvarchar](100) NOT NULL,
	[txtDescription] [nvarchar](255) NOT NULL,
	[txtRemarks] [nvarchar](255) NULL,
	[datRevision] [datetime] NULL,
	[intAuthor] [int] NULL,
	[intPage] [smallint] NOT NULL,
	[intPages] [smallint] NOT NULL,
	[txtImageFile] [nvarchar](50) NOT NULL,
	[intVersion] [int] NULL,
	[bolExpired] [bit] NOT NULL,
	[txtSortkey] [nvarchar](50) NULL,
	[bitStdPath] [bit] NOT NULL,
	[IntIDStdPath] [int] NOT NULL,
	[txtPath] [nvarchar](255) NULL,
	[LAST_CHANGE] [datetime] NULL,
	[LAST_CHANGE_TEXT] [nvarchar](255) NULL,
	[HISTORY] [nvarchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_txtShortName]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] ADD  CONSTRAINT [DF_MMEFigures_txtShortName]  DEFAULT (space((0))) FOR [txtShortName]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_txtDescription]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] ADD  CONSTRAINT [DF_MMEFigures_txtDescription]  DEFAULT (space((0))) FOR [txtDescription]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_txtRemarks]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] ADD  CONSTRAINT [DF_MMEFigures_txtRemarks]  DEFAULT (space((0))) FOR [txtRemarks]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_datRevision]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] ADD  CONSTRAINT [DF_MMEFigures_datRevision]  DEFAULT (space((0))) FOR [datRevision]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_intAuthor]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] ADD  CONSTRAINT [DF_MMEFigures_intAuthor]  DEFAULT ((0)) FOR [intAuthor]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_intPage]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] ADD  CONSTRAINT [DF_MMEFigures_intPage]  DEFAULT ((0)) FOR [intPage]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_intPages]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] ADD  CONSTRAINT [DF_MMEFigures_intPages]  DEFAULT ((0)) FOR [intPages]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_txtImageFile]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] ADD  CONSTRAINT [DF_MMEFigures_txtImageFile]  DEFAULT (space((0))) FOR [txtImageFile]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_intVersion]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] ADD  CONSTRAINT [DF_MMEFigures_intVersion]  DEFAULT ((0)) FOR [intVersion]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_bolExpired]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] ADD  CONSTRAINT [DF_MMEFigures_bolExpired]  DEFAULT ((0)) FOR [bolExpired]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_txtSortkey]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] ADD  CONSTRAINT [DF_MMEFigures_txtSortkey]  DEFAULT (space((0))) FOR [txtSortkey]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_bitStdPath]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] ADD  CONSTRAINT [DF_MMEFigures_bitStdPath]  DEFAULT ((0)) FOR [bitStdPath]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_IntIDStdPath]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] ADD  CONSTRAINT [DF_MMEFigures_IntIDStdPath]  DEFAULT ((0)) FOR [IntIDStdPath]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_txtPath]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] ADD  CONSTRAINT [DF_MMEFigures_txtPath]  DEFAULT (space((0))) FOR [txtPath]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_LAST_CHANGE]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] ADD  CONSTRAINT [DF_MMEFigures_LAST_CHANGE]  DEFAULT (space((0))) FOR [LAST_CHANGE]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_MMEFigures_HISTORY]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MMEFigures] ADD  CONSTRAINT [DF_MMEFigures_HISTORY]  DEFAULT (space((0))) FOR [HISTORY]
END

GO