Quellcode

CREATE TABLE `magazin` (
  `id` tinyint(6) NOT NULL auto_increment,
  `rss-time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `datum` text  NOT NULL,
  `word` varchar(40) default NULL,
  `definition` text,
  `cat` text NOT NULL,
  `online` char(1) NOT NULL default 'y',
  `autor` text NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  FULLTEXT KEY `word` (`word`,`definition`)
) ENGINE=MyISAM AUTO_INCREMENT=62 DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=62 ;