Skip to content

Instantly share code, notes, and snippets.

@EricWittmann
Created February 18, 2015 12:46
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save EricWittmann/c62456b5ff2424cd441b to your computer and use it in GitHub Desktop.
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
--- 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