I need an idea about my design

[plodos]

.sql

CREATE TABLE IF NOT EXISTS `conference` (
  `id` int(11) NOT NULL auto_increment,
  `year` varchar(10) NOT NULL,
  `mounth` varchar(20) NOT NULL,
  `country` varchar(100) NOT NULL,
  `city` varchar(100) NOT NULL,
  `name` text NOT NULL,
  `sname` varchar(50) NOT NULL COMMENT 
  `content` longtext NOT NULL,
  `cdate` varchar(50) NOT NULL COMMENT 
  `link` text NOT NULL,
  `rdate` datetime NOT NULL COMMENT 
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

 

i will keep 1300-2000 characters inside of the `content` longtext NOT NULL,

 

I used "longtext" is it enought or not....Also system will have a search engine to search content

 

Is it good design or not??

 

Thank you

[jackpf]

Well, longtext has a max length of 4294967295 characters, so I think you'll be ok.

[laffin]

but the varchar month/date is disturbing....

10 characters for a year storage is a bit much

20 characters for month storage, i think we using different calander systems here.

 

U shud consider using DATE/DATETIME instead, ot just plain ole INT(11) and let php handle the timestamp.

numerics searches/sorting will always be faster.