-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathsetup.sql
More file actions
41 lines (36 loc) · 1.23 KB
/
Copy pathsetup.sql
File metadata and controls
41 lines (36 loc) · 1.23 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
CREATE DATABASE simple_app;
GO
USE simple_app;
GO
CREATE TABLE Employees (
id INT PRIMARY KEY AUTO_INCREMENT,
username VARCHAR(30) NOT NULL,
password VARCHAR(100) NOT NULL,
email VARCHAR(50)
);
GO
INSERT INTO Employees (username, password, email)
VALUES ('PhamHongPhuc', '123456789', 'php@gmail.com'),
('PhamHongPhuc1', '123456789', 'php1@gmail.com'),
('PhamHongPhuc2', '123456789', 'php2@gmail.com'),
('PhamHongPhuc3', '123456789', 'php3@gmail.com'),
('PhamHongPhuc4', '123456789', 'php4@gmail.com'),
('PhamHongPhuc5', '123456789', 'php5@gmail.com'),
('PhamHongPhuc6', '123456789', 'php6@gmail.com'),
('PhamHongPhuc7', '123456789', 'php7@gmail.com'),
('PhamHongPhuc8', '123456789', 'php8@gmail.com'),
('PhamHongPhuc9', '123456789', 'php9@gmail.com'),
('PhamHongPhuc10', '123456789', 'php10@gmail.com');
GO
CREATE TABLE Productions (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(30) NOT NULL,
amount INT NOT NULL,
employeeId INT,
FOREIGN KEY (employeeId) REFERENCES Employees(id)
);
GO
INSERT INTO Productions (name, amount, employeeId)
VALUES ('production1', 100, 1),
('production2', 200, 2),
('production3', 1000, 3);