test/dummy/db/test.sqlite3 in shipit-engine-0.1.0 vs test/dummy/db/test.sqlite3 in shipit-engine-0.2.0

- old
+ new

@@ -1,43 +1,43 @@ -SQLite format 3@ &- 8 G +SQLite format 3@ B&B- 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" integ2 o[ǭG/335--- +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" integeR o[ǭG/335--- - read:stack ->v2015-06-15 15:40:422015-06-15 15:40:42Here Come The Walrus$WS +>v2015-08-21 01:13:132015-08-21 01:13:13Here Come The Walrus$WS w 533--- - read:stack - write:stack - deploy:stack - lock:stack - read:hook - write:hook ->v2015-06-15 15:40:422015-06-15 15:40:42Spy 8p_QF8 users>v teams -tasks.Cp statuses>S԰ stacks/Uk'output_chunks6#memberships hooks#fi{%github_hooks=!deliveries commits#api_clients/w - >v$ >v/w  P 9  +]3AAA /Uk5˱C5˱C8e859b4c19ea7638443d43d612086948bce51701Chips!2015-06-15 15:40:422015-06-07 15:40:42.000000f2015-06-13 15:40:42.0000002015-06-14 15:40:42.0000007]13AAA $WS>v>v567578b362bf2b4df5903e1c7960929361c3abcdfix all teh things2015-06-15 15:40:422015-06-07 15:40:42.000000f2015-06-13 15:40:42.0000002015-06-14 15:40:42.0000004]%3AAA$WS>v>v467578b362bf2b4df5903e1c7960929361c3435a#yoloshipit!2015-06-15 15:40:422015-06-07 15:40:42.000000f2015-06-11 15:40:42.0000002015-06-12 15:40:42.000000V-]3AAA$WS>v>v367578b362bf2b4df5903e1c7960929361c39074fix it!2015-06-15 15:40:422015-06-07 15:40:42.000000f2015-06-09 15:40:42.0000002015-06-10 15:40:42.000000 @-]3AAA $WS>v>vf890fd8b5f2be05d1fedb763a3605ee461c39074sheep it!2015-06-15 15:40:422015-06-07 15:40:42.000000f2015-06-07 15:40:42.0000002015-06-08 15:40:42.000000-]3AAA$WS>v>v6d9278037b872fd9a6690523e411ecb3aa181355lets go2015-06-15 15:40:422015-06-07 15:40:42.000000f2015-06-05 15:40:42.0000002015-06-06 15:40:42.000000* +>v2015-08-21 01:13:132015-08-21 01:13:13Spy 8p_QF8 users>v teams +tasks.Cp statuses>S԰ stacks/Uk'output_chunks>X|&#memberships hooks#fi{%github_hooks=!deliveries commits#api_clients/w + >v$ >v/w  P 9  +]3AAA /Uk5˱C5˱C8e859b4c19ea7638443d43d612086948bce51701Chips!2015-08-21 01:13:132015-08-13 01:13:13.000000f2015-08-19 01:13:13.0000002015-08-20 01:13:13.0000007]13AAA $WS>v>v567578b362bf2b4df5903e1c7960929361c3abcdfix all teh things2015-08-21 01:13:132015-08-13 01:13:13.000000f2015-08-19 01:13:13.0000002015-08-20 01:13:13.0000004]%3AAA$WS>v>v467578b362bf2b4df5903e1c7960929361c3435a#yoloshipit!2015-08-21 01:13:132015-08-13 01:13:13.000000f2015-08-17 01:13:13.0000002015-08-18 01:13:13.000000V-]3AAA$WS>v>v367578b362bf2b4df5903e1c7960929361c39074fix it!2015-08-21 01:13:132015-08-13 01:13:13.000000f2015-08-15 01:13:13.0000002015-08-16 01:13:13.000000 @-]3AAA $WS>v>vf890fd8b5f2be05d1fedb763a3605ee461c39074sheep it!2015-08-21 01:13:132015-08-13 01:13:13.000000f2015-08-13 01:13:13.0000002015-08-14 01:13:13.000000-]3AAA$WS>v>v6d9278037b872fd9a6690523e411ecb3aa181355lets go2015-08-21 01:13:132015-08-13 01:13:13.000000f2015-08-11 01:13:13.0000002015-08-12 01:13:13.000000* 5˱C>v>v>v>v >v 5˱C>v>v>v>v >v -qq32015-06-15 15:40:4232015-06-15 15:40:4232015-06-15 15:40:4232015-06-15 15:40:4232015-06-15 15:40:423 2015-06-15 15:40:42 +qq32015-08-21 01:13:1332015-08-21 01:13:1332015-08-21 01:13:1332015-08-21 01:13:1332015-08-21 01:13:133 2015-08-21 01:13:13 /Uk$WS$WS$WS$WS $WS ZZ\O-[33Hscheduledhttps://example.com/events/deployapplication/jsondeploy{ "stack": { }, "deploy": { } -}2015-06-15 15:40:422015-06-15 15:40:42 V^{ !33=membership2015-06-15 15:40:422015-06-15 15:40:421234GithubHook::OrganizationshopifyM擄 33-/Ukpush2015-06-15 15:40:422015-06-15 15:40:421234GithubHook::RepoP↨o 33-$WS+status2015-06-15 15:40:422015-06-15 15:40:421234GithubHook::RepoNžy 33-$WS*push2015-06-15 15:40:422015-06-15 15:40:421234GithubHook::Repo +}2015-08-21 01:13:132015-08-21 01:13:13 V^{ !33=membership2015-08-21 01:13:132015-08-21 01:13:131234GithubHook::OrganizationshopifyM擄 33-/Ukpush2015-08-21 01:13:132015-08-21 01:13:131234GithubHook::RepoP↨o 33-$WS+status2015-08-21 01:13:132015-08-21 01:13:131234GithubHook::RepoNžy 33-$WS*push2015-08-21 01:13:132015-08-21 01:13:131234GithubHook::Repo !shopifymembership{ push=status<Ao pushGy !membership{/Ukpush=$WSstatus<Ao$WSpushGy '^{ -O33$WShttps://example.com/events/deployjsontaskf2015-06-15 15:40:422015-06-15 15:40:42e -O+33https://example.com/events/deployformdeploy,rollbackf2015-06-15 15:40:422015-06-15 15:40:42iH -O+33$WShttps://example.com/events/deployjsondeploy,rollbackf2015-06-15 15:40:422015-06-15 15:40:42 - $WS#fi{Ͽ $WSH 0H 33>v2015-06-15 15:40:422015-06-15 15:40:42 +O33$WShttps://example.com/events/deployjsontaskf2015-08-21 01:13:132015-08-21 01:13:13e +O+33https://example.com/events/deployformdeploy,rollbackf2015-08-21 01:13:132015-08-21 01:13:13iH +O+33$WShttps://example.com/events/deployjsondeploy,rollbackf2015-08-21 01:13:132015-08-21 01:13:13 + $WS#fi{Ͽ $WSH 0H 33>v2015-08-21 01:13:132015-08-21 01:13:13   >v - >v IIdC333$WSsudo chmod -R 777 /2015-06-15 15:40:422015-06-15 15:40:42=!'33$WSsudo rm -rf /2015-06-15 15:40:422015-06-15 15:40:42>ޫ8)33$WSMaking ops cry2015-06-15 15:40:422015-06-15 15:40:42F̀933$WSCompiling all the sass2015-06-15 15:40:422015-06-15 15:40:42D533$WSMigrating some stuff2015-06-15 15:40:422015-06-15 15:40:42LSE33$WSdeploy deploy deploy, faiiil2015-06-15 15:40:422015-06-15 15:40:42 - $WS $WS! $WS6 $WS( $WS0 $WS$WS PPA~ 3  wV##{tableapi_clientsapi_clientsCREATE TABLE "api_clients" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "permissions" text(6P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequenceP++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")  - x -k!3A Ocyclimsegeorgeproduction2015-06-15 15:40:422015-06-07 15:40:42.000000masterf{ + >v  ,Id o  Cʑ*333&jsudo chmod -R 777 /2015-08-21 01:13:132015-08-21 01:13:13='33&jsudo rm -rf /2015-08-21 01:13:132015-08-21 01:13:13> )33&jMaking ops cry2015-08-21 01:13:132015-08-21 01:13:13F&933&jCompiling all the sass2015-08-21 01:13:132015-08-21 01:13:13D533&jMigrating some stuff2015-08-21 01:13:132015-08-21 01:13:13C333$WSsudo chmod -R 777 /2015-08-21 01:13:132015-08-21 01:13:13=!'33$WSsudo rm -rf /2015-08-21 01:13:132015-08-21 01:13:13>ޫ8)33$WSMaking ops cry2015-08-21 01:13:132015-08-21 01:13:13F̀933$WSCompiling all the sass2015-08-21 01:13:132015-08-21 01:13:13D533$WSMigrating some stuff2015-08-21 01:13:132015-08-21 01:13:13LSE33$WSdeploy deploy deploy, faiiil2015-08-21 01:13:132015-08-21 01:13:13 + || &j2 &j; &j < &j>X|& &j&j $WS $WS! $WS6 $WS( $WS0 $WS$WS __N 9 yW##{tableapi_clientsapi_clientsCREATE TABLE "api_clients" ("iP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(naP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seqP++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")D##{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))EK#)indexindex_api_clients_on_creator_idapi_clientsCREATE INDEX "index_api_clients_on_creator_id" ON "api_clients" ("creator_id")NFstablecommitscommitsCREATE 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))rGAindexindex_commits_on_author_idcommitsCREATE INDEX "index_commits_on_author_id" ON "commits" ("author_id"){HG!indexindex_commits_on_committer_idcommitsCREATE INDEX "index_commits_on_committer_id" ON "commits" ("committer_id")uICindexindex_commits_on_created_atcommitsCREATE INDEX "index_commits_on_created_at" ON "commits" ("created_at")oJ?indexindex_commits_on_stack_idcommits CREATE INDEX "index_commits_on_stack_id" ON "commits" ("stack_id")uK!!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)FL%%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))3Me%iindexindex_github_hooks_on_organization_and_eventgithub_hooks CREATE UNIQUE INDEX "index_github_hooks_on_organization_and_event" ON "github_hooks" ("organization", "event")'N]%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")tOGtablehookshooksCREATE 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)gP; indexindex_hooks_on_stack_idhooksCREATE INDEX "index_hooks_on_stack_id" ON "hooks" ("stack_id")[Q##}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)&R]#Yindexindex_memberships_on_team_id_and_user_idmembershipsCREATE UNIQUE INDEX "index_memberships_on_team_id_and_user_id" ON "memberships" ("team_id", "user_id")  + +k!3A Ocyclimsegeorgeproduction2015-08-21 01:13:132015-08-13 01:13:13.000000masterf{ "machine": {"environment": {}}, "review": { "checklist": ["foo", "bar", "baz"], "monitoring": [ {"image": "https://example.com/monitor.png", "width": 200, "height": 300} @@ -55,20 +55,20 @@ "cap $ENVIRONMENT deploy:restart" ] } } } -fS!3AOshipit2shopifyproduction2015-06-15 15:40:422015-06-07 15:40:42.000000masterf{ +fmS'!3A shipit-engineshopifyproduction2015-08-21 01:13:132015-08-13 01:13:13.000000masterf{ "machine": {"environment": {}}, "review": { "checklist": ["foo", "bar", "baz"], "monitoring": [ {"image": "https://example.com/monitor.png", "width": 200, "height": 300} ] }, "dependencies": {"override": []}, - "deploy": {"override": null}, + "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", @@ -77,31 +77,32 @@ "cap $ENVIRONMENT deploy:restart" ] } } } -t rf - ] F ,DPL[stablecommitscommitsCREATE TABLE "com5I'%indexindex_output_chunks_on_task_idoutput_chunksCREATE INDEX "index_output_chunks_on_task_id" ON "output_chunkd?9indexindex_tasks_on_user_idtasks CREATE INDEX "index_tasks_on_user_id" ON "tasks" ("user_id")|>IAUIindexindex_teams_on_organization_and_slugteams"CREATE UNIQUE INDEX "index_teams_on_organization_and_]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")h6+tablestacksstacksCREATE 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)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"):tabletaskstasksCREATE 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(16777215))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!!shopifyshipit2production$WS -  R . v ( dϩ0 9A3successhttp://www.example.comlets goci/travis2015-06-06 15:40:42.0000002015-06-15 15:40:42l- 9/A3successhttp://www.example.comlets gometrics/coveralls2015-06-06 15:40:42.0000002015-06-15 15:40:42dΕ 9A3pendinghttp://www.example.comlets goci/travis2015-06-06 15:40:42.0000002015-06-15 15:40:42l޺L 9/A3successhttp://www.example.comlets gometrics/coveralls2015-06-06 15:40:42.0000002015-06-15 15:40:42d' 9A3successhttp://www.example.comlets goci/travis2015-06-06 15:40:42.0000002015-06-15 15:40:42l 9/A3failurehttp://www.example.comlets gometrics/coveralls2015-06-06 15:40:42.0000002015-06-15 15:40:42d˺c 9A3successhttp://www.example.comlets goci/travis2015-06-06 15:40:42.0000002015-06-15 15:40:42l劔W 9/A3pendinghttp://www.example.comlets gometrics/coveralls2015-06-05 15:40:42.0000002015-06-15 15:40:42du 9A3pendinghttp://www.example.comlets goci/travis2015-06-05 15:40:42.0000002015-06-15 15:40:42cH 9 A3pendinghttp://www.example.comlets goci/travis2015-06-05 15:40:42.0000002015-06-15 15:40:42 +t o( " |oE^J'VZ tabletaskstasksCREATE 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(16777215), "rollback_once_aborted" boolean DEFAULT 'f' NOT NULL, "env" text)]c5}indexindex_users_on_loginusers$CREATE INDEX "index_users_on_login" ON "users" ("login") 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))aUIindexindex_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(255), "name" varchar(255), "organization" varchar(255), "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_idtasksCREATE INDEX "index_tasks_on_until_commit_id" ON "tasks" ("until_commit_id")g]; indexindex_tasks_on_stack_idtasksCREATE INDEX "index_tasks_on_stack_id" ON "tasks" ("stack_id")|\I%indexindex_tasks_on_since_commit_idtasksCREATE INDEX "index_tasks_on_since_commit_id" ON "tasks" ("since_commit_id")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")vYCindexindex_statuses_on_commit_idstatusesCREATE INDEX "index_statuses_on_commit_id" ON "statuses" ("commit_id")+X)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)zW'Aindexstack_unicitystacksCREATE UNIQUE INDEX "stack_unicity" ON "stacks" ("repo_owner", "repo_name", "environment")VitablestacksstacksCREATE 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)UI'%indexindex_output_chunks_on_task_idoutput_chunksCREATE INDEX "index_output_chunks_on_task_id" ON "output_chunks" ("task_id")PT''_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)|SE#indexindex_memberships_on_user_idmembershipsCREATE INDEX "index_memberships_on_user_id" ON "memberships" ("user_id") +!!georgecyclimseproduction/Uk''!shopifyshipit-engineproduction$WS +  R . v ( dϩ0 9A3successhttp://www.example.comlets goci/travis2015-08-12 01:13:13.0000002015-08-21 01:13:13l- 9/A3successhttp://www.example.comlets gometrics/coveralls2015-08-12 01:13:13.0000002015-08-21 01:13:13dΕ 9A3pendinghttp://www.example.comlets goci/travis2015-08-12 01:13:13.0000002015-08-21 01:13:13l޺L 9/A3successhttp://www.example.comlets gometrics/coveralls2015-08-12 01:13:13.0000002015-08-21 01:13:13d' 9A3successhttp://www.example.comlets goci/travis2015-08-12 01:13:13.0000002015-08-21 01:13:13l 9/A3failurehttp://www.example.comlets gometrics/coveralls2015-08-12 01:13:13.0000002015-08-21 01:13:13d˺c 9A3successhttp://www.example.comlets goci/travis2015-08-12 01:13:13.0000002015-08-21 01:13:13l劔W 9/A3pendinghttp://www.example.comlets gometrics/coveralls2015-08-11 01:13:13.0000002015-08-21 01:13:13du 9A3pendinghttp://www.example.comlets goci/travis2015-08-11 01:13:13.0000002015-08-21 01:13:13cH 9 A3pendinghttp://www.example.comlets goci/travis2015-08-11 01:13:13.0000002015-08-21 01:13:13 ->S԰3VjL'd/mncWiu YH  _ _X cS_33$WScomplete2015-06-15 15:40:422015-06-15 15:40:425˱CfDeployVR33$WSrunning2015-06-15 15:40:422015-06-15 15:40:42>vfDeployVNN33$WSpending2015-06-15 15:40:422015-06-15 15:40:42fDeploynɆp33O$WSsuccess2015-06-15 15:40:422015-06-15 15:40:42>vfTask{ +>S԰3VjL'd/mncWiu YH  Z $ Z D Eb1A3$WSaborted2015-08-21 00:21:13.0000002015-08-21 01:13:135˱CfRollback'#%Vf\0A3$WSaborted2015-08-21 00:20:13.0000002015-08-21 01:13:135˱CfDeployVt\_A3$WSsuccess2015-08-21 00:19:13.0000002015-08-21 01:13:135˱CfDeployVf\A3$WSrunning2015-08-21 00:18:13.0000002015-08-21 01:13:13>vfDeployVfXNA3$WSpending2015-08-21 00:17:13.0000002015-08-21 01:13:13fDeployfxɆpA3O$WSsuccess2015-08-21 00:16:13.0000002015-08-21 01:13:13>vfTask{ "id": "restart", "action": "Restart application", "description": "Restart app and job servers", "steps": [ "cap $ENVIRONMENT deploy:restart" ] } -O33$WSfailed2015-06-15 15:40:422015-06-15 15:40:42>vfDeploy @MS 33 $WSsuccess2015-06-15 15:40:422015-06-15 15:40:42>vfDeploy -""mH%3f2015-06-15 15:40:42complete $3f2015-06-15 15:40:42running&j$3f2015-06-15 15:40:42pending$3f2015-06-15 15:40:42success.Cp#3f2015-06-15 15:40:42failed0$3f2015-06-15 15:40:42success$WS - &j.Cp0 $WS - $WS  $WS&j $WS $WS.Cp $WS0 $WS$WS - &j.Cp0$WS - 5˱C  >v&j >v.Cp >v0 >v$WS ((d Q33https://example.com/cyclimse/cookscooksCookscyclimse2015-06-15 15:40:422015-06-15 15:40:42p Y!!33https://example.com/shopify/developersdevelopersDevelopersshopify2015-06-15 15:40:422015-06-15 15:40:42 +fYA3$WSfailed2015-08-21 00:15:13.0000002015-08-21 01:13:13>vfDeploy @fWS A3 $WSsuccess2015-08-21 00:14:13.0000002015-08-21 01:13:13>vfDeployf +}Q%+Af2015-08-21 00:21:13.000000aborted1+Af2015-08-21 00:20:13.000000aborted'#%+Af2015-08-21 00:19:13.000000success +Af2015-08-21 00:18:13.000000running&j+Af2015-08-21 00:17:13.000000pending+Af2015-08-21 00:16:13.000000success.Cp*Af2015-08-21 00:15:13.000000failed0+Af2015-08-21 00:14:13.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-08-21 01:13:132015-08-21 01:13:13p Y!!33https://example.com/shopify/developersdevelopersDevelopersshopify2015-08-21 01:13:132015-08-21 01:13:13 cyclimsecooks! shopifydevelopers MU1 --733Anonymous Legionanonymous@example.com2015-06-15 15:40:422015-06-15 15:40:42OC -+#33Bob the Builderbob@bob.combob2015-06-15 15:40:422015-06-15 15:40:42Xڷ --133Lando Walrussianwalrus@shopify.comwalrus2015-06-15 15:40:422015-06-15 15:40:42 +-733Anonymous Legionanonymous@example.com2015-08-21 01:13:132015-08-21 01:13:13OC ++#33Bob the Builderbob@bob.combob2015-08-21 01:13:132015-08-21 01:13:13Xڷ +-133Lando Walrussianwalrus@shopify.comwalrus2015-08-21 01:13:132015-08-21 01:13:13 1 -bob5˱C walrus>v )20150515190352)20140226233935)20150518214944 -)20150515190352)20140226233935) 20150518214944 +bob5˱C walrus>v (p^L:( )20150814204960 )20150814204959 +)20150814204958 )20150814204957)20150814204956)20150814204955)20150708143032)20150630154640)20150518214944)20150515190352)20140226233935)20150814182557 + |iVC0)20150814204960 )20150814204959 )20150814204958 +)20150814204957 )20150814204956)20150814204955)20150708143032)20150630154640)20150518214944)20150515190352)20140226233935) 20150814182557 \ No newline at end of file