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")