summaryrefslogtreecommitdiff
path: root/dev-db
diff options
context:
space:
mode:
authorMartin Holzer <mholzer@gentoo.org>2004-05-01 09:55:06 +0000
committerMartin Holzer <mholzer@gentoo.org>2004-05-01 09:55:06 +0000
commiteb2cb550ee65818c9799b75694a9938d90dd103b (patch)
tree82436867c2a0035662402afe16d94de2b04e4a01 /dev-db
parentstable on all arches. Closes 48379 (diff)
downloadhistorical-eb2cb550ee65818c9799b75694a9938d90dd103b.tar.gz
historical-eb2cb550ee65818c9799b75694a9938d90dd103b.tar.bz2
historical-eb2cb550ee65818c9799b75694a9938d90dd103b.zip
cleanup
Diffstat (limited to 'dev-db')
-rw-r--r--dev-db/phpmyadmin/Manifest2
-rw-r--r--dev-db/phpmyadmin/files/config.inc.php-2.5.6_rc1.patch66
-rw-r--r--dev-db/phpmyadmin/files/mysql-setup.sql.in-2.5.6_rc184
3 files changed, 0 insertions, 152 deletions
diff --git a/dev-db/phpmyadmin/Manifest b/dev-db/phpmyadmin/Manifest
index 8080b462b7bc..c14cd25ac7a3 100644
--- a/dev-db/phpmyadmin/Manifest
+++ b/dev-db/phpmyadmin/Manifest
@@ -6,5 +6,3 @@ MD5 5367bc809b77e6374f18d126990fba75 files/digest-phpmyadmin-2.5.6 70
MD5 12e8a97118eb6912911e207e72d1a421 files/mysql-setup.sql.in-2.5.6 3230
MD5 c6a79ab6f3c9e6d657a5bee36b1f6565 files/phpmyadmin-config.patch 4857
MD5 396133c1da8d8b716ad2da23aa0a5a30 files/phpmyadmin-mysql-setup.sql.in 2712
-MD5 85a86432c3f64acb068a7d2cfab311a9 files/config.inc.php-2.5.6_rc1.patch 5525
-MD5 12e8a97118eb6912911e207e72d1a421 files/mysql-setup.sql.in-2.5.6_rc1 3230
diff --git a/dev-db/phpmyadmin/files/config.inc.php-2.5.6_rc1.patch b/dev-db/phpmyadmin/files/config.inc.php-2.5.6_rc1.patch
deleted file mode 100644
index 17ce8c8187fc..000000000000
--- a/dev-db/phpmyadmin/files/config.inc.php-2.5.6_rc1.patch
+++ /dev/null
@@ -1,66 +0,0 @@
---- config.inc.php.org 2003-12-02 21:59:24.000000000 +0000
-+++ 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/mysql-setup.sql.in-2.5.6_rc1 b/dev-db/phpmyadmin/files/mysql-setup.sql.in-2.5.6_rc1
deleted file mode 100644
index 147c07f721b8..000000000000
--- a/dev-db/phpmyadmin/files/mysql-setup.sql.in-2.5.6_rc1
+++ /dev/null
@@ -1,84 +0,0 @@
-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';