CREATE TABLE module_fileserver_users (
	id				int(10) unsigned NOT NULL auto_increment,
	name			varchar(255) NOT NULL default '',
	sys_name		varchar(255) NOT NULL default '',
	password		varchar(255) NOT NULL default '',
	password_type	enum('plain', 'crypt') NOT NULL default 'plain',
	PRIMARY KEY (id),
	UNIQUE KEY name (name)
) TYPE=MyISAM;

CREATE TABLE module_fileserver_shares (
	id				int(10) unsigned NOT NULL auto_increment,
	name			varchar(255) NOT NULL default '',
	description		varchar(255) NOT NULL default '',
	path			varchar(255) NOT NULL default '',
	writable		enum('false', 'true') NOT NULL default 'false',
	guest_ok		enum('false', 'true') NOT NULL default 'false',
	valid_users		enum('any', 'select') NOT NULL default 'any',
	PRIMARY KEY (id),
	UNIQUE KEY name (name)
) TYPE=MyISAM;

CREATE TABLE module_fileserver_valid_users (
	sid				int(10) unsigned NOT NULL,
	uid				int(10) unsigned NOT NULL,
	PRIMARY KEY (sid, uid)
) TYPE=MyISAM;

CREATE TABLE module_fileserver_params (
	param			varchar(255) NOT NULL,
	val				varchar(255) NOT NULL default '',
	PRIMARY KEY (param)
) TYPE=MyISAM;