· 10 years ago · Feb 03, 2016, 11:21 PM
1This post is related to IndonesianGOV Leaks/DOX Post! http://pastebin.com/MndVBi6h
2
3SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
4/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
5/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
6/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
7/*!40101 SET NAMES utf8 */;
8--
9-- Database: `dbsms`
10--
11-- Table structure for table `user`
12--
13CREATE TABLE IF NOT EXISTS `user` (
14 `username` varchar(32) NOT NULL,
15 `password` varchar(32) NOT NULL
16) ENGINE=MyISAM DEFAULT CHARSET=latin1;
17--
18-- Dumping data for table `user`
19--
20INSERT INTO `user` (`username`, `password`) VALUES
21('admin', '21232f297a57a5a743894a0e4a801fc3');
22-- phpMyAdmin SQL Dump
23-- version 2.11.7
24-- http://www.phpmyadmin.net
25--
26-- Host: localhost
27-- Generation Time: Mar 24, 2012 at 03:52 AM
28-- Server version: 5.0.51
29-- PHP Version: 5.2.6
30SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
31/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
32/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
33/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
34/*!40101 SET NAMES utf8 */;
35--
36-- Database: `sms`
37--
38-- --------------------------------------------------------
39--
40-- Table structure for table `daemons`
41--
42CREATE TABLE IF NOT EXISTS `daemons` (
43 `Start` text NOT NULL,
44 `Info` text NOT NULL
45) ENGINE=MyISAM DEFAULT CHARSET=utf8;
46--
47-- Dumping data for table `daemons`
48--
49-- --------------------------------------------------------
50--
51-- Table structure for table `gammu`
52--
53CREATE TABLE IF NOT EXISTS `gammu` (
54 `Version` int(11) NOT NULL default '0'
55) ENGINE=MyISAM DEFAULT CHARSET=utf8;
56--
57-- Dumping data for table `gammu`
58--
59INSERT INTO `gammu` (`Version`) VALUES
60(10);
61-- --------------------------------------------------------
62--
63-- Table structure for table `inbox`
64--
65CREATE TABLE IF NOT EXISTS `inbox` (
66 `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
67 `ReceivingDateTime` timestamp NOT NULL default '0000-00-00 00:00:00',
68 `Text` text NOT NULL,
69 `SenderNumber` varchar(20) NOT NULL default '',
70 `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
71 `UDH` text NOT NULL,
72 `SMSCNumber` varchar(20) NOT NULL default '',
73 `Class` int(11) NOT NULL default '-1',
74 `TextDecoded` varchar(160) NOT NULL default '',
75 `ID` int(10) unsigned NOT NULL auto_increment,
76 `RecipientID` text NOT NULL,
77 `Processed` enum('false','true') NOT NULL default 'false',
78 PRIMARY KEY (`ID`)
79) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
80--
81-- Dumping data for table `inbox`
82--
83-- --------------------------------------------------------
84--
85-- Table structure for table `komentar`
86--
87CREATE TABLE IF NOT EXISTS `komentar` (
88 `nou` int(11) NOT NULL auto_increment,
89 `nama` varchar(50) NOT NULL,
90 `email` varchar(100) NOT NULL,
91 `pesan` text NOT NULL,
92 `date` date NOT NULL default '0000-00-00',
93 PRIMARY KEY (`nou`)
94) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;
95--
96-- Dumping data for table `komentar`
97--
98INSERT INTO `komentar` (`nou`, `nama`, `email`, `pesan`, `date`) VALUES
99(6, 'Kristian Pratama', 'kristian_90@yahoo.com', 'halooo...', '2010-07-07'),
100(7, 'Agoes Sapoetra', 'takehikoboyz@gmail.com', 'coba member komen... eror ga Ya?? Kaya nya si dijamin engga..', '2010-07-16'),
101(9, 'Feni Agustin', 'felicia_feni@yahoo.co.id', 'thu bener kan ga error..', '2010-07-16'),
102(19, 'Agus Saputra', 'takehikoboyz@gmail.com', ' Halo ', '2012-03-17');
103-- --------------------------------------------------------
104--
105-- Table structure for table `kota`
106--
107CREATE TABLE IF NOT EXISTS `kota` (
108 `id_kota` int(11) NOT NULL auto_increment,
109 `id_prov` int(11) NOT NULL,
110 `nama_kota` varchar(50) NOT NULL,
111 `biaya` int(10) NOT NULL,
112 PRIMARY KEY (`id_kota`)
113) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=144 ;
114--
115-- Dumping data for table `kota`
116--
117INSERT INTO `kota` (`id_kota`, `id_prov`, `nama_kota`, `biaya`) VALUES
118(1, 1, 'Jakarta Pusat', 8000),
119(2, 1, 'Jakarta Selatan', 8000),
120(3, 1, 'Jakarta Utara', 8000),
121(4, 1, 'Jakarta Barat', 8000),
122(5, 1, 'Jakarta Timur', 8000),
123(6, 1, 'Kepulauan Seribu', 8000),
124(7, 2, 'Badung', 20000),
125(8, 2, 'Buleleng', 23000),
126(9, 2, 'Denpasar', 15000),
127(10, 2, 'Gianyar', 20000),
128(11, 2, 'Gilimanuk', 15000),
129(12, 2, 'Jimbrana', 13000),
130(13, 2, 'Klungkung', 20000),
131(14, 2, 'Kuta', 17000),
132(15, 2, 'Negara', 32000),
133(16, 2, 'Ngurah Rai', 17000),
134(17, 2, 'Nusa Dua', 17000),
135(18, 2, 'Sanur', 17000),
136(19, 2, 'Singaraja', 23000),
137(20, 2, 'Tabanan', 23000),
138(21, 2, 'Ubud', 25000),
139(22, 3, 'Bandung', 8000),
140(23, 3, 'Banjar', 15000),
141(24, 3, 'Bekasi', 7000),
142(25, 3, 'Bogor', 7000),
143(26, 3, 'Ciamis', 12000),
144(27, 3, 'Cianjur', 9500),
145(28, 3, 'Ciawi', 8000),
146(29, 3, 'Cibinong', 6500),
147(30, 3, 'Cibubur', 6000),
148(31, 3, 'Cikarang', 7000),
149(32, 3, 'Cileungsi', 8000),
150(33, 3, 'Cimahi', 9000),
151(34, 3, 'Cirebon', 5000),
152(35, 3, 'Citeureup', 8000),
153(36, 3, 'Depok', 7000),
154(37, 3, 'Garut', 7000),
155(38, 3, 'Indramayu', 6000),
156(39, 3, 'Jatibarang', 6000),
157(40, 3, 'Jatinangor', 7000),
158(41, 3, 'Jatiwangi', 5000),
159(42, 3, 'Kabupaten Bogor', 8000),
160(43, 3, 'Kadipaten', 6000),
161(44, 3, 'Karawang', 7000),
162(45, 3, 'Kuningan', 6000),
163(46, 3, 'Lembang', 8000),
164(47, 3, 'Losari', 6500),
165(48, 3, 'Majalaya', 8000),
166(49, 3, 'Majalengka', 6000),
167(50, 3, 'Palimanan', 5000),
168(51, 3, 'Purwakarta', 8000),
169(52, 3, 'Rancaekek', 8000),
170(53, 3, 'Subang', 7500),
171(54, 3, 'Sukabumi', 8000),
172(55, 3, 'Sumedang', 7000),
173(69, 4, 'Boyolali', 16000),
174(68, 4, 'Banyumas', 16000),
175(67, 4, 'Banjarnegara', 17000),
176(66, 4, 'Ambarawa', 15000),
177(65, 3, 'Tasikmalaya', 8000),
178(64, 3, 'Tambun', 8000),
179(70, 4, 'Cepu', 20000),
180(71, 4, 'Cilacap', 11000),
181(72, 4, 'Demak', 17000),
182(73, 4, 'Jepara', 17000),
183(74, 4, 'Karanganyar', 15000),
184(75, 4, 'Kebumen', 18000),
185(76, 4, 'Kendal', 13000),
186(77, 4, 'Klaten', 15000),
187(78, 4, 'Kudus', 15000),
188(79, 4, 'Magelang', 17000),
189(80, 4, 'Pati', 17000),
190(81, 4, 'Pekalongan', 17000),
191(82, 4, 'Pemalang', 19000),
192(83, 4, 'Purbalingga', 17000),
193(84, 4, 'Purwodadi', 17000),
194(85, 4, 'Purwokerto', 16000),
195(86, 4, 'Purworejo', 18000),
196(87, 4, 'Salatiga', 13000),
197(88, 4, 'Semarang', 12000),
198(89, 4, 'Slawi', 20500),
199(90, 4, 'Sragen', 16000),
200(91, 4, 'Sukoharjo', 15000),
201(92, 4, 'Surakarta', 12000),
202(93, 4, 'Tegal', 10000),
203(94, 4, 'Temanggung', 18000),
204(95, 4, 'Ungaran', 12000),
205(96, 4, 'Wonogiri', 16000),
206(97, 4, 'Wonosobo', 18000),
207(98, 5, 'Bantul', 13000),
208(99, 5, 'Kulon Progo', 13500),
209(100, 5, 'Prambanan', 13500),
210(101, 5, 'Sleman', 13500),
211(102, 5, 'Wates', 13500),
212(103, 5, 'Wonosari', 16000),
213(104, 5, 'Yogyakarta', 12000),
214(105, 6, 'Anyer', 9000),
215(106, 6, 'Balaraja', 6500),
216(107, 6, 'Cikupa', 6500),
217(108, 6, 'Cilegon', 6500),
218(109, 6, 'Karawaci', 6500),
219(110, 6, 'Merak', 6500),
220(111, 6, 'Pamulang', 7000),
221(112, 6, 'Pandeglang', 9000),
222(113, 6, 'Serang', 7500),
223(114, 6, 'Serpong', 6500),
224(115, 6, 'Tangerang', 6000),
225(116, 6, 'Tigaraksa', 6500),
226(117, 7, 'Banyuwangi', 25000),
227(118, 7, 'Batu', 19000),
228(119, 7, 'Blitar', 21000),
229(120, 7, 'Bojonegoro', 22500),
230(121, 7, 'Bondowoso', 23000),
231(122, 7, 'Gresik', 16000),
232(123, 7, 'Jember', 19000),
233(124, 7, 'Jombang', 18000),
234(125, 7, 'Kediri', 17000),
235(126, 7, 'Lamongan', 17000),
236(127, 7, 'Lumajang', 20000),
237(128, 7, 'Madiun', 14000),
238(129, 7, 'Malang', 17000),
239(130, 7, 'Mojokerto', 17000),
240(131, 7, 'Nganjuk', 20000),
241(132, 7, 'Ngawi', 17000),
242(133, 7, 'Pamekasan', 28000),
243(134, 7, 'Pandaan', 18000),
244(135, 7, 'Pasuruan', 18000),
245(136, 7, 'Ponorogo', 16000),
246(137, 7, 'Probolinggo', 18000),
247(138, 7, 'Sidoarjo', 14000),
248(139, 7, 'Surabaya', 13000),
249(140, 7, 'Trenggalek', 24500),
250(141, 7, 'Tuban', 18000),
251(142, 7, 'Tulungagung', 20500),
252(143, 7, 'Waru - Sidoarjo', 17500);
253-- --------------------------------------------------------
254--
255-- Table structure for table `outbox`
256--
257CREATE TABLE IF NOT EXISTS `outbox` (
258 `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
259 `InsertIntoDB` timestamp NOT NULL default '0000-00-00 00:00:00',
260 `SendingDateTime` timestamp NOT NULL default '0000-00-00 00:00:00',
261 `Text` text,
262 `DestinationNumber` varchar(20) NOT NULL default '',
263 `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
264 `UDH` text,
265 `Class` int(11) default '-1',
266 `TextDecoded` varchar(160) NOT NULL,
267 `ID` int(10) unsigned NOT NULL auto_increment,
268 `MultiPart` enum('false','true') default 'false',
269 `RelativeValidity` int(11) default '-1',
270 `SenderID` varchar(255) default NULL,
271 `SendingTimeOut` timestamp NULL default '0000-00-00 00:00:00',
272 `DeliveryReport` enum('default','yes','no') default 'default',
273 `CreatorID` text NOT NULL,
274 PRIMARY KEY (`ID`),
275 KEY `outbox_date` (`SendingDateTime`,`SendingTimeOut`),
276 KEY `outbox_sender` (`SenderID`)
277) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
278--
279-- Dumping data for table `outbox`
280--
281INSERT INTO `outbox` (`UpdatedInDB`, `InsertIntoDB`, `SendingDateTime`, `Text`, `DestinationNumber`, `Coding`, `UDH`, `Class`, `TextDecoded`, `ID`, `MultiPart`, `RelativeValidity`, `SenderID`, `SendingTimeOut`, `DeliveryReport`, `CreatorID`) VALUES
282('2012-03-20 21:39:27', '2012-03-20 21:39:27', '2012-03-20 21:39:27', NULL, '08562121141', 'Default_No_Compression', NULL, -1, 'Terima Kasih Telah Berbelanja di Sinar Computer, No Faktur : 120320-092122, Total Pembayaran Rp. 9.270.000 Transfer ke Rek 3740531645 a/n Agoes Sapoetra.', 1, 'false', -1, NULL, '2012-03-20 21:39:27', 'yes', 'system');
283-- --------------------------------------------------------
284--
285-- Table structure for table `outbox_multipart`
286--
287CREATE TABLE IF NOT EXISTS `outbox_multipart` (
288 `Text` text,
289 `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
290 `UDH` text,
291 `Class` int(11) default '-1',
292 `TextDecoded` varchar(160) default NULL,
293 `ID` int(10) unsigned NOT NULL default '0',
294 `SequencePosition` int(11) NOT NULL default '1',
295 PRIMARY KEY (`ID`,`SequencePosition`)
296) ENGINE=MyISAM DEFAULT CHARSET=utf8;
297--
298-- Dumping data for table `outbox_multipart`
299--
300-- --------------------------------------------------------
301--
302-- Table structure for table `pbk`
303--
304CREATE TABLE IF NOT EXISTS `pbk` (
305 `GroupID` int(11) NOT NULL default '-1',
306 `Name` text NOT NULL,
307 `Number` text NOT NULL
308) ENGINE=MyISAM DEFAULT CHARSET=utf8;
309--
310-- Dumping data for table `pbk`
311--
312-- --------------------------------------------------------
313--
314-- Table structure for table `pbk_groups`
315--
316CREATE TABLE IF NOT EXISTS `pbk_groups` (
317 `Name` text NOT NULL,
318 `ID` int(11) NOT NULL auto_increment,
319 PRIMARY KEY (`ID`)
320) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
321--
322-- Dumping data for table `pbk_groups`
323--
324-- --------------------------------------------------------
325--
326-- Table structure for table `phones`
327--
328CREATE TABLE IF NOT EXISTS `phones` (
329 `ID` text NOT NULL,
330 `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
331 `InsertIntoDB` timestamp NOT NULL default '0000-00-00 00:00:00',
332 `TimeOut` timestamp NOT NULL default '0000-00-00 00:00:00',
333 `Send` enum('yes','no') NOT NULL default 'no',
334 `Receive` enum('yes','no') NOT NULL default 'no',
335 `IMEI` varchar(35) NOT NULL,
336 `Client` text NOT NULL,
337 `Battery` int(11) NOT NULL default '0',
338 `Signal` int(11) NOT NULL default '0',
339 `Sent` int(11) NOT NULL default '0',
340 `Received` int(11) NOT NULL default '0',
341 PRIMARY KEY (`IMEI`)
342) ENGINE=MyISAM DEFAULT CHARSET=utf8;
343--
344-- Dumping data for table `phones`
345--
346INSERT INTO `phones` (`ID`, `UpdatedInDB`, `InsertIntoDB`, `TimeOut`, `Send`, `Receive`, `IMEI`, `Client`, `Battery`, `Signal`, `Sent`, `Received`) VALUES
347('MyPhone1', '2010-10-06 02:41:49', '2010-10-06 00:38:44', '2010-10-06 02:41:59', 'yes', 'yes', '352203031941978', 'Gammu 1.25.0, Windows Server 2007, GCC 4.3, MinGW 3.15', 0, 57, 15, 0);
348-- --------------------------------------------------------
349--
350-- Table structure for table `provinsi`
351--
352CREATE TABLE IF NOT EXISTS `provinsi` (
353 `id_prov` int(11) NOT NULL auto_increment,
354 `nama_prov` varchar(50) NOT NULL,
355 PRIMARY KEY (`id_prov`)
356) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
357--
358-- Dumping data for table `provinsi`
359--
360INSERT INTO `provinsi` (`id_prov`, `nama_prov`) VALUES
361(1, 'DKI Jakarta'),
362(2, 'Bali'),
363(3, 'Jawa Barat'),
364(4, 'Jawa Tengah'),
365(5, 'Yogyakarta'),
366(6, 'Banten'),
367(7, 'Jawa Timur');
368-- --------------------------------------------------------
369--
370-- Table structure for table `sentitems`
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` varchar(160) 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-- Dumping data for table `sentitems`
400--
401INSERT INTO `sentitems` (`UpdatedInDB`, `InsertIntoDB`, `SendingDateTime`, `DeliveryDateTime`, `Text`, `DestinationNumber`, `Coding`, `UDH`, `SMSCNumber`, `Class`, `TextDecoded`, `ID`, `SenderID`, `SequencePosition`, `Status`, `StatusError`, `TPMR`, `RelativeValidity`, `CreatorID`) VALUES
402('2010-10-06 02:12:23', '2010-10-06 02:12:11', '2010-10-06 02:12:23', NULL, '0054006500720069006D00610020004B0061007300690068002000540065006C00610068002000420065007200620065006C0061006E006A0061002000640069002000530069006E0061007200200043006F006D00700075007400650072002C0020004E006F002000460061006B0074007500720020003A0020003100300031003000300036002D003000330030003800330030002C00200054006F00740061006C002000500065006D006200610079006100720061006E002000520070002E00200020005400720061006E00730066006500720020006B0065002000520065006B0020003300370034003000350033003100360034003500200061002F006E002000410067006F006500730020005300610070006F0065007400720061002E', '08562121141', 'Default_No_Compression', '', '+6289644000001', -1, 'Terima Kasih Telah Berbelanja di Sinar Computer, No Faktur : 101006-030830, Total Pembayaran Rp. Transfer ke Rek 3740531645 a/n Agoes Sapoetra.', 11, 'MyPhone1', 1, 'SendingOK', -1, 18, 255, 'system'),
403('2010-10-06 02:16:11', '2010-10-06 02:15:58', '2010-10-06 02:16:11', NULL, '0054006500720069006D00610020004B0061007300690068002000540065006C00610068002000420065007200620065006C0061006E006A0061002000640069002000530069006E0061007200200043006F006D00700075007400650072002C0020004E006F002000460061006B0074007500720020003A0020003100300031003000300036002D003000330031003500310038002C00200054006F00740061006C002000500065006D006200610079006100720061006E002000520070002E00200031002E003400370039002E0030003000300020005400720061006E00730066006500720020006B0065002000520065006B0020003300370034003000350033003100360034003500200061002F006E002000410067006F006500730020005300610070006F0065007400720061002E', '08562121141', 'Default_No_Compression', '', '+6289644000001', -1, 'Terima Kasih Telah Berbelanja di Sinar Computer, No Faktur : 101006-031518, Total Pembayaran Rp. 1.479.000 Transfer ke Rek 3740531645 a/n Agoes Sapoetra.', 12, 'MyPhone1', 1, 'SendingOK', -1, 19, 255, 'system'),
404('2010-10-06 02:18:41', '2010-10-06 02:18:28', '2010-10-06 02:18:41', NULL, '0054006500720069006D00610020004B0061007300690068002000540065006C00610068002000420065007200620065006C0061006E006A0061002000640069002000530069006E0061007200200043006F006D00700075007400650072002C0020004E006F002000460061006B0074007500720020003A0020003100300031003000300036002D003000330031003600310035002C00200054006F00740061006C002000500065006D006200610079006100720061006E002000520070002E0020003100350030002E0032003000300020005400720061006E00730066006500720020006B0065002000520065006B0020003300370034003000350033003100360034003500200061002F006E002000410067006F006500730020005300610070006F0065007400720061002E', '02319201211', 'Default_No_Compression', '', '+6289644000001', -1, 'Terima Kasih Telah Berbelanja di Sinar Computer, No Faktur : 101006-031615, Total Pembayaran Rp. 150.200 Transfer ke Rek 3740531645 a/n Agoes Sapoetra.', 13, 'MyPhone1', 1, 'SendingOK', -1, 20, 255, 'system'),
405('2010-10-06 02:20:38', '2010-10-06 02:20:25', '2010-10-06 02:20:38', NULL, '0054006500720069006D00610020004B0061007300690068002000540065006C00610068002000420065007200620065006C0061006E006A0061002000640069002000530069006E0061007200200043006F006D00700075007400650072002C0020004E006F002000460061006B0074007500720020003A0020003100300031003000300036002D003000330031003900310039002C00200054006F00740061006C002000500065006D006200610079006100720061006E002000520070002E0020003300320034002E0030003000300020005400720061006E00730066006500720020006B0065002000520065006B0020003300370034003000350033003100360034003500200061002F006E002000410067006F006500730020005300610070006F0065007400720061002E', '085224812445', 'Default_No_Compression', '', '+6289644000001', -1, 'Terima Kasih Telah Berbelanja di Sinar Computer, No Faktur : 101006-031919, Total Pembayaran Rp. 324.000 Transfer ke Rek 3740531645 a/n Agoes Sapoetra.', 14, 'MyPhone1', 1, 'SendingOK', -1, 21, 255, 'system'),
406('2010-10-06 02:34:40', '2010-10-06 02:34:25', '2010-10-06 02:34:40', NULL, '00500072006F00640075006B002000420061007200750020003A00200063006F00620061002C0020004800610072006700610020003A002000520070002E0020003500350030002E003000300030002C002000530074006F006B0020003A0020003100300030002C0020004B00650074006500720061006E00670061006E0020003A00200048007500620075006E006700690020004B0061006D0069', '08562121141', 'Default_No_Compression', '', '+6289644000001', -1, 'Produk Baru : coba, Harga : Rp. 550.000, Stok : 100, Keterangan : Hubungi Kami', 15, 'MyPhone1', 1, 'SendingOK', -1, 22, 255, 'system'),
407('2010-10-06 02:34:45', '2010-10-06 02:34:25', '2010-10-06 02:34:45', NULL, '00500072006F00640075006B002000420061007200750020003A00200063006F00620061002C0020004800610072006700610020003A002000520070002E0020003500350030002E003000300030002C002000530074006F006B0020003A0020003100300030002C0020004B00650074006500720061006E00670061006E0020003A00200048007500620075006E006700690020004B0061006D0069', '08987300657', 'Default_No_Compression', '', '+6289644000001', -1, 'Produk Baru : coba, Harga : Rp. 550.000, Stok : 100, Keterangan : Hubungi Kami', 16, 'MyPhone1', 1, 'SendingOK', -1, 23, 255, 'system'),
408('2010-10-06 02:35:08', '2010-10-06 02:34:25', '2010-10-06 02:35:08', NULL, '00500072006F00640075006B002000420061007200750020003A00200063006F00620061002C0020004800610072006700610020003A002000520070002E0020003500350030002E003000300030002C002000530074006F006B0020003A0020003100300030002C0020004B00650074006500720061006E00670061006E0020003A00200048007500620075006E006700690020004B0061006D0069', '02319201211', 'Default_No_Compression', '', '+6289644000001', -1, 'Produk Baru : coba, Harga : Rp. 550.000, Stok : 100, Keterangan : Hubungi Kami', 17, 'MyPhone1', 1, 'SendingError', -1, -1, 255, 'system');
409-- --------------------------------------------------------
410--
411-- Table structure for table `tadmin`
412--
413CREATE TABLE IF NOT EXISTS `tadmin` (
414 `username` varchar(50) NOT NULL,
415 `pass` varchar(32) NOT NULL,
416 `idkonsumen` varchar(12) NOT NULL,
417 `level` varchar(10) NOT NULL,
418 PRIMARY KEY (`username`)
419) ENGINE=MyISAM DEFAULT CHARSET=utf8;
420--
421-- Dumping data for table `tadmin`
422--
423INSERT INTO `tadmin` (`username`, `pass`, `idkonsumen`, `level`) VALUES
424('admin', '21232f297a57a5a743894a0e4a801fc3', '', 'admin'),
425('takehikoboyz@gmail.com', '2aa5fdd8488bfe386d6824fc9ae95411', '100926041438', 'member'),
426('felicia_feni@yahoo.co.id', '6fab034efe82b1aa05a07d3cb6bbd6cc', '101006032735', 'member'),
427('takehiko@gmail.com', '96d35c67105ed69516e6924c6b8f0119', '101006032844', 'member');
428-- --------------------------------------------------------
429--
430-- Table structure for table `tbrg`
431--
432CREATE TABLE IF NOT EXISTS `tbrg` (
433 `kdkat` varchar(5) NOT NULL,
434 `kdbrg` int(11) NOT NULL auto_increment,
435 `nmbrg` varchar(50) NOT NULL,
436 `kdmerk` int(11) NOT NULL,
437 `gambar` text NOT NULL,
438 `hrgbeli` double NOT NULL default '0',
439 `hrgjual` double NOT NULL default '0',
440 `stok` int(5) NOT NULL,
441 `spesifikasi` text NOT NULL,
442 `ket` text NOT NULL,
443 `tglmsk` datetime NOT NULL default '0000-00-00 00:00:00',
444 PRIMARY KEY (`kdbrg`)
445) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ;
446--
447-- Dumping data for table `tbrg`
448--
449INSERT INTO `tbrg` (`kdkat`, `kdbrg`, `nmbrg`, `kdmerk`, `gambar`, `hrgbeli`, `hrgjual`, `stok`, `spesifikasi`, `ket`, `tglmsk`) VALUES
450('CD', 1, 'LG DVD Rewriter 24x ( GH 24 ) SATA', 10, '20100609-112425.bmp', 220000, 242000, 100, '<FONT face="arial"><FONT size="2">DVD Burner , DVD+R 24X Write Speed , DVD-ROM 16X Read Speed , Internal Optical Drive</FONT></FONT>', '-<BR>', '2010-06-09 22:24:25'),
451('CD', 2, 'LG DVD Rewriter 22x ( GH 22 ) SATA', 10, '20100609-112539.bmp', 220000, 242000, 94, '<DIV class="proddescription"><FONT face="arial"><FONT size="2">DVD±RW SuperMulti, 22x speed DVD+R , EIDE (ATAPI) \r\nInterface , Internal Optical drive</FONT></FONT></DIV>', '-<BR>', '2010-07-07 22:19:44'),
452('FD', 3, 'Adata C905 4GB', 32, '20100609-112744.bmp', 120000, 132000, 98, '<DIV class="proddescription"><FONT face="arial"><FONT size="2">Unique arc-shaped and grooved contour Aluminum body \r\nwith metallic texture Snap-on cap design on rear end of device</FONT></FONT></DIV>', '-<BR>', '2010-06-09 22:27:44'),
453('FD', 4, 'Adata C905 8GB', 32, '20100609-112836.bmp', 176000, 193600, 100, '<DIV class="proddescription"><FONT face="arial"><FONT size="2">Unique arc-shaped and grooved contour Aluminum body \r\nwith metallic texture Snap-on cap design on rear end of device</FONT></FONT></DIV>', '-<BR>', '2010-06-09 22:28:36'),
454('HD', 5, 'Seagate 80Gb, Barracuda 7200 SATA', 16, '20100609-113019.bmp', 320000, 352000, 100, '<DIV class="proddescription"><FONT face="arial"><FONT size="2">Barracuda 80GB, Serial ATA II 300, 7200 RPM, \r\n3.5"</FONT></FONT></DIV>', '-<BR>', '2010-06-09 22:30:19'),
455('HD', 6, 'Seagate 160Gb, Barracuda 7200 SATA', 16, '20100609-113116.bmp', 330000, 363000, 97, '<FONT face="arial"><FONT size="2">Barracuda 160GB 7200 RPM 8M BCache SATA 3.0Gb/s, 3.5"</FONT></FONT>', '-<BR>', '2010-06-09 22:31:16'),
456('IN', 7, 'Canon BCI-3e (Color)', 6, '20100609-113228.bmp', 89000, 97900, 100, '<DIV class="proddescription"><FONT face="arial"><FONT size="2">Accessory, Printer, Inkjet, Ink Tank, Includes Cyan / \r\nMagenta / Yellow Ink Tanks</FONT></FONT></DIV>', '-<BR>', '2010-06-09 22:32:28'),
457('IN', 8, 'Canon PG-830 Black', 6, '20100609-113353.bmp', 132000, 145200, 99, '<DIV class="proddescription"><FONT face="arial"><FONT size="2">Supplies for \r\nIP-1600/IP-1200/IP-2200/MP-150/MP-170/MP-450</FONT></FONT></DIV>', '-<BR>', '2010-06-09 22:33:53'),
458('MM', 9, 'V-GeN DDR2 1 GB PC-5300 (16 IC)', 18, '20100609-113506.bmp', 220000, 242000, 98, '<DIV class="proddescription"><FONT face="arial"><FONT size="2">PC Memory, DDR2 1 GB , PC-5300(667 MHz), \r\nLong-DIMM</FONT></FONT></DIV>', '-<BR>', '2010-06-17 14:47:50'),
459('MM', 10, 'V-GeN DDR2 1 GB PC-6400 (8 IC)', 18, '20100609-113557.bmp', 210000, 231000, 100, '<DIV class="proddescription"><FONT face="arial"><FONT size="2">PC Memory,DDR2 1GB, PC-6400(800 MHz), Long-DIMM</FONT></FONT></DIV>', '-<BR>', '2010-06-09 22:35:57'),
460('MN', 11, 'ASUS LCD VB171D', 5, '20100609-113723.bmp', 1470000, 1617000, 99, '<DIV class="proddescription"><FONT face="arial"><FONT size="2">17.0", 1280x1024, 0.264mm, 5ms, 300cd/m2, Standart \r\nScreen</FONT></FONT></DIV>', '-<BR>', '2010-06-09 22:37:23'),
461('MN', 12, 'ASUS LCD VW198T', 5, '20100609-113837.bmp', 1120000, 1232000, 100, '<DIV class="proddescription"><FONT face="arial"><FONT size="2">19“1680x1050, 0.243mm, 5 ms, 300 cd/m2, Wide Screen, \r\nDVI</FONT></FONT></DIV>', '-<BR>', '2010-06-09 22:38:37'),
462('MB', 13, 'Asus Sabertooth 55i', 5, '20100609-114003.bmp', 2700000, 2970000, 100, '<DIV class="proddescription"><FONT face="arial"><FONT size="2">Intel® Socket 1156, Intel® P55, FSB 1600/1333/1066 \r\nMHz, 4 DDR3 Dual Channel 2000/1800/1600/1333/1066 MHz, 2 x PCIe x16, 6 x SATA, \r\n14 x USB 2.0, 1 x eSATA, PCIe Gigabit LAN, 10-Channel High Definition Audio, \r\nATX</FONT></FONT></DIV>', '-<BR>', '2010-06-09 22:40:03'),
463('MB', 14, 'Asus P7P55D-E Premium', 5, '20100609-114109.bmp', 3000000, 3300000, 100, '<DIV class="proddescription"><FONT face="arial"><FONT size="2">Intel® Socket 1156, Intel® P55, FSB 1600/1333/1066 \r\nMHz, 4 DDR3 Dual Channel 2000/1800/1600/1333/1066 MHz, 2 x PCIe x16, 6 x SATA, \r\n12 x USB 2.0, 1 x eSATA, Gigabit LAN, 10-Channel High Definition Audio, \r\nATX</FONT></FONT></DIV>', '-<BR>', '2010-06-09 22:41:09'),
464('PC', 15, 'Acer Emachines EL1600', 2, '20100609-114229.bmp', 2750000, 3025000, 99, '<DIV class="proddescription"><FONT face="arial"><FONT size="2">Atom™ 230 - 1.6GHz, 1GB DDR2, 160GB HDD SATA, VGA \r\nIntel GMA 950, DVD±RW, NIC, High-definition Audio, 56K Modem, 5-in-1 Media \r\nReader, USB Stereo 2.0 Speakers, 15" WXGA, Micro Tower ATX, 1-year Parts and \r\nLabor Limited Warranty, Windows Vista Starter</FONT></FONT></DIV>', '-<BR>', '2010-06-09 22:42:29'),
465('PC', 16, 'Acer Emachines EZ1601', 2, '20100609-114354.bmp', 4100000, 4510000, 100, '<DIV class="proddescription"><FONT face="arial"><FONT size="2">Atom™ 270 - 1.6GHz, 1GB DDR2, 160GB HDD SATA, VGA \r\nIntel GMA 950, DVD±RW, GbE NIC, High-definition Audio, WiFi, 4-in-1 Media \r\nReader, Speaker, 18.5" WXGA, All in One PC, 1-year Parts and Labor Limited \r\nWarranty, Windows XP Home SP3</FONT></FONT></DIV>', '-<BR>', '2010-06-09 22:43:54'),
466('PY', 17, 'Acer X1160pz', 2, '20100609-114755.jpg', 6800000, 7480000, 100, '<DIV class="proddescription"><FONT face="arial"><FONT size="2">The big picture has the Acer X1160PZ at Film, Game \r\nand Fun for the whole family. With up to 300 "(7.62 meters) diagonal, 2,400 ANSI \r\nlumens, 2700:1 Contrast and a 1:1.1 zoom is the living room into a cinema and \r\nthe game console experience. The integrated Acer Color Boost II Technology with \r\n6 Segment Farbrad BrilliantColor ™ and DLP ™ chip offers the latest digital \r\nprojection standard for optimized color performance for rich, vivid and \r\nbrilliant colors.</FONT></FONT></DIV>', '-<BR>', '2010-06-09 22:47:55'),
467('PY', 18, 'Acer X1266', 2, '20100609-114923.bmp', 6750000, 7425000, 100, '<DIV class="proddescription"><FONT face="arial"><FONT size="2">XGA (1,024 x 768) , Lumens 2500 ANSI , 1x 2W Speaker \r\n, 2.5Kg , DLP Technology</FONT></FONT></DIV>', '-<BR>', '2010-06-09 22:49:23'),
468('SF', 19, 'Microsoft Windows XP Home Edition SP2b w/Indonesia', 33, '20100609-115231.bmp', 820000, 902000, 100, '<DIV class="proddescription"><FONT face="arial"><FONT size="2">Windows XP Home Edition SP2b English 3pk DSP 3 OEI CD \r\nw/Indonesian LIP LIMITED STOCK</FONT></FONT></DIV>', '-<BR>', '2010-06-09 22:52:31'),
469('SF', 20, 'Microsoft Windows 7 Ultimate x32/x64 - FPP', 33, '20100609-115337.bmp', 1820000, 2002000, 100, '<DIV class="proddescription"><FONT face="arial"><FONT size="2">Full Package Product, Windows 7 Ultimate, 32bit n 64 \r\nBit OS, DVD, 1 User Retail</FONT></FONT></DIV>', '-<BR>', '2010-06-09 22:53:37'),
470('SP', 21, 'Simbadda CST 6300N', 27, '20100609-115455.bmp', 290000, 319000, 98, '<DIV class="proddescription"><FONT face="arial"><FONT size="2">2.1 speaker configuration, 32W RMS, External, RCA \r\nConnectivity</FONT></FONT></DIV>', '-<BR>', '2010-06-09 22:54:55'),
471('SP', 22, 'Simbadda CST 6400N', 27, '20100609-115610.bmp', 300000, 330000, 100, '<DIV class="proddescription"><FONT face="arial"><FONT size="2">2.1 speaker configuration, 32W RMS, External, RCA \r\nConnectivity</FONT></FONT></DIV>', '-<BR>', '2010-06-09 22:56:10'),
472('MD', 23, 'HUAWEI E1550 USB 3.5G HSDPA', 31, '20100609-115731.jpg', 450000, 495000, 96, '<FONT face="arial"><FONT size="2">UMTS/HSDPA/EDGE/GPRS, 3.6 Mpbs, USB 2.0 High Speed Data Transfer</FONT></FONT> ', '-<BR>', '2010-06-09 22:57:31'),
473('MD', 24, 'Sierra Aircard Compass 885u stick', 30, '20100609-115836.jpg', 440000, 484000, 98, '<FONT face="arial"><FONT size="2">HSPA /UMTS /EDGE/GPRS, 7.2 Mbps, Micro SD Memory card slot (up to 4GB), USB</FONT></FONT>', '-<BR>', '2010-06-09 22:58:36'),
474('PR', 25, 'Canon PIXMA iP3680', 6, '20100609-115948.jpg', 820000, 902000, 100, '<DIV class="proddescription"><FONT face="arial"><FONT size="2">A4, 9600 x 2400 dpi, 26/17 ppm, USB</FONT></FONT></DIV>', '-<BR>', '2010-06-09 22:59:48'),
475('PR', 26, 'Canon PIXMA MX328 (Multifunction Print, Scan, Copy', 6, '20100610-120055.jpg', 1100000, 1210000, 100, '<DIV class="proddescription"><FONT face="arial"><FONT size="2">A4, 4800 x 1200 dpi Print, 2400 x 1200 dpi Scan, 33.6 \r\nKbps Modem Fax, USB 2.0</FONT></FONT></DIV>', '-<BR>', '2010-06-09 23:00:55'),
476('SC', 27, 'Canon Lide 700 F', 6, '20100610-120203.jpg', 1200000, 1320000, 99, '<DIV class="proddescription"><FONT face="arial"><FONT size="2">A4 , 9600 × 9600dpi , 48 bit , USB 2.0 Hi-Speed , \r\nFlatbed scaner type</FONT></FONT></DIV>', '-<BR>', '2010-06-09 23:02:03'),
477('SC', 28, 'Canon Scanner Lide 200', 6, '20100610-120332.jpg', 850000, 935000, 100, '<DIV class="proddescription"><FONT face="arial"><FONT size="2">A4 , 300dpi , 48bit , Auto Document Feeder (PDF) , \r\nUSB 2.0 Hi-Speed</FONT></FONT></DIV>', '-<BR>', '2010-06-09 23:03:32'),
478('NB', 29, 'Acer Aspire 4736G - 662G32Mn (Win7HP)', 2, '20100610-120537.jpg', 6800000, 7480000, 99, '<DIV class="proddescription"><FONT face="arial"><FONT size="2">Core2 Duo T6600 - 2.2 GHz, 2GB DDR2, 320GB HDD, VGA \r\nNVIDIA GeForce G103M 512MB (shared), DVD±RW, 56K Modem, GbE NIC, WiFi, \r\nBluetooth, Camera, 5-in-1 Card Reader, 14" WXGA, Win7 Home Premium</FONT></FONT></DIV>', '<FONT face="arial"><FONT size="2">Free Optical Mouse + Laptop Bag + Flashdisk 4 GB</FONT></FONT><BR>', '2010-06-09 23:05:37'),
479('NB', 31, 'Acer Aspire 4732Z - 441G25 (Linux)', 2, '20100611-025716.jpg', 4100000, 4510000, 97, '<FONT face="arial"><FONT size="2">Dual Core T4400 - 2.20 GHz, 1GB DDR2, 250GB HDD, VGA Intel GMA 4500M 284MB (shared), NIC, WiFi, Camera, 5-in-1 Card Reader, 14.1" WXGA, Linux</FONT></FONT>', '<FONT face="arial"><FONT size="2">Free Optical Mouse + Laptop Bag</FONT></FONT><BR>', '2010-06-11 01:57:16');
480-- --------------------------------------------------------
481--
482-- Table structure for table `tdetiljual`
483--
484CREATE TABLE IF NOT EXISTS `tdetiljual` (
485 `iddetil` int(5) NOT NULL auto_increment,
486 `nofaktur` varchar(13) NOT NULL,
487 `jumlah` int(3) NOT NULL default '0',
488 `kdbrg` int(11) NOT NULL,
489 `subtotal` double NOT NULL default '0',
490 PRIMARY KEY (`iddetil`)
491) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;
492--
493-- Dumping data for table `tdetiljual`
494--
495INSERT INTO `tdetiljual` (`iddetil`, `nofaktur`, `jumlah`, `kdbrg`, `subtotal`) VALUES
496(18, '101006-031919', 1, 21, 319000),
497(17, '101006-031615', 1, 8, 145200),
498(16, '101006-031518', 2, 23, 990000),
499(15, '101006-031518', 1, 24, 484000),
500(19, '120320-092122', 2, 31, 9020000),
501(20, '120320-092122', 1, 9, 242000);
502-- --------------------------------------------------------
503--
504-- Table structure for table `tkat`
505--
506CREATE TABLE IF NOT EXISTS `tkat` (
507 `kdkat` varchar(5) NOT NULL,
508 `kategori` varchar(20) NOT NULL,
509 PRIMARY KEY (`kdkat`)
510) ENGINE=MyISAM DEFAULT CHARSET=utf8;
511--
512-- Dumping data for table `tkat`
513--
514INSERT INTO `tkat` (`kdkat`, `kategori`) VALUES
515('SP', 'Speakers'),
516('SC', 'Scanners'),
517('PY', 'Proyektor'),
518('PR', 'Printers'),
519('MM', 'Memory'),
520('IN', 'Ink'),
521('CD', 'CD / DVD External'),
522('PC', 'Paket PC Dekstop'),
523('HD', 'Hard Drive'),
524('FD', 'Flashdisk'),
525('NB', 'Notebook / Net'),
526('MN', 'Monitor'),
527('SF', 'Software'),
528('MB', 'Motherboard'),
529('MD', 'Modem');
530-- --------------------------------------------------------
531--
532-- Table structure for table `tkeranjang`
533--
534CREATE TABLE IF NOT EXISTS `tkeranjang` (
535 `iddetil` int(5) NOT NULL auto_increment,
536 `nofaktur` varchar(13) NOT NULL,
537 `jumlah` int(3) NOT NULL default '0',
538 `kdbrg` int(11) NOT NULL,
539 `subtotal` double NOT NULL default '0',
540 PRIMARY KEY (`iddetil`)
541) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
542--
543-- Dumping data for table `tkeranjang`
544--
545-- --------------------------------------------------------
546--
547-- Table structure for table `tkonsumen`
548--
549CREATE TABLE IF NOT EXISTS `tkonsumen` (
550 `idkonsumen` varchar(13) NOT NULL,
551 `nama` varchar(50) NOT NULL,
552 `alamat` text NOT NULL,
553 `propinsi` varchar(20) NOT NULL,
554 `kota` varchar(30) NOT NULL,
555 `kodepos` varchar(5) NOT NULL,
556 `phone` varchar(20) NOT NULL,
557 `email` text NOT NULL,
558 `nama_bank` varchar(40) NOT NULL,
559 `cabang` varchar(40) NOT NULL,
560 `atas_nama` varchar(50) NOT NULL,
561 `rek` varchar(20) NOT NULL
562) ENGINE=MyISAM DEFAULT CHARSET=utf8;
563--
564-- Dumping data for table `tkonsumen`
565--
566INSERT INTO `tkonsumen` (`idkonsumen`, `nama`, `alamat`, `propinsi`, `kota`, `kodepos`, `phone`, `email`, `nama_bank`, `cabang`, `atas_nama`, `rek`) VALUES
567('101006-031615', 'Takehiko', 'Jl. Kesambi No. 202', '3', '34', '34113', '02319201211', 'takehiko@gmail.com', 'BCA', 'Cipto - Cirebon', 'Takehiko', '3746556442'),
568('101006-031919', 'Yogi Widiyanto', 'Jl. Jamblang', '3', '34', '45343', '085224812445', 'yogi@yahoo.com', 'BNI', 'Cirebon', 'Yogi', '4675657'),
569('100926041438', 'Agus Saputra, A.Md.', 'Jl. Ki Hajar Dewantara No. 142A Arjawinangun', '3', '34', '45162', '08562121141', 'takehikoboyz@gmail.com', 'BCA', 'Cipto - Cirebon', 'Agus Saputra', '3743872733'),
570('120320-092122', 'Sofyan Maulana', 'Mega Kuningan', '1', '2', '12950', '08562121141', 'sofyan.maulana@mitracomm.com', 'BCA', 'Cirebon', 'Agus Saputra', '3740531645');
571-- --------------------------------------------------------
572--
573-- Table structure for table `tmember`
574--
575CREATE TABLE IF NOT EXISTS `tmember` (
576 `idkonsumen` varchar(13) NOT NULL,
577 `nama` varchar(50) NOT NULL,
578 `alamat` text NOT NULL,
579 `propinsi` varchar(20) NOT NULL,
580 `kota` varchar(30) NOT NULL,
581 `kodepos` varchar(5) NOT NULL,
582 `telp` varchar(20) NOT NULL,
583 `email` text NOT NULL,
584 `nama_bank` varchar(40) NOT NULL,
585 `cabang` varchar(40) NOT NULL,
586 `atas_nama` varchar(50) NOT NULL,
587 `rek` varchar(20) NOT NULL,
588 `tgl_aktif` date NOT NULL default '0000-00-00',
589 PRIMARY KEY (`idkonsumen`)
590) ENGINE=MyISAM DEFAULT CHARSET=utf8;
591--
592-- Dumping data for table `tmember`
593--
594INSERT INTO `tmember` (`idkonsumen`, `nama`, `alamat`, `propinsi`, `kota`, `kodepos`, `telp`, `email`, `nama_bank`, `cabang`, `atas_nama`, `rek`, `tgl_aktif`) VALUES
595('100926041438', 'Agus Saputra, A.Md.', 'Jl. Ki Hajar Dewantara No. 142A Arjawinangun', '3', '34', '45162', '08562121141', 'takehikoboyz@gmail.com', 'BCA', 'Cipto - Cirebon', 'Agus Saputra', '3743872733', '2010-09-26'),
596('101006032735', 'Feni Agustin', 'Jl. Kesambi No. 34', '3', '34', '34113', '08987300657', 'felicia_feni@yahoo.co.id', 'BNP', 'Yos Sudarso - Cirebon', 'Feni Agustin', '3748379222', '2010-10-06'),
597('101006032844', 'Takehiko', 'Jl. Kesambi No. 34', '3', '34', '34113', '02319201211', 'takehiko@gmail.com', 'BCA', 'Cipto - Cirebon', 'Takehiko', '3788438783', '2010-10-06');
598--
599-- Dumping data for table `gammu`
600--
601INSERT INTO `gammu` (`Version`) VALUES
602(10);
603-- --------------------------------------------------------
604--
605-- Table structure for table `inbox`
606--
607CREATE TABLE IF NOT EXISTS `inbox` (
608 `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
609 `ReceivingDateTime` timestamp NOT NULL default '0000-00-00 00:00:00',
610 `Text` text NOT NULL,
611 `SenderNumber` varchar(20) NOT NULL default '',
612 `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
613 `UDH` text NOT NULL,
614 `SMSCNumber` varchar(20) NOT NULL default '',
615 `Class` int(11) NOT NULL default '-1',
616 `TextDecoded` varchar(160) NOT NULL default '',
617 `ID` int(10) unsigned NOT NULL auto_increment,
618 `RecipientID` text NOT NULL,
619 `Processed` enum('false','true') NOT NULL default 'false',
620 PRIMARY KEY (`ID`)
621) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
622--
623-- Dumping data for table `inbox`
624--
625INSERT INTO `inbox` (`UpdatedInDB`, `ReceivingDateTime`, `Text`, `SenderNumber`, `Coding`, `UDH`, `SMSCNumber`, `Class`, `TextDecoded`, `ID`, `RecipientID`, `Processed`) VALUES
626('2012-03-22 22:09:16', '2012-03-22 22:07:32', '', '08565818774', 'Default_No_Compression', '', '', -1, 'Asfa Solution', 5, '', 'true'),
627('2012-03-22 22:09:15', '2012-03-22 22:07:36', '', '081565625651', 'Default_No_Compression', '', '', -1, 'tes halo', 4, '', 'true'),
628('2012-03-21 20:43:49', '2012-03-21 15:32:36', '003A00700020', '+628986940410', 'Default_No_Compression', '', '+6289644000001', -1, ':p ', 3, 'MyPhone1', 'true'),
629('2012-03-22 22:09:12', '2012-03-22 22:06:36', '', '08130222211', 'Default_No_Compression', '', '', -1, 'Asfamedia', 6, '', 'true');
630-- --------------------------------------------------------
631--
632-- Table structure for table `outbox`
633--
634CREATE TABLE IF NOT EXISTS `outbox` (
635 `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
636 `InsertIntoDB` timestamp NOT NULL default '0000-00-00 00:00:00',
637 `SendingDateTime` timestamp NOT NULL default '0000-00-00 00:00:00',
638 `Text` text,
639 `DestinationNumber` varchar(20) NOT NULL default '',
640 `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
641 `UDH` text,
642 `Class` int(11) default '-1',
643 `TextDecoded` varchar(160) NOT NULL default '',
644 `ID` int(10) unsigned NOT NULL auto_increment,
645 `MultiPart` enum('false','true') default 'false',
646 `RelativeValidity` int(11) default '-1',
647 `SenderID` varchar(255) default NULL,
648 `SendingTimeOut` timestamp NULL default '0000-00-00 00:00:00',
649 `DeliveryReport` enum('default','yes','no') default 'default',
650 `CreatorID` text NOT NULL,
651 PRIMARY KEY (`ID`),
652 KEY `outbox_date` (`SendingDateTime`,`SendingTimeOut`),
653 KEY `outbox_sender` (`SenderID`)
654) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
655--
656-- Dumping data for table `outbox`
657--
658INSERT INTO `outbox` (`UpdatedInDB`, `InsertIntoDB`, `SendingDateTime`, `Text`, `DestinationNumber`, `Coding`, `UDH`, `Class`, `TextDecoded`, `ID`, `MultiPart`, `RelativeValidity`, `SenderID`, `SendingTimeOut`, `DeliveryReport`, `CreatorID`) VALUES
659('2012-03-21 20:56:12', '2012-03-21 20:56:12', '2012-03-21 20:56:12', NULL, '08562121141', 'Default_No_Compression', NULL, -1, 'Halo', 3, 'false', -1, NULL, '2012-03-21 20:56:12', 'yes', 'system'),
660('2012-03-22 22:11:42', '2012-03-22 22:11:42', '2012-03-22 22:11:42', NULL, '08987300657', 'Default_No_Compression', NULL, -1, 'Tes halo', 4, 'false', -1, NULL, '2012-03-22 22:11:42', 'yes', 'system'),
661('2012-03-22 22:12:01', '2012-03-22 22:12:01', '2012-03-22 22:12:01', NULL, '08562121141', 'Default_No_Compression', NULL, -1, 'Asfa Solution n Asfamedia memang oke', 5, 'false', -1, NULL, '2012-03-22 22:12:01', 'yes', 'system');
662-- --------------------------------------------------------
663--
664-- Table structure for table `outbox_multipart`
665--
666CREATE TABLE IF NOT EXISTS `outbox_multipart` (
667 `Text` text,
668 `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
669 `UDH` text,
670 `Class` int(11) default '-1',
671 `TextDecoded` varchar(160) default NULL,
672 `ID` int(10) unsigned NOT NULL default '0',
673 `SequencePosition` int(11) NOT NULL default '1',
674 PRIMARY KEY (`ID`,`SequencePosition`)
675) ENGINE=MyISAM DEFAULT CHARSET=utf8;
676--
677-- Dumping data for table `outbox_multipart`
678--
679-- --------------------------------------------------------
680--
681-- Table structure for table `pbk`
682--
683CREATE TABLE IF NOT EXISTS `pbk` (
684 `GroupID` int(11) NOT NULL default '-1',
685 `Name` text NOT NULL,
686 `Number` text NOT NULL,
687 `ID` int(11) NOT NULL auto_increment,
688 PRIMARY KEY (`ID`)
689) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
690--
691-- Dumping data for table `pbk`
692--
693INSERT INTO `pbk` (`GroupID`, `Name`, `Number`, `ID`) VALUES
694(1, 'Agus Saputra', '08562121141', 1);
695-- --------------------------------------------------------
696--
697-- Table structure for table `pbk_groups`
698--
699CREATE TABLE IF NOT EXISTS `pbk_groups` (
700 `Name` text NOT NULL,
701 `ID` int(11) NOT NULL auto_increment,
702 PRIMARY KEY (`ID`)
703) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
704--
705-- Dumping data for table `pbk_groups`
706--
707INSERT INTO `pbk_groups` (`Name`, `ID`) VALUES
708('Member', 1),
709('Karyawan', 2);
710-- --------------------------------------------------------
711--
712-- Table structure for table `phones`
713--
714CREATE TABLE IF NOT EXISTS `phones` (
715 `ID` text NOT NULL,
716 `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
717 `InsertIntoDB` timestamp NOT NULL default '0000-00-00 00:00:00',
718 `TimeOut` timestamp NOT NULL default '0000-00-00 00:00:00',
719 `Send` enum('yes','no') NOT NULL default 'no',
720 `Receive` enum('yes','no') NOT NULL default 'no',
721 `IMEI` varchar(35) NOT NULL,
722 `Client` text NOT NULL,
723 `Battery` int(11) NOT NULL default '0',
724 `Signal` int(11) NOT NULL default '0',
725 `Sent` int(11) NOT NULL default '0',
726 `Received` int(11) NOT NULL default '0',
727 PRIMARY KEY (`IMEI`)
728) ENGINE=MyISAM DEFAULT CHARSET=utf8;
729--
730-- Dumping data for table `phones`
731--
732INSERT INTO `phones` (`ID`, `UpdatedInDB`, `InsertIntoDB`, `TimeOut`, `Send`, `Receive`, `IMEI`, `Client`, `Battery`, `Signal`, `Sent`, `Received`) VALUES
733('MyPhone1', '2012-03-21 16:53:13', '2012-03-21 15:28:48', '2012-03-21 16:53:23', 'yes', 'yes', '352203033619465', 'Gammu 1.25.0, Windows Server 2007, GCC 4.3, MinGW 3.15', 0, 60, 1, 3);
734--
735-- Table structure for table `sentitems`
736--
737CREATE TABLE IF NOT EXISTS `sentitems` (
738 `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
739 `InsertIntoDB` timestamp NOT NULL default '0000-00-00 00:00:00',
740 `SendingDateTime` timestamp NOT NULL default '0000-00-00 00:00:00',
741 `DeliveryDateTime` timestamp NULL default NULL,
742 `Text` text NOT NULL,
743 `DestinationNumber` varchar(20) NOT NULL default '',
744 `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
745 `UDH` text NOT NULL,
746 `SMSCNumber` varchar(20) NOT NULL default '',
747 `Class` int(11) NOT NULL default '-1',
748 `TextDecoded` varchar(160) NOT NULL default '',
749 `ID` int(10) unsigned NOT NULL default '0',
750 `SenderID` varchar(255) NOT NULL,
751 `SequencePosition` int(11) NOT NULL default '1',
752 `Status` enum('SendingOK','SendingOKNoReport','SendingError','DeliveryOK','DeliveryFailed','DeliveryPending','DeliveryUnknown','Error') NOT NULL default 'SendingOK',
753 `StatusError` int(11) NOT NULL default '-1',
754 `TPMR` int(11) NOT NULL default '-1',
755 `RelativeValidity` int(11) NOT NULL default '-1',
756 `CreatorID` text NOT NULL,
757 PRIMARY KEY (`ID`,`SequencePosition`),
758 KEY `sentitems_date` (`DeliveryDateTime`),
759 KEY `sentitems_tpmr` (`TPMR`),
760 KEY `sentitems_dest` (`DestinationNumber`),
761 KEY `sentitems_sender` (`SenderID`)
762) ENGINE=MyISAM DEFAULT CHARSET=utf8;
763--
764-- Dumping data for table `sentitems`
765--
766INSERT INTO `sentitems` (`UpdatedInDB`, `InsertIntoDB`, `SendingDateTime`, `DeliveryDateTime`, `Text`, `DestinationNumber`, `Coding`, `UDH`, `SMSCNumber`, `Class`, `TextDecoded`, `ID`, `SenderID`, `SequencePosition`, `Status`, `StatusError`, `TPMR`, `RelativeValidity`, `CreatorID`) VALUES
767('2012-03-22 22:15:22', '2012-03-21 08:10:10', '2012-03-21 08:10:14', '2012-03-21 08:10:14', '', '08562121141', 'Default_No_Compression', '', '', -1, 'Asfa Solution n Asfamedia memang oke', 0, '', 1, 'SendingOK', -1, -1, -1, '');
768-- --------------------------------------------------------
769--
770-- Table structure for table `user`
771--
772CREATE TABLE IF NOT EXISTS `user` (
773 `username` varchar(32) NOT NULL,
774 `password` varchar(32) NOT NULL
775) ENGINE=MyISAM DEFAULT CHARSET=latin1;
776--
777-- Dumping data for table `user`
778--
779INSERT INTO `user` (`username`, `password`) VALUES
780('admin', '21232f297a57a5a743894a0e4a801fc3');
781
782//ProxyService Corporation ! ! !
783//https://www.facebook.com/ProxyServiceCorporation/ (PERSONAL FACEBOOK PAGE)
784//http://twitter.com/ServiceProxy (PERSONAL TWITTER ACCOUNT)
785//Alias Guccifer
786//https://leakforums.net/user-789867 (PERSONAL LEAKFORUMS ACCOUNT)
787//http://crackinglife.xyz/member.php?action=profile&uid=9 (PERSONAL CRACKINGLIFE ACCOUNT)
788//©ProxyService Corporation ~ 2016\\