1:35 a.m.
Hey Eric,
I was just adding all the indexes from the out of date ddls in distro to liquibase and
came across the one below. It looks like the PolicyDefinitionBean has changed and the
policyId column no longer exists. What if anything would you like to use in its place for
the index?
From: apiman_postgresql.ddl
--
-- Name: policydefs
--
CREATE TABLE policydefs (
id character varying(255) NOT NULL,
description character varying(512) NOT NULL,
icon character varying(255) NOT NULL,
name character varying(255) NOT NULL,
policyimpl character varying(255) NOT NULL,
policyId character varying(255)
);
ALTER TABLE ONLY policydefs
ADD CONSTRAINT PK_policydefs PRIMARY KEY (id);
ALTER TABLE ONLY policydefs
ADD CONSTRAINT FK_policydefs_1 FOREIGN KEY (policyId) REFERENCES plugins(id);
CREATE INDEX IDX_FK_policydefs_1 ON policydefs (policyId);
8:52 p.m.
Looking at that table I wonder if it was *ever* right. :(
In any case, I think we need 'plugin_id' to be a foreign key constraint
on the 'plugins' table. No additional indexes are needed I don't think.
-Eric
On 7/9/2015 4:05 PM, Brandon Gaisford wrote:
Hey Eric,
I was just adding all the indexes from the out of date ddls in distro to
liquibase and came across the one below. It looks like the
PolicyDefinitionBean has changed and the policyId column no longer
exists. What if anything would you like to use in its place for the index?
From: apiman_postgresql.ddl
--
-- Name: policydefs
--
CREATE TABLEpolicydefs (
idcharacter varying(255)NOT NULL,
descriptioncharacter varying(512)NOT NULL,
iconcharacter varying(255)NOT NULL,
namecharacter varying(255)NOT NULL,
policyimplcharacter varying(255)NOT NULL,
policyIdcharacter varying(255)
);
ALTER TABLE ONLYpolicydefs
ADD CONSTRAINTPK_policydefsPRIMARY KEY(id);
ALTER TABLE ONLYpolicydefs
ADD CONSTRAINTFK_policydefs_1FOREIGN KEY(policyId)REFERENCESplugins(id);
CREATEINDEX IDX_FK_policydefs_1ONpolicydefs (policyId);
_______________________________________________
Apiman-dev mailing list
Apiman-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/apiman-dev
3377
days inactive
3381
days old
1 comments
2 participants
participants (2)
-
Brandon Gaisford -
Eric Wittmann