SHARE
TWEET

Untitled

oodz May 22nd, 2018 49 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.2.11
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: 127.0.0.1
  6. -- Generation Time: 22 Mei 2018 pada 14.18
  7. -- Versi Server: 5.6.21
  8. -- PHP Version: 5.6.3
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET 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: `notax`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Struktur dari tabel `data_pa`
  27. --
  28.  
  29. CREATE TABLE IF NOT EXISTS `data_pa` (
  30. `id_pa` int(11) NOT NULL,
  31.   `nama` varchar(15) NOT NULL,
  32.   `jnspjk` int(11) NOT NULL
  33. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  34.  
  35. --
  36. -- Dumping data untuk tabel `data_pa`
  37. --
  38.  
  39. INSERT INTO `data_pa` (`id_pa`, `nama`, `jnspjk`) VALUES
  40. (1, 'pa. budi', 2),
  41. (2, 'pa. joko', 2),
  42. (3, 'pa. badrun', 2),
  43. (4, 'pa. mulya', 0);
  44.  
  45. -- --------------------------------------------------------
  46.  
  47. --
  48. -- Struktur dari tabel `gd_total`
  49. --
  50.  
  51. CREATE TABLE IF NOT EXISTS `gd_total` (
  52. `id_gdtot` int(11) NOT NULL,
  53.   `id_tx` int(11) NOT NULL,
  54.   `tgl_input` date NOT NULL,
  55.   `id_pa` int(11) NOT NULL,
  56.   `gdtotal` int(11) NOT NULL,
  57.   `status_byr` varchar(20) NOT NULL
  58. ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  59.  
  60. --
  61. -- Dumping data untuk tabel `gd_total`
  62. --
  63.  
  64. INSERT INTO `gd_total` (`id_gdtot`, `id_tx`, `tgl_input`, `id_pa`, `gdtotal`, `status_byr`) VALUES
  65. (1, 1, '2018-05-22', 1, 872000, 'Telah di Cek'),
  66. (2, 2, '2018-05-22', 2, 872000, 'Telah di Cek'),
  67. (3, 3, '2018-05-22', 3, 436000, 'Telah di Cek'),
  68. (4, 4, '2018-05-22', 1, 436000, 'Telah di Cek'),
  69. (5, 5, '2018-05-22', 4, 892000, 'Telah di Cek'),
  70. (6, 6, '2018-05-22', 2, 872000, 'Telah di Cek'),
  71. (7, 7, '2018-05-22', 1, 872000, 'Telah di Cek');
  72.  
  73. -- --------------------------------------------------------
  74.  
  75. --
  76. -- Struktur dari tabel `pembayaran`
  77. --
  78.  
  79. CREATE TABLE IF NOT EXISTS `pembayaran` (
  80. `id_pem` int(11) NOT NULL,
  81.   `id_tx` int(11) NOT NULL,
  82.   `id_pa` int(11) NOT NULL,
  83.   `tgl_input` date NOT NULL,
  84.   `nama` varchar(50) NOT NULL,
  85.   `tglmuat` date NOT NULL,
  86.   `jnspjk` int(11) NOT NULL,
  87.   `nilaipjk` int(11) NOT NULL,
  88.   `nodm` varchar(10) NOT NULL,
  89.   `nopol` varchar(10) NOT NULL,
  90.   `muatan` varchar(10) NOT NULL,
  91.   `tujuan` varchar(10) NOT NULL,
  92.   `ongkos` int(11) NOT NULL,
  93.   `sangu` int(11) NOT NULL,
  94.   `biaadm` int(11) NOT NULL,
  95.   `status_setorpjk` varchar(20) NOT NULL,
  96.   `masapjk` varchar(10) NOT NULL,
  97.   `nopjk` int(10) NOT NULL
  98. ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  99.  
  100. --
  101. -- Dumping data untuk tabel `pembayaran`
  102. --
  103.  
  104. INSERT INTO `pembayaran` (`id_pem`, `id_tx`, `id_pa`, `tgl_input`, `nama`, `tglmuat`, `jnspjk`, `nilaipjk`, `nodm`, `nopol`, `muatan`, `tujuan`, `ongkos`, `sangu`, `biaadm`, `status_setorpjk`, `masapjk`, `nopjk`) VALUES
  105. (1, 1, 1, '2018-05-22', 'pa. budi', '2018-05-04', 2, 10000, '11111', 'H.1111.KP', 'BERAS', 'BOGOR', 500000, 50000, 4000, 'Belum di Setor', '', 0),
  106. (2, 1, 1, '2018-05-22', 'pa. budi', '2018-05-04', 2, 10000, '11112', 'H.1112.KP', 'BERAS', 'BOGOR', 500000, 50000, 4000, 'Belum di Setor', '', 0),
  107. (3, 2, 2, '2018-05-22', 'pa. joko', '2018-05-04', 2, 10000, '11113', 'H.1113.KP', 'BERAS', 'BOGOR', 500000, 50000, 4000, 'Belum di Setor', '', 0),
  108. (4, 2, 2, '2018-05-22', 'pa. joko', '2018-05-04', 2, 10000, '11114', 'H.1114.KP', 'BERAS', 'BOGOR', 500000, 50000, 4000, 'Belum di Setor', '', 0),
  109. (5, 3, 3, '2018-05-22', 'pa. badrun', '2018-05-04', 2, 10000, '11115', 'H.1115.KP', 'BERAS', 'BOGOR', 500000, 50000, 4000, 'Belum di Setor', '', 0),
  110. (6, 4, 1, '2018-05-22', 'pa. budi', '2018-05-04', 2, 10000, '11116', 'H.1116.KP', 'BERAS', 'BOGOR', 500000, 50000, 4000, 'Belum di Setor', '', 0),
  111. (7, 5, 4, '2018-05-22', 'pa. mulya', '2018-05-04', 0, 0, '11117', 'H.1117.KP', 'BERAS', 'BOGOR', 500000, 50000, 4000, '0', '', 0),
  112. (8, 5, 4, '2018-05-22', 'pa. mulya', '2018-05-04', 0, 0, '11118', 'H.1118.KP', 'BERAS', 'BOGOR', 500000, 50000, 4000, '0', '', 0),
  113. (9, 6, 2, '2018-05-22', 'pa. joko', '2018-05-04', 2, 10000, '11119', 'H.1119.KP', 'BERAS', 'BOGOR', 500000, 50000, 4000, 'Belum di Setor', '', 0),
  114. (10, 6, 2, '2018-05-22', 'pa. joko', '2018-05-04', 2, 10000, '11120', 'H.1120.KP', 'BERAS', 'BOGOR', 500000, 50000, 4000, 'Belum di Setor', '', 0),
  115. (11, 7, 1, '2018-05-22', 'pa. budi', '2018-05-04', 2, 10000, '11121', 'H.1121.KP', 'BERAS', 'BOGOR', 500000, 50000, 4000, 'Belum di Setor', '', 0),
  116. (12, 7, 1, '2018-05-22', 'pa. budi', '2018-05-04', 2, 10000, '11122', 'H.1122.KP', 'BERAS', 'BOGOR', 500000, 50000, 4000, 'Belum di Setor', '', 0);
  117.  
  118. -- --------------------------------------------------------
  119.  
  120. --
  121. -- Struktur dari tabel `tx_pa`
  122. --
  123.  
  124. CREATE TABLE IF NOT EXISTS `tx_pa` (
  125. `id_tx` int(11) NOT NULL,
  126.   `id_pa` int(11) NOT NULL,
  127.   `tgl_input` date NOT NULL
  128. ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  129.  
  130. --
  131. -- Dumping data untuk tabel `tx_pa`
  132. --
  133.  
  134. INSERT INTO `tx_pa` (`id_tx`, `id_pa`, `tgl_input`) VALUES
  135. (1, 1, '2018-05-22'),
  136. (2, 2, '2018-05-22'),
  137. (3, 3, '2018-05-22'),
  138. (4, 1, '2018-05-22'),
  139. (5, 4, '2018-05-22'),
  140. (6, 2, '2018-05-22'),
  141. (7, 1, '2018-05-22');
  142.  
  143. --
  144. -- Indexes for dumped tables
  145. --
  146.  
  147. --
  148. -- Indexes for table `data_pa`
  149. --
  150. ALTER TABLE `data_pa`
  151.  ADD PRIMARY KEY (`id_pa`);
  152.  
  153. --
  154. -- Indexes for table `gd_total`
  155. --
  156. ALTER TABLE `gd_total`
  157.  ADD PRIMARY KEY (`id_gdtot`);
  158.  
  159. --
  160. -- Indexes for table `pembayaran`
  161. --
  162. ALTER TABLE `pembayaran`
  163.  ADD PRIMARY KEY (`id_pem`);
  164.  
  165. --
  166. -- Indexes for table `tx_pa`
  167. --
  168. ALTER TABLE `tx_pa`
  169.  ADD PRIMARY KEY (`id_tx`);
  170.  
  171. --
  172. -- AUTO_INCREMENT for dumped tables
  173. --
  174.  
  175. --
  176. -- AUTO_INCREMENT for table `data_pa`
  177. --
  178. ALTER TABLE `data_pa`
  179. MODIFY `id_pa` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
  180. --
  181. -- AUTO_INCREMENT for table `gd_total`
  182. --
  183. ALTER TABLE `gd_total`
  184. MODIFY `id_gdtot` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
  185. --
  186. -- AUTO_INCREMENT for table `pembayaran`
  187. --
  188. ALTER TABLE `pembayaran`
  189. MODIFY `id_pem` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=13;
  190. --
  191. -- AUTO_INCREMENT for table `tx_pa`
  192. --
  193. ALTER TABLE `tx_pa`
  194. MODIFY `id_tx` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
  195. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  196. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  197. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top