CREATE TABLE IF NOT EXISTS `jurnal` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`id_user` int(11) NOT NULL,
`id_kont` int(11) NOT
NULL,
`time` int(11) NOT NULL,
`msg` varchar(1024) NOT NULL,
`type` varchar(20) NOT NULL,
`read` set('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `id_user` (`id_user`,`id_kont`),
KEY `read`
(`read`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;