Update of /cvsroot/openinteract/OpenInteract/pkg/base_page/struct
In directory usw-pr-cvs1:/tmp/cvs-serv13160/struct
Added Files:
page.sql page_content.sql
Log Message:
updated structures -- 'page' is now just the metadata for a particular
document; page_content is used if you want to store them in the DB
--- NEW FILE: page.sql ---
CREATE TABLE page (
location varchar(150) not null,
directory varchar(150) null,
title varchar(250) null,
author varchar(200) null,
keywords varchar(75) null,
boxes varchar(75) null,
main_template varchar(40) null,
active_on datetime null,
expires_on datetime null,
is_active char(3) default 'no',
is_file char(3) default 'no',
mime_type varchar(30) null,
notes text null,
primary key ( location )
)
--- NEW FILE: page_content.sql ---
CREATE TABLE page_content (
location varchar(150) not null,
content text null,
primary key ( location )
)
|
