GasCU6N5

1-- Create database called 'Oxygen' --
2CREATE DATABASE IF NOT EXISTS `oxygen` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
3USE oxygen;
4
5
6-- Create new table for users --
7CREATE TABLE `users` (
8
9    `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT 'ID ',
10
11    `username` varchar(255) DEFAULT NULL,
12
13    `role` enum('admin','user') NOT NULL DEFAULT 'user',
14
15    `password` varchar(255) NOT NULL,
16
17    `created_at` timestamp NULL DEFAULT NULL,
18
19    `updated_at` timestamp NULL DEFAULT NULL
20
21) COMMENT='Users table';
22
23
24-- Insert new user: admin, password: admin ---
25INSERT INTO `users` (`id`, `username`, `role`, `password`, `created_at`, `updated_at`) VALUES
26(1, 'admin', 'admin', '$2y$10$wakNCVErdbYpXDdeNC/eDeSUMgcKLg1/48ZAFgYcwJeXF859O4yHi', NULL, NULL);