Version bump

3 files changed, 151 insertions, 0 deletions

diff --git a/dev-db/phpmyadmin/files/config.inc.php-2.5.5.patch b/dev-db/phpmyadmin/files/config.inc.php-2.5.5.patch
new file mode 100644
index 000000000000..016ff6a372e3
--- /dev/null
+++ b/dev-db/phpmyadmin/files/config.inc.php-2.5.5.patch
@@ -0,0 +1,66 @@
+--- phpMyAdmin-2.5.5/config.inc.php	2003-12-02 21:59:24.000000000 +0000
++++ phpMyAdmin/config.inc.php	2003-12-29 01:09:58.000000000 +0000
+@@ -72,14 +72,15 @@
+ $cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
+ $cfg['Servers'][$i]['compress']      = FALSE;       // Use compressed protocol for the MySQL connection
+                                                     // (requires PHP >= 4.3.0)
+-$cfg['Servers'][$i]['controluser']   = '';          // MySQL control user settings
++$cfg['Servers'][$i]['controluser']   = 'pma';       // MySQL control user settings
+                                                     // (this user must have read-only
+-$cfg['Servers'][$i]['controlpass']   = '';          // access to the "mysql/user"
++$cfg['Servers'][$i]['controlpass']   = '@pmapass@';
++                                                    // access to the "mysql/user"
+                                                     // and "mysql/db" tables).
+                                                     // The controluser is also
+                                                     // used for all relational
+                                                     // features (pmadb)
+-$cfg['Servers'][$i]['auth_type']     = 'config';    // Authentication method (config, http or cookie based)?
++$cfg['Servers'][$i]['auth_type']     = 'http';      // Authentication method (config, http or cookie based)?
+ $cfg['Servers'][$i]['user']          = 'root';      // MySQL user
+ $cfg['Servers'][$i]['password']      = '';          // MySQL password (only needed
+                                                     // with 'config' auth_type)
+@@ -88,29 +89,36 @@
+                                                     // It may also be an array of db-names, where sorting order is relevant.
+ $cfg['Servers'][$i]['verbose']       = '';          // Verbose name for this host - leave blank to show the hostname
+ 
+-$cfg['Servers'][$i]['pmadb']         = '';          // Database used for Relation, Bookmark and PDF Features
++$cfg['Servers'][$i]['pmadb']         = 'pmadb';     // Database used for Relation, Bookmark and PDF Features
+                                                     // (see scripts/create_tables.sql)
+                                                     //   - leave blank for no support
+                                                     //     DEFAULT: 'phpmyadmin'
+-$cfg['Servers'][$i]['bookmarktable'] = '';          // Bookmark table
++$cfg['Servers'][$i]['bookmarktable'] = 'PMA_bookmark';
++                                                    // Bookmark table
+                                                     //   - leave blank for no bookmark support
+                                                     //     DEFAULT: 'pma_bookmark'
+-$cfg['Servers'][$i]['relation']      = '';          // table to describe the relation between links (see doc)
++$cfg['Servers'][$i]['relation']      = 'PMA_relation';
++                                                    // table to describe the relation between links (see doc)
+                                                     //   - leave blank for no relation-links support
+                                                     //     DEFAULT: 'pma_relation'
+-$cfg['Servers'][$i]['table_info']    = '';          // table to describe the display fields
++$cfg['Servers'][$i]['table_info']    = 'PMA_table_info';
++                                                    // table to describe the display fields
+                                                     //   - leave blank for no display fields support
+                                                     //     DEFAULT: 'pma_table_info'
+-$cfg['Servers'][$i]['table_coords']  = '';          // table to describe the tables position for the PDF schema
++$cfg['Servers'][$i]['table_coords']  = 'PMA_table_coords';
++                                                    // table to describe the tables position for the PDF schema
+                                                     //   - leave blank for no PDF schema support
+                                                     //     DEFAULT: 'pma_table_coords'
+-$cfg['Servers'][$i]['pdf_pages']     = '';          // table to describe pages of relationpdf
++$cfg['Servers'][$i]['pdf_pages']     = 'PMA_pdf_pages';
++                                                    // table to describe pages of relationpdf
+                                                     //   - leave blank if you don't want to use this
+                                                     //     DEFAULT: 'pma_pdf_pages'
+-$cfg['Servers'][$i]['column_info']   = '';          // table to store column information
++$cfg['Servers'][$i]['column_info']   = 'PMA_column_info';
++                                                    // table to store column information
+                                                     //   - leave blank for no column comments/mime types
+                                                     //     DEFAULT: 'pma_column_info'
+-$cfg['Servers'][$i]['history']       = '';          // table to store SQL history
++$cfg['Servers'][$i]['history']       = 'PMA_history';
++                                                    // table to store SQL history
+                                                     //   - leave blank for no SQL query history
+                                                     //     DEFAULT: 'pma_history'
+ $cfg['Servers'][$i]['verbose_check'] = TRUE;        // set to FALSE if you know that your pma_* tables
diff --git a/dev-db/phpmyadmin/files/digest-phpmyadmin-2.5.5 b/dev-db/phpmyadmin/files/digest-phpmyadmin-2.5.5
new file mode 100644
index 000000000000..5a9c1516a3fb
--- /dev/null
+++ b/dev-db/phpmyadmin/files/digest-phpmyadmin-2.5.5
@@ -0,0 +1 @@
+MD5 b790e9f10f9e0d8406d2684e7ad6a9df phpMyAdmin-2.5.5.tar.bz2 1094355
diff --git a/dev-db/phpmyadmin/files/mysql-setup.sql.in-2.5.5 b/dev-db/phpmyadmin/files/mysql-setup.sql.in-2.5.5
new file mode 100644
index 000000000000..147c07f721b8
--- /dev/null
+++ b/dev-db/phpmyadmin/files/mysql-setup.sql.in-2.5.5
@@ -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';