SQLite format 3@ i((i-  G _ga@PP''_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")M %%]tablegithub_hooksgithub_hooks CREATE 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 !!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" ij o[ǭG/335--- - read:stack >v2015-12-04 14:58:402015-12-04 14:58:40Here Come The Walrus$WS w 533--- - read:stack - write:stack - deploy:stack - lock:stack - read:hook - write:hook >v2015-12-04 14:58:402015-12-04 14:58:40Spy 8p_QF8 users>v teams tasks.Cp statuses>S԰ stacks?N'output_chunks>X|&#memberships hooks>I%github_hooks=!deliveries commits#api_clients/w  >v$ >v/w  $P 9  $*]3AAA ?N5˱C5˱C44b3833d39def7ec65b57b42f496eb27ab4980b6Cake!2015-12-04 14:58:402015-11-26 14:58:40.000000f2015-12-02 14:58:40.0000002015-12-03 14:58:40.000000+]3AAA /Uk5˱C5˱C8e859b4c19ea7638443d43d612086948bce51701Chips!2015-12-04 14:58:402015-11-26 14:58:40.000000f2015-12-02 14:58:40.0000002015-12-03 14:58:40.0000007]13AAA $WS>v>v567578b362bf2b4df5903e1c7960929361c3abcdfix all teh things2015-12-04 14:58:402015-11-26 14:58:40.000000f2015-12-02 14:58:40.0000002015-12-03 14:58:40.0000004]%3AAA$WS>v>v467578b362bf2b4df5903e1c7960929361c3435a#yoloshipit!2015-12-04 14:58:402015-11-26 14:58:40.000000f2015-11-30 14:58:40.0000002015-12-01 14:58:40.000000V-]3AAA$WS>v>v367578b362bf2b4df5903e1c7960929361c39074fix it!2015-12-04 14:58:402015-11-26 14:58:40.000000f2015-11-28 14:58:40.0000002015-11-29 14:58:40.000000 @-]3AAA $WS>v>vf890fd8b5f2be05d1fedb763a3605ee461c39074sheep it!2015-12-04 14:58:402015-11-26 14:58:40.000000f2015-11-26 14:58:40.0000002015-11-27 14:58:40.000000-]3AAA$WS>v>v6d9278037b872fd9a6690523e411ecb3aa181355lets go2015-12-04 14:58:402015-11-26 14:58:40.000000f2015-11-24 14:58:40.0000002015-11-25 14:58:40.000000* 5˱C5˱C>v>v>v>v >v 5˱C5˱C>v>v>v>v >v YqY32015-12-04 14:58:4032015-12-04 14:58:4032015-12-04 14:58:4032015-12-04 14:58:4032015-12-04 14:58:4032015-12-04 14:58:403 2015-12-04 14:58:40 ?N/Uk$WS$WS$WS$WS $WS ZZ\O-[33Hscheduledhttps://example.com/events/deployapplication/jsondeploy{ "stack": { }, "deploy": { } }2015-12-04 14:58:402015-12-04 14:58:40 V^{ !33=membership2015-12-04 14:58:402015-12-04 14:58:401234GithubHook::OrganizationshopifyM擄 33-/Ukpush2015-12-04 14:58:402015-12-04 14:58:401234GithubHook::RepoP↨o 33-$WS+status2015-12-04 14:58:402015-12-04 14:58:401234GithubHook::RepoNžy 33-$WS*push2015-12-04 14:58:402015-12-04 14:58:401234GithubHook::Repo !shopifymembership{ push=statusI $WS#fi{Ͽ $WSH 0H 33>v2015-12-04 14:58:402015-12-04 14:58:40   >v  >v  ,Id o  Cʑ*333&jsudo chmod -R 777 /2015-12-04 14:58:402015-12-04 14:58:40='33&jsudo rm -rf /2015-12-04 14:58:402015-12-04 14:58:40> )33&jMaking ops cry2015-12-04 14:58:402015-12-04 14:58:40F&933&jCompiling all the sass2015-12-04 14:58:402015-12-04 14:58:40D533&jMigrating some stuff2015-12-04 14:58:402015-12-04 14:58:40C333$WSsudo chmod -R 777 /2015-12-04 14:58:402015-12-04 14:58:40=!'33$WSsudo rm -rf /2015-12-04 14:58:402015-12-04 14:58:40>ޫ8)33$WSMaking ops cry2015-12-04 14:58:402015-12-04 14:58:40F̀933$WSCompiling all the sass2015-12-04 14:58:402015-12-04 14:58:40D533$WSMigrating some stuff2015-12-04 14:58:402015-12-04 14:58:40LSE33$WSdeploy deploy deploy, faiiil2015-12-04 14:58:402015-12-04 14:58:40 || &j2 &j; &j < &j>X|& &j&j $WS $WS! $WS6 $WS( $WS0 $WS$WS XXG  9 yW##{tableapi_clientsapi_clientsCREP++Ytablesqlite_sequencesqlite_P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)l#//tableschema_migrationsschema_mP++Ytablesqlite_sequencP++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")uaCindexindex_commits_on_created_atcommitsCREATE INDEX "index_commits_on_created_at" ON "commits" ("created_at")ob?indexindex_commits_on_stack_idcommits CREATE INDEX "index_commits_on_stack_id" ON "commits" ("stack_id")uc!!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)Md%%]tablegithub_hooksgithub_hooks CREATE 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))3ee%iindexindex_github_hooks_on_organization_and_eventgithub_hooks CREATE UNIQUE INDEX "index_github_hooks_on_organization_and_event" ON "github_hooks" ("organization", "event")'f]%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")tgGtablehookshooksCREATE 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)gh; indexindex_hooks_on_stack_idhooksCREATE INDEX "index_hooks_on_stack_id" ON "hooks" ("stack_id")[i##}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)&j]#Yindexindex_memberships_on_team_id_and_user_idmembershipsCREATE UNIQUE INDEX "index_memberships_on_team_id_and_user_id" ON "memberships" ("team_id", "user_id") Z 3ZR:!3A sfoo-barshopifyproduction2015-12-04 14:58:402015-11-26 14:58:40.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 Ocyclimsegeorgeproduction2015-12-04 14:58:402015-11-26 14:58:40.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-12-04 14:58:402015-11-26 14:58:40.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 S05 g N 2GSIkdw9indexindex_tasks_on_user_idtasks CREATE INDEX "index_tasks_on_user_id" ON "tasks" ("user_id")|vI%indexindex_tasks_on_until_commit_idtasksCREATE INDEX "index_tasks_on_until_commit_id" ON "tasks" ("until_cyU]{5}indexindex_users_on_loginusers$CREATE INDEX "index_users_on_login" ON "users" ("login")|kE#indexindex_memberships_on_user_idmembershipsCREATE INDEX "index_memberships_on_user_id" ON "memberships" ("user_id")Pl''_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)mI'%indexindex_output_chunks_on_task_idoutput_chunksCREATE INDEX "index_output_chunks_on_task_id" ON "output_chunks" ("task_id")ngtablestacksstacksCREATE 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)zo'Aindexstack_unicitystacksCREATE UNIQUE INDEX "stack_unicity" ON "stacks" ("repo_owner", "repo_name", "environment")+p)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)vqCindexindex_statuses_on_commit_idstatusesCREATE INDEX "index_statuses_on_commit_id" ON "statuses" ("commit_id")vrKtabletaskstasksCREATE 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(10), "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)6sqqindexindex_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")|tI%indexindex_tasks_on_since_commit_idtasksCREATE INDEX "index_tasks_on_since_commit_id" ON "tasks" ("since_commit_id")gu; indexindex_tasks_on_stack_idtasksCREATE INDEX "index_tasks_on_stack_id" ON "tasks" ("stack_id")|vI%indexindex_tasks_on_until_commit_idtasksCREATE INDEX "index_tasks_on_until_commit_id" ON "tasks" ("until_commit_id")dw9indexindex_tasks_on_user_idtasks CREATE INDEX "index_tasks_on_user_id" ON "tasks" ("user_id")xtableteamsteams!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)yUIindexindex_teams_on_organization_and_slugteams"CREATE UNIQUE INDEX "index_teams_on_organization_and_slug" ON "teams" ("organization", "slug")ztableusersusers#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)) !!shopifyfoo-barproduction?N!!georgecyclimseproduction/Uk''!shopifyshipit-engineproduction$WS  R . v ( dϩ0 9A3successhttp://www.example.comlets goci/travis2015-11-25 14:58:40.0000002015-12-04 14:58:40l- 9/A3successhttp://www.example.comlets gometrics/coveralls2015-11-25 14:58:40.0000002015-12-04 14:58:40dΕ 9A3pendinghttp://www.example.comlets goci/travis2015-11-25 14:58:40.0000002015-12-04 14:58:40l޺L 9/A3successhttp://www.example.comlets gometrics/coveralls2015-11-25 14:58:40.0000002015-12-04 14:58:40d' 9A3successhttp://www.example.comlets goci/travis2015-11-25 14:58:40.0000002015-12-04 14:58:40l 9/A3failurehttp://www.example.comlets gometrics/coveralls2015-11-25 14:58:40.0000002015-12-04 14:58:40d˺c 9A3successhttp://www.example.comlets goci/travis2015-11-25 14:58:40.0000002015-12-04 14:58:40l劔W 9/A3pendinghttp://www.example.comlets gometrics/coveralls2015-11-24 14:58:40.0000002015-12-04 14:58:40du 9A3pendinghttp://www.example.comlets goci/travis2015-11-24 14:58:40.0000002015-12-04 14:58:40cH 9 A3pendinghttp://www.example.comlets goci/travis2015-11-24 14:58:40.0000002015-12-04 14:58:40 >S԰3VjL'd/mncWiu YH  R  R B Bc1A3$WSaborted2015-12-04 14:06:40.0000002015-12-04 14:58:405˱CfRollback'#%Vf]0A3$WSaborted2015-12-04 14:05:40.0000002015-12-04 14:58:405˱CfDeployVt]_A3$WSsuccess2015-12-04 14:04:40.0000002015-12-04 14:58:405˱CfDeployVf]A3$WSrunning2015-12-04 14:03:40.0000002015-12-04 14:58:40>vfDeployVfYNA3$WSpending2015-12-04 14:02:40.0000002015-12-04 14:58:40fDeployfyɆpA3O$WSsuccess2015-12-04 14:01:40.0000002015-12-04 14:58:40>vfTask{ "id": "restart", "action": "Restart application", "description": "Restart app and job servers", "steps": [ "cap $ENVIRONMENT deploy:restart" ] } fZA3$WSfailed2015-12-04 14:00:40.0000002015-12-04 14:58:40>vfDeploy @fXS A3 $WSsuccess2015-12-04 13:59:40.0000002015-12-04 14:58:40>vfDeployf }Q%+Af2015-12-04 14:06:40.000000aborted1+Af2015-12-04 14:05:40.000000aborted'#%+Af2015-12-04 14:04:40.000000success +Af2015-12-04 14:03:40.000000running&j+Af2015-12-04 14:02:40.000000pending+Af2015-12-04 14:01:40.000000success.Cp*Af2015-12-04 14:00:40.000000failed0+Af2015-12-04 13:59:40.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-12-04 14:58:402015-12-04 14:58:40p Y!!33https://example.com/shopify/developersdevelopersDevelopersshopify2015-12-04 14:58:402015-12-04 14:58:40 cyclimsecooks! shopifydevelopers MU1 -733Anonymous Legionanonymous@example.com2015-12-04 14:58:402015-12-04 14:58:40OC +#33Bob the Builderbob@bob.combob2015-12-04 14:58:402015-12-04 14:58:40Xڷ -133Lando Walrussianwalrus@shopify.comwalrus2015-12-04 14:58:402015-12-04 14:58:40 1 bob5˱C walrus>v  (p^L:( )20151112152113 )20151112152112 )20151103144716 )20151102201634)20150918190012)20150814182557)20150708143032)20150630154640)20150518214944)20150515190352)20140226233935)20151113151323 |iVC0)20151112152113 )20151112152112 )20151103144716 )20151102201634 )20150918190012)20150814182557)20150708143032)20150630154640)20150518214944)20150515190352)20140226233935) 20151113151323%$#$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")u*Cindexindex_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")r(Aindexindex_commits_on_author_idcommitsCREATE INDEX "index_commits_on_author_id" ON "commits" ("author_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))g; indexindex_tasks_on_stack_idtasksCREATE INDEX "index_tasks_on_stack_id" ON "tasks" ("stack_id") K=indexindex_tasks_by_stack_and_statustasksCREATE INDEX "index_tasks_by_stack_and_status" ON "tasks" ("type", "stack_id", "status")|I%indexindex_tasks_on_until_commit_idtasks CREATE INDEX "index_tasks_on_until_commit_id" ON "tasks" ("until_commit_id")d9indexindex_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(50), "name" varchar(255), "organization" varchar(39), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) UIindexindex_teams_on_organization_and_slugteams#CREATE UNIQUE INDEX "index_teams_on_organization_and_slug" ON "teams" ("organization", "slug")!tableusersusers$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))]"5}indexindex_users_on_loginusers%CREATE INDEX "index_users_on_login" ON "users" ("login")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")