 -- AUTO_INCREMENT for table `certificate`
 --
 ALTER TABLE `certificate`
-MODIFY `id_certificate` int(11) NOT NULL AUTO_INCREMENT;
+MODIFY `id_certificate` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
 --
 -- AUTO_INCREMENT for table `user`
 --

CREATE TABLE IF NOT EXISTS `certificate` (
`id_certificate` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `tanggal` int(11) NOT NULL,
  `nama_user` int(11) NOT NULL,
  `email_user` int(11) NOT NULL,
  `kode_negara_user` int(11) NOT NULL,
  `provinsi_user` int(11) NOT NULL,
  `kota_user` int(11) NOT NULL,
  `nama_organisasi` int(11) NOT NULL,
  `unit_organisasi` int(11) NOT NULL,
  `challenge_password` int(11) NOT NULL,
  `optional_company` int(11) NOT NULL,
  `url_certificate` int(11) NOT NULL,
  `status_certificate` int(11) NOT NULL,
  `url` varchar(1000) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: May 07, 2015 at 03:35 AM
-- Server version: 5.6.21
-- PHP Version: 5.6.3

