SQLite format 3@ 3%P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)"))tablecitygate_userscitygate_usersCREATE TABLE "citygate_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) 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), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" va  pp)20120916223209)20120727145840)20120706095551)20120706095550)20120706095549)20120706095548)20120706095547)20120706095546 h{h)20120916223209)20120727145840)20120706095551)20120706095550)20120706095549)20120706095548)20120706095547)20120706095546)]AAAA5luis@zamith.ptfa2d4fdfd0602439152148fe9e5edc567d2e6f0d2012-09-10 10:16:12.8630472012-09-10 10:16:23.6827772012-09-10 10:16:23.6822762012-09-10 10:16:12.862637uiky1jsz94fqePT3maoz;]AAAAAA5zamith@groupbuddies.com13fab05ee328c3f184177371c3763304952dc0b62012-08-21 13:56:38.3429112012-08-21 13:56:38.342911127.0.0.1127.0.0.12012-08-21 13:56:25.9753052012-08-24 00:29:40.9752862012-08-21 13:56:38.3366322012-08-21 13:56:25.974930rxfkh6MxhyaYqafyWXUq9]AAAAAA5admin@groupbuddies.com69256c896e90e2d9b269ca50ff3aa0829796fe532012-08-07 15:08:06.2852412012-08-07 15:08:06.285241127.0.0.1127.0.0.12012-08-07 15:07:53.7379302012-08-07 15:40:16.1676552012-08-07 15:08:06.2782152012-08-07 15:07:53.737517KoQcfJEUPy15cTtZpYvnS=]AA5A5nj_nets_kidd@hotmail.com05076c92bbc1073240493eafc7535eeb3eac4fd72012-07-25 17:58:36.5279802012-07-25 17:58:36.5279808ZyAiARZWpskpG2zSZy92012-07-25 17:58:36.527468yZEx1seQsa7HDz3 5citygate_permissions;citygate_authorizations)citygate_users)citygate_roles $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")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) HH&cccq//tableschema_migrations5))%tablecitygate_userscitygate_usersCREATE 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)  ))Utablecitygate_userscitygate_usersCREATE TABLE "citygate_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) 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), "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 )luis@zamith.pt;zamith@groupbuddies.com9admin@groupbuddies.com=nj_nets_kidd@hotmail.com Q M G)/indexindex_citygate_users_on_emailcitygate_users CREATE UNIQUE INDEX "index_citygate_users_on_email" ON "citygate_users" ("email")6e)kindexindex_citygate_users_on_reset_password_tokencitygate_users CREATE UNIQUE INDEX "index_citygate_users_on_reset_password_token" ON "citygate_users" ("reset_password_token")#])Mindexindex_citygate_users_on_invitation_tokencitygate_users CREATE 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")0 a)cindexindex_citygate_users_on_confirmation_tokencitygate_users CREATE UNIQUE INDEX "index_citygate_users_on_confirmation_token" ON "citygate_users" ("confirmation_token")   BVp9pdxdpqd5e7Aq58ZyAiARZWpskpG2zSZy9 ${& -)AAGooglehttps://www.google.com/accounts/o8/id?id=AItOawn6rTHR2pynEaEtBjOuZnPYRZLRqJ8C35gLuís Ferreira2012-09-10 10:16:13.5223772012-09-10 10:16:13.522377& -)AAGooglehttps://www.google.com/accounts/o8/id?id=AItOawnP1EJguObiGHHnoigbReK1uAdrjw9FjX0Luís Ferreira2012-08-21 13:56:26.3079422012-08-21 13:56:26.307942% -'AAGooglehttps://www.google.com/accounts/o8/id?id=AItOawnz03Fg9IaDSwTZUil_CzZKY3Vbp6Dad9QGroup Buddies2012-08-07 15:07:54.4528662012-08-07 15:07:54.4528661 k7S{AAFacebook754864768AAAFgyOm83rkBACi46mN0qZCwiwxBhuWJADVhW1FoEyU8kIZA7XiSP9JoJqmN1p6eE7Cjl8jxAvV1ZB4I14L9EcKZC0wwuIYCHY7sh8KXCQZDZDLuís Zamith Ferreirahttp://www.facebook.com/luis.zamithhttp://graph.facebook.com/754864768/picture?type=square2012-07-25 17:58:37.2510912012-07-25 17:58:37.251091 0 ;;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" 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)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) >AAAdmin2012-07-06 09:56:18.4924462012-07-06 09:56:18.492446?AAMember2012-07-06 09:56:18.4621232012-07-06 09:56:18.462123 manageall)readCitygate::Userindexhome  @@] 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)) W5Aindexindex_citygate_permissions_on_role_idcitygate_permissionsCREATE INDEX "index_citygate_permissions_on_role_id" ON "citygate_permissions" ("role_id") * ;]AAAAAA5zamith@groupbuddies.com13fab05ee328c3f184177371c3763304952dc0b62012-08-21 13:56:38.3429112012-08-21 13:56:38.342911127.0.0.1127.0.0.12012-08-21 13:56:25.9753052012-08-24 00:29:40.9752862012-08-21 13:56:38.3366322012-08-21 13:56:25.974930rxfkh6MxhyaYqafyWXUq9]AAAAAA5admin@groupbuddies.com69256c896e90e2d9b269ca50ff3aa0829796fe532012-08-07 15:08:06.2852412012-08-07 15:08:06.285241127.0.0.1127.0.0.12012-08-07 15:07:53.7379302012-08-07 15:40:16.1676552012-08-07 15:08:06.2782152012-08-07 15:07:53.737517KoQcfJEUPy15cTtZpYvnS=]AA5A5nj_nets_kidd@hotmail.com05076c92bbc1073240493eafc7535eeb3eac4fd72012-07-25 17:58:36.5279802012-07-25 17:58:36.5279808ZyAiARZWpskpG2zSZy92012-07-25 17:58:36.527468yZEx1seQsa7HDz3pGnF5 )]AAAAAA5luis@zamith.ptfa2d4fdfd0602439152148fe9e5edc567d2e6f0d2012-09-10 10:16:23.6886542012-09-10 10:16:23.688654127.0.0.1127.0.0.12012-09-10 10:16:12.8630472012-09-10 10:16:27.4659592012-09-10 10:16:23.6822762012-09-10 10:16:12.862637uiky1jsz94fqePT3maoz