Repository navigation
Expand file tree
/
Copy pathh32blog.sql
More file actions
67 lines (61 loc) · 1.53 KB
/
Copy pathh32blog.sql
File metadata and controls
67 lines (61 loc) · 1.53 KB
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
55
56
57
58
59
60
61
62
63
64
65
66
67
drop database h32_blog;
SHOW DATABASES;
CREATE DATABASE h32_blog;
SHOW DATABASES;
USE h32_blog;
CREATE TABLE USER (
userID INT PRIMARY KEY AUTO_INCREMENT,
accountName VARCHAR(50) NOT NULL UNIQUE,
passWord VARCHAR(50) NOT NULL,
fullName VARCHAR(50) NOT NULL,
academicYear INT,
about TEXT,
major NVARCHAR(50),
currentJob TEXT
);
CREATE TABLE USERROLE (
userRoleID VARCHAR(50) PRIMARY KEY,
userRoleNote VARCHAR(50),
active BOOLEAN NOT NULL,
createByUserID INT
);
CREATE TABLE USERUSERROLE (
userID INT,
userRoleID VARCHAR(50),
PRIMARY KEY (userID, userRoleID),
FOREIGN KEY (userID) REFERENCES USER(userID),
FOREIGN KEY (userRoleID) REFERENCES USERROLE(userRoleID)
);
CREATE TABLE IMAGEUSER (
imageID VARCHAR(50) PRIMARY KEY,
userID INT NOT NULL,
imgURL TEXT NOT NULL,
imgUnBgURL TEXT NOT NULL,
FOREIGN KEY (userID) REFERENCES USER(userID)
);
CREATE TABLE LabImage (
labImageID VARCHAR(50) PRIMARY KEY,
userID INT NOT NULL,
tag VARCHAR (50),
description NVARCHAR(100) DEFAULT "img_lab",
year INT DEFAULT '1',
imgURL TEXT NOT NULL,
FOREIGN KEY (userID) REFERENCES USER(userID)
);
CREATE TABLE TimeLine (
timeLineID INT PRIMARY KEY AUTO_INCREMENT,
name TEXT NOT NULL,
tag VARCHAR(50),
description TEXT NOT NULL,
year INT DEFAULT '2',
title TEXT NOT NULL
);
CREATE TABLE Food(
foodID INT PRIMARY KEY AUTO_INCREMENT,
name TEXT NOT NULL,
imgFood TEXT,
minPrice DOUBLE NOT NULL,
maxPrice DOUBLE NOT NULL,
address TEXT,
moreInf TEXT
)