-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- Table structure for table `bantuan`
--

CREATE TABLE `bantuan` (
  `id_bantuan` int(10) NOT NULL,
  `no_telp` varchar(16) NOT NULL,
  `latitude` varchar(15) NOT NULL,
  `longitude` varchar(15) NOT NULL,
  `desc_bantuan` text NOT NULL,
  `read_bantuan` int(11) NOT NULL DEFAULT 0,
  `image` varchar(500) NOT NULL,
  `kepolisian` varchar(20) NOT NULL,
  `tanggal` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bantuan`
--

INSERT INTO `bantuan` (`id_bantuan`, `no_telp`, `latitude`, `longitude`, `desc_bantuan`, `read_bantuan`, `image`, `kepolisian`, `tanggal`) VALUES
(63, '+6289652439566', '-7.9233271', '112.5947231', 'tolong ada kecelakaan', 2, '1564111819701.jpg', '6', '2019-07-26 03:30:19'),
(62, '+6281218041018', '0', '0', 'null', 0, '', '0', '2019-05-08 23:56:57');

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

--
-- Table structure for table `firebase`
--

CREATE TABLE `firebase` (
  `id` int(10) NOT NULL,
  `no_telp` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `nama` varchar(30) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `firebase`
--

INSERT INTO `firebase` (`id`, `no_telp`, `nama`) VALUES
(1, '+6289652439', 'farid'),
(2, '+6289652439566', 'Dadhe'),
(3, '+6285333864335', 'Farid');

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

--
-- Table structure for table `gudang`
--

CREATE TABLE `gudang` (
  `id` int(20) NOT NULL,
  `id_local` int(20) NOT NULL,
  `nama` varchar(1000) CHARACTER SET latin1 NOT NULL,
  `image` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `quantity` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `barcode` varchar(100) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `gudang`
--

INSERT INTO `gudang` (`id`, `id_local`, `nama`, `image`, `quantity`, `barcode`) VALUES
(42, 0, '', '1563288668975.jpg', '', '');

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

--
-- Table structure for table `history`
--

CREATE TABLE `history` (
  `id_history` int(8) NOT NULL,
  `no_telp` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `latitude` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `longitude` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `desc_history` text COLLATE utf8_unicode_ci NOT NULL,
  `tanggal` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `history`
--

INSERT INTO `history` (`id_history`, `no_telp`, `latitude`, `longitude`, `desc_history`, `tanggal`) VALUES
(27, '+6281218041018', '-7.9204106', '112.5887561', 'hei', '2019-02-01 20:31:42'),
(28, '+6281218041018', '-7.9204104', '112.5887401', 'hei', '2019-02-01 20:32:16'),
(29, '+6281218041018', '-7.9203366', '112.5887312', 'apa', '2019-02-02 06:05:47'),
(30, '+6281218041018', '-7.9203866', '112.5887396', 'apa', '2019-02-02 06:05:50'),
(31, '+6281218041018', '-7.9204028', '112.5887478', 'saya aman', '2019-02-02 06:07:02'),
(32, '+6281218041018', '-7.9204261', '112.588724', 'saya sudah aman', '2019-02-02 08:46:17'),
(33, '+6281218041018', '-7.9204629', '112.5887145', 'saya sudah aman', '2019-02-02 08:46:37'),
(34, '+6281218041018', '-7.9204401', '112.588722', 'aman', '2019-02-02 08:56:08'),
(35, '+6281218041018', '-7.9204166', '112.5887307', 'aman', '2019-02-02 10:18:53'),
(36, '+6281218041018', '-7.9204185', '112.5887397', 'zudah', '2019-02-06 17:27:17'),
(37, '+6281218041018', '-7.9213357', '112.5802901', 'udah', '2019-02-09 13:36:59'),
(38, '+6281218041018', '-7.921315', '112.5802869', 'saya aman', '2019-02-09 16:39:08'),
(39, '+6281232575959', '-7.9213514', '112.5802831', 'saya aman', '2019-02-09 16:39:20'),
(40, '+6281232575959', '-7.9213489', '112.5802813', 'saya aman', '2019-02-09 16:39:22'),
(41, '+6281232575959', '-7.9213489', '112.5802813', 'saya aman', '2019-02-09 16:39:23'),
(42, '+6281232575959', '-7.9213489', '112.5802813', 'saya aman', '2019-02-09 16:39:24'),
(43, '+6281232575959', '-7.9213489', '112.5802813', 'saya aman', '2019-02-09 16:39:26'),
(44, '+6281232575959', '-7.9213489', '112.5802813', 'saya aman', '2019-02-09 16:39:27'),
(45, '+6281232575959', '-7.9213489', '112.5802813', 'saya aman', '2019-02-09 16:39:29'),
(46, '+6281232575959', '-7.9213489', '112.5802813', 'saya aman', '2019-02-09 16:39:30'),
(47, '+6281232575959', '-7.9213489', '112.5802813', 'saya aman', '2019-02-09 16:39:32'),
(48, '+6281232575959', '-7.9213489', '112.5802813', 'saya aman', '2019-02-09 16:39:34'),
(49, '+6281232575959', '-7.9213489', '112.5802813', 'saya aman', '2019-02-09 16:39:35'),
(50, '+6281232575959', '-7.9213489', '112.5802813', 'saya aman', '2019-02-09 16:39:37'),
(51, '+6281232575959', '-7.9213489', '112.5802813', 'saya aman', '2019-02-09 16:39:38'),
(52, '+6281218041018', '-7.9204223', '112.5887395', 'sudah aman', '2019-02-27 13:39:56'),
(53, '+6281218041018', '-7.9204235', '112.5887492', 'aman saya', '2019-02-27 13:41:05'),
(54, '+6281218041018', '-7.920889', '112.5984478', 'saya aman pak', '2019-03-11 05:24:51'),
(55, '+6281218041018', '-7.920889', '112.5984478', 'saya aman', '2019-03-11 05:26:05'),
(56, '+6281218041018', '-7.9203993', '112.5887828', 'saya sudah aman', '2019-03-12 18:38:03'),
(57, '+6281218041018', '-7.9203847', '112.5887129', 'saya aman', '2019-03-13 02:25:02'),
(58, '+6281218041018', '-7.9204193', '112.5887482', 'saya aman yaaaaaaa', '2019-03-13 18:47:38'),
(59, '+6281218041018', '-7.9204211', '112.5887395', 'sa su mati', '2019-03-22 08:56:38'),
(60, '+6281218041018', '-7.9204211', '112.5887395', 'aman', '2019-03-25 14:08:08'),
(61, '+6289652439566', '-7.9204318', '112.5887467', 'aman', '2019-03-27 18:48:36'),
(62, '+6289652439566', '-7.9206661', '112.5970236', 'saya aman', '2019-03-28 06:59:31'),
(63, '+6289652439566', '-7.9206661', '112.5970236', 'saya aman', '2019-03-28 06:59:32'),
(64, '+6289652439566', '-7.9206813', '112.5973924', 'aman', '2019-03-28 07:01:36'),
(65, '+6289652439566', '-7.9206813', '112.5973924', 'aman', '2019-03-28 07:01:42'),
(66, '+6289652439566', '-7.9204584', '112.5888486', 'saya aman', '2019-03-28 10:00:46'),
(67, '+6289652439566', '-7.9204329', '112.5887733', 'aman', '2019-03-28 14:34:02'),
(68, '+6289652439566', '-7.9204318', '112.5887467', 'saya aman', '2019-03-28 14:34:40'),
(69, '+6289652439566', '-7.9204361', '112.5887703', 'im save', '2019-03-28 14:35:32'),
(70, '+6289652439566', '-7.9204272', '112.5887679', 'im save', '2019-03-28 14:35:43'),
(71, '+6289652439566', '-7.9204205', '112.5887035', 'aman saya', '2019-03-29 11:37:39'),
(72, '+6289652439566', '-7.9204318', '112.5887467', 'aman bosku', '2019-03-31 09:11:27'),
(73, '+6289652439566', '-7.9204399', '112.588774', 'bosku aman nih', '2019-03-31 09:12:17'),
(74, '+6289652439566', '-7.9204488', '112.588805', 'aman saya pak', '2019-03-31 13:59:46'),
(75, '+6289652439566', '-7.3575438', '112.7286527', 'saya aman', '2019-04-02 11:07:50'),
(76, '+6289652439566', '-7.9198911', '112.5880185', 'saya aman', '2019-04-22 13:29:34'),
(77, '+6289652439566', '-7.9198911', '112.5880185', 'saya aman', '2019-04-22 13:30:02'),
(78, '+6289652439566', '-7.9198911', '112.5880185', 'saya aman', '2019-04-22 13:30:04'),
(79, '+6289652439566', '-7.9213757', '112.5898809', 'saya aman', '2019-04-22 13:45:08'),
(80, '+6289652439566', '-7.9213757', '112.5898809', 'saya aman', '2019-04-22 13:47:49'),
(81, '+6289652439566', '-7.92049', '112.5887122', 'saya aman', '2019-04-22 13:51:46'),
(82, '+6289652439566', '-7.9205324', '112.5887082', 'saya aman', '2019-04-22 13:55:28'),
(83, '+6289652439566', '-7.9203851', '112.5887857', 'saya aman', '2019-04-22 14:00:23'),
(84, '+6289652439566', '-7.9203956', '112.5887105', 'saya aman', '2019-04-22 14:03:39'),
(85, '+6289652439566', '-7.9204475', '112.5887751', 'sudah', '2019-04-22 14:30:32'),
(86, '+6289652439566', '-7.9204114', '112.5887381', 'saya aman', '2019-04-22 14:42:20'),
(87, '+6289652439566', '-7.920415', '112.5887295', 'ya', '2019-04-22 14:46:25'),
(88, '+6289652439566', '-7.9213757', '112.5898809', 'aman saya', '2019-04-22 16:12:28'),
(89, '+6289652439566', '-7.9213757', '112.5898809', 'aman', '2019-04-22 16:13:47'),
(90, '+6289652439566', '-7.9213757', '112.5898809', 'aman', '2019-04-22 16:14:25'),
(91, '+6289652439566', '-7.9204712', '112.5888062', 'saya aman', '2019-04-22 16:17:35'),
(92, '+6289652439566', '-7.9204373', '112.588768', 'aman', '2019-04-22 16:18:09'),
(93, '+6289652439566', '-7.9204106', '112.5887375', 'Alhamdulillah', '2019-04-22 16:22:05'),
(94, '+6289652439566', '-7.9204336', '112.5887226', 'aman', '2019-04-23 10:32:15'),
(95, '+6289652439566', '-7.9204277', '112.5886438', 'aman', '2019-04-23 10:34:07'),
(96, '+6289652439566', '-7.9204212', '112.588738', 'saya aman', '2019-04-23 20:09:56'),
(97, '+6289652439566', '-7.9204019', '112.588724', 'saya aman', '2019-04-24 16:32:43'),
(98, '+6289652439566', '-7.920387', '112.588716', 'saya aman', '2019-04-24 16:33:52'),
(99, '+6289652439566', '-7.8715168', '112.5263368', '', '2019-04-28 13:40:03'),
(100, '+6289652439566', '-7.8715168', '112.5263368', '', '2019-04-28 13:40:05'),
(101, '+6289652439566', '-7.8715168', '112.5263368', 'iya', '2019-04-28 13:40:08'),
(102, '+6289652439566', '-7.9204212', '112.588738', 'aman', '2019-04-28 18:23:30'),
(103, '+6289652439566', '-7.9204212', '112.588738', 'aman', '2019-04-28 18:23:57'),
(104, '+6289652439566', '-7.9204265', '112.5887322', 'saya aman', '2019-05-06 08:35:28'),
(105, '+6289652439566', '-7.9204306', '112.5887467', 'saya sudah aman pak', '2019-05-07 18:06:12'),
(106, '+6289652439566', '-7.9204306', '112.5887467', 'saya sudah aman pak', '2019-05-07 18:08:40'),
(107, '+6289652439566', '-7.9204306', '112.5887467', 'saya sudah aman pak', '2019-05-09 09:19:40'),
(108, '+6289652439566', '-7.9204306', '112.5887467', 'saya sudah aman', '2019-05-09 09:20:40'),
(109, '+6289652439566', '-7.9204306', '112.5887467', 'saya sudah aman', '2019-05-09 09:21:36'),
(110, '+6289652439566', '-7.9204306', '112.5887467', 'saya aman', '2019-05-10 15:47:56'),
(111, '+6289652439566', '-7.9204306', '112.5887467', 'saya aman', '2019-05-10 15:48:17'),
(112, '+6289652439566', '-7.9204306', '112.5887467', 'saya aman', '2019-05-10 15:49:49'),
(113, '+6289652439566', '-7.9204306', '112.5887467', 'aman', '2019-05-10 15:51:11'),
(114, '+6289652439566', '-7.9213395', '112.5995569', 'saya amaan', '2019-05-13 04:55:48'),
(115, '+6289652439566', '-7.9213395', '112.5995569', 'saya amaan', '2019-05-13 04:55:50'),
(116, '+6289652439566', '-7.9220554', '112.6003102', 'saya aman', '2019-05-13 04:56:52'),
(117, '+6289652439566', '-7.9220554', '112.6003102', 'saya aman', '2019-05-13 04:56:53'),
(118, '+6289652439566', '-7.9204306', '112.5887467', 'saya aman', '2019-05-13 17:27:10'),
(119, '+6289652439566', '-7.9211153', '112.5992179', 'saya aman', '2019-06-18 02:41:43'),
(120, '+6289652439566', '-7.9207409', '112.6010551', 'aman', '2019-06-18 04:59:30'),
(121, '+6289652439566', '-7.9204214', '112.5898809', 'amin', '2019-06-21 07:32:14'),
(122, '+6289652439566', '-7.941503', '112.609458', 'saya aman', '2019-06-28 01:33:05'),
(123, '+6289652439566', '-7.9414663', '112.6094269', 'aman', '2019-06-28 01:48:39'),
(124, '+6289652439566', '-7.9414663', '112.6094269', 'aman', '2019-06-28 01:48:40'),
(125, '+6289652439566', '-7.9419048', '112.6092495', 'aman', '2019-06-28 01:49:25'),
(126, '+6289652439566', '-7.9414759', '112.6094416', 'aman', '2019-06-28 01:50:29'),
(127, '+6289652439566', '-7.94153', '112.6094131', 'saya aman', '2019-06-28 01:53:18'),
(128, '+6289652439566', '-7.9204145', '112.5887151', 'aman', '2019-06-28 03:25:24'),
(129, '+6289652439566', '-7.9210927', '112.599262', 'aman', '2019-07-08 04:26:39'),
(130, '+6289652439566', '-7.9541256', '112.6153608', 'aman', '2019-07-09 01:59:16'),
(131, '+6289652439566', '-7.920441', '112.5887162', 'aman', '2019-07-09 12:00:39'),
(132, '+6289652439566', '-7.9201578', '112.5887922', 'aman', '2019-07-09 12:09:16'),
(133, '+6289652439566', '-7.920441', '112.5887162', 'aman', '2019-07-09 12:31:48'),
(134, '+6289652439566', '-7.9213175', '112.5995937', 'aman', '2019-07-12 06:17:20'),
(135, '+6289652439566', '-7.9468305', '112.6127582', 'aman bos', '2019-07-16 14:50:03'),
(136, '+6289652439566', '-7.9468453', '112.6127166', 'ya', '2019-07-16 15:07:20'),
(137, '+6289652439566', '-7.9468348', '112.6127543', 'aman', '2019-07-16 15:33:10'),
(138, '+6289652439566', '-7.9467006', '112.6127944', 'aman', '2019-07-16 15:35:06'),
(139, '+6289652439566', '-7.9468266', '112.6127501', 'aman', '2019-07-16 15:47:28'),
(140, '+6289652439566', '-7.9468133', '112.6125889', 'aman', '2019-07-16 15:50:47'),
(141, '+6289652439566', '-7.9468309', '112.6127336', 'aman', '2019-07-16 15:50:48'),
(142, '+6289652439566', '-7.9468133', '112.6125889', 'aman', '2019-07-16 15:50:48'),
(143, '+6289652439566', '-7.9468381', '112.6127314', 'aman', '2019-07-16 16:01:07'),
(144, '+6289652439566', '-7.9541874', '112.6151171', 'aman', '2019-07-17 02:13:19'),
(145, '+6289652439566', '-7.9541874', '112.6151171', 'yea', '2019-07-17 03:36:47'),
(146, '+6289652439566', '-7.9541766', '112.6151034', 'aman', '2019-07-17 03:55:09'),
(147, '+6289652439566', '-7.9541719', '112.615112', 'ama', '2019-07-17 04:07:08'),
(148, '+6289652439566', '-7.9541874', '112.6151171', 'ye', '2019-07-17 04:20:25'),
(149, '+6289652439566', '-7.9541818', '112.6151157', 'aman', '2019-07-17 04:24:45'),
(150, '+6289652439566', '-7.9541874', '112.6151171', 'aman', '2019-07-17 04:29:10'),
(151, '+6289652439566', '-7.9541682', '112.6151252', 'aman', '2019-07-17 04:48:13'),
(152, '+6289652439566', '-7.9541685', '112.6151247', 'aman', '2019-07-17 04:56:12'),
(153, '+6289652439566', '-7.9541874', '112.6151171', 'aman', '2019-07-17 05:10:27'),
(154, '+6289652439566', '-7.9541874', '112.6151171', 'aman', '2019-07-17 05:11:04'),
(155, '+6289652439566', '-7.9540179', '112.6153342', 'aman', '2019-07-17 05:13:41'),
(156, '+6289652439566', '-7.9204421', '112.5887191', 'aman', '2019-07-19 14:51:39'),
(157, '+6289652439566', '-7.9223722', '112.5891359', 'aman', '2019-07-25 14:45:43'),
(158, '+6289652439566', '-7.9210714', '112.5958943', 'apa', '2019-07-26 03:25:04'),
(159, '+6289652439566', '-7.9233271', '112.5947231', 'aman', '2019-07-26 03:29:26');

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

--
-- Table structure for table `lokasiprd`
--

CREATE TABLE `lokasiprd` (
  `id_prd` int(10) NOT NULL,
  `latitude` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `longitude` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `keterangan` text COLLATE utf8_unicode_ci NOT NULL,
  `no_telp` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `alamat` text COLLATE utf8_unicode_ci NOT NULL,
  `kategori` varchar(20) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lokasiprd`
--

INSERT INTO `lokasiprd` (`id_prd`, `latitude`, `longitude`, `keterangan`, `no_telp`, `alamat`, `kategori`) VALUES
(3, '-7.925935', '112.5986148', 'Rumah Sakit Umum Universitas Muhammadiyah Malang', '(0341) 561666', 'Jl. Raya Tlogomas No.45, Dusun Rambaan, Tlogomas, Kec. Lowokwaru, Kota Malang, Jawa Timur 65144', 'rs'),
(4, '-7.940134', '112.6083798', 'Rumah Sakit Islam UNISMA Malang', '(0341) 551356', 'Jalan, Jl. Mayjen Haryono Gg. 10 No.139, Dinoyo, Kec. Lowokwaru, Kota Malang, Jawa Timur 65144', 'rs'),
(5, '-7.9417826', '112.6201451', 'Rumah Sakit Universitas Brawijaya', '(0341) 403000', 'Jl. Soekarno - Hatta, Lowokwaru, Kec. Lowokwaru, Kota Malang, Jawa Timur 65141', 'rs'),
(6, '-7.9410574', '112.609091', 'Kantor Polsek Lowokwaru', '(0341) 570200', 'Gang 13 Jalan M.T. Haryono No.413, Dinoyo, Kecamatan Lowokwaru, Dinoyo, Kec. Lowokwaru, Kota Malang, Jawa Timur 65144', 'kepolisian'),
(7, '-7.9719846', '112.6286592', 'Polresta Malang', '(0341) 364211', 'Jl. Jaksa Agung Suprapto No.19, Samaan, Klojen, Kota Malang, Jawa Timur 65112', 'kepolisian'),
(8, '-7.9932448', '112.6256402', 'Pemadam Kebakaran Kota Malang', '(0341) 362222', 'Jl. Bingkil No.1, Ciptomulyo, Sukun, Kota Malang, Jawa Timur 65148', 'damkar');

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

--
-- Table structure for table `saranpertanyaan`
--

CREATE TABLE `saranpertanyaan` (
  `id_saranpertanyaan` int(10) NOT NULL,
  `no_telp` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `kategori` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `deskripsi` text COLLATE utf8_unicode_ci NOT NULL,
  `tanggal` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `saranpertanyaan`
--

INSERT INTO `saranpertanyaan` (`id_saranpertanyaan`, `no_telp`, `email`, `kategori`, `deskripsi`, `tanggal`) VALUES
(25, '+6289652439566', 'fariddadhe@gmail.com', 'Pertanyaan', 'saya mau bertanya', '2019-05-07 16:32:58'),
(26, '+6289652439566', 'fariddadhe@gmail.com', 'Saran', 'saya ingin memberi saran', '2019-05-07 16:33:43'),
(27, '+6289652439566', 'fariddadhe@gmail.com', 'Saran', 'saya ingin memberi saran', '2019-05-07 16:34:20');

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

--
-- Table structure for table `warga`
--

CREATE TABLE `warga` (
  `id_warga` int(9) NOT NULL,
  `no_telp` varchar(16) NOT NULL,
  `nama` varchar(30) NOT NULL,
  `no_ktp` int(20) NOT NULL,
  `email` varchar(40) NOT NULL,
  `tempat_lahir` varchar(20) NOT NULL,
  `jenis_kelamin` varchar(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `warga`
--

INSERT INTO `warga` (`id_warga`, `no_telp`, `nama`, `no_ktp`, `email`, `tempat_lahir`, `jenis_kelamin`) VALUES
(64, '+6281218041018', 'dadhe', 2147483647, 'zerallie@gmail.com', 'malang', 'Laki-laki'),
(75, '+6289652439566', 'farid', 222838383, 'fariddadhe@gmail.com', 'sorong', 'Laki-laki');

--
-- Indexes for table `bantuan`
--
ALTER TABLE `bantuan`
  ADD PRIMARY KEY (`id_bantuan`);

--
-- Indexes for table `firebase`
--
ALTER TABLE `firebase`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `gudang`
--
ALTER TABLE `gudang`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `history`
--
ALTER TABLE `history`
  ADD PRIMARY KEY (`id_history`);

--
-- Indexes for table `lokasiprd`
--
ALTER TABLE `lokasiprd`
  ADD PRIMARY KEY (`id_prd`);

--
-- Indexes for table `saranpertanyaan`
--
ALTER TABLE `saranpertanyaan`
  ADD PRIMARY KEY (`id_saranpertanyaan`);

--
-- Indexes for table `warga`
--
ALTER TABLE `warga`
  ADD PRIMARY KEY (`id_warga`);

--
-- AUTO_INCREMENT for table `bantuan`
--
ALTER TABLE `bantuan`
  MODIFY `id_bantuan` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;

--
-- AUTO_INCREMENT for table `firebase`
--
ALTER TABLE `firebase`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `gudang`
--
ALTER TABLE `gudang`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT for table `history`
--
ALTER TABLE `history`
  MODIFY `id_history` int(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=160;

--
-- AUTO_INCREMENT for table `lokasiprd`
--
ALTER TABLE `lokasiprd`
  MODIFY `id_prd` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `saranpertanyaan`
--
ALTER TABLE `saranpertanyaan`
  MODIFY `id_saranpertanyaan` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `warga`
--
ALTER TABLE `warga`
  MODIFY `id_warga` int(9) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76;
COMMIT;

