mirror of
https://github.com/kuhyx/WUT_Computer_Science.git
synced 2026-07-04 14:03:08 +02:00
Krzysztof kuhy Rudnicki
838184c85b
git-subtree-dir: Programming/ERSMS-project git-subtree-mainline:7861d69ae9git-subtree-split:d060e8285a
21 lines
430 B
SQL
21 lines
430 B
SQL
CREATE TABLE users (
|
|
id SERIAL PRIMARY KEY,
|
|
username VARCHAR(255) NOT NULL,
|
|
oauth_ID VARCHAR(255) NOT NULL
|
|
);
|
|
|
|
CREATE TABLE ratings (
|
|
id SERIAL PRIMARY KEY,
|
|
movie_ID VARCHAR(255) NOT NULL,
|
|
oauth_ID VARCHAR(255) NOT NULL,
|
|
rating INTEGER NOT NULL,
|
|
rdate TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
|
|
);
|
|
|
|
INSERT INTO users (username, oauth_ID) VALUES
|
|
('Mkyong', 40),
|
|
('Ali', 28),
|
|
('Teoh', 18);
|
|
|
|
|