· 5 years ago · Mar 10, 2020, 01:12 PM
1-- phpMyAdmin SQL Dump
2-- version 3.5.2.2
3-- http://www.phpmyadmin.net
4--
5-- Inang: 127.0.0.1
6-- Waktu pembuatan: 10 Mar 2020 pada 14.04
7-- Versi Server: 5.5.27
8-- Versi PHP: 5.4.7
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11SET 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-- Basis data: `db_sg`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktur dari tabel `daemons`
27--
28
29CREATE TABLE IF NOT EXISTS `daemons` (
30 `Start` text NOT NULL,
31 `Info` text NOT NULL
32) ENGINE=MyISAM DEFAULT CHARSET=utf8;
33
34-- --------------------------------------------------------
35
36--
37-- Struktur dari tabel `gammu`
38--
39
40CREATE TABLE IF NOT EXISTS `gammu` (
41 `Version` int(11) NOT NULL DEFAULT '0'
42) ENGINE=MyISAM DEFAULT CHARSET=utf8;
43
44--
45-- Dumping data untuk tabel `gammu`
46--
47
48INSERT INTO `gammu` (`Version`) VALUES
49(13);
50
51-- --------------------------------------------------------
52
53--
54-- Struktur dari tabel `inbox`
55--
56
57CREATE TABLE IF NOT EXISTS `inbox` (
58 `UpdatedInDB` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
59 `ReceivingDateTime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
60 `Text` text NOT NULL,
61 `SenderNumber` varchar(20) NOT NULL DEFAULT '',
62 `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL DEFAULT 'Default_No_Compression',
63 `UDH` text NOT NULL,
64 `SMSCNumber` varchar(20) NOT NULL DEFAULT '',
65 `Class` int(11) NOT NULL DEFAULT '-1',
66 `TextDecoded` text NOT NULL,
67 `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
68 `RecipientID` text NOT NULL,
69 `Processed` enum('false','true') NOT NULL DEFAULT 'false',
70 PRIMARY KEY (`ID`)
71) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=341 ;
72
73--
74-- Trigger `inbox`
75--
76DROP TRIGGER IF EXISTS `inbox_timestamp`;
77DELIMITER //
78CREATE TRIGGER `inbox_timestamp` BEFORE INSERT ON `inbox`
79 FOR EACH ROW BEGIN
80 IF NEW.ReceivingDateTime = '0000-00-00 00:00:00' THEN
81 SET NEW.ReceivingDateTime = CURRENT_TIMESTAMP();
82 END IF;
83END
84//
85DELIMITER ;
86
87-- --------------------------------------------------------
88
89--
90-- Struktur dari tabel `inbox_spam`
91--
92
93CREATE TABLE IF NOT EXISTS `inbox_spam` (
94 `UpdatedInDB` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
95 `ReceivingDateTime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
96 `Text` text NOT NULL,
97 `SenderNumber` varchar(20) NOT NULL DEFAULT '',
98 `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL DEFAULT 'Default_No_Compression',
99 `UDH` text NOT NULL,
100 `SMSCNumber` varchar(20) NOT NULL DEFAULT '',
101 `Class` int(11) NOT NULL DEFAULT '-1',
102 `TextDecoded` text NOT NULL,
103 `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
104 `RecipientID` text NOT NULL,
105 `Processed` enum('false','true') NOT NULL DEFAULT 'false',
106 PRIMARY KEY (`ID`)
107) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=278 ;
108
109--
110-- Dumping data untuk tabel `inbox_spam`
111--
112
113INSERT INTO `inbox_spam` (`UpdatedInDB`, `ReceivingDateTime`, `Text`, `SenderNumber`, `Coding`, `UDH`, `SMSCNumber`, `Class`, `TextDecoded`, `ID`, `RecipientID`, `Processed`) VALUES
114('2017-10-11 12:27:46', '2017-10-11 12:27:46', '', '21321322', 'Default_No_Compression', '', '', -1, 'PEMILU#IMN ANJRIT', 273, '', 'false'),
115('2017-10-22 20:52:09', '2017-10-22 20:52:09', '', '213213', 'Default_No_Compression', '', '', -1, 'REG SAGA ANJRIT', 274, '', 'false'),
116('2018-01-27 12:03:12', '2018-01-27 12:03:12', '', '+6285711521421', 'Default_No_Compression', '', '', -1, 'ANJRIT', 275, '', 'false'),
117('2018-01-27 12:13:29', '2018-01-27 12:13:29', '', '+6285711521421', 'Default_No_Compression', '', '', -1, 'ANJRIT', 276, '', 'false'),
118('2018-01-27 12:15:34', '2018-01-27 12:15:34', '', '+6285711521421', 'Default_No_Compression', '', '', -1, 'ANJRIT', 277, '', 'false');
119
120-- --------------------------------------------------------
121
122--
123-- Struktur dari tabel `jabatan`
124--
125
126CREATE TABLE IF NOT EXISTS `jabatan` (
127 `id` int(11) NOT NULL AUTO_INCREMENT,
128 `jabatan` text NOT NULL,
129 `deskripsi` text NOT NULL,
130 PRIMARY KEY (`id`)
131) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
132
133--
134-- Dumping data untuk tabel `jabatan`
135--
136
137INSERT INTO `jabatan` (`id`, `jabatan`, `deskripsi`) VALUES
138(1, 'Ketua', 'Ketua Jemaat Sola Gratia'),
139(2, 'Sekretaris', 'Sekretaris Jemaat Sola Gratia'),
140(4, 'penatua', 'penatua kolom 1');
141
142-- --------------------------------------------------------
143
144--
145-- Struktur dari tabel `outbox`
146--
147
148CREATE TABLE IF NOT EXISTS `outbox` (
149 `UpdatedInDB` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
150 `InsertIntoDB` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
151 `SendingDateTime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
152 `SendBefore` time NOT NULL DEFAULT '23:59:59',
153 `SendAfter` time NOT NULL DEFAULT '00:00:00',
154 `Text` text,
155 `DestinationNumber` varchar(20) NOT NULL DEFAULT '',
156 `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL DEFAULT 'Default_No_Compression',
157 `UDH` text,
158 `Class` int(11) DEFAULT '-1',
159 `TextDecoded` text NOT NULL,
160 `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
161 `MultiPart` enum('false','true') DEFAULT 'false',
162 `RelativeValidity` int(11) DEFAULT '-1',
163 `SenderID` varchar(255) DEFAULT NULL,
164 `SendingTimeOut` timestamp NULL DEFAULT '0000-00-00 00:00:00',
165 `DeliveryReport` enum('default','yes','no') DEFAULT 'default',
166 `CreatorID` text NOT NULL,
167 PRIMARY KEY (`ID`),
168 KEY `outbox_date` (`SendingDateTime`,`SendingTimeOut`),
169 KEY `outbox_sender` (`SenderID`)
170) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=428 ;
171
172--
173-- Dumping data untuk tabel `outbox`
174--
175
176INSERT INTO `outbox` (`UpdatedInDB`, `InsertIntoDB`, `SendingDateTime`, `SendBefore`, `SendAfter`, `Text`, `DestinationNumber`, `Coding`, `UDH`, `Class`, `TextDecoded`, `ID`, `MultiPart`, `RelativeValidity`, `SenderID`, `SendingTimeOut`, `DeliveryReport`, `CreatorID`) VALUES
177('2020-03-07 10:50:56', '2020-03-07 10:50:56', '2020-03-07 10:50:56', '23:59:59', '00:00:00', NULL, '081341558006', 'Default_No_Compression', NULL, -1, 'terserah padamu. kau coba dulu bisa ato tidak', 427, 'false', -1, NULL, '2020-03-07 10:50:56', 'default', 'Gammu');
178
179--
180-- Trigger `outbox`
181--
182DROP TRIGGER IF EXISTS `outbox_timestamp`;
183DELIMITER //
184CREATE TRIGGER `outbox_timestamp` BEFORE INSERT ON `outbox`
185 FOR EACH ROW BEGIN
186 IF NEW.InsertIntoDB = '0000-00-00 00:00:00' THEN
187 SET NEW.InsertIntoDB = CURRENT_TIMESTAMP();
188 END IF;
189 IF NEW.SendingDateTime = '0000-00-00 00:00:00' THEN
190 SET NEW.SendingDateTime = CURRENT_TIMESTAMP();
191 END IF;
192 IF NEW.SendingTimeOut = '0000-00-00 00:00:00' THEN
193 SET NEW.SendingTimeOut = CURRENT_TIMESTAMP();
194 END IF;
195END
196//
197DELIMITER ;
198
199-- --------------------------------------------------------
200
201--
202-- Struktur dari tabel `outbox_multipart`
203--
204
205CREATE TABLE IF NOT EXISTS `outbox_multipart` (
206 `Text` text,
207 `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL DEFAULT 'Default_No_Compression',
208 `UDH` text,
209 `Class` int(11) DEFAULT '-1',
210 `TextDecoded` text,
211 `ID` int(10) unsigned NOT NULL DEFAULT '0',
212 `SequencePosition` int(11) NOT NULL DEFAULT '1',
213 PRIMARY KEY (`ID`,`SequencePosition`)
214) ENGINE=MyISAM DEFAULT CHARSET=utf8;
215
216-- --------------------------------------------------------
217
218--
219-- Struktur dari tabel `pbk`
220--
221
222CREATE TABLE IF NOT EXISTS `pbk` (
223 `ID` int(11) NOT NULL AUTO_INCREMENT,
224 `GroupID` int(11) NOT NULL DEFAULT '-1',
225 `Name` text NOT NULL,
226 `Number` text NOT NULL,
227 `Foto` varchar(250) NOT NULL,
228 `tgl_lahir` date NOT NULL,
229 PRIMARY KEY (`ID`)
230) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=85 ;
231
232--
233-- Dumping data untuk tabel `pbk`
234--
235
236INSERT INTO `pbk` (`ID`, `GroupID`, `Name`, `Number`, `Foto`, `tgl_lahir`) VALUES
237(61, 2, 'SRI WAHYUNI ', '+628381899000', 'assets/img/03_charming.jpg', '1989-01-26'),
238(60, 3, 'Koperasi', '+6283818993400', 'assets/img/logo-koperasi_zps581860cf.png', '0000-00-00'),
239(62, 3, 'Sudijo', '0898989', 'assets/img/Meme-Mudik-Lebaran-Gambar-DP-BBM-Lucu-Kocak-Keren-Gokil-Abis-7.png', '1989-06-01'),
240(75, -1, 'sadsad', '13213213', 'assets/img/', '0000-00-00'),
241(67, 2, 'jurnal', '08989898898', '', '0000-00-00'),
242(68, -1, 'Kemod', '0898898', 'assets/img/', '0000-00-00'),
243(69, -1, 'sdsadsadsdsdsdsdsds', '2313213', 'assets/img/', '0000-00-00'),
244(70, -1, 'asdsad', '23213', 'assets/img/', '0000-00-00'),
245(76, 2, 'sadsadsad', '213123213123', 'assets/img/', '0000-00-00'),
246(77, 3, 'andez', '082213148092', 'assets/img/', '1989-01-27'),
247(78, 2, 'TES', '09889898', 'assets/img/', '1989-01-15'),
248(79, 2, 'IMAN', '085711521421', 'assets/img/', '1999-01-27'),
249(80, 3, 'WARDIMAN', '08986957879', 'assets/img/', '1995-11-21'),
250(81, 17, 'gong', '081341558008', 'assets/img/', '1996-06-07'),
251(82, 18, 'reven linus', '081341558009', 'assets/img/', '1998-04-26'),
252(83, 19, 'reven love carni', '081341558006', 'assets/img/', '1998-04-26'),
253(84, 19, 'gong', '08888882', 'assets/img/', '2020-03-10');
254
255-- --------------------------------------------------------
256
257--
258-- Struktur dari tabel `pbk_groups`
259--
260
261CREATE TABLE IF NOT EXISTS `pbk_groups` (
262 `NameGroup` text NOT NULL,
263 `GroupID` int(11) NOT NULL AUTO_INCREMENT,
264 PRIMARY KEY (`GroupID`)
265) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;
266
267--
268-- Dumping data untuk tabel `pbk_groups`
269--
270
271INSERT INTO `pbk_groups` (`NameGroup`, `GroupID`) VALUES
272('Keluarga', 2),
273('Teman', 3),
274('Group Nakal', 9),
275('Client', 8),
276('Group 2', 12),
277('tessss', 14),
278('sadsadsadsad', 15),
279('MOBILE LEGEND', 16),
280('anjir', 17),
281('reven carni', 19),
282('Kolom Satu', 20);
283
284-- --------------------------------------------------------
285
286--
287-- Struktur dari tabel `pengaturan`
288--
289
290CREATE TABLE IF NOT EXISTS `pengaturan` (
291 `id` int(11) NOT NULL,
292 `judul` text NOT NULL,
293 `nama` text NOT NULL,
294 `sejarah` text NOT NULL
295) ENGINE=InnoDB DEFAULT CHARSET=latin1;
296
297--
298-- Dumping data untuk tabel `pengaturan`
299--
300
301INSERT INTO `pengaturan` (`id`, `judul`, `nama`, `sejarah`) VALUES
302(123456, 'Sistem Sola Gratia', 'Sistem Informasi Sola Gratia', 'www');
303
304-- --------------------------------------------------------
305
306--
307-- Struktur dari tabel `pengurus_gereja`
308--
309
310CREATE TABLE IF NOT EXISTS `pengurus_gereja` (
311 `id` int(11) NOT NULL AUTO_INCREMENT,
312 `id_pbk` int(11) NOT NULL,
313 `jabatan` text NOT NULL,
314 PRIMARY KEY (`id`)
315) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
316
317--
318-- Dumping data untuk tabel `pengurus_gereja`
319--
320
321INSERT INTO `pengurus_gereja` (`id`, `id_pbk`, `jabatan`) VALUES
322(1, 82, '2'),
323(2, 60, '<br />\r\n<b>Notice</b>: Undefined index: id in <b>C:xampphtdocssola-gratia-paluadminadmin-webpengurusinput.php</b> on line <b>27</b><br />\r\n'),
324(3, 83, '1'),
325(4, 61, '4');
326
327-- --------------------------------------------------------
328
329--
330-- Struktur dari tabel `phones`
331--
332
333CREATE TABLE IF NOT EXISTS `phones` (
334 `ID` text NOT NULL,
335 `UpdatedInDB` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
336 `InsertIntoDB` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
337 `TimeOut` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
338 `Send` enum('yes','no') NOT NULL DEFAULT 'no',
339 `Receive` enum('yes','no') NOT NULL DEFAULT 'no',
340 `IMEI` varchar(35) NOT NULL,
341 `Client` text NOT NULL,
342 `Battery` int(11) NOT NULL DEFAULT '-1',
343 `Signal` int(11) NOT NULL DEFAULT '-1',
344 `Sent` int(11) NOT NULL DEFAULT '0',
345 `Received` int(11) NOT NULL DEFAULT '0',
346 PRIMARY KEY (`IMEI`)
347) ENGINE=MyISAM DEFAULT CHARSET=utf8;
348
349--
350-- Trigger `phones`
351--
352DROP TRIGGER IF EXISTS `phones_timestamp`;
353DELIMITER //
354CREATE TRIGGER `phones_timestamp` BEFORE INSERT ON `phones`
355 FOR EACH ROW BEGIN
356 IF NEW.InsertIntoDB = '0000-00-00 00:00:00' THEN
357 SET NEW.InsertIntoDB = CURRENT_TIMESTAMP();
358 END IF;
359 IF NEW.TimeOut = '0000-00-00 00:00:00' THEN
360 SET NEW.TimeOut = CURRENT_TIMESTAMP();
361 END IF;
362END
363//
364DELIMITER ;
365
366-- --------------------------------------------------------
367
368--
369-- Struktur dari tabel `sentitems`
370--
371
372CREATE TABLE IF NOT EXISTS `sentitems` (
373 `UpdatedInDB` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
374 `InsertIntoDB` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
375 `SendingDateTime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
376 `DeliveryDateTime` timestamp NULL DEFAULT NULL,
377 `Text` text NOT NULL,
378 `DestinationNumber` varchar(20) NOT NULL DEFAULT '',
379 `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL DEFAULT 'Default_No_Compression',
380 `UDH` text NOT NULL,
381 `SMSCNumber` varchar(20) NOT NULL DEFAULT '',
382 `Class` int(11) NOT NULL DEFAULT '-1',
383 `TextDecoded` text NOT NULL,
384 `ID` int(10) unsigned NOT NULL DEFAULT '0',
385 `SenderID` varchar(255) NOT NULL,
386 `SequencePosition` int(11) NOT NULL DEFAULT '1',
387 `Status` enum('SendingOK','SendingOKNoReport','SendingError','DeliveryOK','DeliveryFailed','DeliveryPending','DeliveryUnknown','Error') NOT NULL DEFAULT 'SendingOK',
388 `StatusError` int(11) NOT NULL DEFAULT '-1',
389 `TPMR` int(11) NOT NULL DEFAULT '-1',
390 `RelativeValidity` int(11) NOT NULL DEFAULT '-1',
391 `CreatorID` text NOT NULL,
392 PRIMARY KEY (`ID`,`SequencePosition`),
393 KEY `sentitems_date` (`DeliveryDateTime`),
394 KEY `sentitems_tpmr` (`TPMR`),
395 KEY `sentitems_dest` (`DestinationNumber`),
396 KEY `sentitems_sender` (`SenderID`)
397) ENGINE=MyISAM DEFAULT CHARSET=utf8;
398
399--
400-- Trigger `sentitems`
401--
402DROP TRIGGER IF EXISTS `sentitems_timestamp`;
403DELIMITER //
404CREATE TRIGGER `sentitems_timestamp` BEFORE INSERT ON `sentitems`
405 FOR EACH ROW BEGIN
406 IF NEW.InsertIntoDB = '0000-00-00 00:00:00' THEN
407 SET NEW.InsertIntoDB = CURRENT_TIMESTAMP();
408 END IF;
409 IF NEW.SendingDateTime = '0000-00-00 00:00:00' THEN
410 SET NEW.SendingDateTime = CURRENT_TIMESTAMP();
411 END IF;
412END
413//
414DELIMITER ;
415
416-- --------------------------------------------------------
417
418--
419-- Struktur dari tabel `tbl_autoreply`
420--
421
422CREATE TABLE IF NOT EXISTS `tbl_autoreply` (
423 `id` int(2) NOT NULL AUTO_INCREMENT,
424 `pesan` text NOT NULL,
425 PRIMARY KEY (`id`)
426) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
427
428--
429-- Dumping data untuk tabel `tbl_autoreply`
430--
431
432INSERT INTO `tbl_autoreply` (`id`, `pesan`) VALUES
433(3, 'Mohon maaf saya sedang sibuk'),
434(4, 'sedang sibuk');
435
436-- --------------------------------------------------------
437
438--
439-- Struktur dari tabel `tbl_autorespon`
440--
441
442CREATE TABLE IF NOT EXISTS `tbl_autorespon` (
443 `id` int(11) NOT NULL AUTO_INCREMENT,
444 `keyword1` varchar(25) NOT NULL,
445 `keyword2` varchar(25) NOT NULL,
446 `result` text NOT NULL,
447 `idforward` int(1) NOT NULL,
448 `no_forward` varchar(15) NOT NULL,
449 PRIMARY KEY (`id`)
450) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
451
452--
453-- Dumping data untuk tabel `tbl_autorespon`
454--
455
456INSERT INTO `tbl_autorespon` (`id`, `keyword1`, `keyword2`, `result`, `idforward`, `no_forward`) VALUES
457(9, 'REG', 'SAGA', 'Terima kasih', 1, '83804070476'),
458(10, 'ADSAD', 'SADSADSADSAD', 'sadsadsadsad', 1, '13213213'),
459(11, 'REG', 'IMAN', 'TERIMA KASIH', 0, '0');
460
461-- --------------------------------------------------------
462
463--
464-- Struktur dari tabel `tbl_filter_kata`
465--
466
467CREATE TABLE IF NOT EXISTS `tbl_filter_kata` (
468 `idkata` int(11) NOT NULL AUTO_INCREMENT,
469 `nm_kata` varchar(100) NOT NULL,
470 PRIMARY KEY (`idkata`)
471) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
472
473--
474-- Dumping data untuk tabel `tbl_filter_kata`
475--
476
477INSERT INTO `tbl_filter_kata` (`idkata`, `nm_kata`) VALUES
478(1, 'Anjrit'),
479(2, 'asdsadsadsd');
480
481-- --------------------------------------------------------
482
483--
484-- Struktur dari tabel `tbl_log_polling`
485--
486
487CREATE TABLE IF NOT EXISTS `tbl_log_polling` (
488 `idlog` int(11) NOT NULL AUTO_INCREMENT,
489 `nohp` varchar(15) NOT NULL,
490 `kode` varchar(15) NOT NULL,
491 PRIMARY KEY (`idlog`)
492) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
493
494-- --------------------------------------------------------
495
496--
497-- Struktur dari tabel `tbl_polling`
498--
499
500CREATE TABLE IF NOT EXISTS `tbl_polling` (
501 `id` int(10) NOT NULL AUTO_INCREMENT,
502 `name` varchar(100) NOT NULL,
503 `jumlah` int(10) NOT NULL,
504 `kode` varchar(20) NOT NULL,
505 PRIMARY KEY (`id`)
506) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
507
508--
509-- Dumping data untuk tabel `tbl_polling`
510--
511
512INSERT INTO `tbl_polling` (`id`, `name`, `jumlah`, `kode`) VALUES
513(1, 'Iman Muhamad Wardiman', 0, 'IMN'),
514(2, 'Andez Muhamad Pradesa', 0, 'ANZ'),
515(3, 'SRI', 0, 'SRI');
516
517-- --------------------------------------------------------
518
519--
520-- Struktur dari tabel `tbl_schedule`
521--
522
523CREATE TABLE IF NOT EXISTS `tbl_schedule` (
524 `id` int(3) NOT NULL AUTO_INCREMENT,
525 `DestinationNumber` varchar(160) NOT NULL,
526 `TextDecoded` varchar(50) NOT NULL,
527 `CreatorID` varchar(5) NOT NULL,
528 `Time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
529 `nama_event` varchar(25) NOT NULL,
530 PRIMARY KEY (`id`)
531) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
532
533-- --------------------------------------------------------
534
535--
536-- Struktur dari tabel `tbl_setting`
537--
538
539CREATE TABLE IF NOT EXISTS `tbl_setting` (
540 `idset` int(1) NOT NULL AUTO_INCREMENT,
541 `set_autorespon` int(1) NOT NULL,
542 `set_autoreply` int(1) NOT NULL,
543 `set_ultah` int(1) NOT NULL,
544 `set_pesan_ultah` text NOT NULL,
545 PRIMARY KEY (`idset`)
546) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
547
548--
549-- Dumping data untuk tabel `tbl_setting`
550--
551
552INSERT INTO `tbl_setting` (`idset`, `set_autorespon`, `set_autoreply`, `set_ultah`, `set_pesan_ultah`) VALUES
553(1, 0, 0, 0, 'Selamat Ulang Tahun Ya');
554
555-- --------------------------------------------------------
556
557--
558-- Struktur dari tabel `tbl_set_pol`
559--
560
561CREATE TABLE IF NOT EXISTS `tbl_set_pol` (
562 `idset` int(1) NOT NULL AUTO_INCREMENT,
563 `judul` varchar(100) NOT NULL,
564 `kode_awal` varchar(25) NOT NULL,
565 `pemisah` varchar(1) NOT NULL,
566 PRIMARY KEY (`idset`)
567) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
568
569--
570-- Dumping data untuk tabel `tbl_set_pol`
571--
572
573INSERT INTO `tbl_set_pol` (`idset`, `judul`, `kode_awal`, `pemisah`) VALUES
574(1, 'Pemilihan Ketua Kelas', 'PEMILU', '#');
575
576-- --------------------------------------------------------
577
578--
579-- Struktur dari tabel `tbl_sms_ultah`
580--
581
582CREATE TABLE IF NOT EXISTS `tbl_sms_ultah` (
583 `id` int(11) NOT NULL AUTO_INCREMENT,
584 `no_hp` varchar(15) NOT NULL,
585 `nama` varchar(100) NOT NULL,
586 `ucapan` text NOT NULL,
587 `tahun` year(4) NOT NULL,
588 `tanggal` date NOT NULL,
589 PRIMARY KEY (`id`)
590) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
591
592--
593-- Dumping data untuk tabel `tbl_sms_ultah`
594--
595
596INSERT INTO `tbl_sms_ultah` (`id`, `no_hp`, `nama`, `ucapan`, `tahun`, `tanggal`) VALUES
597(1, '', '', ', Selamat Ulang Tahun Ya', 2018, '2018-01-26'),
598(2, '+628381899000', 'SRI WAHYUNI ', 'SRI WAHYUNI , Selamat Ulang Tahun Ya', 2018, '2018-01-26'),
599(3, '082213148092', 'andez', 'andez, Selamat Ulang Tahun Ya', 2018, '2018-01-27'),
600(4, '085711521421', 'IMAN', 'IMAN, Selamat Ulang Tahun Ya', 2018, '2018-01-27');
601
602-- --------------------------------------------------------
603
604--
605-- Struktur dari tabel `tbl_user`
606--
607
608CREATE TABLE IF NOT EXISTS `tbl_user` (
609 `id_user` int(10) NOT NULL AUTO_INCREMENT,
610 `username` varchar(100) NOT NULL,
611 `pass` varchar(100) NOT NULL,
612 `level_user` int(5) NOT NULL,
613 `email` varchar(50) NOT NULL,
614 `status` int(5) NOT NULL,
615 `w_login` datetime NOT NULL,
616 `photo` varchar(100) NOT NULL,
617 `nohp` varchar(15) NOT NULL,
618 PRIMARY KEY (`id_user`)
619) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
620
621--
622-- Dumping data untuk tabel `tbl_user`
623--
624
625INSERT INTO `tbl_user` (`id_user`, `username`, `pass`, `level_user`, `email`, `status`, `w_login`, `photo`, `nohp`) VALUES
626(2, 'andez', '79803a0eaab30ae84b7b807bb46419f5', 1, 'andeztea@gmail.com', 1, '2020-03-09 19:59:45', 'assets/img/users_lock.png', '+08989899898');
627
628/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
629/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
630/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;