summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorRasmus Steinke <rasi@xssn.at>2014-08-25 22:20:54 +0200
committerRasmus Steinke <rasi@xssn.at>2014-08-25 22:20:54 +0200
commit3742a00a6aafdd08c0c6c4bdc095009a0ecd86e8 (patch)
treeecba467713964dd1164549b21331a8c460936b87
parenta560dff0c8d3626fbe5cd95d955b40f2847f05ba (diff)
downloadperl-app-clerk-3742a00a6aafdd08c0c6c4bdc095009a0ecd86e8.tar.gz
perl-app-clerk-3742a00a6aafdd08c0c6c4bdc095009a0ecd86e8.tar.xz
add titles to tracks table
-rw-r--r--create_rating.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/create_rating.sql b/create_rating.sql
index cf59285..53d5c34 100644
--- a/create_rating.sql
+++ b/create_rating.sql
@@ -1,6 +1,7 @@
create table if not exists tracks(
date varchar(12) not null,
artist varchar(255) not null,
+ title varchar(255) not null,
album varchar(255) not null,
directory varchar(500) not null,
rating smallint not null