DROP DATABASE Blog;
CREATE DATABASE Blog;
USE Blog;

CREATE TABLE Blogs (
        ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
        Title TEXT NOT NULL,
        Text TEXT NOT NULL,
        Date DATETIME NOT NULL,
        Shown BOOLEAN NOT NULL,
        Keywords TEXT NOT NULL
);

CREATE TABLE Comments (
        ID INT NOT NULL PRIMARY KEY,
        BlogID TEXT NOT NULL,
        Date DATETIME NOT NULL,
        DisplayName TEXT NOT NULL,
        Email TEXT NOT NULL,
        Text TEXT NOT NULL
);