Suggestions about "Creating/altering table" and "Altering indexes"
Database management in a single PHP file
Brought to you by:
jakubvrana
Menu
▾
▴
#643 Suggestions about "Creating/altering table" and "Altering indexes"
If this section is only meant to be used as Bug Reports, I apologise.
Apache: 2.4.35
MySQL: 8.0.13
PHP: 7.2.11
Adminer: 4.6.3 for MySQL (English only).
The first suggestion is about Integer types. When we create a new table or alter an existed table and select "Type" column so we can choose the appropriate datatype for a column, it would be very useful if when highlighting a certain integer such as TINYINT to show the min/max and sign/unsigned values such as "-128 to 127 for unsigned" and "0 to 255 for signed".
The second suggestion is about creating indexes in descending order through "Alter indexes" page rather than executing a query ourselves to do it.
Adminer links the documentation, https://dev.mysql.com/doc/refman/8.0/en/numeric-type-overview.html in this case. This is good enough.
https://github.com/vrana/adminer/commit/5bebb439 adds support for descending indexes in MySQL 8.