· 6 years ago · Aug 09, 2019, 06:34 PM
1-- --------------------------------------------------------
2-- SQL Commands to set up the pmadb as described in the documentation.
3--
4-- This file is meant for use with MySQL 5 and above!
5--
6-- This script expects the user pma to already be existing. If we would put a
7-- line here to create him too many users might just use this script and end
8-- up with having the same password for the controluser.
9--
10-- This user "pma" must be defined in config.inc.php (controluser/controlpass)
11--
12-- Please don't forget to set up the tablenames in config.inc.php
13--
14
15-- --------------------------------------------------------
16
17--
18-- Database : `phpmyadmin`
19--
20CREATE DATABASE IF NOT EXISTS `phpmyadmin`
21 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
22USE phpmyadmin;
23
24-- --------------------------------------------------------
25
26--
27-- Privileges
28--
29-- (activate this statement if necessary)
30-- GRANT SELECT, INSERT, DELETE, UPDATE, ALTER ON `phpmyadmin`.* TO
31-- 'pma'@localhost;
32
33-- --------------------------------------------------------
34
35--
36-- Table structure for table `pma__bookmark`
37--
38
39CREATE TABLE IF NOT EXISTS `pma__bookmark` (
40 `id` int(10) unsigned NOT NULL auto_increment,
41 `dbase` varchar(255) NOT NULL default '',
42 `user` varchar(255) NOT NULL default '',
43 `label` varchar(255) COLLATE utf8_general_ci NOT NULL default '',
44 `query` text NOT NULL,
45 PRIMARY KEY (`id`)
46)
47 COMMENT='Bookmarks'
48 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
49
50-- --------------------------------------------------------
51
52--
53-- Table structure for table `pma__column_info`
54--
55
56CREATE TABLE IF NOT EXISTS `pma__column_info` (
57 `id` int(5) unsigned NOT NULL auto_increment,
58 `db_name` varchar(64) NOT NULL default '',
59 `table_name` varchar(64) NOT NULL default '',
60 `column_name` varchar(64) NOT NULL default '',
61 `comment` varchar(255) COLLATE utf8_general_ci NOT NULL default '',
62 `mimetype` varchar(255) COLLATE utf8_general_ci NOT NULL default '',
63 `transformation` varchar(255) NOT NULL default '',
64 `transformation_options` varchar(255) NOT NULL default '',
65 `input_transformation` varchar(255) NOT NULL default '',
66 `input_transformation_options` varchar(255) NOT NULL default '',
67 PRIMARY KEY (`id`),
68 UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`)
69)
70 COMMENT='Column information for phpMyAdmin'
71 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
72
73-- --------------------------------------------------------
74
75--
76-- Table structure for table `pma__history`
77--
78
79CREATE TABLE IF NOT EXISTS `pma__history` (
80 `id` bigint(20) unsigned NOT NULL auto_increment,
81 `username` varchar(64) NOT NULL default '',
82 `db` varchar(64) NOT NULL default '',
83 `table` varchar(64) NOT NULL default '',
84 `timevalue` timestamp NOT NULL default CURRENT_TIMESTAMP,
85 `sqlquery` text NOT NULL,
86 PRIMARY KEY (`id`),
87 KEY `username` (`username`,`db`,`table`,`timevalue`)
88)
89 COMMENT='SQL history for phpMyAdmin'
90 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
91
92-- --------------------------------------------------------
93
94--
95-- Table structure for table `pma__pdf_pages`
96--
97
98CREATE TABLE IF NOT EXISTS `pma__pdf_pages` (
99 `db_name` varchar(64) NOT NULL default '',
100 `page_nr` int(10) unsigned NOT NULL auto_increment,
101 `page_descr` varchar(50) COLLATE utf8_general_ci NOT NULL default '',
102 PRIMARY KEY (`page_nr`),
103 KEY `db_name` (`db_name`)
104)
105 COMMENT='PDF relation pages for phpMyAdmin'
106 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
107
108-- --------------------------------------------------------
109
110--
111-- Table structure for table `pma__recent`
112--
113
114CREATE TABLE IF NOT EXISTS `pma__recent` (
115 `username` varchar(64) NOT NULL,
116 `tables` text NOT NULL,
117 PRIMARY KEY (`username`)
118)
119 COMMENT='Recently accessed tables'
120 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
121
122-- --------------------------------------------------------
123
124--
125-- Table structure for table `pma__favorite`
126--
127
128CREATE TABLE IF NOT EXISTS `pma__favorite` (
129 `username` varchar(64) NOT NULL,
130 `tables` text NOT NULL,
131 PRIMARY KEY (`username`)
132)
133 COMMENT='Favorite tables'
134 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
135
136-- --------------------------------------------------------
137
138--
139-- Table structure for table `pma__table_uiprefs`
140--
141
142CREATE TABLE IF NOT EXISTS `pma__table_uiprefs` (
143 `username` varchar(64) NOT NULL,
144 `db_name` varchar(64) NOT NULL,
145 `table_name` varchar(64) NOT NULL,
146 `prefs` text NOT NULL,
147 `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
148 PRIMARY KEY (`username`,`db_name`,`table_name`)
149)
150 COMMENT='Tables'' UI preferences'
151 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
152
153-- --------------------------------------------------------
154
155--
156-- Table structure for table `pma__relation`
157--
158
159CREATE TABLE IF NOT EXISTS `pma__relation` (
160 `master_db` varchar(64) NOT NULL default '',
161 `master_table` varchar(64) NOT NULL default '',
162 `master_field` varchar(64) NOT NULL default '',
163 `foreign_db` varchar(64) NOT NULL default '',
164 `foreign_table` varchar(64) NOT NULL default '',
165 `foreign_field` varchar(64) NOT NULL default '',
166 PRIMARY KEY (`master_db`,`master_table`,`master_field`),
167 KEY `foreign_field` (`foreign_db`,`foreign_table`)
168)
169 COMMENT='Relation table'
170 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
171
172-- --------------------------------------------------------
173
174--
175-- Table structure for table `pma__table_coords`
176--
177
178CREATE TABLE IF NOT EXISTS `pma__table_coords` (
179 `db_name` varchar(64) NOT NULL default '',
180 `table_name` varchar(64) NOT NULL default '',
181 `pdf_page_number` int(11) NOT NULL default '0',
182 `x` float unsigned NOT NULL default '0',
183 `y` float unsigned NOT NULL default '0',
184 PRIMARY KEY (`db_name`,`table_name`,`pdf_page_number`)
185)
186 COMMENT='Table coordinates for phpMyAdmin PDF output'
187 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
188
189-- --------------------------------------------------------
190
191--
192-- Table structure for table `pma__table_info`
193--
194
195CREATE TABLE IF NOT EXISTS `pma__table_info` (
196 `db_name` varchar(64) NOT NULL default '',
197 `table_name` varchar(64) NOT NULL default '',
198 `display_field` varchar(64) NOT NULL default '',
199 PRIMARY KEY (`db_name`,`table_name`)
200)
201 COMMENT='Table information for phpMyAdmin'
202 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
203
204-- --------------------------------------------------------
205
206--
207-- Table structure for table `pma__tracking`
208--
209
210CREATE TABLE IF NOT EXISTS `pma__tracking` (
211 `db_name` varchar(64) NOT NULL,
212 `table_name` varchar(64) NOT NULL,
213 `version` int(10) unsigned NOT NULL,
214 `date_created` datetime NOT NULL,
215 `date_updated` datetime NOT NULL,
216 `schema_snapshot` text NOT NULL,
217 `schema_sql` text,
218 `data_sql` longtext,
219 `tracking` set('UPDATE','REPLACE','INSERT','DELETE','TRUNCATE','CREATE DATABASE','ALTER DATABASE','DROP DATABASE','CREATE TABLE','ALTER TABLE','RENAME TABLE','DROP TABLE','CREATE INDEX','DROP INDEX','CREATE VIEW','ALTER VIEW','DROP VIEW') default NULL,
220 `tracking_active` int(1) unsigned NOT NULL default '1',
221 PRIMARY KEY (`db_name`,`table_name`,`version`)
222)
223 COMMENT='Database changes tracking for phpMyAdmin'
224 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
225
226-- --------------------------------------------------------
227
228--
229-- Table structure for table `pma__userconfig`
230--
231
232CREATE TABLE IF NOT EXISTS `pma__userconfig` (
233 `username` varchar(64) NOT NULL,
234 `timevalue` timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
235 `config_data` text NOT NULL,
236 PRIMARY KEY (`username`)
237)
238 COMMENT='User preferences storage for phpMyAdmin'
239 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
240
241-- --------------------------------------------------------
242
243--
244-- Table structure for table `pma__users`
245--
246
247CREATE TABLE IF NOT EXISTS `pma__users` (
248 `username` varchar(64) NOT NULL,
249 `usergroup` varchar(64) NOT NULL,
250 PRIMARY KEY (`username`,`usergroup`)
251)
252 COMMENT='Users and their assignments to user groups'
253 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
254
255-- --------------------------------------------------------
256
257--
258-- Table structure for table `pma__usergroups`
259--
260
261CREATE TABLE IF NOT EXISTS `pma__usergroups` (
262 `usergroup` varchar(64) NOT NULL,
263 `tab` varchar(64) NOT NULL,
264 `allowed` enum('Y','N') NOT NULL DEFAULT 'N',
265 PRIMARY KEY (`usergroup`,`tab`,`allowed`)
266)
267 COMMENT='User groups with configured menu items'
268 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
269
270-- --------------------------------------------------------
271
272--
273-- Table structure for table `pma__navigationhiding`
274--
275
276CREATE TABLE IF NOT EXISTS `pma__navigationhiding` (
277 `username` varchar(64) NOT NULL,
278 `item_name` varchar(64) NOT NULL,
279 `item_type` varchar(64) NOT NULL,
280 `db_name` varchar(64) NOT NULL,
281 `table_name` varchar(64) NOT NULL,
282 PRIMARY KEY (`username`,`item_name`,`item_type`,`db_name`,`table_name`)
283)
284 COMMENT='Hidden items of navigation tree'
285 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
286
287-- --------------------------------------------------------
288
289--
290-- Table structure for table `pma__savedsearches`
291--
292
293CREATE TABLE IF NOT EXISTS `pma__savedsearches` (
294 `id` int(5) unsigned NOT NULL auto_increment,
295 `username` varchar(64) NOT NULL default '',
296 `db_name` varchar(64) NOT NULL default '',
297 `search_name` varchar(64) NOT NULL default '',
298 `search_data` text NOT NULL,
299 PRIMARY KEY (`id`),
300 UNIQUE KEY `u_savedsearches_username_dbname` (`username`,`db_name`,`search_name`)
301)
302 COMMENT='Saved searches'
303 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
304
305-- --------------------------------------------------------
306
307--
308-- Table structure for table `pma__central_columns`
309--
310
311CREATE TABLE IF NOT EXISTS `pma__central_columns` (
312 `db_name` varchar(64) NOT NULL,
313 `col_name` varchar(64) NOT NULL,
314 `col_type` varchar(64) NOT NULL,
315 `col_length` text,
316 `col_collation` varchar(64) NOT NULL,
317 `col_isNull` boolean NOT NULL,
318 `col_extra` varchar(255) default '',
319 `col_default` text,
320 PRIMARY KEY (`db_name`,`col_name`)
321)
322 COMMENT='Central list of columns'
323 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
324
325-- --------------------------------------------------------
326
327--
328-- Table structure for table `pma__designer_settings`
329--
330
331CREATE TABLE IF NOT EXISTS `pma__designer_settings` (
332 `username` varchar(64) NOT NULL,
333 `settings_data` text NOT NULL,
334 PRIMARY KEY (`username`)
335)
336 COMMENT='Settings related to Designer'
337 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
338
339-- --------------------------------------------------------
340
341--
342-- Table structure for table `pma__export_templates`
343--
344
345CREATE TABLE IF NOT EXISTS `pma__export_templates` (
346 `id` int(5) unsigned NOT NULL AUTO_INCREMENT,
347 `username` varchar(64) NOT NULL,
348 `export_type` varchar(10) NOT NULL,
349 `template_name` varchar(64) NOT NULL,
350 `template_data` text NOT NULL,
351 PRIMARY KEY (`id`),
352 UNIQUE KEY `u_user_type_template` (`username`,`export_type`,`template_name`)
353)
354 COMMENT='Saved export templates'
355 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;