-- -- Extends the cr_items table to hold information on static pages. -- CREATE TABLE static_pages ( static_page_id integer PRIMARY KEY NOT NULL, -- -- The full path of the file (e.g. /web/my_site/www/books/index.html). -- filename varchar(500), -- -- ID of folder containing page. -- folder_id integer, -- -- Are comments shown on the page, or is the user simply offered a link -- to view the comments? -- show_comments_p bool DEFAULT true NOT NULL, -- -- Last modification time of file as reported by [file mtime] -- mtime integer, CONSTRAINT static_pgs_folder_id_fk REFERENCES sp_folders (), CONSTRAINT static_pgs_static_pg_id_fk REFERENCES sp_folders (), CONSTRAINT static_pgs_static_pg_pk REFERENCES sp_folders (), CONSTRAINT static_pgs_static_pg_pk REFERENCES cr_items (), CONSTRAINT static_pgs_folder_id_fk REFERENCES cr_items (), CONSTRAINT static_pgs_static_pg_id_fk REFERENCES cr_items () ); CREATE INDEX static_pages_filename_idx ON static_pages (filename); CREATE INDEX static_pages_folder_id_idx ON static_pages (folder_id); CREATE TRIGGER RI_ConstraintTrigger_a_342952 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342953 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342979 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342980 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342984 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342985 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to static_pages: --sp_extant_files(static_pgs_folder_id_fk) --sp_extant_files(static_pgs_static_pg_id_fk) --sp_extant_files(static_pgs_static_pg_pk) -- Table size: 286,720 bytes -- Table rows: 3,029
Begin main content
