apply new versions db schema
Closed this issue · 3 comments
jackfrancis commented
apply new versions db schema
jackfrancis commented
Dropped existing (empty) table:
deis_prod_pg=> select count(*) from versions;
count
-------
0
(1 row)
deis_prod_pg=> drop table versions;
DROP TABLE
deis_prod_pg=> \d+;
List of relations
Schema | Name | Type | Owner | Size | Description
--------+-----------------------------------+----------+---------+------------+-------------
public | clusters | table | dbadmin | 1016 kB |
public | clusters_checkins | table | dbadmin | 1104 kB |
public | clusters_checkins_checkins_id_seq | sequence | dbadmin | 8192 bytes |
(3 rows)
jackfrancis commented
Installed new workflow-manager-api app to champagne cluster:
$ deis pull quay.io/deisci/workflow-manager-api:git-777688e -a workflow-manager-api
Creating build... done
jackfrancis commented
New workflow-manager-api app created updated versions table as expected:
deis_prod_pg=> \d+;
List of relations
Schema | Name | Type | Owner | Size | Description
--------+-----------------------------------+----------+---------+------------+-------------
public | clusters | table | dbadmin | 1016 kB |
public | clusters_checkins | table | dbadmin | 1104 kB |
public | clusters_checkins_checkins_id_seq | sequence | dbadmin | 8192 bytes |
public | versions | table | dbadmin | 8192 bytes |
public | versions_version_id_seq | sequence | dbadmin | 8192 bytes |
(5 rows)
deis_prod_pg=> \d versions;
Table "public.versions"
Column | Type | Modifiers
-------------------+-----------------------------+---------------------------------------------------------------
version_id | bigint | not null default nextval('versions_version_id_seq'::regclass)
component_name | character varying(32) |
train | character varying(24) |
version | character varying(32) |
release_timestamp | timestamp without time zone |
data | json |
Indexes:
"versions_pkey" PRIMARY KEY, btree (version_id)
"versions_component_name_train_version_key" UNIQUE CONSTRAINT, btree (component_name, train, version)