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 /sql/upgrade_column_info_4_6_5+.sql | |
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.
Diffstat (limited to 'sql/upgrade_column_info_4_6_5+.sql')
-rw-r--r-- | sql/upgrade_column_info_4_6_5+.sql | 24 |
1 files changed, 24 insertions, 0 deletions
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; |