new version of the database, all fields were changed to utf-8_ci

1 files changed, 164 insertions, 122 deletions

diff --git a/sql/ampache.sql b/sql/ampache.sql
index bcf1aab0..71a933a5 100755
--- a/sql/ampache.sql
+++ b/sql/ampache.sql
@@ -1,30 +1,18 @@
--- 
---
--- Copyright (c) 2001 - 2007 Ampache.org
--- All rights reserved.
---
--- This program is free software; you can redistribute it and/or
--- modify it under the terms of the GNU General Public License v2
--- as published by the Free Software Foundation.
---
--- This program is distributed in the hope that it will be useful,
--- but WITHOUT ANY WARRANTY; without even the implied warranty of
--- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
--- GNU General Public License for more details.
---
--- You should have received a copy of the GNU General Public License
--- along with this program; if not, write to the Free Software
--- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
 -- MySQL dump 10.11
 --
 -- Host: localhost    Database: ampache
 -- ------------------------------------------------------
 -- Server version	5.0.45-Debian_1-log
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
 /*!40103 SET TIME_ZONE='+00:00' */;
 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
-/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL40' */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 
 --
@@ -34,18 +22,19 @@
 DROP TABLE IF EXISTS `access_list`;
 CREATE TABLE `access_list` (
   `id` int(11) unsigned NOT NULL auto_increment,
-  `name` varchar(255) NOT NULL default '',
+  `name` varchar(255) collate utf8_unicode_ci NOT NULL,
   `start` int(11) unsigned NOT NULL default '0',
   `end` int(11) unsigned NOT NULL default '0',
+  `dns` varchar(255) collate utf8_unicode_ci NOT NULL,
   `level` smallint(3) unsigned NOT NULL default '5',
-  `type` varchar(64) NOT NULL default 'interface',
+  `type` varchar(64) collate utf8_unicode_ci NOT NULL default 'interface',
   `user` int(11) NOT NULL,
-  `key` varchar(255) default NULL,
+  `key` varchar(255) collate utf8_unicode_ci default NULL,
   PRIMARY KEY  (`id`),
   KEY `start` (`start`),
   KEY `end` (`end`),
   KEY `level` (`level`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `access_list`
@@ -63,13 +52,15 @@ UNLOCK TABLES;
 DROP TABLE IF EXISTS `album`;
 CREATE TABLE `album` (
   `id` int(11) unsigned NOT NULL auto_increment,
-  `name` varchar(255) NOT NULL default '',
-  `prefix` enum('The','An','A','Der','Die','Das','Ein','Eine') default NULL,
+  `name` varchar(255) collate utf8_unicode_ci NOT NULL,
+  `prefix` enum('The','An','A','Der','Die','Das','Ein','Eine') collate utf8_unicode_ci default NULL,
   `year` int(4) unsigned NOT NULL default '1984',
+  `disk` smallint(5) unsigned default NULL,
   PRIMARY KEY  (`id`),
   KEY `name` (`name`),
-  KEY `year` (`year`)
-) TYPE=MyISAM;
+  KEY `year` (`year`),
+  KEY `disk` (`disk`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `album`
@@ -88,11 +79,11 @@ DROP TABLE IF EXISTS `album_data`;
 CREATE TABLE `album_data` (
   `album_id` int(11) unsigned NOT NULL,
   `art` mediumblob,
-  `art_mime` varchar(64) default NULL,
+  `art_mime` varchar(64) collate utf8_unicode_ci default NULL,
   `thumb` blob,
-  `thumb_mime` varchar(64) default NULL,
+  `thumb_mime` varchar(64) collate utf8_unicode_ci default NULL,
   UNIQUE KEY `album_id` (`album_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `album_data`
@@ -110,11 +101,11 @@ UNLOCK TABLES;
 DROP TABLE IF EXISTS `artist`;
 CREATE TABLE `artist` (
   `id` int(11) unsigned NOT NULL auto_increment,
-  `name` varchar(255) NOT NULL default '',
-  `prefix` enum('The','An','A','Der','Die','Das','Ein','Eine') default NULL,
+  `name` varchar(255) collate utf8_unicode_ci NOT NULL,
+  `prefix` enum('The','An','A','Der','Die','Das','Ein','Eine') collate utf8_unicode_ci default NULL,
   PRIMARY KEY  (`id`),
   KEY `name` (`name`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `artist`
@@ -126,25 +117,49 @@ LOCK TABLES `artist` WRITE;
 UNLOCK TABLES;
 
 --
+-- Table structure for table `artist_data`
+--
+
+DROP TABLE IF EXISTS `artist_data`;
+CREATE TABLE `artist_data` (
+  `artist_id` int(11) unsigned NOT NULL,
+  `art` mediumblob NOT NULL,
+  `art_mime` varchar(32) collate utf8_unicode_ci NOT NULL,
+  `thumb` blob NOT NULL,
+  `thumb_mime` varchar(32) collate utf8_unicode_ci NOT NULL,
+  `bio` text collate utf8_unicode_ci NOT NULL,
+  UNIQUE KEY `artist_id` (`artist_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+
+--
+-- Dumping data for table `artist_data`
+--
+
+LOCK TABLES `artist_data` WRITE;
+/*!40000 ALTER TABLE `artist_data` DISABLE KEYS */;
+/*!40000 ALTER TABLE `artist_data` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
 -- Table structure for table `catalog`
 --
 
 DROP TABLE IF EXISTS `catalog`;
 CREATE TABLE `catalog` (
   `id` int(11) unsigned NOT NULL auto_increment,
-  `name` varchar(128) NOT NULL default '',
-  `path` varchar(255) NOT NULL default '',
-  `catalog_type` enum('local','remote') NOT NULL default 'local',
+  `name` varchar(128) collate utf8_unicode_ci NOT NULL,
+  `path` varchar(255) collate utf8_unicode_ci NOT NULL,
+  `catalog_type` enum('local','remote') collate utf8_unicode_ci NOT NULL default 'local',
   `last_update` int(11) unsigned NOT NULL default '0',
   `last_add` int(11) unsigned NOT NULL default '0',
   `enabled` tinyint(1) unsigned NOT NULL default '1',
-  `rename_pattern` varchar(255) NOT NULL default '%a - %T - %t.mp3',
-  `sort_pattern` varchar(255) NOT NULL default '%C/%a/%A',
-  `gather_types` varchar(255) NOT NULL default '',
-  `key` varchar(255) NOT NULL default '',
+  `rename_pattern` varchar(255) collate utf8_unicode_ci NOT NULL default '%a - %T - %t.mp3',
+  `sort_pattern` varchar(255) collate utf8_unicode_ci NOT NULL default '%C/%a/%A',
+  `gather_types` varchar(255) collate utf8_unicode_ci NOT NULL,
+  `key` varchar(255) collate utf8_unicode_ci NOT NULL,
   PRIMARY KEY  (`id`),
   KEY `enabled` (`enabled`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `catalog`
@@ -163,18 +178,18 @@ DROP TABLE IF EXISTS `flagged`;
 CREATE TABLE `flagged` (
   `id` int(11) unsigned NOT NULL auto_increment,
   `object_id` int(11) unsigned NOT NULL default '0',
-  `object_type` enum('artist','album','song') NOT NULL default 'song',
+  `object_type` enum('artist','album','song') collate utf8_unicode_ci NOT NULL default 'song',
   `user` int(11) NOT NULL,
-  `flag` enum('delete','retag','reencode','other') NOT NULL default 'other',
+  `flag` enum('delete','retag','reencode','other') collate utf8_unicode_ci NOT NULL default 'other',
   `date` int(11) unsigned NOT NULL default '0',
   `approved` tinyint(1) unsigned NOT NULL default '0',
-  `comment` varchar(255) NOT NULL default '',
+  `comment` varchar(255) collate utf8_unicode_ci NOT NULL,
   PRIMARY KEY  (`id`),
   KEY `date` (`date`,`approved`),
   KEY `object_id` (`object_id`),
   KEY `object_type` (`object_type`),
   KEY `user` (`user`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `flagged`
@@ -192,10 +207,10 @@ UNLOCK TABLES;
 DROP TABLE IF EXISTS `genre`;
 CREATE TABLE `genre` (
   `id` int(11) unsigned NOT NULL auto_increment,
-  `name` varchar(255) NOT NULL default '',
+  `name` varchar(255) collate utf8_unicode_ci NOT NULL,
   PRIMARY KEY  (`id`),
   KEY `name` (`name`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `genre`
@@ -220,7 +235,7 @@ CREATE TABLE `ip_history` (
   KEY `username` (`user`),
   KEY `date` (`date`),
   KEY `ip` (`ip`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `ip_history`
@@ -238,18 +253,18 @@ UNLOCK TABLES;
 DROP TABLE IF EXISTS `live_stream`;
 CREATE TABLE `live_stream` (
   `id` int(11) unsigned NOT NULL auto_increment,
-  `name` varchar(128) NOT NULL default '',
-  `site_url` varchar(255) NOT NULL default '',
-  `url` varchar(255) NOT NULL default '',
+  `name` varchar(128) collate utf8_unicode_ci NOT NULL,
+  `site_url` varchar(255) collate utf8_unicode_ci NOT NULL,
+  `url` varchar(255) collate utf8_unicode_ci NOT NULL,
   `genre` int(11) unsigned NOT NULL default '0',
   `catalog` int(11) unsigned NOT NULL default '0',
-  `frequency` varchar(32) NOT NULL default '',
-  `call_sign` varchar(32) NOT NULL default '',
+  `frequency` varchar(32) collate utf8_unicode_ci NOT NULL,
+  `call_sign` varchar(32) collate utf8_unicode_ci NOT NULL,
   PRIMARY KEY  (`id`),
   KEY `catalog` (`catalog`),
   KEY `genre` (`genre`),
   KEY `name` (`name`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `live_stream`
@@ -266,12 +281,12 @@ UNLOCK TABLES;
 
 DROP TABLE IF EXISTS `now_playing`;
 CREATE TABLE `now_playing` (
-  `id` varchar(64) NOT NULL,
+  `id` varchar(64) collate utf8_unicode_ci NOT NULL,
   `song_id` int(11) unsigned NOT NULL default '0',
   `user` int(11) NOT NULL,
   `expire` int(11) unsigned NOT NULL default '0',
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `now_playing`
@@ -289,7 +304,7 @@ UNLOCK TABLES;
 DROP TABLE IF EXISTS `object_count`;
 CREATE TABLE `object_count` (
   `id` int(11) unsigned NOT NULL auto_increment,
-  `object_type` enum('album','artist','song','playlist','genre','catalog','live_stream','video') NOT NULL default 'song',
+  `object_type` enum('album','artist','song','playlist','genre','catalog','live_stream','video') collate utf8_unicode_ci NOT NULL default 'song',
   `object_id` int(11) unsigned NOT NULL default '0',
   `date` int(11) unsigned NOT NULL default '0',
   `user` int(11) unsigned NOT NULL,
@@ -298,7 +313,7 @@ CREATE TABLE `object_count` (
   KEY `object_id` (`object_id`),
   KEY `userid` (`user`),
   KEY `date` (`date`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `object_count`
@@ -316,15 +331,15 @@ UNLOCK TABLES;
 DROP TABLE IF EXISTS `playlist`;
 CREATE TABLE `playlist` (
   `id` int(11) unsigned NOT NULL auto_increment,
-  `name` varchar(128) NOT NULL default '',
+  `name` varchar(128) collate utf8_unicode_ci NOT NULL,
   `user` int(11) NOT NULL,
-  `type` enum('private','public') NOT NULL default 'private',
+  `type` enum('private','public') collate utf8_unicode_ci NOT NULL default 'private',
   `genre` int(11) unsigned NOT NULL,
-  `date` timestamp NOT NULL,
+  `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
   PRIMARY KEY  (`id`),
   KEY `name` (`name`),
   KEY `type` (`type`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `playlist`
@@ -344,12 +359,12 @@ CREATE TABLE `playlist_data` (
   `id` int(11) unsigned NOT NULL auto_increment,
   `playlist` int(11) unsigned NOT NULL default '0',
   `object_id` int(11) unsigned default NULL,
-  `object_type` varchar(32) NOT NULL default 'song',
-  `dynamic_song` text,
+  `object_type` varchar(32) collate utf8_unicode_ci NOT NULL default 'song',
+  `dynamic_song` text collate utf8_unicode_ci,
   `track` int(11) unsigned NOT NULL default '0',
   PRIMARY KEY  (`id`),
   KEY `playlist` (`playlist`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `playlist_data`
@@ -367,16 +382,16 @@ UNLOCK TABLES;
 DROP TABLE IF EXISTS `preference`;
 CREATE TABLE `preference` (
   `id` int(11) unsigned NOT NULL auto_increment,
-  `name` varchar(128) NOT NULL default '',
-  `value` varchar(255) NOT NULL default '',
-  `description` varchar(255) NOT NULL default '',
+  `name` varchar(128) collate utf8_unicode_ci NOT NULL,
+  `value` varchar(255) collate utf8_unicode_ci NOT NULL,
+  `description` varchar(255) collate utf8_unicode_ci NOT NULL,
   `level` int(11) unsigned NOT NULL default '100',
-  `type` varchar(128) NOT NULL default '',
-  `catagory` varchar(128) NOT NULL default '',
+  `type` varchar(128) collate utf8_unicode_ci NOT NULL,
+  `catagory` varchar(128) collate utf8_unicode_ci NOT NULL,
   PRIMARY KEY  (`id`),
   KEY `catagory` (`catagory`),
   KEY `name` (`name`)
-) TYPE=MyISAM AUTO_INCREMENT=56;
+) ENGINE=MyISAM AUTO_INCREMENT=56 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `preference`
@@ -384,7 +399,7 @@ CREATE TABLE `preference` (
 
 LOCK TABLES `preference` WRITE;
 /*!40000 ALTER TABLE `preference` DISABLE KEYS */;
-INSERT INTO `preference` VALUES (1,'download','0','Allow Downloads',100,'boolean','options'),(4,'popular_threshold','10','Popular Threshold',25,'integer','interface'),(19,'sample_rate','32','Transcode Bitrate',25,'string','streaming'),(22,'site_title','Ampache :: Pour l\'Amour de la Musique','Website Title',100,'string','system'),(23,'lock_songs','0','Lock Songs',100,'boolean','system'),(24,'force_http_play','1','Forces Http play regardless of port',100,'boolean','system'),(25,'http_port','80','Non-Standard Http Port',100,'integer','system'),(26,'catalog_echo_count','100','Catalog Echo Interval',100,'integer','system'),(41,'localplay_controller','0','Localplay Type',100,'special','streaming'),(29,'play_type','stream','Type of Playback',25,'special','streaming'),(30,'direct_link','1','Allow Direct Links',100,'boolean','options'),(31,'lang','en_US','Language',100,'special','interface'),(32,'playlist_type','m3u','Playlist Type',100,'special','playlist'),(33,'theme_name','classic','Theme',0,'special','interface'),(34,'ellipse_threshold_album','27','Album Ellipse Threshold',0,'integer','interface'),(35,'ellipse_threshold_artist','27','Artist Ellipse Threshold',0,'integer','interface'),(36,'ellipse_threshold_title','27','Title Ellipse Threshold',0,'integer','interface'),(51,'offset_limit','50','Offset Limit',5,'integer','interface'),(40,'localplay_level','0','Localplay Access Level',100,'special','streaming'),(44,'allow_stream_playback','1','Allow Streaming',100,'boolean','system'),(45,'allow_democratic_playback','0','Allow Democratic Play',100,'boolean','system'),(46,'allow_localplay_playback','0','Allow Localplay Play',100,'boolean','system'),(47,'stats_threshold','7','Statistics Day Threshold',25,'integer','interface'),(49,'min_object_count','1','Min Element Count',5,'integer','interface'),(52,'rate_limit','8192','Rate Limit',100,'integer','streaming'),(53,'playlist_method','normal','Playlist Method',5,'string','playlist'),(54,'playlist_add','append','Add Behavior',5,'string','playlist'),(55,'transcode','default','Transcoding',25,'string','streaming');
+INSERT INTO `preference` VALUES (1,'download','0','Allow Downloads',100,'boolean','options'),(4,'popular_threshold','10','Popular Threshold',25,'integer','interface'),(19,'sample_rate','32','Transcode Bitrate',25,'string','streaming'),(22,'site_title','Ampache :: Pour l\'Amour de la Musique','Website Title',100,'string','system'),(23,'lock_songs','0','Lock Songs',100,'boolean','system'),(24,'force_http_play','1','Forces Http play regardless of port',100,'boolean','system'),(25,'http_port','80','Non-Standard Http Port',100,'integer','system'),(26,'catalog_echo_count','100','Catalog Echo Interval',100,'integer','system'),(41,'localplay_controller','0','Localplay Type',100,'special','options'),(29,'play_type','stream','Type of Playback',25,'special','streaming'),(30,'direct_link','1','Allow Direct Links',100,'boolean','options'),(31,'lang','en_US','Language',100,'special','interface'),(32,'playlist_type','m3u','Playlist Type',100,'special','playlist'),(33,'theme_name','classic','Theme',0,'special','interface'),(34,'ellipse_threshold_album','27','Album Ellipse Threshold',0,'integer','interface'),(35,'ellipse_threshold_artist','27','Artist Ellipse Threshold',0,'integer','interface'),(36,'ellipse_threshold_title','27','Title Ellipse Threshold',0,'integer','interface'),(51,'offset_limit','50','Offset Limit',5,'integer','interface'),(40,'localplay_level','0','Localplay Config',100,'special','options'),(44,'allow_stream_playback','1','Allow Streaming',100,'boolean','system'),(45,'allow_democratic_playback','0','Allow Democratic Play',100,'boolean','system'),(46,'allow_localplay_playback','0','Allow Localplay Play',100,'boolean','system'),(47,'stats_threshold','7','Statistics Day Threshold',25,'integer','interface'),(49,'min_object_count','1','Min Element Count',5,'integer','interface'),(52,'rate_limit','8192','Rate Limit',100,'integer','streaming'),(53,'playlist_method','default','Playlist Method',5,'string','playlist'),(55,'transcode','default','Transcoding',25,'string','streaming');
 /*!40000 ALTER TABLE `preference` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -396,12 +411,12 @@ DROP TABLE IF EXISTS `rating`;
 CREATE TABLE `rating` (
   `id` int(11) unsigned NOT NULL auto_increment,
   `user` int(11) NOT NULL,
-  `object_type` enum('artist','album','song','steam','video') NOT NULL default 'artist',
+  `object_type` enum('artist','album','song','steam','video') collate utf8_unicode_ci NOT NULL default 'artist',
   `object_id` int(11) unsigned NOT NULL default '0',
-  `rating` enum('-1','0','1','2','3','4','5') NOT NULL default '0',
+  `rating` enum('-1','0','1','2','3','4','5') collate utf8_unicode_ci NOT NULL default '0',
   PRIMARY KEY  (`id`),
   KEY `object_id` (`object_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `rating`
@@ -418,15 +433,15 @@ UNLOCK TABLES;
 
 DROP TABLE IF EXISTS `session`;
 CREATE TABLE `session` (
-  `id` varchar(64) NOT NULL,
-  `username` varchar(16) NOT NULL default '',
+  `id` varchar(64) collate utf8_unicode_ci NOT NULL,
+  `username` varchar(16) collate utf8_unicode_ci NOT NULL,
   `expire` int(11) unsigned NOT NULL default '0',
-  `value` longtext NOT NULL,
+  `value` longtext collate utf8_unicode_ci NOT NULL,
   `ip` int(11) unsigned default NULL,
-  `type` enum('sso','mysql','ldap','http') NOT NULL default 'mysql',
+  `type` enum('sso','mysql','ldap','http') collate utf8_unicode_ci NOT NULL default 'mysql',
   PRIMARY KEY  (`id`),
   KEY `expire` (`expire`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `session`
@@ -438,18 +453,42 @@ LOCK TABLES `session` WRITE;
 UNLOCK TABLES;
 
 --
+-- Table structure for table `session_api`
+--
+
+DROP TABLE IF EXISTS `session_api`;
+CREATE TABLE `session_api` (
+  `id` varchar(64) collate utf8_unicode_ci NOT NULL,
+  `user` int(11) unsigned NOT NULL,
+  `agent` varchar(255) collate utf8_unicode_ci default NULL,
+  `level` int(11) unsigned NOT NULL default '0',
+  `expire` int(11) unsigned NOT NULL,
+  `ip` int(11) unsigned default NULL,
+  PRIMARY KEY  (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+
+--
+-- Dumping data for table `session_api`
+--
+
+LOCK TABLES `session_api` WRITE;
+/*!40000 ALTER TABLE `session_api` DISABLE KEYS */;
+/*!40000 ALTER TABLE `session_api` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
 -- Table structure for table `session_stream`
 --
 
 DROP TABLE IF EXISTS `session_stream`;
 CREATE TABLE `session_stream` (
-  `id` varchar(64) NOT NULL,
+  `id` varchar(64) collate utf8_unicode_ci NOT NULL,
   `user` int(11) unsigned NOT NULL,
-  `agent` varchar(255) default NULL,
+  `agent` varchar(255) collate utf8_unicode_ci default NULL,
   `expire` int(11) unsigned NOT NULL,
   `ip` int(11) unsigned default NULL,
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `session_stream`
@@ -467,15 +506,15 @@ UNLOCK TABLES;
 DROP TABLE IF EXISTS `song`;
 CREATE TABLE `song` (
   `id` int(11) unsigned NOT NULL auto_increment,
-  `file` varchar(255) NOT NULL default '',
+  `file` varchar(255) collate utf8_unicode_ci NOT NULL,
   `catalog` int(11) unsigned NOT NULL default '0',
   `album` int(11) unsigned NOT NULL default '0',
   `year` mediumint(4) unsigned NOT NULL default '0',
   `artist` int(11) unsigned NOT NULL default '0',
-  `title` varchar(255) NOT NULL default '',
+  `title` varchar(255) collate utf8_unicode_ci NOT NULL,
   `bitrate` mediumint(8) unsigned NOT NULL default '0',
   `rate` mediumint(8) unsigned NOT NULL default '0',
-  `mode` enum('abr','vbr','cbr') default 'cbr',
+  `mode` enum('abr','vbr','cbr') collate utf8_unicode_ci default 'cbr',
   `size` int(11) unsigned NOT NULL default '0',
   `time` smallint(5) unsigned NOT NULL default '0',
   `track` smallint(5) unsigned default NULL,
@@ -484,7 +523,7 @@ CREATE TABLE `song` (
   `enabled` tinyint(1) unsigned NOT NULL default '1',
   `update_time` int(11) unsigned default '0',
   `addition_time` int(11) unsigned default '0',
-  `hash` varchar(64) default NULL,
+  `hash` varchar(64) collate utf8_unicode_ci default NULL,
   PRIMARY KEY  (`id`),
   KEY `genre` (`genre`),
   KEY `album` (`album`),
@@ -495,7 +534,7 @@ CREATE TABLE `song` (
   KEY `catalog` (`catalog`),
   KEY `played` (`played`),
   KEY `enabled` (`enabled`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `song`
@@ -513,13 +552,13 @@ UNLOCK TABLES;
 DROP TABLE IF EXISTS `song_data`;
 CREATE TABLE `song_data` (
   `song_id` int(11) unsigned NOT NULL,
-  `comment` text,
-  `lyrics` text,
-  `label` varchar(128) default NULL,
-  `catalog_number` varchar(128) default NULL,
-  `language` varchar(128) default NULL,
+  `comment` text collate utf8_unicode_ci,
+  `lyrics` text collate utf8_unicode_ci,
+  `label` varchar(128) collate utf8_unicode_ci default NULL,
+  `catalog_number` varchar(128) collate utf8_unicode_ci default NULL,
+  `language` varchar(128) collate utf8_unicode_ci default NULL,
   UNIQUE KEY `song_id` (`song_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `song_data`
@@ -538,13 +577,13 @@ DROP TABLE IF EXISTS `tag_map`;
 CREATE TABLE `tag_map` (
   `id` int(11) unsigned NOT NULL auto_increment,
   `object_id` int(11) unsigned NOT NULL,
-  `object_type` varchar(16) NOT NULL,
+  `object_type` varchar(16) collate utf8_unicode_ci NOT NULL,
   `user` int(11) NOT NULL,
   PRIMARY KEY  (`id`),
   KEY `object_id` (`object_id`),
   KEY `object_type` (`object_type`),
   KEY `user_id` (`user`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `tag_map`
@@ -562,11 +601,11 @@ UNLOCK TABLES;
 DROP TABLE IF EXISTS `tags`;
 CREATE TABLE `tags` (
   `map_id` int(11) unsigned NOT NULL,
-  `name` varchar(32) NOT NULL,
+  `name` varchar(32) collate utf8_unicode_ci NOT NULL,
   `order` tinyint(2) NOT NULL,
   KEY `order` (`order`),
   KEY `map_id` (`map_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `tags`
@@ -584,14 +623,14 @@ UNLOCK TABLES;
 DROP TABLE IF EXISTS `tmp_playlist`;
 CREATE TABLE `tmp_playlist` (
   `id` int(11) unsigned NOT NULL auto_increment,
-  `session` varchar(32) NOT NULL,
-  `type` varchar(32) NOT NULL,
-  `object_type` varchar(32) NOT NULL,
+  `session` varchar(32) collate utf8_unicode_ci NOT NULL,
+  `type` varchar(32) collate utf8_unicode_ci NOT NULL,
+  `object_type` varchar(32) collate utf8_unicode_ci NOT NULL,
   `base_playlist` int(11) unsigned NOT NULL,
   PRIMARY KEY  (`id`),
   KEY `session` (`session`),
   KEY `type` (`type`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `tmp_playlist`
@@ -610,11 +649,11 @@ DROP TABLE IF EXISTS `tmp_playlist_data`;
 CREATE TABLE `tmp_playlist_data` (
   `id` int(11) unsigned NOT NULL auto_increment,
   `tmp_playlist` int(11) unsigned NOT NULL,
-  `object_type` varchar(32) default NULL,
+  `object_type` varchar(32) collate utf8_unicode_ci default NULL,
   `object_id` int(11) unsigned NOT NULL,
   PRIMARY KEY  (`id`),
   KEY `tmp_playlist` (`tmp_playlist`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `tmp_playlist_data`
@@ -631,11 +670,10 @@ UNLOCK TABLES;
 
 DROP TABLE IF EXISTS `update_info`;
 CREATE TABLE `update_info` (
-  `key` varchar(128) NOT NULL default '',
-  `value` varchar(255) NOT NULL default '',
-  UNIQUE KEY `key_2` (`key`),
-  KEY `key` (`key`)
-) TYPE=MyISAM;
+  `key` varchar(128) collate utf8_unicode_ci NOT NULL,
+  `value` varchar(255) collate utf8_unicode_ci NOT NULL,
+  UNIQUE KEY `key` (`key`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `update_info`
@@ -643,7 +681,7 @@ CREATE TABLE `update_info` (
 
 LOCK TABLES `update_info` WRITE;
 /*!40000 ALTER TABLE `update_info` DISABLE KEYS */;
-INSERT INTO `update_info` VALUES ('db_version','340008');
+INSERT INTO `update_info` VALUES ('db_version','340011');
 /*!40000 ALTER TABLE `update_info` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -654,18 +692,18 @@ UNLOCK TABLES;
 DROP TABLE IF EXISTS `user`;
 CREATE TABLE `user` (
   `id` int(11) NOT NULL auto_increment,
-  `username` varchar(128) NOT NULL default '',
-  `fullname` varchar(128) NOT NULL default '',
-  `email` varchar(128) default NULL,
-  `password` varchar(64) NOT NULL default '',
+  `username` varchar(128) collate utf8_unicode_ci NOT NULL,
+  `fullname` varchar(128) collate utf8_unicode_ci NOT NULL,
+  `email` varchar(128) collate utf8_unicode_ci default NULL,
+  `password` varchar(64) collate utf8_unicode_ci NOT NULL,
   `access` tinyint(4) unsigned NOT NULL,
   `disabled` tinyint(1) unsigned NOT NULL default '0',
   `last_seen` int(11) unsigned NOT NULL default '0',
   `create_date` int(11) unsigned default NULL,
-  `validation` varchar(128) default NULL,
+  `validation` varchar(128) collate utf8_unicode_ci default NULL,
   PRIMARY KEY  (`id`),
   UNIQUE KEY `username` (`username`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `user`
@@ -684,10 +722,10 @@ DROP TABLE IF EXISTS `user_preference`;
 CREATE TABLE `user_preference` (
   `user` int(11) NOT NULL,
   `preference` int(11) unsigned NOT NULL default '0',
-  `value` varchar(255) NOT NULL default '',
+  `value` varchar(255) collate utf8_unicode_ci NOT NULL,
   KEY `user` (`user`),
   KEY `preference` (`preference`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `user_preference`
@@ -695,6 +733,7 @@ CREATE TABLE `user_preference` (
 
 LOCK TABLES `user_preference` WRITE;
 /*!40000 ALTER TABLE `user_preference` DISABLE KEYS */;
+INSERT INTO `user_preference` VALUES (-1,1,'0'),(-1,4,'10'),(-1,19,'32'),(-1,22,'Ampache :: Pour l\'Amour de la Musique'),(-1,23,'0'),(-1,24,'1'),(-1,25,'80'),(-1,26,'100'),(-1,41,'0'),(-1,29,'stream'),(-1,30,'1'),(-1,31,'en_US'),(-1,32,'m3u'),(-1,33,'classic'),(-1,34,'27'),(-1,35,'27'),(-1,36,'27'),(-1,51,'50'),(-1,40,'0'),(-1,44,'1'),(-1,45,'0'),(-1,46,'0'),(-1,47,'7'),(-1,49,'1'),(-1,52,'8192'),(-1,53,'normal'),(-1,54,'append'),(-1,55,'default');
 /*!40000 ALTER TABLE `user_preference` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -706,16 +745,16 @@ DROP TABLE IF EXISTS `user_shout`;
 CREATE TABLE `user_shout` (
   `id` int(11) unsigned NOT NULL auto_increment,
   `user` int(11) NOT NULL,
-  `text` text NOT NULL,
+  `text` text collate utf8_unicode_ci NOT NULL,
   `date` int(11) unsigned NOT NULL,
   `sticky` tinyint(1) unsigned NOT NULL default '0',
   `object_id` int(11) unsigned NOT NULL,
-  `object_type` varchar(32) NOT NULL,
+  `object_type` varchar(32) collate utf8_unicode_ci NOT NULL,
   PRIMARY KEY  (`id`),
   KEY `sticky` (`sticky`),
   KEY `date` (`date`),
   KEY `user` (`user`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `user_shout`
@@ -738,7 +777,7 @@ CREATE TABLE `user_vote` (
   KEY `user` (`user`),
   KEY `object_id` (`object_id`),
   KEY `date` (`date`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Dumping data for table `user_vote`
@@ -753,6 +792,9 @@ UNLOCK TABLES;
 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
+/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
+/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2007-08-05 22:13:37
+-- Dump completed on 2007-11-25 22:48:18