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

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;

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


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