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.

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;