FAQ DB f?r FAQ Objekt morgen

CREATE TABLE Faq (
  ID int(11) NOT NULL auto_increment,
  lang char(2) default 'de',
  title varchar(50) NOT NULL default '',
  faqinfo_keywordset text,
  question text NOT NULL,
  answer text NOT NULL,
  created datetime NOT NULL default '0000-00-00 00:00:00',
  createdby varchar(50) NOT NULL default 'someone',
  changed timestamp(14) NOT NULL,
  changedby varchar(50) NOT NULL default 'someone',
  rang bigint(20) NOT NULL default '0',
  PRIMARY KEY  (ID),
  UNIQUE KEY ID (ID)
) TYPE=MyISAM;


--
roger fischer | bitflux GmbH | schöneggstrasse 5 | ch-8004 zürich
tel +41 1 240 56 72 | mobil +41 78 607 75 06 | fax +41 1 240 56 71
http://www.bitflux.ch | [email protected]