diff options
| author | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2009-06-02 01:42:55 +0000 |
|---|---|---|
| committer | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2009-06-02 01:42:55 +0000 |
| commit | 94f5610ef6c66dc094372e76df9a6d8783e9bc7f (patch) | |
| tree | 90b9f2c265c29f50cd0e5a366b8a3cd90ee78593 /sql/ampache.sql | |
| parent | 778fe71fed0de15b7cda3efcf30d90739ec46c78 (diff) | |
| download | ampache-94f5610ef6c66dc094372e76df9a6d8783e9bc7f.tar.gz ampache-94f5610ef6c66dc094372e76df9a6d8783e9bc7f.tar.bz2 ampache-94f5610ef6c66dc094372e76df9a6d8783e9bc7f.zip | |
add MBID support Thx flowerysong
Diffstat (limited to 'sql/ampache.sql')
| -rw-r--r-- | sql/ampache.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/ampache.sql b/sql/ampache.sql index 56ea00c7..602de62d 100644 --- a/sql/ampache.sql +++ b/sql/ampache.sql @@ -76,6 +76,7 @@ CREATE TABLE `album` ( `id` int(11) unsigned NOT NULL auto_increment, `name` varchar(255) character set utf8 default NULL, `prefix` varchar(32) character set utf8 default NULL, + `mbid` varchar(36) default NULL, `year` int(4) unsigned NOT NULL default '1984', `disk` smallint(5) unsigned default NULL, PRIMARY KEY (`id`), @@ -132,6 +133,7 @@ CREATE TABLE `artist` ( `id` int(11) unsigned NOT NULL auto_increment, `name` varchar(255) character set utf8 default NULL, `prefix` varchar(32) character set utf8 default NULL, + `mbid` varchar(36) default NULL, PRIMARY KEY (`id`), KEY `name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; @@ -716,6 +718,7 @@ CREATE TABLE `song` ( `size` int(11) unsigned NOT NULL default '0', `time` smallint(5) unsigned NOT NULL default '0', `track` smallint(5) unsigned default NULL, + `mbid` varchar(36) default NULL, `played` tinyint(1) unsigned NOT NULL default '0', `enabled` tinyint(1) unsigned NOT NULL default '1', `update_time` int(11) unsigned default '0', |