· 8 years ago · May 21, 2018, 03:20 PM
1-- phpMyAdmin SQL Dump
2-- version 3.4.5
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: May 21, 2018 at 05:09 PM
7-- Server version: 5.5.16
8-- PHP Version: 5.3.8
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `jual`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `tahun16`
27--
28
29CREATE TABLE IF NOT EXISTS `tahun16` (
30 `THBL` varchar(11) NOT NULL,
31 `ID` varchar(11) NOT NULL,
32 `JUMLAH` varchar(11) NOT NULL,
33 `KETERANGAN` varchar(30) NOT NULL
34) ENGINE=InnoDB DEFAULT CHARSET=latin1;
35
36--
37-- Dumping data for table `tahun16`
38--
39
40INSERT INTO `tahun16` (`THBL`, `ID`, `JUMLAH`, `KETERANGAN`) VALUES
41('201601', '0004', '40', 'oke'),
42('201602', '0004', '60', 'oke'),
43('201603', '0004', '81', 'oke'),
44('201604', '0004', '60', 'oke'),
45('201605', '0004', '90', 'oke'),
46('201605', '0004', '120', 'oke'),
47('201606', '0004', '99', 'oke'),
48('201607', '0004', '220', 'oke'),
49('201608', '0004', '70', 'oke'),
50('201609', '0004', '50', 'oke'),
51('201610', '0004', '55', 'oke'),
52('201611', '0004', '77', 'oke'),
53('201612', '0004', '79', 'oke');
54
55-- --------------------------------------------------------
56
57--
58-- Table structure for table `tahun17`
59--
60
61CREATE TABLE IF NOT EXISTS `tahun17` (
62 `THBL` varchar(11) NOT NULL,
63 `ID` varchar(11) NOT NULL,
64 `JUMLAH` varchar(11) NOT NULL,
65 `KETERANGAN` varchar(30) NOT NULL
66) ENGINE=InnoDB DEFAULT CHARSET=latin1;
67
68--
69-- Dumping data for table `tahun17`
70--
71
72INSERT INTO `tahun17` (`THBL`, `ID`, `JUMLAH`, `KETERANGAN`) VALUES
73('201706', '0004', '50', 'oke'),
74('201707', '0004', '68', 'oke'),
75('201708', '0004', '73', 'OKE'),
76('201709', '0004', '84', 'oke'),
77('201710', '0004', '83', 'oke'),
78('201711', '0004', '82', 'oke'),
79('201712', '0004', '71', 'oke');
80
81-- --------------------------------------------------------
82
83--
84-- Table structure for table `tahun18`
85--
86
87CREATE TABLE IF NOT EXISTS `tahun18` (
88 `THBL` varchar(11) NOT NULL,
89 `ID` varchar(11) NOT NULL,
90 `JUMLAH` varchar(11) NOT NULL,
91 `KETERANGAN` varchar(30) NOT NULL
92) ENGINE=InnoDB DEFAULT CHARSET=latin1;
93
94--
95-- Dumping data for table `tahun18`
96--
97
98INSERT INTO `tahun18` (`THBL`, `ID`, `JUMLAH`, `KETERANGAN`) VALUES
99('201811', '0004', '46', 'ok'),
100('201812', '0004', '55', 'ok');
101
102/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
103/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
104/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;