print 'Creating Northwind database'
USE [master]
GO
/****** Object: Database [D:\TFS\LIVELINQ\DEVELOPMENT\MAIN\SAMPLES\DATA\NORTHWND.MDF] Script Date: 08/13/2010 10:50:07 ******/
CREATE DATABASE [Northwind] ON PRIMARY
( NAME = N'Northwind', FILENAME = N'|DataFile|.MDF' , SIZE = 6144KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
LOG ON
( NAME = N'Northwind_log', FILENAME = N'|DataFile|_log.ldf' , SIZE = 1024KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [Northwind].[dbo].[sp_fulltext_database] @action = 'disable'
end
GO
ALTER DATABASE [Northwind] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [Northwind] SET ANSI_NULLS OFF
GO
ALTER DATABASE [Northwind] SET ANSI_PADDING OFF
GO
ALTER DATABASE [Northwind] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [Northwind] SET ARITHABORT OFF
GO
ALTER DATABASE [Northwind] SET AUTO_CLOSE ON
GO
ALTER DATABASE [Northwind] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [Northwind] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [Northwind] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [Northwind] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [Northwind] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [Northwind] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [Northwind] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [Northwind] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [Northwind] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [Northwind] SET DISABLE_BROKER
GO
ALTER DATABASE [Northwind] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [Northwind] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [Northwind] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [Northwind] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [Northwind] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [Northwind] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [Northwind] SET READ_WRITE
GO
ALTER DATABASE [Northwind] SET RECOVERY SIMPLE
GO
ALTER DATABASE [Northwind] SET MULTI_USER
GO
ALTER DATABASE [Northwind] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [Northwind] SET DB_CHAINING OFF
GO
USE [Northwind]
GO
/****** Object: Table [dbo].[Shippers] Script Date: 08/13/2010 11:05:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Shippers](
[ShipperID] [int] IDENTITY(1,1) NOT NULL,
[CompanyName] [nvarchar](40) NOT NULL,
[Phone] [nvarchar](24) NULL,
CONSTRAINT [PK_Shippers] PRIMARY KEY CLUSTERED
(
[ShipperID] 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
SET IDENTITY_INSERT [dbo].[Shippers] ON
INSERT [dbo].[Shippers] ([ShipperID], [CompanyName], [Phone]) VALUES (1, N'Speedy Express', N'(503) 555-9831')
INSERT [dbo].[Shippers] ([ShipperID], [CompanyName], [Phone]) VALUES (2, N'United Package', N'(503) 555-3199')
INSERT [dbo].[Shippers] ([ShipperID], [CompanyName], [Phone]) VALUES (3, N'Federal Shipping', N'(503) 555-9931')
SET IDENTITY_INSERT [dbo].[Shippers] OFF
/****** Object: Table [dbo].[Region] Script Date: 08/13/2010 11:05:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Region](
[RegionID] [int] NOT NULL,
[RegionDescription] [nchar](50) NOT NULL,
CONSTRAINT [PK_Region] PRIMARY KEY NONCLUSTERED
(
[RegionID] 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
INSERT [dbo].[Region] ([RegionID], [RegionDescription]) VALUES (1, N'Eastern ')
INSERT [dbo].[Region] ([RegionID], [RegionDescription]) VALUES (2, N'Western ')
INSERT [dbo].[Region] ([RegionID], [RegionDescription]) VALUES (3, N'Northern ')
INSERT [dbo].[Region] ([RegionID], [RegionDescription]) VALUES (4, N'Southern ')
/****** Object: Table [dbo].[Suppliers] Script Date: 08/13/2010 11:05:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Suppliers](
[SupplierID] [int] IDENTITY(1,1) NOT NULL,
[CompanyName] [nvarchar](40) NOT NULL,
[ContactName] [nvarchar](30) NULL,
[ContactTitle] [nvarchar](30) NULL,
[Address] [nvarchar](60) NULL,
[City] [nvarchar](15) NULL,
[Region] [nvarchar](15) NULL,
[PostalCode] [nvarchar](10) NULL,
[Country] [nvarchar](15) NULL,
[Phone] [nvarchar](24) NULL,
[Fax] [nvarchar](24) NULL,
[HomePage] [ntext] NULL,
CONSTRAINT [PK_Suppliers] PRIMARY KEY CLUSTERED
(
[SupplierID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [CompanyName] ON [dbo].[Suppliers]
(
[CompanyName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [PostalCode] ON [dbo].[Suppliers]
(
[PostalCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Suppliers] ON
INSERT [dbo].[Suppliers] ([SupplierID], [CompanyName], [ContactName], [ContactTitle], [Address], [City], [Region], [PostalCode], [Country], [Phone], [Fax], [HomePage]) VALUES (1, N'Exotic Liquids', N'Charlotte Cooper', N'Purchasing Manager', N'49 Gilbert St.', N'London', NULL, N'EC1 4SD', N'UK', N'(171) 555-2222', NULL, NULL)
INSERT [dbo].[Suppliers] ([SupplierID], [CompanyName], [ContactName], [ContactTitle], [Address], [City], [Region], [PostalCode], [Country], [Phone], [Fax], [HomePage]) VALUES (2, N'New Orleans Cajun Delights', N'Shelley Burke', N'Order Administrator', N'P.O. Box 78934', N'New Orleans', N'LA', N'70117', N'USA', N'(100) 555-4822', NULL, N'#CAJUN.HTM#')
INSERT [dbo].[Suppliers] ([SupplierID], [CompanyName], [ContactName], [ContactTitle], [Address], [City], [Region], [PostalCode], [Country], [Phone], [Fax], [HomePage]) VALUES (3, N'Grandma Kelly''s Homestead', N'Regina Murphy', N'Sales Representative', N'707 Oxford Rd.', N'Ann Arbor', N'MI', N'48104', N'USA', N'(313) 555-5735', N'(313) 555-3349', NULL)
INSERT [dbo].[Suppliers] ([SupplierID], [CompanyName], [ContactName], [ContactTitle], [Address], [City], [Region], [PostalCode], [Country], [Phone], [Fax], [HomePage]) VALUES (4, N'Tokyo Traders', N'Yoshi Nagase', N'Marketing Manager', N'9-8 Sekimai Musashino-shi', N'Tokyo', NULL, N'100', N'Japan', N'(03) 3555-5011', NULL, NULL)
INSERT [dbo].[Suppliers] ([SupplierID], [CompanyName], [ContactName], [ContactTitle], [Address], [City], [Region], [PostalCode], [Country], [Phone], [Fax], [HomePage]) VALUES (5, N'Cooperativa de Quesos ''Las Cabras''', N'Antonio del Valle Saavedra', N'Export Administrator', N'Calle del Rosal 4', N'Oviedo', N'Asturias', N'33007', N'Spain', N'(98) 598 76 54', NULL, NULL)
INSERT [dbo].[Suppliers] ([SupplierID], [CompanyName], [ContactName], [ContactTitle], [Address], [City], [Region], [PostalCode], [Country], [Phone], [Fax], [HomePage]) VALUES (6, N'Mayumi''s', N'Mayumi Ohno', N'Marketing Representative', N'92 Setsuko Chuo-ku', N'Osaka', NULL, N'545', N'Japan', N'(06) 431-7877', NULL, N'Mayumi''s (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps/mayumi.htm#')
INSERT [dbo].[Suppliers] ([SupplierID], [CompanyName], [ContactName], [ContactTitle], [Address], [City], [Region], [PostalCode], [Country], [Phone], [Fax], [HomePage]) VALUES (7, N'Pavlova, Ltd.', N'Ian Devling', N'Marketi