/* wiadomosc wlasciwa */
CREATE TABLE IF NOT EXISTS `msg` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `senderId` int(11) unsigned NOT NULL,
  `title` varchar(256) COLLATE utf8_bin NOT NULL,
  `text` text COLLATE utf8_bin NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=10 ;

/* pointer na msg */
CREATE TABLE IF NOT EXISTS `msg_p` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `msgId` int(11) unsigned NOT NULL,
  `objectId` int(11) unsigned NOT NULL,
    `externalsId` int(11) unsigned NULL, /*zalaczniki*/
  `type` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=10 ;

/* zewnetrzne zasoby */
CREATE TABLE IF NOT EXISTS `externals` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `val` text COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=10 ;