· 8 years ago · May 21, 2018, 09:42 AM
1-- phpMyAdmin SQL Dump
2-- version 4.2.11
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: 21 Mei 2018 pada 11.36
7-- Versi Server: 5.6.21
8-- PHP Version: 5.6.3
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: `nota`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktur dari tabel `angkutan`
27--
28
29CREATE TABLE IF NOT EXISTS `angkutan` (
30`id_tx` int(11) NOT NULL,
31 `id_pa` int(11) NOT NULL,
32 `nama` varchar(15) NOT NULL,
33 `tgl_input` date NOT NULL,
34 `jnspjk` int(11) NOT NULL,
35 `ket` varchar(50) NOT NULL
36) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
37
38-- --------------------------------------------------------
39
40--
41-- Struktur dari tabel `gd_total`
42--
43
44CREATE TABLE IF NOT EXISTS `gd_total` (
45`id_gdtot` int(11) NOT NULL,
46 `id_tx` int(11) NOT NULL,
47 `tgl_input` date NOT NULL,
48 `id_pa` int(11) NOT NULL,
49 `gdtotal` int(11) NOT NULL,
50 `jnsbyr` varchar(20) NOT NULL,
51 `pembulatan` int(11) NOT NULL,
52 `tglbyr` varchar(10) NOT NULL,
53 `status_byr` varchar(20) NOT NULL
54) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
55
56-- --------------------------------------------------------
57
58--
59-- Struktur dari tabel `pembayaran`
60--
61
62CREATE TABLE IF NOT EXISTS `pembayaran` (
63`id_pem` int(11) NOT NULL,
64 `id_tx` int(11) NOT NULL,
65 `id_pa` int(11) NOT NULL,
66 `tgl_input` date NOT NULL,
67 `nama` varchar(50) NOT NULL,
68 `tglmuat` date NOT NULL,
69 `jnspjk` int(11) NOT NULL,
70 `nilaipjk` int(11) NOT NULL,
71 `nodm` varchar(10) NOT NULL,
72 `nopol` varchar(10) NOT NULL,
73 `muatan` varchar(10) NOT NULL,
74 `tujuan` varchar(10) NOT NULL,
75 `ongkos` int(11) NOT NULL,
76 `sangu` int(11) NOT NULL,
77 `biaadm` int(11) NOT NULL,
78 `status_setorpjk` varchar(20) NOT NULL,
79 `masapjk` varchar(10) NOT NULL,
80 `nopjk` int(10) NOT NULL
81) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
82
83--
84-- Indexes for dumped tables
85--
86
87--
88-- Indexes for table `angkutan`
89--
90ALTER TABLE `angkutan`
91 ADD PRIMARY KEY (`id_tx`);
92
93--
94-- Indexes for table `gd_total`
95--
96ALTER TABLE `gd_total`
97 ADD PRIMARY KEY (`id_gdtot`);
98
99--
100-- Indexes for table `pembayaran`
101--
102ALTER TABLE `pembayaran`
103 ADD PRIMARY KEY (`id_pem`);
104
105--
106-- AUTO_INCREMENT for dumped tables
107--
108
109--
110-- AUTO_INCREMENT for table `angkutan`
111--
112ALTER TABLE `angkutan`
113MODIFY `id_tx` int(11) NOT NULL AUTO_INCREMENT;
114--
115-- AUTO_INCREMENT for table `gd_total`
116--
117ALTER TABLE `gd_total`
118MODIFY `id_gdtot` int(11) NOT NULL AUTO_INCREMENT;
119--
120-- AUTO_INCREMENT for table `pembayaran`
121--
122ALTER TABLE `pembayaran`
123MODIFY `id_pem` int(11) NOT NULL AUTO_INCREMENT;
124/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
125/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
126/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;