diff options
Diffstat (limited to 'dev-db/phpmyadmin/files/mysql-setup.sql.in-2.5.1')
-rw-r--r-- | dev-db/phpmyadmin/files/mysql-setup.sql.in-2.5.1 | 84 |
1 files changed, 0 insertions, 84 deletions
diff --git a/dev-db/phpmyadmin/files/mysql-setup.sql.in-2.5.1 b/dev-db/phpmyadmin/files/mysql-setup.sql.in-2.5.1 deleted file mode 100644 index 147c07f721b8..000000000000 --- a/dev-db/phpmyadmin/files/mysql-setup.sql.in-2.5.1 +++ /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'; |