USE [SeiferCP]GOIF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_WebMarket_transaction_status]') AND type = 'D')BEGINALTER TABLE [dbo].[WebMarket] DROP CONSTRAINT [DF_WebMarket_transaction_status]ENDGOUSE [SeiferCP]GO/****** Object: Table [dbo].[WebMarket] Script Date: 11/29/2018 18:32:39 ******/IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WebMarket]') AND type in (N'U'))DROP TABLE [dbo].[WebMarket]GOUSE [SeiferCP]GO/****** Object: Table [dbo].[WebMarket] Script Date: 11/29/2018 18:32:39 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE [dbo].[WebMarket]( [transaction_id] [int] IDENTITY(1,1) NOT NULL, [sellerChaNum] [int] NULL, [sellerGold] [money] NULL, [sellerPrice] [int] NULL, [transaction_status] [int] NOT NULL, [buyerUsernum] [int] NULL) ON [PRIMARY]GOALTER TABLE [dbo].[WebMarket] ADD CONSTRAINT [DF_WebMarket_transaction_status] DEFAULT ((0)) FOR [transaction_status]GO