-- -- Table for storing the different parts of the site we will generate -- summaries for. -- CREATE TABLE rss_gen_subscrs ( -- -- Subscriptions are ACS objects. They will typically inherit -- permission from a package instance. -- subscr_id integer PRIMARY KEY NOT NULL, -- -- The implementation which will provide summary information and -- update status. -- impl_id integer NOT NULL, -- -- An identifier unique to the site section whose content is to be -- summarized. A context identifier need not be a package instance -- id. We will suggest a convention but the format is entirely up to -- the implementors. -- summary_context_id integer NOT NULL, -- -- The minimum number of seconds between summary builds. -- timeout integer NOT NULL, -- -- Accounting column for use by rss generation service. -- lastbuild timestamptz, -- -- Another accounting column. The last time to build (in seconds). -- last_ttb integer, -- -- Used for display purposes. -- channel_title varchar(200), -- -- Used for display purposes. -- channel_link varchar(1000), CONSTRAINT rss_gen_subscrs_id_fk REFERENCES acs_objects (), CONSTRAINT rss_gen_subscrs_id_pk REFERENCES acs_objects (), CONSTRAINT rss_gen_subscrs_impl_fk REFERENCES acs_objects (), CONSTRAINT rss_gen_subscrs_impl_fk REFERENCES acs_sc_impls (), CONSTRAINT rss_gen_subscrs_id_fk REFERENCES acs_sc_impls (), CONSTRAINT rss_gen_subscrs_id_pk REFERENCES acs_sc_impls () ); CREATE UNIQUE INDEX rss_gen_subscrs_impl_con_un ON rss_gen_subscrs (impl_id, summary_context_id); CREATE INDEX rss_gen_subscrs_lastbuild_idx ON rss_gen_subscrs (lastbuild); CREATE TRIGGER RI_ConstraintTrigger_a_342432 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342433 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342899 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342900 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342904 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342905 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to rss_gen_subscrs: --fs_rss_subscrs(rss_gen_subscrs_id_fk) --fs_rss_subscrs(rss_gen_subscrs_id_pk) --fs_rss_subscrs(rss_gen_subscrs_impl_fk) -- Table size: 8,192 bytes -- Table rows: 1
Begin main content
