SQLite format 3@     posts blogsX     llC[ktableadsadsCREATE TABLE "ads" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "blog_id" integer, "content" varchar(255))P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)--tablearticlesarticlesCREATE TABLE "articles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "contents" varchar(255), "created_at" datetime, "updated_at" datetime)%%tableassetsassetsCREATE TABLE "assets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime, "format" varchar(255))=//)tableasset_attachmentsasset_attachmentsCREATE TABLE "asset_attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_id" integer, "to_type" varchar(255), "from_id" integer)"tableauthorsauthorsCREATE TABLE "authors" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_id" integer, "nickname" varchar(255), "user_id" integer) ssI332009-11-10 16:24:512009-11-10 16:24:51332009-11-10 16:24:512009-11-10 16:24:51332009-11-10 16:24:512009-11-10 16:24:51332009-11-10 16:24:502009-11-10 16:24-X332009-11-10 16:24:512009-11-10 16:24:51-W332009-11-10 16:24:512009-11-10 16:24:51-V332009-11-10 16:24:512009-11-10 16:24:51 MKutableblogsblogs CREATE TABLE "blogs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "published" boolean, "special_id" integer, "created_at" datetime, "updated_at" datetime)h#tablecommentscomments CREATE TABLE "comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_id" integer, "user_id" integer, "contents" varchar(255), "offensive" boolean, "created_at" datetime, "updated_at" datetime)F _tablefeaturesfeatures CREATE TABLE "features" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "blog_id" integer, "featurable_id" integer, "featurable_type" varchar(255), "priority" integer)0 %%#tablenews_storiesnews_stories CREATE TABLE "news_stories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "blog_id" integer, "permalink" varchar(255), "contents" text)     jL. 32009-11-10 16:24:51 32009-11-10 16:24:51 32009-11-10 16:24:14 32009-11-10 16:24:14 32009-11-10 16:23:52 32009-11-10 16:23:52 32009-11-10 16:22:24 32009-11-10 16:22:24 DDJ tablephotosphotosCREATE TABLE "photos" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_id" integer, "path" varchar(255), "format" varchar(255)) ]tablepostspostsCREATE TABLE "posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "blog_id" integer, "special_blog_id" integer, "permalink" varchar(255), "created_at" datetime, "published" boolean, "content" varchar(255), "title" varchar(255))` !! tableposts_tagsposts_tagsCREATE TABLE "posts_tags" ("post_id" integer, "tag_id" integer)3=tablereviewsreviewsCREATE TABLE "reviews" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "reviewable_id" integer, "reviewable_type" varchar(255), "stars_count" integer)        M9''1tablesubscriptionssubscriptionsCREATE TABLE "subscriptions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255), "created_at" datetime, "updated_at" datetime)oAtabletagstagsCREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255))0?tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar(255), "last_name" varchar(255), "email_address" varchar(255))