SHARE
TWEET

Untitled

oodz May 21st, 2018 98 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: 21 Mei 2018 pada 11.36
  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: `nota`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Struktur dari tabel `angkutan`
  27. --
  28.  
  29. CREATE 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.  
  44. CREATE 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.  
  62. CREATE 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. --
  90. ALTER TABLE `angkutan`
  91.  ADD PRIMARY KEY (`id_tx`);
  92.  
  93. --
  94. -- Indexes for table `gd_total`
  95. --
  96. ALTER TABLE `gd_total`
  97.  ADD PRIMARY KEY (`id_gdtot`);
  98.  
  99. --
  100. -- Indexes for table `pembayaran`
  101. --
  102. ALTER 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. --
  112. ALTER TABLE `angkutan`
  113. MODIFY `id_tx` int(11) NOT NULL AUTO_INCREMENT;
  114. --
  115. -- AUTO_INCREMENT for table `gd_total`
  116. --
  117. ALTER TABLE `gd_total`
  118. MODIFY `id_gdtot` int(11) NOT NULL AUTO_INCREMENT;
  119. --
  120. -- AUTO_INCREMENT for table `pembayaran`
  121. --
  122. ALTER TABLE `pembayaran`
  123. MODIFY `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 */;
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