spec/test_app/db/development.sqlite3 in lti_skydrive-1.2.1 vs spec/test_app/db/development.sqlite3 in lti_skydrive-1.2.2

- old
+ new

@@ -1,19 +1,13 @@ -SQLite format 3@ 0-%     G - )-// tableskydrive_accountsskydrive_accounts CREATE TABLE "skydrive_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "key" varchar(255), "secret" varchar(255), "tool_consumer_instance_guid" text, "name" varchar(255), "email" varchar(255), "institution" varchar(255), "title" varchar(255))))ctableskydrive_usersskydrive_usersCREATE TABLE "skydrive_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "username" varchar(255), "email" varchar(255), "created_at" datetime, "updated_at" datetime, "account_id" integer, "lti_user_id" text)#[/Iindexindex_skydrive_api_keys_on_access_tokenskydrive_api_keys CREATE INDEX "index_skydrive_api_keys_on_access_token" ON "skydrive_api_keys" ("access_token")$//wtableskydrive_api_keysskydrive_api_keysCREATE TABLE "skydrive_api_keys" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "access_token" varchar(255), "scope" varchar(255), "oauth_code" varchar(255), "expired_at" datetime, "created_at" datetime, "init_params" text) -7indexi -//ytableskydrive_accountsskydrive_accounts CREATE TABLE "skydrive_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "key" varchar(255), "secret" varchar(255), "tool_consumer_instance_guid" text, "name" varchar(255)) M+-indexindex_skydrive_tokens_on_user_idskydrive_tokens CREATE INDEX "index_skydrive_tokens_on_user_id" ON "skydrive_tokens" ("user_id")X++gtableskydrive_tokensskydrive_tokens -CREATE TABLE "skydrive_tokens" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "token_type" varchar(255), "access_token" text(255), "expires_in" integer, "refresh_token" text(255), "not_before" datetime, "expires_on" datetime, "resource" varchar(255), "personal_url" varchar(255)) )\//wtableskydrive_accountsskydrive_accounts CREATE TABLE "skydrive_accounts" ("id" INTI/%indexindex_skydrive_accounts_on_keyskydrive_accounts CREATE INDEX "index_skydrive_accounts_on_key" ON "skydrive_accounts" ("key")W/Aindexindex_skydrive_api_keys_on_oauth_codeskydrive_api_keysCREATE INDEX "index_skydrive_api_keys_on_oauth_code" ON "skydrive_api_keys" ("oauth_code") KI/%indexindex_skydrive_accounts_on_keyskydrive_accounts CREATE INDEX "index_skydrive_accounts_on_key" ON "skydrive_accounts" ("key")Q/5indexindex_skydrive_api_keys_on_user_idskydrive_api_keysCREATE INDEX "index_skydrive_api_keys_on_user_id" ON "skydrive_api_keys" ("user_id")1utablelti_keyslti_keys CREATE TABLE "lti_keys" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "key" varchar(255), "secret" varchar(255))P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)}tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "username" varchar(255), "email" varchar(255), "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) p^L:( )20141218213907 )20141212214641 )20140910214356 -)20140910210840 )20140103221052)20130802231147)20130801181008)20130730164700)20130726170108)20130725183724)20130722173006)20130710195819)20130710195807 -  -|iVC0 -)20141218213907 )20141212214641 )20140910214356 )20140910210840 -)20140103221052 )20130802231147)20130801181008)20130730164700)20130726170108)20130725183724)20130722173006)20130710195819) 20130710195807 r+V : E AA nameuser2015-05-11 21:29:07.5106452015-05-11 21:29:07.510645E - AA nameuser2015-05-11 21:29:07.1418312015-05-11 21:29:07.141831E AA nameuser2015-05-11 21:29:06.7416782015-05-11 21:29:06.741678E AA nameuser2015-05-11 21:29:06.3262872015-05-11 21:29:06.326287E AA nameuser2015-05-11 21:29:05.8537702015-05-11 21:29:05.853770E AA nameuser2015-05-11 21:29:05.0216932015-05-11 21:29:05.021693E AA nameuser2015-05-11 21:29:03.2940242015-05-11 21:29:03.294024E AA nameuser2015-05-11 21:29:01.5890772015-05-11 21:29:01.589077E AA nameuser2015-05-11 21:28:58.9328442015-05-11 21:28:58.932844E AA nameuser2015-05-11 21:28:57.3569402015-05-11 21:28:57.356940E AA nameuser2015-05-11 21:28:55.3165662015-05-11 21:28:55.316566 )skydrive_users / skydrive_accounts  - -  - -  !i am a key ) - - - ! i am a key - +SQLite format 3@  -    +  + &~&#[/Iindexindex_skydrive_api_keys_on_access_tokenskydrive_api_keysCREATE INDEX "index_skydrive_api_keys_on_access_token" ON "skydrive_api_keys" ("access_token")$//wtableskydrive_api_keysskydrive_api_keysCREATE TABLE "skydrive_api_keys" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "access_token" varchar(255), "scope" varchar(255), "oauth_code" varchar(255), "expired_at" datetime, "created_at" datetime, "init_params" text)I/%indexindex_skydrive_accounts_on_keyskydrive_accountsCREATE INDEX "index_skydrive_accounts_on_key" ON "skydrive_accounts" ("key")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)-// tableskydrive_accountsskydrive_accountsCREATE TABLE "skydrive_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "key" varchar(255), "secret" varchar(255), "tool_consumer_instance_guid" text, "name" varchar(255), "email" varchar(255), "institution" varchar(255), "title" varchar(255)) + Z#911X++gtableskydrive_tokensskydrive_tokens CREATE TABLE "skydrive_tokens" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "token_type" varchar(255), "access_token" text(255), "expires_in" integer, "refresh_token" text(255), "not_before" datetime, "expires_on" datetime, "resource" varchar(255), "personal_url" varchar(255))Q/5indexindex_skydrive_api_keys_on_user_idskydrive_api_keys +CREATE INDEX "index_skydrive_api_keys_on_user_id" ON "skydrive_api_keys" ("user_id")W/Aindexindex_skydrive_api_keys_on_oauth_codeskydrive_api_keysCREATE INDEX "index_skydrive_api_keys_on_oauth_code" ON "skydrive_api_keys" ("oauth_code") +  +  ]qZ] =//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) +))ctableskydrive_usersskydrive_users CREATE TABLE "skydrive_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "username" varchar(255), "email" varchar(255), "created_at" datetime, "updated_at" datetime, "account_id" integer, "lti_user_id" text) M+-indexindex_skydrive_tokens_on_user_idskydrive_tokens CREATE INDEX "index_skydrive_tokens_on_user_id" ON "skydrive_tokens" ("user_id") p^L:( )20140103221052 )20141212214641 )20140910210840 +)20130710195807 )20130730164700)20130726170108)20140910214356)20130725183724)20130710195819)20130801181008)20130802231147)20130722173006)20141218213907 +  +CiV +0|)20140103221052 )20141212214641 )20140910210840 )20130710195807 +)20130730164700 )20130726170108)20140910214356)20130725183724)20130710195819)20130801181008)20130802231147)20130722173006) 20141218213907 \ No newline at end of file