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 -- This user "pma" must be defined in config.inc.php #
12 -- (controluser/controlpass) #
14 -- Please dont forget to set up the tablenames in #
17 -- Please note that the table names might be converted #
18 -- to lower case, if the MySQL option #
19 -- "lower_case_table_names" is enabled. By default, this #
20 -- is the case on Win32 machines. #
22 -- ########################################################
26 GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO
29 DROP TABLE IF EXISTS `pma_bookmark`;
30 CREATE TABLE `pma_bookmark` (
31 `id` int(11) DEFAULT '0' NOT NULL AUTO_INCREMENT,
32 `dbase` VARCHAR(255) NOT NULL,
33 `user` VARCHAR(255) NOT NULL,
34 `label` VARCHAR(255) NOT NULL,
35 `query` TEXT NOT NULL,
37 ) TYPE=MyISAM COMMENT='Bookmarks';
39 DROP TABLE IF EXISTS `pma_relation`;
40 CREATE TABLE `pma_relation` (
41 `master_db` VARCHAR(64) NOT NULL DEFAULT '',
42 `master_table` VARCHAR(64) NOT NULL DEFAULT '',
43 `master_field` VARCHAR(64) NOT NULL DEFAULT '',
44 `foreign_db` VARCHAR(64) NOT NULL DEFAULT '',
45 `foreign_table` VARCHAR(64) NOT NULL DEFAULT '',
46 `foreign_field` VARCHAR(64) NOT NULL DEFAULT '',
47 PRIMARY KEY (`master_db`, `master_table`,`master_field`),
48 KEY `foreign_field` (`foreign_db`, `foreign_table`)
49 ) TYPE=MyISAM COMMENT='Relation table';
51 DROP TABLE IF EXISTS `pma_table_info`;
52 CREATE TABLE `pma_table_info` (
53 `db_name` VARCHAR(64) NOT NULL DEFAULT '',
54 `table_name` VARCHAR(64) NOT NULL DEFAULT '',
55 `display_field` VARCHAR(64) NOT NULL DEFAULT '',
56 PRIMARY KEY (`db_name`, `table_name`)
57 ) TYPE=MyISAM COMMENT='Table information for phpMyAdmin';
59 DROP TABLE IF EXISTS `pma_table_coords`;
60 CREATE TABLE `pma_table_coords` (
61 `db_name` VARCHAR(64) NOT NULL DEFAULT '',
62 `table_name` VARCHAR(64) NOT NULL DEFAULT '',
63 `pdf_page_number` INT NOT NULL DEFAULT '0',
64 `x` float unsigned NOT NULL DEFAULT '0',
65 `y` float unsigned NOT NULL DEFAULT '0',
66 PRIMARY KEY (`db_name`, `table_name`, `pdf_page_number`)
67 ) TYPE=MyISAM COMMENT='Table coordinates for phpMyAdmin PDF output';
69 DROP TABLE IF EXISTS `pma_pdf_pages`;
70 CREATE TABLE `pma_pdf_pages` (
71 `db_name` VARCHAR(64) NOT NULL DEFAULT '',
72 `page_nr` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
73 `page_descr` VARCHAR(50) NOT NULL DEFAULT '',
74 PRIMARY KEY (`page_nr`),
76 ) TYPE=MyISAM COMMENT='PDF Relationpages for PMA';
78 DROP TABLE IF EXISTS `pma_column_info`;
79 CREATE TABLE `pma_column_info` (
80 `id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
81 `db_name` VARCHAR(64) NOT NULL DEFAULT '',
82 `table_name` VARCHAR(64) NOT NULL DEFAULT '',
83 `column_name` VARCHAR(64) NOT NULL DEFAULT '',
84 `comment` VARCHAR(255) NOT NULL DEFAULT '',
85 `mimetype` VARCHAR(255) NOT NULL DEFAULT '',
86 `transformation` VARCHAR(255) NOT NULL DEFAULT '',
87 `transformation_options` VARCHAR(255) NOT NULL DEFAULT '',
89 UNIQUE KEY `db_name` (`db_name`, `table_name`, `column_name`)
90 ) TYPE=MyISAM COMMENT='Column Information for phpMyAdmin';
92 DROP TABLE IF EXISTS `pma_history`;
93 CREATE TABLE `pma_history` (
94 `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
95 `username` VARCHAR(64) NOT NULL,
96 `db` VARCHAR(64) NOT NULL,
97 `table` VARCHAR(64) NOT NULL,
98 `timevalue` TIMESTAMP NOT NULL,
99 `sqlquery` TEXT NOT NULL,
101 KEY `username` (`username`, `db`, `table`, `timevalue`)
102 ) TYPE=MyISAM COMMENT='SQL history';