SQLite format 3@  -   : e } f> h##tableuser_groupsuser_groupsCREATE TABLE "user_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)SGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")]5}indexindex_users_on_emailusersCREATE INDEX "index_users_on_email" ON "users" ("email")PtableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_group_id" integer, "required_role_id" integer, "username" varchar(255), "note" text, "created_at" datetime, "updated_at" datetime, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(128) DEFAULT '' 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))V  tablerolesrolesCREATE TABLE "roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)L gtablelanguageslanguages CREATE TABLE "languages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "native_name" varchar(255), "display_name" text, "iso_639_1" varchar(255), "iso_639_2" varchar(255), "iso_639_3" varchar(255), "note" text, "position" integer, "created_at" datetime, "updated_at" datetime) O-1indexindex_answer_has_items_on_item_idanswer_has_items CREATE INDEX "index_answer_has_items_on_item_id" ON "answer_has_items" ("item_id") S-9indexindex_answer_has_items_on_answer_idanswer_has_items CREATE INDEX "index_answer_has_items_on_answer_id" ON "answer_has_items" ("answer_id")h --tableanswer_has_itemsanswer_has_items CREATE TABLE "answer_has_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "answer_id" integer, "item_id" integer, "position" integer, "created_at" datetime, "updated_at" datetime)xEindexindex_answers_on_question_idanswers CREATE INDEX "index_answers_on_question_id" ON "answers" ("question_id")l= indexindex_answers_on_user_idanswersCREATE INDEX "index_answers_on_user_id" ON "answers" ("user_id")\tableanswersanswersCREATE TABLE "answers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "question_id" integer NOT NULL, "body" text, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, "shared" boolean DEFAULT 't' NOT NULL, "state" varchar(255), "item_identifier_list" text, "url_list" text)tAindexindex_questions_on_user_idquestionsCREATE INDEX "index_questions_on_user_id" ON "questions" ("user_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)t7tablequestionsquestionsCREATE TABLE "questions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "body" text, "shared" boolean DEFAULT 't' NOT NULL, "answers_count" integer DEFAULT 0 NOT NULL, "deleted_at" datetime, "state" varchar(255), "solved" boolean DEFAULT 'f' NOT NULL, "note" text, "created_at" datetime, "updated_at" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) )20111201163342)20111201155513)20111201155456)20111201121844)20111201121636)201002170540289998 )20111201163342)20111201155513)20111201155456)20111201121844)20111201121636)201002170540289998