224 lines
16 KiB
Transact-SQL
224 lines
16 KiB
Transact-SQL
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
|