SHOW:
|
|
- or go back to the newest paste.
1 | -- phpMyAdmin SQL Dump | |
2 | -- version 4.7.0 | |
3 | -- https://www.phpmyadmin.net/ | |
4 | -- | |
5 | -- Host: 127.0.0.1 | |
6 | -- Generation Time: Aug 04, 2017 at 12:45 PM | |
7 | -- Server version: 10.1.25-MariaDB | |
8 | -- PHP Version: 7.1.7 | |
9 | ||
10 | SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; | |
11 | SET AUTOCOMMIT = 0; | |
12 | START TRANSACTION; | |
13 | SET time_zone = "+00:00"; | |
14 | ||
15 | ||
16 | /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; | |
17 | /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; | |
18 | /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; | |
19 | /*!40101 SET NAMES utf8mb4 */; | |
20 | ||
21 | -- | |
22 | -- Database: `codeigniterjwt` | |
23 | -- | |
24 | ||
25 | -- -------------------------------------------------------- | |
26 | ||
27 | -- | |
28 | -- Table structure for table `acl_token` | |
29 | -- | |
30 | ||
31 | CREATE TABLE `acl_token` ( | |
32 | `nama` varchar(255) NOT NULL, | |
33 | `key` varchar(255) NOT NULL, | |
34 | `value` text NOT NULL | |
35 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; | |
36 | ||
37 | -- -------------------------------------------------------- | |
38 | ||
39 | -- | |
40 | -- Table structure for table `detail_transaksi_rafi` | |
41 | -- | |
42 | ||
43 | CREATE TABLE `detail_transaksi_rafi` ( | |
44 | `id_detail` int(11) NOT NULL, | |
45 | `id_transaksi` int(11) NOT NULL, | |
46 | `id_produk` int(11) NOT NULL, | |
47 | `ttl` int(10) NOT NULL | |
48 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; | |
49 | ||
50 | -- | |
51 | -- Dumping data for table `detail_transaksi_rafi` | |
52 | -- | |
53 | ||
54 | INSERT INTO `detail_transaksi_rafi` (`id_detail`, `id_transaksi`, `id_produk`, `ttl`) VALUES | |
55 | (1, 3, 1, 40000); | |
56 | ||
57 | -- -------------------------------------------------------- | |
58 | ||
59 | -- | |
60 | -- Table structure for table `produk_rafi` | |
61 | -- | |
62 | ||
63 | CREATE TABLE `produk_rafi` ( | |
64 | `id_produk` int(11) NOT NULL, | |
65 | `nama` varchar(200) NOT NULL, | |
66 | `deskripsi` text NOT NULL, | |
67 | `harga` int(11) NOT NULL, | |
68 | `gambar` varchar(255) NOT NULL | |
69 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; | |
70 | ||
71 | -- | |
72 | -- Dumping data for table `produk_rafi` | |
73 | -- | |
74 | ||
75 | INSERT INTO `produk_rafi` (`id_produk`, `nama`, `deskripsi`, `harga`, `gambar`) VALUES | |
76 | (1, 'Barang', 'Pokoknya barang', 10000, ''); | |
77 | ||
78 | -- -------------------------------------------------------- | |
79 | ||
80 | -- | |
81 | -- Table structure for table `transaksi_rafi` | |
82 | -- | |
83 | ||
84 | CREATE TABLE `transaksi_rafi` ( | |
85 | `id_transaksi` int(11) NOT NULL, | |
86 | `id_user` int(11) NOT NULL, | |
87 | `jml_brg` int(3) NOT NULL, | |
88 | `lokasi` varchar(200) NOT NULL, | |
89 | `alamat` text NOT NULL, | |
90 | `tanggal` date NOT NULL, | |
91 | `waktu` time NOT NULL | |
92 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; | |
93 | ||
94 | -- | |
95 | -- Dumping data for table `transaksi_rafi` | |
96 | -- | |
97 | ||
98 | INSERT INTO `transaksi_rafi` (`id_transaksi`, `id_user`, `jml_brg`, `lokasi`, `alamat`, `tanggal`, `waktu`) VALUES | |
99 | (3, 6, 4, 'isinya geolocatic', 'Jl.Ciliwung raya', '2017-08-04', '03:31:27'); | |
100 | ||
101 | -- -------------------------------------------------------- | |
102 | ||
103 | -- | |
104 | -- Table structure for table `user_rafi` | |
105 | -- | |
106 | ||
107 | CREATE TABLE `user_rafi` ( | |
108 | `id_user` int(11) NOT NULL, | |
109 | `username` varchar(200) NOT NULL, | |
110 | `password` varchar(255) NOT NULL, | |
111 | `email` varchar(200) NOT NULL, | |
112 | `nama` varchar(255) NOT NULL, | |
113 | `tgl_lahir` date NOT NULL, | |
114 | `alamat` text NOT NULL, | |
115 | `ip_address` varchar(200) NOT NULL, | |
116 | `updatetimestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, | |
117 | `status` set('active','pending','not_active') NOT NULL, | |
118 | `token` varchar(255) NOT NULL | |
119 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; | |
120 | ||
121 | -- | |
122 | -- Dumping data for table `user_rafi` | |
123 | -- | |
124 | ||
125 | INSERT INTO `user_rafi` (`id_user`, `username`, `password`, `email`, `nama`, `tgl_lahir`, `alamat`, `ip_address`, `updatetimestamp`, `status`, `token`) VALUES | |
126 | (6, 'tatsu', '$2y$10$r4/AqSL8wPIWG6Bu9bT96OCFxalmzALBHiAX3ePLvB6oC.3Lbw9Wi', 'rafi16500@gmail.com', 'Muhammad Rafi', '0000-00-00', 'Jl.Ciliwung raya', '127.0.0.0', '2017-08-03 17:23:51', 'active', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6IjYifQ.uj3sy0CgSw8vChrjwkCAJEHlM4oFvffklRwMWW5_HTM'), | |
127 | (7, '', '$2y$10$vmY/ZN2m/KQpwpmoFkftX.SwiGCcWNHl3JPXmgVFKBNMsnUbo.UPq', 'rafi1600@gmail.com', '', '0000-00-00', '', '', '2017-08-04 01:48:21', '', ''); | |
128 | ||
129 | -- | |
130 | -- Indexes for dumped tables | |
131 | -- | |
132 | ||
133 | -- | |
134 | -- Indexes for table `detail_transaksi_rafi` | |
135 | -- | |
136 | ALTER TABLE `detail_transaksi_rafi` | |
137 | ADD PRIMARY KEY (`id_detail`); | |
138 | ||
139 | -- | |
140 | -- Indexes for table `produk_rafi` | |
141 | -- | |
142 | ALTER TABLE `produk_rafi` | |
143 | ADD PRIMARY KEY (`id_produk`); | |
144 | ||
145 | -- | |
146 | -- Indexes for table `transaksi_rafi` | |
147 | -- | |
148 | ALTER TABLE `transaksi_rafi` | |
149 | ADD PRIMARY KEY (`id_transaksi`); | |
150 | ||
151 | -- | |
152 | -- Indexes for table `user_rafi` | |
153 | -- | |
154 | ALTER TABLE `user_rafi` | |
155 | ADD PRIMARY KEY (`id_user`); | |
156 | ||
157 | -- | |
158 | -- AUTO_INCREMENT for dumped tables | |
159 | -- | |
160 | ||
161 | -- | |
162 | -- AUTO_INCREMENT for table `detail_transaksi_rafi` | |
163 | -- | |
164 | ALTER TABLE `detail_transaksi_rafi` | |
165 | MODIFY `id_detail` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; | |
166 | -- | |
167 | -- AUTO_INCREMENT for table `produk_rafi` | |
168 | -- | |
169 | ALTER TABLE `produk_rafi` | |
170 | MODIFY `id_produk` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; | |
171 | -- | |
172 | -- AUTO_INCREMENT for table `transaksi_rafi` | |
173 | -- | |
174 | ALTER TABLE `transaksi_rafi` | |
175 | MODIFY `id_transaksi` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; | |
176 | -- | |
177 | -- AUTO_INCREMENT for table `user_rafi` | |
178 | -- | |
179 | ALTER TABLE `user_rafi` | |
180 | MODIFY `id_user` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;COMMIT; | |
181 | ||
182 | /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; | |
183 | /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; | |
184 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |