spec/dummy/db/test.sqlite3 in maestrano-connector-rails-0.2.9 vs spec/dummy/db/test.sqlite3 in maestrano-connector-rails-0.2.10
- old
+ new
@@ -1,14 +1,12 @@
-SQLite format 3 @ -
+SQLite format 3 @ -
-
p `tableid_mapsid_mapsCREATE TABLE "id_maps" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "connec_id" varchar, "connec_entity" varchar, "external_id" varchar, "external_entity" varchar, "organization_id" integer, "last_push_to_connec" datetime, "last_push_to_external" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)1Mindexidmap_connec_indexid_mapsCREATE INDEX "idmap_connec_index" ON "id_maps" ("connec_id", "connec_entity", "organization_id")5Yindexidmap_external_indexid_mapsCREATE INDEX "idmap_external_index" ON "id_maps" ("external_id", "external_entity", "organization_id")t=indexidmap_organization_indexid_mapsCREATE INDEX "idmap_organization_index" ON "id_maps" ("organization_id")
+ +Pm 6''+tableorganizationsorganizationsCREATE TABLE "organizations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "provider" varchar, "uid" varchar, "name" varchar, "tenant" varchar, "oauth_provider" varchar, "oauth_uid" varchar, "oauth_token" varchar, "refresh_token" varchar, "instance_url" varchar, "synchronized_entities" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "sync_enabled" boolean DEFAULT 'f')j)'indexorga_uid_indexorganizations
+
T Tp Getableid_mapsid_mapsCREATE TABLE "id_maps" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "connec_id" varchar, "connec_entity" varchar, "external_id" varchar, "external_entity" varchar, "organization_id" integer, "last_push_to_connec" datetime, "last_push_to_external" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "to_connec" boolean DEFAULT 't', "to_external" boolean DEFAULT 't', "name" varchar, "message" varchar)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)1Mindexidmap_connec_indexid_mapsCREATE INDEX "idmap_connec_index" ON "id_maps" ("connec_id", "connec_entity", "organization_id")5Yindexidmap_external_indexid_mapsCREATE INDEX "idmap_external_index" ON "id_maps" ("external_id", "external_entity", "organization_id")t=indexidmap_organization_indexid_mapsCREATE INDEX "idmap_organization_index" ON "id_maps" ("organization_id")
+ +Pm 6''+tableorganizationsorganizationsCREATE TABLE "organizations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "provider" varchar, "uid" varchar, "name" varchar, "tenant" varchar, "oauth_provider" varchar, "oauth_uid" varchar, "oauth_token" varchar, "refresh_token" varchar, "instance_url" varchar, "synchronized_entities" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "sync_enabled" boolean DEFAULT 'f')j)'indexorga_uid_indexorganizations
CREATE INDEX "orga_uid_index" ON "organizations" ("uid", "tenant")--gtablesynchronizationssynchronizationsCREATE TABLE "synchronizations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "organization_id" integer, "status" varchar, "message" text, "partial" boolean DEFAULT 'f', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) G-9indexsynchronization_orga_id_indexsynchronizationsCREATE INDEX "synchronization_orga_id_index" ON "synchronizations" ("organization_id")
u l
99stableuser_organization_relsuser_organization_rels
CREATE TABLE "user_organization_rels" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "organization_id" integer, "created_at" datetime, "updated_at" datetime) +9)indexrels_orga_indexuser_organization_relsCREATE INDEX "rels_orga_index" ON "user_organization_rels" ("organization_id")x+9indexrels_user_indexuser_organization_relsCREATE INDEX "rels_user_index" ON "user_organization_rels" ("user_id")
{tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "provider" varchar, "uid" varchar, "first_name" varchar, "last_name" varchar, "email" varchar, "tenant" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
-
( p^L:( )20151122162613)20151122163325
-)20160205132857 )20151122163449)20151122162414)20151122162100)20160204223451)20160204223450)20160204223447)20160204223449)20160204223448)20160205133024
- |i0VC )20151122162613)20151122163325)20160205132857
-)20151122163449 )20151122162414)20151122162100)20160204223451)20160204223450)20160204223447)20160204223449)20160204223448) 20160205133024
v Z)indexuser_uid_indexusersCREATE INDEX "user_uid_index" ON "users" ("uid", "tenant")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
+
)20151122162613)20151122163325)20160205132857)20151122163449)20151122162414)20151122162100)20160215103120
+ | | )20151122162613)20151122163325)20160205132857)20151122163449)20151122162414)20151122162100) 20160215103120
v Z)indexuser_uid_indexusersCREATE INDEX "user_uid_index" ON "users" ("uid", "tenant")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
\ No newline at end of file