G2A Many GEOs
SHARE
TWEET

Untitled

oodz May 22nd, 2018 50 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
Ledger Nano X - The secure hardware wallet
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