Task #104259
Updated by Stefan Bürk 5 months ago
<pre>
SQLITE INTEGER SIGNED -9223372036854775808 <=> +9223372036854775807 (INTEGER SCALES SINCE v3, AUTOINCREMENT PK ONLY WIHT INTEGER TYPE) PK/AUTOINCREMENT POSSIBLE
SQLITE INTEGER SIGNED 0 <=> 18446744073709551615 (INTEGER SCALES SINCE v3, AUTOINCREMENT PK ONLY WIHT INTEGER TYPE) PK/AUTOINCREMENT POSSIBLE
SQLITE BIGINT UNSIGNED -9223372036854775808 <=> +9223372036854775807 (INTEGER SCALES SINCE v3, AUTOINCREMENT PK ONLY WIHT INTEGER TYPE) PK/AUTOINCREMENT POSSIBLE
SQLITE BIGINT UNSIGNED 0 <=> 18446744073709551615 (INTEGER SCALES SINCE v3, AUTOINCREMENT PK ONLY WIHT INTEGER TYPE) PK/AUTOINCREMENT POSSIBLE
POSTGRESQL INTEGER -2147483648 <=> +2147483647 (no unsigned integer, only signed) PK/AUTOINCREMENT POSSIBLE
POSTGRESQL BIGINT -9223372036854775808 <=> +9223372036854775807 (no unsigned integer, only signed) PK/AUTOINCREMENT POSSIBLE
MARIADB INTEGER SIGNED -2147483648 <=> 2147483647
MARIADB INTEGER UNSIGNED 0 <=> 4294967295
MARIADB BIGINT SIGNED -9223372036854775808 <=> 9223372036854775807 PK/AUTOINCREMENT POSSIBLE ?
MARIADB BIGINT UNSIGNED 0 <=> 18446744073709551615 PK/AUTOINCREMENT POSSIBLE ?
MYSQL INTEGER SIGNED -2147483648 <=> 2147483647
MYSQL INTEGER UNSIGNED 0 <=> 4294967295
MYSQL BIGINT SIGNED -2^63 <=> 2^63 - 1 PK/AUTOINCREMENT POSSIBLE ?
MYSQL BIGINT UNSIGNED 0 <=> 2^64 - 1 PK/AUTOINCREMENT POSSIBLE ?
</pre>