Created
May 7, 2015 12:06
-
-
Save biharitomi/320e54d477d521a810b1 to your computer and use it in GitHub Desktop.
network migration
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE network ( | |
| dtype character varying(31) NOT NULL, | |
| id bigint NOT NULL, | |
| account character varying(255), | |
| description text, | |
| name character varying(255) NOT NULL, | |
| owner character varying(255), | |
| publicinaccount boolean NOT NULL, | |
| status character varying(255), | |
| subnetcidr character varying(255) NOT NULL, | |
| addressprefixcidr character varying(255), | |
| internetgatewayid character varying(255), | |
| vpcid character varying(255), | |
| publicnetid character varying(255) | |
| ); | |
| ALTER TABLE ONLY network | |
| ADD CONSTRAINT network_pkey PRIMARY KEY (id); | |
| ALTER TABLE ONLY network | |
| ADD CONSTRAINT uk_networknameinaccount UNIQUE (account, name); | |
| CREATE SEQUENCE network_table | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| NO MAXVALUE | |
| CACHE 1; | |
| ALTER TABLE stack ADD COLUMN network_id bigint; | |
| ALTER TABLE ONLY stack | |
| ADD CONSTRAINT fk_networkidinstack FOREIGN KEY (network_id) REFERENCES network(id); | |
| select id from stack where status in ('AVAILABLE','STOPPED','START_FAILED'); | |
| select s.name,sp.stack_id,sp.key,sp.value from stack s RIGHT OUTER JOIN stack_parameters sp ON s.id=sp.stack_id; | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment