· 5 years ago · Nov 16, 2020, 07:50 AM
1USE [docflow_hel]
2GO
3
4ALTER TABLE [dbo].[_customWssLinks] DROP CONSTRAINT [DF___customWs__chang__18A3331D]
5GO
6
7/****** Object: Table [dbo].[_customWssLinks] Script Date: 13.11.2020 15:36:07 ******/
8IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[_customWssLinks]') AND type in (N'U'))
9DROP TABLE [dbo].[_customWssLinks]
10GO
11
12/****** Object: Table [dbo].[_customWssLinks] Script Date: 13.11.2020 15:36:07 ******/
13SET ANSI_NULLS ON
14GO
15
16SET QUOTED_IDENTIFIER ON
17GO
18
19CREATE TABLE [dbo].[_customWssLinks](
20 [id] [int] IDENTITY(1,1) NOT NULL,
21 [uniqueId] [varchar](100) NOT NULL,
22 [change_date] [datetime] NOT NULL,
23 CONSTRAINT AK_TransactionID UNIQUE([uniqueId]),
24PRIMARY KEY CLUSTERED
25(
26 [id] ASC
27)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
28) ON [PRIMARY]
29GO
30
31ALTER TABLE [dbo].[_customWssLinks] ADD DEFAULT (getdate()) FOR [change_date]
32GO
33