001.USE [master]
002.GO
003./****** Object: Database [mydatabase] Script Date: 01/08/2018 10:41:23 ******/
004.CREATE DATABASE [mydatabase] ON PRIMARY
005.( NAME = N'mydatabase_Data', FILENAME = N'D:\database\mydatabase_Data.MDF' , SIZE = 1984KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
006. LOG ON
007.( NAME = N'mydatabase_Log', FILENAME = N'D:\database\mydatabase_Log.LDF' , SIZE = 3136KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
008.GO
009.ALTER DATABASE [mydatabase] SET COMPATIBILITY_LEVEL = 80
010.GO
011.IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
012.begin
013.EXEC [mydatabase].[dbo].[sp_fulltext_database] @action = 'disable'
014.end
015.GO
016.ALTER DATABASE [mydatabase] SET ANSI_NULL_DEFAULT OFF
017.GO
018.ALTER DATABASE [mydatabase] SET ANSI_NULLS OFF
019.GO
020.ALTER DATABASE [mydatabase] SET ANSI_PADDING OFF
021.GO
022.ALTER DATABASE [mydatabase] SET ANSI_WARNINGS OFF
023.GO
024.ALTER DATABASE [mydatabase] SET ARITHABORT OFF
025.GO
026.ALTER DATABASE [mydatabase] SET AUTO_CLOSE OFF
027.GO
028.ALTER DATABASE [mydatabase] SET AUTO_CREATE_STATISTICS ON
029.GO
030.ALTER DATABASE [mydatabase] SET AUTO_SHRINK OFF
031.GO
032.ALTER DATABASE [mydatabase] SET AUTO_UPDATE_STATISTICS ON
033.GO
034.ALTER DATABASE [mydatabase] SET CURSOR_CLOSE_ON_COMMIT OFF
035.GO
036.ALTER DATABASE [mydatabase] SET CURSOR_DEFAULT GLOBAL
037.GO
038.ALTER DATABASE [mydatabase] SET CONCAT_NULL_YIELDS_NULL OFF
039.GO
040.ALTER DATABASE [mydatabase] SET NUMERIC_ROUNDABORT OFF
041.GO
042.ALTER DATABASE [mydatabase] SET QUOTED_IDENTIFIER OFF
043.GO
044.ALTER DATABASE [mydatabase] SET RECURSIVE_TRIGGERS OFF
045.GO
046.ALTER DATABASE [mydatabase] SET ENABLE_BROKER
047.GO
048.ALTER DATABASE [mydatabase] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
049.GO
050.ALTER DATABASE [mydatabase] SET DATE_CORRELATION_OPTIMIZATION OFF
051.GO
052.ALTER DATABASE [mydatabase] SET TRUSTWORTHY OFF
053.GO
054.ALTER DATABASE [mydatabase] SET ALLOW_SNAPSHOT_ISOLATION OFF
055.GO
056.ALTER DATABASE [mydatabase] SET PARAMETERIZATION SIMPLE
057.GO
058.ALTER DATABASE [mydatabase] SET READ_COMMITTED_SNAPSHOT OFF
059.GO
060.ALTER DATABASE [mydatabase] SET HONOR_BROKER_PRIORITY OFF
061.GO
062.ALTER DATABASE [mydatabase] SET READ_WRITE
063.GO
064.ALTER DATABASE [mydatabase] SET RECOVERY FULL
065.GO
066.ALTER DATABASE [mydatabase] SET MULTI_USER
067.GO
068.ALTER DATABASE [mydatabase] SET PAGE_VERIFY NONE
069.GO
070.ALTER DATABASE [mydatabase] SET DB_CHAINING OFF
071.GO
072.USE [mydatabase]
073.GO
074./****** Object: Table [dbo].[customer] Script Date: 01/08/2018 10:41:25 ******/
075.SET ANSI_NULLS ON
076.GO
077.SET QUOTED_IDENTIFIER ON
078.GO
079.SET ANSI_PADDING ON
080.GO
081.CREATE TABLE [dbo].[customer](
082. [CustomerID] [varchar](4) NOT NULL,
083. [Name] [varchar](50) NULL,
084. [Email] [varchar](50) NULL,
085. [CountryCode] [varchar](2) NULL,
086. [Budget] [float] NULL,
087. [Used] [float] NULL,
088. CONSTRAINT [PK_customer] PRIMARY KEY CLUSTERED
089.(
090. [CustomerID] ASC
091.)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
092.) ON [PRIMARY]
093.GO
094.SET ANSI_PADDING OFF
095.GO
096./****** Object: Table [dbo].[country] Script Date: 01/08/2018 10:41:25 ******/
097.SET ANSI_NULLS ON
098.GO
099.SET QUOTED_IDENTIFIER ON
100.GO
101.SET ANSI_PADDING ON
102.GO
103.CREATE TABLE [dbo].[country](
104. [CountryCode] [varchar](2) NOT NULL,
105. [CountryName] [varchar](50) NULL,
106. CONSTRAINT [PK_country] PRIMARY KEY CLUSTERED
107.(
108. [CountryCode] ASC
109.)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
110.) ON [PRIMARY]
111.GO
112.SET ANSI_PADDING OFF
113.GO
114./****** Object: Table [dbo].[audit] Script Date: 01/08/2018 10:41:25 ******/
115.SET ANSI_NULLS ON
116.GO
117.SET QUOTED_IDENTIFIER ON
118.GO
119.SET ANSI_PADDING ON
120.GO
121.CREATE TABLE [dbo].[audit](
122. [AuditID] [varchar](4) NOT NULL,
123. [CustomerID] [varchar](4) NULL,
124. [Date] [datetime] NULL,
125. [Used] [float] NULL,
126. CONSTRAINT [PK_audit] PRIMARY KEY CLUSTERED
127.(
128. [AuditID] ASC
129.)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
130.) ON [PRIMARY]
131.GO
132.SET ANSI_PADDING OFF
133.GO
134./****** Object: ForeignKey [FK_customer_audit] Script Date: 01/08/2018 10:41:25 ******/
135.ALTER TABLE [dbo].[audit] WITH NOCHECK ADD CONSTRAINT [FK_customer_audit] FOREIGN KEY([CustomerID])
136.REFERENCES [dbo].[customer] ([CustomerID])
137.ON UPDATE CASCADE
138.ON DELETE CASCADE
139.GO
140.ALTER TABLE [dbo].[audit] CHECK CONSTRAINT [FK_customer_audit]
141.GO
