CREATE TABLE acs_enum_values ( attribute_id integer NOT NULL, enum_value varchar(1000) NOT NULL, pretty_name varchar(100) NOT NULL, sort_order integer NOT NULL, PRIMARY KEY (attribute_id,enum_value), CONSTRAINT acs_enum_values_pk REFERENCES acs_attributes (), CONSTRAINT asc_enum_values_attr_id_fk REFERENCES acs_attributes () ); CREATE INDEX acs_enum_values_attr_id_idx ON acs_enum_values (attribute_id); CREATE UNIQUE INDEX acs_enum_values_pretty_name_un ON acs_enum_values (attribute_id, pretty_name); CREATE UNIQUE INDEX acs_enum_values_sort_order_un ON acs_enum_values (attribute_id, sort_order); CREATE TRIGGER RI_ConstraintTrigger_c_340754 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340755 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
