-- -- a simple count of how many times an object is viewed for each type, -- multiple visits trigger maintained by updates on views_by_type. -- CREATE TABLE view_aggregates_by_type ( object_id integer NOT NULL, view_type varchar(100) NOT NULL, views_count integer DEFAULT 1, unique_views integer DEFAULT 1, last_viewed timestamptz DEFAULT now(), PRIMARY KEY (object_id,view_type), ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT view_agg_b_type_ob_id_fk REFERENCES acs_objects (), CONSTRAINT view_aggregates_by_type_pk REFERENCES acs_objects () ); CREATE TRIGGER RI_ConstraintTrigger_c_343069 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343070 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
