14 lines
241 B
MySQL
14 lines
241 B
MySQL
|
CREATE TABLE IF NOT EXISTS track (
|
||
|
|
filepath TEXT PRIMARY KEY,
|
||
|
|
artist TEXT,
|
||
|
|
albumartist TEXT,
|
||
|
|
date TEXT,
|
||
|
|
album TEXT,
|
||
|
|
discnumber TEXT,
|
||
|
|
tracknumber TEXT,
|
||
|
|
title TEXT,
|
||
|
|
genre TEXT,
|
||
|
|
length FLOAT,
|
||
|
|
last_modified TIMESTAMP WITH TIME ZONE
|
||
|
|
)
|