intag article schema

schema

DROP TABLE IF EXISTS `articles`;

CREATE TABLE `articles` (
    `alias` VARCHAR(64) NOT NULL,
    `author` TEXT NOT NULL,
    `title` TEXT NOT NULL,
    `intro` TEXT NOT NULL,
    `body` TEXT NOT NULL,
    `date` DATE NOT NULL,
    PRIMARY KEY (`alias`)
);

DROP TABLE IF EXISTS `pdfs`;

CREATE TABLE `pdfs` (
    `issue_number` int NOT NULL,
    `headline` TEXT NOT NULL,
    `date` DATE NOT NULL,
    `filename` VARCHAR(64) NOT NULL,
    `thumbnail` VARCHAR(64) NOT NULL,
    PRIMARY KEY (`issue_number`)
);