diff options
author | Rasmus Steinke <rasi@xssn.at> | 2014-10-04 20:00:18 +0200 |
---|---|---|
committer | Rasmus Steinke <rasi@xssn.at> | 2014-10-04 20:00:18 +0200 |
commit | 0ef401e3922946c241aa59b893ff2ae5c48e907a (patch) | |
tree | 677391ea2e93aa9940d23d3d9b150b498b5c87c4 /create_rating.sql | |
parent | 9bf16c75228f789c57604d39982444b16adbd434 (diff) | |
download | perl-app-clerk-0ef401e3922946c241aa59b893ff2ae5c48e907a.tar.gz perl-app-clerk-0ef401e3922946c241aa59b893ff2ae5c48e907a.tar.xz |
finished up track ratings support, removed some 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, |