At this stage, we only support creation and administration of custom sections at the group level. Later, we will augment the system to support site wide administration of custom sections.
create table content_files ( content_file_id integer primary key, section_id references content_sections, -- this will be part of url; should be a-zA-Z and underscore file_name varchar(30) not null, -- this is a MIME type (e.g., text/html, image/jpeg) file_type varchar(100) not null, file_extension varchar(50), -- e.g., "jpg" -- if file is text or html we need page_pretty_name, body and html_p page_pretty_name varchar(200), body clob, html_p char(1) default 'f' check(html_p in ('t','f')), -- if the file is attachment we need use binary_data blob( e.g. photo, image) binary_data blob );