CREATE DATABASE course_management;

USE course_management;

CREATE TABLE courses (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    description TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);


CREATE USER 'course'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Cm@100670';
GRANT ALL PRIVILEGES ON course__management.* TO 'course'@'localhost';
FLUSH PRIVILEGES;
