-- Create database called 'Oxygen' --

CREATE DATABASE IF NOT EXISTS `oxygen` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE oxygen;


-- Create new table for users --

CREATE TABLE `users` (

    `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT 'ID ',

    `username` varchar(255) DEFAULT NULL,

    `role` enum('admin','user') NOT NULL DEFAULT 'user',

    `password` varchar(255) NOT NULL,

    `created_at` timestamp NULL DEFAULT NULL,

    `updated_at` timestamp NULL DEFAULT NULL

) COMMENT='Users table';


-- Insert new user: admin, password: admin ---
INSERT INTO `users` (`id`, `username`, `role`, `email`, `password`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'admin', 'admin@example.com', '$2y$10$wakNCVErdbYpXDdeNC/eDeSUMgcKLg1/48ZAFgYcwJeXF859O4yHi', NULL, NULL);