USE [site_fuchs] GO ALTER TABLE [dbo].[fuchs_debug] DROP CONSTRAINT [DF_fuchs_debug_date] GO /****** Object: Table [dbo].[fuchs_debug] Script Date: 02.12.2020 21:05:05 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[fuchs_debug]') AND type in (N'U')) DROP TABLE [dbo].[fuchs_debug] GO /****** Object: Table [dbo].[fuchs_debug] Script Date: 02.12.2020 21:05:06 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[fuchs_debug]( [rn] [bigint] IDENTITY(1,1) NOT NULL, [interface] [varchar](50) NOT NULL, [url] [varchar](500) NULL, [data] [nvarchar](max) NULL, [date] [datetime] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER AUTHORIZATION ON [dbo].[fuchs_debug] TO SCHEMA OWNER GO ALTER TABLE [dbo].[fuchs_debug] ADD CONSTRAINT [DF_fuchs_debug_date] DEFAULT (getutcdate()) FOR [date] GO