DROP TABLE IF EXISTS `XXX_event`; ##b_dump##
CREATE TABLE `XXX_event` (
  `EVENT_ID` int(11) NOT NULL auto_increment ,
  `EVENT_DATE1` datetime NULL ,
  `EVENT_DATE2` datetime NULL ,
  `EVENT_DISCRIPTION` varchar(80) NULL ,
  `EVENT_TEXT` text NULL ,
  `EVENT_CONTACT` varchar(80) NULL ,
  `EVENT_LINK` text NULL ,
  `EVENT_ACTIVE` int(1) NULL  DEFAULT '0' ,
  PRIMARY KEY (`EVENT_ID`) 
) ENGINE=MyISAM ; ##b_dump##

INSERT INTO `XXX_event` SET EVENT_ID='2', EVENT_DATE1='2010-12-24 17:00:00', EVENT_DATE2='2010-12-24 18:00:00', EVENT_DISCRIPTION='', EVENT_TEXT='', EVENT_CONTACT='info@weihnachtsmann.de', EVENT_LINK='', EVENT_ACTIVE='1'  ; ##b_dump##


DROP TABLE IF EXISTS `XXX_event_lang`; ##b_dump##
CREATE TABLE `XXX_event_lang` (
  `EVENT_ID` int(11) NOT NULL ,
  `EVENT_LANG_ID` varchar(80) NULL ,
  `EVENT_DISCRIPTION` varchar(80) NULL ,
  `EVENT_TEXT` text NULL  
) ENGINE=MyISAM ; ##b_dump##

INSERT INTO `XXX_event_lang` SET EVENT_ID='2', EVENT_LANG_ID='1', EVENT_DISCRIPTION='Bescherung', EVENT_TEXT='Das Christkind kommt.'  ; ##b_dump##


DROP TABLE IF EXISTS `XXX_event_pref`; ##b_dump##
CREATE TABLE `XXX_event_pref` (
  `event_id` int(11) NOT NULL  DEFAULT '0' ,
  `event_export` varchar(255) NOT NULL ,
  `event_import` varchar(255) NOT NULL ,
  `event_lang` text NOT NULL  
) ENGINE=MyISAM ; ##b_dump##

INSERT INTO `XXX_event_pref` SET event_id='1', event_export='', event_import='', event_lang='0;1'  ; ##b_dump##