KsvMx5kb

1USE Emototron
2GO
3SET ANSI_NULLS ON
4GO
5SET QUOTED_IDENTIFIER ON
6GO
7
8--Drop and create Measurement table
9IF EXISTS(
10	SELECT 1 FROM sys.objects 
11	WHERE [object_id] = OBJECT_ID('dbo.Measurement')
12)
13	DROP TABLE dbo.Measurement
14
15CREATE TABLE dbo.Measurement(
16	EmotionId INT NOT NULL
17	,[Name] VARCHAR(20) NOT NULL
18	,[Level] INT NOT NULL
19	CONSTRAINT [PK_Measurement] PRIMARY KEY CLUSTERED(EmotionId ASC)
20)
21
22--Drop and create Input table
23IF EXISTS(
24	SELECT 1 FROM sys.objects 
25	WHERE [object_id] = OBJECT_ID('dbo.Input')
26)
27	DROP TABLE dbo.Input
28
29CREATE TABLE dbo.Input(
30	InputId BIGINT IDENTITY(1,1)
31	,EmotionId INT NOT NULL
32	,IPAddress VARCHAR(20) NOT NULL
33	,UpVote BIT NOT NULL
34	,CONSTRAINT [PK_Input] PRIMARY KEY CLUSTERED(InputId ASC)
35)