SQLize | PHPize | SQLtest

CREATE TABLE users ( id int8 NOT NULL UNIQUE GENERATED ALWAYS AS IDENTITY, -- TODO: is it really required? (START WITH -9223372036854775808) email text NOT NULL UNIQUE, password text NOT NULL, admin bool NOT NULL DEFAULT false, created timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP, updated timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP, name text NOT NULL, PRIMARY KEY(id) ); CREATE TABLE pets ( id INTEGER PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, name VARCHAR(30) NOT NULL, pet_type VARCHAR(15) NOT NULL, breed VARCHAR(30) NOT NULL, user_id int8 NOT NULL REFERENCES users(id), weight SMALLINT NOT NULL, height SMALLINT NOT NULL, length SMALLINT NOT NULL, gender BOOLEAN NOT NULL, birth_date DATE NOT NULL );