 --
 
 CREATE TABLE `suara` (
-  `id` int(11) NOT NULL,
   `id_kandidat` int(11) NOT NULL,
-  `nama_kandidat` varchar(225) NOT NULL,
-  `total_suara` varchar(225) NOT NULL
+  `total_suara` int(11) NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 --
 -- Dumping data for table `suara`
 --
 
-INSERT INTO `suara` (`id`, `id_kandidat`, `nama_kandidat`, `total_suara`) VALUES
-(1, 1, 'Mahardika', '300');
+INSERT INTO `suara` (`id_kandidat`, `total_suara`) VALUES
+(1, 2),
+(2, 1),
+(3, 1),
+(4, 1);
 
 --
 -- Indexes for dumped tables

-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Mar 29, 2017 at 10:15 AM
-- Server version: 10.1.13-MariaDB
-- PHP Version: 7.0.8


-- AUTO_INCREMENT for table `kandidat`
--
ALTER TABLE `kandidat`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `pemilih`
--
