[MYSQL] DATABASE aplikasi bbm

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `db_pertamina`
--
DROP DATABASE IF EXISTS db_pertamina;
CREATE DATABASE db_pertamina;
use db_pertamina;
-- --------------------------------------------------------

--
-- Table structure for table `bahan_bakar`
--

CREATE TABLE `bahan_bakar` (
  `id` int(10) NOT NULL,
  `jenis_bahanbakar` text NOT NULL,
  `ron` int(11) NOT NULL,
  `harga` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bahan_bakar`
--

INSERT INTO `bahan_bakar` (`id`, `jenis_bahanbakar`, `ron`, `harga`) VALUES
(101, 'premium', 88, 6450),
(102, 'pertalite', 90, 6900),
(103, 'pertamax', 92, 7600),
(104, 'pertamax plus', 95, 8450),
(105, 'pertamax turbo', 98, 8750),
(201, 'dexlite', 88, 6750),
(202, 'pertamax dex', 88, 8000);

--
-- Indexes for dumped tables
--

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