CREATE DATABASE aldirBlanc;
USE aldirBlanc;

CREATE TABLE posts(
    id int PRIMARY KEY AUTO_INCREMENT NOT NULL,
    title varchar(255) NOT NULL,
    author varchar(255) NOT NULL,
    videoID varchar(255),
    category varchar(255),
    date varchar(10) NOT NULL,
    content text NOT NULL,
    isActive TINYINT NOT NULL DEFAULT 1
);