TUTORIAL

CREATE TABLE IF NOT EXISTS `tbpenjualan` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `kd_brg` varchar(200) NOT NULL,
  `nm_pembeli` varchar(200) NOT NULL,
  `tanggal` date NOT NULL,
  `jumlah` int(10) NOT NULL,
  `harga` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `tbbarang` (
  `nm_brg` varchar(200) DEFAULT NULL,
  `no_brg` varchar(200) NOT NULL DEFAULT '',
  `kat_brg` varchar(200) DEFAULT NULL,
  `mrk_brg` varchar(200) DEFAULT NULL,
  `des_brg` varchar(200) DEFAULT NULL,
  `jml` int(10) DEFAULT NULL,
  `harga` int(10) DEFAULT NULL,
  PRIMARY KEY (`no_brg`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;