CREATE DATABASE IF NOT EXISTS password_change_practice
CHARACTER SET utf8mb4
COLLATE utf8mb4_unicode_ci;

USE password_change_practice;

CREATE TABLE admins (
    id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    password VARCHAR(255) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
        ON UPDATE CURRENT_TIMESTAMP
);

INSERT INTO admins (password)
VALUES (
    '$2y$10$Xl2RQzD2M6Jq1nL6dQ6N7e0KXvXWnM4v5Zl5XQFQv2N7N0QmNQ6mS'
);