diff options
| -rwxr-xr-x | docs/CHANGELOG | 3 | ||||
| -rwxr-xr-x | docs/README | 1 | ||||
| -rw-r--r-- | lib/init.php | 4 | ||||
| -rw-r--r-- | sql/ampache40.sql | 1024 |
4 files changed, 6 insertions, 1026 deletions
diff --git a/docs/CHANGELOG b/docs/CHANGELOG index ce39e99b..d632c31e 100755 --- a/docs/CHANGELOG +++ b/docs/CHANGELOG @@ -3,6 +3,9 @@ -------------------------------------------------------------------------- -------------------------------------------------------------------------- + v.3.6-Alpha1 + +-------------------------------------------------------------------------- v.3.5 05/05/2009 - Added complete Czech translation (Thx martin hason) - Add the AlmightyOatmeal-Sanity check to prevent a clean from diff --git a/docs/README b/docs/README index a2cc4a75..d686d04f 100755 --- a/docs/README +++ b/docs/README @@ -99,6 +99,7 @@ Contents: - Japanese (ja_JP) - Catalan (ca_ES) - Russian (ru_RU) + - Czech (cs_CZ) D) A Special Thanks: Thanks to those who've helped us make Ampache so useable: diff --git a/lib/init.php b/lib/init.php index af14fea3..e64a6e14 100644 --- a/lib/init.php +++ b/lib/init.php @@ -20,7 +20,7 @@ */ // SVN Fluf -//$svn_version = 'Subversion ' . trim('$Rev$','$ '); +$svn_version = 'Subversion ' . trim('$Rev$','$ '); // Use output buffering, this gains us a few things and // fixes some CSS issues @@ -90,7 +90,7 @@ if (!function_exists('hash') OR !function_exists('inet_pton') OR (strtoupper(sub } /** This is the version.... fluf nothing more... **/ -$results['version'] = '3.5 '. $svn_version; +$results['version'] = '3.6-Alpha1 '. $svn_version; $results['int_config_version'] = '10'; $results['raw_web_path'] = $results['web_path']; diff --git a/sql/ampache40.sql b/sql/ampache40.sql deleted file mode 100644 index 3c782809..00000000 --- a/sql/ampache40.sql +++ /dev/null @@ -1,1024 +0,0 @@ --- Copyright (c) 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.77-1-log -/*!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' */; -/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; - --- --- Table structure for table `access_list` --- - -DROP TABLE IF EXISTS `access_list`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `access_list` ( - `id` int(11) unsigned NOT NULL auto_increment, - `name` varchar(255) default NULL, - `start` varbinary(255) NOT NULL, - `end` varbinary(255) NOT NULL, - `level` smallint(3) unsigned NOT NULL default '5', - `type` varchar(64) default NULL, - `user` int(11) NOT NULL, - `key` varchar(255) default NULL, - `enabled` tinyint(1) unsigned NOT NULL default '1', - PRIMARY KEY (`id`), - KEY `start` (`start`), - KEY `end` (`end`), - KEY `level` (`level`), - KEY `enabled` (`enabled`) -) TYPE=MyISAM AUTO_INCREMENT=5; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `access_list` --- - -LOCK TABLES `access_list` WRITE; -/*!40000 ALTER TABLE `access_list` DISABLE KEYS */; -INSERT INTO `access_list` VALUES (1,'DEFAULTv4','\0\0\0\0','ÿÿÿÿ',75,'interface',-1,NULL,1),(2,'DEFAULTv4','\0\0\0\0','ÿÿÿÿ',75,'stream',-1,NULL,1),(3,'DEFAULTv6','\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0','ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ',75,'interface',-1,NULL,1),(4,'DEFAULTv6','\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0','ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ',75,'stream',-1,NULL,1); -/*!40000 ALTER TABLE `access_list` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `album` --- - -DROP TABLE IF EXISTS `album`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `album` ( - `id` int(11) unsigned NOT NULL auto_increment, - `name` varchar(255) default NULL, - `prefix` varchar(32) 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`), - KEY `disk` (`disk`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `album` --- - -LOCK TABLES `album` WRITE; -/*!40000 ALTER TABLE `album` DISABLE KEYS */; -/*!40000 ALTER TABLE `album` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `album_data` --- - -DROP TABLE IF EXISTS `album_data`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `album_data` ( - `album_id` int(11) unsigned NOT NULL, - `art` mediumblob, - `art_mime` varchar(64) default NULL, - `thumb` mediumblob, - `thumb_mime` varchar(64) default NULL, - UNIQUE KEY `album_id` (`album_id`), - KEY `art_mime` (`art_mime`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `album_data` --- - -LOCK TABLES `album_data` WRITE; -/*!40000 ALTER TABLE `album_data` DISABLE KEYS */; -/*!40000 ALTER TABLE `album_data` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `artist` --- - -DROP TABLE IF EXISTS `artist`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `artist` ( - `id` int(11) unsigned NOT NULL auto_increment, - `name` varchar(255) default NULL, - `prefix` varchar(32) default NULL, - PRIMARY KEY (`id`), - KEY `name` (`name`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `artist` --- - -LOCK TABLES `artist` WRITE; -/*!40000 ALTER TABLE `artist` DISABLE KEYS */; -/*!40000 ALTER TABLE `artist` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `artist_data` --- - -DROP TABLE IF EXISTS `artist_data`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `artist_data` ( - `artist_id` int(11) unsigned NOT NULL, - `art` mediumblob NOT NULL, - `art_mime` varchar(32) default NULL, - `thumb` mediumblob, - `thumb_mime` varchar(32) default NULL, - `bio` text NOT NULL, - UNIQUE KEY `artist_id` (`artist_id`), - KEY `art_mime` (`art_mime`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- 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`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `catalog` ( - `id` int(11) unsigned NOT NULL auto_increment, - `name` varchar(128) default NULL, - `path` varchar(255) default NULL, - `catalog_type` enum('local','remote') default NULL, - `last_update` int(11) unsigned NOT NULL default '0', - `last_clean` int(11) unsigned default NULL, - `last_add` int(11) unsigned NOT NULL default '0', - `enabled` tinyint(1) unsigned NOT NULL default '1', - `rename_pattern` varchar(255) default NULL, - `sort_pattern` varchar(255) default NULL, - `gather_types` varchar(255) default NULL, - `key` varchar(255) default NULL, - PRIMARY KEY (`id`), - KEY `enabled` (`enabled`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `catalog` --- - -LOCK TABLES `catalog` WRITE; -/*!40000 ALTER TABLE `catalog` DISABLE KEYS */; -/*!40000 ALTER TABLE `catalog` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `democratic` --- - -DROP TABLE IF EXISTS `democratic`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `democratic` ( - `id` int(11) unsigned NOT NULL auto_increment, - `name` varchar(64) default NULL, - `cooldown` tinyint(4) unsigned default NULL, - `level` tinyint(4) unsigned NOT NULL default '25', - `user` int(11) NOT NULL, - `primary` tinyint(1) unsigned NOT NULL default '0', - `base_playlist` int(11) unsigned NOT NULL, - PRIMARY KEY (`id`), - KEY `level` (`level`), - KEY `primary_2` (`primary`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `democratic` --- - -LOCK TABLES `democratic` WRITE; -/*!40000 ALTER TABLE `democratic` DISABLE KEYS */; -/*!40000 ALTER TABLE `democratic` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `dynamic_playlist` --- - -DROP TABLE IF EXISTS `dynamic_playlist`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `dynamic_playlist` ( - `id` int(11) unsigned NOT NULL auto_increment, - `name` varchar(255) NOT NULL, - `user` int(11) NOT NULL, - `date` int(11) unsigned NOT NULL, - `type` varchar(128) NOT NULL, - PRIMARY KEY (`id`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `dynamic_playlist` --- - -LOCK TABLES `dynamic_playlist` WRITE; -/*!40000 ALTER TABLE `dynamic_playlist` DISABLE KEYS */; -/*!40000 ALTER TABLE `dynamic_playlist` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `dynamic_playlist_data` --- - -DROP TABLE IF EXISTS `dynamic_playlist_data`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `dynamic_playlist_data` ( - `id` int(11) unsigned NOT NULL auto_increment, - `dynamic_id` int(11) unsigned NOT NULL, - `field` varchar(255) NOT NULL, - `internal_operator` varchar(64) NOT NULL, - `external_operator` varchar(64) NOT NULL, - `value` varchar(255) NOT NULL, - PRIMARY KEY (`id`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `dynamic_playlist_data` --- - -LOCK TABLES `dynamic_playlist_data` WRITE; -/*!40000 ALTER TABLE `dynamic_playlist_data` DISABLE KEYS */; -/*!40000 ALTER TABLE `dynamic_playlist_data` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `flagged` --- - -DROP TABLE IF EXISTS `flagged`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -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') default NULL, - `user` int(11) NOT NULL, - `flag` enum('delete','retag','reencode','other') default NULL, - `date` int(11) unsigned NOT NULL default '0', - `approved` tinyint(1) unsigned NOT NULL default '0', - `comment` varchar(255) default NULL, - PRIMARY KEY (`id`), - KEY `date` (`date`,`approved`), - KEY `object_id` (`object_id`), - KEY `object_type` (`object_type`), - KEY `user` (`user`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `flagged` --- - -LOCK TABLES `flagged` WRITE; -/*!40000 ALTER TABLE `flagged` DISABLE KEYS */; -/*!40000 ALTER TABLE `flagged` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `ip_history` --- - -DROP TABLE IF EXISTS `ip_history`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `ip_history` ( - `id` int(11) unsigned NOT NULL auto_increment, - `user` int(11) NOT NULL, - `ip` varbinary(255) default NULL, - `date` int(11) unsigned NOT NULL default '0', - `agent` varchar(255) default NULL, - PRIMARY KEY (`id`), - KEY `username` (`user`), - KEY `date` (`date`), - KEY `ip` (`ip`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `ip_history` --- - -LOCK TABLES `ip_history` WRITE; -/*!40000 ALTER TABLE `ip_history` DISABLE KEYS */; -/*!40000 ALTER TABLE `ip_history` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `live_stream` --- - -DROP TABLE IF EXISTS `live_stream`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `live_stream` ( - `id` int(11) unsigned NOT NULL auto_increment, - `name` varchar(128) default NULL, - `site_url` varchar(255) default NULL, - `url` varchar(255) default NULL, - `genre` int(11) unsigned NOT NULL default '0', - `catalog` int(11) unsigned NOT NULL default '0', - `frequency` varchar(32) default NULL, - `call_sign` varchar(32) default NULL, - PRIMARY KEY (`id`), - KEY `catalog` (`catalog`), - KEY `genre` (`genre`), - KEY `name` (`name`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `live_stream` --- - -LOCK TABLES `live_stream` WRITE; -/*!40000 ALTER TABLE `live_stream` DISABLE KEYS */; -/*!40000 ALTER TABLE `live_stream` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `now_playing` --- - -DROP TABLE IF EXISTS `now_playing`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `now_playing` ( - `id` varchar(64) NOT NULL default '', - `object_id` int(11) unsigned NOT NULL, - `object_type` varchar(255) NOT NULL, - `user` int(11) NOT NULL, - `expire` int(11) unsigned NOT NULL default '0', - PRIMARY KEY (`id`), - KEY `expire` (`expire`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `now_playing` --- - -LOCK TABLES `now_playing` WRITE; -/*!40000 ALTER TABLE `now_playing` DISABLE KEYS */; -/*!40000 ALTER TABLE `now_playing` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `object_count` --- - -DROP TABLE IF EXISTS `object_count`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `object_count` ( - `id` int(11) unsigned NOT NULL auto_increment, - `object_type` enum('album','artist','song','playlist','genre','catalog','live_stream','video') default NULL, - `object_id` int(11) unsigned NOT NULL default '0', - `date` int(11) unsigned NOT NULL default '0', - `user` int(11) unsigned NOT NULL, - PRIMARY KEY (`id`), - KEY `object_type` (`object_type`), - KEY `object_id` (`object_id`), - KEY `userid` (`user`), - KEY `date` (`date`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `object_count` --- - -LOCK TABLES `object_count` WRITE; -/*!40000 ALTER TABLE `object_count` DISABLE KEYS */; -/*!40000 ALTER TABLE `object_count` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `playlist` --- - -DROP TABLE IF EXISTS `playlist`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `playlist` ( - `id` int(11) unsigned NOT NULL auto_increment, - `name` varchar(128) default NULL, - `user` int(11) NOT NULL, - `type` enum('private','public') default NULL, - `date` int(11) unsigned NOT NULL, - PRIMARY KEY (`id`), - KEY `name` (`name`), - KEY `type` (`type`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `playlist` --- - -LOCK TABLES `playlist` WRITE; -/*!40000 ALTER TABLE `playlist` DISABLE KEYS */; -/*!40000 ALTER TABLE `playlist` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `playlist_data` --- - -DROP TABLE IF EXISTS `playlist_data`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -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) default NULL, - `track` int(11) unsigned NOT NULL default '0', - PRIMARY KEY (`id`), - KEY `playlist` (`playlist`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `playlist_data` --- - -LOCK TABLES `playlist_data` WRITE; -/*!40000 ALTER TABLE `playlist_data` DISABLE KEYS */; -/*!40000 ALTER TABLE `playlist_data` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `preference` --- - -DROP TABLE IF EXISTS `preference`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `preference` ( - `id` int(11) unsigned NOT NULL auto_increment, - `name` varchar(128) default NULL, - `value` varchar(255) default NULL, - `description` varchar(255) default NULL, - `level` int(11) unsigned NOT NULL default '100', - `type` varchar(128) default NULL, - `catagory` varchar(128) default NULL, - PRIMARY KEY (`id`), - KEY `catagory` (`catagory`), - KEY `name` (`name`) -) TYPE=MyISAM AUTO_INCREMENT=70; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for 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'),(41,'localplay_controller','0','Localplay Type',100,'special','options'),(29,'play_type','stream','Type of Playback',25,'special','streaming'),(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',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'),(57,'tags_userlist','','User to track',0,'string','tags'),(69,'show_lyrics','0','Show Lyrics',0,'boolean','interface'); -/*!40000 ALTER TABLE `preference` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `rating` --- - -DROP TABLE IF EXISTS `rating`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `rating` ( - `id` int(11) unsigned NOT NULL auto_increment, - `user` int(11) NOT NULL, - `object_type` enum('artist','album','song','steam','video') default NULL, - `object_id` int(11) unsigned NOT NULL default '0', - `rating` tinyint(4) NOT NULL, - PRIMARY KEY (`id`), - KEY `object_id` (`object_id`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `rating` --- - -LOCK TABLES `rating` WRITE; -/*!40000 ALTER TABLE `rating` DISABLE KEYS */; -/*!40000 ALTER TABLE `rating` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `session` --- - -DROP TABLE IF EXISTS `session`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `session` ( - `id` varchar(64) NOT NULL default '', - `username` varchar(16) default NULL, - `expire` int(11) unsigned NOT NULL default '0', - `value` longtext NOT NULL, - `ip` varbinary(255) default NULL, - `type` enum('mysql','ldap','http','api','xml-rpc') default NULL, - `agent` varchar(255) default NULL, - PRIMARY KEY (`id`), - KEY `expire` (`expire`), - KEY `type` (`type`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `session` --- - -LOCK TABLES `session` WRITE; -/*!40000 ALTER TABLE `session` DISABLE KEYS */; -/*!40000 ALTER TABLE `session` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `session_stream` --- - -DROP TABLE IF EXISTS `session_stream`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `session_stream` ( - `id` varchar(64) NOT NULL default '', - `user` int(11) unsigned NOT NULL, - `agent` varchar(255) default NULL, - `expire` int(11) unsigned NOT NULL, - `ip` varbinary(255) default NULL, - PRIMARY KEY (`id`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `session_stream` --- - -LOCK TABLES `session_stream` WRITE; -/*!40000 ALTER TABLE `session_stream` DISABLE KEYS */; -/*!40000 ALTER TABLE `session_stream` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `song` --- - -DROP TABLE IF EXISTS `song`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `song` ( - `id` int(11) unsigned NOT NULL auto_increment, - `file` varchar(255) default 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) default NULL, - `bitrate` mediumint(8) unsigned NOT NULL default '0', - `rate` mediumint(8) unsigned NOT NULL default '0', - `mode` enum('abr','vbr','cbr') default NULL, - `size` int(11) unsigned NOT NULL default '0', - `time` smallint(5) unsigned NOT NULL default '0', - `track` smallint(5) unsigned 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', - `addition_time` int(11) unsigned default '0', - PRIMARY KEY (`id`), - KEY `album` (`album`), - KEY `artist` (`artist`), - KEY `file` (`file`), - KEY `update_time` (`update_time`), - KEY `addition_time` (`addition_time`), - KEY `catalog` (`catalog`), - KEY `played` (`played`), - KEY `enabled` (`enabled`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `song` --- - -LOCK TABLES `song` WRITE; -/*!40000 ALTER TABLE `song` DISABLE KEYS */; -/*!40000 ALTER TABLE `song` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `song_data` --- - -DROP TABLE IF EXISTS `song_data`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -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, - UNIQUE KEY `song_id` (`song_id`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `song_data` --- - -LOCK TABLES `song_data` WRITE; -/*!40000 ALTER TABLE `song_data` DISABLE KEYS */; -/*!40000 ALTER TABLE `song_data` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `tag` --- - -DROP TABLE IF EXISTS `tag`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `tag` ( - `id` int(11) unsigned NOT NULL auto_increment, - `name` varchar(255) default NULL, - UNIQUE KEY `name` (`name`), - KEY `map_id` (`id`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `tag` --- - -LOCK TABLES `tag` WRITE; -/*!40000 ALTER TABLE `tag` DISABLE KEYS */; -/*!40000 ALTER TABLE `tag` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `tag_map` --- - -DROP TABLE IF EXISTS `tag_map`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `tag_map` ( - `id` int(11) unsigned NOT NULL auto_increment, - `tag_id` int(11) unsigned NOT NULL, - `object_id` int(11) unsigned NOT NULL, - `object_type` varchar(16) default NULL, - `user` int(11) NOT NULL, - PRIMARY KEY (`id`), - KEY `object_id` (`object_id`), - KEY `object_type` (`object_type`), - KEY `user_id` (`user`), - KEY `tag_id` (`tag_id`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `tag_map` --- - -LOCK TABLES `tag_map` WRITE; -/*!40000 ALTER TABLE `tag_map` DISABLE KEYS */; -/*!40000 ALTER TABLE `tag_map` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `tmp_browse` --- - -DROP TABLE IF EXISTS `tmp_browse`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `tmp_browse` ( - `sid` varchar(128) NOT NULL, - `type` varchar(255) NOT NULL, - `data` longtext NOT NULL, - UNIQUE KEY `sid` (`sid`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `tmp_browse` --- - -LOCK TABLES `tmp_browse` WRITE; -/*!40000 ALTER TABLE `tmp_browse` DISABLE KEYS */; -/*!40000 ALTER TABLE `tmp_browse` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `tmp_playlist` --- - -DROP TABLE IF EXISTS `tmp_playlist`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `tmp_playlist` ( - `id` int(11) unsigned NOT NULL auto_increment, - `session` varchar(32) default NULL, - `type` varchar(32) default NULL, - `object_type` varchar(32) default NULL, - PRIMARY KEY (`id`), - KEY `session` (`session`), - KEY `type` (`type`) -) TYPE=MyISAM AUTO_INCREMENT=8; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `tmp_playlist` --- - -LOCK TABLES `tmp_playlist` WRITE; -/*!40000 ALTER TABLE `tmp_playlist` DISABLE KEYS */; -/*!40000 ALTER TABLE `tmp_playlist` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `tmp_playlist_data` --- - -DROP TABLE IF EXISTS `tmp_playlist_data`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -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_id` int(11) unsigned NOT NULL, - `track` int(11) unsigned default NULL, - PRIMARY KEY (`id`), - KEY `tmp_playlist` (`tmp_playlist`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `tmp_playlist_data` --- - -LOCK TABLES `tmp_playlist_data` WRITE; -/*!40000 ALTER TABLE `tmp_playlist_data` DISABLE KEYS */; -/*!40000 ALTER TABLE `tmp_playlist_data` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `update_info` --- - -DROP TABLE IF EXISTS `update_info`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `update_info` ( - `key` varchar(128) default NULL, - `value` varchar(255) default NULL, - UNIQUE KEY `key` (`key`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `update_info` --- - -LOCK TABLES `update_info` WRITE; -/*!40000 ALTER TABLE `update_info` DISABLE KEYS */; -INSERT INTO `update_info` VALUES ('db_version','350008'); -/*!40000 ALTER TABLE `update_info` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `user` --- - -DROP TABLE IF EXISTS `user`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `user` ( - `id` int(11) NOT NULL auto_increment, - `username` varchar(128) default NULL, - `fullname` varchar(128) default NULL, - `email` varchar(128) default NULL, - `password` varchar(64) default 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, - PRIMARY KEY (`id`), - UNIQUE KEY `username` (`username`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `user` --- - -LOCK TABLES `user` WRITE; -/*!40000 ALTER TABLE `user` DISABLE KEYS */; -/*!40000 ALTER TABLE `user` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `user_catalog` --- - -DROP TABLE IF EXISTS `user_catalog`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `user_catalog` ( - `user` int(11) unsigned NOT NULL, - `catalog` int(11) unsigned NOT NULL, - `level` smallint(4) unsigned NOT NULL default '5', - KEY `user` (`user`), - KEY `catalog` (`catalog`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `user_catalog` --- - -LOCK TABLES `user_catalog` WRITE; -/*!40000 ALTER TABLE `user_catalog` DISABLE KEYS */; -/*!40000 ALTER TABLE `user_catalog` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `user_preference` --- - -DROP TABLE IF EXISTS `user_preference`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `user_preference` ( - `user` int(11) NOT NULL, - `preference` int(11) unsigned NOT NULL default '0', - `value` varchar(255) default NULL, - KEY `user` (`user`), - KEY `preference` (`preference`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for 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,41,'0'),(-1,29,'stream'),(-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,'default'),(-1,55,'default'),(-1,57,''),(-1,69,'0'); -/*!40000 ALTER TABLE `user_preference` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `user_shout` --- - -DROP TABLE IF EXISTS `user_shout`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `user_shout` ( - `id` int(11) unsigned NOT NULL auto_increment, - `user` int(11) NOT NULL, - `text` text 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) default NULL, - PRIMARY KEY (`id`), - KEY `sticky` (`sticky`), - KEY `date` (`date`), - KEY `user` (`user`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `user_shout` --- - -LOCK TABLES `user_shout` WRITE; -/*!40000 ALTER TABLE `user_shout` DISABLE KEYS */; -/*!40000 ALTER TABLE `user_shout` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `user_vote` --- - -DROP TABLE IF EXISTS `user_vote`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `user_vote` ( - `user` int(11) unsigned NOT NULL, - `object_id` int(11) unsigned NOT NULL, - `date` int(11) unsigned NOT NULL, - KEY `user` (`user`), - KEY `object_id` (`object_id`), - KEY `date` (`date`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `user_vote` --- - -LOCK TABLES `user_vote` WRITE; -/*!40000 ALTER TABLE `user_vote` DISABLE KEYS */; -/*!40000 ALTER TABLE `user_vote` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `video` --- - -DROP TABLE IF EXISTS `video`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `video` ( - `id` int(11) unsigned NOT NULL auto_increment, - `file` varchar(255) NOT NULL, - `catalog` int(11) unsigned NOT NULL, - `title` varchar(255) NOT NULL, - `video_codec` varchar(255) NOT NULL, - `audio_codec` varchar(255) NOT NULL, - `resolution_x` mediumint(8) unsigned NOT NULL, - `resolution_y` mediumint(8) unsigned NOT NULL, - `time` int(11) unsigned NOT NULL, - `size` bigint(20) unsigned NOT NULL, - `mime` varchar(255) NOT NULL, - `addition_time` int(11) unsigned NOT NULL, - `update_time` int(11) unsigned default NULL, - `enabled` tinyint(1) NOT NULL default '1', - PRIMARY KEY (`id`), - KEY `file` (`file`), - KEY `enabled` (`enabled`), - KEY `title` (`title`), - KEY `addition_time` (`addition_time`), - KEY `update_time` (`update_time`) -) TYPE=MyISAM; -SET character_set_client = @saved_cs_client; - --- --- Dumping data for table `video` --- - -LOCK TABLES `video` WRITE; -/*!40000 ALTER TABLE `video` DISABLE KEYS */; -/*!40000 ALTER TABLE `video` ENABLE KEYS */; -UNLOCK TABLES; -/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; - -/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; -/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; -/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; -/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; - --- Dump completed on 2009-03-15 23:54:50 |