19 lines
533 B
SQL
19 lines
533 B
SQL
CREATE TABLE IF NOT EXISTS videos (
|
|
file_name VARCHAR(255) PRIMARY KEY,
|
|
raw_file VARCHAR(255) UNIQUE,
|
|
duration DECIMAL(10,2),
|
|
mp4_file VARCHAR(255),
|
|
mp4_file_name VARCHAR(255),
|
|
rotated_file VARCHAR(255),
|
|
thumbnail_file VARCHAR(255),
|
|
record_datetime TIMESTAMP,
|
|
day_of_week VARCHAR(50),
|
|
record_time TIME GENERATED ALWAYS AS (TIME(record_datetime)) VIRTUAL,
|
|
lat DECIMAL(10,6),
|
|
long DECIMAL(11,7),
|
|
address VARCHAR(255),
|
|
difficulty_level VARCHAR(255) DEFAULT 'Tout niveau',
|
|
alias VARCHAR(255) DEFAULT ''
|
|
);
|
|
|