SQLize | PHPize | SQLtest

CREATE TABLE users ( id SERIAL PRIMARY KEY, username VARCHAR(50) NOT NULL, email VARCHAR(255) NOT NULL UNIQUE, password_hash VARCHAR(255) NOT NULL, is_active BOOLEAN DEFAULT TRUE, created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP, CONSTRAINT valid_email CHECK ( email ~* '^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}$' ), CONSTRAINT valid_username CHECK ( LENGTH(username) >= 3 ), CONSTRAINT valid_password CHECK ( LENGTH(password_hash) >= 8 ) ); CREATE OR REPLACE FUNCTION update_modified_column() RETURNS TRIGGER AS $$ BEGIN NEW.updated_at = CURRENT_TIMESTAMP; RETURN NEW; END; $$ LANGUAGE plpgsql; CREATE TRIGGER update_users_updated_at BEFORE UPDATE ON users FOR EACH ROW EXECUTE FUNCTION update_modified_column(); INSERT INTO users (username, email, password_hash) VALUES ('alex_ivanov', 'alex@example.com', 'secure12345'); INSERT INTO users (username, email, password_hash, is_active) VALUES ('maria_petrova', 'maria@test.org', 'qwerty123', FALSE); SELECT * FROM users;