gistfile1.txt

root@localhost[(none)]> create database strict_test;
Query OK, 1 row affected (0.00 sec)

root@localhost[(none)]> use strict_test;
Database changed
root@localhost[strict_test]> SET NAMES utf8mb4;
Query OK, 0 rows affected (0.00 sec)

root@localhost[strict_test]> SET @@SESSION.sql_mode = 'TRADITIONAL,NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY';
Query OK, 0 rows affected (0.00 sec)

root@localhost[strict_test]> create table users ( `id` bigint unsigned not null, `is_private` tinyint(1) default '1', primary key (`id`)) engine=InnoDB, default charset=utf8;
Query OK, 0 rows affected (0.01 sec)

root@localhost[strict_test]> insert into users set id = uuid_short();
Query OK, 1 row affected (0.00 sec)