SQLite format 3@ JNq Aindexindex_topics_on_partner_idtopics CREATE INDEX "index_topics_on_partner_id" ON "topics" ("partner_id")i -tabletopicstopics CREATE TABLE "topics" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255) NOT NULL, "description" text NOT NULL, "partner_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime)CYtablepartnerspartners CREATE TABLE "partners" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "subdomain" varchar(255), "created_at" datetime, "updated_at" datetime)]tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(128) DEFAULT '' NOT NULL, "login" varchar(255) NOT NULL, "first_name" varchar(255) NOT NULL, "last_name" varchar(255) NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255), "created_at" datetime, "updated_at" datetime, "role" varchar(255) DEFAULT 'user')SGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e5 indexindex_users_on_loginusersCREATE UNIQUE INDEX "index_users_on_login" ON "users" ("login")e5 indexindex_users_on_emailusersCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT  )20110926223739)20110901013344)20110828002919)20110827230636)20110825183001)20110825174735)20110812014820 {{)20110926223739)20110901013344)20110828002919)20110827230636)20110825183001)20110825174735)20110812014820          ;GNq Aindexindex_topics_on_partner_idtopics CREATE INDEX "index_topics_on_partner_id" ON "topics" ("partner_id")i -tabletopicstopics CREATE TABLE "topics" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255) NOT NULL, "description" text NOT NULL, "partner_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime)CYtablepartnerspartners CREATE TABLE "partners" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "subdomain" varchar(255), "created_at" datetime, "updated_at" datetime)]tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(128) DEFAULT '' NOT NULL, "login" varchar(255) NOT NULL, "first_name" varchar(255) Nq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")]tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(128) DEFAULT '' NOT NULL, "login" varchar(255) NOT NULL, "first_name" varchar(255) NOT NULL, "last_name" varchar(255) NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255), "created_at" datetime, "updated_at" datetime, "role" varchar(255) DEFAULT 'user')P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)e5 indexindex_users_on_emailusersCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")  /v.Vtablepartnerspartners CREATE TABLE "partners" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "subdomain" varchar(255), "created_at" datetime, "updated_at" datetime, "intro_text" text)g; indexindex_ideas_on_topic_idideasCREATE INDEX "index_ideas_on_topic_id" ON "ideas" ("topic_id")E itableideasideasCREATE TABLE "ideas" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "topic_id" integer NOT NULL, "description" text NOT NULL, "created_at" datetime, "updated_at" datetime)O s3indexindex_partner_memberships_on_user_id_and_partner_idpartner_membershipsCREATE UNIQUE INDEX "index_partner_memberships_on_user_id_and_partner_id" ON "partner_memberships" ("user_id", "partner_id")e5 indexindex_users_on_loginusersCREATE UNIQUE INDEX "index_users_on_login" ON "users" ("login")SGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")Ytablepartnerspartners CREATE TABLE "partners" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "subdomain" varchar(255), "created_at" datetime, "updated_at" datetime)i -tabletopicstopics CREATE TABLE "topics" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255) NOT NULL, "description" text NOT NULL, "partner_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime)q Aindexindex_topics_on_partner_idtopics CREATE INDEX "index_topics_on_partner_id" ON "topics" ("partner_id") 33Otablepartner_membershipspartner_memberships CREATE TABLE "partner_memberships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "partner_id" integer NOT NULL, "role" varchar(255) DEFAULT 'user', "created_at" datetime, "updated_at" datetime)