SQLite format 3@ &N- 8 G _ghGWP''_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")t GtablehookshooksCREATE TABLE "hooks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stack_id" integer(4), "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_hooks CREATE UNIQUE INDEX "index_github_hooks_on_stack_id_and_event" ON "github_hooks" ("stack_id", "event")3 e%iindexindex_github_hooks_on_organization_and_eventgithub_hooks CREATE UNIQUE INDEX "index_github_hooks_on_organization_and_event" ON "github_hooks" ("organization", "event")F %%Otablegithub_hooksgithub_hooks CREATE TABLE "github_hooks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stack_id" integer(4), "github_id" integer(4), "event" varchar(255), "created_at" datetime, "updated_at" datetime, "secret" varchar(255), "api_url" varchar(255), "type" varchar(255), "organization" varchar(255))u !!5tabledeliveriesdeliveries CREATE 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_idcommits CREATE INDEX "index_commits_on_stack_id" ON "commits" ("stack_id")uCindexindex_commits_on_created_atcommitsCREATE INDEX "index_commits_on_created_at" ON "commits" ("created_at"){G!indexindex_commits_on_committer_idcommitsCREATE INDEX "index_commits_on_committer_id" ON "commits" ("committer_id")rAindexindex_commits_on_author_idcommitsCREATE INDEX "index_commits_on_author_id" ON "commits" ("author_id")NstablecommitscommitsCREATE 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))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" intege2 o[ǭG/335--- - read:stack >v2015-09-30 16:45:522015-09-30 16:45:52Here Come The Walrus$WS w 533--- - read:stack - write:stack - deploy:stack - lock:stack - read:hook - write:hook >v2015-09-30 16:45:522015-09-30 16:45:52Spy 8p_QF8 users>v teams tasks.Cp statuses>S԰ stacks/Uk'output_chunks>X|&#memberships hooks>I%github_hooks=!deliveries commits#api_clients/w  >v$ >v/w  P 9  +]3AAA /Uk5˱C5˱C8e859b4c19ea7638443d43d612086948bce51701Chips!2015-09-30 16:45:522015-09-22 16:45:52.000000f2015-09-28 16:45:52.0000002015-09-29 16:45:52.0000007]13AAA $WS>v>v567578b362bf2b4df5903e1c7960929361c3abcdfix all teh things2015-09-30 16:45:522015-09-22 16:45:52.000000f2015-09-28 16:45:52.0000002015-09-29 16:45:52.0000004]%3AAA$WS>v>v467578b362bf2b4df5903e1c7960929361c3435a#yoloshipit!2015-09-30 16:45:522015-09-22 16:45:52.000000f2015-09-26 16:45:52.0000002015-09-27 16:45:52.000000V-]3AAA$WS>v>v367578b362bf2b4df5903e1c7960929361c39074fix it!2015-09-30 16:45:522015-09-22 16:45:52.000000f2015-09-24 16:45:52.0000002015-09-25 16:45:52.000000 @-]3AAA $WS>v>vf890fd8b5f2be05d1fedb763a3605ee461c39074sheep it!2015-09-30 16:45:522015-09-22 16:45:52.000000f2015-09-22 16:45:52.0000002015-09-23 16:45:52.000000-]3AAA$WS>v>v6d9278037b872fd9a6690523e411ecb3aa181355lets go2015-09-30 16:45:522015-09-22 16:45:52.000000f2015-09-20 16:45:52.0000002015-09-21 16:45:52.000000* 5˱C>v>v>v>v >v 5˱C>v>v>v>v >v qq32015-09-30 16:45:5232015-09-30 16:45:5232015-09-30 16:45:5232015-09-30 16:45:5232015-09-30 16:45:523 2015-09-30 16:45:52 /Uk$WS$WS$WS$WS $WS ZZ\O-[33Hscheduledhttps://example.com/events/deployapplication/jsondeploy{ "stack": { }, "deploy": { } }2015-09-30 16:45:522015-09-30 16:45:52 V^{ !33=membership2015-09-25 15:56:162015-09-25 15:56:161234GithubHook::OrganizationshopifyO˸2 ^{ !33=membership2015-09-30 16:45:522015-09-30 16:45:521234GithubHook::OrganizationshopifyM擄 33-/Ukpush2015-09-30 16:45:522015-09-30 16:45:521234GithubHook::RepoP↨o 33-$WS+status2015-09-30 16:45:522015-09-30 16:45:521234GithubHook::RepoNžy 33-$WS*push2015-09-30 16:45:522015-09-30 16:45:521234GithubHook::Repo !shopifymembership{!shopifymembership{ push=statusI $WS#fi{Ͽ $WSH 0H 33>v2015-09-30 16:45:522015-09-30 16:45:52   >v  >v  ,Id o  Cʑ*333&jsudo chmod -R 777 /2015-09-30 16:45:522015-09-30 16:45:52='33&jsudo rm -rf /2015-09-30 16:45:522015-09-30 16:45:52> )33&jMaking ops cry2015-09-30 16:45:522015-09-30 16:45:52F&933&jCompiling all the sass2015-09-30 16:45:522015-09-30 16:45:52D533&jMigrating some stuff2015-09-30 16:45:522015-09-30 16:45:52C333$WSsudo chmod -R 777 /2015-09-30 16:45:522015-09-30 16:45:52=!'33$WSsudo rm -rf /2015-09-30 16:45:522015-09-30 16:45:52>ޫ8)33$WSMaking ops cry2015-09-30 16:45:522015-09-30 16:45:52F̀933$WSCompiling all the sass2015-09-30 16:45:522015-09-30 16:45:52D533$WSMigrating some stuff2015-09-30 16:45:522015-09-30 16:45:52LSE33$WSdeploy deploy deploy, faiiil2015-09-30 16:45:522015-09-30 16:45:52 || &j2 &j; &j < &j>X|& &j&j $WS $WS! $WS6 $WS( $WS0 $WS$WS __N 9 yW##{tableapi_clientsapi_clP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)P++Ytablesqlite_sP++Ytablesqlite_sequencesqlite_sequenceCP++Ytablesqlite_sequencesqlite_sequP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)l"//tableschema_migrationsschema_migrations%CREATE TABLE "schema_migrations" ("version" varchar NOT NULL)#=//indexunique_schema_migrationsschema_migrations&CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")$##{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))%K#)indexindex_api_clients_on_creator_idapi_clientsCREATE INDEX "index_api_clients_on_creator_id" ON "api_clients" ("creator_id")N&stablecommitscommitsCREATE 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))r'Aindexindex_commits_on_author_idcommitsCREATE INDEX "index_commits_on_author_id" ON "commits" ("author_id"){(G!indexindex_commits_on_committer_idcommitsCREATE INDEX "index_commits_on_committer_id" ON "commits" ("committer_id")u)Cindexindex_commits_on_created_atcommitsCREATE INDEX "index_commits_on_created_at" ON "commits" ("created_at")o*?indexindex_commits_on_stack_idcommits CREATE INDEX "index_commits_on_stack_id" ON "commits" ("stack_id")u+!!5tabledeliveriesdeliveries CREATE 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)F,%%Otablegithub_hooksgithub_hooks CREATE TABLE "github_hooks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stack_id" integer(4), "github_id" integer(4), "event" varchar(255), "created_at" datetime, "updated_at" datetime, "secret" varchar(255), "api_url" varchar(255), "type" varchar(255), "organization" varchar(255))3-e%iindexindex_github_hooks_on_organization_and_eventgithub_hooks CREATE UNIQUE INDEX "index_github_hooks_on_organization_and_event" ON "github_hooks" ("organization", "event")'.]%Yindexindex_github_hooks_on_stack_id_and_eventgithub_hooks CREATE UNIQUE INDEX "index_github_hooks_on_stack_id_and_event" ON "github_hooks" ("stack_id", "event")t/GtablehookshooksCREATE TABLE "hooks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stack_id" integer(4), "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)g0; indexindex_hooks_on_stack_idhooksCREATE INDEX "index_hooks_on_stack_id" ON "hooks" ("stack_id")[1##}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)&2]#Yindexindex_memberships_on_team_id_and_user_idmembershipsCREATE UNIQUE INDEX "index_memberships_on_team_id_and_user_id" ON "memberships" ("team_id", "user_id")  3 3k!3A Ocyclimsegeorgeproduction2015-09-30 16:45:522015-09-22 16:45:52.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" ] } } } f?S'!3A ?shipit-engineshopifyproduction2015-09-30 16:45:522015-09-22 16:45:52.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", "steps": [ "cap $ENVIRONMENT deploy:restart" ] } }, "ci": { "hide": ["ci/hidden"], "allow_failures": ["ci/ok_to_fail"] } } t M*0 d K /FMDhC&2]#Yindexindex5I'%indexindex_output_chunkd?9indexindex_tasks_on_user_idtasks CREATE INDEX "index_tasks_on_user_id" ON "tasks" ("user_id")|>I%indexindex_tasks_on_until_commit_idtasksCREATE INDEX "index_tasks_on_until_commit_id" ON "tasks" ("untilA]C5}indexindex_users_on_loginusers$CREATE INDEX "index_users_on_login" ON "users" ("login")|3E#indexindex_memberships_on_user_idmembershipsCREATE INDEX "index_memberships_on_user_id" ON "memberships" ("user_id")P4''_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)5I'%indexindex_output_chunks_on_task_idoutput_chunksCREATE INDEX "index_output_chunks_on_task_id" ON "output_chunks" ("task_id")6itablestacksstacksCREATE TABLE "stacks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "repo_name" varchar(255) NOT NULL, "repo_owner" varchar(255) NOT NULL, "environment" varchar(255) DEFAULT 'production' NOT NULL, "created_at" datetime, "updated_at" datetime, "branch" varchar(255) DEFAULT 'master' NOT NULL, "deploy_url" varchar(255), "lock_reason" varchar(255), "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)z7'Aindexstack_unicitystacksCREATE UNIQUE INDEX "stack_unicity" ON "stacks" ("repo_owner", "repo_name", "environment")+8)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)v9Cindexindex_statuses_on_commit_idstatusesCREATE INDEX "index_statuses_on_commit_id" ON "statuses" ("commit_id")x:OtabletaskstasksCREATE 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(255) DEFAULT 'pending' NOT NULL, "created_at" datetime, "updated_at" datetime, "user_id" integer(4), "rolled_up" boolean DEFAULT 'f' NOT NULL, "type" varchar(255), "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)6;qqindexindex_tasks_on_rolled_up_and_created_at_and_statustasksCREATE INDEX "index_tasks_on_rolled_up_and_created_at_and_status" ON "tasks" ("rolled_up", "created_at", "status")|<I%indexindex_tasks_on_since_commit_idtasksCREATE INDEX "index_tasks_on_since_commit_id" ON "tasks" ("since_commit_id")g=; indexindex_tasks_on_stack_idtasksCREATE INDEX "index_tasks_on_stack_id" ON "tasks" ("stack_id")|>I%indexindex_tasks_on_until_commit_idtasksCREATE INDEX "index_tasks_on_until_commit_id" ON "tasks" ("until_commit_id")d?9indexindex_tasks_on_user_idtasks CREATE INDEX "index_tasks_on_user_id" ON "tasks" ("user_id")@tableteamsteams!CREATE TABLE "teams" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "github_id" integer(4), "api_url" varchar(255), "slug" varchar(255), "name" varchar(255), "organization" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)AUIindexindex_teams_on_organization_and_slugteams"CREATE UNIQUE INDEX "index_teams_on_organization_and_slug" ON "teams" ("organization", "slug") Btableusersusers#CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "github_id" integer(4), "name" varchar(255) NOT NULL, "email" varchar(255), "login" varchar(255), "api_url" varchar(255), "created_at" datetime, "updated_at" datetime, "avatar_url" varchar(255)) !!georgecyclimseproduction/Uk''!shopifyshipit-engineproduction$WS  R . v ( dϩ0 9A3successhttp://www.example.comlets goci/travis2015-09-21 16:45:52.0000002015-09-30 16:45:52l- 9/A3successhttp://www.example.comlets gometrics/coveralls2015-09-21 16:45:52.0000002015-09-30 16:45:52dΕ 9A3pendinghttp://www.example.comlets goci/travis2015-09-21 16:45:52.0000002015-09-30 16:45:52l޺L 9/A3successhttp://www.example.comlets gometrics/coveralls2015-09-21 16:45:52.0000002015-09-30 16:45:52d' 9A3successhttp://www.example.comlets goci/travis2015-09-21 16:45:52.0000002015-09-30 16:45:52l 9/A3failurehttp://www.example.comlets gometrics/coveralls2015-09-21 16:45:52.0000002015-09-30 16:45:52d˺c 9A3successhttp://www.example.comlets goci/travis2015-09-21 16:45:52.0000002015-09-30 16:45:52l劔W 9/A3pendinghttp://www.example.comlets gometrics/coveralls2015-09-20 16:45:52.0000002015-09-30 16:45:52du 9A3pendinghttp://www.example.comlets goci/travis2015-09-20 16:45:52.0000002015-09-30 16:45:52cH 9 A3pendinghttp://www.example.comlets goci/travis2015-09-20 16:45:52.0000002015-09-30 16:45:52 >S԰3VjL'd/mncWiu YH  R  R B Bc1A3$WSaborted2015-09-30 15:53:52.0000002015-09-30 16:45:525˱CfRollback'#%Vf]0A3$WSaborted2015-09-30 15:52:52.0000002015-09-30 16:45:525˱CfDeployVt]_A3$WSsuccess2015-09-30 15:51:52.0000002015-09-30 16:45:525˱CfDeployVf]A3$WSrunning2015-09-30 15:50:52.0000002015-09-30 16:45:52>vfDeployVfYNA3$WSpending2015-09-30 15:49:52.0000002015-09-30 16:45:52fDeployfyɆpA3O$WSsuccess2015-09-30 15:48:52.0000002015-09-30 16:45:52>vfTask{ "id": "restart", "action": "Restart application", "description": "Restart app and job servers", "steps": [ "cap $ENVIRONMENT deploy:restart" ] } fZA3$WSfailed2015-09-30 15:47:52.0000002015-09-30 16:45:52>vfDeploy @fXS A3 $WSsuccess2015-09-30 15:46:52.0000002015-09-30 16:45:52>vfDeployf }Q%+Af2015-09-30 15:53:52.000000aborted1+Af2015-09-30 15:52:52.000000aborted'#%+Af2015-09-30 15:51:52.000000success +Af2015-09-30 15:50:52.000000running&j+Af2015-09-30 15:49:52.000000pending+Af2015-09-30 15:48:52.000000success.Cp*Af2015-09-30 15:47:52.000000failed0+Af2015-09-30 15:46:52.000000success$WS 1'#% &j.Cp0 $WS  $WS1 $WS'#% $WS  $WS&j $WS $WS.Cp $WS0 $WS$WS 1'#% &j.Cp0$WS  5˱C1 5˱C'#% 5˱C  >v&j >v.Cp >v0 >v$WS ((d Q33https://example.com/cyclimse/cookscooksCookscyclimse2015-09-30 16:45:522015-09-30 16:45:52p Y!!33https://example.com/shopify/developersdevelopersDevelopersshopify2015-09-30 16:45:522015-09-30 16:45:52 cyclimsecooks! shopifydevelopers MU1 -733Anonymous Legionanonymous@example.com2015-09-30 16:45:522015-09-30 16:45:52OC +#33Bob the Builderbob@bob.combob2015-09-30 16:45:522015-09-30 16:45:52Xڷ -133Lando Walrussianwalrus@shopify.comwalrus2015-09-30 16:45:522015-09-30 16:45:52 1 bob5˱C walrus>v )20150814182557)20150708143032)20150630154640)20150518214944)20150515190352)20140226233935)20150918190012 ||)20150814182557)20150708143032)20150630154640)20150518214944)20150515190352)20140226233935) 20150918190012