-- phpMyAdmin SQL Dump -- version 4.6.3 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: Nov 10, 2016 at 03:29 AM -- Server version: 5.5.52-cll -- PHP Version: 5.5.38 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; -- -- Database: `stok_barang` -- -- -------------------------------------------------------- -- -- Table structure for table `stok_brg` -- CREATE TABLE `stok_brg` ( `no_` int(4) NOT NULL, `tgl` date NOT NULL, `brg` varchar(25) NOT NULL DEFAULT 'Kosong', `qty` int(5) NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `stok_brg` -- INSERT INTO `stok_brg` (`no_`, `tgl`, `brg`, `qty`) VALUES (1001, '2016-11-09', 'A', 10), (1002, '2016-11-09', 'A', -2), (1003, '2016-11-09', 'A', 2), (1004, '2016-11-09', 'A', -1), (1005, '2016-11-09', 'A', 1), (1006, '2016-11-09', 'A', -1), (1007, '2016-11-09', 'B', 20), (1008, '2016-11-09', 'B', 1), (1009, '2016-11-09', 'B', -21), (1010, '2016-11-09', 'B', 2), (1011, '2016-11-09', 'A', -5), (1012, '2016-11-09', 'd', 3), (1013, '2016-11-09', 'd', -2), (1014, '2016-11-09', 'paku', 10), (1015, '2016-11-09', 'paku', -5), (1016, '2016-11-09', 'paku', -4), (1017, '2016-11-09', 'paku', 3), (1018, '2016-11-09', 'semen', -10), (1019, '2016-11-09', 'semen', 20), (1020, '2016-11-09', 'A', -4), (1021, '2016-11-09', 'baju', 5), (1022, '2016-11-09', 'baju', 10), (1023, '2016-11-10', '', 0), (1024, '2016-11-10', 'baju', 1), (1025, '2016-11-10', 'baju', -15); -- -- Indexes for dumped tables -- -- -- Indexes for table `stok_brg` -- ALTER TABLE `stok_brg` ADD PRIMARY KEY (`no_`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `stok_brg` -- ALTER TABLE `stok_brg` MODIFY `no_` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1026;