CREATE TABLE tbl_playlist (
u_id int(4) NOT NULL default ``0``,
name varchar(32) NOT NULL default ````,
public char(1) NOT NULL default ``0``,
status tinyint(1) NOT NULL default ``0``,
list longtext NOT NULL,
listid int(11) NOT NULL auto_increment,
PRIMARY KEY (listid)
) TYPE=MyISAM;
CREATE TABLE tbl_playlist_list (
listid int(11) NOT NULL default ``0``,
id int(11) NOT NULL auto_increment,
title varchar(255) NOT NULL default ````,
pdir varchar(255) NOT NULL default ````,
cnt int(4) NOT NULL default ``0``,
PRIMARY KEY (id)
) TYPE=MyISAM;
CREATE TABLE tbl_search (
id int(11) NOT NULL auto_increment,
title varchar(75) NOT NULL default ````,
free varchar(255) NOT NULL default ````,
album varchar(50) NOT NULL default ````,
artist varchar(200) NOT NULL default ````,
PRIMARY KEY (id)
) TYPE=MyISAM;
CREATE TABLE tbl_users (
u_name varchar(32) NOT NULL default ````,
u_pass varchar(32) NOT NULL default ````,
u_login varchar(32) NOT NULL default ````,
u_ip varchar(16) NOT NULL default ````,
u_comment varchar(64) default NULL,
u_id int(4) NOT NULL auto_increment,
u_sessionkey bigint(16) unsigned default ``0``,
u_booted tinyint(4) NOT NULL default ``0``,
u_status tinyint(4) NOT NULL default ``0``,
u_time bigint(16) NOT NULL default ``0``,
u_access tinyint(4) default ``1``,
PRIMARY KEY (u_id),
UNIQUE KEY u_login (u_login),
UNIQUE KEY u_id (u_id)
) TYPE=MyISAM;