Page Table creaton advice

[camdenite]

Hi all,

    I want to create a table in my database for standard pages but I am not sure what I should have.

 

I've got this:

 

CREATE TABLE pages (

 

page_id INT unsigned NOT NULL auto_increment,

page_name varchar(15) NOT NULL,

content ?

active CHAR(32),

creation_date datetime NOT NULL,

PRIMARY KEY (page_id)

;

 

I just want this to store the main content of the page. I will use css for the rest. And maybe other tables for other sections. I want the main table to use html as I want to add FCKeditor to help create nice content.

 

I am making this up as I go along as I can't find actual examples and I'm less than confident.

 

Thankyou for any help.

 

Cheers.

[uniflare]

You can assign the "content" to a TEXT, or for large content purposes a BLOB (i believe its a blob), these however cannot have a default value.