CREATE TABLE IF NOT EXISTS `medicar_nachrichten` (
  `nachrichten_id` int(255) NOT NULL auto_increment,
  `nachrichten_von` varchar(255) NOT NULL,
  `id_von` int(15) NOT NULL,
  `nachrichten_an` varchar(255) NOT NULL,
  `id_an` int(15) NOT NULL,
  `nachrichten_subject` varchar(255) NOT NULL,
  `nachrichten_text` text NOT NULL,
  `nachrichten_zeit` int(15) NOT NULL,
  `regdate` int(15) NOT NULL,
  `Rang` varchar(50) NOT NULL,
  `Funktion` varchar(50) NOT NULL,
  `Foto` varchar(255) NOT NULL,
  `nachrichten_text_reply` text,
  `nachrichten_pm` int(1) NOT NULL default '1',
  PRIMARY KEY  (`nachrichten_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=50 ;