Re: [Apiman-dev] policydefs index
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