Created
February 18, 2015 12:46
-
-
Save EricWittmann/c62456b5ff2424cd441b to your computer and use it in GitHub Desktop.
postgresql DDL diff: apiman 1.0.2.Final -> apiman 1.0.3.Final
This file contains 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
--- a/distro/wildfly8/src/main/resources/overlay/apiman/ddls/apiman_postgresql.ddl | |
+++ b/distro/wildfly8/src/main/resources/overlay/apiman/ddls/apiman_postgresql.ddl | |
@@ -332,6 +332,7 @@ CREATE TABLE service_versions ( | |
retiredOn timestamp without time zone, | |
status character varying(255) NOT NULL, | |
version character varying(255), | |
+ definitionType character varying(255), | |
service_id character varying(255), | |
service_orgId character varying(255) | |
); | |
@@ -345,6 +346,26 @@ ALTER TABLE ONLY service_versions | |
ALTER TABLE ONLY service_versions | |
ADD CONSTRAINT FK_service_versions_1 FOREIGN KEY (service_id, service_orgId) REFERENCES services(id, organizationId); | |
+ | |
+-- | |
+-- Name: service_defs | |
+-- | |
+ | |
+CREATE TABLE service_defs ( | |
+ id bigint NOT NULL, | |
+ serviceVersionId bigint NOT NULL, | |
+ data bytea NOT NULL | |
+); | |
+ | |
+ALTER TABLE ONLY service_defs | |
+ ADD CONSTRAINT PK_service_defs PRIMARY KEY (id); | |
+ | |
+ALTER TABLE ONLY service_defs | |
+ ADD CONSTRAINT UK_service_defs_1 UNIQUE (serviceVersionId); | |
+ | |
+ALTER TABLE ONLY service_defs | |
+ ADD CONSTRAINT FK_service_defs_1 FOREIGN KEY (serviceVersionId) REFERENCES service_versions(id); | |
+ | |
-- | |
-- Name: svc_gateways | |
-- |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment