Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
- _ _ _____ ___ ___ _ _
- _| || |_| _ | | \/ | | | | |
- |_ __ _| | | |_ __ | . . | ___ _ __ __| | ___| | ____ _
- _| || |_| | | | '_ \| |\/| |/ _ \ '__/ _` |/ _ \ |/ / _` |
- |_ __ _\ \_/ / |_) | | | | __/ | | (_| | __/ < (_| |
- |_||_| \___/| .__/\_| |_/\___|_| \__,_|\___|_|\_\__,_|
- | |
- |_|
- &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
- #OpMerdeka = #Anonymous
- #INDONESIA WE ARE HERE!!!!!!!!!!!!!!!! https://www.youtube.com/watch?v=BROWqjuTM0g
- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8 */;
- --
- -- Database: `dbsms`
- --
- -- Table structure for table `user`
- --
- CREATE TABLE IF NOT EXISTS `user` (
- `username` varchar(32) NOT NULL,
- `password` varchar(32) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `user`
- --
- INSERT INTO `user` (`username`, `password`) VALUES
- ('admin', '21232f297a57a5a743894a0e4a801fc3');
- -- phpMyAdmin SQL Dump
- -- version 2.11.7
- -- http://www.phpmyadmin.net
- --
- -- Host: localhost
- -- Generation Time: Mar 24, 2012 at 03:52 AM
- -- Server version: 5.0.51
- -- PHP Version: 5.2.6
- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8 */;
- --
- -- Database: `sms`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `daemons`
- --
- CREATE TABLE IF NOT EXISTS `daemons` (
- `Start` text NOT NULL,
- `Info` text NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `daemons`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `gammu`
- --
- CREATE TABLE IF NOT EXISTS `gammu` (
- `Version` int(11) NOT NULL default '0'
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `gammu`
- --
- INSERT INTO `gammu` (`Version`) VALUES
- (10);
- -- --------------------------------------------------------
- --
- -- Table structure for table `inbox`
- --
- CREATE TABLE IF NOT EXISTS `inbox` (
- `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
- `ReceivingDateTime` timestamp NOT NULL default '0000-00-00 00:00:00',
- `Text` text NOT NULL,
- `SenderNumber` varchar(20) NOT NULL default '',
- `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
- `UDH` text NOT NULL,
- `SMSCNumber` varchar(20) NOT NULL default '',
- `Class` int(11) NOT NULL default '-1',
- `TextDecoded` varchar(160) NOT NULL default '',
- `ID` int(10) unsigned NOT NULL auto_increment,
- `RecipientID` text NOT NULL,
- `Processed` enum('false','true') NOT NULL default 'false',
- PRIMARY KEY (`ID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
- --
- -- Dumping data for table `inbox`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `komentar`
- --
- CREATE TABLE IF NOT EXISTS `komentar` (
- `nou` int(11) NOT NULL auto_increment,
- `nama` varchar(50) NOT NULL,
- `email` varchar(100) NOT NULL,
- `pesan` text NOT NULL,
- `date` date NOT NULL default '0000-00-00',
- PRIMARY KEY (`nou`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;
- --
- -- Dumping data for table `komentar`
- --
- INSERT INTO `komentar` (`nou`, `nama`, `email`, `pesan`, `date`) VALUES
- (6, 'Kristian Pratama', 'kristian_90@yahoo.com', 'halooo...', '2010-07-07'),
- (7, 'Agoes Sapoetra', 'takehikoboyz@gmail.com', 'coba member komen... eror ga Ya?? Kaya nya si dijamin engga..', '2010-07-16'),
- (9, 'Feni Agustin', 'felicia_feni@yahoo.co.id', 'thu bener kan ga error..', '2010-07-16'),
- (19, 'Agus Saputra', 'takehikoboyz@gmail.com', ' Halo ', '2012-03-17');
- -- --------------------------------------------------------
- --
- -- Table structure for table `kota`
- --
- CREATE TABLE IF NOT EXISTS `kota` (
- `id_kota` int(11) NOT NULL auto_increment,
- `id_prov` int(11) NOT NULL,
- `nama_kota` varchar(50) NOT NULL,
- `biaya` int(10) NOT NULL,
- PRIMARY KEY (`id_kota`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=144 ;
- --
- -- Dumping data for table `kota`
- --
- INSERT INTO `kota` (`id_kota`, `id_prov`, `nama_kota`, `biaya`) VALUES
- (1, 1, 'Jakarta Pusat', 8000),
- (2, 1, 'Jakarta Selatan', 8000),
- (3, 1, 'Jakarta Utara', 8000),
- (4, 1, 'Jakarta Barat', 8000),
- (5, 1, 'Jakarta Timur', 8000),
- (6, 1, 'Kepulauan Seribu', 8000),
- (7, 2, 'Badung', 20000),
- (8, 2, 'Buleleng', 23000),
- (9, 2, 'Denpasar', 15000),
- (10, 2, 'Gianyar', 20000),
- (11, 2, 'Gilimanuk', 15000),
- (12, 2, 'Jimbrana', 13000),
- (13, 2, 'Klungkung', 20000),
- (14, 2, 'Kuta', 17000),
- (15, 2, 'Negara', 32000),
- (16, 2, 'Ngurah Rai', 17000),
- (17, 2, 'Nusa Dua', 17000),
- (18, 2, 'Sanur', 17000),
- (19, 2, 'Singaraja', 23000),
- (20, 2, 'Tabanan', 23000),
- (21, 2, 'Ubud', 25000),
- (22, 3, 'Bandung', 8000),
- (23, 3, 'Banjar', 15000),
- (24, 3, 'Bekasi', 7000),
- (25, 3, 'Bogor', 7000),
- (26, 3, 'Ciamis', 12000),
- (27, 3, 'Cianjur', 9500),
- (28, 3, 'Ciawi', 8000),
- (29, 3, 'Cibinong', 6500),
- (30, 3, 'Cibubur', 6000),
- (31, 3, 'Cikarang', 7000),
- (32, 3, 'Cileungsi', 8000),
- (33, 3, 'Cimahi', 9000),
- (34, 3, 'Cirebon', 5000),
- (35, 3, 'Citeureup', 8000),
- (36, 3, 'Depok', 7000),
- (37, 3, 'Garut', 7000),
- (38, 3, 'Indramayu', 6000),
- (39, 3, 'Jatibarang', 6000),
- (40, 3, 'Jatinangor', 7000),
- (41, 3, 'Jatiwangi', 5000),
- (42, 3, 'Kabupaten Bogor', 8000),
- (43, 3, 'Kadipaten', 6000),
- (44, 3, 'Karawang', 7000),
- (45, 3, 'Kuningan', 6000),
- (46, 3, 'Lembang', 8000),
- (47, 3, 'Losari', 6500),
- (48, 3, 'Majalaya', 8000),
- (49, 3, 'Majalengka', 6000),
- (50, 3, 'Palimanan', 5000),
- (51, 3, 'Purwakarta', 8000),
- (52, 3, 'Rancaekek', 8000),
- (53, 3, 'Subang', 7500),
- (54, 3, 'Sukabumi', 8000),
- (55, 3, 'Sumedang', 7000),
- (69, 4, 'Boyolali', 16000),
- (68, 4, 'Banyumas', 16000),
- (67, 4, 'Banjarnegara', 17000),
- (66, 4, 'Ambarawa', 15000),
- (65, 3, 'Tasikmalaya', 8000),
- (64, 3, 'Tambun', 8000),
- (70, 4, 'Cepu', 20000),
- (71, 4, 'Cilacap', 11000),
- (72, 4, 'Demak', 17000),
- (73, 4, 'Jepara', 17000),
- (74, 4, 'Karanganyar', 15000),
- (75, 4, 'Kebumen', 18000),
- (76, 4, 'Kendal', 13000),
- (77, 4, 'Klaten', 15000),
- (78, 4, 'Kudus', 15000),
- (79, 4, 'Magelang', 17000),
- (80, 4, 'Pati', 17000),
- (81, 4, 'Pekalongan', 17000),
- (82, 4, 'Pemalang', 19000),
- (83, 4, 'Purbalingga', 17000),
- (84, 4, 'Purwodadi', 17000),
- (85, 4, 'Purwokerto', 16000),
- (86, 4, 'Purworejo', 18000),
- (87, 4, 'Salatiga', 13000),
- (88, 4, 'Semarang', 12000),
- (89, 4, 'Slawi', 20500),
- (90, 4, 'Sragen', 16000),
- (91, 4, 'Sukoharjo', 15000),
- (92, 4, 'Surakarta', 12000),
- (93, 4, 'Tegal', 10000),
- (94, 4, 'Temanggung', 18000),
- (95, 4, 'Ungaran', 12000),
- (96, 4, 'Wonogiri', 16000),
- (97, 4, 'Wonosobo', 18000),
- (98, 5, 'Bantul', 13000),
- (99, 5, 'Kulon Progo', 13500),
- (100, 5, 'Prambanan', 13500),
- (101, 5, 'Sleman', 13500),
- (102, 5, 'Wates', 13500),
- (103, 5, 'Wonosari', 16000),
- (104, 5, 'Yogyakarta', 12000),
- (105, 6, 'Anyer', 9000),
- (106, 6, 'Balaraja', 6500),
- (107, 6, 'Cikupa', 6500),
- (108, 6, 'Cilegon', 6500),
- (109, 6, 'Karawaci', 6500),
- (110, 6, 'Merak', 6500),
- (111, 6, 'Pamulang', 7000),
- (112, 6, 'Pandeglang', 9000),
- (113, 6, 'Serang', 7500),
- (114, 6, 'Serpong', 6500),
- (115, 6, 'Tangerang', 6000),
- (116, 6, 'Tigaraksa', 6500),
- (117, 7, 'Banyuwangi', 25000),
- (118, 7, 'Batu', 19000),
- (119, 7, 'Blitar', 21000),
- (120, 7, 'Bojonegoro', 22500),
- (121, 7, 'Bondowoso', 23000),
- (122, 7, 'Gresik', 16000),
- (123, 7, 'Jember', 19000),
- (124, 7, 'Jombang', 18000),
- (125, 7, 'Kediri', 17000),
- (126, 7, 'Lamongan', 17000),
- (127, 7, 'Lumajang', 20000),
- (128, 7, 'Madiun', 14000),
- (129, 7, 'Malang', 17000),
- (130, 7, 'Mojokerto', 17000),
- (131, 7, 'Nganjuk', 20000),
- (132, 7, 'Ngawi', 17000),
- (133, 7, 'Pamekasan', 28000),
- (134, 7, 'Pandaan', 18000),
- (135, 7, 'Pasuruan', 18000),
- (136, 7, 'Ponorogo', 16000),
- (137, 7, 'Probolinggo', 18000),
- (138, 7, 'Sidoarjo', 14000),
- (139, 7, 'Surabaya', 13000),
- (140, 7, 'Trenggalek', 24500),
- (141, 7, 'Tuban', 18000),
- (142, 7, 'Tulungagung', 20500),
- (143, 7, 'Waru - Sidoarjo', 17500);
- -- --------------------------------------------------------
- --
- -- Table structure for table `outbox`
- --
- CREATE TABLE IF NOT EXISTS `outbox` (
- `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
- `InsertIntoDB` timestamp NOT NULL default '0000-00-00 00:00:00',
- `SendingDateTime` timestamp NOT NULL default '0000-00-00 00:00:00',
- `Text` text,
- `DestinationNumber` varchar(20) NOT NULL default '',
- `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
- `UDH` text,
- `Class` int(11) default '-1',
- `TextDecoded` varchar(160) NOT NULL,
- `ID` int(10) unsigned NOT NULL auto_increment,
- `MultiPart` enum('false','true') default 'false',
- `RelativeValidity` int(11) default '-1',
- `SenderID` varchar(255) default NULL,
- `SendingTimeOut` timestamp NULL default '0000-00-00 00:00:00',
- `DeliveryReport` enum('default','yes','no') default 'default',
- `CreatorID` text NOT NULL,
- PRIMARY KEY (`ID`),
- KEY `outbox_date` (`SendingDateTime`,`SendingTimeOut`),
- KEY `outbox_sender` (`SenderID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
- --
- -- Dumping data for table `outbox`
- --
- INSERT INTO `outbox` (`UpdatedInDB`, `InsertIntoDB`, `SendingDateTime`, `Text`, `DestinationNumber`, `Coding`, `UDH`, `Class`, `TextDecoded`, `ID`, `MultiPart`, `RelativeValidity`, `SenderID`, `SendingTimeOut`, `DeliveryReport`, `CreatorID`) VALUES
- ('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');
- -- --------------------------------------------------------
- --
- -- Table structure for table `outbox_multipart`
- --
- CREATE TABLE IF NOT EXISTS `outbox_multipart` (
- `Text` text,
- `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
- `UDH` text,
- `Class` int(11) default '-1',
- `TextDecoded` varchar(160) default NULL,
- `ID` int(10) unsigned NOT NULL default '0',
- `SequencePosition` int(11) NOT NULL default '1',
- PRIMARY KEY (`ID`,`SequencePosition`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `outbox_multipart`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `pbk`
- --
- CREATE TABLE IF NOT EXISTS `pbk` (
- `GroupID` int(11) NOT NULL default '-1',
- `Name` text NOT NULL,
- `Number` text NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `pbk`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `pbk_groups`
- --
- CREATE TABLE IF NOT EXISTS `pbk_groups` (
- `Name` text NOT NULL,
- `ID` int(11) NOT NULL auto_increment,
- PRIMARY KEY (`ID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
- --
- -- Dumping data for table `pbk_groups`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `phones`
- --
- CREATE TABLE IF NOT EXISTS `phones` (
- `ID` text NOT NULL,
- `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
- `InsertIntoDB` timestamp NOT NULL default '0000-00-00 00:00:00',
- `TimeOut` timestamp NOT NULL default '0000-00-00 00:00:00',
- `Send` enum('yes','no') NOT NULL default 'no',
- `Receive` enum('yes','no') NOT NULL default 'no',
- `IMEI` varchar(35) NOT NULL,
- `Client` text NOT NULL,
- `Battery` int(11) NOT NULL default '0',
- `Signal` int(11) NOT NULL default '0',
- `Sent` int(11) NOT NULL default '0',
- `Received` int(11) NOT NULL default '0',
- PRIMARY KEY (`IMEI`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `phones`
- --
- INSERT INTO `phones` (`ID`, `UpdatedInDB`, `InsertIntoDB`, `TimeOut`, `Send`, `Receive`, `IMEI`, `Client`, `Battery`, `Signal`, `Sent`, `Received`) VALUES
- ('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);
- -- --------------------------------------------------------
- --
- -- Table structure for table `provinsi`
- --
- CREATE TABLE IF NOT EXISTS `provinsi` (
- `id_prov` int(11) NOT NULL auto_increment,
- `nama_prov` varchar(50) NOT NULL,
- PRIMARY KEY (`id_prov`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
- --
- -- Dumping data for table `provinsi`
- --
- INSERT INTO `provinsi` (`id_prov`, `nama_prov`) VALUES
- (1, 'DKI Jakarta'),
- (2, 'Bali'),
- (3, 'Jawa Barat'),
- (4, 'Jawa Tengah'),
- (5, 'Yogyakarta'),
- (6, 'Banten'),
- (7, 'Jawa Timur');
- -- --------------------------------------------------------
- --
- -- Table structure for table `sentitems`
- --
- CREATE TABLE IF NOT EXISTS `sentitems` (
- `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
- `InsertIntoDB` timestamp NOT NULL default '0000-00-00 00:00:00',
- `SendingDateTime` timestamp NOT NULL default '0000-00-00 00:00:00',
- `DeliveryDateTime` timestamp NULL default NULL,
- `Text` text NOT NULL,
- `DestinationNumber` varchar(20) NOT NULL default '',
- `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
- `UDH` text NOT NULL,
- `SMSCNumber` varchar(20) NOT NULL default '',
- `Class` int(11) NOT NULL default '-1',
- `TextDecoded` varchar(160) NOT NULL,
- `ID` int(10) unsigned NOT NULL default '0',
- `SenderID` varchar(255) NOT NULL,
- `SequencePosition` int(11) NOT NULL default '1',
- `Status` enum('SendingOK','SendingOKNoReport','SendingError','DeliveryOK','DeliveryFailed','DeliveryPending','DeliveryUnknown','Error') NOT NULL default 'SendingOK',
- `StatusError` int(11) NOT NULL default '-1',
- `TPMR` int(11) NOT NULL default '-1',
- `RelativeValidity` int(11) NOT NULL default '-1',
- `CreatorID` text NOT NULL,
- PRIMARY KEY (`ID`,`SequencePosition`),
- KEY `sentitems_date` (`DeliveryDateTime`),
- KEY `sentitems_tpmr` (`TPMR`),
- KEY `sentitems_dest` (`DestinationNumber`),
- KEY `sentitems_sender` (`SenderID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `sentitems`
- --
- INSERT INTO `sentitems` (`UpdatedInDB`, `InsertIntoDB`, `SendingDateTime`, `DeliveryDateTime`, `Text`, `DestinationNumber`, `Coding`, `UDH`, `SMSCNumber`, `Class`, `TextDecoded`, `ID`, `SenderID`, `SequencePosition`, `Status`, `StatusError`, `TPMR`, `RelativeValidity`, `CreatorID`) VALUES
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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');
- -- --------------------------------------------------------
- --
- -- Table structure for table `tadmin`
- --
- CREATE TABLE IF NOT EXISTS `tadmin` (
- `username` varchar(50) NOT NULL,
- `pass` varchar(32) NOT NULL,
- `idkonsumen` varchar(12) NOT NULL,
- `level` varchar(10) NOT NULL,
- PRIMARY KEY (`username`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `tadmin`
- --
- INSERT INTO `tadmin` (`username`, `pass`, `idkonsumen`, `level`) VALUES
- ('admin', '21232f297a57a5a743894a0e4a801fc3', '', 'admin'),
- ('takehikoboyz@gmail.com', '2aa5fdd8488bfe386d6824fc9ae95411', '100926041438', 'member'),
- ('felicia_feni@yahoo.co.id', '6fab034efe82b1aa05a07d3cb6bbd6cc', '101006032735', 'member'),
- ('takehiko@gmail.com', '96d35c67105ed69516e6924c6b8f0119', '101006032844', 'member');
- -- --------------------------------------------------------
- --
- -- Table structure for table `tbrg`
- --
- CREATE TABLE IF NOT EXISTS `tbrg` (
- `kdkat` varchar(5) NOT NULL,
- `kdbrg` int(11) NOT NULL auto_increment,
- `nmbrg` varchar(50) NOT NULL,
- `kdmerk` int(11) NOT NULL,
- `gambar` text NOT NULL,
- `hrgbeli` double NOT NULL default '0',
- `hrgjual` double NOT NULL default '0',
- `stok` int(5) NOT NULL,
- `spesifikasi` text NOT NULL,
- `ket` text NOT NULL,
- `tglmsk` datetime NOT NULL default '0000-00-00 00:00:00',
- PRIMARY KEY (`kdbrg`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ;
- --
- -- Dumping data for table `tbrg`
- --
- INSERT INTO `tbrg` (`kdkat`, `kdbrg`, `nmbrg`, `kdmerk`, `gambar`, `hrgbeli`, `hrgjual`, `stok`, `spesifikasi`, `ket`, `tglmsk`) VALUES
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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'),
- ('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');
- -- --------------------------------------------------------
- --
- -- Table structure for table `tdetiljual`
- --
- CREATE TABLE IF NOT EXISTS `tdetiljual` (
- `iddetil` int(5) NOT NULL auto_increment,
- `nofaktur` varchar(13) NOT NULL,
- `jumlah` int(3) NOT NULL default '0',
- `kdbrg` int(11) NOT NULL,
- `subtotal` double NOT NULL default '0',
- PRIMARY KEY (`iddetil`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;
- --
- -- Dumping data for table `tdetiljual`
- --
- INSERT INTO `tdetiljual` (`iddetil`, `nofaktur`, `jumlah`, `kdbrg`, `subtotal`) VALUES
- (18, '101006-031919', 1, 21, 319000),
- (17, '101006-031615', 1, 8, 145200),
- (16, '101006-031518', 2, 23, 990000),
- (15, '101006-031518', 1, 24, 484000),
- (19, '120320-092122', 2, 31, 9020000),
- (20, '120320-092122', 1, 9, 242000);
- -- --------------------------------------------------------
- --
- -- Table structure for table `tkat`
- --
- CREATE TABLE IF NOT EXISTS `tkat` (
- `kdkat` varchar(5) NOT NULL,
- `kategori` varchar(20) NOT NULL,
- PRIMARY KEY (`kdkat`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `tkat`
- --
- INSERT INTO `tkat` (`kdkat`, `kategori`) VALUES
- ('SP', 'Speakers'),
- ('SC', 'Scanners'),
- ('PY', 'Proyektor'),
- ('PR', 'Printers'),
- ('MM', 'Memory'),
- ('IN', 'Ink'),
- ('CD', 'CD / DVD External'),
- ('PC', 'Paket PC Dekstop'),
- ('HD', 'Hard Drive'),
- ('FD', 'Flashdisk'),
- ('NB', 'Notebook / Net'),
- ('MN', 'Monitor'),
- ('SF', 'Software'),
- ('MB', 'Motherboard'),
- ('MD', 'Modem');
- -- --------------------------------------------------------
- --
- -- Table structure for table `tkeranjang`
- --
- CREATE TABLE IF NOT EXISTS `tkeranjang` (
- `iddetil` int(5) NOT NULL auto_increment,
- `nofaktur` varchar(13) NOT NULL,
- `jumlah` int(3) NOT NULL default '0',
- `kdbrg` int(11) NOT NULL,
- `subtotal` double NOT NULL default '0',
- PRIMARY KEY (`iddetil`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
- --
- -- Dumping data for table `tkeranjang`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `tkonsumen`
- --
- CREATE TABLE IF NOT EXISTS `tkonsumen` (
- `idkonsumen` varchar(13) NOT NULL,
- `nama` varchar(50) NOT NULL,
- `alamat` text NOT NULL,
- `propinsi` varchar(20) NOT NULL,
- `kota` varchar(30) NOT NULL,
- `kodepos` varchar(5) NOT NULL,
- `phone` varchar(20) NOT NULL,
- `email` text NOT NULL,
- `nama_bank` varchar(40) NOT NULL,
- `cabang` varchar(40) NOT NULL,
- `atas_nama` varchar(50) NOT NULL,
- `rek` varchar(20) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `tkonsumen`
- --
- INSERT INTO `tkonsumen` (`idkonsumen`, `nama`, `alamat`, `propinsi`, `kota`, `kodepos`, `phone`, `email`, `nama_bank`, `cabang`, `atas_nama`, `rek`) VALUES
- ('101006-031615', 'Takehiko', 'Jl. Kesambi No. 202', '3', '34', '34113', '02319201211', 'takehiko@gmail.com', 'BCA', 'Cipto - Cirebon', 'Takehiko', '3746556442'),
- ('101006-031919', 'Yogi Widiyanto', 'Jl. Jamblang', '3', '34', '45343', '085224812445', 'yogi@yahoo.com', 'BNI', 'Cirebon', 'Yogi', '4675657'),
- ('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'),
- ('120320-092122', 'Sofyan Maulana', 'Mega Kuningan', '1', '2', '12950', '08562121141', 'sofyan.maulana@mitracomm.com', 'BCA', 'Cirebon', 'Agus Saputra', '3740531645');
- -- --------------------------------------------------------
- --
- -- Table structure for table `tmember`
- --
- CREATE TABLE IF NOT EXISTS `tmember` (
- `idkonsumen` varchar(13) NOT NULL,
- `nama` varchar(50) NOT NULL,
- `alamat` text NOT NULL,
- `propinsi` varchar(20) NOT NULL,
- `kota` varchar(30) NOT NULL,
- `kodepos` varchar(5) NOT NULL,
- `telp` varchar(20) NOT NULL,
- `email` text NOT NULL,
- `nama_bank` varchar(40) NOT NULL,
- `cabang` varchar(40) NOT NULL,
- `atas_nama` varchar(50) NOT NULL,
- `rek` varchar(20) NOT NULL,
- `tgl_aktif` date NOT NULL default '0000-00-00',
- PRIMARY KEY (`idkonsumen`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `tmember`
- --
- INSERT INTO `tmember` (`idkonsumen`, `nama`, `alamat`, `propinsi`, `kota`, `kodepos`, `telp`, `email`, `nama_bank`, `cabang`, `atas_nama`, `rek`, `tgl_aktif`) VALUES
- ('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'),
- ('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'),
- ('101006032844', 'Takehiko', 'Jl. Kesambi No. 34', '3', '34', '34113', '02319201211', 'takehiko@gmail.com', 'BCA', 'Cipto - Cirebon', 'Takehiko', '3788438783', '2010-10-06');
- --
- -- Dumping data for table `gammu`
- --
- INSERT INTO `gammu` (`Version`) VALUES
- (10);
- -- --------------------------------------------------------
- --
- -- Table structure for table `inbox`
- --
- CREATE TABLE IF NOT EXISTS `inbox` (
- `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
- `ReceivingDateTime` timestamp NOT NULL default '0000-00-00 00:00:00',
- `Text` text NOT NULL,
- `SenderNumber` varchar(20) NOT NULL default '',
- `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
- `UDH` text NOT NULL,
- `SMSCNumber` varchar(20) NOT NULL default '',
- `Class` int(11) NOT NULL default '-1',
- `TextDecoded` varchar(160) NOT NULL default '',
- `ID` int(10) unsigned NOT NULL auto_increment,
- `RecipientID` text NOT NULL,
- `Processed` enum('false','true') NOT NULL default 'false',
- PRIMARY KEY (`ID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
- --
- -- Dumping data for table `inbox`
- --
- INSERT INTO `inbox` (`UpdatedInDB`, `ReceivingDateTime`, `Text`, `SenderNumber`, `Coding`, `UDH`, `SMSCNumber`, `Class`, `TextDecoded`, `ID`, `RecipientID`, `Processed`) VALUES
- ('2012-03-22 22:09:16', '2012-03-22 22:07:32', '', '08565818774', 'Default_No_Compression', '', '', -1, 'Asfa Solution', 5, '', 'true'),
- ('2012-03-22 22:09:15', '2012-03-22 22:07:36', '', '081565625651', 'Default_No_Compression', '', '', -1, 'tes halo', 4, '', 'true'),
- ('2012-03-21 20:43:49', '2012-03-21 15:32:36', '003A00700020', '+628986940410', 'Default_No_Compression', '', '+6289644000001', -1, ':p ', 3, 'MyPhone1', 'true'),
- ('2012-03-22 22:09:12', '2012-03-22 22:06:36', '', '08130222211', 'Default_No_Compression', '', '', -1, 'Asfamedia', 6, '', 'true');
- -- --------------------------------------------------------
- --
- -- Table structure for table `outbox`
- --
- CREATE TABLE IF NOT EXISTS `outbox` (
- `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
- `InsertIntoDB` timestamp NOT NULL default '0000-00-00 00:00:00',
- `SendingDateTime` timestamp NOT NULL default '0000-00-00 00:00:00',
- `Text` text,
- `DestinationNumber` varchar(20) NOT NULL default '',
- `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
- `UDH` text,
- `Class` int(11) default '-1',
- `TextDecoded` varchar(160) NOT NULL default '',
- `ID` int(10) unsigned NOT NULL auto_increment,
- `MultiPart` enum('false','true') default 'false',
- `RelativeValidity` int(11) default '-1',
- `SenderID` varchar(255) default NULL,
- `SendingTimeOut` timestamp NULL default '0000-00-00 00:00:00',
- `DeliveryReport` enum('default','yes','no') default 'default',
- `CreatorID` text NOT NULL,
- PRIMARY KEY (`ID`),
- KEY `outbox_date` (`SendingDateTime`,`SendingTimeOut`),
- KEY `outbox_sender` (`SenderID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
- --
- -- Dumping data for table `outbox`
- --
- INSERT INTO `outbox` (`UpdatedInDB`, `InsertIntoDB`, `SendingDateTime`, `Text`, `DestinationNumber`, `Coding`, `UDH`, `Class`, `TextDecoded`, `ID`, `MultiPart`, `RelativeValidity`, `SenderID`, `SendingTimeOut`, `DeliveryReport`, `CreatorID`) VALUES
- ('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'),
- ('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'),
- ('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');
- -- --------------------------------------------------------
- --
- -- Table structure for table `outbox_multipart`
- --
- CREATE TABLE IF NOT EXISTS `outbox_multipart` (
- `Text` text,
- `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
- `UDH` text,
- `Class` int(11) default '-1',
- `TextDecoded` varchar(160) default NULL,
- `ID` int(10) unsigned NOT NULL default '0',
- `SequencePosition` int(11) NOT NULL default '1',
- PRIMARY KEY (`ID`,`SequencePosition`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `outbox_multipart`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `pbk`
- --
- CREATE TABLE IF NOT EXISTS `pbk` (
- `GroupID` int(11) NOT NULL default '-1',
- `Name` text NOT NULL,
- `Number` text NOT NULL,
- `ID` int(11) NOT NULL auto_increment,
- PRIMARY KEY (`ID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
- --
- -- Dumping data for table `pbk`
- --
- INSERT INTO `pbk` (`GroupID`, `Name`, `Number`, `ID`) VALUES
- (1, 'Agus Saputra', '08562121141', 1);
- -- --------------------------------------------------------
- --
- -- Table structure for table `pbk_groups`
- --
- CREATE TABLE IF NOT EXISTS `pbk_groups` (
- `Name` text NOT NULL,
- `ID` int(11) NOT NULL auto_increment,
- PRIMARY KEY (`ID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
- --
- -- Dumping data for table `pbk_groups`
- --
- INSERT INTO `pbk_groups` (`Name`, `ID`) VALUES
- ('Member', 1),
- ('Karyawan', 2);
- -- --------------------------------------------------------
- --
- -- Table structure for table `phones`
- --
- CREATE TABLE IF NOT EXISTS `phones` (
- `ID` text NOT NULL,
- `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
- `InsertIntoDB` timestamp NOT NULL default '0000-00-00 00:00:00',
- `TimeOut` timestamp NOT NULL default '0000-00-00 00:00:00',
- `Send` enum('yes','no') NOT NULL default 'no',
- `Receive` enum('yes','no') NOT NULL default 'no',
- `IMEI` varchar(35) NOT NULL,
- `Client` text NOT NULL,
- `Battery` int(11) NOT NULL default '0',
- `Signal` int(11) NOT NULL default '0',
- `Sent` int(11) NOT NULL default '0',
- `Received` int(11) NOT NULL default '0',
- PRIMARY KEY (`IMEI`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `phones`
- --
- INSERT INTO `phones` (`ID`, `UpdatedInDB`, `InsertIntoDB`, `TimeOut`, `Send`, `Receive`, `IMEI`, `Client`, `Battery`, `Signal`, `Sent`, `Received`) VALUES
- ('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);
- --
- -- Table structure for table `sentitems`
- --
- CREATE TABLE IF NOT EXISTS `sentitems` (
- `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
- `InsertIntoDB` timestamp NOT NULL default '0000-00-00 00:00:00',
- `SendingDateTime` timestamp NOT NULL default '0000-00-00 00:00:00',
- `DeliveryDateTime` timestamp NULL default NULL,
- `Text` text NOT NULL,
- `DestinationNumber` varchar(20) NOT NULL default '',
- `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
- `UDH` text NOT NULL,
- `SMSCNumber` varchar(20) NOT NULL default '',
- `Class` int(11) NOT NULL default '-1',
- `TextDecoded` varchar(160) NOT NULL default '',
- `ID` int(10) unsigned NOT NULL default '0',
- `SenderID` varchar(255) NOT NULL,
- `SequencePosition` int(11) NOT NULL default '1',
- `Status` enum('SendingOK','SendingOKNoReport','SendingError','DeliveryOK','DeliveryFailed','DeliveryPending','DeliveryUnknown','Error') NOT NULL default 'SendingOK',
- `StatusError` int(11) NOT NULL default '-1',
- `TPMR` int(11) NOT NULL default '-1',
- `RelativeValidity` int(11) NOT NULL default '-1',
- `CreatorID` text NOT NULL,
- PRIMARY KEY (`ID`,`SequencePosition`),
- KEY `sentitems_date` (`DeliveryDateTime`),
- KEY `sentitems_tpmr` (`TPMR`),
- KEY `sentitems_dest` (`DestinationNumber`),
- KEY `sentitems_sender` (`SenderID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `sentitems`
- --
- INSERT INTO `sentitems` (`UpdatedInDB`, `InsertIntoDB`, `SendingDateTime`, `DeliveryDateTime`, `Text`, `DestinationNumber`, `Coding`, `UDH`, `SMSCNumber`, `Class`, `TextDecoded`, `ID`, `SenderID`, `SequencePosition`, `Status`, `StatusError`, `TPMR`, `RelativeValidity`, `CreatorID`) VALUES
- ('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, '');
- -- --------------------------------------------------------
- --
- -- Table structure for table `user`
- --
- CREATE TABLE IF NOT EXISTS `user` (
- `username` varchar(32) NOT NULL,
- `password` varchar(32) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `user`
- --
- INSERT INTO `user` (`username`, `password`) VALUES
- ('admin', '21232f297a57a5a743894a0e4a801fc3');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement