HkBfSAUG

1SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
2SET time_zone = "+00:00";
3CREATE DATABASE IF NOT EXISTS `phpmyadmin` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
4USE `phpmyadmin`;
5
6DROP TABLE IF EXISTS `pma__bookmark`;
7CREATE TABLE `pma__bookmark` (
8  `id` int(10) UNSIGNED NOT NULL,
9  `dbase` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
10  `user` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
11  `label` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
12  `query` text COLLATE utf8_bin NOT NULL
13) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Bookmarks';
14
15TRUNCATE TABLE `pma__bookmark`;
16DROP TABLE IF EXISTS `pma__central_columns`;
17CREATE TABLE `pma__central_columns` (
18  `db_name` varchar(64) COLLATE utf8_bin NOT NULL,
19  `col_name` varchar(64) COLLATE utf8_bin NOT NULL,
20  `col_type` varchar(64) COLLATE utf8_bin NOT NULL,
21  `col_length` text COLLATE utf8_bin,
22  `col_collation` varchar(64) COLLATE utf8_bin NOT NULL,
23  `col_isNull` tinyint(1) NOT NULL,
24  `col_extra` varchar(255) COLLATE utf8_bin DEFAULT '',
25  `col_default` text COLLATE utf8_bin
26) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Central list of columns';
27
28TRUNCATE TABLE `pma__central_columns`;
29DROP TABLE IF EXISTS `pma__column_info`;
30CREATE TABLE `pma__column_info` (
31  `id` int(5) UNSIGNED NOT NULL,
32  `db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
33  `table_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
34  `column_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
35  `comment` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
36  `mimetype` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
37  `transformation` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
38  `transformation_options` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
39  `input_transformation` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
40  `input_transformation_options` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ''
41) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column information for phpMyAdmin';
42
43TRUNCATE TABLE `pma__column_info`;
44DROP TABLE IF EXISTS `pma__designer_settings`;
45CREATE TABLE `pma__designer_settings` (
46  `username` varchar(64) COLLATE utf8_bin NOT NULL,
47  `settings_data` text COLLATE utf8_bin NOT NULL
48) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Settings related to Designer';
49
50TRUNCATE TABLE `pma__designer_settings`;
51DROP TABLE IF EXISTS `pma__export_templates`;
52CREATE TABLE `pma__export_templates` (
53  `id` int(5) UNSIGNED NOT NULL,
54  `username` varchar(64) COLLATE utf8_bin NOT NULL,
55  `export_type` varchar(10) COLLATE utf8_bin NOT NULL,
56  `template_name` varchar(64) COLLATE utf8_bin NOT NULL,
57  `template_data` text COLLATE utf8_bin NOT NULL
58) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Saved export templates';
59
60TRUNCATE TABLE `pma__export_templates`;
61DROP TABLE IF EXISTS `pma__favorite`;
62CREATE TABLE `pma__favorite` (
63  `username` varchar(64) COLLATE utf8_bin NOT NULL,
64  `tables` text COLLATE utf8_bin NOT NULL
65) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Favorite tables';
66
67TRUNCATE TABLE `pma__favorite`;
68DROP TABLE IF EXISTS `pma__history`;
69CREATE TABLE `pma__history` (
70  `id` bigint(20) UNSIGNED NOT NULL,
71  `username` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
72  `db` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
73  `table` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
74  `timevalue` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
75  `sqlquery` text COLLATE utf8_bin NOT NULL
76) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='SQL history for phpMyAdmin';
77
78TRUNCATE TABLE `pma__history`;
79DROP TABLE IF EXISTS `pma__navigationhiding`;
80CREATE TABLE `pma__navigationhiding` (
81  `username` varchar(64) COLLATE utf8_bin NOT NULL,
82  `item_name` varchar(64) COLLATE utf8_bin NOT NULL,
83  `item_type` varchar(64) COLLATE utf8_bin NOT NULL,
84  `db_name` varchar(64) COLLATE utf8_bin NOT NULL,
85  `table_name` varchar(64) COLLATE utf8_bin NOT NULL
86) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Hidden items of navigation tree';
87
88TRUNCATE TABLE `pma__navigationhiding`;
89DROP TABLE IF EXISTS `pma__pdf_pages`;
90CREATE TABLE `pma__pdf_pages` (
91  `db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
92  `page_nr` int(10) UNSIGNED NOT NULL,
93  `page_descr` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT ''
94) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='PDF relation pages for phpMyAdmin';
95
96TRUNCATE TABLE `pma__pdf_pages`;
97DROP TABLE IF EXISTS `pma__recent`;
98CREATE TABLE `pma__recent` (
99  `username` varchar(64) COLLATE utf8_bin NOT NULL,
100  `tables` text COLLATE utf8_bin NOT NULL
101) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Recently accessed tables';
102
103TRUNCATE TABLE `pma__recent`;
104DROP TABLE IF EXISTS `pma__relation`;
105CREATE TABLE `pma__relation` (
106  `master_db` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
107  `master_table` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
108  `master_field` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
109  `foreign_db` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
110  `foreign_table` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
111  `foreign_field` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT ''
112) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Relation table';
113
114TRUNCATE TABLE `pma__relation`;
115DROP TABLE IF EXISTS `pma__savedsearches`;
116CREATE TABLE `pma__savedsearches` (
117  `id` int(5) UNSIGNED NOT NULL,
118  `username` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
119  `db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
120  `search_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
121  `search_data` text COLLATE utf8_bin NOT NULL
122) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Saved searches';
123
124TRUNCATE TABLE `pma__savedsearches`;
125DROP TABLE IF EXISTS `pma__table_coords`;
126CREATE TABLE `pma__table_coords` (
127  `db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
128  `table_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
129  `pdf_page_number` int(11) NOT NULL DEFAULT '0',
130  `x` float UNSIGNED NOT NULL DEFAULT '0',
131  `y` float UNSIGNED NOT NULL DEFAULT '0'
132) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table coordinates for phpMyAdmin PDF output';
133
134TRUNCATE TABLE `pma__table_coords`;
135DROP TABLE IF EXISTS `pma__table_info`;
136CREATE TABLE `pma__table_info` (
137  `db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
138  `table_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
139  `display_field` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT ''
140) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table information for phpMyAdmin';
141
142TRUNCATE TABLE `pma__table_info`;
143DROP TABLE IF EXISTS `pma__table_uiprefs`;
144CREATE TABLE `pma__table_uiprefs` (
145  `username` varchar(64) COLLATE utf8_bin NOT NULL,
146  `db_name` varchar(64) COLLATE utf8_bin NOT NULL,
147  `table_name` varchar(64) COLLATE utf8_bin NOT NULL,
148  `prefs` text COLLATE utf8_bin NOT NULL,
149  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
150) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Tables'' UI preferences';
151
152TRUNCATE TABLE `pma__table_uiprefs`;
153DROP TABLE IF EXISTS `pma__tracking`;
154CREATE TABLE `pma__tracking` (
155  `db_name` varchar(64) COLLATE utf8_bin NOT NULL,
156  `table_name` varchar(64) COLLATE utf8_bin NOT NULL,
157  `version` int(10) UNSIGNED NOT NULL,
158  `date_created` datetime NOT NULL,
159  `date_updated` datetime NOT NULL,
160  `schema_snapshot` text COLLATE utf8_bin NOT NULL,
161  `schema_sql` text COLLATE utf8_bin,
162  `data_sql` longtext COLLATE utf8_bin,
163  `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') COLLATE utf8_bin DEFAULT NULL,
164  `tracking_active` int(1) UNSIGNED NOT NULL DEFAULT '1'
165) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Database changes tracking for phpMyAdmin';
166
167TRUNCATE TABLE `pma__tracking`;
168DROP TABLE IF EXISTS `pma__userconfig`;
169CREATE TABLE `pma__userconfig` (
170  `username` varchar(64) COLLATE utf8_bin NOT NULL,
171  `timevalue` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
172  `config_data` text COLLATE utf8_bin NOT NULL
173) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User preferences storage for phpMyAdmin';
174
175TRUNCATE TABLE `pma__userconfig`;
176INSERT INTO `pma__userconfig` (`username`, `timevalue`, `config_data`) VALUES
177('root', '2017-01-25 22:47:34', '{\"PmaNoRelation_DisableWarning\":true,\"SuhosinDisableWarning\":true,\"LoginCookieValidityDisableWarning\":true,\"ServerLibraryDifference_DisableWarning\":true,\"ReservedWordDisableWarning\":true,\"VersionCheck\":false,\"LoginCookieValidity\":86400,\"ShowDbStructureCharset\":true,\"ShowDbStructureComment\":true,\"ShowDbStructureCreation\":true,\"ShowDbStructureLastUpdate\":true,\"ShowDbStructureLastCheck\":true,\"ShowAll\":true,\"MaxRows\":100,\"MinSizeForInputField\":10,\"MaxSizeForInputField\":120,\"TextareaCols\":60,\"TextareaRows\":20,\"CharTextareaCols\":60,\"CharTextareaRows\":4,\"TitleTable\":\"@DATABASE@ \\/ @TABLE@ | @PHPMYADMIN@\",\"TitleDatabase\":\"@DATABASE@ | @PHPMYADMIN@\",\"TitleServer\":\"@PHPMYADMIN@\",\"TitleDefault\":\"@PHPMYADMIN@\",\"NavigationDisplayLogo\":false,\"Server\\/hide_db\":\"information_schema|mysql|performance_schema|phpmyadmin|sys\",\"Server\\/only_db\":\"\",\"collation_connection\":\"utf8mb4_unicode_ci\"}');
178
179DROP TABLE IF EXISTS `pma__usergroups`;
180CREATE TABLE `pma__usergroups` (
181  `usergroup` varchar(64) COLLATE utf8_bin NOT NULL,
182  `tab` varchar(64) COLLATE utf8_bin NOT NULL,
183  `allowed` enum('Y','N') COLLATE utf8_bin NOT NULL DEFAULT 'N'
184) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User groups with configured menu items';
185
186TRUNCATE TABLE `pma__usergroups`;
187DROP TABLE IF EXISTS `pma__users`;
188CREATE TABLE `pma__users` (
189  `username` varchar(64) COLLATE utf8_bin NOT NULL,
190  `usergroup` varchar(64) COLLATE utf8_bin NOT NULL
191) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and their assignments to user groups';
192
193TRUNCATE TABLE `pma__users`;
194
195ALTER TABLE `pma__bookmark`
196  ADD PRIMARY KEY (`id`);
197
198ALTER TABLE `pma__central_columns`
199  ADD PRIMARY KEY (`db_name`,`col_name`);
200
201ALTER TABLE `pma__column_info`
202  ADD PRIMARY KEY (`id`),
203  ADD UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`);
204
205ALTER TABLE `pma__designer_settings`
206  ADD PRIMARY KEY (`username`);
207
208ALTER TABLE `pma__export_templates`
209  ADD PRIMARY KEY (`id`),
210  ADD UNIQUE KEY `u_user_type_template` (`username`,`export_type`,`template_name`);
211
212ALTER TABLE `pma__favorite`
213  ADD PRIMARY KEY (`username`);
214
215ALTER TABLE `pma__history`
216  ADD PRIMARY KEY (`id`),
217  ADD KEY `username` (`username`,`db`,`table`,`timevalue`);
218
219ALTER TABLE `pma__navigationhiding`
220  ADD PRIMARY KEY (`username`,`item_name`,`item_type`,`db_name`,`table_name`);
221
222ALTER TABLE `pma__pdf_pages`
223  ADD PRIMARY KEY (`page_nr`),
224  ADD KEY `db_name` (`db_name`);
225
226ALTER TABLE `pma__recent`
227  ADD PRIMARY KEY (`username`);
228
229ALTER TABLE `pma__relation`
230  ADD PRIMARY KEY (`master_db`,`master_table`,`master_field`),
231  ADD KEY `foreign_field` (`foreign_db`,`foreign_table`);
232
233ALTER TABLE `pma__savedsearches`
234  ADD PRIMARY KEY (`id`),
235  ADD UNIQUE KEY `u_savedsearches_username_dbname` (`username`,`db_name`,`search_name`);
236
237ALTER TABLE `pma__table_coords`
238  ADD PRIMARY KEY (`db_name`,`table_name`,`pdf_page_number`);
239
240ALTER TABLE `pma__table_info`
241  ADD PRIMARY KEY (`db_name`,`table_name`);
242
243ALTER TABLE `pma__table_uiprefs`
244  ADD PRIMARY KEY (`username`,`db_name`,`table_name`);
245
246ALTER TABLE `pma__tracking`
247  ADD PRIMARY KEY (`db_name`,`table_name`,`version`);
248
249ALTER TABLE `pma__userconfig`
250  ADD PRIMARY KEY (`username`);
251
252ALTER TABLE `pma__usergroups`
253  ADD PRIMARY KEY (`usergroup`,`tab`,`allowed`);
254
255ALTER TABLE `pma__users`
256  ADD PRIMARY KEY (`username`,`usergroup`);
257
258
259ALTER TABLE `pma__bookmark`
260  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
261ALTER TABLE `pma__column_info`
262  MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT;
263ALTER TABLE `pma__export_templates`
264  MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT;
265ALTER TABLE `pma__history`
266  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
267ALTER TABLE `pma__pdf_pages`
268  MODIFY `page_nr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
269ALTER TABLE `pma__savedsearches`
270  MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT;