DROP DATABASE IF EXISTS mp3;
CREATE DATABASE mp3;
USE mp3;

CREATE TABLE directories
(
	id int(11) NOT NULL auto_increment,
	name VARCHAR(128),                   # Directory name
	parent int(11),                      # Parent directory
	PRIMARY KEY( id ),
	KEY( parent )
);


CREATE TABLE files
(
	id int(11) NOT NULL auto_increment,
	name VARCHAR(128),                    # Filename
	parent int(11),                       # Parent directory
	count int(11),                        # Playcount
	mtime DATETIME,                       # modification time
	size int(11),                         # File size
	PRIMARY KEY( id ),
	KEY( parent )
);