-
Notifications
You must be signed in to change notification settings - Fork 0
/
Planner.txt
40 lines (34 loc) · 1.05 KB
/
Planner.txt
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
ROBLOX Games Review
What to review?
- Name
- Creator
- Genre
- Description
- Visit
- Date release
- Link
- Img link
(Game ID)
action=/add
action=/edit
action=/delete
sql:
CREATE TABLE game_list(
id SERIAL PRIMARY KEY,
Creator VARCHAR(50),
Creator_Link VARCHAR(200),
Title VARCHAR(100),
Game_Link VARCHAR(200),
Date DATE,
Visits VARCHAR(15),
Genre VARCHAR(30),
Rating FLOAT,
Game_Image VARCHAR(200)
)
INSERT INTO game_list(creator, creator_link, title, game_link, date, visits, genre, rating, game_image)
VALUES
INSERT INTO game_list(creator, creator_link, title, game_link, date, visits, genre, rating, game_image)
VALUES ('vetexgames', 'https://www.roblox.com/users/5414629/profile/', 'Arcane Odyssey', 'https://www.roblox.com/games/3272915504/Arcane-Odyssey-Halloween', '2019-6-8', '109.2M','RPG', 9.26, 'https://tr.rbxcdn.com/180DAY-84940403ee2b433909e76c23a50b880a/256/256/Image/Webp/noFilter')
PH
INSERT INTO game_list (creator, creator_link, title, game_link, date, visits, genre, rating, game_image)
VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9);