14 lines
225 B
MySQL
14 lines
225 B
MySQL
|
DROP TABLE IF EXISTS movies;
|
||
|
|
|
||
|
|
CREATE TABLE movies (
|
||
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
||
|
|
number INTEGER,
|
||
|
|
title TEXT,
|
||
|
|
year INTEGER,
|
||
|
|
poster TEXT,
|
||
|
|
plot TEXT,
|
||
|
|
watched INTEGER,
|
||
|
|
watchDate TEXT,
|
||
|
|
score NUMBER
|
||
|
|
)
|