CREATE TABLE authors(
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(30),
    surname VARCHAR(50),
    password VARCHAR(30),
    street VARCHAR(150),
    city VARCHAR(150),
    email VARCHAR(150),
    author_type VARCHAR(10),
    date_registered DATETIME
)


CREATE TABLE advertisments(
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(150) NOT NULL,
    content TEXT,
    active INT,
    FOREIGN KEY (author_id) REFERENCES authors(id),
    FOREIGN KEY (category_id) REFERENCES categories(id),
    date_posted DATETIME NOT NULL
)


CREATE TABLE categories (
    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR (100) NOT NULL,
    information TEXT NOT NULL
    )

CREATE TABLE tags (
    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL
    )

CREATE TABLE advertisments_tags (
    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    FOREIGN KEY (advertisment_id) REFERENCES advertisments(id),
    FOREIGN KEY (tag_id) REFERENCES tags(id)
)