CREATE DATABASE phpmyadmin;
CONNECT phpmyadmin;

CREATE TABLE `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 `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 `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 `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 `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 `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 `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';