--
-- Do not use these beginning lines...
--
CREATE DATABASE phplayersmenu;
GRANT select, insert, update, delete, create, drop ON phplayersmenu.* TO mysql@localhost IDENTIFIED BY 'mysql';
USE phplayersmenu;
--
-- ... if you are importing the dump through phpMyAdmin :^)
--

CREATE TABLE phplayersmenu (
	id int NOT NULL auto_increment,
	parent_id int DEFAULT '1' NOT NULL,
	text text,
	href text,
	title text,
	icon text,
	target text,
	orderfield int DEFAULT '0',
	expanded tinyint DEFAULT '0',
	PRIMARY KEY (id)
);

CREATE TABLE phplayersmenu_i18n (
	language varchar(15) NOT NULL,
	id int NOT NULL,
	text text,
	title text,
	PRIMARY KEY (language, id)
);

