table jurnal -suplier

CREATE TABLE IF NOT EXISTS `jurnal` (
`j_id` int(11) NOT NULL,
  `j_date` date NOT NULL,
  `j_sup` int(11) NOT NULL,
  `j_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `j_user` int(11) NOT NULL COMMENT 'yg bikin jurnal'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `suplier` (
`sup_id` int(11) NOT NULL,
  `sup_name` varchar(200) NOT NULL,
  `sup_address` text NOT NULL,
  `sup_cp` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

ALTER TABLE `jurnal`
 ADD PRIMARY KEY (`j_id`), ADD KEY `j_user` (`j_user`), ADD KEY `j_sup` (`j_sup`);

ALTER TABLE `suplier`
 ADD PRIMARY KEY (`sup_id`), ADD KEY `sup_name` (`sup_name`), ADD FULLTEXT KEY `sup_address` (`sup_address`,`sup_cp`);

ALTER TABLE `jurnal`
MODIFY `j_id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `suplier`
MODIFY `sup_id` int(11) NOT NULL AUTO_INCREMENT;