test/dummy/db/test.sqlite3 in shipit-engine-0.15.0 vs test/dummy/db/test.sqlite3 in shipit-engine-0.16.0

- old
+ new

@@ -1,60 +1,73 @@ -SQLite format 3@ 33,3-p& +SQLite format 3@ >>7>-p8 - q,8MM%%]tablegithub_hooksgithub_hooksCREATE TABLE "github_hooks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stack_id" integer(4), "github_id" integer(4), "event" varchar(50) NOT NULL, "created_at" datetime, "updated_at" datetime, "secret" varchar(255), "api_url" varchar(255), "type" varchar(255), "organization" varchar(39))U!;indexindex_deliveries_on_status_and_eventdeliveriesCREATE INDEX "index_deliveries_on_status_and_event" ON "deliveries" ("status", "event")5m!iindexindex_deliveries_on_hook_id_and_event_and_statusdeliveriesCREATE INDEX "index_deliveries_on_hook_id_and_event_and_status" ON "deliveries" ("hook_id", "event", "status")I!%indexindex_deliveries_on_created_atdeliveriesCREATE INDEX "index_deliveries_on_created_at" ON "deliveries" ("created_at")s!!1tabledeliveriesdeliveriesCREATE TABLE "deliveries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "hook_id" integer(4) NOT NULL, "status" varchar(50) DEFAULT 'pending' NOT NULL, "url" varchar(4096) NOT NULL, "content_type" varchar(255) NOT NULL, "event" varchar(50) NOT NULL, "payload" text(16777215) NOT NULL, "response_code" integer(4), "response_headers" text(65535), "response_body" text(65535), "delivered_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)o ?indexindex_commits_on_stack_idcommitsCREATE INDEX "index_commits_on_stack_id" ON "commits" ("stack_id")u Cindexindex_commits_on_created_atcommits CREATE INDEX "index_commits_on_created_at" ON "commits" ("created_at"){ G!indexindex_commits_on_committer_idcommits CREATE INDEX "index_commits_on_committer_id" ON "commits" ("committer_id")r -Aindexindex_commits_on_author_idcommits CREATE INDEX "index_commits_on_author_id" ON "commits" ("author_id")N stablecommitscommits -CREATE TABLE "commits" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stack_id" integer(4) NOT NULL, "author_id" integer(4) NOT NULL, "committer_id" integer(4) NOT NULL, "sha" varchar(40) NOT NULL, "message" text(65535) NOT NULL, "created_at" datetime, "updated_at" datetime, "detached" boolean DEFAULT 'f' NOT NULL, "authored_at" datetime NOT NULL, "committed_at" datetime NOT NULL, "additions" integer(4), "deletions" integer(4))S19indexindex_commit_deployments_on_task_idcommit_deployments CREATE INDEX "index_commit_deployments_on_task_id" ON "commit_deployments" ("task_id")Ho1}indexindex_commit_deployments_on_commit_id_and_task_idcommit_deploymentsCREATE UNIQUE INDEX "index_commit_deployments_on_commit_id_and_task_id" ON "commit_deployments" ("commit_id", "task_id")11Stablecommit_deploymentscommit_deploymentsCREATE TABLE "commit_deployments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "commit_id" integer, "task_id" integer, "github_id" integer, "api_url" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)_}A indexindex_commit_deployment_statuses_on_commit_deployment_idcommit_deployment_statusesCREATE INDEX "index_commit_deployment_statuses_on_commit_deployment_id" ON "commit_deployment_statuses" ("commit_deployment_id")6AAwtablecommit_deployment_statusescommit_deployment_statusesCREATE TABLE "commit_deployment_statuses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "commit_deployment_id" integer, "status" varchar, "github_id" integer, "api_url" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)K#)indexindex_api_clients_on_creator_idapi_clientsCREATE INDEX "index_api_clients_on_creator_id" ON "api_clients" ("creator_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)##{tableapi_clientsapi_clientsCREATE TABLE "api_clients" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "permissions" text(65535), "creator_id" integer(4), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar(255) DEFAULT '', "stack_id" i aiǭG/AA5--- + qBQis7U!;indexindex_deliveries_on_status_and_eventdeliveriesCREATE INDEX "index_deliveries_on_status_and_event" ON "deliveries" ("status", "event")5m!iindexindex_deliveries_on_hook_id_and_event_and_statusdeliveriesCREATE INDEX "index_deliveries_on_hook_id_and_event_and_status" ON "deliveries" ("hook_id", "event", "status")I!%indexindex_deliveries_on_created_atdeliveriesCREATE INDEX "index_deliveries_on_created_at" ON "deliveries" ("created_at")s!!1tabledeliveriesdeliveriesCREATE TABLE "deliveries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "hook_id" integer(4) NOT NULL, "status" varchar(50) DEFAULT 'pending' NOT NULL, "url" varchar(4096) NOT NULL, "content_type" varchar(255) NOT NULL, "event" varchar(50) NOT NULL, "payload" text(16777215) NOT NULL, "response_code" integer(4), "response_headers" text(65535), "response_body" text(65535), "delivered_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)o ?indexindex_commits_on_stack_idcommitsCREATE INDEX "index_commits_on_stack_id" ON "commits" ("stack_id")u Cindexindex_commits_on_created_atcommits CREATE INDEX "index_commits_on_created_at" ON "commits" ("created_at"){ G!indexindex_commits_on_committer_idcommits CREATE INDEX "index_commits_on_committer_id" ON "commits" ("committer_id")r +Aindexindex_commits_on_author_idcommits CREATE INDEX "index_commits_on_author_id" ON "commits" ("author_id"), /tablecommitscommits +CREATE TABLE "commits" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stack_id" integer(4) NOT NULL, "author_id" integer(4) NOT NULL, "committer_id" integer(4) NOT NULL, "sha" varchar(40) NOT NULL, "message" text(65535) NOT NULL, "created_at" datetime, "updated_at" datetime, "detached" boolean DEFAULT 'f' NOT NULL, "authored_at" datetime NOT NULL, "committed_at" datetime NOT NULL, "additions" integer(4), "deletions" integer(4), "pull_request_number" integer, "pull_request_title" varchar(1024), "pull_request_id" integer)S19indexindex_commit_deployments_on_task_idcommit_deployments CREATE INDEX "index_commit_deployments_on_task_id" ON "commit_deployments" ("task_id")Ho1}indexindex_commit_deployments_on_commit_id_and_task_idcommit_deploymentsCREATE UNIQUE INDEX "index_commit_deployments_on_commit_id_and_task_id" ON "commit_deployments" ("commit_id", "task_id")11Stablecommit_deploymentscommit_deploymentsCREATE TABLE "commit_deployments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "commit_id" integer, "task_id" integer, "github_id" integer, "api_url" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)_}A indexindex_commit_deployment_statuses_on_commit_deployment_idcommit_deployment_statusesCREATE INDEX "index_commit_deployment_statuses_on_commit_deployment_id" ON "commit_deployment_statuses" ("commit_deployment_id")6AAwtablecommit_deployment_statusescommit_deployment_statusesCREATE TABLE "commit_deployment_statuses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "commit_deployment_id" integer, "status" varchar, "github_id" integer, "api_url" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)K#)indexindex_api_clients_on_creator_idapi_clientsCREATE INDEX "index_api_clients_on_creator_id" ON "api_clients" ("creator_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)##{tableapi_clientsapi_clientsCREATE TABLE "api_clients" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "permissions" text(65535), "creator_id" integer(4), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar(255) DEFAULT '', "stack_'' aiǭG/AA5--- - read:stack ->v2017-01-17 10:53:37.0623832017-01-17 10:53:37.062383Here Come The Walrus$WSw 5AA--- +>v2017-02-21 13:21:03.1110902017-02-21 13:21:03.111090Here Come The Walrus$WSw 5AA--- - read:stack - write:stack - deploy:stack - lock:stack - read:hook - write:hook ->v2017-01-17 10:53:37.0623832017-01-17 10:53:37.062383Spy ykWA2!  users>v teams tasks statuses>S԰ -stacks?N 'output_chunks>X|&#memberships hooks>I%github_hooks=!deliveries commits1commit_deployments7P!Acommit_deployment_statuses4Z#api_clients/w - >v$ >v/w /e/|G֚kAASfailure2017-01-17 10:53:37.0735752017-01-17 10:53:37.073575GAASpending2017-01-17 10:53:37.0735752017-01-17 10:53:37.073575 %AAusuccess+https://api.github.com/repos/shopify/shipit-engine/deployments/1/statuses/432017-01-17 10:53:37.0735752017-01-17 10:53:37.073575 %AAupending*https://api.github.com/repos/shopify/shipit-engine/deployments/1/statuses/422017-01-17 10:53:37.0735752017-01-17 10:53:37.073575 - Sk S! u4Z u3   }o  `+>ǦEAA2017-01-17 10:53:37.0768652017-01-17 10:53:37.076865> AA2017-01-17 10:53:37.0768652017-01-17 10:53:37.076865>lAA2017-01-17 10:53:37.0768652017-01-17 10:53:37.076865>=AA2017-01-17 10:53:37.0768652017-01-17 10:53:37.076865>PAA2017-01-17 10:53:37.0768652017-01-17 10:53:37.076865  AAhttps://api.github.com/repos/shopify/shipit-engine/deployments/32017-01-17 10:53:37.0768652017-01-17 10:53:37.076865S  AAhttps://api.github.com/repos/shopify/shipit-engine/deployments/22017-01-17 10:53:37.0768652017-01-17 10:53:37.076865~u  AAhttps://api.github.com/repos/shopify/shipit-engine/deployments/12017-01-17 10:53:37.0768652017-01-17 10:53:37.076865 +>v2017-02-21 13:21:03.1110902017-02-21 13:21:03.111090Spy ykWA+  users>v teams tasks statuses>S԰ stacks?N +'pull_requests;e4 'output_chunks>X|&#memberships hooks>I%github_hooks=!deliveries commits1commit_deployments7P!Acommit_deployment_statuses4Z#api_clients/w + >v$ >v/w /e/|G֚kAASfailure2017-02-21 13:21:03.1211262017-02-21 13:21:03.121126GAASpending2017-02-21 13:21:03.1211262017-02-21 13:21:03.121126 %AAusuccess+https://api.github.com/repos/shopify/shipit-engine/deployments/1/statuses/432017-02-21 13:21:03.1211262017-02-21 13:21:03.121126 %AAupending*https://api.github.com/repos/shopify/shipit-engine/deployments/1/statuses/422017-02-21 13:21:03.1211262017-02-21 13:21:03.121126 + Sk S! u4Z u3   }o  `+>ǦEAA2017-02-21 13:21:03.1242462017-02-21 13:21:03.124246> AA2017-02-21 13:21:03.1242462017-02-21 13:21:03.124246>lAA2017-02-21 13:21:03.1242462017-02-21 13:21:03.124246>=AA2017-02-21 13:21:03.1242462017-02-21 13:21:03.124246>PAA2017-02-21 13:21:03.1242462017-02-21 13:21:03.124246  AAhttps://api.github.com/repos/shopify/shipit-engine/deployments/32017-02-21 13:21:03.1242462017-02-21 13:21:03.124246S  AAhttps://api.github.com/repos/shopify/shipit-engine/deployments/22017-02-21 13:21:03.1242462017-02-21 13:21:03.124246~u  AAhttps://api.github.com/repos/shopify/shipit-engine/deployments/12017-02-21 13:21:03.1242462017-02-21 13:21:03.124246  E 2D 2:X  ɽ 7P  S  u -E2D2:X ɽ7PS u  Q^ < Q]A333 ?N5˱C5˱C44b3833d39def7ec65b57b42f496eb27ab4980b6Cake!2017-01-17 10:53:37.0809382017-01-09 10:53:37f2017-01-15 10:53:372017-01-16 10:53:37]A333 /Uk5˱C5˱C8e859b4c19ea7638443d43d612086948bce51701Chips!2017-01-17 10:53:37.0809382017-01-09 10:53:37f2017-01-15 10:53:372017-01-16 10:53:37)]1A333 $WS>v>v567578b362bf2b4df5903e1c7960929361c3abcdfix all teh things2017-01-17 10:53:37.0809382017-01-09 10:53:37f2017-01-15 10:53:372017-01-16 10:53:37[] A333$WS>v>v467578b362bf2b4df5903e1c7960929361c3435aMerge pull request #7 from shipit-engine/yoloshipit +E2D2:X ɽ7PS u  +[ 0 < +(]'A333$WS>v>v424278037b872fd9a6690523e411ecb3aa181355Super feature2017-02-21 13:21:03.1285652017-02-13 13:21:03t2017-02-11 13:21:032017-02-12 13:21:03*]A333 ?N5˱C5˱C44b3833d39def7ec65b57b42f496eb27ab4980b6Cake!2017-02-21 13:21:03.1285652017-02-13 13:21:03f2017-02-19 13:21:032017-02-20 13:21:03 ]A333 /Uk5˱C5˱C8e859b4c19ea7638443d43d612086948bce51701Chips!2017-02-21 13:21:03.1285652017-02-13 13:21:03f2017-02-19 13:21:032017-02-20 13:21:03,]1A333 $WS>v>v567578b362bf2b4df5903e1c7960929361c3abcdfix all teh things2017-02-21 13:21:03.1285652017-02-13 13:21:03f2017-02-19 13:21:032017-02-20 13:21:03^] A333$WS>v>v467578b362bf2b4df5903e1c7960929361c3435aMerge pull request #7 from shipit-engine/yoloshipit -yoloshipit!2017-01-17 10:53:37.0809382017-01-09 10:53:37f2017-01-13 10:53:372017-01-14 10:53:37V]A333$WS>v>v367578b362bf2b4df5903e1c7960929361c39074fix it!2017-01-17 10:53:37.0809382017-01-09 10:53:37f2017-01-11 10:53:372017-01-12 10:53:37 @]A333 $WS>v>vf890fd8b5f2be05d1fedb763a3605ee461c39074sheep it!2017-01-17 10:53:37.0809382017-01-09 10:53:37f2017-01-09 10:53:372017-01-10 10:53:37]A333$WS>v>v6d9278037b872fd9a6690523e411ecb3aa181355lets go2017-01-17 10:53:37.0809382017-01-09 10:53:37f2017-01-07 10:53:372017-01-08 10:53:37* -5˱C5˱C>v>v>v>v >v -5˱C5˱C>v>v>v>v >v -(fG(A2017-01-17 10:53:37.080938A2017-01-17 10:53:37.080938A2017-01-17 10:53:37.080938A2017-01-17 10:53:37.080938A2017-01-17 10:53:37.080938A2017-01-17 10:53:37.080938A 2017-01-17 10:53:37.080938 -?N/Uk$WS$WS$WS$WS $WS LL-\O-[AAHscheduledhttps://example.com/events/deployapplication/jsondeploy{ +yoloshipit!2017-02-21 13:21:03.1285652017-02-13 13:21:03f2017-02-17 13:21:032017-02-18 13:21:03V"]A333$WS>v>v367578b362bf2b4df5903e1c7960929361c39074fix it!2017-02-21 13:21:03.1285652017-02-13 13:21:03f2017-02-15 13:21:032017-02-16 13:21:03 @"]A333 $WS>v>vf890fd8b5f2be05d1fedb763a3605ee461c39074sheep it!2017-02-21 13:21:03.1285652017-02-13 13:21:03f2017-02-13 13:21:032017-02-14 13:21:03"]A333$WS>v>v6d9278037b872fd9a6690523e411ecb3aa181355lets go2017-02-21 13:21:03.1285652017-02-13 13:21:03f2017-02-11 13:21:032017-02-12 13:21:03* +>v5˱C5˱C>v>v>v>v >v +>v5˱C5˱C>v>v>v>v >v + fG( A2017-02-21 13:21:03.128565A2017-02-21 13:21:03.128565A2017-02-21 13:21:03.128565A2017-02-21 13:21:03.128565A2017-02-21 13:21:03.128565A2017-02-21 13:21:03.128565A2017-02-21 13:21:03.128565A 2017-02-21 13:21:03.128565 +$WS?N/Uk$WS$WS$WS$WS $WS LL-\O-[AAHscheduledhttps://example.com/events/deployapplication/jsondeploy{ "stack": { }, "deploy": { } -}2017-01-17 10:53:37.0875692017-01-17 10:53:37.087569 -!A2017-01-17 10:53:37.087569 +}2017-02-21 13:21:03.1357992017-02-21 13:21:03.135799 +!A2017-02-21 13:21:03.135799 Hdeployscheduled -scheduleddeploy GG*t{ !AAMmembership2017-01-17 10:53:37.0909152017-01-17 10:53:37.0909151234Shipit::GithubHook::Organizationshopifyc擄 AA=/Ukpush2017-01-17 10:53:37.0909152017-01-17 10:53:37.0909151234Shipit::GithubHook::Repof↨o AA=$WS+status2017-01-17 10:53:37.0909152017-01-17 10:53:37.0909151234Shipit::GithubHook::Repodžy AA=$WS*push2017-01-17 10:53:37.0909152017-01-17 10:53:37.0909151234Shipit::GithubHook::Repo -!shopifymembership{ push=status<Ao pushGy M +scheduleddeploy GG*t{ !AAMmembership2017-02-21 13:21:03.1402682017-02-21 13:21:03.1402681234Shipit::GithubHook::Organizationshopifyc擄 AA=/Ukpush2017-02-21 13:21:03.1402682017-02-21 13:21:03.1402681234Shipit::GithubHook::Repof↨o AA=$WS+status2017-02-21 13:21:03.1402682017-02-21 13:21:03.1402681234Shipit::GithubHook::Repodžy AA=$WS*push2017-02-21 13:21:03.1402682017-02-21 13:21:03.1402681234Shipit::GithubHook::Repo 7 - q,8MM%%]tablegithub_hooksgithub_hooksCREATE TABLE "github_hooks" M%%]tablegithub_hooksgithub_hooksCREATE TABLE "github_hooks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stack_id" integer(4), "github_id" integer(4), "event" varchar(50) NOT NULL, "created_at" datetime, "updated_at" datetime, "secret" varchar(255), "api_url" varchar(255), "type" varchar(255), "organization" varchar(39))U!;indexindex_deliveries_on_status_and_eventdeliveriesCREATE INDEX "index_deliveries_on_status_and_event" ON "deliveries" ("status", "event")5m!iindexindex_deliveries_on_hook_id_and_event_and_statusdeliveriesCREATE INDEX "index_deliveries_on_hook_id_and_event_and_status" ON "deliveries" ("hook_id", "event", "status")I!%indexindex_deliveries_on_created_atdeliveriesCREATE INDEX "index_deliveries_on_created_at" ON "deliveries" ("created_at")s!!1tabledeliveriesdeliveriesCREATE TABLE "deliveries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "hook_id" integer(4) NOT NULL, "status" varchar(50) DEFAULT 'pending' NOT NULL, "url" varchar(4096) NOT NULL, "content_type" varchar(255) NOT NULL, "event" varchar(50) NOT NULL, "payload" text(16777215) NOT NULL, "response_code" integer(4), "response_headers" text(65535), "response_body" text(65535), "delivered_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)o ?indexindex_commits_on_stack_idcommitsCREATE INDEX "index_commits_on_stack_id" ON "commits" ("stack_id")u Cindexindex_commits_on_created_atcommits CREATE INDEX "index_commits_on_created_at" ON "commits" ("created_at"){ G!indexindex_commits_on_committer_idcommits CREATE INDEX "index_commits_on_committer_id" ON "commits" ("committer_id")r -Aindexindex_commits_on_author_idcommits CREATE INDEX "index_commits_on_author_id" ON "commits" ("author_id")N stablecommitscommits -CREATE TABLE "commits" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stack_id" integer(4) NOT NULL, "author_id" integer(4) NOT NULL, "committer_id" integer(4) NOT NULL, "sha" varchar(40) NOT NULL, "message" text(65535) NOT NULL, "created_at" datetime, "updated_at" datetime, "detached" boolean DEFAULT 'f' NOT NULL, "authored_at" datetime NOT NULL, "committed_at" datetime NOT NULL, "additions" integer(4), "deletions" integer(4))S19indexindex_commit_deployments_on_task_idcommit_deployments CREATE INDEX "index_commit_deployments_on_task_id" ON "commit_deployments" ("task_id")Ho1}indexindex_commit_deployments_on_commit_id_and_task_idcommit_deploymentsCREATE UNIQUE INDEX "index_commit_deployments_on_commit_id_and_task_id" ON "commit_deployments" ("commit_id", "task_id")11Stablecommit_deploymentscommit_deploymentsCREATE TABLE "commit_deployments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "commit_id" integer, "task_id" integer, "github_id" integer, "api_url" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)_}A indexindex_commit_deployment_statuses_on_commit_deployment_idcommit_deployment_statusesCREATE INDEX "index_commit_deployment_statuses_on_commit_deployment_id" ON "commit_deployment_statuses" ("commit_deployment_id")6AAwtablecommit_deployment_statusescommit_deployment_statusesCREATE TABLE "commit_deployment_statuses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "commit_deployment_id" integer, "status" varchar, "github_id" integer, "api_url" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)K#)indexindex_api_clients_on_creator_idapi_clientsCREATE INDEX "index_api_clients_on_creator_id" ON "api_clients" ("creator_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)##{tableapi_clientsapi_clientsCREATE TABLE "api_clients" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "permissions" text(65535), "creator_id" integer(4), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar(255) DEFAULT '', "stack_id" integer(4))  h @ -[Z0@h -d` `6!qqindexindex_tasks_on_rolled_up_and_created_at_and_statustasks$CREATE INDEX "index_tasks_on_rolled_up_and_created_at_and_status" ON "tasks" ("rolled_up", "created_at", "status") Kctablestatusesstatuses!CREATE TABLE "statuses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "state" varchar(255), "target_url" varchar(255), "description" text(65535), "context" varchar(255) DEFAULT 'default' NOT NULL, "commit_id" integer(4), "created_at" datetime, "updated_at" datetime, "stack_id" integer NOT NULL)I'%indexindex_output_chunks_on_task_idoutput_chunksCREATE INDEX "index_output_chunks_on_task_id" ON "output_chunks" ("task_id")P''_tableoutput_chunksoutput_chunksCREATE TABLE "output_chunks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "task_id" integer(4), "text" text(16777215), "created_at" datetime, "updated_at" datetime)|E#indexindex_memberships_on_user_idmembershipsCREATE INDEX "index_memberships_on_user_id" ON "memberships" ("user_id")&]#Yindexindex_memberships_on_team_id_and_user_idmembershipsCREATE UNIQUE INDEX "index_memberships_on_team_id_and_user_id" ON "memberships" ("team_id", "user_id")[##}tablemembershipsmembershipsCREATE TABLE "memberships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "team_id" integer(4), "user_id" integer(4), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)g; indexindex_hooks_on_stack_idhooksCREATE INDEX "index_hooks_on_stack_id" ON "hooks" ("stack_id")}YtablehookshooksCREATE TABLE "hooks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stack_id" integer(4), "delivery_url" varchar(4096) NOT NULL, "content_type" varchar(4) DEFAULT 'json' NOT NULL, "secret" varchar(255), "events" varchar(255) DEFAULT '' NOT NULL, "insecure_ssl" boolean DEFAULT 'f' NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)']%Yindexindex_github_hooks_on_stack_id_and_eventgithub_hooksCREATE UNIQUE INDEX "index_github_hooks_on_stack_id_and_event" ON "github_hooks" ("stack_id", "event")3e%iindexindex_github_hooks_on_organization_and_eventgithub_hooksCREATE UNIQUE INDEX "index_github_hooks_on_organization_and_event" ON "github_hooks" ("organization", "event")K%%]tablegithub_hooksgiT tabletaskstasks#CREATE TABLE "tasks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stack_id" integer(4) NOT NULL, "since_commit_id" integer(4) NOT NULL, "until_commit_id" integer(4) NOT NULL, "status" varchar(10) DEFAULT 'pending' NOT NULL, "created_at" datetime, "updated_at" datetime, M%%]tablegithub_hooksgithub_hooksCREATE TABLE "github_hooks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stack_id" integer(4), "github_id" integer(4), "event" varchar(50) NOT NULL, "created_at" datetime, "updated_at" datetime, "secret" varchar(255), "api_url" varchar(255), "type" varchar(255), "organization" varchar(39))U!;indexindex_deliveries_on_status_and_eventdeliveriesCREATE INDEX "index_deliveries_on_status_and_event" ON "deliveries" ("status", "event")5m!iindexindex_deliveries_on_hook_id_and_event_and_statusdeliveriesCREATE INDEX "index_deliveries_on_hook_id_and_event_and_status" ON "deliveries" ("hook_id", "event", "status")etablestacksstacksCREATE TABLE "stacks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "repo_name" varchar(100) NOT NULL, "repo_owner" varchar(39) NOT NULL, "environment" varchar(50) DEFAULT 'production' NOT NULL, "created_at" datetime, "updated_at" datetime, "branch" varchar(255) DEFAULT 'master' NOT NULL, "deploy_url" varchar(255), "lock_reason" varchar(4096), "tasks_count" integer(4) DEFAULT 0 NOT NULL, "continuous_deployment" boolean DEFAULT 'f' NOT NULL, "undeployed_commits_count" integer(4) DEFAULT 0 NOT NULL, "cached_deploy_spec" text(65535), "lock_author_id" integer(4), "ignore_ci" boolean, "inaccessible_since" datetime, "estimated_deploy_duration" integer DEFAULT 1 NOT NULL, "continuous_delivery_delayed_since" datetime, "locked_since" datetime) + qBQis7RM%%]tablegithub_hooksgithub_hooksCREATE TABLE "github_hooks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stack_id" integer(4), "github_id" integer(4), "event" varchar(50) NOT NULL, "created_at" datetime, "updated_at" datetime, "secret" varchar(255), "api_url" varchar(255), "type" varchar(255), "organization" varchar(39))U!;indexindex_deliveries_on_status_and_eventdeliveriesCREATE INDEX "index_deliveries_on_status_and_event" ON "deliveries" ("status", "event")5m!iindexindex_deliveries_on_hook_id_and_event_and_statusdeliveriesCREATE INDEX "index_deliveries_on_hook_id_and_event_and_status" ON "deliveries" ("hook_id", "event", "status")I!%indexindex_deliveries_on_created_atdeliveriesCREATE INDEX "index_deliveries_on_created_at" ON "deliveries" ("created_at")s!!1tabledeliveriesdeliveriesCREATE TABLE "deliveries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "hook_id" integer(4) NOT NULL, "status" varchar(50) DEFAULT 'pending' NOT NULL, "url" varchar(4096) NOT NULL, "content_type" varchar(255) NOT NULL, "event" varchar(50) NOT NULL, "payload" text(16777215) NOT NULL, "response_code" integer(4), "response_headers" text(65535), "response_body" text(65535), "delivered_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)o ?indexindex_commits_on_stack_idcommitsCREATE INDEX "index_commits_on_stack_id" ON "commits" ("stack_id")u Cindexindex_commits_on_created_atcommits CREATE INDEX "index_commits_on_created_at" ON "commits" ("created_at"){ G!indexindex_commits_on_committer_idcommits CREATE INDEX "index_commits_on_committer_id" ON "commits" ("committer_id")r +Aindexindex_commits_on_author_idcommits CREATE INDEX "index_commits_on_author_id" ON "commits" ("author_id"), /tablecommitscommits +CREATE TABLE "commits" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stack_id" integer(4) NOT NULL, "author_id" integer(4) NOT NULL, "committer_id" integer(4) NOT NULL, "sha" varchar(40) NOT NULL, "message" text(65535) NOT NULL, "created_at" datetime, "updated_at" datetime, "detached" boolean DEFAULT 'f' NOT NULL, "authored_at" datetime NOT NULL, "committed_at" datetime NOT NULL, "additions" integer(4), "deletions" integer(4), "pull_request_number" integer, "pull_request_title" varchar(1024), "pull_request_id" integer)S19indexindex_commit_deployments_on_task_idcommit_deployments CREATE INDEX "index_commit_deployments_on_task_id" ON "commit_deployments" ("task_id")Ho1}indexindex_commit_deployments_on_commit_id_and_task_idcommit_deploymentsCREATE UNIQUE INDEX "index_commit_deployments_on_commit_id_and_task_id" ON "commit_deployments" ("commit_id", "task_id")11Stablecommit_deploymentscommit_deploymentsCREATE TABLE "commit_deployments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "commit_id" integer, "task_id" integer, "github_id" integer, "api_url" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)_}A indexindex_commit_deployment_statuses_on_commit_deployment_idcommit_deployment_statusesCREATE INDEX "index_commit_deployment_statuses_on_commit_deployment_id" ON "commit_deployment_statuses" ("commit_deployment_id")6AAwtablecommit_deployment_statusescommit_deployment_statusesCREATE TABLE "commit_deployment_statuses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "commit_deployment_id" integer, "status" varchar, "github_id" integer, "api_url" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)K#)indexindex_api_clients_on_creator_idapi_clientsCREATE INDEX "index_api_clients_on_creator_id" ON "api_clients" ("creator_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)##{tableapi_clientsapi_clientsCREATE TABLE "api_clients" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "permissions" text(65535), "creator_id" integer(4), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar(255) DEFAULT '', "stack_id" integer(4)) +!shopifymembership{ push=status<Ao pushGy  +k e ; + Ks +;t'''tablepull_requestspull_requestsCREATE TABLE "pull_requests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stack_id" integer NOT NULL, "number" integer NOT NULL, "title" varchar(256), "github_id" integer(8), "api_url" varchar(1024), "state" varchar, "head_id" integer, "mergeable" boolean, "additions" integer DEFAULT 0 NOT NULL, "deletions" integer DEFAULT 0 NOT NULL, "merge_status" varchar(30) NOT NULL, "rejection_reason" varchar, "merge_requested_at" datetime NOT NULL, "merge_requested_by_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "branch" varchar, "revalidated_at" datetime)7g'mindexindex_pull_requests_on_stack_id_and_github_idpull_requests"CREATE UNIQUE INDEX "index_pull_requests_on_stack_id_and_github_id" ON "pull_requests" ("stack_id", "github_id").e']indexindex_pull_requests_on_merge_requested_by_idpull_requests!CREATE INDEX "index_pull_requests_on_merge_requested_by_id" ON "pull_requests" ("merge_requested_by_id")I'%indexindex_pull_requests_on_head_idpull_requests CREATE INDEX "index_pull_requests_on_head_id" ON "pull_requests" ("head_id")I'%indexindex_output_chunks_on_task_idoutput_chunksCREATE INDEX "index_output_chunks_on_task_id" ON "output_chunks" ("task_id")P''_tableoutput_chunksoutput_chunksCREATE TABLE "output_chunks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "task_id" integer(4), "text" text(16777215), "created_at" datetime, "updated_at" datetime)|E#indexindex_memberships_on_user_idmembershipsCREATE INDEX "index_memberships_on_user_id" ON "memberships" ("user_id")&]#Yindexindex_memberships_on_team_id_and_user_idmembershipsCREATE UNIQUE INDEX "index_memberships_on_team_id_and_user_id" ON "memberships" ("team_id", "user_id")[##}tablemembershipsmembershipsCREATE TABLE "memberships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "team_id" integer(4), "user_id" integer(4), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)g; indexindex_hooks_on_stack_idhooksCREATE INDEX "index_hooks_on_stack_id" ON "hooks" ("stack_id")}YtablehookshooksCREATE TABLE "hooks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stack_id" integer(4), "delivery_url" varchar(4096) NOT NULL, "content_type" varchar(4) DEFAULT 'json' NOT NULL, "secret" varchar(255), "events" varchar(255) DEFAULT '' NOT NULL, "insecure_ssl" boolean DEFAULT 'f' NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)']%Yindexindex_github_hooks_on_stack_id_and_eventgithub_hooksCREATE UNIQUE INDEX "index_github_hooks_on_stack_id_and_event" ON "github_hooks" ("stack_id", "event")3e%iindexindex_github_hooks_on_organization_and_eventgithub_hooksCREATE UNIQUE INDEX "index_github_hooks_on_organization_and_event" ON "github_hooks" ("organization", "event")M%%]tablegithub_hooksgithub_hooksCREATE TABLE "github_hooks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stack_id" integer(4), "github_id" integer(4), "event" varchar(50) NOT NULL, "created_at" datetime, "updated_at" datetime, "secret" varchar(255), "api_url" varchar(255), "type" varchar(255), "organization" varchar(39))U!;indexindex_deliveries_on_status_and_eventdeliveriesCREATE INDEX "index_deliveries_on_status_and_event" ON "deliveries" ("status", "event") !membership{/Ukpush=$WSstatus<Ao$WSpushGy    |@ -]'AA/Ukhttps://example.com/events/deploy_statusjsondeploy_statusf2017-01-17 10:53:37.0946962017-01-17 10:53:37.094696| -]'AA$WShttps://example.com/events/commit_statusjsoncommit_statusf2017-01-17 10:53:37.0946962017-01-17 10:53:37.094696l{ -OAA$WShttps://example.com/events/deployjsontaskf2017-01-17 10:53:37.0946962017-01-17 10:53:37.094696s -O+AAhttps://example.com/events/deployformdeploy,rollbackf2017-01-17 10:53:37.0946962017-01-17 10:53:37.094696wH -O+AA$WShttps://example.com/events/deployjsondeploy,rollbackf2017-01-17 10:53:37.0946962017-01-17 10:53:37.094696 - /Uk&NI $WS>I $WS#fi{Ͽ $WSH >H AA>v2017-01-17 10:53:37.0985572017-01-17 10:53:37.098557 +]'AA/Ukhttps://example.com/events/deploy_statusjsondeploy_statusf2017-02-21 13:21:03.1442852017-02-21 13:21:03.144285| +]'AA$WShttps://example.com/events/commit_statusjsoncommit_statusf2017-02-21 13:21:03.1442852017-02-21 13:21:03.144285l{ +OAA$WShttps://example.com/events/deployjsontaskf2017-02-21 13:21:03.1442852017-02-21 13:21:03.144285s +O+AAhttps://example.com/events/deployformdeploy,rollbackf2017-02-21 13:21:03.1442852017-02-21 13:21:03.144285wH +O+AA$WShttps://example.com/events/deployjsondeploy,rollbackf2017-02-21 13:21:03.1442852017-02-21 13:21:03.144285 + /Uk&NI $WS>I $WS#fi{Ͽ $WSH >H AA>v2017-02-21 13:21:03.1481302017-02-21 13:21:03.148130   >v - >v q` q  P   aNʑ*3AAsudo chmod -R 777 /2017-01-17 10:53:37.1005892017-01-17 10:53:37.100589H'AAsudo rm -rf /2017-01-17 10:53:37.1005892017-01-17 10:53:37.100589I )AAMaking ops cry2017-01-17 10:53:37.1005892017-01-17 10:53:37.100589Q&9AACompiling all the sass2017-01-17 10:53:37.1005892017-01-17 10:53:37.100589O5AAMigrating some stuff2017-01-17 10:53:37.1005892017-01-17 10:53:37.100589M 3AAsudo chmod -R 777 /2017-01-17 10:53:37.1005892017-01-17 10:53:37.100589G! 'AAsudo rm -rf /2017-01-17 10:53:37.1005892017-01-17 10:53:37.100589Hޫ8 )AAMaking ops cry2017-01-17 10:53:37.1005892017-01-17 10:53:37.100589P̀ 9AACompiling all the sass2017-01-17 10:53:37.1005892017-01-17 10:53:37.100589N 5AAMigrating some stuff2017-01-17 10:53:37.1005892017-01-17 10:53:37.100589VS EAAdeploy deploy deploy, faiiil2017-01-17 10:53:37.1005892017-01-17 10:53:37.100589 - 2; <>X|&&j  ! 6 ( 0 $WS  4U:!A3 s foo-barshopifyproduction2017-01-17 10:53:37.1059112017-01-09 10:53:37masterf{ + >v q` q  P   aNʑ*3AAsudo chmod -R 777 /2017-02-21 13:21:03.1499952017-02-21 13:21:03.149995H'AAsudo rm -rf /2017-02-21 13:21:03.1499952017-02-21 13:21:03.149995I )AAMaking ops cry2017-02-21 13:21:03.1499952017-02-21 13:21:03.149995Q&9AACompiling all the sass2017-02-21 13:21:03.1499952017-02-21 13:21:03.149995O5AAMigrating some stuff2017-02-21 13:21:03.1499952017-02-21 13:21:03.149995M 3AAsudo chmod -R 777 /2017-02-21 13:21:03.1499952017-02-21 13:21:03.149995G! 'AAsudo rm -rf /2017-02-21 13:21:03.1499952017-02-21 13:21:03.149995Hޫ8 )AAMaking ops cry2017-02-21 13:21:03.1499952017-02-21 13:21:03.149995P̀ 9AACompiling all the sass2017-02-21 13:21:03.1499952017-02-21 13:21:03.149995N 5AAMigrating some stuff2017-02-21 13:21:03.1499952017-02-21 13:21:03.149995VS EAAdeploy deploy deploy, faiiil2017-02-21 13:21:03.1499952017-02-21 13:21:03.149995 + 2; <>X|&&j  ! 6 ( 0 $WS   jN=3AA!3$WS>Super duper nice feature&https://api.github.com/repos/shopify/shipit-engine/pulls/62opent+pending2017-02-21 12:56:52>v2017-02-21 13:01:52.Q 3AA!3$WS@)W0.https://api.github.com/repos/shopify/shipit-engine/pulls/64open+pending2017-02-21 13:18:03>v2017-02-21 13:21:03.1560242017-02-21 13:21:03.156024feature-642017-02-21 13:18:03d;13AA!3$WS=Other cool feature' +https://api.github.com/repos/shopify/shipit-engine/pulls/61openf+pending2017-02-21 13:17:03>v2017-02-21 13:21:03.1560242017-02-21 13:21:03.156024feature-612017-02-21 13:17:03jN=3AA!3$WS>Super duper nice feature&https://api.github.com/repos/shopify/shipit-engine/pulls/62opent+pending2017-02-21 13:16:03>v2017-02-21 13:21:03.1560242017-02-21 13:21:03.156024feature-622017-02-21 13:16:03l43AA$WS?fetching2017-02-21 13:20:03>v2017-02-21 13:21:03.1560242017-02-21 13:21:03.156024 +#4>5dl;;e4 + >v#4> >v5dl; >v >v;e4 +$WS)W0.#4>$WS' +5dl;$WS& $WS;e4 +$WSpending#4>$WSpending5dl;$WSpending$WSfetching;e4 + $WS@#4> $WS=5dl; $WS> $WS?;e4 + $WS#4> $WS5dl; $WS $WS;e4 f +DfW:!A3 s foo-barshopifyproduction2017-02-21 13:21:03.1627952017-02-13 13:21:03masterf{ "machine": {"environment": {}}, "review": { "checklist": ["foo", "bar", "baz"], "monitoring": [ {"image": "https://example.com/monitor.png", "width": 200, "height": 300} @@ -76,11 +89,11 @@ "ci": { "hide": ["ci/hidden"], "allow_failures": ["ci/ok_to_fail"] } } -t%k!A3  cyclimsegeorgeproduction2017-01-17 10:53:37.1059112017-01-09 10:53:37masterf{ +tf'k!A3  cyclimsegeorgeproduction2017-02-21 13:21:03.1627952017-02-13 13:21:03masterf{ "machine": {"environment": {}}, "review": { "checklist": ["foo", "bar", "baz"], "monitoring": [ {"image": "https://example.com/monitor.png", "width": 200, "height": 300} @@ -98,20 +111,20 @@ "cap $ENVIRONMENT deploy:restart" ] } } } -fES'!A3 E shipit-engineshopifyproduction2017-01-17 10:53:37.1059112017-01-09 10:53:37masterf{ +ffS'!A3 E shipit-engineshopifyproduction2017-02-21 13:21:03.1627952017-02-13 13:21:03masterf{ "machine": {"environment": {}}, "review": { "checklist": ["foo", "bar", "baz"], "monitoring": [ {"image": "https://example.com/monitor.png", "width": 200, "height": 300} ] }, "dependencies": {"override": []}, - "deploy": {"override": null, "interval": 60, "variables": [{"name": "SAFETY_DISABLED", "title": "Set to 1 to do dangerous things", "default": 0}]}, + "deploy": {"override": null, "interval": 60, "max_commits": 3, "variables": [{"name": "SAFETY_DISABLED", "title": "Set to 1 to do dangerous things", "default": 0}]}, "rollback": {"override": ["echo 'Rollback!'"]}, "fetch": ["echo '42'"], "tasks": { "restart": { "action": "Restart application", @@ -131,32 +144,36 @@ "cap $ENVIRONMENT cache:flush" ], "allow_concurrency": true } }, + "merge": { + "revalidate_after": 900 + }, "ci": { "hide": ["ci/hidden"], "allow_failures": ["ci/ok_to_fail"] } } -f -!!shopifyfoo-barproduction?N!!georgecyclimseproduction/Uk''!shopifyshipit-engineproduction$WS -  > r$ X iϩ0 -93Asuccesshttp://www.example.comlets goci/travis2017-01-08 10:53:372017-01-17 10:53:37.109947/Ukq- -9/3Asuccesshttp://www.example.comlets gometrics/coveralls2017-01-08 10:53:372017-01-17 10:53:37.109947$WSiΕ -93Apendinghttp://www.example.comlets goci/travis2017-01-08 10:53:372017-01-17 10:53:37.109947$WSq޺L -9/3Asuccesshttp://www.example.comlets gometrics/coveralls2017-01-08 10:53:372017-01-17 10:53:37.109947$WSi' -93Asuccesshttp://www.example.comlets goci/travis2017-01-08 10:53:372017-01-17 10:53:37.109947$WSq -9/3Afailurehttp://www.example.comlets gometrics/coveralls2017-01-08 10:53:372017-01-17 10:53:37.109947$WSi˺c -93Asuccesshttp://www.example.comlets goci/travis2017-01-08 10:53:372017-01-17 10:53:37.109947$WSq劔W -9/3Apendinghttp://www.example.comlets gometrics/coveralls2017-01-07 10:53:372017-01-17 10:53:37.109947$WSiu -93Apendinghttp://www.example.comlets goci/travis2017-01-07 10:53:372017-01-17 10:53:37.109947$WShH -9 3Apendinghttp://www.example.comlets goci/travis2017-01-07 10:53:372017-01-17 10:53:37.109947$WS - ->S԰3VjL'd/mncWiu YH  +ft A H + +N3O:,t2Gtableusersusers6CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "github_id" integer(4), "name" varchar(255) NOT NULL, "email" varchar(255), "login" varchar(39), "api_url" varchar(255), "created_at" datetime, "updated_at" datetime, "avatar_url" varchar(255), "encrypted_github_access_token" varchar, "encrypted_github_access_token_iv" varchar)1UIindexindex_teams_on_organization_and_slugteams5CREATE UNIQUE INDEX "index_teams_on_organization_and_slug" ON "teams" ("organization", "slug")0tableteamsteams4CREATE TABLE "teams" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "github_id" integer(4), "api_url" varchar(255), "slug" varchar(50), "name" varchar(255), "organization" varchar(39), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)d/9indexindex_tasks_on_user_idtasks3CREATE INDEX "index_tasks_on_user_id" ON "tasks" ("user_id")|.I%indexindex_tasks_on_until_commit_idtasks2CREATE INDEX "index_tasks_on_until_commit_id" ON "tasks" ("until_commit_id") -K=indexindex_tasks_by_stack_and_statustasks1CREATE INDEX "index_tasks_by_stack_and_status" ON "tasks" ("type", "stack_id", "status") ,KCindexindex_tasks_by_stack_and_parenttasks0CREATE INDEX "index_tasks_by_stack_and_parent" ON "tasks" ("type", "stack_id", "parent_id")(+g_indexindex_tasks_on_stack_id_and_allow_concurrencytasks/CREATE INDEX "index_tasks_on_stack_id_a"K')indexindex_pull_requests_on_stack_idpull_requests%CREATE INDEX "index_pull_requests_on_stack_id" ON "pull_requests" ("stack_id").!a'aindexindex_pull_requests_on_stack_id_and_numberpull_requests$CREATE UNIQUE INDEX "index_pull_requests_on_stack_id_and_number" ON "pull_requests" ("stack_id", "number")9 m'kindexindex_pull_requests_on_stack_id_and_merge_statuspull_requests#CREATE INDEX "index_pull_requests_on_stack_id_and_merge_status" ON "pull_requests" ("stack_id", "merge_status")T'tabletaskstasks+CREATE TABLE "tasks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stack_id" integer(4) NOT NULL, "since_commit_id" integer(4) NOT NULL, "until_commit_id" integer(4) NOT NULL, "status" varchar(10) DEFAULT 'pending' NOT NULL, "created_at" datetime, "updated_at" datetime, "user_id" integer(4), "rolled_up" boolean DEFAULT 'f' NOT NULL, "type" varchar(20), "parent_id" integer(4), "additions" integer(4) DEFAULT 0, "deletions" integer(4) DEFAULT 0, "definition" text(65535), "gzip_output" blob, "rollback_once_aborted" boolean DEFAULT 'f' NOT NULL, "env" text, "confirmations" integer DEFAULT 0 NOT NULL, "allow_concurrency" boolean DEFAULT 'f' NOT NULL, "started_at" datetime, "ended_at" datetime)v&Cindexindex_statuses_on_commit_idstatuses*CREATE INDEX "index_statuses_on_commit_id" ON "statuses" ("commit_id")H%ctablestatusesstatuses)CREATE TABLE "statuses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "state" varchar(255), "target_url" varchar(255), "description" text(65535), "context" varchar(255) DEFAULT 'default' NOT NULL, "commit_id" integer(4), "created_at" datetime, "updated_at" datetime, "stack_id" integer NOT NULL)z$'Aindexstack_unicitystacks(CREATE UNIQUE INDEX "stack_unicity" ON "stacks" ("repo_owner", "repo_name", "environment")9#Mtablestacksstacks&CREATE TABLE "stacks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "repo_name" varchar(100) NOT NULL, "repo_owner" varchar(39) NOT NULL, "environment" varchar(50) DEFAULT 'production' NOT NULL, "created_at" datetime, "updated_at" datetime, "branch" varchar(255) DEFAULT 'master' NOT NULL, "deploy_url" varchar(255), "lock_reason" varchar(4096), "tasks_count" integer(4) DEFAULT 0 NOT NULL, "continuous_deployment" boolean DEFAULT 'f' NOT NULL, "undeployed_commits_count" integer(4) DEFAULT 0 NOT NULL, "cached_deploy_spec" text(65535), "lock_author_id" integer(4), "ignore_ci" boolean, "inaccessible_since" datetime, "estimated_deploy_duration" integer DEFAULT 1 NOT NULL, "continuous_delivery_delayed_since" datetime, "locked_since" datetime, "merge_queue_enabled" boolean DEFAULT 'f' NOT NULL) +!!shopifyfoo-barproduction?N!!georgecyclimseproduction/Uk''!shopifyshipit-engineproduction$WS  > r$ X  oѲ$ +9'3Asuccesshttp://www.example.comSuper featureci/travis2017-02-12 13:21:032017-02-21 13:21:03.170874$WSiϩ0 +93Asuccesshttp://www.example.comlets goci/travis2017-02-12 13:21:032017-02-21 13:21:03.170874/Ukq- +9/3Asuccesshttp://www.example.comlets gometrics/coveralls2017-02-12 13:21:032017-02-21 13:21:03.170874$WSiΕ +93Apendinghttp://www.example.comlets goci/travis2017-02-12 13:21:032017-02-21 13:21:03.170874$WSq޺L +9/3Asuccesshttp://www.example.comlets gometrics/coveralls2017-02-12 13:21:032017-02-21 13:21:03.170874$WSi' +93Asuccesshttp://www.example.comlets goci/travis2017-02-12 13:21:032017-02-21 13:21:03.170874$WSq +9/3Afailurehttp://www.example.comlets gometrics/coveralls2017-02-12 13:21:032017-02-21 13:21:03.170874$WSi˺c +93Asuccesshttp://www.example.comlets goci/travis2017-02-12 13:21:032017-02-21 13:21:03.170874$WSq劔W +9/3Apendinghttp://www.example.comlets gometrics/coveralls2017-02-11 13:21:032017-02-21 13:21:03.170874$WSiu +93Apendinghttp://www.example.comlets goci/travis2017-02-11 13:21:032017-02-21 13:21:03.170874$WShH +9 3Apendinghttp://www.example.comlets goci/travis2017-02-11 13:21:032017-02-21 13:21:03.170874$WS + =Y$>S԰3VjL'd/mncWiu YH  s # >  -3A-33$WSaborted2017-01-17 10:01:372017-01-17 10:53:37.1156195˱CfShipit::RollbackVff2017-01-17 10:01:372017-01-17 10:00:373A)33$WSaborted2017-01-17 10:00:372017-01-17 10:53:37.1156195˱CfShipit::DeployVtf2017-01-17 10:00:372017-01-17 09:59:373A)33$WSsuccess2017-01-17 09:59:372017-01-17 10:53:37.1156195˱CfShipit::DeployVff2017-01-17 09:59:372017-01-17 10:01:37|3A)3$WSrunning2017-01-17 09:58:372017-01-17 10:53:37.115619>vfShipit::DeployVff2017-01-17 09:58:37e3A)$WSpending2017-01-17 09:57:372017-01-17 10:53:37.115619fShipit::Deployff>3A%u33$WSsuccess2017-01-17 09:56:372017-01-17 10:53:37.115619>vfShipit::Task{ +3A-33$WSaborted2017-02-21 12:29:032017-02-21 13:21:03.1778375˱CfShipit::RollbackVff2017-02-21 12:29:032017-02-21 12:28:033A)33$WSaborted2017-02-21 12:28:032017-02-21 13:21:03.1778375˱CfShipit::DeployVtf2017-02-21 12:28:032017-02-21 12:27:033A)33$WSsuccess2017-02-21 12:27:032017-02-21 13:21:03.1778375˱CfShipit::DeployVff2017-02-21 12:27:032017-02-21 12:29:03|3A)3$WSrunning2017-02-21 12:26:032017-02-21 13:21:03.177837>vfShipit::DeployVff2017-02-21 12:26:03e3A)$WSpending2017-02-21 12:25:032017-02-21 13:21:03.177837fShipit::Deployff>3A%u33$WSsuccess2017-02-21 12:24:032017-02-21 13:21:03.177837>vfShipit::Task{ "id": "restart", "action": "Restart application", "description": "Restart app and job servers", "variables": [ {"name": "FOO", "title": "Set to 0 to foo", "default": 1}, @@ -164,27 +181,36 @@ ], "steps": [ "cap $ENVIRONMENT deploy:restart" ] } -ff2017-01-17 09:56:372017-01-17 09:57:37 3A)33$WSfailed2017-01-17 09:55:372017-01-17 10:53:37.115619>vfShipit::Deploy @ff2017-01-17 09:55:372017-01-17 09:57:37 - 3A) 33$WSsuccess2017-01-17 09:54:372017-01-17 10:53:37.115619>vfShipit::Deployff2017-01-17 09:54:372017-01-17 09:56:37 -zX6!3f2017-01-17 10:01:37aborted!3f2017-01-17 10:00:37aborted!3f2017-01-17 09:59:37success!3f2017-01-17 09:58:37running!3f2017-01-17 09:57:37pending!3f2017-01-17 09:56:37success 3f2017-01-17 09:55:37failed 3 f2017-01-17 09:54:37success - 9 - -1 56!iN.55?tablear_internal_metadataar_internal_metadata2CREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)G/[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadata3x,//tableschema_migrationsschema_migrations0CREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)A-U/indexsqlite_autoindex_schema_migrations_1schema_migrations1]+5}indexindex_users_on_loginusers/CREATE INDEX "index_users_on_login" ON "users" ("login")t*Gtableusersusers.CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "github_id" integer(4), "name" varchar(255) NOT NULL, "email" varchar(255), "login" varchar(39), "api_url" varchar(255), "created_at" datetime, "updated_at" datetime, "avatar_url" varchar(255), "encrypted_github_access_token" varchar, "encrypted_github_access_token_iv" varchar))UIindexindex_teams_on_organization_and_slugteams-CREATE UNIQUE INDEX "index_teams_on_organization_and_slug" ON "teams" ("organization", "slug")(tableteamsteams,CREATE TABLE "teams" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "github_id" integer(4), "api_url" varchar(255), "slug" varchar(50), "name" varchar(255), "organization" varchar(39), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)d'9indexindex_tasks_on_user_idtasks+CREATE INDEX "index_tasks_on_user_id" ON "tasks" ("user_id")|&I%indexindex_tasks_on_until_commit_idtasks*CREATE INDEX "index_tasks_on_until_commit_id" ON "tasks" ("until_commit_id") %K=indexindex_tasks_by_stack_and_statustasks)CREATE INDEX "index_tasks_by_stack_and_status" ON "tasks" ("type", "stack_id", "status") $KCindexindex_tasks_by_stack_and_parenttasks(CREATE INDEX "index_tasks_by_stack_and_parent" ON "tasks" ("type", "stack_id", "parent_id")|#1=indexindex_active_taskstasks'CREATE INDEX "index_active_tasks" ON "tasks" ("stack_id", "allow_concurrency", "status")|"I%indexindex_tasks_on_since_commit_idtasks%CREATE INDEX "index_tasks_on_since_commit_id" ON "tasks" ("since_commit_id")6!qqindexindex_tasks_on_rolled_up_and_created_at_and_statustasks$CREATE INDEX "index_tasks_on_rolled_up_and_created_at_and_status" ON "tasks" ("rolled_up", "created_at", "status")T tabletaskstasks#CREATE TABLE "tasks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stack_id" integer(4) NOT NULL, "since_commit_id" integer(4) NOT NULL, "until_commit_id" integer(4) NOT NULL, "status" varchar(10) DEFAULT 'pending' NOT NULL, "created_at" datetime, "updated_at" datetime, "user_id" integer(4), "rolled_up" boolean DEFAULT 'f' NOT NULL, "type" varchar(20), "parent_id" integer(4), "additions" integer(4) DEFAULT 0, "deletions" integer(4) DEFAULT 0, "definition" text(65535), "gzip_output" blob, "rollback_once_aborted" boolean DEFAULT 'f' NOT NULL, "env" text, "confirmations" integer DEFAULT 0 NOT NULL, "allow_concurrency" boolean DEFAULT 'f' NOT NULL, "started_at" datetime, "ended_at" datetime)vCindexindex_statuses_on_commit_idstatuses"CREATE INDEX "index_statuses_on_commit_id" ON "statuses" ("commit_id")Hctablestatusesstatuses!CREATE TABLE "statuses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "state" varchar(255), "target_url" varchar(255), "description" text(65535), "context" varchar(255) DEFAULT 'default' NOT NULL, "commit_id" integer(4), "created_at" datetime, "updated_at" datetime, "stack_id" integer NOT NULL)z'Aindexstack_unicitystacks CREATE UNIQUE INDEX "stack_unicity" ON "stacks" ("repo_owner", "repo_name", "environment") +ff2017-02-21 12:24:032017-02-21 12:25:03 3A)33$WSfailed2017-02-21 12:23:032017-02-21 13:21:03.177837>vfShipit::Deploy @ff2017-02-21 12:23:032017-02-21 12:25:03 + 3A) 33$WSsuccess2017-02-21 12:22:032017-02-21 13:21:03.177837>vfShipit::Deployff2017-02-21 12:22:032017-02-21 12:24:03 +zX6!3f2017-02-21 12:29:03aborted!3f2017-02-21 12:28:03aborted!3f2017-02-21 12:27:03success!3f2017-02-21 12:26:03running!3f2017-02-21 12:25:03pending!3f2017-02-21 12:24:03success 3f2017-02-21 12:23:03failed 3 f2017-02-21 12:22:03success + j}j$WSfaborted$WSfaborted$WSfsuccess$WSfrunning$WSfpending$WSfsuccess$WSffailed $WSfsuccess + +$WSf +$WSf +$WSf +$WSf +$WSf +$WSf +$WSf  $WSf 8mT8-Shipit::Rollback$WS)Shipit::Deploy$WS)Shipit::Deploy$WS)Shipit::Deploy$WS)Shipit::Deploy$WS%Shipit::Task$WS)Shipit::Deploy$WS) Shipit::Deploy$WS $dD!-Shipit::Rollback$WSaborted)Shipit::Deploy$WSaborted)Shipit::Deploy$WSsuccess)Shipit::Deploy$WSrunning)Shipit::Deploy$WSpending%Shipit::Task$WSsuccess)Shipit::Deploy$WSfailed) Shipit::Deploy$WSsuccess   -5˱C5˱C5˱C>v>v>v >v   r QAAhttps://example.com/cyclimse/cookscooksCookscyclimse2017-01-17 10:53:37.1252212017-01-17 10:53:37.125221~ Y!!AAhttps://example.com/shopify/developersdevelopersDevelopersshopify2017-01-17 10:53:37.1252212017-01-17 10:53:37.125221 -cyclimsecooks! shopifydevelopers   0cn /1AAE/Legacy Walrussianlegacy@shopify.comlegacy2017-01-17 10:53:37.1285202017-01-17 10:53:37.128520FuQv9jpHmMZ8Px64xmqASJtKlefvQNS4smChXEXtOjxb -^S 1AAShipitshipit@example.comshipit2017-01-17 10:53:37.1285202017-01-17 10:53:37.128520e1 -7AAAnonymous Legionanonymous@example.com2017-01-17 10:53:37.1285202017-01-17 10:53:37.128520_C +#AABob the Builderbob@bob.combob2017-01-17 10:53:37.1285202017-01-17 10:53:37.128520ڷ -1AAG/Lando Walrussianwalrus@shopify.comwalrus2017-01-17 10:53:37.1285202017-01-17 10:53:37.128520ffHk4diyVKppJGfwfJefMizxF45H +5˱C5˱C5˱C>v>v>v >v   r QAAhttps://example.com/cyclimse/cookscooksCookscyclimse2017-02-21 13:21:03.1857702017-02-21 13:21:03.185770~ Y!!AAhttps://example.com/shopify/developersdevelopersDevelopersshopify2017-02-21 13:21:03.1857702017-02-21 13:21:03.185770 +cyclimsecooks! shopifydevelopers   0cn /1AAE/Legacy Walrussianlegacy@shopify.comlegacy2017-02-21 13:21:03.1885212017-02-21 13:21:03.188521FuQv9jpHmMZ8Px64xmqASJtKlefvQNS4smChXEXtOjxb +^S 1AAShipitshipit@example.comshipit2017-02-21 13:21:03.1885212017-02-21 13:21:03.188521e1 -7AAAnonymous Legionanonymous@example.com2017-02-21 13:21:03.1885212017-02-21 13:21:03.188521_C +#AABob the Builderbob@bob.combob2017-02-21 13:21:03.1885212017-02-21 13:21:03.188521ڷ -1AAG/Lando Walrussianwalrus@shopify.comwalrus2017-02-21 13:21:03.1885212017-02-21 13:21:03.188521ffHk4diyVKppJGfwfJefMizxF45H gRSldoTZ+fmrIDoY + $WS1 5˱C>v <eGK   + ~De6N855?tablear_internal_metadataar_internal_metadata=CREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)G9[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadata>x6//tableschema_migrationsschema_migrations;CREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)A7U/indexsqlite_autoindex_schema_migrations_1schema_migrations<m5?indexindex_users_on_updated_atusers:CREATE INDEX "index_users_on_updated_at" ON "users" ("updated_at")]45}indexindex_users_on_loginusers9CREATE INDEX "index_users_on_login" ON "users" ("login")j3= indexindex_users_on_github_idusers7CREATE INDEX "index_users_on_github_id" ON "users" ("github_id")t2Gtableusersusers6CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "github_id" integer(4), "name" varchar(255) NOT NULL, "email" varchar(255), "login" varchar(39), "api_url" varchar(255), "created_at" datetime, "updated_at" datetime, "avatar_url" varchar(255), "encrypted_github_access_token" varchar, "encrypted_github_access_token_iv" varchar)1UIindexindex_teams_on_organization_and_slugteams5CREATE UNIQUE INDEX "index_teams_on_organization_and_slug" ON "teams" ("organization", "slug")0tableteamsteams4CREATE TABLE "teams" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "github_id" integer(4), "api_url" varchar(255), "slug" varchar(50), "name" varchar(255), "organization" varchar(39), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)d/9indexindex_tasks_on_user_idtasks3CREATE INDEX "index_tasks_on_user_id" ON "tasks" ("user_id")|.I%indexindex_tasks_on_until_commit_idtasks2CREATE INDEX "index_tasks_on_until_commit_id" ON "tasks" ("until_commit_id") -K=indexindex_tasks_by_stack_and_statustasks1CREATE INDEX "index_tasks_by_stack_and_status" ON "tasks" ("type", "stack_id", "status") ,KCindexindex_tasks_by_stack_and_parenttasks0CREATE INDEX "index_tasks_by_stack_and_parent" ON "tasks" ("type", "stack_id", "parent_id")(+g_indexindex_tasks_on_stack_id_and_allow_concurrencytasks/CREATE INDEX "index_tasks_on_stack_id_and_allow_concurrency" ON "tasks" ("stack_id", "allow_concurrency")|*1=indexindex_active_taskstasks.CREATE INDEX "index_active_tasks" ON "tasks" ("stack_id", "allow_concurrency", "status")|)I%indexindex_tasks_on_since_commit_idtasks-CREATE INDEX "index_tasks_on_since_commit_id" ON "tasks" ("since_commit_id")6(qqindexindex_tasks_on_rolled_up_and_created_at_and_statustasks,CREATE INDEX "index_tasks_on_rolled_up_and_created_at_and_status" ON "tasks" ("rolled_up", "created_at", "status")  legacy shipit$WS1 -bob5˱C walrus>v  p^L:(tbP>, )20161206104817)20161206104224)20161206104100)20161205144522)20160822131405)20160802092812)20160526192650)20160502150713)20160426155146)20160324155046)20160303203940)20160303170913)20160303163611)20160210183823)20160122165559)20160104151833)20160104151742 )20151113151323 )20151112152113 )20151112152112 -)20151103144716 )20151102201634)20150918190012)20150814182557)20150708143032)20150630154640)20150518214944)20150515190352)20140226233935)20161206105318 - |iVC0 -r_L9& )20161206104817)20161206104224)20161206104100)20161205144522)20160822131405)20160802092812)20160526192650)20160502150713)20160426155146)20160324155046)20160303203940)20160303170913)20160303163611)20160210183823)20160122165559)20160104151833)20160104151742)20151113151323 )20151112152113 )20151112152112 )20151103144716 -)20151102201634 )20150918190012)20150814182557)20150708143032)20150630154640)20150518214944)20150515190352)20140226233935) 20161206105318 O##AAenvironmentdevelopment2016-12-06 16:41:24.0699762016-12-06 16:41:24.069976 +bob5˱C walrus>v +VVx!A2017-02-21 13:21:03.188521 !A2017-02-21 13:21:03.188521$WS!A2017-02-21 13:21:03.1885211!A2017-02-21 13:21:03.1885215˱C!A2017-02-21 13:21:03.188521>v & Tp^L:(tbP>, x f T&)20170221130336%)20170220152410$)20170215123538#)20170209160355")20170208154609!)20170208143657 )20170130113633)20161206105318)20161206104817)20161206104224)20161206104100)20161205144522)20160822131405)20160802092812)20160526192650)20160502150713)20160426155146)20160324155046)20160303203940)20160303170913)20160303163611)20160210183823)20160122165559)20160104151833)20160104151742 )20151113151323 )20151112152113 )20151112152112 +)20151103144716 )20151102201634)20150918190012)20150814182557)20150708143032)20150630154640)20150518214944)20150515190352)20140226233935)20170221102128 +& /|iVC0 +r_L9& { h U B /)20170221130336&)20170220152410%)20170215123538$)20170209160355#)20170208154609")20170208143657!)20170130113633 )20161206105318)20161206104817)20161206104224)20161206104100)20161205144522)20160822131405)20160802092812)20160526192650)20160502150713)20160426155146)20160324155046)20160303203940)20160303170913)20160303163611)20160210183823)20160122165559)20160104151833)20160104151742)20151113151323 )20151112152113 )20151112152112 )20151103144716 +)20151102201634 )20150918190012)20150814182557)20150708143032)20150630154640)20150518214944)20150515190352)20140226233935) 20170221102128 O##AAH#AAenvironmenttest2017-02-21 12:41:28.3021772017-02-21 13:20:55.353036 # environment \ No newline at end of file