test/dummy/db/test.sqlite3 in shipit-engine-0.10.0 vs test/dummy/db/test.sqlite3 in shipit-engine-0.11.0
- old
+ new
@@ -1,57 +1,56 @@
-SQLite format 3 @ | / * | -
+SQLite format 3 @ . ) -
'
q,8 ']%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!!5tabledeliveriesdeliveriesCREATE TABLE "deliveries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "hook_id" integer(4) NOT NULL, "status" varchar(255) DEFAULT 'pending' NOT NULL, "url" varchar(4096) NOT NULL, "content_type" varchar(255) NOT NULL, "event" varchar(255) 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
o [ǭG /335---
- read:stack
->v2016-04-28 17:16:302016-04-28 17:16:30Here Come The Walrus$WS
+>v2016-07-12 14:08:572016-07-12 14:08:57Here Come The Walrus$WS
w 533 ---
- read:stack
- write:stack
- deploy:stack
- lock:stack
- read:hook
- write:hook
->v2016-04-28 17:16:302016-04-28 17:16:30Spy
ykWA2! users>v
teams tasks.Cp statuses>S
+>v2016-07-12 14:08:572016-07-12 14:08:57Spy
ykWA2! users>v
teams tasks.Cp statuses>S
stacks?N 'output_chunks>X|&#memberships hooks>I%github_hooks=!deliveries commits1commit_deployments7P!Acommit_deployment_statuses4Z#api_clients/w
- >v$ >v/w
g sg 9֚k 33Sfailure2016-04-28 17:16:302016-04-28 17:16:309 33Spending2016-04-28 17:16:302016-04-28 17:16:30 %33usuccess+https://api.github.com/repos/shopify/shipit-engine/deployments/1/statuses/432016-04-28 17:16:302016-04-28 17:16:30 %33upending*https://api.github.com/repos/shopify/shipit-engine/deployments/1/statuses/422016-04-28 17:16:302016-04-28 17:16:30
- Sk S! u4Z u3
u
u
X 3ǦE 3312016-04-28 17:16:302016-04-28 17:16:303
33'#%2016-04-28 17:16:302016-04-28 17:16:303l 33 2016-04-28 17:16:302016-04-28 17:16:303= 33&j2016-04-28 17:16:302016-04-28 17:16:303P 33 2016-04-28 17:16:302016-04-28 17:16:30u
33 https://api.github.com/repos/shopify/shipit-engine/deployments/32016-04-28 17:16:302016-04-28 17:16:30uS
33 0https://api.github.com/repos/shopify/shipit-engine/deployments/22016-04-28 17:16:302016-04-28 17:16:30tu
33$WShttps://api.github.com/repos/shopify/shipit-engine/deployments/12016-04-28 17:16:302016-04-28 17:16:30
+ >v$ >v/w
g sg 9֚k 33Sfailure2016-07-12 14:08:572016-07-12 14:08:579 33Spending2016-07-12 14:08:572016-07-12 14:08:57 %33usuccess+https://api.github.com/repos/shopify/shipit-engine/deployments/1/statuses/432016-07-12 14:08:572016-07-12 14:08:57 %33upending*https://api.github.com/repos/shopify/shipit-engine/deployments/1/statuses/422016-07-12 14:08:572016-07-12 14:08:57
+ Sk S! u4Z u3
u
u
X 3ǦE 3312016-07-12 14:08:572016-07-12 14:08:573
33'#%2016-07-12 14:08:572016-07-12 14:08:573l 33 2016-07-12 14:08:572016-07-12 14:08:573= 33&j2016-07-12 14:08:572016-07-12 14:08:573P 33 2016-07-12 14:08:572016-07-12 14:08:57u
33 https://api.github.com/repos/shopify/shipit-engine/deployments/32016-07-12 14:08:572016-07-12 14:08:57uS
33 0https://api.github.com/repos/shopify/shipit-engine/deployments/22016-07-12 14:08:572016-07-12 14:08:57tu
33$WShttps://api.github.com/repos/shopify/shipit-engine/deployments/12016-07-12 14:08:572016-07-12 14:08:57
1 E
'#%2D
2:X &j ɽ
7P
0S
$WSu
1 E '#%2D 2:X
&j ɽ 7P 0S $WSu
P
J
- * ]3AAA ?N5˱C5˱C44b3833d39def7ec65b57b42f496eb27ab4980b6Cake!2016-04-28 17:16:302016-04-20 17:16:30.000000f2016-04-26 17:16:30.0000002016-04-27 17:16:30.000000+ ]3AAA /Uk5˱C5˱C8e859b4c19ea7638443d43d612086948bce51701Chips!2016-04-28 17:16:302016-04-20 17:16:30.000000f2016-04-26 17:16:30.0000002016-04-27 17:16:30.0000007 ]13AAA $WS>v>v567578b362bf2b4df5903e1c7960929361c3abcdfix all teh things2016-04-28 17:16:302016-04-20 17:16:30.000000f2016-04-26 17:16:30.0000002016-04-27 17:16:30.000000i ]
3AAA$WS>v>v467578b362bf2b4df5903e1c7960929361c3435aMerge pull request #7 from shipit-engine/yoloshipit
+ * ]3AAA ?N5˱C5˱C44b3833d39def7ec65b57b42f496eb27ab4980b6Cake!2016-07-12 14:08:572016-07-04 14:08:57.000000f2016-07-10 14:08:57.0000002016-07-11 14:08:57.000000+ ]3AAA /Uk5˱C5˱C8e859b4c19ea7638443d43d612086948bce51701Chips!2016-07-12 14:08:572016-07-04 14:08:57.000000f2016-07-10 14:08:57.0000002016-07-11 14:08:57.0000007 ]13AAA $WS>v>v567578b362bf2b4df5903e1c7960929361c3abcdfix all teh things2016-07-12 14:08:572016-07-04 14:08:57.000000f2016-07-10 14:08:57.0000002016-07-11 14:08:57.000000i ]
3AAA$WS>v>v467578b362bf2b4df5903e1c7960929361c3435aMerge pull request #7 from shipit-engine/yoloshipit
-yoloshipit!2016-04-28 17:16:302016-04-20 17:16:30.000000f2016-04-24 17:16:30.0000002016-04-25 17:16:30.000000V- ]3AAA$WS>v>v367578b362bf2b4df5903e1c7960929361c39074fix it!2016-04-28 17:16:302016-04-20 17:16:30.000000f2016-04-22 17:16:30.0000002016-04-23 17:16:30.000000 @- ] 3AAA $WS>v>vf890fd8b5f2be05d1fedb763a3605ee461c39074sheep it!2016-04-28 17:16:302016-04-20 17:16:30.000000f2016-04-20 17:16:30.0000002016-04-21 17:16:30.000000- ]3AAA$WS>v>v6d9278037b872fd9a6690523e411ecb3aa181355lets go2016-04-28 17:16:302016-04-20 17:16:30.000000f2016-04-18 17:16:30.0000002016-04-19 17:16:30.000000*
+yoloshipit!2016-07-12 14:08:572016-07-04 14:08:57.000000f2016-07-08 14:08:57.0000002016-07-09 14:08:57.000000V- ]3AAA$WS>v>v367578b362bf2b4df5903e1c7960929361c39074fix it!2016-07-12 14:08:572016-07-04 14:08:57.000000f2016-07-06 14:08:57.0000002016-07-07 14:08:57.000000 @- ] 3AAA $WS>v>vf890fd8b5f2be05d1fedb763a3605ee461c39074sheep it!2016-07-12 14:08:572016-07-04 14:08:57.000000f2016-07-04 14:08:57.0000002016-07-05 14:08:57.000000- ]3AAA$WS>v>v6d9278037b872fd9a6690523e411ecb3aa181355lets go2016-07-12 14:08:572016-07-04 14:08:57.000000f2016-07-02 14:08:57.0000002016-07-03 14:08:57.000000*
5˱C5˱C>v>v>v>v >v
5˱C5˱C>v>v>v>v >v
- Y qY 32016-04-28 17:16:3032016-04-28 17:16:3032016-04-28 17:16:3032016-04-28 17:16:3032016-04-28 17:16:3032016-04-28 17:16:303 2016-04-28 17:16:30
+ Y qY 32016-07-12 14:08:5732016-07-12 14:08:5732016-07-12 14:08:5732016-07-12 14:08:5732016-07-12 14:08:5732016-07-12 14:08:573 2016-07-12 14:08:57
?N/Uk$WS$WS$WS$WS $WS
Z Z \ O-[ 33Hscheduledhttps://example.com/events/deployapplication/jsondeploy{
"stack": {
},
"deploy": {
}
-}2016-04-28 17:16:302016-04-28 17:16:30
F f{ !33 Mmembership2016-04-28 17:16:302016-04-28 17:16:301234Shipit::GithubHook::OrganizationshopifyU擄 33 = /Ukpush2016-04-28 17:16:302016-04-28 17:16:301234Shipit::GithubHook::RepoX↨o 33 = $WS+status2016-04-28 17:16:302016-04-28 17:16:301234Shipit::GithubHook::RepoVy 33 = $WS*push2016-04-28 17:16:302016-04-28 17:16:301234Shipit::GithubHook::Repo
+}2016-07-12 14:08:572016-07-12 14:08:57
F f{ !33 Mmembership2016-07-12 14:08:572016-07-12 14:08:571234Shipit::GithubHook::OrganizationshopifyU擄 33 = /Ukpush2016-07-12 14:08:572016-07-12 14:08:571234Shipit::GithubHook::RepoX↨o 33 = $WS+status2016-07-12 14:08:572016-07-12 14:08:571234Shipit::GithubHook::RepoVy 33 = $WS*push2016-07-12 14:08:572016-07-12 14:08:571234Shipit::GithubHook::Repo
!shopifymembership{ push= status<Ao pushGy
!membership{/Ukpush=$WSstatus<Ao$WSpushGy
'
O n@
- ] '33/Ukhttps://example.com/events/deploy_statusjsondeploy_statusf2016-04-28 17:16:302016-04-28 17:16:30n
- ] '33$WShttps://example.com/events/commit_statusjsoncommit_statusf2016-04-28 17:16:302016-04-28 17:16:30^{
- O 33$WShttps://example.com/events/deployjsontaskf2016-04-28 17:16:302016-04-28 17:16:30e
- O +33https://example.com/events/deployformdeploy,rollbackf2016-04-28 17:16:302016-04-28 17:16:30iH
- O +33$WShttps://example.com/events/deployjsondeploy,rollbackf2016-04-28 17:16:302016-04-28 17:16:30
+ ] '33/Ukhttps://example.com/events/deploy_statusjsondeploy_statusf2016-07-12 14:08:572016-07-12 14:08:57n
+ ] '33$WShttps://example.com/events/commit_statusjsoncommit_statusf2016-07-12 14:08:572016-07-12 14:08:57^{
+ O 33$WShttps://example.com/events/deployjsontaskf2016-07-12 14:08:572016-07-12 14:08:57e
+ O +33https://example.com/events/deployformdeploy,rollbackf2016-07-12 14:08:572016-07-12 14:08:57iH
+ O +33$WShttps://example.com/events/deployjsondeploy,rollbackf2016-07-12 14:08:572016-07-12 14:08:57
q,8 ']%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!!5tabledeliveriesdeliveriesCREATE TABLE "deliveries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "hook_id" integer(4) NOT NULL, "status" varchar(255) DEFAULT 'pending' NOT NULL, "url" varchar(4096) NOT NULL, "content_type" varchar(255) NOT NULL, "event" varchar(255) 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))
V
m h
-
- U nq |!1=indexindex_active_taskstasks$CREATE INDEX "index_active_tasks" ON "tasks" ("status", "stack_id", "allow_concurrency")g ; indexindex_tasks_on_stack_idtasks#CREATE INDEX "index_tasks_on_stack_id" ON "tasks" ("stack_id")| 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 NUL3e%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))z'Aindexstack_unicitystacks CREATE UNIQUE INDEX "stack_unicity" ON "stacks" ("repo_owner", "repo_name", "environment")gtablestacksstacks 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)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")
- /Uk&NI $WS>I $WS#fi{ Ͽ $WSH
0H 33>v2016-04-28 17:16:302016-04-28 17:16:30
+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))
+u
9 ?
+{EI . "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" integ']%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))z'Aindexstack_unicitystacks CREATE UNIQUE INDEX "stack_unicity" ON "stacks" ("repo_owner", "repo_name", "environment")>Wtablestacksstacks 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)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)
+ /Uk&NI $WS>I $WS#fi{ Ͽ $WSH
0H 33>v2016-07-12 14:08:572016-07-12 14:08:57
>v
- >v
,Id
o
Cʑ* 333&jsudo chmod -R 777 /2016-04-28 17:16:302016-04-28 17:16:30= '33&jsudo rm -rf /2016-04-28 17:16:302016-04-28 17:16:30> )33&jMaking ops cry2016-04-28 17:16:302016-04-28 17:16:30F& 933&jCompiling all the sass2016-04-28 17:16:302016-04-28 17:16:30D 533&jMigrating some stuff2016-04-28 17:16:302016-04-28 17:16:30C 333$WSsudo chmod -R 777 /2016-04-28 17:16:302016-04-28 17:16:30=! '33$WSsudo rm -rf /2016-04-28 17:16:302016-04-28 17:16:30>ޫ8 )33$WSMaking ops cry2016-04-28 17:16:302016-04-28 17:16:30F̀ 933$WSCompiling all the sass2016-04-28 17:16:302016-04-28 17:16:30D 533$WSMigrating some stuff2016-04-28 17:16:302016-04-28 17:16:30LS E33$WSdeploy deploy deploy, faiiil2016-04-28 17:16:302016-04-28 17:16:30
- | | &j2 &j; &j < &j>X|& &j&j $WS $WS! $WS6 $WS( $WS 0 $WS$WS
G R: !3A s foo-barshopifyproduction2016-04-28 17:16:302016-04-20 17:16:30.000000masterf{
+ >v
,Id
o
Cʑ* 333&jsudo chmod -R 777 /2016-07-12 14:08:572016-07-12 14:08:57= '33&jsudo rm -rf /2016-07-12 14:08:572016-07-12 14:08:57> )33&jMaking ops cry2016-07-12 14:08:572016-07-12 14:08:57F& 933&jCompiling all the sass2016-07-12 14:08:572016-07-12 14:08:57D 533&jMigrating some stuff2016-07-12 14:08:572016-07-12 14:08:57C 333$WSsudo chmod -R 777 /2016-07-12 14:08:572016-07-12 14:08:57=! '33$WSsudo rm -rf /2016-07-12 14:08:572016-07-12 14:08:57>ޫ8 )33$WSMaking ops cry2016-07-12 14:08:572016-07-12 14:08:57F̀ 933$WSCompiling all the sass2016-07-12 14:08:572016-07-12 14:08:57D 533$WSMigrating some stuff2016-07-12 14:08:572016-07-12 14:08:57LS E33$WSdeploy deploy deploy, faiiil2016-07-12 14:08:572016-07-12 14:08:57
+ | | &j2 &j; &j < &j>X|& &j&j $WS $WS! $WS6 $WS( $WS 0 $WS$WS
6 S: !3A s foo-barshopifyproduction2016-07-12 14:08:572016-07-04 14:08:57.000000masterf{
"machine": {"environment": {}},
"review": {
"checklist": ["foo", "bar", "baz"],
"monitoring": [
{"image": "https://example.com/monitor.png", "width": 200, "height": 300}
@@ -73,20 +72,20 @@
"ci": {
"hide": ["ci/hidden"],
"allow_failures": ["ci/ok_to_fail"]
}
}
-t k !3A O cyclimsegeorgeproduction2016-04-28 17:16:302016-04-20 17:16:30.000000masterf{
+t#k !3A cyclimsegeorgeproduction2016-07-12 14:08:572016-07-04 14:08:57.000000masterf{
"machine": {"environment": {}},
"review": {
"checklist": ["foo", "bar", "baz"],
"monitoring": [
{"image": "https://example.com/monitor.png", "width": 200, "height": 300}
]
},
"dependencies": {"override": []},
- "deploy": {"override": null},
+ "deploy": {"max_commits": 2, "interval": 60, "override": null},
"rollback": {"override": ["echo 'Rollback!'"]},
"fetch": ["echo '42'"],
"tasks": {
"restart": {
"action": "Restart application",
@@ -95,20 +94,20 @@
"cap $ENVIRONMENT deploy:restart"
]
}
}
}
-f2S '!3A % shipit-engineshopifyproduction2016-04-28 17:16:302016-04-20 17:16:30.000000masterf{
+fCS '!3A E shipit-engineshopifyproduction2016-07-12 14:08:572016-07-04 14:08:57.000000masterf{
"machine": {"environment": {}},
"review": {
"checklist": ["foo", "bar", "baz"],
"monitoring": [
{"image": "https://example.com/monitor.png", "width": 200, "height": 300}
]
},
"dependencies": {"override": []},
- "deploy": {"override": null, "variables": [{"name": "SAFETY_DISABLED", "title": "Set to 1 to do dangerous things", "default": 0}]},
+ "deploy": {"override": null, "interval": 60, "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",
@@ -135,16 +134,16 @@
"allow_failures": ["ci/ok_to_fail"]
}
}
f
!!shopifyfoo-barproduction?N! !georgecyclimseproduction/Uk''!shopifyshipit-engineproduction$WS
-
R .
v
( dϩ0 9 A3successhttp://www.example.comlets goci/travis2016-04-19 17:16:30.0000002016-04-28 17:16:30l- 9/A3successhttp://www.example.comlets gometrics/coveralls2016-04-19 17:16:30.0000002016-04-28 17:16:30dΕ 9 A3pendinghttp://www.example.comlets goci/travis2016-04-19 17:16:30.0000002016-04-28 17:16:30lL 9/A3successhttp://www.example.comlets gometrics/coveralls2016-04-19 17:16:30.0000002016-04-28 17:16:30d' 9 A3successhttp://www.example.comlets goci/travis2016-04-19 17:16:30.0000002016-04-28 17:16:30l 9/A3failurehttp://www.example.comlets gometrics/coveralls2016-04-19 17:16:30.0000002016-04-28 17:16:30d˺c 9 A3successhttp://www.example.comlets goci/travis2016-04-19 17:16:30.0000002016-04-28 17:16:30l劔W 9/A3pendinghttp://www.example.comlets gometrics/coveralls2016-04-18 17:16:30.0000002016-04-28 17:16:30du 9 A3pendinghttp://www.example.comlets goci/travis2016-04-18 17:16:30.0000002016-04-28 17:16:30cH 9 A3pendinghttp://www.example.comlets goci/travis2016-04-18 17:16:30.0000002016-04-28 17:16:30
+
R .
v
( dϩ0 9 A3successhttp://www.example.comlets goci/travis2016-07-03 14:08:57.0000002016-07-12 14:08:57l- 9/A3successhttp://www.example.comlets gometrics/coveralls2016-07-03 14:08:57.0000002016-07-12 14:08:57dΕ 9 A3pendinghttp://www.example.comlets goci/travis2016-07-03 14:08:57.0000002016-07-12 14:08:57lL 9/A3successhttp://www.example.comlets gometrics/coveralls2016-07-03 14:08:57.0000002016-07-12 14:08:57d' 9 A3successhttp://www.example.comlets goci/travis2016-07-03 14:08:57.0000002016-07-12 14:08:57l 9/A3failurehttp://www.example.comlets gometrics/coveralls2016-07-03 14:08:57.0000002016-07-12 14:08:57d˺c 9 A3successhttp://www.example.comlets goci/travis2016-07-03 14:08:57.0000002016-07-12 14:08:57l劔W 9/A3pendinghttp://www.example.comlets gometrics/coveralls2016-07-02 14:08:57.0000002016-07-12 14:08:57du 9 A3pendinghttp://www.example.comlets goci/travis2016-07-02 14:08:57.0000002016-07-12 14:08:57cH 9 A3pendinghttp://www.example.comlets goci/travis2016-07-02 14:08:57.0000002016-07-12 14:08:57
>S3VjL'd/mnc Wiu YH
-<
-< -
-
" #1 A3- AA$WSaborted2016-04-28 16:24:30.0000002016-04-28 17:16:305˱CfShipit::Rollback'#%Vff2016-04-28 16:24:30.0000002016-04-28 16:23:30.000000 0 A3) AA$WSaborted2016-04-28 16:23:30.0000002016-04-28 17:16:305˱CfShipit::DeployVtf2016-04-28 16:23:30.0000002016-04-28 16:22:30.000000 _ A3) AA$WSsuccess2016-04-28 16:22:30.0000002016-04-28 17:16:305˱CfShipit::DeployVff2016-04-28 16:22:30.0000002016-04-28 16:18:30.000000 A3) A $WSrunning2016-04-28 16:21:30.0000002016-04-28 17:16:30>vfShipit::DeployVff2016-04-28 16:21:30.000000eN A3 ) $WSpending2016-04-28 16:20:30.0000002016-04-28 17:16:30fShipit::DeployffLɆp A3% u AA$WSsuccess2016-04-28 16:19:30.0000002016-04-28 17:16:30>vfShipit::Task{
+ U
+ a
+ #1 A3- AA$WSaborted2016-07-12 13:16:57.0000002016-07-12 14:08:575˱CfShipit::Rollback'#%Vff2016-07-12 13:16:57.0000002016-07-12 13:15:57.000000 0 A3) AA$WSaborted2016-07-12 13:15:57.0000002016-07-12 14:08:575˱CfShipit::DeployVtf2016-07-12 13:15:57.0000002016-07-12 13:14:57.000000 _ A3) AA$WSsuccess2016-07-12 13:14:57.0000002016-07-12 14:08:575˱CfShipit::DeployVff2016-07-12 13:14:57.0000002016-07-12 13:16:57.000000 A3) A $WSrunning2016-07-12 13:13:57.0000002016-07-12 14:08:57>vfShipit::DeployVff2016-07-12 13:13:57.000000eN A3 ) $WSpending2016-07-12 13:12:57.0000002016-07-12 14:08:57fShipit::DeployffLɆp A3% u AA$WSsuccess2016-07-12 13:11:57.0000002016-07-12 14:08:57>vfShipit::Task{
"id": "restart",
"action": "Restart application",
"description": "Restart app and job servers",
"variables": [
{"name": "FOO", "title": "Set to 0 to foo", "default": 1},
@@ -152,24 +151,23 @@
],
"steps": [
"cap $ENVIRONMENT deploy:restart"
]
}
-ff2016-04-28 16:19:30.0000002016-04-28 16:20:30.000000 A3) AA$WSfailed2016-04-28 16:18:30.0000002016-04-28 17:16:30>vfShipit::Deploy @ff2016-04-28 16:18:30.0000002016-04-28 16:20:30.000000dS A3) $WSsuccess2016-04-28 16:17:30.0000002016-04-28 17:16:30>vfShipit::Deployff
- }Q% +Af2016-04-28 16:24:30.000000aborted1+Af2016-04-28 16:23:30.000000aborted'#%+Af2016-04-28 16:22:30.000000success +Af2016-04-28 16:21:30.000000running&j+Af2016-04-28 16:20:30.000000pending +Af2016-04-28 16:19:30.000000success.Cp*Af2016-04-28 16:18:30.000000failed 0+Af2016-04-28 16:17:30.000000success$WS
+ff2016-07-12 13:11:57.0000002016-07-12 13:12:57.000000 A3) AA$WSfailed2016-07-12 13:10:57.0000002016-07-12 14:08:57>vfShipit::Deploy @ff2016-07-12 13:10:57.0000002016-07-12 13:12:57.000000S A3) AA$WSsuccess2016-07-12 13:09:57.0000002016-07-12 14:08:57>vfShipit::Deployff2016-07-12 13:09:57.0000002016-07-12 13:11:57.000000
+ }Q% +Af2016-07-12 13:16:57.000000aborted1+Af2016-07-12 13:15:57.000000aborted'#%+Af2016-07-12 13:14:57.000000success +Af2016-07-12 13:13:57.000000running&j+Af2016-07-12 13:12:57.000000pending +Af2016-07-12 13:11:57.000000success.Cp*Af2016-07-12 13:10:57.000000failed 0+Af2016-07-12 13:09:57.000000success$WS
1'#% &j .Cp 0 $WS
- $WS1 $WS'#% $WS $WS&j $WS $WS.Cp $WS 0 $WS$WS
- Q Qg} aborted$WSf1aborted$WSf'#%success$WSf running$WSf&jpending$WSf success$WSf.Cpfailed$WSf 0success$WSf$WS
+ Q Qg} $WSfaborted1$WSfaborted'#%$WSfsuccess $WSfrunning&j$WSfpending $WSfsuccess.Cp$WSffailed 0$WSfsuccess$WS
Zv> !-Shipit::Rollback$WS'#%1) Shipit::Deploy$WS'#%) Shipit::Deploy$WS ) Shipit::Deploy$WS&j) Shipit::Deploy$WS % Shipit::Task$WS.Cp) Shipit::Deploy$WS 0) Shipit::Deploy$WS$WS
- wT1 $-Shipit::Rollback$WSaborted1")Shipit::Deploy$WSaborted'#%")Shipit::Deploy$WSsuccess ")Shipit::Deploy$WSrunning&j")Shipit::Deploy$WSpending %Shipit::Task$WSsuccess.Cp!)Shipit::Deploy$WSfailed 0")Shipit::Deploy$WSsuccess$WS
Z
+ wT1 $-Shipit::Rollback$WSaborted1")Shipit::Deploy$WSaborted'#%")Shipit::Deploy$WSsuccess ")Shipit::Deploy$WSrunning&j")Shipit::Deploy$WSpending %Shipit::Task$WSsuccess.Cp!)Shipit::Deploy$WSfailed 0")Shipit::Deploy$WSsuccess$WS
+ 1'#% &j .Cp 0$WS
U Z
-L eJfQCv +=//indexunique_schema_migrationsschema_migrations/CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l*//tableschema_migrationsschema_migrations.CREATE TABLE "schema_migrations" ("version" varchar NOT NULL)])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" ("status", "stack_id", "allow_concurrency")g ; indexindex_tasks_on_stack_idtasks#CREATE INDEX "index_tasks_on_stack_id" ON "tasks" ("stack_id")| 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)v C indexindex_statuses_on_commit_idstatuses CREATE INDEX "index_statuses_on_commit_id" ON "statuses" ("commit_id")+ )tablestatusesstatuses 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)
- 1'#% &j .Cp 0$WS
- 5˱C1 5˱C'#% 5˱C >v&j >v.Cp >v 0 >v$WS
( ( d Q 33https://example.com/cyclimse/cookscooksCookscyclimse2016-04-28 17:16:302016-04-28 17:16:30p Y!!33https://example.com/shopify/developersdevelopersDevelopersshopify2016-04-28 17:16:302016-04-28 17:16:30
- cyclimsecooks! shopifydevelopers
r W1 -7 33 Anonymous Legionanonymous@example.com2016-04-28 17:16:302016-04-28 17:16:30QC +# 33 Bob the Builderbob@bob.combob2016-04-28 17:16:302016-04-28 17:16:30ڷ -1 33 E/Lando Walrussianwalrus@shopify.comwalrus2016-04-28 17:16:302016-04-28 17:16:30FuQv9jpHmMZ8Px64xmqASJtKlefvQNS4smChXEXtOjxb
+L ?5#MU *=//indexunique_schema_migrationsschema_migrations.CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l)//tableschema_migrationsschema_migrations-CREATE TABLE "schema_migrations" ("version" varchar NOT NULL)](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)v C indexindex_statuses_on_commit_idstatuses CREATE INDEX "index_statuses_on_commit_id" ON "statuses" ("commit_id")+ )tablestatusesstatuses 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)
+ 5˱C1 5˱C'#% 5˱C >v&j >v.Cp >v 0 >v$WS
( ( d Q 33https://example.com/cyclimse/cookscooksCookscyclimse2016-07-12 14:08:572016-07-12 14:08:57p Y!!33https://example.com/shopify/developersdevelopersDevelopersshopify2016-07-12 14:08:572016-07-12 14:08:57
+ cyclimsecooks! shopifydevelopers
i ir PS 1 33 Shipitshipit@example.comshipit2016-07-12 14:08:572016-07-12 14:08:57W1 -7 33 Anonymous Legionanonymous@example.com2016-07-12 14:08:572016-07-12 14:08:57QC +# 33 Bob the Builderbob@bob.combob2016-07-12 14:08:572016-07-12 14:08:57ڷ -1 33 E/Lando Walrussianwalrus@shopify.comwalrus2016-07-12 14:08:572016-07-12 14:08:57FuQv9jpHmMZ8Px64xmqASJtKlefvQNS4smChXEXtOjxb
- 1
-bob5˱C
walrus>v
p^L:( )20160324155046)20160303203940)20160303170913)20160303163611)20160210183823)20160122165559)20160104151833)20160104151742
)20151113151323 )20151112152113 )20151112152112
-)20151103144716 )20151102201634)20150918190012)20150814182557)20150708143032)20150630154640)20150518214944)20150515190352)20140226233935)20160426155146
- r |iVC0
-r )20160324155046)20160303203940)20160303170913)20160303163611)20160210183823)20160122165559)20160104151833)20160104151742)20151113151323
)20151112152113 )20151112152112 )20151103144716
-)20151102201634 )20150918190012)20150814182557)20150708143032)20150630154640)20150518214944)20150515190352)20140226233935) 20160426155146
+
shipit$WS 1
+bob5˱C
walrus>v
b p^L:(tb )20160502150713)20160426155146)20160324155046)20160303203940)20160303170913)20160303163611)20160210183823)20160122165559)20160104151833)20160104151742
)20151113151323 )20151112152113 )20151112152112
+)20151103144716 )20151102201634)20150918190012)20150814182557)20150708143032)20150630154640)20150518214944)20150515190352)20140226233935)20160526192650
+ L |iVC0
+r_L )20160502150713)20160426155146)20160324155046)20160303203940)20160303170913)20160303163611)20160210183823)20160122165559)20160104151833)20160104151742)20151113151323
)20151112152113 )20151112152112 )20151103144716
+)20151102201634 )20150918190012)20150814182557)20150708143032)20150630154640)20150518214944)20150515190352)20140226233935) 20160526192650
\ No newline at end of file