diff options
author | Kjetil Ørbekk <orbekk@pvv.ntnu.no> | 2008-08-12 21:44:18 +0200 |
---|---|---|
committer | Kjetil Ørbekk <orbekk@pvv.ntnu.no> | 2008-08-12 21:44:18 +0200 |
commit | 425289cfe389c4a5c0eaed744fe1c637328fc8ef (patch) | |
tree | 122aa167009f4aa46d72e644314b3cdbc7c4b6f9 /dbschema.sql | |
parent | b401c0765b296f2660550592cd4bd043f5f8203b (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.sql | 2 |
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) ); |