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/create_tables.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/create_tables.sql')
-rw-r--r-- | sql/create_tables.sql | 2 |
1 files changed, 1 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 '', |