SQLite format 3@ 33,3-p& 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--- - read:stack >v2017-01-17 10:53:37.0623832017-01-17 10:53:37.062383Here 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  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 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{ "stack": { }, "deploy": { } }2017-01-17 10:53:37.0875692017-01-17 10:53:37.087569 !A2017-01-17 10:53:37.087569 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=statusI $WS#fi{Ͽ $WSH >H AA>v2017-01-17 10:53:37.0985572017-01-17 10:53:37.098557   >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{ "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  cyclimsegeorgeproduction2017-01-17 10:53:37.1059112017-01-09 10:53:37masterf{ "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-engineshopifyproduction2017-01-17 10:53:37.1059112017-01-09 10:53:37masterf{ "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$ 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  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{ "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" ] } 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") 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   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 gRSldoTZ+fmrIDoY  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 # environment