diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/create_tables.sql | 2 | ||||
| -rw-r--r-- | sql/upgrade_column_info_4_6_5+.sql | 24 |
2 files changed, 25 insertions, 1 deletions
diff --git a/sql/create_tables.sql b/sql/create_tables.sql index f906115fbe..e2fe779e10 100644 --- a/sql/create_tables.sql +++ b/sql/create_tables.sql @@ -37,7 +37,7 @@ USE phpmyadmin; -- CREATE TABLE IF NOT EXISTS `pma__bookmark` ( - `id` int(11) NOT NULL auto_increment, + `id` int(10) unsigned NOT NULL auto_increment, `dbase` varchar(255) NOT NULL default '', `user` varchar(255) NOT NULL default '', `label` varchar(255) COLLATE utf8_general_ci NOT NULL default '', diff --git a/sql/upgrade_column_info_4_6_5+.sql b/sql/upgrade_column_info_4_6_5+.sql new file mode 100644 index 0000000000..12705a25d4 --- /dev/null +++ b/sql/upgrade_column_info_4_6_5+.sql @@ -0,0 +1,24 @@ +-- ------------------------------------------------------------- +-- SQL Commands to upgrade pmadb.pma__column_info table +-- for normal phpMyAdmin operation +-- +-- This file is meant for use with phpMyAdmin 4.6.5 and above! +-- For older releases, please use create_tables.sql +-- +-- Please don't forget to set up the table names in config.inc.php +-- + +-- -------------------------------------------------------- + +-- +-- Database : `phpmyadmin` +-- +USE `phpmyadmin`; + +-- -------------------------------------------------------- + +-- +-- Update table structure for table `pma__bookmark` +-- +ALTER TABLE `pma__bookmark` + CHANGE `id` `id` int( 10 ) unsigned NOT NULL auto_increment; |