--
--    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_ctx_fk REFERENCES acs_objects (),
	CONSTRAINT rss_gen_subscrs_id_fk REFERENCES acs_objects (),
	CONSTRAINT rss_gen_subscrs_impl_fk REFERENCES acs_sc_impls ()
);

CREATE UNIQUE INDEX rss_gen_subscrs_impl_con_un ON rss_gen_subscrs (impl_id, summary_context_id);

-- Tables with foreign keys that refer to rss_gen_subscrs:
--fs_rss_subscrs(fs_rss_subscrs_fk)

-- Table size: 0 bytes
-- Table rows: 0

Tables: