RVFLM8mx

1CREATE EXTENSION IF NOT EXISTS citext;
2
3CREATE TABLE IF NOT EXISTS users
4(
5    id       serial PRIMARY KEY,
6    nickname citext UNIQUE NOT NULL,
7    fullname text          NOT NULL,
8    about    text          NOT NULL,
9    email    citext UNIQUE NOT NULL,
10
11    CONSTRAINT right_nickname CHECK ( nickname ~* '[0-9a-z_]')
12);