-- -- a simple count of how many times an object is viewed. -- CREATE TABLE views_views ( object_id integer NOT NULL, viewer_id integer NOT NULL, views_count integer DEFAULT 1, last_viewed timestamptz DEFAULT now(), PRIMARY KEY (object_id,viewer_id), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT views_object_id_fk REFERENCES acs_objects (), CONSTRAINT views_owner_id_fk REFERENCES acs_objects (), CONSTRAINT views_views_pk REFERENCES acs_objects () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT views_views_pk REFERENCES parties (), CONSTRAINT views_object_id_fk REFERENCES parties (), CONSTRAINT views_owner_id_fk REFERENCES parties () ); CREATE UNIQUE INDEX views_views_viewer_idx ON views_views (viewer_id, object_id); CREATE TRIGGER views_views_ins_tr AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE views_views_ins_tr (disabled) CREATE TRIGGER views_views_upd_tr AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE views_views_upd_tr (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343089 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343090 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343094 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343095 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 598,016 bytes -- Table rows: 9,949
Begin main content
