   `keterangan_customer` text,
   `created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
   PRIMARY KEY (`id_customer`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
 
 /*Data for the table `tbl_customer` */
+
+insert  into `tbl_customer`(`id_customer`,`nama_customer`,`alamat_customer`,`telp_customer`,`telp2_customer`,`id_kota`,`id_sales`,`keterangan_customer`,`created`) values 
+
+(2,'ada123','dada','123','456',9,1,'adada','2017-04-04 23:04:58'),
+
+(3,'tes','122121','123','456',3,3,'asda','2017-04-04 23:07:34');
+
+/*Table structure for table `tbl_kategori` */
+
+CREATE TABLE `tbl_kategori` (
+  `id_kategori` int(11) NOT NULL AUTO_INCREMENT,
+  `nama_kategori` varchar(50) DEFAULT NULL,
+  KEY `id_kategori` (`id_kategori`)
+) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
+
+/*Data for the table `tbl_kategori` */
+
+insert  into `tbl_kategori`(`id_kategori`,`nama_kategori`) values 
+
+(1,'Charger'),
+
+(2,'Head Set'),
+
+(3,'Handphone');
 
 /*Table structure for table `tbl_kota` */
 


(1,'admin','827ccb0eea8a706c4c34a16891f84e7b','Administrator','2017-03-28 13:30:30');

/*Table structure for table `tbl_sales` */

CREATE TABLE `tbl_sales` (
  `id_sales` int(11) NOT NULL AUTO_INCREMENT,
  `nama_sales` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id_sales`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `tbl_sales` */

/*Table structure for table `tbl_supplier` */


  `id_kota` int(11) NOT NULL AUTO_INCREMENT,
  `nama_kota` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id_kota`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

/*Data for the table `tbl_kota` */

insert  into `tbl_kota`(`id_kota`,`nama_kota`) values 

(1,'tes123'),

(2,'Jakarta'),

