SQLite format 3@ w.)w- ' 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-03-22 13:10:102016-03-22 13:10:10Here Come The Walrus$WS w 533--- - read:stack - write:stack - deploy:stack - lock:stack - read:hook - write:hook >v2016-03-22 13:10:102016-03-22 13:10:10Spy 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 gsg9֚k33Sfailure2016-03-22 13:10:102016-03-22 13:10:10933Spending2016-03-22 13:10:102016-03-22 13:10:10 %33usuccess+https://api.github.com/repos/shopify/shipit-engine/deployments/1/statuses/432016-03-22 13:10:102016-03-22 13:10:10 %33upending*https://api.github.com/repos/shopify/shipit-engine/deployments/1/statuses/422016-03-22 13:10:102016-03-22 13:10:10  Sk S! u4Z u3  u   u X3ǦE3312016-03-22 13:10:102016-03-22 13:10:103 33'#%2016-03-22 13:10:102016-03-22 13:10:103l33 2016-03-22 13:10:102016-03-22 13:10:103=33&j2016-03-22 13:10:102016-03-22 13:10:103P332016-03-22 13:10:102016-03-22 13:10:10u  33https://api.github.com/repos/shopify/shipit-engine/deployments/32016-03-22 13:10:102016-03-22 13:10:10uS  330https://api.github.com/repos/shopify/shipit-engine/deployments/22016-03-22 13:10:102016-03-22 13:10:10tu  33$WShttps://api.github.com/repos/shopify/shipit-engine/deployments/12016-03-22 13:10:102016-03-22 13:10:10  1E '#%2D  2:X &j ɽ 7P  0S $WSu  1E '#%2D  2:X &j ɽ 7P  0S $WSu  P  J *]3AAA ?N5˱C5˱C44b3833d39def7ec65b57b42f496eb27ab4980b6Cake!2016-03-22 13:10:102016-03-14 13:10:10.000000f2016-03-20 13:10:10.0000002016-03-21 13:10:10.000000+]3AAA /Uk5˱C5˱C8e859b4c19ea7638443d43d612086948bce51701Chips!2016-03-22 13:10:102016-03-14 13:10:10.000000f2016-03-20 13:10:10.0000002016-03-21 13:10:10.0000007]13AAA $WS>v>v567578b362bf2b4df5903e1c7960929361c3abcdfix all teh things2016-03-22 13:10:102016-03-14 13:10:10.000000f2016-03-20 13:10:10.0000002016-03-21 13:10:10.000000i] 3AAA$WS>v>v467578b362bf2b4df5903e1c7960929361c3435aMerge pull request #7 from shipit-engine/yoloshipit yoloshipit!2016-03-22 13:10:102016-03-14 13:10:10.000000f2016-03-18 13:10:10.0000002016-03-19 13:10:10.000000V-]3AAA$WS>v>v367578b362bf2b4df5903e1c7960929361c39074fix it!2016-03-22 13:10:102016-03-14 13:10:10.000000f2016-03-16 13:10:10.0000002016-03-17 13:10:10.000000 @-]3AAA $WS>v>vf890fd8b5f2be05d1fedb763a3605ee461c39074sheep it!2016-03-22 13:10:102016-03-14 13:10:10.000000f2016-03-14 13:10:10.0000002016-03-15 13:10:10.000000-]3AAA$WS>v>v6d9278037b872fd9a6690523e411ecb3aa181355lets go2016-03-22 13:10:102016-03-14 13:10:10.000000f2016-03-12 13:10:10.0000002016-03-13 13:10:10.000000* 5˱C5˱C>v>v>v>v >v 5˱C5˱C>v>v>v>v >v YqY32016-03-22 13:10:1032016-03-22 13:10:1032016-03-22 13:10:1032016-03-22 13:10:1032016-03-22 13:10:1032016-03-22 13:10:103 2016-03-22 13:10:10 ?N/Uk$WS$WS$WS$WS $WS ZZ\O-[33Hscheduledhttps://example.com/events/deployapplication/jsondeploy{ "stack": { }, "deploy": { } }2016-03-22 13:10:102016-03-22 13:10:10 Ff{ !33Mmembership2016-03-22 13:10:102016-03-22 13:10:101234Shipit::GithubHook::OrganizationshopifyU擄 33=/Ukpush2016-03-22 13:10:102016-03-22 13:10:101234Shipit::GithubHook::RepoX↨o 33=$WS+status2016-03-22 13:10:102016-03-22 13:10:101234Shipit::GithubHook::RepoVžy 33=$WS*push2016-03-22 13:10:102016-03-22 13:10:101234Shipit::GithubHook::Repo !shopifymembership{ push=statusI $WS#fi{Ͽ $WSH 0H 33>v2016-03-22 13:10:102016-03-22 13:10:10   >v  >v  ,Id o  Cʑ*333&jsudo chmod -R 777 /2016-03-22 13:10:102016-03-22 13:10:10='33&jsudo rm -rf /2016-03-22 13:10:102016-03-22 13:10:10> )33&jMaking ops cry2016-03-22 13:10:102016-03-22 13:10:10F&933&jCompiling all the sass2016-03-22 13:10:102016-03-22 13:10:10D533&jMigrating some stuff2016-03-22 13:10:102016-03-22 13:10:10C333$WSsudo chmod -R 777 /2016-03-22 13:10:102016-03-22 13:10:10=!'33$WSsudo rm -rf /2016-03-22 13:10:102016-03-22 13:10:10>ޫ8)33$WSMaking ops cry2016-03-22 13:10:102016-03-22 13:10:10F̀933$WSCompiling all the sass2016-03-22 13:10:102016-03-22 13:10:10D533$WSMigrating some stuff2016-03-22 13:10:102016-03-22 13:10:10LSE33$WSdeploy deploy deploy, faiiil2016-03-22 13:10:102016-03-22 13:10:10 || &j2 &j; &j < &j>X|& &j&j $WS $WS! $WS6 $WS( $WS0 $WS$WS  GR:!3A sfoo-barshopifyproduction2016-03-22 13:10:102016-03-14 13:10:10.000000masterf{ "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"] } } tk!3A Ocyclimsegeorgeproduction2016-03-22 13:10:102016-03-14 13:10:10.000000masterf{ "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" ] } } } f2S'!3A %shipit-engineshopifyproduction2016-03-22 13:10:102016-03-14 13:10:10.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}]}, "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 9A3successhttp://www.example.comlets goci/travis2016-03-13 13:10:10.0000002016-03-22 13:10:10l- 9/A3successhttp://www.example.comlets gometrics/coveralls2016-03-13 13:10:10.0000002016-03-22 13:10:10dΕ 9A3pendinghttp://www.example.comlets goci/travis2016-03-13 13:10:10.0000002016-03-22 13:10:10l޺L 9/A3successhttp://www.example.comlets gometrics/coveralls2016-03-13 13:10:10.0000002016-03-22 13:10:10d' 9A3successhttp://www.example.comlets goci/travis2016-03-13 13:10:10.0000002016-03-22 13:10:10l 9/A3failurehttp://www.example.comlets gometrics/coveralls2016-03-13 13:10:10.0000002016-03-22 13:10:10d˺c 9A3successhttp://www.example.comlets goci/travis2016-03-13 13:10:10.0000002016-03-22 13:10:10l劔W 9/A3pendinghttp://www.example.comlets gometrics/coveralls2016-03-12 13:10:10.0000002016-03-22 13:10:10du 9A3pendinghttp://www.example.comlets goci/travis2016-03-12 13:10:10.0000002016-03-22 13:10:10cH 9 A3pendinghttp://www.example.comlets goci/travis2016-03-12 13:10:10.0000002016-03-22 13:10:10 >S԰3VjL'd/mncWiu YH  o O o (. m1A3-$WSaborted2016-03-22 12:18:10.0000002016-03-22 13:10:105˱CfShipit::Rollback'#%Vffg0A3)$WSaborted2016-03-22 12:17:10.0000002016-03-22 13:10:105˱CfShipit::DeployVtfg_A3)$WSsuccess2016-03-22 12:16:10.0000002016-03-22 13:10:105˱CfShipit::DeployVffgA3)$WSrunning2016-03-22 12:15:10.0000002016-03-22 13:10:10>vfShipit::DeployVffcNA3)$WSpending2016-03-22 12:14:10.0000002016-03-22 13:10:10fShipit::DeployffɆpA3%u$WSsuccess2016-03-22 12:13:10.0000002016-03-22 13:10:10>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" ] } ffdA3)$WSfailed2016-03-22 12:12:10.0000002016-03-22 13:10:10>vfShipit::Deploy @ffbS A3) $WSsuccess2016-03-22 12:11:10.0000002016-03-22 13:10:10>vfShipit::Deployff }Q%+Af2016-03-22 12:18:10.000000aborted1+Af2016-03-22 12:17:10.000000aborted'#%+Af2016-03-22 12:16:10.000000success +Af2016-03-22 12:15:10.000000running&j+Af2016-03-22 12:14:10.000000pending+Af2016-03-22 12:13:10.000000success.Cp*Af2016-03-22 12:12:10.000000failed0+Af2016-03-22 12:11:10.000000success$WS 1'#% &j.Cp0 $WS  $WS1 $WS'#% $WS  $WS&j $WS $WS.Cp $WS0 $WS$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$WS0)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$WSfailed0")Shipit::Deploy$WSsuccess$WS 1'#% &j.Cp0$WS Z x  vd *=//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")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")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")(/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)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)  5˱C1 5˱C'#% 5˱C  >v&j >v.Cp >v0 >v$WS ((d Q33https://example.com/cyclimse/cookscooksCookscyclimse2016-03-22 13:10:102016-03-22 13:10:10p Y!!33https://example.com/shopify/developersdevelopersDevelopersshopify2016-03-22 13:10:102016-03-22 13:10:10 cyclimsecooks! shopifydevelopers rW1 -733Anonymous Legionanonymous@example.com2016-03-22 13:10:102016-03-22 13:10:10QC +#33Bob the Builderbob@bob.combob2016-03-22 13:10:102016-03-22 13:10:10ڷ -133E/Lando Walrussianwalrus@shopify.comwalrus2016-03-22 13:10:102016-03-22 13:10:10FuQv9jpHmMZ8Px64xmqASJtKlefvQNS4smChXEXtOjxb 1 bob5˱C walrus>v p^L:()20160303170913)20160303163611)20160210183823)20160122165559)20160104151833)20160104151742 )20151113151323 )20151112152113 )20151112152112 )20151103144716 )20151102201634)20150918190012)20150814182557)20150708143032)20150630154640)20150518214944)20150515190352)20140226233935)20160303203940 |iVC0 )20160303170913)20160303163611)20160210183823)20160122165559)20160104151833)20160104151742)20151113151323 )20151112152113 )20151112152112 )20151103144716 )20151102201634 )20150918190012)20150814182557)20150708143032)20150630154640)20150518214944)20150515190352)20140226233935) 20160303203940