TBPPQzvs

1MariaDB [drone]> CREATE TABLE IF NOT EXISTS users (
2    ->  user_id            INTEGER PRIMARY KEY AUTO_INCREMENT
3    -> ,user_login         VARCHAR(250)
4    -> ,user_email         VARCHAR(500)
5    -> ,user_admin         BOOLEAN
6    -> ,user_machine       BOOLEAN
7    -> ,user_active        BOOLEAN
8    -> ,user_avatar        VARCHAR(2000)
9    -> ,user_syncing       BOOLEAN
10    -> ,user_synced        INTEGER
11    -> ,user_created       INTEGER
12    -> ,user_updated       INTEGER
13    -> ,user_last_login    INTEGER
14    -> ,user_oauth_token   VARCHAR(500)
15    -> ,user_oauth_refresh VARCHAR(500)
16    -> ,user_oauth_expiry  INTEGER
17    -> ,user_hash          VARCHAR(500)
18    -> ,UNIQUE(user_login)
19    -> ,UNIQUE(user_hash)
20    -> );
21ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes