1 files changed, 84 insertions, 0 deletions
diff --git a/dev-db/phpmyadmin/files/mysql-setup.sql.in-2.5.4 b/dev-db/phpmyadmin/files/mysql-setup.sql.in-2.5.4
new file mode 100644
index 000000000000..147c07f721b8
--- /dev/null
+++ b/dev-db/phpmyadmin/files/mysql-setup.sql.in-2.5.4
@@ -0,0 +1,84 @@
+GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY '@pmapass@';
+
+GRANT SELECT (Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,
+	Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,
+	File_priv, Grant_priv, References_priv, Index_priv, Alter_priv)
+	ON mysql.user TO 'pma'@'localhost';
+
+GRANT SELECT ON mysql.db TO 'pma'@'localhost';
+
+GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)
+	ON mysql.tables_priv TO 'pma'@'localhost';
+
+GRANT SELECT, INSERT, UPDATE, DELETE ON pmadb.* TO 'pma'@'localhost';
+
+CREATE DATABASE IF NOT EXISTS pmadb;
+USE pmadb;
+
+CREATE TABLE IF NOT EXISTS `PMA_bookmark` (
+	`id` int(11) DEFAULT '0' NOT NULL auto_increment,
+	`dbase` varchar(255) NOT NULL,
+	`user` varchar(255) NOT NULL,
+	`label` varchar(255) NOT NULL,
+	`query` text NOT NULL,
+	PRIMARY KEY (id)
+	) TYPE=MyISAM COMMENT='Bookmarks';
+
+CREATE TABLE IF NOT EXISTS `PMA_relation` (
+	`master_db` varchar(64) NOT NULL default '',
+	`master_table` varchar(64) NOT NULL default '',
+	`master_field` varchar(64) NOT NULL default '',
+	`foreign_db` varchar(64) NOT NULL default '',
+	`foreign_table` varchar(64) NOT NULL default '',
+	`foreign_field` varchar(64) NOT NULL default '',
+	PRIMARY KEY (`master_db`, `master_table`, `master_field`),
+	KEY foreign_field (foreign_db, foreign_table)
+	) TYPE=MyISAM COMMENT='Relation table';
+
+CREATE TABLE IF NOT EXISTS `PMA_table_info` (
+	`db_name` varchar(64) NOT NULL default '',
+	`table_name` varchar(64) NOT NULL default '',
+	`display_field` varchar(64) NOT NULL default '',
+	PRIMARY KEY (`db_name`, `table_name`)
+	) TYPE=MyISAM COMMENT='Table information for phpMyAdmin';
+
+CREATE TABLE IF NOT EXISTS `PMA_table_coords` (
+	`db_name` varchar(64) NOT NULL default '',
+	`table_name` varchar(64) NOT NULL default '',
+	`pdf_page_number` int NOT NULL default '0',
+	`x` float unsigned NOT NULL default '0',
+	`y` float unsigned NOT NULL default '0',
+	PRIMARY KEY (`db_name`, `table_name`, `pdf_page_number`)
+	) TYPE=MyISAM COMMENT='Table coordinates for phpMyAdmin PDF output';
+
+CREATE TABLE IF NOT EXISTS `PMA_pdf_pages` (
+	`db_name` varchar(64) NOT NULL default '',
+	`page_nr` int(10) unsigned NOT NULL auto_increment,
+	`page_descr` varchar(50) NOT NULL default '',
+	PRIMARY KEY (page_nr),
+	KEY (db_name)
+	) TYPE=MyISAM COMMENT='PDF Relationpages for PMA';
+
+CREATE TABLE IF NOT EXISTS `PMA_column_info` (
+	id int(5) unsigned NOT NULL auto_increment,
+	db_name varchar(64) NOT NULL default '',
+	table_name varchar(64) NOT NULL default '',
+	column_name varchar(64) NOT NULL default '',
+	`comment` varchar(255) NOT NULL default '',
+	mimetype varchar(255) NOT NULL default '',
+	transformation varchar(255) NOT NULL default '',
+	transformation_options varchar(255) NOT NULL default '',
+	PRIMARY KEY (id),
+	UNIQUE KEY db_name (db_name, table_name, column_name)
+	) TYPE=MyISAM COMMENT='Comments for Columns';
+
+CREATE TABLE IF NOT EXISTS `PMA_history` (
+	`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
+	`username` VARCHAR( 64 ) NOT NULL ,
+	`db` VARCHAR( 64 ) NOT NULL ,
+	`table` VARCHAR( 64 ) NOT NULL ,
+	`timevalue` TIMESTAMP NOT NULL ,
+	`sqlquery` TEXT NOT NULL ,
+	PRIMARY KEY ( `id` ) ,
+	INDEX ( `username` , `db` , `table` , `timevalue` )
+	) TYPE=MyISAM COMMENT='SQL history';