-- -- a simple count of how many times an object is viewed for each type. -- CREATE TABLE views_by_type ( object_id integer NOT NULL, viewer_id integer NOT NULL, view_type varchar(100) NOT NULL, views_count integer DEFAULT 1, last_viewed timestamptz DEFAULT now(), PRIMARY KEY (object_id,viewer_id,view_type), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT views_by_type_object_id_fk REFERENCES acs_objects (), CONSTRAINT views_by_type_owner_id_fk REFERENCES acs_objects (), CONSTRAINT views_by_type_pk REFERENCES acs_objects () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT views_by_type_pk REFERENCES parties (), CONSTRAINT views_by_type_object_id_fk REFERENCES parties (), CONSTRAINT views_by_type_owner_id_fk REFERENCES parties () ); CREATE UNIQUE INDEX views_by_type_viewer_idx ON views_by_type (viewer_id, object_id, view_type); CREATE TRIGGER views_by_type_ins_tr AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE views_by_type_ins_tr (disabled) CREATE TRIGGER views_by_type_upd_tr AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE views_by_type_upd_tr (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343079 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343080 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343084 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343085 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
