--stores xml fragments for consolidating into rss feeds. Also stores an html version of the content item -- and it's url from the link field of the rss CREATE TABLE syndication ( object_id integer PRIMARY KEY NOT NULL, last_updated timestamptz DEFAULT now() NOT NULL, rss_xml_frag text(-5), body text(-5), url text(-5), ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT syndication_object_id_fk REFERENCES acs_objects (), CONSTRAINT syndication_pk REFERENCES acs_objects () ); CREATE TRIGGER RI_ConstraintTrigger_c_342989 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342990 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 13,361,152 bytes -- Table rows: 11,221
Begin main content
