Title:           fimfic tables 3
Author:          waterapple
Pastebin link:   http://pastebin.com/7kVSmvYW
First Edit:      Sunday 15th of February 2015 11:39:46 PM CDT
Last Edit:       Sunday 15th of February 2015 11:39:46 PM CDT

TABLES = {}
TABLES['story_metadata'] = (
    "CREATE TABLE `story_metadata` ("
    # Local stuff
    "  `primary_key` int NOT NULL AUTO_INCREMENT,"
    "  `version` int NOT NULL,"
    # From site
    "  `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 {name (string),id (int)}
    "  `author_name` text NOT NULL,"
    "  `author_id` int NOT NULL,"
    "  `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")
 
 
 
TABLES['chapter_metadata'] = (
    "CREATE TABLE `chapter_metadata` ("
    # Local stuff
    "  `primary_key` int NOT NULL AUTO_INCREMENT,"
    "  `version` int NOT NULL,"
    "  `parent_story_id` int NOT NULL,"
    "  `chapter_number` int NOT NULL,"
    # From site
    "  `id` int NOT NULL,"
    "  `link` text NOT NULL,"
    "  `title` text NOT NULL,"
    "  `views` int NOT NULL,"
    "  `words` int NOT NULL,"
    "  PRIMARY KEY (`primary_key`)"
    ") ENGINE=InnoDB")
 
 
 
TABLES['chapter_texts'] = (
    "CREATE TABLE `chapter_texts` ("
    # Local stuff
    "  `primary_key` int NOT NULL AUTO_INCREMENT,"
    "  `version` int NOT NULL,"
    "  `parent_chapter_id` int NOT NULL,"
    "  `parent_story_id` int NOT NULL,"
    "  `parent_chapter_id` int NOT NULL,"
    "  `chapter_number` int NOT NULL,"
    # From site
    "  `chapter_text` text NOT NULL,"
    "  PRIMARY KEY (`primary_key`)"
    ") ENGINE=InnoDB")
 
 
 
TABLES['full_texts'] = (
    "CREATE TABLE `full_texts` ("
    # Local stuff
    "  `primary_key` int NOT NULL AUTO_INCREMENT,"
    "  `version` int NOT NULL,"
    "  `parent_story_id` int NOT NULL,"
    # From site
    "  `full_story_text` text NOT NULL,"
    "  PRIMARY KEY (`primary_key`)"
    ") ENGINE=InnoDB")
 
 
TABLES['story_categories'] = (
    "CREATE TABLE `chapter_texts` ("
    # Local stuff
    "  `primary_key` int NOT NULL AUTO_INCREMENT,"
    "  `version` int NOT NULL,"
    "  `parent_story_id` int NOT NULL,"
    # From site
    "  `Dark` bool,"
    "  `Slice of Life` bool,"
    "  `Anthro` bool,"
    "  `Random` bool,"
    "  `Alternate Universe` bool,"
    "  `Sad` bool,"
    "  `Romance` bool,"
    "  `Crossover` bool,"
    "  `Adventure` bool,"
    "  `Human` bool,"
    "  `Comedy` bool,"
    "  `Tragedy` bool,"
    "  PRIMARY KEY (`primary_key`)"
    ") ENGINE=InnoDB")