· 11 years ago · Apr 29, 2015, 01:30 PM
1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
3/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
4/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
5/*!40101 SET NAMES utf8 */;
6--
7-- Database: `dbsms`
8--
9-- Table structure for table `user`
10--
11CREATE TABLE IF NOT EXISTS `user` (
12 `username` varchar(32) NOT NULL,
13 `password` varchar(32) NOT NULL
14) ENGINE=MyISAM DEFAULT CHARSET=latin1;
15--
16-- Dumping data for table `user`
17--
18INSERT INTO `user` (`username`, `password`) VALUES
19('admin', '21232f297a57a5a743894a0e4a801fc3');
20-- phpMyAdmin SQL Dump
21-- version 2.11.7
22-- http://www.phpmyadmin.net
23--
24-- Host: localhost
25-- Generation Time: Mar 24, 2012 at 03:52 AM
26-- Server version: 5.0.51
27-- PHP Version: 5.2.6
28SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
29/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
30/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
31/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
32/*!40101 SET NAMES utf8 */;
33--
34-- Database: `sms`
35--
36-- --------------------------------------------------------
37--
38-- Table structure for table `daemons`
39--
40CREATE TABLE IF NOT EXISTS `daemons` (
41 `Start` text NOT NULL,
42 `Info` text NOT NULL
43) ENGINE=MyISAM DEFAULT CHARSET=utf8;
44--
45-- Dumping data for table `daemons`
46--
47-- --------------------------------------------------------
48--
49-- Table structure for table `gammu`
50--
51CREATE TABLE IF NOT EXISTS `gammu` (
52 `Version` int(11) NOT NULL default '0'
53) ENGINE=MyISAM DEFAULT CHARSET=utf8;
54--
55-- Dumping data for table `gammu`
56--
57INSERT INTO `gammu` (`Version`) VALUES
58(10);
59-- --------------------------------------------------------
60--
61-- Table structure for table `inbox`
62--
63CREATE TABLE IF NOT EXISTS `inbox` (
64 `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
65 `ReceivingDateTime` timestamp NOT NULL default '0000-00-00 00:00:00',
66 `Text` text NOT NULL,
67 `SenderNumber` varchar(20) NOT NULL default '',
68 `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
69 `UDH` text NOT NULL,
70 `SMSCNumber` varchar(20) NOT NULL default '',
71 `Class` int(11) NOT NULL default '-1',
72 `TextDecoded` varchar(160) NOT NULL default '',
73 `ID` int(10) unsigned NOT NULL auto_increment,
74 `RecipientID` text NOT NULL,
75 `Processed` enum('false','true') NOT NULL default 'false',
76 PRIMARY KEY (`ID`)
77) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
78--
79-- Dumping data for table `inbox`
80--
81-- --------------------------------------------------------
82--
83-- Table structure for table `komentar`
84--
85CREATE TABLE IF NOT EXISTS `komentar` (
86 `nou` int(11) NOT NULL auto_increment,
87 `nama` varchar(50) NOT NULL,
88 `email` varchar(100) NOT NULL,
89 `pesan` text NOT NULL,
90 `date` date NOT NULL default '0000-00-00',
91 PRIMARY KEY (`nou`)
92) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;
93--
94-- Dumping data for table `komentar`
95--
96INSERT INTO `komentar` (`nou`, `nama`, `email`, `pesan`, `date`) VALUES
97(6, 'Kristian Pratama', 'kristian_90@yahoo.com', 'halooo...', '2010-07-07'),
98(7, 'Agoes Sapoetra', 'takehikoboyz@gmail.com', 'coba member komen... eror ga Ya?? Kaya nya si dijamin engga..', '2010-07-16'),
99(9, 'Feni Agustin', 'felicia_feni@yahoo.co.id', 'thu bener kan ga error..', '2010-07-16'),
100(19, 'Agus Saputra', 'takehikoboyz@gmail.com', ' Halo ', '2012-03-17');
101-- --------------------------------------------------------
102--
103-- Table structure for table `kota`
104--
105CREATE TABLE IF NOT EXISTS `kota` (
106 `id_kota` int(11) NOT NULL auto_increment,
107 `id_prov` int(11) NOT NULL,
108 `nama_kota` varchar(50) NOT NULL,
109 `biaya` int(10) NOT NULL,
110 PRIMARY KEY (`id_kota`)
111) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=144 ;
112--
113-- Dumping data for table `kota`
114--
115INSERT INTO `kota` (`id_kota`, `id_prov`, `nama_kota`, `biaya`) VALUES
116(1, 1, 'Jakarta Pusat', 8000),
117(2, 1, 'Jakarta Selatan', 8000),
118(3, 1, 'Jakarta Utara', 8000),
119(4, 1, 'Jakarta Barat', 8000),
120(5, 1, 'Jakarta Timur', 8000),
121(6, 1, 'Kepulauan Seribu', 8000),
122(7, 2, 'Badung', 20000),
123(8, 2, 'Buleleng', 23000),
124(9, 2, 'Denpasar', 15000),
125(10, 2, 'Gianyar', 20000),
126(11, 2, 'Gilimanuk', 15000),
127(12, 2, 'Jimbrana', 13000),
128(13, 2, 'Klungkung', 20000),
129(14, 2, 'Kuta', 17000),
130(15, 2, 'Negara', 32000),
131(16, 2, 'Ngurah Rai', 17000),
132(17, 2, 'Nusa Dua', 17000),
133(18, 2, 'Sanur', 17000),
134(19, 2, 'Singaraja', 23000),
135(20, 2, 'Tabanan', 23000),
136(21, 2, 'Ubud', 25000),
137(22, 3, 'Bandung', 8000),
138(23, 3, 'Banjar', 15000),
139(24, 3, 'Bekasi', 7000),
140(25, 3, 'Bogor', 7000),
141(26, 3, 'Ciamis', 12000),
142(27, 3, 'Cianjur', 9500),
143(28, 3, 'Ciawi', 8000),
144(29, 3, 'Cibinong', 6500),
145(30, 3, 'Cibubur', 6000),
146(31, 3, 'Cikarang', 7000),
147(32, 3, 'Cileungsi', 8000),
148(33, 3, 'Cimahi', 9000),
149(34, 3, 'Cirebon', 5000),
150(35, 3, 'Citeureup', 8000),
151(36, 3, 'Depok', 7000),
152(37, 3, 'Garut', 7000),
153(38, 3, 'Indramayu', 6000),
154(39, 3, 'Jatibarang', 6000),
155(40, 3, 'Jatinangor', 7000),
156(41, 3, 'Jatiwangi', 5000),
157(42, 3, 'Kabupaten Bogor', 8000),
158(43, 3, 'Kadipaten', 6000),
159(44, 3, 'Karawang', 7000),
160(45, 3, 'Kuningan', 6000),
161(46, 3, 'Lembang', 8000),
162(47, 3, 'Losari', 6500),
163(48, 3, 'Majalaya', 8000),
164(49, 3, 'Majalengka', 6000),
165(50, 3, 'Palimanan', 5000),
166(51, 3, 'Purwakarta', 8000),
167(52, 3, 'Rancaekek', 8000),
168(53, 3, 'Subang', 7500),
169(54, 3, 'Sukabumi', 8000),
170(55, 3, 'Sumedang', 7000),
171(69, 4, 'Boyolali', 16000),
172(68, 4, 'Banyumas', 16000),
173(67, 4, 'Banjarnegara', 17000),
174(66, 4, 'Ambarawa', 15000),
175(65, 3, 'Tasikmalaya', 8000),
176(64, 3, 'Tambun', 8000),
177(70, 4, 'Cepu', 20000),
178(71, 4, 'Cilacap', 11000),
179(72, 4, 'Demak', 17000),
180(73, 4, 'Jepara', 17000),
181(74, 4, 'Karanganyar', 15000),
182(75, 4, 'Kebumen', 18000),
183(76, 4, 'Kendal', 13000),
184(77, 4, 'Klaten', 15000),
185(78, 4, 'Kudus', 15000),
186(79, 4, 'Magelang', 17000),
187(80, 4, 'Pati', 17000),
188(81, 4, 'Pekalongan', 17000),
189(82, 4, 'Pemalang', 19000),
190(83, 4, 'Purbalingga', 17000),
191(84, 4, 'Purwodadi', 17000),
192(85, 4, 'Purwokerto', 16000),
193(86, 4, 'Purworejo', 18000),
194(87, 4, 'Salatiga', 13000),
195(88, 4, 'Semarang', 12000),
196(89, 4, 'Slawi', 20500),
197(90, 4, 'Sragen', 16000),
198(91, 4, 'Sukoharjo', 15000),
199(92, 4, 'Surakarta', 12000),
200(93, 4, 'Tegal', 10000),
201(94, 4, 'Temanggung', 18000),
202(95, 4, 'Ungaran', 12000),
203(96, 4, 'Wonogiri', 16000),
204(97, 4, 'Wonosobo', 18000),
205(98, 5, 'Bantul', 13000),
206(99, 5, 'Kulon Progo', 13500),
207(100, 5, 'Prambanan', 13500),
208(101, 5, 'Sleman', 13500),
209(102, 5, 'Wates', 13500),
210(103, 5, 'Wonosari', 16000),
211(104, 5, 'Yogyakarta', 12000),
212(105, 6, 'Anyer', 9000),
213(106, 6, 'Balaraja', 6500),
214(107, 6, 'Cikupa', 6500),
215(108, 6, 'Cilegon', 6500),
216(109, 6, 'Karawaci', 6500),
217(110, 6, 'Merak', 6500),
218(111, 6, 'Pamulang', 7000),
219(112, 6, 'Pandeglang', 9000),
220(113, 6, 'Serang', 7500),
221(114, 6, 'Serpong', 6500),
222(115, 6, 'Tangerang', 6000),
223(116, 6, 'Tigaraksa', 6500),
224(117, 7, 'Banyuwangi', 25000),
225(118, 7, 'Batu', 19000),
226(119, 7, 'Blitar', 21000),
227(120, 7, 'Bojonegoro', 22500),
228(121, 7, 'Bondowoso', 23000),
229(122, 7, 'Gresik', 16000),
230(123, 7, 'Jember', 19000),
231(124, 7, 'Jombang', 18000),
232(125, 7, 'Kediri', 17000),
233(126, 7, 'Lamongan', 17000),
234(127, 7, 'Lumajang', 20000),
235(128, 7, 'Madiun', 14000),
236(129, 7, 'Malang', 17000),
237(130, 7, 'Mojokerto', 17000),
238(131, 7, 'Nganjuk', 20000),
239(132, 7, 'Ngawi', 17000),
240(133, 7, 'Pamekasan', 28000),
241(134, 7, 'Pandaan', 18000),
242(135, 7, 'Pasuruan', 18000),
243(136, 7, 'Ponorogo', 16000),
244(137, 7, 'Probolinggo', 18000),
245(138, 7, 'Sidoarjo', 14000),
246(139, 7, 'Surabaya', 13000),
247(140, 7, 'Trenggalek', 24500),
248(141, 7, 'Tuban', 18000),
249(142, 7, 'Tulungagung', 20500),
250(143, 7, 'Waru - Sidoarjo', 17500);
251-- --------------------------------------------------------
252--
253-- Table structure for table `outbox`
254--
255CREATE TABLE IF NOT EXISTS `outbox` (
256 `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
257 `InsertIntoDB` timestamp NOT NULL default '0000-00-00 00:00:00',
258 `SendingDateTime` timestamp NOT NULL default '0000-00-00 00:00:00',
259 `Text` text,
260 `DestinationNumber` varchar(20) NOT NULL default '',
261 `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
262 `UDH` text,
263 `Class` int(11) default '-1',
264 `TextDecoded` varchar(160) NOT NULL,
265 `ID` int(10) unsigned NOT NULL auto_increment,
266 `MultiPart` enum('false','true') default 'false',
267 `RelativeValidity` int(11) default '-1',
268 `SenderID` varchar(255) default NULL,
269 `SendingTimeOut` timestamp NULL default '0000-00-00 00:00:00',
270 `DeliveryReport` enum('default','yes','no') default 'default',
271 `CreatorID` text NOT NULL,
272 PRIMARY KEY (`ID`),
273 KEY `outbox_date` (`SendingDateTime`,`SendingTimeOut`),
274 KEY `outbox_sender` (`SenderID`)
275) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
276--
277-- Dumping data for table `outbox`
278--
279INSERT INTO `outbox` (`UpdatedInDB`, `InsertIntoDB`, `SendingDateTime`, `Text`, `DestinationNumber`, `Coding`, `UDH`, `Class`, `TextDecoded`, `ID`, `MultiPart`, `RelativeValidity`, `SenderID`, `SendingTimeOut`, `DeliveryReport`, `CreatorID`) VALUES
280('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');
281-- --------------------------------------------------------
282--
283-- Table structure for table `outbox_multipart`
284--
285CREATE TABLE IF NOT EXISTS `outbox_multipart` (
286 `Text` text,
287 `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
288 `UDH` text,
289 `Class` int(11) default '-1',
290 `TextDecoded` varchar(160) default NULL,
291 `ID` int(10) unsigned NOT NULL default '0',
292 `SequencePosition` int(11) NOT NULL default '1',
293 PRIMARY KEY (`ID`,`SequencePosition`)
294) ENGINE=MyISAM DEFAULT CHARSET=utf8;
295--
296-- Dumping data for table `outbox_multipart`
297--
298-- --------------------------------------------------------
299--
300-- Table structure for table `pbk`
301--
302CREATE TABLE IF NOT EXISTS `pbk` (
303 `GroupID` int(11) NOT NULL default '-1',
304 `Name` text NOT NULL,
305 `Number` text NOT NULL
306) ENGINE=MyISAM DEFAULT CHARSET=utf8;
307--
308-- Dumping data for table `pbk`
309--
310-- --------------------------------------------------------
311--
312-- Table structure for table `pbk_groups`
313--
314CREATE TABLE IF NOT EXISTS `pbk_groups` (
315 `Name` text NOT NULL,
316 `ID` int(11) NOT NULL auto_increment,
317 PRIMARY KEY (`ID`)
318) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
319--
320-- Dumping data for table `pbk_groups`
321--
322-- --------------------------------------------------------
323--
324-- Table structure for table `phones`
325--
326CREATE TABLE IF NOT EXISTS `phones` (
327 `ID` text NOT NULL,
328 `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
329 `InsertIntoDB` timestamp NOT NULL default '0000-00-00 00:00:00',
330 `TimeOut` timestamp NOT NULL default '0000-00-00 00:00:00',
331 `Send` enum('yes','no') NOT NULL default 'no',
332 `Receive` enum('yes','no') NOT NULL default 'no',
333 `IMEI` varchar(35) NOT NULL,
334 `Client` text NOT NULL,
335 `Battery` int(11) NOT NULL default '0',
336 `Signal` int(11) NOT NULL default '0',
337 `Sent` int(11) NOT NULL default '0',
338 `Received` int(11) NOT NULL default '0',
339 PRIMARY KEY (`IMEI`)
340) ENGINE=MyISAM DEFAULT CHARSET=utf8;
341--
342-- Dumping data for table `phones`
343--
344INSERT INTO `phones` (`ID`, `UpdatedInDB`, `InsertIntoDB`, `TimeOut`, `Send`, `Receive`, `IMEI`, `Client`, `Battery`, `Signal`, `Sent`, `Received`) VALUES
345('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);
346-- --------------------------------------------------------
347--
348-- Table structure for table `provinsi`
349--
350CREATE TABLE IF NOT EXISTS `provinsi` (
351 `id_prov` int(11) NOT NULL auto_increment,
352 `nama_prov` varchar(50) NOT NULL,
353 PRIMARY KEY (`id_prov`)
354) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
355--
356-- Dumping data for table `provinsi`
357--
358INSERT INTO `provinsi` (`id_prov`, `nama_prov`) VALUES
359(1, 'DKI Jakarta'),
360(2, 'Bali'),
361(3, 'Jawa Barat'),
362(4, 'Jawa Tengah'),
363(5, 'Yogyakarta'),
364(6, 'Banten'),
365(7, 'Jawa Timur');
366-- --------------------------------------------------------
367--
368-- Table structure for table `sentitems`
369--
370CREATE TABLE IF NOT EXISTS `sentitems` (
371 `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
372 `InsertIntoDB` timestamp NOT NULL default '0000-00-00 00:00:00',
373 `SendingDateTime` timestamp NOT NULL default '0000-00-00 00:00:00',
374 `DeliveryDateTime` timestamp NULL default NULL,
375 `Text` text NOT NULL,
376 `DestinationNumber` varchar(20) NOT NULL default '',
377 `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
378 `UDH` text NOT NULL,
379 `SMSCNumber` varchar(20) NOT NULL default '',
380 `Class` int(11) NOT NULL default '-1',
381 `TextDecoded` varchar(160) NOT NULL,
382 `ID` int(10) unsigned NOT NULL default '0',
383 `SenderID` varchar(255) NOT NULL,
384 `SequencePosition` int(11) NOT NULL default '1',
385 `Status` enum('SendingOK','SendingOKNoReport','SendingError','DeliveryOK','DeliveryFailed','DeliveryPending','DeliveryUnknown','Error') NOT NULL default 'SendingOK',
386 `StatusError` int(11) NOT NULL default '-1',
387 `TPMR` int(11) NOT NULL default '-1',
388 `RelativeValidity` int(11) NOT NULL default '-1',
389 `CreatorID` text NOT NULL,
390 PRIMARY KEY (`ID`,`SequencePosition`),
391 KEY `sentitems_date` (`DeliveryDateTime`),
392 KEY `sentitems_tpmr` (`TPMR`),
393 KEY `sentitems_dest` (`DestinationNumber`),
394 KEY `sentitems_sender` (`SenderID`)
395) ENGINE=MyISAM DEFAULT CHARSET=utf8;
396--
397-- Dumping data for table `sentitems`
398--
399INSERT INTO `sentitems` (`UpdatedInDB`, `InsertIntoDB`, `SendingDateTime`, `DeliveryDateTime`, `Text`, `DestinationNumber`, `Coding`, `UDH`, `SMSCNumber`, `Class`, `TextDecoded`, `ID`, `SenderID`, `SequencePosition`, `Status`, `StatusError`, `TPMR`, `RelativeValidity`, `CreatorID`) VALUES
400('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'),
401('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'),
402('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'),
403('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'),
404('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'),
405('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'),
406('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');
407-- --------------------------------------------------------
408--
409-- Table structure for table `tadmin`
410--
411CREATE TABLE IF NOT EXISTS `tadmin` (
412 `username` varchar(50) NOT NULL,
413 `pass` varchar(32) NOT NULL,
414 `idkonsumen` varchar(12) NOT NULL,
415 `level` varchar(10) NOT NULL,
416 PRIMARY KEY (`username`)
417) ENGINE=MyISAM DEFAULT CHARSET=utf8;
418--
419-- Dumping data for table `tadmin`
420--
421INSERT INTO `tadmin` (`username`, `pass`, `idkonsumen`, `level`) VALUES
422('admin', '21232f297a57a5a743894a0e4a801fc3', '', 'admin'),
423('takehikoboyz@gmail.com', '2aa5fdd8488bfe386d6824fc9ae95411', '100926041438', 'member'),
424('felicia_feni@yahoo.co.id', '6fab034efe82b1aa05a07d3cb6bbd6cc', '101006032735', 'member'),
425('takehiko@gmail.com', '96d35c67105ed69516e6924c6b8f0119', '101006032844', 'member');
426-- --------------------------------------------------------
427--
428-- Table structure for table `tbrg`
429--
430CREATE TABLE IF NOT EXISTS `tbrg` (
431 `kdkat` varchar(5) NOT NULL,
432 `kdbrg` int(11) NOT NULL auto_increment,
433 `nmbrg` varchar(50) NOT NULL,
434 `kdmerk` int(11) NOT NULL,
435 `gambar` text NOT NULL,
436 `hrgbeli` double NOT NULL default '0',
437 `hrgjual` double NOT NULL default '0',
438 `stok` int(5) NOT NULL,
439 `spesifikasi` text NOT NULL,
440 `ket` text NOT NULL,
441 `tglmsk` datetime NOT NULL default '0000-00-00 00:00:00',
442 PRIMARY KEY (`kdbrg`)
443) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ;
444--
445-- Dumping data for table `tbrg`
446--
447INSERT INTO `tbrg` (`kdkat`, `kdbrg`, `nmbrg`, `kdmerk`, `gambar`, `hrgbeli`, `hrgjual`, `stok`, `spesifikasi`, `ket`, `tglmsk`) VALUES
448('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'),
449('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'),
450('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'),
451('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'),
452('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'),
453('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'),
454('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'),
455('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'),
456('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'),
457('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'),
458('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'),
459('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'),
460('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'),
461('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'),
462('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'),
463('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'),
464('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'),
465('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'),
466('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'),
467('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'),
468('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'),
469('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'),
470('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'),
471('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'),
472('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'),
473('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'),
474('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'),
475('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'),
476('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'),
477('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');
478-- --------------------------------------------------------
479--
480-- Table structure for table `tdetiljual`
481--
482CREATE TABLE IF NOT EXISTS `tdetiljual` (
483 `iddetil` int(5) NOT NULL auto_increment,
484 `nofaktur` varchar(13) NOT NULL,
485 `jumlah` int(3) NOT NULL default '0',
486 `kdbrg` int(11) NOT NULL,
487 `subtotal` double NOT NULL default '0',
488 PRIMARY KEY (`iddetil`)
489) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;
490--
491-- Dumping data for table `tdetiljual`
492--
493INSERT INTO `tdetiljual` (`iddetil`, `nofaktur`, `jumlah`, `kdbrg`, `subtotal`) VALUES
494(18, '101006-031919', 1, 21, 319000),
495(17, '101006-031615', 1, 8, 145200),
496(16, '101006-031518', 2, 23, 990000),
497(15, '101006-031518', 1, 24, 484000),
498(19, '120320-092122', 2, 31, 9020000),
499(20, '120320-092122', 1, 9, 242000);
500-- --------------------------------------------------------
501--
502-- Table structure for table `tkat`
503--
504CREATE TABLE IF NOT EXISTS `tkat` (
505 `kdkat` varchar(5) NOT NULL,
506 `kategori` varchar(20) NOT NULL,
507 PRIMARY KEY (`kdkat`)
508) ENGINE=MyISAM DEFAULT CHARSET=utf8;
509--
510-- Dumping data for table `tkat`
511--
512INSERT INTO `tkat` (`kdkat`, `kategori`) VALUES
513('SP', 'Speakers'),
514('SC', 'Scanners'),
515('PY', 'Proyektor'),
516('PR', 'Printers'),
517('MM', 'Memory'),
518('IN', 'Ink'),
519('CD', 'CD / DVD External'),
520('PC', 'Paket PC Dekstop'),
521('HD', 'Hard Drive'),
522('FD', 'Flashdisk'),
523('NB', 'Notebook / Net'),
524('MN', 'Monitor'),
525('SF', 'Software'),
526('MB', 'Motherboard'),
527('MD', 'Modem');
528-- --------------------------------------------------------
529--
530-- Table structure for table `tkeranjang`
531--
532CREATE TABLE IF NOT EXISTS `tkeranjang` (
533 `iddetil` int(5) NOT NULL auto_increment,
534 `nofaktur` varchar(13) NOT NULL,
535 `jumlah` int(3) NOT NULL default '0',
536 `kdbrg` int(11) NOT NULL,
537 `subtotal` double NOT NULL default '0',
538 PRIMARY KEY (`iddetil`)
539) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
540--
541-- Dumping data for table `tkeranjang`
542--
543-- --------------------------------------------------------
544--
545-- Table structure for table `tkonsumen`
546--
547CREATE TABLE IF NOT EXISTS `tkonsumen` (
548 `idkonsumen` varchar(13) NOT NULL,
549 `nama` varchar(50) NOT NULL,
550 `alamat` text NOT NULL,
551 `propinsi` varchar(20) NOT NULL,
552 `kota` varchar(30) NOT NULL,
553 `kodepos` varchar(5) NOT NULL,
554 `phone` varchar(20) NOT NULL,
555 `email` text NOT NULL,
556 `nama_bank` varchar(40) NOT NULL,
557 `cabang` varchar(40) NOT NULL,
558 `atas_nama` varchar(50) NOT NULL,
559 `rek` varchar(20) NOT NULL
560) ENGINE=MyISAM DEFAULT CHARSET=utf8;
561--
562-- Dumping data for table `tkonsumen`
563--
564INSERT INTO `tkonsumen` (`idkonsumen`, `nama`, `alamat`, `propinsi`, `kota`, `kodepos`, `phone`, `email`, `nama_bank`, `cabang`, `atas_nama`, `rek`) VALUES
565('101006-031615', 'Takehiko', 'Jl. Kesambi No. 202', '3', '34', '34113', '02319201211', 'takehiko@gmail.com', 'BCA', 'Cipto - Cirebon', 'Takehiko', '3746556442'),
566('101006-031919', 'Yogi Widiyanto', 'Jl. Jamblang', '3', '34', '45343', '085224812445', 'yogi@yahoo.com', 'BNI', 'Cirebon', 'Yogi', '4675657'),
567('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'),
568('120320-092122', 'Sofyan Maulana', 'Mega Kuningan', '1', '2', '12950', '08562121141', 'sofyan.maulana@mitracomm.com', 'BCA', 'Cirebon', 'Agus Saputra', '3740531645');
569-- --------------------------------------------------------
570--
571-- Table structure for table `tmember`
572--
573CREATE TABLE IF NOT EXISTS `tmember` (
574 `idkonsumen` varchar(13) NOT NULL,
575 `nama` varchar(50) NOT NULL,
576 `alamat` text NOT NULL,
577 `propinsi` varchar(20) NOT NULL,
578 `kota` varchar(30) NOT NULL,
579 `kodepos` varchar(5) NOT NULL,
580 `telp` varchar(20) NOT NULL,
581 `email` text NOT NULL,
582 `nama_bank` varchar(40) NOT NULL,
583 `cabang` varchar(40) NOT NULL,
584 `atas_nama` varchar(50) NOT NULL,
585 `rek` varchar(20) NOT NULL,
586 `tgl_aktif` date NOT NULL default '0000-00-00',
587 PRIMARY KEY (`idkonsumen`)
588) ENGINE=MyISAM DEFAULT CHARSET=utf8;
589--
590-- Dumping data for table `tmember`
591--
592INSERT INTO `tmember` (`idkonsumen`, `nama`, `alamat`, `propinsi`, `kota`, `kodepos`, `telp`, `email`, `nama_bank`, `cabang`, `atas_nama`, `rek`, `tgl_aktif`) VALUES
593('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'),
594('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'),
595('101006032844', 'Takehiko', 'Jl. Kesambi No. 34', '3', '34', '34113', '02319201211', 'takehiko@gmail.com', 'BCA', 'Cipto - Cirebon', 'Takehiko', '3788438783', '2010-10-06');
596--
597-- Dumping data for table `gammu`
598--
599INSERT INTO `gammu` (`Version`) VALUES
600(10);
601-- --------------------------------------------------------
602--
603-- Table structure for table `inbox`
604--
605CREATE TABLE IF NOT EXISTS `inbox` (
606 `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
607 `ReceivingDateTime` timestamp NOT NULL default '0000-00-00 00:00:00',
608 `Text` text NOT NULL,
609 `SenderNumber` varchar(20) NOT NULL default '',
610 `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
611 `UDH` text NOT NULL,
612 `SMSCNumber` varchar(20) NOT NULL default '',
613 `Class` int(11) NOT NULL default '-1',
614 `TextDecoded` varchar(160) NOT NULL default '',
615 `ID` int(10) unsigned NOT NULL auto_increment,
616 `RecipientID` text NOT NULL,
617 `Processed` enum('false','true') NOT NULL default 'false',
618 PRIMARY KEY (`ID`)
619) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
620--
621-- Dumping data for table `inbox`
622--
623INSERT INTO `inbox` (`UpdatedInDB`, `ReceivingDateTime`, `Text`, `SenderNumber`, `Coding`, `UDH`, `SMSCNumber`, `Class`, `TextDecoded`, `ID`, `RecipientID`, `Processed`) VALUES
624('2012-03-22 22:09:16', '2012-03-22 22:07:32', '', '08565818774', 'Default_No_Compression', '', '', -1, 'Asfa Solution', 5, '', 'true'),
625('2012-03-22 22:09:15', '2012-03-22 22:07:36', '', '081565625651', 'Default_No_Compression', '', '', -1, 'tes halo', 4, '', 'true'),
626('2012-03-21 20:43:49', '2012-03-21 15:32:36', '003A00700020', '+628986940410', 'Default_No_Compression', '', '+6289644000001', -1, ':p ', 3, 'MyPhone1', 'true'),
627('2012-03-22 22:09:12', '2012-03-22 22:06:36', '', '08130222211', 'Default_No_Compression', '', '', -1, 'Asfamedia', 6, '', 'true');
628-- --------------------------------------------------------
629--
630-- Table structure for table `outbox`
631--
632CREATE TABLE IF NOT EXISTS `outbox` (
633 `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
634 `InsertIntoDB` timestamp NOT NULL default '0000-00-00 00:00:00',
635 `SendingDateTime` timestamp NOT NULL default '0000-00-00 00:00:00',
636 `Text` text,
637 `DestinationNumber` varchar(20) NOT NULL default '',
638 `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
639 `UDH` text,
640 `Class` int(11) default '-1',
641 `TextDecoded` varchar(160) NOT NULL default '',
642 `ID` int(10) unsigned NOT NULL auto_increment,
643 `MultiPart` enum('false','true') default 'false',
644 `RelativeValidity` int(11) default '-1',
645 `SenderID` varchar(255) default NULL,
646 `SendingTimeOut` timestamp NULL default '0000-00-00 00:00:00',
647 `DeliveryReport` enum('default','yes','no') default 'default',
648 `CreatorID` text NOT NULL,
649 PRIMARY KEY (`ID`),
650 KEY `outbox_date` (`SendingDateTime`,`SendingTimeOut`),
651 KEY `outbox_sender` (`SenderID`)
652) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
653--
654-- Dumping data for table `outbox`
655--
656INSERT INTO `outbox` (`UpdatedInDB`, `InsertIntoDB`, `SendingDateTime`, `Text`, `DestinationNumber`, `Coding`, `UDH`, `Class`, `TextDecoded`, `ID`, `MultiPart`, `RelativeValidity`, `SenderID`, `SendingTimeOut`, `DeliveryReport`, `CreatorID`) VALUES
657('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'),
658('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'),
659('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');
660-- --------------------------------------------------------
661--
662-- Table structure for table `outbox_multipart`
663--
664CREATE TABLE IF NOT EXISTS `outbox_multipart` (
665 `Text` text,
666 `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
667 `UDH` text,
668 `Class` int(11) default '-1',
669 `TextDecoded` varchar(160) default NULL,
670 `ID` int(10) unsigned NOT NULL default '0',
671 `SequencePosition` int(11) NOT NULL default '1',
672 PRIMARY KEY (`ID`,`SequencePosition`)
673) ENGINE=MyISAM DEFAULT CHARSET=utf8;
674--
675-- Dumping data for table `outbox_multipart`
676--
677-- --------------------------------------------------------
678--
679-- Table structure for table `pbk`
680--
681CREATE TABLE IF NOT EXISTS `pbk` (
682 `GroupID` int(11) NOT NULL default '-1',
683 `Name` text NOT NULL,
684 `Number` text NOT NULL,
685 `ID` int(11) NOT NULL auto_increment,
686 PRIMARY KEY (`ID`)
687) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
688--
689-- Dumping data for table `pbk`
690--
691INSERT INTO `pbk` (`GroupID`, `Name`, `Number`, `ID`) VALUES
692(1, 'Agus Saputra', '08562121141', 1);
693-- --------------------------------------------------------
694--
695-- Table structure for table `pbk_groups`
696--
697CREATE TABLE IF NOT EXISTS `pbk_groups` (
698 `Name` text NOT NULL,
699 `ID` int(11) NOT NULL auto_increment,
700 PRIMARY KEY (`ID`)
701) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
702--
703-- Dumping data for table `pbk_groups`
704--
705INSERT INTO `pbk_groups` (`Name`, `ID`) VALUES
706('Member', 1),
707('Karyawan', 2);
708-- --------------------------------------------------------
709--
710-- Table structure for table `phones`
711--
712CREATE TABLE IF NOT EXISTS `phones` (
713 `ID` text NOT NULL,
714 `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
715 `InsertIntoDB` timestamp NOT NULL default '0000-00-00 00:00:00',
716 `TimeOut` timestamp NOT NULL default '0000-00-00 00:00:00',
717 `Send` enum('yes','no') NOT NULL default 'no',
718 `Receive` enum('yes','no') NOT NULL default 'no',
719 `IMEI` varchar(35) NOT NULL,
720 `Client` text NOT NULL,
721 `Battery` int(11) NOT NULL default '0',
722 `Signal` int(11) NOT NULL default '0',
723 `Sent` int(11) NOT NULL default '0',
724 `Received` int(11) NOT NULL default '0',
725 PRIMARY KEY (`IMEI`)
726) ENGINE=MyISAM DEFAULT CHARSET=utf8;
727--
728-- Dumping data for table `phones`
729--
730INSERT INTO `phones` (`ID`, `UpdatedInDB`, `InsertIntoDB`, `TimeOut`, `Send`, `Receive`, `IMEI`, `Client`, `Battery`, `Signal`, `Sent`, `Received`) VALUES
731('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);
732--
733-- Table structure for table `sentitems`
734--
735CREATE TABLE IF NOT EXISTS `sentitems` (
736 `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
737 `InsertIntoDB` timestamp NOT NULL default '0000-00-00 00:00:00',
738 `SendingDateTime` timestamp NOT NULL default '0000-00-00 00:00:00',
739 `DeliveryDateTime` timestamp NULL default NULL,
740 `Text` text NOT NULL,
741 `DestinationNumber` varchar(20) NOT NULL default '',
742 `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
743 `UDH` text NOT NULL,
744 `SMSCNumber` varchar(20) NOT NULL default '',
745 `Class` int(11) NOT NULL default '-1',
746 `TextDecoded` varchar(160) NOT NULL default '',
747 `ID` int(10) unsigned NOT NULL default '0',
748 `SenderID` varchar(255) NOT NULL,
749 `SequencePosition` int(11) NOT NULL default '1',
750 `Status` enum('SendingOK','SendingOKNoReport','SendingError','DeliveryOK','DeliveryFailed','DeliveryPending','DeliveryUnknown','Error') NOT NULL default 'SendingOK',
751 `StatusError` int(11) NOT NULL default '-1',
752 `TPMR` int(11) NOT NULL default '-1',
753 `RelativeValidity` int(11) NOT NULL default '-1',
754 `CreatorID` text NOT NULL,
755 PRIMARY KEY (`ID`,`SequencePosition`),
756 KEY `sentitems_date` (`DeliveryDateTime`),
757 KEY `sentitems_tpmr` (`TPMR`),
758 KEY `sentitems_dest` (`DestinationNumber`),
759 KEY `sentitems_sender` (`SenderID`)
760) ENGINE=MyISAM DEFAULT CHARSET=utf8;
761--
762-- Dumping data for table `sentitems`
763--
764INSERT INTO `sentitems` (`UpdatedInDB`, `InsertIntoDB`, `SendingDateTime`, `DeliveryDateTime`, `Text`, `DestinationNumber`, `Coding`, `UDH`, `SMSCNumber`, `Class`, `TextDecoded`, `ID`, `SenderID`, `SequencePosition`, `Status`, `StatusError`, `TPMR`, `RelativeValidity`, `CreatorID`) VALUES
765('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, '');
766-- --------------------------------------------------------
767--
768-- Table structure for table `user`
769--
770CREATE TABLE IF NOT EXISTS `user` (
771 `username` varchar(32) NOT NULL,
772 `password` varchar(32) NOT NULL
773) ENGINE=MyISAM DEFAULT CHARSET=latin1;
774--
775-- Dumping data for table `user`
776--
777INSERT INTO `user` (`username`, `password`) VALUES
778('admin', '21232f297a57a5a743894a0e4a801fc3');