summaryrefslogtreecommitdiff
path: root/dbschema.sql
diff options
context:
space:
mode:
authorKjetil Ørbekk <orbekk@pvv.ntnu.no>2008-08-12 21:44:18 +0200
committerKjetil Ørbekk <orbekk@pvv.ntnu.no>2008-08-12 21:44:18 +0200
commit425289cfe389c4a5c0eaed744fe1c637328fc8ef (patch)
tree122aa167009f4aa46d72e644314b3cdbc7c4b6f9 /dbschema.sql
parentb401c0765b296f2660550592cd4bd043f5f8203b (diff)
- Added extension and mtime to dbschema and scanning code
mtime: preparation for updating files already in the db extension: to include extension in the mp3fs hierarchy
Diffstat (limited to 'dbschema.sql')
-rw-r--r--dbschema.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/dbschema.sql b/dbschema.sql
index efa89f5..ec24d28 100644
--- a/dbschema.sql
+++ b/dbschema.sql
@@ -13,6 +13,8 @@ CREATE TABLE song (
genrename varchar(200),
filepath varchar(255),
year int,
+ extension varchar(50),
+ mtime int,
PRIMARY KEY(title, artistname, year)
);