Jump to content

Archived

This topic is now archived and is closed to further replies.

rallokkcaz

blog like thing im making

Recommended Posts

im making something that is somewhat like a blog ive made a table
with the follow rows
text
time

what other rows should i put in???

Share this post


Link to post
Share on other sites
Here's my table structure for blog.

CREATE TABLE `blog` (
  `id` int(11) NOT NULL auto_increment,
  `display` tinyint(2) NOT NULL default '1',
  `archive` tinyint(2) NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `title` varchar(255) NOT NULL default '',
  `entry` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `date` (`date`),
  KEY `archive` (`archive`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 CHECKSUM=1 AUTO_INCREMENT=2 ;

Hope this helps!

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.