 -- AUTO_INCREMENT for table `kategori`
 --
 ALTER TABLE `kategori`
-  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8351;
+  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8353;
 --
 -- AUTO_INCREMENT for table `login_attempts`
 --

--

INSERT INTO `users` (`id`, `ip_address`, `username`, `password`, `salt`, `email`, `activation_code`, `forgotten_password_code`, `forgotten_password_time`, `remember_code`, `created_on`, `last_login`, `active`, `first_name`, `last_name`, `company`, `phone`) VALUES
(1, '127.0.0.1', 'administrator', '$2a$07$SeBknntpZror9uyftVopmu61qg0ms8Qv1yV6FG.kQOSM.9QhmTo36', '', 'admin@admin.com', '', NULL, NULL, 'LNovQL3sncAHvhpbmHDBXe', 1268889823, 1478898878, 1, 'Admin', 'istrator', 'ADMIN', '0'),
(2, '::1', 'rizkiherda@gmail.com', '$2y$08$rhJwtbO/Q6M26847s1dfFeJ77WcJbZqBue67L.4FOoaPtuVLixsfm', NULL, 'rizkiherda@gmail.com', NULL, 'o.gpY4GpP9WBnu-Zi1Dsc.09b3725c196d398db2', 1475723946, NULL, 1475722620, 1475722653, 1, 'Rizki', 'Herdatullah', 'MasCitra', '082234367866');

-- --------------------------------------------------------

  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updateAt` timestamp NULL DEFAULT NULL,
  `createdBy` int(11) NOT NULL,
  `updateBy` int(11) DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='5';

--
-- Dumping data untuk tabel `barang`
--

INSERT INTO `barang` (`id`, `kode_kategori`, `nama`, `merk`, `tipe`, `ukuran`, `satuan`, `hargaPasar`, `biayaKirim`, `resistensi`, `ppn`, `hargashsb`, `keterangan`, `spesifikasi`, `gambar`, `tahun_anggaran`, `popularitas`, `createdAt`, `updateAt`, `createdBy`, `updateBy`, `status`) VALUES
(3, '0206030102', 'PDA', 'Toth', '1352', '6', 'Inchi', 2500000, 22000, 20000, 254200, 2796200, 'Tidak Ada', '<p>Tidak Ada</p>', NULL, 2016, 9, '2016-11-19 03:49:02', '2016-11-11 00:34:13', 1, 1, 1),
(6, '02060301', 'Handphone', 'Xiaomi', 'Mi5', '5', 'Inchi', 2500000, 22000, 20000, 254200, 2796200, 'Tidak Ada', '<p>Tidak Ada</p>', 'img-20161111103021.jpg', 2016, 4, '2016-11-19 03:49:02', '2016-11-11 03:30:21', 1, 1, 1),
(7, '02060301', 'Handphone', 'Lenovo', 'Vibe', '6', 'Inchi', 2000000, 22000, 20000, 204200, 2246200, 'Tidak Ada', '<p>Tidak Ada</p>', 'img-20161112041138.png', 2016, 8, '2016-11-19 10:01:02', '2016-11-11 03:22:15', 1, 1, 1),
(8, '02060301', 'Laptop', 'Toshiba', '1594', '15', 'Inchi', 5000000, 40000, 50000, 509000, 5599000, 'Tidak Ada', '<p>Tidak Ada</p>', 'img-20161111102922.jpg', 2016, 4, '2016-11-19 10:01:23', '2016-11-11 03:29:22', 1, 1, 1),
(9, '02060206', 'Kulkas', 'LG', '2 pintu', '1.5', 'Meter', 3000000, 160000, 25000, 318500, 3503500, 'Tidak Ada', '<p>Tidak Ada</p>', 'img-20161112041138.jpg', 2016, 0, '2016-11-19 03:49:02', '2016-11-11 03:54:40', 1, 1, 1),
(13, '0206020603', 'Televisi', 'Samsung', 'Curve', '32', 'Inchi', 5400000, 100000, 50000, 555000, 6105000, 'Lazada', 'Layar Cekung', NULL, 2016, 0, '2016-11-19 03:49:02', NULL, 1, NULL, 1),
(14, '0202010104', 'Traktor', 'new', 'new', '1', 'Unit', 126047000, 0, 0, 0, 126047000, 'bhinneka.com', '<p>New Traktor Empat Roda : Model : China Tractor parts , 4x4 compact agricultural tractor. (US $7,800 - 8,900) Nilai Beli Indonesia (13.235 x 7.800 US $) IDR : 103.233.000</p>', 'img-20161119104207.jpg', 2017, 2, '2016-11-19 10:39:27', '2016-11-19 03:42:07', 1, 1, 1),
(15, '0202010104', 'Traktor', 'new', 'new', '1', 'Unit', 143823000, 0, 0, 0, 143823000, 'bhinneka.com', '<p>New Traktor Empat Roda : Model : China HX504 Agricultural Tractor part with front end loader. (US $7,800 - 8,900) Nilai Beli Indonesia (13.235 x 8.900 US $) IDR : 117.791.500</p>', 'img-20161119114219.jpg', 2017, 3, '2016-11-19 10:43:15', '2016-11-19 04:42:19', 1, 1, 1);

-- --------------------------------------------------------

