6VNWJpMc

1-- Adminer 4.2.5 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `admin`;
9CREATE TABLE `admin` (
10  `uid` varchar(20) COLLATE latin1_general_ci NOT NULL DEFAULT '',
11  `nama` varchar(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
12  `password` varchar(32) COLLATE latin1_general_ci NOT NULL DEFAULT '',
13  `status` char(1) COLLATE latin1_general_ci DEFAULT '0',
14  `online` char(1) COLLATE latin1_general_ci DEFAULT '0',
15  `lastaktif` datetime DEFAULT NULL,
16  `ipaddr` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
17  `sesino` int(11) DEFAULT NULL,
18  `jenis_user` text COLLATE latin1_general_ci,
19  `hak_akses` text COLLATE latin1_general_ci,
20  PRIMARY KEY (`uid`)
21) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci ROW_FORMAT=COMPACT;
22
23
24DROP TABLE IF EXISTS `copy_writing`;
25CREATE TABLE `copy_writing` (
26  `id` int(11) NOT NULL AUTO_INCREMENT,
27  `id_produk` int(11) NOT NULL,
28  `judul` text NOT NULL,
29  `isi_content` int(11) NOT NULL,
30  `tanggal` date NOT NULL,
31  `status` int(11) NOT NULL,
32  PRIMARY KEY (`id`)
33) ENGINE=InnoDB DEFAULT CHARSET=latin1;
34
35
36DROP TABLE IF EXISTS `detail_penjualan`;
37CREATE TABLE `detail_penjualan` (
38  `id` int(11) NOT NULL AUTO_INCREMENT,
39  `id_penjualan` int(11) NOT NULL,
40  `id_produk` int(11) NOT NULL,
41  `jumlah` int(11) NOT NULL,
42  `harga` decimal(10,0) NOT NULL,
43  `total` decimal(10,0) NOT NULL,
44  PRIMARY KEY (`id`),
45  KEY `id_penjualan` (`id_penjualan`),
46  KEY `id_produk` (`id_produk`),
47  CONSTRAINT `detail_penjualan_ibfk_1` FOREIGN KEY (`id_penjualan`) REFERENCES `penjualan` (`id`),
48  CONSTRAINT `detail_penjualan_ibfk_2` FOREIGN KEY (`id_produk`) REFERENCES `produk` (`id`)
49) ENGINE=InnoDB DEFAULT CHARSET=latin1;
50
51
52DROP TABLE IF EXISTS `funnel`;
53CREATE TABLE `funnel` (
54  `id` int(11) NOT NULL AUTO_INCREMENT,
55  `nama_funnel` text NOT NULL,
56  `jumlah_trafic` int(11) NOT NULL,
57  `link` text NOT NULL,
58  `status` text NOT NULL,
59  PRIMARY KEY (`id`)
60) ENGINE=InnoDB DEFAULT CHARSET=latin1;
61
62
63DROP TABLE IF EXISTS `galeri`;
64CREATE TABLE `galeri` (
65  `id` int(11) NOT NULL AUTO_INCREMENT,
66  `tanggal` date NOT NULL,
67  `gambar` text NOT NULL,
68  `id_admin` text NOT NULL,
69  PRIMARY KEY (`id`)
70) ENGINE=InnoDB DEFAULT CHARSET=latin1;
71
72
73DROP TABLE IF EXISTS `komisi`;
74CREATE TABLE `komisi` (
75  `id` int(11) NOT NULL AUTO_INCREMENT,
76  `id_penjualan` int(11) NOT NULL,
77  `komisi` text NOT NULL,
78  `jenis_komisi` text NOT NULL,
79  `id_member` text NOT NULL,
80  `tanggal` date NOT NULL,
81  PRIMARY KEY (`id`),
82  KEY `id_penjualan` (`id_penjualan`),
83  CONSTRAINT `komisi_ibfk_1` FOREIGN KEY (`id_penjualan`) REFERENCES `penjualan` (`id`)
84) ENGINE=InnoDB DEFAULT CHARSET=latin1;
85
86
87DROP TABLE IF EXISTS `log_alamat`;
88CREATE TABLE `log_alamat` (
89  `id` int(11) NOT NULL AUTO_INCREMENT,
90  `id_member` int(11) NOT NULL,
91  `alamat` text NOT NULL,
92  `kecamatan` text NOT NULL,
93  `kota` text NOT NULL,
94  `provinsi` text NOT NULL,
95  `kode_pos` text NOT NULL,
96  PRIMARY KEY (`id`),
97  KEY `id_member` (`id_member`)
98) ENGINE=InnoDB DEFAULT CHARSET=latin1;
99
100
101DROP TABLE IF EXISTS `member`;
102CREATE TABLE `member` (
103  `id` int(11) NOT NULL AUTO_INCREMENT,
104  `email` text NOT NULL,
105  `password` text NOT NULL,
106  `nama` text NOT NULL,
107  `alamat` text NOT NULL,
108  `nomor_telepon` text NOT NULL,
109  `nama_bank` text NOT NULL,
110  `nomor_rekening` text NOT NULL,
111  `nama_rekening` text NOT NULL,
112  `upline` text NOT NULL,
113  `tanggal_join` date NOT NULL,
114  `komisi` decimal(10,0) NOT NULL,
115  `jumlah_transaksi` int(11) NOT NULL,
116  `jumlah_barang` int(11) NOT NULL,
117  `status` text NOT NULL,
118  `lisensi` text NOT NULL COMMENT 'CALON MEMBER, BASIC, AGEN, STOKIS',
119  PRIMARY KEY (`id`)
120) ENGINE=InnoDB DEFAULT CHARSET=latin1;
121
122
123DROP TABLE IF EXISTS `news`;
124CREATE TABLE `news` (
125  `id` int(11) NOT NULL AUTO_INCREMENT,
126  `judul` text NOT NULL,
127  `isi_content` longtext NOT NULL,
128  `tanggal` date NOT NULL,
129  `jam` text NOT NULL,
130  `status` text NOT NULL,
131  PRIMARY KEY (`id`)
132) ENGINE=InnoDB DEFAULT CHARSET=latin1;
133
134
135DROP TABLE IF EXISTS `pembayaran_komisi`;
136CREATE TABLE `pembayaran_komisi` (
137  `id` int(11) NOT NULL AUTO_INCREMENT,
138  `id_member` int(11) NOT NULL,
139  `tanggal` date NOT NULL,
140  `jumlah` decimal(10,0) NOT NULL,
141  `bukti_transfer` text NOT NULL,
142  PRIMARY KEY (`id`),
143  KEY `id_member` (`id_member`),
144  CONSTRAINT `pembayaran_komisi_ibfk_1` FOREIGN KEY (`id_member`) REFERENCES `member` (`id`)
145) ENGINE=InnoDB DEFAULT CHARSET=latin1;
146
147
148DROP TABLE IF EXISTS `penjualan`;
149CREATE TABLE `penjualan` (
150  `id` int(11) NOT NULL AUTO_INCREMENT,
151  `id_member` int(11) NOT NULL,
152  `nama_pembeli` text NOT NULL,
153  `email_pembeli` text NOT NULL,
154  `nomor_telepon` text NOT NULL,
155  `alamat_pengiriman` text NOT NULL,
156  `kecamatan_pengiriman` text NOT NULL,
157  `kota_pengiriman` text NOT NULL,
158  `provinsi_pengiriman` text NOT NULL,
159  `kode_pos_pengiriman` text NOT NULL,
160  `tanggal` date NOT NULL,
161  `sub_total` decimal(10,0) NOT NULL,
162  `ongkir` decimal(10,0) NOT NULL,
163  `total` decimal(10,0) NOT NULL,
164  `status` text NOT NULL,
165  `id_trafic` int(11) NOT NULL,
166  `id_admin` text NOT NULL,
167  `service_pengiriman` text NOT NULL,
168  PRIMARY KEY (`id`)
169) ENGINE=InnoDB DEFAULT CHARSET=latin1;
170
171
172DROP TABLE IF EXISTS `produk`;
173CREATE TABLE `produk` (
174  `id` int(11) NOT NULL AUTO_INCREMENT,
175  `nama_produk` text NOT NULL,
176  `harga` decimal(10,0) NOT NULL,
177  `harga_member` decimal(10,0) NOT NULL,
178  `deskripsi` longtext NOT NULL,
179  `promo` longtext NOT NULL,
180  `komisi` text NOT NULL,
181  `gambar` text NOT NULL,
182  `video` text NOT NULL,
183  `berat` int(11) NOT NULL,
184  `kategori` text NOT NULL,
185  `diskon` text NOT NULL,
186  `nama_diskon` text NOT NULL,
187  `cashback` text NOT NULL COMMENT 'isi json / lisensi',
188  PRIMARY KEY (`id`)
189) ENGINE=InnoDB DEFAULT CHARSET=latin1;
190
191
192DROP TABLE IF EXISTS `rekap_transaksi`;
193CREATE TABLE `rekap_transaksi` (
194  `id` int(11) NOT NULL AUTO_INCREMENT,
195  `id_member` int(11) NOT NULL,
196  `komisi` decimal(10,0) NOT NULL,
197  `jumlah_penjualan` int(11) NOT NULL,
198  `jumlah_barang` int(11) NOT NULL,
199  `periode` text NOT NULL,
200  PRIMARY KEY (`id`)
201) ENGINE=InnoDB DEFAULT CHARSET=latin1;
202
203
204DROP TABLE IF EXISTS `setting`;
205CREATE TABLE `setting` (
206  `id` int(11) NOT NULL AUTO_INCREMENT,
207  `nama` text NOT NULL,
208  `isi` text NOT NULL,
209  PRIMARY KEY (`id`)
210) ENGINE=InnoDB DEFAULT CHARSET=latin1;
211
212
213DROP TABLE IF EXISTS `trafic`;
214CREATE TABLE `trafic` (
215  `id` int(11) NOT NULL AUTO_INCREMENT,
216  `id_member` int(11) NOT NULL,
217  `unique_id` longtext NOT NULL,
218  `id_funnel` text NOT NULL,
219  `tanggal` date NOT NULL,
220  `jam` text NOT NULL,
221  `ip_address` text NOT NULL,
222  `lokasi` text NOT NULL,
223  `user_agent` text NOT NULL,
224  PRIMARY KEY (`id`),
225  KEY `id_member` (`id_member`)
226) ENGINE=InnoDB DEFAULT CHARSET=latin1;
227
228
229DROP TABLE IF EXISTS `training`;
230CREATE TABLE `training` (
231  `id` int(11) NOT NULL AUTO_INCREMENT,
232  `judul_materi` text NOT NULL,
233  `deskripsi_materi` longtext NOT NULL,
234  `video_souce` text NOT NULL,
235  `thumbnail` text NOT NULL,
236  `kategori` text NOT NULL,
237  `wajib_tonton` text NOT NULL,
238  `urutan` int(11) NOT NULL,
239  `tanggal_update` date NOT NULL,
240  `jam_update` text NOT NULL,
241  PRIMARY KEY (`id`)
242) ENGINE=InnoDB DEFAULT CHARSET=latin1;
243
244
245DROP VIEW IF EXISTS `view_rekap_komisi`;
246CREATE TABLE `view_rekap_komisi` (`id_member` int(11), `komisi` double, `totalPenjualan` bigint(21), `tanggal` date);
247
248
249DROP VIEW IF EXISTS `view_rekap_komisi_backup`;
250CREATE TABLE `view_rekap_komisi_backup` (`id` int(11), `id_penjualan` int(11), `komisi` text, `jenis_komisi` text, `id_member` text, `tanggal` date);
251
252
253DROP TABLE IF EXISTS `watched_training`;
254CREATE TABLE `watched_training` (
255  `id` int(11) NOT NULL AUTO_INCREMENT,
256  `id_member` int(11) NOT NULL,
257  `tanggal` date NOT NULL,
258  `jam` text NOT NULL,
259  `id_training` int(11) NOT NULL,
260  PRIMARY KEY (`id`),
261  KEY `id_member` (`id_member`),
262  KEY `id_training` (`id_training`),
263  CONSTRAINT `watched_training_ibfk_1` FOREIGN KEY (`id_member`) REFERENCES `member` (`id`),
264  CONSTRAINT `watched_training_ibfk_2` FOREIGN KEY (`id_training`) REFERENCES `training` (`id`)
265) ENGINE=InnoDB DEFAULT CHARSET=latin1;
266
267
268DROP TABLE IF EXISTS `view_rekap_komisi`;
269CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `view_rekap_komisi` AS select `member`.`id` AS `id_member`,sum(`komisi`.`komisi`) AS `komisi`,(select count(`komisi`.`id`) from `komisi` where ((`komisi`.`jenis_komisi` = 'PENJUALAN') and (`komisi`.`id_member` = `member`.`id`))) AS `totalPenjualan`,`komisi`.`tanggal` AS `tanggal` from (`komisi` left join `member` on((`member`.`id` = `komisi`.`id_member`))) where (`komisi`.`komisi` > 0) group by `member`.`id`;
270
271DROP TABLE IF EXISTS `view_rekap_komisi_backup`;
272CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `view_rekap_komisi_backup` AS select `komisi`.`id` AS `id`,`komisi`.`id_penjualan` AS `id_penjualan`,`komisi`.`komisi` AS `komisi`,`komisi`.`jenis_komisi` AS `jenis_komisi`,`komisi`.`id_member` AS `id_member`,`komisi`.`tanggal` AS `tanggal` from `komisi` group by `komisi`.`id_member`;
273
274-- 2019-08-14 15:27:01