Title:           fimfic tables 1
Author:          waterapple
Pastebin link:   http://pastebin.com/xHpbcKS4
First Edit:      Sunday 15th of February 2015 08:04:03 AM CDT
Last Edit:       Sunday 15th of February 2015 08:04:03 AM CDT

TABLES = {}
TABLES['api_metadata'] = (
    "CREATE TABLE `api_metadata` ("
    "  `primary_key` int(11) NOT NULL AUTO_INCREMENT,"
    "  `status` text NOT NULL,"
    "  `total_views` int NOT NULL,"
    "  `full_image` text NOT NULL,"
    "  `description` text NOT NULL,"
    "  `views` int NOT NULL,"
    "  `date_modified` int NOT NULL,"
    "  `url` text NOT NULL,"
    "  `image` text NOT NULL,"
    "  `title` text NOT NULL,"
    "  `dislikes` int NOT NULL,"
    "  `comments` int NOT NULL,"
    "  `content_rating` int NOT NULL,"
    "  `chapter_count` int NOT NULL,"
    # chapters [??]
    # author {???}
    "  `words` int NOT NULL,"
    "  `content_rating_text` text NOT NULL,"
    "  `short_description` text NOT NULL,"
    "  `id` int NOT NULL,"
    # categories {??}
    "  `likes` int NOT NULL,"
    "  PRIMARY KEY (`primary_key`)"
    ") ENGINE=InnoDB")