-- phpMyAdmin SQL Dump
-- version 4.9.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Dec 30, 2019 at 08:57 AM
-- Server version: 10.4.11-MariaDB
-- PHP Version: 7.4.0

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `db_skdpt`
--

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

--
-- Table structure for table `img_all`
--

CREATE TABLE `img_all` (
  `id_img` int(20) NOT NULL,
  `detail` int(100) NOT NULL,
  `path` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `img_jenis_sapi` tinyint(1) NOT NULL,
  `img_profile` tinyint(1) NOT NULL,
  `img_ternak` tinyint(1) NOT NULL,
  `other` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jenis_pakan`
--

CREATE TABLE `jenis_pakan` (
  `id` int(20) NOT NULL,
  `jenis` varchar(80) NOT NULL,
  `detail_jenis_pakan` varchar(400) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `jenis_pakan`
--

INSERT INTO `jenis_pakan` (`id`, `jenis`, `detail_jenis_pakan`) VALUES
(1, 'Rumput lapangan', ''),
(2, 'Rumput grinting', ''),
(3, 'Rumput tanaman', ''),
(4, 'Rumput benggala', ''),
(5, 'Rumput kolonjono', ''),
(6, 'Rumput tuton', ''),
(7, 'Daun leguminoss', '');

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

--
-- Table structure for table `jenis_sapi`
--

CREATE TABLE `jenis_sapi` (
  `id` int(20) NOT NULL,
  `jenis` varchar(80) NOT NULL,
  `detail_jenis_sapi` varchar(400) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `jenis_sapi`
--

INSERT INTO `jenis_sapi` (`id`, `jenis`, `detail_jenis_sapi`) VALUES
(1, 'Limousine (Limosin)', ''),
(2, 'Brahman', ''),
(3, 'Simmental', ''),
(4, 'PO (Peranakan Ongole)', ''),
(5, 'Ongole', ''),
(6, 'Madura', ''),
(7, 'Bali', '');

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

--
-- Table structure for table `ternak`
--

CREATE TABLE `ternak` (
  `id` int(20) NOT NULL,
  `id_user` varchar(40) NOT NULL,
  `time_input` varchar(100) NOT NULL,
  `jenis_kelamin` tinyint(1) NOT NULL DEFAULT 0,
  `lokasi_kandang` varchar(80) NOT NULL,
  `jenis_ternak` int(20) NOT NULL,
  `umur_ternak` varchar(80) NOT NULL,
  `berat_ternak` varchar(80) NOT NULL,
  `jenis_pakan` int(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(20) NOT NULL,
  `full_name` varchar(100) NOT NULL,
  `username` varchar(80) NOT NULL,
  `email` varchar(120) NOT NULL,
  `password` varchar(120) NOT NULL,
  `kontak` varchar(100) NOT NULL,
  `alamat` varchar(250) NOT NULL,
  `level` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `full_name`, `username`, `email`, `password`, `kontak`, `alamat`, `level`) VALUES
(1, 'test gz', 'testgz', 'gz@test.com', 'passwordtest', '081297831682', 'Btn.Simpang Limax', 0),
(2, 'Abdul Djalil Djayali', 'jlcnate', 'jlcnate.zit@gmail.com', 'jlcnate', '082264439233', 'Kel. Toboleu. Ternate Utara', 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `img_all`
--
ALTER TABLE `img_all`
  ADD PRIMARY KEY (`id_img`);

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

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

--
-- Indexes for table `ternak`
--
ALTER TABLE `ternak`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_user` (`id_user`),
  ADD KEY `jenis_ternak` (`jenis_ternak`),
  ADD KEY `jenis_pakan` (`jenis_pakan`);

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

--
-- AUTO_INCREMENT for table `ternak`
--
ALTER TABLE `ternak`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;