diff options
| author | Kjetil Ørbekk <orbekk@pvv.ntnu.no> | 2008-08-13 19:57:14 +0200 |
|---|---|---|
| committer | Kjetil Ørbekk <orbekk@pvv.ntnu.no> | 2008-08-13 19:57:14 +0200 |
| commit | d88ae053d3d9de35a54b04d101148bce09bd1f84 (patch) | |
| tree | 8fd2c61fe26ce1f4e179203c30cbc6018829cbb1 /dbschema.sql | |
| parent | a7ecaad4b4c8c04244f6bbefc23ec06c05d66c7b (diff) | |
- Add track number on import [Rune Hammersland]
Diffstat (limited to 'dbschema.sql')
| -rw-r--r-- | dbschema.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/dbschema.sql b/dbschema.sql index ec24d28..2fcf0c9 100644 --- a/dbschema.sql +++ b/dbschema.sql @@ -13,9 +13,10 @@ CREATE TABLE song ( genrename varchar(200), filepath varchar(255), year int, + track varchar(8), extension varchar(50), mtime int, - PRIMARY KEY(title, artistname, year) + PRIMARY KEY(title, artistname, album, year) ); CREATE TABLE genre ( |