summaryrefslogtreecommitdiff
path: root/dbschema.sql
diff options
context:
space:
mode:
authorUlf Lilleengen <lulf@carrot.studby.ntnu.no>2008-08-09 14:41:29 +0200
committerUlf Lilleengen <lulf@carrot.studby.ntnu.no>2008-08-09 14:41:29 +0200
commitcfa01e2eded5e91a9272d1578e48540199c8b2d8 (patch)
tree5e6b63b4feb7f8e3604fcdf90d3d35b2ce33d712 /dbschema.sql
parente8793de12358e0f6f9239cd93cdf4e6f54a40702 (diff)
- Rename list to lookup, and change it, so a generic lookup callback that
will be called with the retrieved data can be specified. - Add filepath to the database schema.
Diffstat (limited to 'dbschema.sql')
-rw-r--r--dbschema.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/dbschema.sql b/dbschema.sql
index 7528591..efa89f5 100644
--- a/dbschema.sql
+++ b/dbschema.sql
@@ -11,6 +11,7 @@ CREATE TABLE song (
album varchar(200),
artistname varchar(200),
genrename varchar(200),
+ filepath varchar(255),
year int,
PRIMARY KEY(title, artistname, year)
);