SQLite format 3@ .)-r& 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 aiǭG/AA5--- - read:stack >v2016-11-30 14:48:47.4072642016-11-30 14:48:47.407264Here Come The Walrus$WSw 5AA--- - read:stack - write:stack - deploy:stack - lock:stack - read:hook - write:hook >v2016-11-30 14:48:47.4072642016-11-30 14:48:47.407264Spy 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֚kAASfailure2016-11-30 14:48:47.4146662016-11-30 14:48:47.414666GAASpending2016-11-30 14:48:47.4146662016-11-30 14:48:47.414666 %AAusuccess+https://api.github.com/repos/shopify/shipit-engine/deployments/1/statuses/432016-11-30 14:48:47.4146662016-11-30 14:48:47.414666 %AAupending*https://api.github.com/repos/shopify/shipit-engine/deployments/1/statuses/422016-11-30 14:48:47.4146662016-11-30 14:48:47.414666  Sk S! u4Z u3   }o  `+>ǦEAA2016-11-30 14:48:47.4192902016-11-30 14:48:47.419290> AA2016-11-30 14:48:47.4192902016-11-30 14:48:47.419290>lAA2016-11-30 14:48:47.4192902016-11-30 14:48:47.419290>=AA2016-11-30 14:48:47.4192902016-11-30 14:48:47.419290>PAA2016-11-30 14:48:47.4192902016-11-30 14:48:47.419290  AAhttps://api.github.com/repos/shopify/shipit-engine/deployments/32016-11-30 14:48:47.4192902016-11-30 14:48:47.419290S  AAhttps://api.github.com/repos/shopify/shipit-engine/deployments/22016-11-30 14:48:47.4192902016-11-30 14:48:47.419290~u  AAhttps://api.github.com/repos/shopify/shipit-engine/deployments/12016-11-30 14:48:47.4192902016-11-30 14:48:47.419290  E 2D 2:X  ɽ 7P  S  u E2D2:X ɽ7PS u  Q^ < Q*]3AAA ?N5˱C5˱C44b3833d39def7ec65b57b42f496eb27ab4980b6Cake!2016-09-16 11:44:472016-]A333 ?N5˱C5˱C44b3833d39def7ec65b57b42f496eb27ab4980b6Cake!2016-11-30 14:48:47.4231542016-11-22 14:48:47f2016-11-28 14:48:472016-11-29 14:48:47]A333 /Uk5˱C5˱C8e859b4c19ea7638443d43d612086948bce51701Chips!2016-11-30 14:48:47.4231542016-11-22 14:48:47f2016-11-28 14:48:472016-11-29 14:48:47)]1A333 $WS>v>v567578b362bf2b4df5903e1c7960929361c3abcdfix all teh things2016-11-30 14:48:47.4231542016-11-22 14:48:47f2016-11-28 14:48:472016-11-29 14:48:47[] A333$WS>v>v467578b362bf2b4df5903e1c7960929361c3435aMerge pull request #7 from shipit-engine/yoloshipit yoloshipit!2016-11-30 14:48:47.4231542016-11-22 14:48:47f2016-11-26 14:48:472016-11-27 14:48:47V]A333$WS>v>v367578b362bf2b4df5903e1c7960929361c39074fix it!2016-11-30 14:48:47.4231542016-11-22 14:48:47f2016-11-24 14:48:472016-11-25 14:48:47 @]A333 $WS>v>vf890fd8b5f2be05d1fedb763a3605ee461c39074sheep it!2016-11-30 14:48:47.4231542016-11-22 14:48:47f2016-11-22 14:48:472016-11-23 14:48:47]A333$WS>v>v6d9278037b872fd9a6690523e411ecb3aa181355lets go2016-11-30 14:48:47.4231542016-11-22 14:48:47f2016-11-20 14:48:472016-11-21 14:48:47* 5˱C5˱C>v>v>v>v >v 5˱C5˱C>v>v>v>v >v (fG(A2016-11-30 14:48:47.423154A2016-11-30 14:48:47.423154A2016-11-30 14:48:47.423154A2016-11-30 14:48:47.423154A2016-11-30 14:48:47.423154A2016-11-30 14:48:47.423154A 2016-11-30 14:48:47.423154 ?N/Uk$WS$WS$WS$WS $WS LL-\O-[AAHscheduledhttps://example.com/events/deployapplication/jsondeploy{ "stack": { }, "deploy": { } }2016-11-30 14:48:47.4416472016-11-30 14:48:47.441647 GG*t{ !AAMmembership2016-11-30 14:48:47.4438272016-11-30 14:48:47.4438271234Shipit::GithubHook::Organizationshopifyc擄 AA=/Ukpush2016-11-30 14:48:47.4438272016-11-30 14:48:47.4438271234Shipit::GithubHook::Repof↨o AA=$WS+status2016-11-30 14:48:47.4438272016-11-30 14:48:47.4438271234Shipit::GithubHook::Repodžy AA=$WS*push2016-11-30 14:48:47.4438272016-11-30 14:48:47.4438271234Shipit::GithubHook::Repo !shopifymembership{ push=statusI $WS#fi{Ͽ $WSH >H AA>v2016-11-30 14:48:47.4507922016-11-30 14:48:47.450792   >v  >v q` q  P   aNʑ*3AAsudo chmod -R 777 /2016-11-30 14:48:47.4527922016-11-30 14:48:47.452792H'AAsudo rm -rf /2016-11-30 14:48:47.4527922016-11-30 14:48:47.452792I )AAMaking ops cry2016-11-30 14:48:47.4527922016-11-30 14:48:47.452792Q&9AACompiling all the sass2016-11-30 14:48:47.4527922016-11-30 14:48:47.452792O5AAMigrating some stuff2016-11-30 14:48:47.4527922016-11-30 14:48:47.452792M 3AAsudo chmod -R 777 /2016-11-30 14:48:47.4527922016-11-30 14:48:47.452792G! 'AAsudo rm -rf /2016-11-30 14:48:47.4527922016-11-30 14:48:47.452792Hޫ8 )AAMaking ops cry2016-11-30 14:48:47.4527922016-11-30 14:48:47.452792P̀ 9AACompiling all the sass2016-11-30 14:48:47.4527922016-11-30 14:48:47.452792N 5AAMigrating some stuff2016-11-30 14:48:47.4527922016-11-30 14:48:47.452792VS EAAdeploy deploy deploy, faiiil2016-11-30 14:48:47.4527922016-11-30 14:48:47.452792 2; <>X|&&j  ! 6 ( 0 $WS  4U:!A3 s foo-barshopifyproduction2016-11-30 14:48:47.4574242016-11-22 14:48:47masterf{ "machine": {"environment": {}}, "review": { "checklist": ["foo", "bar", "baz"], "monitoring": [ {"image": "https://example.com/monitor.png", "width": 200, "height": 300} ] }, "dependencies": {"override": []}, "deploy": {"override": null}, "rollback": {"override": ["echo 'Rollback!'"]}, "fetch": ["echo '42'"], "tasks": { "restart": { "action": "Restart application", "description": "Restart app and job servers", "steps": [ "cap $ENVIRONMENT deploy:restart" ] } }, "ci": { "hide": ["ci/hidden"], "allow_failures": ["ci/ok_to_fail"] } } t%k!A3  cyclimsegeorgeproduction2016-11-30 14:48:47.4574242016-11-22 14:48:47masterf{ "machine": {"environment": {}}, "review": { "checklist": ["foo", "bar", "baz"], "monitoring": [ {"image": "https://example.com/monitor.png", "width": 200, "height": 300} ] }, "dependencies": {"override": []}, "deploy": {"max_commits": 2, "interval": 60, "override": null}, "rollback": {"override": ["echo 'Rollback!'"]}, "fetch": ["echo '42'"], "tasks": { "restart": { "action": "Restart application", "description": "Restart app and job servers", "steps": [ "cap $ENVIRONMENT deploy:restart" ] } } } fES'!A3 E shipit-engineshopifyproduction2016-11-30 14:48:47.4574242016-11-22 14:48:47masterf{ "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}]}, "rollback": {"override": ["echo 'Rollback!'"]}, "fetch": ["echo '42'"], "tasks": { "restart": { "action": "Restart application", "description": "Restart app and job servers", "variables": [ {"name": "FOO", "title": "Set to 0 to foo", "default": 1}, {"name": "BAR", "title": "Set to 1 to bar", "default": 0} ], "steps": [ "cap $ENVIRONMENT deploy:restart" ] }, "flush_cache": { "action": "Flush cache", "description": "Flush the application cache", "steps": [ "cap $ENVIRONMENT cache:flush" ], "allow_concurrency": true } }, "ci": { "hide": ["ci/hidden"], "allow_failures": ["ci/ok_to_fail"] } } f !!shopifyfoo-barproduction?N!!georgecyclimseproduction/Uk''!shopifyshipit-engineproduction$WS  R . v ( dϩ0 93Asuccesshttp://www.example.comlets goci/travis2016-11-21 14:48:472016-11-30 14:48:47.461104l- 9/3Asuccesshttp://www.example.comlets gometrics/coveralls2016-11-21 14:48:472016-11-30 14:48:47.461104dΕ 93Apendinghttp://www.example.comlets goci/travis2016-11-21 14:48:472016-11-30 14:48:47.461104l޺L 9/3Asuccesshttp://www.example.comlets gometrics/coveralls2016-11-21 14:48:472016-11-30 14:48:47.461104d' 93Asuccesshttp://www.example.comlets goci/travis2016-11-21 14:48:472016-11-30 14:48:47.461104l 9/3Afailurehttp://www.example.comlets gometrics/coveralls2016-11-21 14:48:472016-11-30 14:48:47.461104d˺c 93Asuccesshttp://www.example.comlets goci/travis2016-11-21 14:48:472016-11-30 14:48:47.461104l劔W 9/3Apendinghttp://www.example.comlets gometrics/coveralls2016-11-20 14:48:472016-11-30 14:48:47.461104du 93Apendinghttp://www.example.comlets goci/travis2016-11-20 14:48:472016-11-30 14:48:47.461104cH 9 3Apendinghttp://www.example.comlets goci/travis2016-11-20 14:48:472016-11-30 14:48:47.461104 >S԰3VjL'd/mncWiu YH  s # >  A3-AA$WSaborted2016-09-16 10:52:47.0000002016-09-16 11:44:475˱CfShip3A-33$WSaborted2016-11-30 13:56:472016-11-30 14:48:47.4655115˱CfShipit::RollbackVff2016-11-30 13:56:472016-11-30 13:55:473A)33$WSaborted2016-11-30 13:55:472016-11-30 14:48:47.4655115˱CfShipit::DeployVtf2016-11-30 13:55:472016-11-30 13:54:473A)33$WSsuccess2016-11-30 13:54:472016-11-30 14:48:47.4655115˱CfShipit::DeployVff2016-11-30 13:54:472016-11-30 13:56:47|3A)3$WSrunning2016-11-30 13:53:472016-11-30 14:48:47.465511>vfShipit::DeployVff2016-11-30 13:53:47e3A)$WSpending2016-11-30 13:52:472016-11-30 14:48:47.465511fShipit::Deployff>3A%u33$WSsuccess2016-11-30 13:51:472016-11-30 14:48:47.465511>vfShipit::Task{ "id": "restart", "action": "Restart application", "description": "Restart app and job servers", "variables": [ {"name": "FOO", "title": "Set to 0 to foo", "default": 1}, {"name": "BAR", "title": "Set to 1 to bar", "default": 0} ], "steps": [ "cap $ENVIRONMENT deploy:restart" ] } ff2016-11-30 13:51:472016-11-30 13:52:47 3A)33$WSfailed2016-11-30 13:50:472016-11-30 14:48:47.465511>vfShipit::Deploy @ff2016-11-30 13:50:472016-11-30 13:52:47  3A) 33$WSsuccess2016-11-30 13:49:472016-11-30 14:48:47.465511>vfShipit::Deployff2016-11-30 13:49:472016-11-30 13:51:47 zX6(Af2016-09-16 10:52:47.000000aborted(Af2016-09-!3f2016-11-30 13:56:47aborted!3f2016-11-30 13:55:47aborted!3f2016-11-30 13:54:47success!3f2016-11-30 13:53:47running!3f2016-11-30 13:52:47pending!3f2016-11-30 13:51:47success 3f2016-11-30 13:50:47failed 3 f2016-11-30 13:49:47success  j}j$WSfaborted$WSfaborted$WSfsuccess$WSfrunning$WSfpending$WSfsuccess$WSffailed $WSfsuccess 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 V  N R7S>0c*=//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")6qqindexindex_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")Ttabletaskstasks 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_idstatusesCREATE INDEX "index_statuses_on_commit_id" ON "statuses" ("commit_id")+)tablestatusesstatusesCREATE 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)z'Aindexstack_unicitystacksCREATE UNIQUE INDEX "stack_unicity" ON "stacks" ("repo_owner", "repo_name", "environment")   5˱C5˱C5˱C>v>v>v >v   r QAAhttps://example.com/cyclimse/cookscooksCookscyclimse2016-11-30 14:48:47.4739052016-11-30 14:48:47.473905~ Y!!AAhttps://example.com/shopify/developersdevelopersDevelopersshopify2016-11-30 14:48:47.4739052016-11-30 14:48:47.473905 cyclimsecooks! shopifydevelopers   0cn /1AAE/Legacy Walrussianlegacy@shopify.comlegacy2016-11-30 14:48:47.4764922016-11-30 14:48:47.476492FuQv9jpHmMZ8Px64xmqASJtKlefvQNS4smChXEXtOjxb ^S 1AAShipitshipit@example.comshipit2016-11-30 14:48:47.4764922016-11-30 14:48:47.476492e1 -7AAAnonymous Legionanonymous@example.com2016-11-30 14:48:47.4764922016-11-30 14:48:47.476492_C +#AABob the Builderbob@bob.combob2016-11-30 14:48:47.4764922016-11-30 14:48:47.476492ڷ -1AAG/Lando Walrussianwalrus@shopify.comwalrus2016-11-30 14:48:47.4764922016-11-30 14:48:47.476492ffHk4diyVKppJGfwfJefMizxF45H gRSldoTZ+fmrIDoY  legacy shipit$WS1 bob5˱C walrus>v >p^L:(tbP>)20160802092812)20160526192650)20160502150713)20160426155146)20160324155046)20160303203940)20160303170913)20160303163611)20160210183823)20160122165559)20160104151833)20160104151742 )20151113151323 )20151112152113 )20151112152112 )20151103144716 )20151102201634)20150918190012)20150814182557)20150708143032)20150630154640)20150518214944)20150515190352)20140226233935)20160822131405 &|iVC0 r_L9&)20160802092812)20160526192650)20160502150713)20160426155146)20160324155046)20160303203940)20160303170913)20160303163611)20160210183823)20160122165559)20160104151833)20160104151742)20151113151323 )20151112152113 )20151112152112 )20151103144716 )20151102201634 )20150918190012)20150814182557)20150708143032)20150630154640)20150518214944)20150515190352)20140226233935) 20160822131405