ShVzAm6M

1SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
2SET time_zone = "+00:00";
3
4--
5-- Database: `db_pertamina`
6--
7DROP DATABASE IF EXISTS db_pertamina;
8CREATE DATABASE db_pertamina;
9use db_pertamina;
10-- --------------------------------------------------------
11
12--
13-- Table structure for table `bahan_bakar`
14--
15
16CREATE TABLE `bahan_bakar` (
17  `id` int(10) NOT NULL,
18  `jenis_bahanbakar` text NOT NULL,
19  `ron` int(11) NOT NULL,
20  `harga` int(11) NOT NULL
21) ENGINE=InnoDB DEFAULT CHARSET=utf8;
22
23--
24-- Dumping data for table `bahan_bakar`
25--
26
27INSERT INTO `bahan_bakar` (`id`, `jenis_bahanbakar`, `ron`, `harga`) VALUES
28(101, 'premium', 88, 6450),
29(102, 'pertalite', 90, 6900),
30(103, 'pertamax', 92, 7600),
31(104, 'pertamax plus', 95, 8450),
32(105, 'pertamax turbo', 98, 8750),
33(201, 'dexlite', 88, 6750),
34(202, 'pertamax dex', 88, 8000);
35
36--
37-- Indexes for dumped tables
38--
39
40--
41-- Indexes for table `bahan_bakar`
42--
43ALTER TABLE `bahan_bakar`
44  ADD PRIMARY KEY (`id`);