CREATE TABLE IF NOT EXISTS `group`
(
	`name` VARCHAR(64) NOT NULL,
	`type` VARCHAR(32) NOT NULL,
	`value` SMALLINT NOT NULL,
	PRIMARY KEY  (`type`)
) TYPE=MyISAM;

CREATE TABLE IF NOT EXISTS `user`
(
	`active` TINYINT NULL,
	`count_logins` INTEGER NOT NULL DEFAULT 0,
	`description` TEXT NULL,
	`gender` VARCHAR(1) NOT NULL DEFAULT 'n',
	`id` VARCHAR(32) NOT NULL,
	`inserted` INTEGER NOT NULL,
	`last_login` INTEGER NULL,
	`mail` VARCHAR(255) NOT NULL,
	`modified` INTEGER NULL,
	`passwort` VARCHAR(128) NOT NULL,
	`permission` TEXT NULL,
	`photo` VARCHAR(255) NULL,
	`photo_active` TINYINT NULL DEFAULT 0,
	`type` VARCHAR(32) NOT NULL,
	PRIMARY KEY  (`id`)
) TYPE=MyISAM;

CREATE TABLE IF NOT EXISTS `newuser`
(
	`newuser_id` INTEGER NOT NULL auto_increment,
	`newuser_key` TEXT NOT NULL,
	`newuser_mail` VARCHAR(255) NOT NULL,
	`newuser_name` VARCHAR(32) NOT NULL,
	`newuser_utc` int(11) NOT NULL DEFAULT '0',
	`newuser_ip` VARCHAR(15) NOT NULL,
	PRIMARY KEY  (`newuser_id`)
) TYPE=MyISAM;