# MySQL-Front Dump 2.1
#
# Host: 192.168.0.45   Database: wmj
#--------------------------------------------------------
# Server version 3.23.41
USE mysql;

# The value 'wmj' is the username
# The value 'wmjdb' the databasename
# And 'wmjpass' the password.
# be sure to alter all the values!

INSERT INTO user VALUES('localhost', 'wmjuser', password('wmjpass'), 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n');
INSERT INTO db VALUES('localhost', 'wmjdb', 'wmjuser', 'y', 'y', 'y', 'y', 'y', 'y', 'n', 'y', 'y', 'y');

CREATE DATABASE wmjdb;
USE wmjdb;

# ------------------- DON'T ALTER ANY THING BELOW! ------------------------
#
# Table structure for table 'files'
#

CREATE TABLE `files` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `filename` varchar(255) NOT NULL default '',
  `artist` varchar(255) default '0',
  `album` text,
  `year` smallint(4) unsigned default '0',
  `genreid` tinyint(3) unsigned default '0',
  `bitrate` decimal(3,0) default '0',
  `frequency` decimal(6,1) default '0.0',
  `chanelmode` varchar(50) default '0',
  `playtime` decimal(8,6) default '0.000000',
  `title` varchar(255) default '0',
  `counter` int(10) unsigned default '0',
  PRIMARY KEY  (`filename`),
  KEY `id` (`id`)
) TYPE=MyISAM;



#
# Table structure for table 'genres'
#

CREATE TABLE `genres` (
  `id` tinyint(3) unsigned NOT NULL auto_increment,
  `description` varchar(255) default '0',
  PRIMARY KEY  (`id`),
  KEY `id` (`id`)
) TYPE=MyISAM;

INSERT INTO genres VALUES (1,'Blues');
INSERT INTO genres VALUES (2,'Classic Rock');
INSERT INTO genres VALUES (3,'Country');
INSERT INTO genres VALUES (4,'Dance');
INSERT INTO genres VALUES (5,'Disco');
INSERT INTO genres VALUES (6,'Funk');
INSERT INTO genres VALUES (7,'Grunge');
INSERT INTO genres VALUES (8,'Hip-Hop');
INSERT INTO genres VALUES (9,'Jazz');
INSERT INTO genres VALUES (10,'Metal');
INSERT INTO genres VALUES (11,'New Age');
INSERT INTO genres VALUES (12,'Oldies');
INSERT INTO genres VALUES (13,'Other');
INSERT INTO genres VALUES (14,'Pop');
INSERT INTO genres VALUES (15,'R&B');
INSERT INTO genres VALUES (16,'Rap');
INSERT INTO genres VALUES (17,'Reggae');
INSERT INTO genres VALUES (18,'Rock');
INSERT INTO genres VALUES (19,'Techno');
INSERT INTO genres VALUES (20,'Industrial');
INSERT INTO genres VALUES (21,'Alternative');
INSERT INTO genres VALUES (22,'Ska');
INSERT INTO genres VALUES (23,'Death Metal');
INSERT INTO genres VALUES (24,'Pranks');
INSERT INTO genres VALUES (25,'Soundtrack');
INSERT INTO genres VALUES (26,'Euro-Techno');
INSERT INTO genres VALUES (27,'Ambient');
INSERT INTO genres VALUES (28,'Trip-Hop');
INSERT INTO genres VALUES (29,'Vocal');
INSERT INTO genres VALUES (30,'Jazz+Funk');
INSERT INTO genres VALUES (31,'Fusion');
INSERT INTO genres VALUES (32,'Trance');
INSERT INTO genres VALUES (33,'Classical');
INSERT INTO genres VALUES (34,'Instrumental');
INSERT INTO genres VALUES (35,'Acid');
INSERT INTO genres VALUES (36,'House');
INSERT INTO genres VALUES (37,'Game');
INSERT INTO genres VALUES (38,'Sound Clip');
INSERT INTO genres VALUES (39,'Gospel');
INSERT INTO genres VALUES (40,'Noise');
INSERT INTO genres VALUES (41,'Alt. Rock');
INSERT INTO genres VALUES (42,'Bass');
INSERT INTO genres VALUES (43,'Soul');
INSERT INTO genres VALUES (44,'Punk');
INSERT INTO genres VALUES (45,'Space');
INSERT INTO genres VALUES (46,'Meditative');
INSERT INTO genres VALUES (47,'Instrumental Pop');
INSERT INTO genres VALUES (48,'Instrumental Rock');
INSERT INTO genres VALUES (49,'Ethnic');
INSERT INTO genres VALUES (50,'Gothic');
INSERT INTO genres VALUES (51,'Darkwave');
INSERT INTO genres VALUES (52,'Techno-Industrial');
INSERT INTO genres VALUES (53,'Electronic');
INSERT INTO genres VALUES (54,'Folk/Pop');
INSERT INTO genres VALUES (55,'Eurodance');
INSERT INTO genres VALUES (56,'Dream');
INSERT INTO genres VALUES (57,'Southern Rock');
INSERT INTO genres VALUES (58,'Comedy');
INSERT INTO genres VALUES (59,'Cult');
INSERT INTO genres VALUES (60,'Gangsta');
INSERT INTO genres VALUES (61,'Top 40');
INSERT INTO genres VALUES (62,'Christian Rap');
INSERT INTO genres VALUES (63,'Pop/Funk');
INSERT INTO genres VALUES (64,'Jungle');
INSERT INTO genres VALUES (65,'Native American');
INSERT INTO genres VALUES (66,'Cabaret');
INSERT INTO genres VALUES (67,'New Wave');
INSERT INTO genres VALUES (68,'Psychadelic');
INSERT INTO genres VALUES (69,'Rave');
INSERT INTO genres VALUES (70,'Showtunes');
INSERT INTO genres VALUES (71,'Trailer');
INSERT INTO genres VALUES (72,'Lo-Fi');
INSERT INTO genres VALUES (73,'Tribal');
INSERT INTO genres VALUES (74,'Acid Punk');
INSERT INTO genres VALUES (75,'Acid Jazz');
INSERT INTO genres VALUES (76,'Polka');
INSERT INTO genres VALUES (77,'Retro');
INSERT INTO genres VALUES (78,'Musical');
INSERT INTO genres VALUES (79,'Rock & Roll');
INSERT INTO genres VALUES (80,'Hard Rock');
INSERT INTO genres VALUES (81,'Folk');
INSERT INTO genres VALUES (82,'Folk/Rock');
INSERT INTO genres VALUES (83,'National Folk');
INSERT INTO genres VALUES (84,'Swing');
INSERT INTO genres VALUES (85,'Fast-Fusion');
INSERT INTO genres VALUES (86,'Bebob');
INSERT INTO genres VALUES (87,'Latin');
INSERT INTO genres VALUES (88,'Revival');
INSERT INTO genres VALUES (89,'Celtic');
INSERT INTO genres VALUES (90,'Bluegrass');
INSERT INTO genres VALUES (91,'Avantgarde');
INSERT INTO genres VALUES (92,'Gothic Rock');
INSERT INTO genres VALUES (93,'Progressive Rock');
INSERT INTO genres VALUES (94,'Psychedelic Rock');
INSERT INTO genres VALUES (95,'Symphonic Rock');
INSERT INTO genres VALUES (96,'Slow Rock');
INSERT INTO genres VALUES (97,'Big Band');
INSERT INTO genres VALUES (98,'Chorus');
INSERT INTO genres VALUES (99,'Easy Listening');
INSERT INTO genres VALUES (100,'Acoustic');
INSERT INTO genres VALUES (101,'Humour');
INSERT INTO genres VALUES (102,'Speech');
INSERT INTO genres VALUES (103,'Chanson');
INSERT INTO genres VALUES (104,'Opera');
INSERT INTO genres VALUES (105,'Chamber Music');
INSERT INTO genres VALUES (106,'Sonata');
INSERT INTO genres VALUES (107,'Symphony');
INSERT INTO genres VALUES (108,'Booty Bass');
INSERT INTO genres VALUES (109,'Primus');
INSERT INTO genres VALUES (110,'Porn Groove');
INSERT INTO genres VALUES (111,'Satire');
INSERT INTO genres VALUES (112,'Slow Jam');
INSERT INTO genres VALUES (113,'Club');
INSERT INTO genres VALUES (114,'Tango');
INSERT INTO genres VALUES (115,'Samba');
INSERT INTO genres VALUES (116,'Folklore');
INSERT INTO genres VALUES (117,'Ballad');
INSERT INTO genres VALUES (118,'Power Ballad');
INSERT INTO genres VALUES (119,'Rhythmic Soul');
INSERT INTO genres VALUES (120,'Freestyle');
INSERT INTO genres VALUES (121,'Duet');
INSERT INTO genres VALUES (122,'Punk Rock');
INSERT INTO genres VALUES (123,'Drum Solo');
INSERT INTO genres VALUES (124,'A Cappella');
INSERT INTO genres VALUES (125,'Euro-House');
INSERT INTO genres VALUES (126,'Dance Hall');
INSERT INTO genres VALUES (127,'Goa');
INSERT INTO genres VALUES (128,'Drum & Bass');
INSERT INTO genres VALUES (129,'Club-House');
INSERT INTO genres VALUES (130,'Hardcore');
INSERT INTO genres VALUES (131,'Terror');
INSERT INTO genres VALUES (132,'Indie');
INSERT INTO genres VALUES (133,'BritPop');
INSERT INTO genres VALUES (134,'Negerpunk');
INSERT INTO genres VALUES (135,'Polsk Punk');
INSERT INTO genres VALUES (136,'Beat');
INSERT INTO genres VALUES (137,'Christian Gangsta Rap');
INSERT INTO genres VALUES (138,'Heavy Metal');
INSERT INTO genres VALUES (139,'Black Metal');
INSERT INTO genres VALUES (140,'Crossover');
INSERT INTO genres VALUES (141,'Contemporary Christian');
INSERT INTO genres VALUES (142,'Christian Rock');
INSERT INTO genres VALUES (143,'Merengue');
INSERT INTO genres VALUES (144,'Salsa');
INSERT INTO genres VALUES (145,'Trash Metal');
INSERT INTO genres VALUES (146,'Anime');
INSERT INTO genres VALUES (147,'Jpop');
INSERT INTO genres VALUES (148,'Synthpop');

#
# Table structure for table 'playlist'
#

CREATE TABLE `playlist` (
  `filename` varchar(255) NOT NULL default '',
  `id` int(11) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;



#
# Table structure for table 'prefs'
#

CREATE TABLE `prefs` (
  `randomplay` enum('y','n') default NULL,
  `genre` text,
  `maxtime` decimal(5,2) default '0.00',
  `artist` varchar(255) default NULL,
  `play` enum('y','n') default 'y',
  `currentplay` varchar(255) default NULL
) TYPE=MyISAM;
INSERT INTO prefs VALUES ('y', '', '' , '', 'y', '');


FLUSH PRIVILEGES;