aWSCzTUA

1CREATE DATABASE IF NOT EXISTS QA
2GO
3USE QA
4GO
5CREATE TABLE Users
6(
7UserID int identity(-2147483648,1),
8Name varchar(150),
9fname varchar(150),
10isadmin bit,
11CONSTRAINT PK_Users PRIMARY KEY CLUSTERED (UserID),
12)
13
14GO
15CREATE TABLE Question
16(
17QuestionID int identity(-2147483648,1),
18UserID int,
19Question varchar(max),
20CONSTRAINT PK_Question PRIMARY KEY CLUSTERED (QuestionID),
21CONSTRAINT FK_UserQuestion FOREIGN KEY (UserID)     
22    REFERENCES dbo.Users (UserID) 
23)
24GO
25CREATE TABLE Answer
26(
27AnswerID int identity(-2147483648,1),
28QuestionID int,
29UserID int,
30Answer varchar(max),
31IsSolver bit,
32CONSTRAINT PK_Answer PRIMARY KEY CLUSTERED (AnswerID),
33CONSTRAINT FK_UserAnswer FOREIGN KEY (UserID)     
34    REFERENCES dbo.Users (UserID) ,
35CONSTRAINT FK_AnswerQuestion FOREIGN KEY (UserID)     
36    REFERENCES dbo.Question (QuestionID) 
37)
38GO
39	
40CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name
41[create_specification] ...
42	
43CREATE DATABASE QA;
44
45CREATE TABLE QA.Users
46(
47UserID int AUTO_INCREMENT PRIMARY KEY,
48Name varchar(150),
49fname varchar(150),
50isadmin bit
51) engine = INNODB;
52
53CREATE TABLE QA.Question
54(
55QuestionID int AUTO_INCREMENT PRIMARY KEY,
56UserID int,
57Question varchar(max),
58FOREIGN KEY (FK_UserQuestion,UserID)     
59    REFERENCES QA.Users (UserID) 
60) engine = INNODB;
61
62CREATE TABLE QA.Answer
63(
64AnswerID int AUTO_INCREMENT PRIMARY KEY,
65QuestionID int,
66UserID int,
67Answer varchar(max),
68IsSolver bit,
69FOREIGN KEY (User_ID, UserID)
70    REFERENCES QA.Users(UserID)
71FOREIGN KEY ( FK_AnswerQuestion,QuestionID)     
72    REFERENCES QA.Question (QuestionID) 
73) engine = INNODB;
74	
75CREATE DATABASE QA;
76
77    CREATE TABLE QA.Users
78    (
79     UserID int NOT NULL AUTO_INCREMENT,
80     Name varchar(150),
81     fname varchar(150),
82     isadmin bit,
83     PRIMARY KEY (UserID)
84    ) engine = INNODB;
85
86    CREATE TABLE QA.Question
87    (
88    QuestionID int NOT NULL AUTO_INCREMENT,
89    UserID int,
90    Question varchar(150),
91    PRIMARY KEY (QuestionID),
92    FOREIGN KEY (FK_UserQuestion,UserID)     
93    REFERENCES Users (UserID) 
94    ) engine = INNODB;
95
96    CREATE TABLE QA.Answer
97    (
98    AnswerID int NOT NULL AUTO_INCREMENT,
99    QuestionID int,
100    UserID int,
101    Answer varchar(150),
102    IsSolver bit,
103    PRIMARY KEY (AnswerID),
104    FOREIGN KEY (User_ID, UserID)
105    REFERENCES Users(UserID),
106    FOREIGN KEY ( FK_AnswerQuestion,QuestionID)     
107    REFERENCES Question (QuestionID) 
108    ) engine = INNODB;