USE [Revention] GO /****** Object: Table [dbo].[CustomerAddr] Script Date: 08/20/2018 09:37:59 ******/ CREATE TABLE [dbo].[CustomerAddr]( [AddrKey] [int] IDENTITY(1,1) NOT NULL, [StNumber] [nvarchar](15) NULL, [Street] [nvarchar](50) NULL, [Apt] [nvarchar](25) NULL, [City] [nvarchar](25) NULL, [State] [nvarchar](20) NULL, [Zip] [nvarchar](20) NULL, [AddrType] [nvarchar](10) NOT NULL, [CompanyName] [nvarchar](50) NULL, [EntryCode] [nvarchar](20) NULL, [AddrZone] [nvarchar](25) NULL, [CrossStreet] [nvarchar](40) NULL, [AddrGrid] [nvarchar](10) NULL, [BadChecksAddr] [bit] NOT NULL, [DoNotDeliver] [bit] NOT NULL, [EntSync] [datetime] NULL, [SyncStatus] [int] NOT NULL, [EntID] [int] NOT NULL, CONSTRAINT [PK_CustomerAddr] PRIMARY KEY CLUSTERED ( [AddrKey] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CustomerAddr] ADD CONSTRAINT [DF__CustomerA__BadCh__3CFEF876] DEFAULT (0) FOR [BadChecksAddr] GO ALTER TABLE [dbo].[CustomerAddr] ADD CONSTRAINT [DF__CustomerA__DoNot__23FE4082] DEFAULT (0) FOR [DoNotDeliver] GO ALTER TABLE [dbo].[CustomerAddr] ADD DEFAULT ((0)) FOR [SyncStatus] GO ALTER TABLE [dbo].[CustomerAddr] ADD DEFAULT ((0)) FOR [EntID] GO