CREATE TABLE users (
 id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
 username VARCHAR(50) NOT NULL UNIQUE,
 email VARCHAR(255) NOT NULL UNIQUE,
 password_hash VARCHAR(255) NOT NULL,
 is_active TINYINT(1) NOT NULL DEFAULT 1,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
 role VARCHAR(50) NOT NULL DEFAULT 'user',
 comment VARCHAR(255) NULL,
 reset_token_hash VARCHAR(64) NULL,
 reset_expires_at DATETIME NULL,
 is_admin TINYINT(1) NOT NULL DEFAULT 0
);

INSERT INTO users
(username,email,password_hash,is_active,role,is_admin)
VALUES
(
 'admin',
 'admin@example.com',
 '$2y$12$4z.a1Iw6CA3MP3VT8ghyrOuCnvNmFX.Bqa7vH07SaDZJHGgUs6rf6',
 1,
 'admin',
 1
);