[Openinteract-commits] CVS: OpenInteract/pkg/base_page/struct page.sql,NONE,1.1 page_content.sql,NONE,1.1

[Chris W. <la...@us...>]

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 )
)