-- -- a simple count of how many times an object is viewed, multiple visits -- trigger maintained by updates on views. -- CREATE TABLE view_aggregates ( object_id integer PRIMARY KEY NOT NULL, views_count integer DEFAULT 1, unique_views integer DEFAULT 1, last_viewed timestamptz DEFAULT now(), ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT view_aggregatess_pk REFERENCES acs_objects (), CONSTRAINT view_aggs_object_id_fk REFERENCES acs_objects () ); CREATE TRIGGER RI_ConstraintTrigger_c_343074 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343075 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 155,648 bytes -- Table rows: 2,252
Begin main content
