diff options
Diffstat (limited to 'scripts/create_tables.sql')
-rw-r--r-- | scripts/create_tables.sql | 159 |
1 files changed, 159 insertions, 0 deletions
diff --git a/scripts/create_tables.sql b/scripts/create_tables.sql new file mode 100644 index 0000000000..7fca18cf18 --- /dev/null +++ b/scripts/create_tables.sql @@ -0,0 +1,159 @@ +-- -------------------------------------------------------- +-- SQL Commands to set up the pmadb as described in Documentation.html. +-- +-- DON'T RUN THIS SCRIPT ON MySQL 4.1.2 AND ABOVE! +-- Instead, please run create_tables_mysql_4_1_2+.sql. +-- +-- This script expects the user pma to already be existing. If we would put a +-- line here to create him too many users might just use this script and end +-- up with having the same password for the controluser. +-- +-- This user "pma" must be defined in config.inc.php (controluser/controlpass) +-- +-- Please don't forget to set up the tablenames in config.inc.php +-- +-- $Id$ + +-- -------------------------------------------------------- + +-- +-- Database : `phpmyadmin` +-- +DROP DATABASE IF EXISTS `phpmyadmin`; +CREATE DATABASE `phpmyadmin`; +USE phpmyadmin; + +-- -------------------------------------------------------- + +-- +-- Privileges +-- +GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO + 'pma'@localhost; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `pma_bookmark` +-- + +CREATE TABLE `pma_bookmark` ( + `id` int(11) NOT NULL auto_increment, + `dbase` varchar(255) NOT NULL default '', + `user` varchar(255) NOT NULL default '', + `label` varchar(255) NOT NULL default '', + `query` text NOT NULL, + PRIMARY KEY (`id`) +) TYPE=MyISAM COMMENT='Bookmarks'; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `pma_column_info` +-- + +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='Column information for phpMyAdmin'; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `pma_history` +-- + +CREATE TABLE `pma_history` ( + `id` bigint(20) unsigned NOT NULL auto_increment, + `username` varchar(64) NOT NULL default '', + `db` varchar(64) NOT NULL default '', + `table` varchar(64) NOT NULL default '', + `timevalue` timestamp(14) NOT NULL, + `sqlquery` text NOT NULL, + PRIMARY KEY (`id`), + KEY `username` (`username`,`db`,`table`,`timevalue`) +) TYPE=MyISAM COMMENT='SQL history for phpMyAdmin'; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `pma_pdf_pages` +-- + +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` (`db_name`) +) TYPE=MyISAM COMMENT='PDF relation pages for phpMyAdmin'; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `pma_relation` +-- + +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'; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `pma_table_coords` +-- + +CREATE TABLE `pma_table_coords` ( + `db_name` varchar(64) NOT NULL default '', + `table_name` varchar(64) NOT NULL default '', + `pdf_page_number` int(11) 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'; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `pma_table_info` +-- + +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'; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `pma_designer_coords` +-- + +CREATE TABLE `pma_designer_coords` ( + `db_name` varchar(64) NOT NULL default '', + `table_name` varchar(64) NOT NULL default '', + `x` INT(11) default NULL, + `y` INT(11) default NULL, + `v` TINYINT(4) default NULL, + `h` TINYINT(4) default NULL, + PRIMARY KEY (`db_name`,`table_name`) +) TYPE=MyISAM COMMENT='Table coordinates for Designer' + |