From 7a766402794d43e8a8e2220939f24a3b1f7e690f Mon Sep 17 00:00:00 2001 From: Daniel Popiniuc Date: Wed, 9 Nov 2016 15:26:38 +0200 Subject: Bookmark id that is an auto_increment column can only take positive values starting from 1, therefore should be unsigned otherwise half of allowed interval is wasted from start, and this is the fix for that. --- sql/create_tables.sql | 2 +- sql/upgrade_column_info_4_6_5+.sql | 24 ++++++++++++++++++++++++ 2 files changed, 25 insertions(+), 1 deletion(-) create mode 100644 sql/upgrade_column_info_4_6_5+.sql 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; -- cgit v1.2.3