FilesExpand file tree

 master

/

CreateDatabase.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

54 lines (45 loc) · 1.58 KB

 master

/

CreateDatabase.sql

Copy path

Top

File metadata and controls

• Code
• Blame

54 lines (45 loc) · 1.58 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

/*

Copyright 2011 tSQLt

Licensed under the Apache License, Version 2.0 (the "License");

you may not use this file except in compliance with the License.

You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software

distributed under the License is distributed on an "AS IS" BASIS,

WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

See the License for the specific language governing permissions and

limitations under the License.

*/

USE tempdb;

IF(db_id('tSQLt_Example') IS NOT NULL)

EXEC('

ALTER DATABASE tSQLt_Example SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE;

USE tSQLt_Example;

ALTER DATABASE tSQLt_Example SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

USE tempdb;

DROP DATABASE tSQLt_Example;

');

CREATE DATABASE tSQLt_Example WITH TRUSTWORTHY ON;

GO

USE tSQLt_Example;

GO

------------------------------------------------------------------------------------

CREATE SCHEMA Accelerator;

GO

IF OBJECT_ID('Accelerator.Particle') IS NOT NULL DROP TABLE Accelerator.Particle;

GO

CREATE TABLE Accelerator.Particle(

Id INT IDENTITY(1,1) NOT NULL CONSTRAINT PK_Point_Id PRIMARY KEY,

X DECIMAL(10,2) NOT NULL,

Y DECIMAL(10,2) NOT NULL,

Value NVARCHAR(MAX) NOT NULL,

ColorId INT NOT NULL

);

GO

IF OBJECT_ID('Accelerator.Color') IS NOT NULL DROP TABLE Accelerator.Color;

GO

CREATE TABLE Accelerator.Color(

Id INT IDENTITY(1,1) NOT NULL CONSTRAINT PK_Color_Id PRIMARY KEY,

ColorName NVARCHAR(MAX) NOT NULL

);

GO