1 -- ########################################################
3 -- SQL Commands to set up the pmadb as described in #
4 -- Documentation.txt. #
6 -- This script expects the user pma to already be #
7 -- existing. (if we would put a line here to create him #
8 -- too many users might just use this script and end #
9 -- up with having the same password for the controluser) #
11 -- Please dont forget to set up the tablenames in #
14 -- Please note that the table names might be converted #
15 -- to lower case, if the MySQL option #
16 -- "lower_case_table_names" is enabled. By default, this #
17 -- is the case on Win32 machines. #
19 -- ########################################################
21 DROP DATABASE IF EXISTS `phpmyadmin`;
22 CREATE DATABASE IF NOT EXISTS `phpmyadmin`;
24 -- (backquotes are not supported in USE)
27 GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO
30 DROP TABLE IF EXISTS `PMA_bookmark`;
31 CREATE TABLE `PMA_bookmark` (
32 `id` int(11) DEFAULT '0' NOT NULL AUTO_INCREMENT,
33 `dbase` VARCHAR(255) NOT NULL,
34 `user` VARCHAR(255) NOT NULL,
35 `label` VARCHAR(255) NOT NULL,
36 `query` TEXT NOT NULL,
38 ) TYPE=MyISAM COMMENT='Bookmarks';
40 DROP TABLE IF EXISTS `PMA_relation`;
41 CREATE TABLE `PMA_relation` (
42 `master_db` VARCHAR(64) NOT NULL DEFAULT '',
43 `master_table` VARCHAR(64) NOT NULL DEFAULT '',
44 `master_field` VARCHAR(64) NOT NULL DEFAULT '',
45 `foreign_db` VARCHAR(64) NOT NULL DEFAULT '',
46 `foreign_table` VARCHAR(64) NOT NULL DEFAULT '',
47 `foreign_field` VARCHAR(64) NOT NULL DEFAULT '',
48 PRIMARY KEY (`master_db`, `master_table`,`master_field`),
49 KEY `foreign_field` (`foreign_db`, `foreign_table`)
50 ) TYPE=MyISAM COMMENT='Relation table';
52 DROP TABLE IF EXISTS `PMA_table_info`;
53 CREATE TABLE `PMA_table_info` (
54 `db_name` VARCHAR(64) NOT NULL DEFAULT '',
55 `table_name` VARCHAR(64) NOT NULL DEFAULT '',
56 `display_field` VARCHAR(64) NOT NULL DEFAULT '',
57 PRIMARY KEY (`db_name`, `table_name`)
58 ) TYPE=MyISAM COMMENT='Table information for phpMyAdmin';
60 DROP TABLE IF EXISTS `PMA_table_coords`;
61 CREATE TABLE `PMA_table_coords` (
62 `db_name` VARCHAR(64) NOT NULL DEFAULT '',
63 `table_name` VARCHAR(64) NOT NULL DEFAULT '',
64 `pdf_page_number` INT NOT NULL DEFAULT '0',
65 `x` float unsigned NOT NULL DEFAULT '0',
66 `y` float unsigned NOT NULL DEFAULT '0',
67 PRIMARY KEY (`db_name`, `table_name`, `pdf_page_number`)
68 ) TYPE=MyISAM COMMENT='Table coordinates for phpMyAdmin PDF output';
70 DROP TABLE IF EXISTS `PMA_pdf_pages`;
71 CREATE TABLE `PMA_pdf_pages` (
72 `db_name` VARCHAR(64) NOT NULL DEFAULT '',
73 `page_nr` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
74 `page_descr` VARCHAR(50) NOT NULL DEFAULT '',
75 PRIMARY KEY (`page_nr`),
77 ) TYPE=MyISAM COMMENT='PDF Relationpages for PMA';
79 DROP TABLE IF EXISTS `PMA_column_info`;
80 CREATE TABLE `PMA_column_info` (
81 `id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
82 `db_name` VARCHAR(64) NOT NULL DEFAULT '',
83 `table_name` VARCHAR(64) NOT NULL DEFAULT '',
84 `column_name` VARCHAR(64) NOT NULL DEFAULT '',
85 `comment` VARCHAR(255) NOT NULL DEFAULT '',
86 `mimetype` VARCHAR(255) NOT NULL DEFAULT '',
87 `transformation` VARCHAR(255) NOT NULL DEFAULT '',
88 `transformation_options` VARCHAR(255) NOT NULL DEFAULT '',
90 UNIQUE KEY `db_name` (`db_name`, `table_name`, `column_name`)
91 ) TYPE=MyISAM COMMENT='Column Information for phpMyAdmin';
93 DROP TABLE IF EXISTS `PMA_history`;
94 CREATE TABLE `PMA_history` (
95 `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
96 `username` VARCHAR(64) NOT NULL,
97 `db` VARCHAR(64) NOT NULL,
98 `table` VARCHAR(64) NOT NULL,
99 `timevalue` TIMESTAMP NOT NULL,
100 `sqlquery` TEXT NOT NULL,
102 KEY `username` (`username`, `db`, `table`, `timevalue`)
103 ) TYPE=MyISAM COMMENT='SQL history';