SQLite format 3@  55Wtablecitygate_permissionscitygate_permissionsCREATE TABLE "citygate_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "action" varchar(255) NOT NULL, "subject_class" varchar(255) NOT NULL, "subject_id" varchar(255), "role_id" integer, "conditions" varchar(255))P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq);;tablecitygate_authorizationscitygate_authorizationsCREATE TABLE "citygate_authorizations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "provider" varchar(255), "uid" varchar(255), "user_id" integer, "token" varchar(255), "secret" varchar(255), "name" varchar(255), "link" varchar(255), "image_url" varchar(255), "created_at" datetime NOT NULL, "updated_at   5citygate_permissions)citygate_roles manageall)readCitygate::Userindexhome    ]c;;tablecitygate_authorizationscitygate_authorizationsCREATE TABLE "citygate_authorizations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "provider" v;;tablecitygate_authorizationscitygate_authorizationsCREATE TABLE "citygate_authorizations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "provider" varchar(255), "uid" varchar(255), "user_id" integer, "token" varchar(255), "secret" varchar(255), "name" varchar(255), "link" varchar(255), "image_url" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)55Wtablecitygate_permissionscitygate_permissionsCREATE TABLE "citygate_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "action" varchar(255) NOT NULL, "subject_class" varchar(255) NOT NULL, "subject_id" varchar(255), "role_id" integer, "conditions" varchar(255)) >AAAdmin2012-09-16 22:42:01.1987832012-09-16 22:42:01.198783?AAMember2012-09-16 22:42:01.1672752012-09-16 22:42:01.167275 0 W5Aindexindex_citygate_permissions_on_role_idcitygate_permissionsCREATE INDEX "index_citygate_permissions_on_role_id" ON "citygate_permissions" ("role_id")M))Utablecitygate_rolescitygate_rolesCREATE TABLE "citygate_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  HH5))%tablecitygate_userscitygate_users CREATE TABLE "citygate_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) DEFAULT '', "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 NOT NULL, "updated_at" datetime NOT NULL, "first_name" varchar(255), "last_name" varchar(255), "confirmation_token" varchar(255), "confirmed_at" datetime, "confirmation_sent_at" datetime, "unconfirmed_email" varchar(255), "invitation_token" varchar(60), "invitation_sent_at" datetime, "invitation_accepted_at" datetime, "invitation_limit" integer, "invited_by_id" integer, "invited_by_type" varchar(255), "password_salt" varchar(255), "role_id" integer)  ~~1cRq //tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)6 e)kindexindex_citygate_users_on_reset_password_tokencitygate_usersCREATE UNIQUE INDEX "index_citygate_users_on_reset_password_token" ON "citygate_users" ("reset_password_token")0a)cindexindex_citygate_users_on_confirmation_tokencitygate_users CREATE UNIQUE INDEX "index_citygate_users_on_confirmation_token" ON "citygate_users" ("confirmation_token") G)/indexindex_citygate_users_on_emailcitygate_users CREATE UNIQUE INDEX "index_citygate_users_on_email" ON "citygate_users" ("email")# ])Mindexindex_citygate_users_on_invitation_tokencitygate_usersCREATE INDEX "index_citygate_users_on_invitation_token" ON "citygate_users" ("invitation_token") W)Aindexindex_citygate_users_on_invited_by_idcitygate_usersCREATE INDEX "index_citygate_users_on_invited_by_id" ON "citygate_users" ("invited_by_id")     pp)20120727145840)20120706095551)20120706095550)20120706095549)20120706095548)20120706095547)20120706095546)20120916223209 h{h)20120727145840)20120706095551)20120706095550)20120706095549)20120706095548)20120706095547)20120706095546)20120916223209 JJv6 e)kindexindex_citygate_users_on_reset_password_tokencitygate_usersCREATE UNIQUE INDEX "index_citygate_users_on_reset_password_token" ON "citygate_users" ("reset_password_token")q //tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) =//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")