Here you go... this doesn't include all the db tables just the relavent ones
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_DealerCountry_Country]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[DealerCountry] DROP CONSTRAINT FK_DealerCountry_Country
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_DealerCountry_Dealer]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[DealerCountry] DROP CONSTRAINT FK_DealerCountry_Dealer
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_DealerProximity_Dealer]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[DealerProximity] DROP CONSTRAINT FK_DealerProximity_Dealer
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_DealerAttribute_Dealer]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[DealerStoreAttribute] DROP CONSTRAINT FK_DealerAttribute_Dealer
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Country]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Country]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Dealer]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Dealer]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DealerCountry]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[DealerCountry]
GO
CREATE TABLE [dbo].[Country] (
[PKID] [int] IDENTITY (1, 1) NOT NULL ,
[Name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Code] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Dealer] (
[PKID] [int] IDENTITY (1, 1) NOT NULL ,
[StoreID] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[CountryID] [int] NULL ,
[Street1] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Street2] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[City] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Region] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[RegionID] [int] NULL ,
[PostalCode] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Phone] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Fax] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[URL] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Email] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SalesRep] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ARNumber] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Latitude] [float] NULL ,
[Longitude] [float] NULL ,
[StatusCode] [bit] NOT NULL ,
[UTCLastUpdatedDate] [datetime] NULL ,
[UpdatedBy] [int] NULL ,
[UTCCreatedDate] [datetime] NULL ,
[CreatedBy] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[DealerCountry] (
[DealerID] [int] NOT NULL ,
[CountryID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Country] WITH NOCHECK ADD
CONSTRAINT [PK_Country] PRIMARY KEY CLUSTERED
(
[PKID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Dealer] WITH NOCHECK ADD
CONSTRAINT [PK_Dealer] PRIMARY KEY CLUSTERED
(
[PKID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DealerCountry] WITH NOCHECK ADD
CONSTRAINT [PK_DealerCountry] PRIMARY KEY CLUSTERED
(
[DealerID],
[CountryID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Dealer] ADD
CONSTRAINT [DF_Dealer_IsActive] DEFAULT (1) FOR [StatusCode],
CONSTRAINT [DF_Dealer_Created] DEFAULT (getdate()) FOR [UTCCreatedDate]
GO
CREATE INDEX [IX_STORE] ON [dbo].[Dealer]([StoreID]) ON [PRIMARY]
GO
CREATE INDEX [IX_PKID_STOREID_NAME] ON [dbo].[Dealer]([PKID], [StoreID], [Name]) ON [PRIMARY]
GO
CREATE INDEX [IX_DealerName] ON [dbo].[Dealer]([Name]) ON [PRIMARY]
GO
CREATE INDEX [IX_DealerCity] ON [dbo].[Dealer]([City]) ON [PRIMARY]
GO
CREATE INDEX [IX_DealerRegion] ON [dbo].[Dealer]([Region]) ON [PRIMARY]
GO
CREATE INDEX [IX_DealerCountry] ON [dbo].[DealerCountry]([DealerID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DealerCountry] ADD
CONSTRAINT [FK_DealerCountry_Country] FOREIGN KEY
(
[CountryID]
) REFERENCES [dbo].[Country] (
[PKID]
),
CONSTRAINT [FK_DealerCountry_Dealer] FOREIGN KEY
(
[DealerID]
) REFERENCES [dbo].[Dealer] (
[PKID]
)
GO