• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Day 16

Listing D.34 shows the table structure for tblMessage.

Listing D.34. Table Definition of tblMessage

1 CREATE TABLE tblMessage (
2   messageID int(11) NOT NULL auto_increment,
3   parentID int(11) default NULL,
4   subject varchar(250) default NULL,
5   iconURL varchar(250) default NULL,
6   author varchar(250) default NULL,
7   body text,
8   password varchar(250) default NULL,
9   PRIMARY KEY  (messageID)
10 );


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint