CREATE TABLE `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;
ALTER TABLE `jurnal` ADD `type`
varchar(20) NOT NULL;