diff options
Diffstat (limited to 'create_rating.sql')
| -rw-r--r-- | create_rating.sql | 11 |
1 files changed, 0 insertions, 11 deletions
diff --git a/create_rating.sql b/create_rating.sql index 8cb60ee..f2d112e 100644 --- a/create_rating.sql +++ b/create_rating.sql @@ -1,14 +1,3 @@ -create table if not exists tracks( - date varchar(12) not null, - artist varchar(255) not null, - album varchar(255) not null, - title varchar(255) not null, - tracknumber smallint not null, - rating smallint not null -); -create index if not exists track_ratings_idx ON tracks (rating); -CREATE UNIQUE INDEX tracks_title_idx ON tracks (title); - create table if not exists albums( date varchar(12) not null, artist varchar(255) not null, |