diff options
author | Daniel Popiniuc <danielpopiniuc@gmail.com> | 2016-11-09 16:26:38 +0300 |
---|---|---|
committer | Daniel Popiniuc <danielpopiniuc@gmail.com> | 2016-11-09 16:26:38 +0300 |
commit | 7a766402794d43e8a8e2220939f24a3b1f7e690f (patch) | |
tree | bfa59cff4bb58398d7b2e53a4996f894d0e7d0ab | |
parent | d7a74c2684aef83ec4e8c9f56d32b0471a9b772b (diff) |
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.
-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; |