test(3).sql

-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Aug 19, 2017 at 11:29 AM
-- Server version: 10.1.9-MariaDB
-- PHP Version: 5.6.15

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 utf8mb4 */;

--
-- Database: `test`
--

-- --------------------------------------------------------

--
-- Table structure for table `buku`
--

CREATE TABLE `buku` (
  `kd_buku` varchar(35) NOT NULL,
  `judul` varchar(1000) NOT NULL,
  `penerbit` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `buku`
--

INSERT INTO `buku` (`kd_buku`, `judul`, `penerbit`) VALUES
('B001', 'MATEMATIKA SMA-MA/SMK KLS X', 'SEWU'),
('B002', 'BAHASA INDONESIA SMA-MA/SMK KLS X', 'YRAMA WIDYA'),
('B003', 'SOSIOLOGI SMA-MA/SMK KLS X', 'SEWU'),
('B004', 'GEOGRAFI BILINGUAL SMA KLS XI', 'YRAMA WIDYA'),
('M001', 'BUKU GURU IPA TERPADU UNTUK SMP KELAS VIII', 'YRAMA WIDYA'),
('M002', 'BUKU GURU HEADLINE ENGLISH UNTUK SMP KELAS VIII', 'SEWU'),
('M003', 'MATEMATIKA UNTUK SMP/MTS KELAS IX "KURIKULUM 2013"', 'YRAMA WIDYA'),
('M004', 'BUKU GURU HEADLINE ENGLISH 1 FOR SMP/MTS KLS VII KURIKULUM 2013', 'SEWU'),
('S001', 'BUKU GURU TEMATIK UNTUK SD/MI KELAS 1F', 'YRAMA WIDYA'),
('S002', 'TEMATIK BERBAGI PEKERJAAN 4D (TEMA 4) UNTUK SD/MI KELAS 4', 'YRAMA WIDYA'),
('S003', 'MATEMATIKA BERBASIS KARAKTER SD/MI KELAS 1', 'SEWU'),
('S004', 'IPS BERBASIS KARAKTER SD/MI KELAS 2', 'SEWU');

--
-- Triggers `buku`
--
DELIMITER $$
CREATE TRIGGER `addStok` AFTER INSERT ON `buku` FOR EACH ROW BEGIN
 INSERT INTO stok (no_buku,jumlah)
 VALUES (new.kd_buku,0);
 END
$$
DELIMITER ;

-- --------------------------------------------------------

--
-- Table structure for table `buku_masuk`
--

CREATE TABLE `buku_masuk` (
  `no_faktur` varchar(25) NOT NULL,
  `tgl_masuk` date NOT NULL,
  `kd_suplier` varchar(25) NOT NULL,
  `no_po` int(20) NOT NULL,
  `lokasi` int(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `buku_masuk`
--

INSERT INTO `buku_masuk` (`no_faktur`, `tgl_masuk`, `kd_suplier`, `no_po`, `lokasi`) VALUES
('S-19051701', '2017-05-19', 'as', 1, 2),
('S-19051702', '2017-05-19', 'w1', 2, 3),
('S-30051701', '2017-05-30', '12', 12, 1),
('S-30051702', '2017-05-30', '12', 1, 1),
('S-30051703', '2017-05-30', '1', 2, 1),
('S-30051704', '2017-05-30', '13', 1, 1),
('S-30051705', '2017-05-30', '12', 1, 1),
('S-30051706', '2017-05-30', '12', 3, 1);

-- --------------------------------------------------------

--
-- Table structure for table `cek_pesanan`
--

CREATE TABLE `cek_pesanan` (
  `kd_sp` varchar(20) NOT NULL,
  `kd_plgn` varchar(20) NOT NULL,
  `id_sales` varchar(10) NOT NULL,
  `tgl` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cek_pesanan`
--

INSERT INTO `cek_pesanan` (`kd_sp`, `kd_plgn`, `id_sales`, `tgl`) VALUES
('SP17-002', 'a01-00003', 'a01', '2017-08-18');

-- --------------------------------------------------------

--
-- Table structure for table `daemons`
--

CREATE TABLE `daemons` (
  `Start` text NOT NULL,
  `Info` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `data_buku`
--

CREATE TABLE `data_buku` (
  `kode_buku` varchar(50) NOT NULL,
  `no_faktur` varchar(50) NOT NULL,
  `nama_buku` varchar(50) NOT NULL,
  `penerbit` varchar(50) NOT NULL,
  `hrg_distributor` bigint(50) NOT NULL,
  `hrg_satuan` bigint(50) NOT NULL,
  `stok` int(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `data_buku`
--

INSERT INTO `data_buku` (`kode_buku`, `no_faktur`, `nama_buku`, `penerbit`, `hrg_distributor`, `hrg_satuan`, `stok`) VALUES
('4h4h', 'S-15051701', 'sa', 'asde', 12, 13, 5),
('a0009', 'S-15051701', 'ada', 'sad', 1313, 12, 1),
('a009', 'S-15051701', 'sa', 'asde', 12, 12, 12),
('a12', 'S-15051701', 'ads', 'as', 134, 1234, 4),
('a123', 'S-15051701', 'sad', 'asd', 12, 12, 2),
('a123243', 'S-19051702', 'sf', 'df', 1, 1, 1),
('a1256', 'S-15051701', 'assd', 'asda', 123, 12, 1),
('a312', 'S-15051701', 'asda', 'asd', 12345, 12, 1),
('as123e', 'S-18051701', 'asd', 'ds', 123, 1, 1),
('b002', 'S-30051701', 'adasdsadad', 'rerewfdf', 123, 12, 2),
('b005', 'S-12061701', 'b005', 'sdjdk', 21, 12, 5),
('b123', 'S-30051702', 'dfdfdf', 'adsd', 44, 33, 2),
('c121', 'S-30051703', 'adas', 'afegh', 45, 32, 3),
('d12', 'S-15051701', 'asd', 'asd', 12, 1, 1),
('d3', 'S-19051701', 'ad', 'asd', 1, 2, 1),
('e23', 'S-30051705', 'asds', 'ffaaa', 234, 12, 1),
('e32', 'S-30051706', 'adtr', 'dfdg', 3, 2, 1),
('f1234', 'S-15051701', 'asd', 'asd', 1244, 12, 1),
('f32', 'S-30051705', 'ad', 'dasd', 54, 2, 1),
('ryftghjw', 'S-31051701', 'ryftghjw', 'tf', 4, 3, 5),
('s123', 'S-18051701', 'asd', 'asd', 123, 12, 1),
('s423', 'S-30051704', 'ads', 'dgfgf', 45, 3, 3),
('v232', 'S-30051704', 'adsa', 'dfdf', 23, 2, 1);

-- --------------------------------------------------------

--
-- Table structure for table `data_masuk`
--

CREATE TABLE `data_masuk` (
  `kode_buku` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `detail_fbuku`
--

CREATE TABLE `detail_fbuku` (
  `id_fbuku` int(11) NOT NULL,
  `no_fbuku` varchar(50) NOT NULL,
  `kode_buku` varchar(20) NOT NULL,
  `jumlah` int(30) NOT NULL,
  `hrg_satuan` int(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `detail_fbuku`
--

INSERT INTO `detail_fbuku` (`id_fbuku`, `no_fbuku`, `kode_buku`, `jumlah`, `hrg_satuan`) VALUES
(1, 'FB-12061701', 'a001', 2, 3000),
(2, 'FB-12061701', 'a003', 5, 1000),
(3, 'FB-12061701', 'a004', 3, 2000),
(4, 'FB-12061701', 'a005', 1, 3000),
(5, 'FB-13061701', 'a006', 3, 7000),
(6, 'FB-13061701', 'a001', 3, 2000),
(7, 'FB-13061702', 'a001', 3, 2000),
(8, 'FB-13061703', 'a006', 2, 7000),
(9, 'FB-11071701', 'S004', 3, 53000),
(10, 'FB-11071701', 'B004', 4, 46500),
(11, 'FB-12071701', 'B002', 15, 79500),
(12, 'FB-12071701', 'B003', 20, 52500),
(13, 'FB-12071701', 'S004', 20, 53000),
(14, 'FB-17001', 'S004', 3, 53000);

--
-- Triggers `detail_fbuku`
--
DELIMITER $$
CREATE TRIGGER `trgTmbhStokUpdateHrg` AFTER INSERT ON `detail_fbuku` FOR EACH ROW BEGIN
 INSERT INTO stok SET 
 no_buku=new.kode_buku,
 jumlah=new.jumlah
 ON DUPLICATE KEY UPDATE jumlah=jumlah+New.jumlah;
 update harga SET 
 hrg_satuan=new.hrg_satuan
where id_buku=new.kode_buku;
 END
$$
DELIMITER ;

-- --------------------------------------------------------

--
-- Table structure for table `detail_fjual`
--

CREATE TABLE `detail_fjual` (
  `id_fjual` int(50) NOT NULL,
  `kd_fjual` varchar(25) NOT NULL,
  `kode_bk` varchar(25) NOT NULL,
  `jumlah` int(20) NOT NULL,
  `discount` int(20) NOT NULL,
  `subtotal` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `detail_fjual`
--

INSERT INTO `detail_fjual` (`id_fjual`, `kd_fjual`, `kode_bk`, `jumlah`, `discount`, `subtotal`) VALUES
(1, 'FJ-17001', 'S004', 6, 10, 286200),
(2, 'FJ-17001', 'B002', 2, 5, 151050);

--
-- Triggers `detail_fjual`
--
DELIMITER $$
CREATE TRIGGER `UpdateStokUpdateSubtotal` AFTER INSERT ON `detail_fjual` FOR EACH ROW BEGIN
 INSERT INTO stok SET 
 no_buku=new.kode_bk,
 jumlah=new.jumlah
 ON DUPLICATE KEY UPDATE jumlah=jumlah-New.jumlah;
 INSERT INTO total_jual SET
 kd_faktur=new.kd_fjual,
 total=new.subtotal
 ON DUPLICATE KEY UPDATE total=total+New.subtotal;
 END
$$
DELIMITER ;
DELIMITER $$
CREATE TRIGGER `deleteTotalandPiutang` AFTER DELETE ON `detail_fjual` FOR EACH ROW BEGIN
DELETE from total_jual where kd_faktur=old.kd_fjual;

Update stok SET
jumlah=jumlah+old.jumlah where no_buku = old.kode_bk; 
 END
$$
DELIMITER ;

-- --------------------------------------------------------

--
-- Table structure for table `detail_sp`
--

CREATE TABLE `detail_sp` (
  `id_sp` int(11) NOT NULL,
  `kode_sp` varchar(50) NOT NULL,
  `kode_buku` varchar(50) NOT NULL,
  `jmlh` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `detail_sp`
--

INSERT INTO `detail_sp` (`id_sp`, `kode_sp`, `kode_buku`, `jmlh`) VALUES
(1, 'SP-14061701', 'a001', 2),
(2, 'SP-14061701', 'a006', 2),
(3, 'SP-14061702', 'a001', 2),
(4, 'SP-14061703', 'a001', 2),
(5, 'SP-14061704', 'a001', 4),
(6, 'SP-14061705', 'a001', 3),
(7, 'SP-14061706', 'a001', 2),
(8, 'SP-14061707', 'a001', 2),
(9, 'SP-16061701', 'a001', 3),
(10, 'SP-16061702', 'a001', 4),
(11, 'SP-16061702', 'a001', 3),
(12, 'SP-16061702', 'a006', 3),
(13, 'SP-18061701', 'a001', 4),
(14, 'SP-18061702', 'a001', 3),
(15, 'SP-18061702', 'a006', 2),
(16, 'SP-19061701', 'a001', 20),
(17, 'SP-12071701', 'S004', 3),
(18, 'SP17-001', 'S004', 6),
(19, 'SP17-001', 'B002', 2),
(20, 'SP17-002', 'B003', 3);

-- --------------------------------------------------------

--
-- Table structure for table `faktur_buku`
--

CREATE TABLE `faktur_buku` (
  `no_fbuku` varchar(50) NOT NULL,
  `tgl` date NOT NULL,
  `kd_suplier` int(10) NOT NULL,
  `no_po` int(10) NOT NULL,
  `lokasi` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `faktur_buku`
--

INSERT INTO `faktur_buku` (`no_fbuku`, `tgl`, `kd_suplier`, `no_po`, `lokasi`) VALUES
('FB-11071701', '2017-07-11', 1, 1, 1),
('FB-12061701', '2017-06-12', 1, 1, 1),
('FB-12071701', '2017-07-12', 1, 1, 1),
('FB-13061701', '2017-06-13', 3, 3, 3),
('FB-13061702', '2017-06-13', 2, 1, 1),
('FB-13061703', '2017-06-13', 2, 2, 2),
('FB-17001', '2017-08-16', 1, 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `faktur_jual`
--

CREATE TABLE `faktur_jual` (
  `no_fjual` varchar(50) NOT NULL,
  `no_sp` varchar(25) NOT NULL,
  `kode_plgn` varchar(25) NOT NULL,
  `kode_sales` varchar(20) NOT NULL,
  `j_tgl` date NOT NULL,
  `j_tempo` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `faktur_jual`
--

INSERT INTO `faktur_jual` (`no_fjual`, `no_sp`, `kode_plgn`, `kode_sales`, `j_tgl`, `j_tempo`) VALUES
('FJ-17001', 'SP17-001', 'a01-00003', 'a01', '2017-08-16', '2017-08-17'),
('FJ17-001', 'SP17-001', 'a01-00003', 'a01', '2017-08-19', '2017-08-20'),
('FJ17-002', 'SP17-002', 'a01-00003', 'a01', '2017-08-19', '2017-08-20');

--
-- Triggers `faktur_jual`
--
DELIMITER $$
CREATE TRIGGER `updatePiutang` AFTER INSERT ON `faktur_jual` FOR EACH ROW BEGIN
Update piutang SET
 kode_fjual = new.no_fjual,
 kode_plgn = new.kode_plgn,
 tgl=new.j_tgl
where kode_fjual=new.no_fjual;
delete from cek_pesanan where kd_sp=new.no_sp;
END
$$
DELIMITER ;

-- --------------------------------------------------------

--
-- Table structure for table `gammu`
--

CREATE TABLE `gammu` (
  `Version` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `gammu`
--

INSERT INTO `gammu` (`Version`) VALUES
(13);

-- --------------------------------------------------------

--
-- Table structure for table `harga`
--

CREATE TABLE `harga` (
  `id_buku` varchar(20) NOT NULL,
  `hrg_satuan` int(11) NOT NULL,
  `hrg_distributor` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `harga`
--

INSERT INTO `harga` (`id_buku`, `hrg_satuan`, `hrg_distributor`) VALUES
('B001', 99500, 99500),
('B002', 79500, 79500),
('B003', 52500, 52500),
('B004', 46500, 46500),
('M001', 39500, 39500),
('M002', 39500, 39500),
('M003', 96000, 96000),
('M004', 39500, 39500),
('S001', 38000, 38000),
('S002', 45000, 45000),
('S003', 63000, 63000),
('S004', 53000, 53000);

-- --------------------------------------------------------

--
-- Table structure for table `harga_buku`
--

CREATE TABLE `harga_buku` (
  `id_meta` int(11) NOT NULL,
  `jenis` varchar(20) NOT NULL,
  `value` int(11) NOT NULL,
  `tgl` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `harga_buku`
--

INSERT INTO `harga_buku` (`id_meta`, `jenis`, `value`, `tgl`) VALUES
(1, 'faktur_buku', 0, '0000-00-00'),
(2, 'faktur_jual', 0, '0000-00-00');

-- --------------------------------------------------------

--
-- Table structure for table `inbox`
--

CREATE TABLE `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` text NOT NULL,
  `ID` int(10) UNSIGNED NOT NULL,
  `RecipientID` text NOT NULL,
  `Processed` enum('false','true') NOT NULL DEFAULT 'false'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `inbox`
--

INSERT INTO `inbox` (`UpdatedInDB`, `ReceivingDateTime`, `Text`, `SenderNumber`, `Coding`, `UDH`, `SMSCNumber`, `Class`, `TextDecoded`, `ID`, `RecipientID`, `Processed`) VALUES
('2015-12-04 13:57:22', '2015-12-04 12:59:43', '00540065006C006B006F006D00730065006C0020004E00610069006B0020004800610072006700610020004E006100730069006F006E0061006C000D000A00280043004C003800340029002C00200053004600310030002E003000380031003200350033003500350032003900370036002000530055004B005300450053002C00200053004E003A003C0035003100320030003400310039003500390033003100320031003900310039003600330031003E003E002C0048002E00310030002E003800320039002C00200053003D0020003C00520070002E003300330036002E003600310033003E', '+6289674987196', 'Default_No_Compression', '', '+628964011098', -1, 'Telkomsel Naik Harga Nasional\r\n(CL84), SF10.081253552976 SUKSES, SN:<5120419593121919631>>,H.10.829, S= <Rp.336.613>', 6, '', 'false'),
('2015-12-03 08:24:23', '2015-12-03 07:32:40', '0073006400660073006400660064007300660064007300660073006400660073006400660073006600640073006600730066', '+6283840400679', 'Default_No_Compression', '', '+628315000032', 1, 'sdfsdfdsfdsfsdfsdfsfdsfsf', 2, '', 'false'),
('2015-12-03 08:24:23', '2015-12-03 07:50:00', '0053007700610064006500650020006B00680061', '+628982168343', 'Default_No_Compression', '', '+628964011094', -1, 'Swadee kha', 3, '', 'false'),
('2015-12-03 09:39:04', '2015-12-03 07:27:07', '00530065006100640064006500650020006B00680061', '+628982168343', 'Default_No_Compression', '', '+628964011094', -1, 'Seaddee kha', 4, '', 'false'),
('2015-12-03 09:41:02', '2015-12-03 09:39:37', '0074', '+628973450211', 'Default_No_Compression', '', '+628964011094', -1, 't', 5, '', 'false'),
('2015-12-04 14:00:42', '2015-12-04 14:00:37', '005400650073002000670061006D006D0075', '+6289693214771', 'Default_No_Compression', '', '+628964011098', -1, 'Tes gammu', 7, '', 'false'),
('2015-12-07 00:54:59', '2015-11-12 07:02:21', '004B006500790077006F0072006400200043004C0055005300540045005200200074006900640061006B0020007400650072006400610066007400610072002000640069002000730069007300740065006D00200033003900330035', '3935', 'Default_No_Compression', '', '+6281100000', -1, 'Keyword CLUSTER tidak terdaftar di sistem 3935', 8, '', 'false'),
('2015-12-07 00:54:59', '2015-11-12 07:02:34', '004B006500790077006F0072006400200043004C0055005300540045005200200074006900640061006B0020007400650072006400610066007400610072002000640069002000730069007300740065006D00200033003900330035', '3935', 'Default_No_Compression', '', '+6281100000', -1, 'Keyword CLUSTER tidak terdaftar di sistem 3935', 9, '', 'false'),
('2015-12-07 00:55:00', '2015-11-12 07:02:43', '0054006500720069006D00610020006B0061007300690068002000740065006C006100680020006D006A0064002000700065006C0061006E006700670061006E002000730069006D0050004100540049002E002000430065006B002000700061006B006500740020006E0065006C0070006F006E002C00200073006D0073002C0020002600200069006E007400650072006E006500740020006400690020002A00390039003900230020006100740061007500200064006F0077006E006C006F006100640020004D007900540065006C006B006F006D00730065006C002000610070007000730020006400690020007400730065006C002E006D0065002F0031002000730069006D0050004100540049002000230059006F00750072004500760065007200790064006100790044006900730063006F0076006500720079', 'TELKOMSEL', 'Default_No_Compression', '', '+6281100000', 1, 'Terima kasih telah mjd pelanggan simPATI. Cek paket nelpon, sms, & internet di *999# atau download MyTelkomsel apps di tsel.me/1 simPATI #YourEverydayDiscovery', 10, '', 'false'),
('2015-12-07 00:55:00', '2015-11-12 07:02:59', '004D006F0068006F006E0020006D0061006100660020007000650072006D0069006E007400610061006E00200041006E0064006100200074006900640061006B002000640061007000610074002000640069006C0061006E006A00750074006B0061006E002E00200028006E00610063006B0029', '3935', 'Default_No_Compression', '', '+6281100000', -1, 'Mohon maaf permintaan Anda tidak dapat dilanjutkan. (nack)', 11, '', 'false'),
('2015-12-07 00:55:00', '2015-11-12 07:03:45', '0041006E0064006100200061006B0061006E0020006200650072006C0061006E006700670061006E0061006E002000700061006B00650074002000520070002E00340039003000300030002000750074006B00200035003000300020004D00420020002B00200031002E0035002000470042002000440061007400610020004C006F006B0061006C002F0036003000200068006100720069002E004A0069006B006100200073006500740075006A0075002000620061006C00610073002000200046004C004100530048003C00730070006100730069003E005900410020006B006900720069006D0020006B006500200033003600330036002000750074006B0020006D0065006C0061006E006A00750074006B0061006E002E00500061006B006500740020006400690070', '3636', 'Default_No_Compression', '0500033F0201', '+6281100000', 1, 'Anda akan berlangganan paket Rp.49000 utk 500 MB + 1.5 GB Data Lokal/60 hari.Jika setuju balas  FLASH<spasi>YA kirim ke 3636 utk melanjutkan.Paket dip', 12, '', 'false'),
('2015-12-07 00:55:00', '2015-11-12 07:03:46', '0065007200700061006E006A0061006E00670020007000610064006100200061006B0068006900720020006D00610073006100200061006B007400690066002000640065006E00670061006E00200074006100720069006600200073006500730075006100690020006C006F006B00610073006900200041006E00640061002E002000540075006E00670067007500200053004D00530020006B006F006E006600690072006D006100730069002000730062006C006D002000700065006D0061006B006100690061006E002E0049006E0066006F002000640065007400610069006C00200074006100720069006600660020006C00690068006100740020006400690020005400730065006C002E006D0065002F0069006E007400650072006E006500740020', '3636', 'Default_No_Compression', '0500033F0202', '+6281100000', 1, 'erpanjang pada akhir masa aktif dengan tarif sesuai lokasi Anda. Tunggu SMS konfirmasi sblm pemakaian.Info detail tariff lihat di Tsel.me/internet ', 13, '', 'false'),
('2015-12-07 00:55:01', '2015-11-12 07:03:54', '00530065006C0061006D00610074002000500061006B0065007400200046006C00610073006800200035003000300020004D00420020002B00200031002E0035002000470042002000440061007400610020004C006F006B0061006C0020002800360030002000680061007200690029002000520070002E00340039003000300030002000740065006C006100680020006400690061006B007400690066006B0061006E002C0020006200650072006C0061006B007500200073002F0064002000740067006C002000310030002F00300031002F003200300031003600200070006B002E002000320033003A003500390020005700490042002E002000500061006B006500740020006C0061006E006700730075006E006700200064006900700065007200700061006E006A', '3636', 'Default_No_Compression', '0500031E0301', '+6281100000', 1, 'Selamat Paket Flash 500 MB + 1.5 GB Data Lokal (60 hari) Rp.49000 telah diaktifkan, berlaku s/d tgl 10/01/2016 pk. 23:59 WIB. Paket langsung diperpanj', 14, '', 'false'),
('2015-12-07 00:55:01', '2015-11-12 07:03:55', '0061006E00670020007000610064006100200061006B0068006900720020006D00610073006100200061006B007400690066002000700061006B00650074002000640065006E00670061006E00200074006100720069006600200073006500730075006100690020006C006F006B00610073006900200041006E00640061002E002000430065006B0020007300740061007400750073002F00620065007200680065006E007400690020006200650072006C0061006E006700670061006E0061006E0020006D0065006C0061006C007500690020002A0033003600330023002E00200049006E0066006F002000640065007400610069006C0020007400610072006900660020006C00690068006100740020006400690020005400730065006C002E006D0065002F0069006E', '3636', 'Default_No_Compression', '0500031E0302', '+6281100000', 1, 'ang pada akhir masa aktif paket dengan tarif sesuai lokasi Anda. Cek status/berhenti berlangganan melalui *363#. Info detail tarif lihat di Tsel.me/in', 15, '', 'false'),
('2015-12-07 00:55:01', '2015-11-12 07:03:56', '007400650072006E00650074', '3636', 'Default_No_Compression', '0500031E0303', '+6281100000', 1, 'ternet', 16, '', 'false'),
('2015-12-07 00:55:02', '2015-11-12 07:06:07', '0031002F003200200041006E00640061002000740065006C006100680020006200650072006C0061006E006700670061006E0061006E0020004E0053005000200050007500730069006E00670020004B006500700061006C00610020004200650072006200690020002800350030003000290020002D0020005200440053002000740061007200690066002000520070002E0020003500300030002B002000500050004E002F0037002000680072002E002000500065007200700061006E006A0061006E00670061006E00200062006500720069006B00750074006E00790061002000310039002D00310031002D0032003000310035002000640067006E0020007400610072006900660066002000520070002000330030003000300020002B002000500050004E002F003700680072002E002000550074006B', '121209', 'Default_No_Compression', '', '+6281100000', -1, '1/2 Anda telah berlangganan NSP Pusing Kepala Berbi (500) - RDS tarif Rp. 500+ PPN/7 hr. Perpanjangan berikutnya 19-11-2015 dgn tariff Rp 3000 + PPN/7hr. Utk', 17, '', 'false'),
('2015-12-07 00:55:02', '2015-11-12 07:06:08', '0032002F0032002000620065007200680065006E00740069002C0020006B006500740069006B0020004F004600460020005200440053004400480020006B006900720069006D0020006B006500200031003200310032002E00430053003A003100330033002F003100380038', '121209', 'Default_No_Compression', '', '+6281100000', -1, '2/2 berhenti, ketik OFF RDSDH kirim ke 1212.CS:133/188', 18, '', 'false'),
('2015-12-07 00:55:02', '2015-11-27 01:14:23', '00500061006B0065007400200049006E007400650072006E006500740020004D00750072006100680020005300700065007300690061006C002C00200041006E006400610020006400610070006100740020006D0065006E00670061006B007400690066006B0061006E002000500061006B0065007400200049006E007400650072006E006500740020006B0068007500730075007300200032004700420020006800610072006700610020006D0075006C0061006900200034003900720062002000280068006100720067006100200073006500730075006100690020006C006F006B0061007300690029002000730065006700650072006100200061006B007400690066006B0061006E0020006400690020002A003900390039002A00390023002000530026004B0020004200650072006C0061006B0075', 'TELKOMSEL', 'Default_No_Compression', '', '+6281100000', -1, 'Paket Internet Murah Spesial, Anda dapat mengaktifkan Paket Internet khusus 2GB harga mulai 49rb (harga sesuai lokasi) segera aktifkan di *999*9# S&K Berlaku', 19, '', 'false'),
('2015-12-07 00:55:03', '2015-11-29 04:29:45', '00540075006E00670067007500200061007000610020006C006100670069003F00200049006E007400650072006E006500740061006E002000700061006B0065002000540065006C006B006F006D00730065006C00200046006C0061007300680020006B0075006F007400610020003200470042002F0033003000680072002C002000620069006B0069006E00200041006E0064006100200065006B0073006900730020006C00650062006900680020006C0061006D006100210020004D0075006C0061006900200052007000360035007200620020006400690020002A003900390039002A0034003700320023002E0020005400610072006900660026006C006F006B006100730069002000630065006B0020006400690020007400730065006C002E006D0065002F0046004C', 'TELKOMSEL', 'Default_No_Compression', '', '+6281100000', 1, 'Tunggu apa lagi? Internetan pake Telkomsel Flash kuota 2GB/30hr, bikin Anda eksis lebih lama! Mulai Rp65rb di *999*472#. Tarif&lokasi cek di tsel.me/FL', 20, '', 'false'),
('2015-12-07 00:57:16', '2015-12-07 00:57:12', '00460061006900730061006C00200065006D0061006E0067002000700072006F', '+6289602801925', 'Default_No_Compression', '', '+628964011092', -1, 'Faisal emang pro', 21, '', 'false'),
('2015-12-07 00:58:53', '2015-12-07 00:58:49', '004C007500700069002000670061006E00740065006E0067', '+6289602801925', 'Default_No_Compression', '', '+628964011092', -1, 'Lupi ganteng', 22, '', 'false'),
('2015-12-12 10:26:54', '2015-04-11 07:38:04', '004F006B0065006C0061006800200028007900290020002E002E0020004B0061006B0061006B002000700075006E002000740061006B00200064006100740061006E00670020002C002C', '+6289648062926', 'Default_No_Compression', '', '+628964011092', -1, 'Okelah (y) .. Kakak pun tak datang ,,', 23, '', 'false'),
('2015-12-12 10:26:54', '2015-04-10 10:12:29', '0042007500640061006B0020006C00610065006E0020006B0061006E0020006100640065002C00200061006B0075002000610064006500200073007500720070007200690073006500200062006100680020006200750061007400200061006E0061006D', '+6289693669923', 'Default_No_Compression', '', '+628964011092', -1, 'Budak laen kan ade, aku ade surprise bah buat anam', 24, '', 'false'),
('2015-12-12 10:26:54', '2015-04-11 07:38:07', '003A0044', '+6289648062926', 'Default_No_Compression', '', '+628964011092', -1, ':D', 25, '', 'false'),
('2015-12-12 10:26:54', '2015-04-11 07:49:10', '004B0069006E002C0020006800610072006900200069006E00690020006B0069007400650020006E006700650072006100790065006B0061006E00200075006C00740061006800200073006900610070006500320020006A0061006B003F', '+6289693555896', 'Default_No_Compression', '', '+628964011092', -1, 'Kin, hari ini kite ngerayekan ultah siape2 jak?', 26, '', 'false'),
('2015-12-12 10:26:55', '2015-04-11 07:50:14', '004F006B0065002C00200061006B0020006200610077006100200063006500770065006B00200062006F006C00650068002000790061006B003F', '+6289693555896', 'Default_No_Compression', '', '+628964011092', -1, 'Oke, ak bawa cewek boleh yak?', 27, '', 'false'),
('2015-12-12 10:26:55', '2015-04-11 07:52:08', '005700740066', '+6289693555896', 'Default_No_Compression', '', '+628964011092', -1, 'Wtf', 28, '', 'false'),
('2015-12-12 10:26:55', '2015-04-11 08:33:11', '004B006C00200061006E0064006100200062007300200069006E007300740061006C00200064006900720075006D0061006800200073006F0072006500200069006E00690020002C00200062006F006C006500680020006A0067', '+6289683701271', 'Default_No_Compression', '', '+628964011092', -1, 'Kl anda bs instal dirumah sore ini , boleh jg', 29, '', 'false'),
('2015-12-12 10:26:55', '2015-04-09 03:04:35', '00550064006100680020006E00690020006B006C0075006100720020006400610068002E', '+6289669190001', 'Default_No_Compression', '', '+628964011092', -1, 'Udah ni kluar dah.', 30, '', 'false'),
('2015-12-12 10:26:56', '2015-04-08 09:49:36', '004B00610075002000730069006E0065006B0020006C00650070006100730020006D006100670072006500620020006B00200073006500620065006C006F006D0020006D00610067007200650062003F', '+6289693214771', 'Default_No_Compression', '', '+628964011092', -1, 'Kau sinek lepas magreb k sebelom magreb?', 31, '', 'false'),
('2015-12-12 10:26:56', '2015-04-09 03:18:04', '00590075006E006100200075006400680020006B006C0075006100720020006400610068', '+6289669190001', 'Default_No_Compression', '', '+628964011092', -1, 'Yuna udh kluar dah', 32, '', 'false'),
('2015-12-12 10:26:56', '2015-04-17 08:24:32', '0069006E0076006900740065002000700069006E0020006200610072007500200061006B0075002000350035003200320039003500390035', '+6289693816147', 'Default_No_Compression', '', '+628964011092', -1, 'invite pin baru aku 55229595', 33, '', 'false'),
('2015-12-12 10:26:56', '2015-04-11 10:03:11', '004B0069006E00200074006C0075006E006700200074006100670065006800200062007500640061006B00320020006E00610061', '+6285750213569', 'Default_No_Compression', '', '+62816124', -1, 'Kin tlung tageh budak2 naa', 34, '', 'false'),
('2015-12-12 10:26:57', '2015-04-11 09:14:47', '00550064006800200061006400200062007500640061006B0020006B00650020006B0069006E00200064006900200072006D00680020007400720069006B003F', '+6289693555896', 'Default_No_Compression', '', '+628964011092', -1, 'Udh ad budak ke kin di rmh trik?', 35, '', 'false'),
('2015-12-12 10:26:57', '2015-04-11 10:17:41', '004B0061007500200064006D0061006E0065', '+6289693680745', 'Default_No_Compression', '', '+628964011092', -1, 'Kau dmane', 36, '', 'false'),
('2015-12-12 10:26:57', '2015-04-11 13:13:41', '004E0061006B0020006D0061006E00650020006B00610075002000630061006B003F00200020', '+6285822333904', 'Default_No_Compression', '', '+62816124', -1, 'Nak mane kau cak?  ', 37, '', 'false'),
('2015-12-12 10:26:57', '2015-04-18 01:08:32', '0055006400610068', '+6289693555896', 'Default_No_Compression', '', '+628964011092', -1, 'Udah', 38, '', 'false'),
('2015-12-12 10:26:58', '2015-04-18 01:16:02', '0042006100720075', '+6289693555896', 'Default_No_Compression', '', '+6289644000001', -1, 'Baru', 39, '', 'false'),
('2015-12-12 10:26:58', '2015-04-17 08:48:26', '004F006800200069007900650020002E002E', '+6289648062926', 'Default_No_Compression', '', '+628964011092', -1, 'Oh iye ..', 40, '', 'false'),
('2015-12-12 10:26:58', '2015-04-10 06:22:47', '00500075006E007900610020006E006F00200064006100750073003F', '+6289693648395', 'Default_No_Compression', '', '+628964011092', -1, 'Punya no daus?', 41, '', 'false'),
('2015-12-12 10:26:58', '2015-04-10 06:24:09', '004D0061006B006100730069002000730061006C006900680069006E', '+6289693648395', 'Default_No_Compression', '', '+628964011092', -1, 'Makasi salihin', 42, '', 'false'),
('2015-12-12 10:26:59', '2015-04-10 07:49:47', '004D0061006E00650020006B00770020006B0069006E003F', '+6285750213569', 'Default_No_Compression', '', '+62816124', -1, 'Mane kw kin?', 43, '', 'false'),
('2015-12-12 10:26:59', '2015-04-10 07:51:29', '004E0061006B0020006B0020006D0061006E006500200073006900200061006E0061006D002000680069006E0020003F0020004100750073007400720061006C00690020006B0020003F', '+6289693214771', 'Default_No_Compression', '', '+628964011092', -1, 'Nak k mane si anam hin ? Australi k ?', 44, '', 'false'),
('2015-12-12 10:26:59', '2015-04-10 07:52:39', '004200650073006F006B0020006B0065003F', '+6289693555896', 'Default_No_Compression', '', '+628964011092', -1, 'Besok ke?', 45, '', 'false'),
('2015-12-12 10:26:59', '2015-04-10 07:53:53', '006D0061006E0065002000620069007300650020006A0061006D00200034002000620072006F0020006A0061006D002000350020006C006100680020002E002E', '+6289693471277', 'Default_No_Compression', '', '+6289644000001', -1, 'mane bise jam 4 bro jam 5 lah ..', 46, '', 'false'),
('2015-12-12 10:27:00', '2015-04-17 09:13:46', '004900790065002C002C', '+6289648062926', 'Default_No_Compression', '', '+628964011092', -1, 'Iye,,', 47, '', 'false'),
('2015-12-12 10:27:00', '2015-04-17 09:15:09', '0049007900650020003A0029', '+6289648062926', 'Default_No_Compression', '', '+628964011092', -1, 'Iye :)', 48, '', 'false'),
('2015-12-12 10:27:00', '2015-04-10 07:54:06', '004D0061006F006F006B0020006B006D0061006E00650020006400690065003F00200042006E006100720020006E0064006B003F', '+6289693680745', 'Default_No_Compression', '', '+628964011092', -1, 'Maook kmane die? Bnar ndk?', 49, '', 'false'),
('2015-12-12 10:27:00', '2015-04-18 02:04:07', '0041006B0075006E002000770069006600690020006B000A00200020000A00200020005B00410062006400750072005300480041004800410042005D', '+6289630778919', 'Default_No_Compression', '', '+628964011092', -1, 'Akun wifi k\n  \n  [AbdurSHAHAB]', 50, '', 'false'),
('2015-12-12 10:27:01', '2015-04-18 03:05:43', '0033003200300031003400310036003000320030000A004E007500720075006C0069006B', '+6285750657851', 'Default_No_Compression', '', '+62816124', -1, '3201416020\nNurulik', 51, '', 'false'),
('2015-12-12 10:27:01', '2015-04-18 02:05:54', '00470061006B002000610064006100200061006B0075002000770061000A005E007E005E000A', '+6289509293990', 'Default_No_Compression', '', '+628964011092', -1, 'Gak ada aku wa\n^~^\n', 52, '', 'false'),
('2015-12-12 10:27:01', '2015-04-18 02:06:00', '00330032003000310034003100360030003400320020000A004B0041006600610062006900720061', '+6289693463158', 'Default_No_Compression', '', '+628964011092', -1, '3201416042 \nKAfabira', 53, '', 'false'),
('2015-12-12 10:27:01', '2015-04-18 03:09:47', '003300320030003100340031003600300033003900200072006D0061006E00350033003800340034003400390032', '+6285750848648', 'Default_No_Compression', '', '+62816124', -1, '3201416039 rman53844492', 54, '', 'false'),
('2015-12-12 10:27:02', '2015-04-18 02:11:46', '004F006B00650020006C00610068002E002E002000200033003200300031003400310036003000340035000A006B00610064006100720069007900610068000A004A0067006E00200067006E007400690020007900650020003A0029000A000A00200020000A00200020005B00410062006400750072005300480041004800410042005D', '+6289630778919', 'Default_No_Compression', '', '+6289644000001', -1, 'Oke lah..  3201416045\nkadariyah\nJgn gnti ye :)\n\n  \n  [AbdurSHAHAB]', 55, '', 'false'),
('2015-12-12 10:27:02', '2015-04-18 02:04:10', '004B006100750020006400690070006F006C006E006500700020006B0065002000680069006E003F', '+6282254507798', 'Default_No_Compression', '', '+6281100000', -1, 'Kau dipolnep ke hin?', 56, '', 'false'),
('2015-12-12 10:27:02', '2015-04-18 02:19:48', '004A0061006D0020006200720070003F', '+6282254507798', 'Default_No_Compression', '', '+6281100000', -1, 'Jam brp?', 57, '', 'false'),
('2015-12-12 10:27:02', '2015-04-10 07:54:07', '0061006E0061006D0020006D0061006F0020006B0065006D0061006E006500200065006D0061006E00670020006E007900650020002E002E', '+6289693471277', 'Default_No_Compression', '', '+628964011092', -1, 'anam mao kemane emang nye ..', 58, '', 'false'),
('2015-12-12 10:27:03', '2015-04-18 03:25:41', '00550064006800200064007000740020006B006100200061006B0075006E00200065002000680069006E003F', '+6285750510881', 'Default_No_Compression', '', '+62816124', -1, 'Udh dpt ka akun e hin?', 59, '', 'false'),
('2015-12-12 10:27:03', '2015-04-18 03:27:58', '0050006B006500200061006B0075006E00200061006B0075002000790061006B0020002C0020000A0033003200300031003400310036003000350039000A005000610073007300200072006F0079003100300030003900390036', '+6285750510881', 'Default_No_Compression', '', '+62816124', -1, 'Pke akun aku yak , \n3201416059\nPass roy100996', 60, '', 'false'),
('2015-12-12 10:27:03', '2015-04-18 02:57:32', '004D006E00740020006E006F002000700061006B00200064006500640065', '+628996908945', 'Default_No_Compression', '', '+628964011092', -1, 'Mnt no pak dede', 61, '', 'false'),
('2015-12-12 10:27:03', '2015-04-18 10:10:56', '00440069002000720075006D00610068002C0020006B006E0070002000680069006E0020003F', '+628983722271', 'Default_No_Compression', '', '+628964011092', -1, 'Di rumah, knp hin ?', 62, '', 'false'),
('2015-12-12 10:27:04', '2015-04-17 11:58:52', '004C007400680061006E', '+6282254507798', 'Default_No_Compression', '', '+6281100000', -1, 'Lthan', 63, '', 'false'),
('2015-12-12 10:27:04', '2015-04-10 08:03:02', '00540069007400650070002000730061006C0061006D0020006A0061006B00200062007200610079002C002000740061006B0020006200690073006500200064006100740061006E006700200061006B0075', '+6289693669923', 'Default_No_Compression', '', '+628964011092', -1, 'Titep salam jak bray, tak bise datang aku', 64, '', 'false'),
('2015-12-12 10:27:04', '2015-04-18 10:12:00', '004D0061006E00650020006B0075006C0069006100680020006800610072006900200073006200740075002000680069006E002C002000630075006D0061006E0020006E00670061006E007400720020006B006E00200075006E00640061006E00670061006E002000790061006B002000740061006400690020002E', '+628983722271', 'Default_No_Compression', '', '+628964011092', -1, 'Mane kuliah hari sbtu hin, cuman ngantr kn undangan yak tadi .', 65, '', 'false'),
('2015-12-12 10:27:04', '2015-04-18 10:14:40', '0048006100680061006800610020006500660065006B00200069006E007300740061006C0020006C006100700074006F007000200062006E0079006B00200062006E0079006B002C0020006B0065006D0061006B0061006E0020006C006100700074006F007000200065006E00650072006700690020006B00610075002000680069006E00200068006100680061000A006B00610075002000640020006D0061006E0065002000680069006E0020003F', '+628983722271', 'Default_No_Compression', '', '+628964011092', -1, 'Hahaha efek instal laptop bnyk bnyk, kemakan laptop energi kau hin haha\nkau d mane hin ?', 66, '', 'false'),
('2015-12-12 10:27:05', '2015-04-18 10:17:34', '0048006100680061006800610020006D0061006B00200063007000610074002000670061006B0020006B006100750020006B0065002000730061006E0061006B002000680069006E0020003A0044000A006D006100730068002000680075006A0061006E0020002000680069006E', '+628983722271', 'Default_No_Compression', '', '+628964011092', -1, 'Hahaha mak cpat gak kau ke sanak hin :D\nmash hujan  hin', 67, '', 'false'),
('2015-12-12 10:27:05', '2015-04-18 10:25:30', '004100640020006200650072006C00690061006E0020003A0044000A00520061006D006100690020006B0065002000620064006B002000680069006E0020003F', '+628983722271', 'Default_No_Compression', '', '+628964011092', -1, 'Ad berlian :D\nRamai ke bdk hin ?', 68, '', 'false'),
('2015-12-12 10:27:05', '2015-04-10 10:16:26', '00410068006100680061002000740061006B00200070006100700065006C00610068', '+6289693669923', 'Default_No_Compression', '', '+6289644000001', -1, 'Ahaha tak papelah', 69, '', 'false'),
('2015-12-12 10:27:05', '2015-04-09 03:50:24', '00590075006E006100200070006C00670020007900610068002E', '+6289669190001', 'Default_No_Compression', '', '+628964011092', -1, 'Yuna plg yah.', 70, '', 'false'),
('2015-12-12 10:27:06', '2015-04-10 09:10:09', '00420075006400610071002000740061006B0020006100640065002000720075006D0061006800200074007200690020006B00650020006800610072006900200069006E0069002000680069006E', '+6285750848648', 'Default_No_Compression', '', '+62816124', -1, 'Budaq tak ade rumah tri ke hari ini hin', 71, '', 'false'),
('2015-12-12 10:27:06', '2015-04-10 10:13:50', '00530075006B00650020006E0061006B0020006200750061006C', '+6285750848648', 'Default_No_Compression', '', '+62816124', -1, 'Suke nak bual', 72, '', 'false'),
('2015-12-12 10:27:41', '2015-12-12 09:19:59', '004F00740077', '+6289693214771', 'Default_No_Compression', '', '+628964011092', -1, 'Otw', 73, '', 'false'),
('2015-12-12 10:27:47', '2015-12-12 10:25:04', '004B0070006E0020006B0061007500200073006D00730020006E0069', '+6289616657557', 'Default_No_Compression', '', '+628964011092', -1, 'Kpn kau sms ni', 74, '', 'false'),
('2015-12-12 10:30:07', '2015-12-12 11:29:59', '00440049002000420041004E00440049004E00470020004D004F004E005900450054', '+6285750848648', 'Default_No_Compression', '', '+62816124', -1, 'DI BANDING MONYET', 75, '', 'false'),
('2015-12-13 13:05:29', '2015-12-13 13:05:24', '00500065006C0061006E006700670061006E0020005900740068002C002000700065006E0067006900720069006D0061006E00200053004D00530020006B00650020006E006F002000300038003900360039003300320031003400370037003100200067006100670061006C0020006B0072006E002000700075006C00730061002F006C0069006D0069007400200074006900640061006B0020006D0065006E00630075006B007500700069002E0020004400700074006B0061006E00200069006E0066006F0072006D006100730069002000730065007000750074006100720020006B006100720074007500200054007200690020006400690020002A0031003200330023002000610074006100750020007600690061002000610070006C0069006B006100730069002000420049004D0041005400520049', '3', 'Default_No_Compression', '', '+628964011098', -1, 'Pelanggan Yth, pengiriman SMS ke no 089693214771 gagal krn pulsa/limit tidak mencukupi. Dptkan informasi seputar kartu Tri di *123# atau via aplikasi BIMATRI', 76, '', 'false'),
('2015-12-13 13:05:37', '2015-12-13 13:05:37', '00500065006C0061006E006700670061006E0020005900740068002C002000700065006E0067006900720069006D0061006E00200053004D00530020006B00650020006E006F002000300038003900360039003300320031003400370037003100200067006100670061006C0020006B0072006E002000700075006C00730061002F006C0069006D0069007400200074006900640061006B0020006D0065006E00630075006B007500700069002E0020004400700074006B0061006E00200069006E0066006F0072006D006100730069002000730065007000750074006100720020006B006100720074007500200054007200690020006400690020002A0031003200330023002000610074006100750020007600690061002000610070006C0069006B006100730069002000420049004D0041005400520049', '3', 'Default_No_Compression', '', '+628964011098', -1, 'Pelanggan Yth, pengiriman SMS ke no 089693214771 gagal krn pulsa/limit tidak mencukupi. Dptkan informasi seputar kartu Tri di *123# atau via aplikasi BIMATRI', 77, '', 'false'),
('2015-12-13 13:07:09', '2015-12-13 13:06:49', '004900440020005400720061006E00730061006B0073006900200031003200310033003200300030003600340038003100390034003300370031003300300032002E0020004E006F006D006F007200200041006E00640061002000740065006C00610068002000640069002D0074006F007000200075007000200035002C00300030003000200070006100640061002000310033002D00310032002D0032003000310035002000320030003A00300036003A00340038', 'V-Tri', 'Default_No_Compression', '', '+628964011091', -1, 'ID Transaksi 1213200648194371302. Nomor Anda telah di-top up 5,000 pada 13-12-2015 20:06:48', 78, '', 'false'),
('2015-12-13 13:07:18', '2015-12-13 13:06:50', '00530065006C0061006D00610074002C00200041006E00640061002000640070007400200042004F004E0055005300200042004900430041005200410020003200340020006A0061006D0020006B0065002000730065006D007500610020005400720069002000790061006E00670020006200650072006C0061006B00750020006400690020006B006F00740061002000740065007200740065006E00740075002E002000490073006900200075006C0061006E0067002000740065007200750073002000750074006B0020006E0069006B006D00610074006900200062006F006E00750073006E00790061002E0020005300790061007200610074002000260020004B006500740065006E007400750061006E0020006200650072006C0061006B0075002E00200049006E0066006F0020003100320033', '+3', 'Default_No_Compression', '', '+628964011091', -1, 'Selamat, Anda dpt BONUS BICARA 24 jam ke semua Tri yang berlaku di kota tertentu. Isi ulang terus utk nikmati bonusnya. Syarat & Ketentuan berlaku. Info 123', 79, '', 'false'),
('2015-12-13 13:07:25', '2015-12-13 13:06:50', '00500065006E00670069007300690061006E0020005200700035003000300030002000730075006B007300650073002E0020004D00610073006100200061006B00740069006600200073002F0064002000300037002F00300037002F0032003000310036002E00200041006B0068006900720020006D006100730061002000740065006E006700670061006E0067002000300035002F00300039002F0032003000310036002E004D006100750020006B0075006F00740061002000680065006D006100740020003300300030004D004200280052007000310030007200620029003F006B006500740069006B0020004D004100550028007300700061007300690029003300300030004D00420020006B006900720069006D0020006B00650020003200330034002F002A003100320033002A0033002A003300230020', '+3', 'Default_No_Compression', '', '+628964011091', -1, 'Pengisian Rp5000 sukses. Masa aktif s/d 07/07/2016. Akhir masa tenggang 05/09/2016.Mau kuota hemat 300MB(Rp10rb)?ketik MAU(spasi)300MB kirim ke 234/*123*3*3# ', 80, '', 'false'),
('2015-12-13 13:17:08', '2015-12-13 13:17:02', '005400650073', '+6289693214771', 'Default_No_Compression', '', '+628964011092', -1, 'Tes', 81, '', 'false'),
('2015-12-13 14:26:04', '2015-12-13 14:26:00', '00540065007300200061006B006800690072', '+6289693214771', 'Default_No_Compression', '', '+628964011092', -1, 'Tes akhir', 82, '', 'false'),
('2016-01-03 06:45:58', '2016-01-01 00:16:34', '0050006B007400200048006F00740052006F006400200031002E003500470042002C0020003300300048006100720069002C002000520070003500300072006200200041006E0064006100200061006B0061006E00200062006500720061006B0068006900720020006A0061006D0020002000320033003A00350039002E002000500061007300740069006B0061006E002000700075006C00730061002000630075006B0075007000200075006E00740075006B002000700065007200700061006E006A0061006E00670061006E002E00200049006E0066006F0020003800310037', 'XL-Axiata', 'Default_No_Compression', '', '+628184422876', -1, 'Pkt HotRod 1.5GB, 30Hari, Rp50rb Anda akan berakhir jam  23:59. Pastikan pulsa cukup untuk perpanjangan. Info 817', 83, '', 'false'),
('2016-01-03 06:45:58', '2016-01-01 21:56:52', '0050006B007400200048006F00740052006F006400200031002E003500470042002C0020003300300048006100720069002C002000520070003500300072006200200041006E00640061002000740065007200680065006E007400690020006B0072006E002000700075006C0073006100200074006900640061006B002000630075006B0075007000200075006E00740075006B002000700065007200700061006E006A0061006E00670061006E002E002000410079006F0020006900730069002000700075006C0073006100200064006900200058004C002000430065006E007400650072002C002000410054004D002E00200049006E0066006F0020003800310037', 'XL-Axiata', 'Default_No_Compression', '', '+628184422876', -1, 'Pkt HotRod 1.5GB, 30Hari, Rp50rb Anda terhenti krn pulsa tidak cukup untuk perpanjangan. Ayo isi pulsa di XL Center, ATM. Info 817', 84, '', 'false'),
('2016-01-19 13:12:59', '2016-01-19 13:12:58', '005400650073002000700065006B', '+6289696292474', 'Default_No_Compression', '', '+628964011092', -1, 'Tes pek', 85, '', 'false'),
('2016-01-24 08:51:48', '2016-01-08 03:14:43', '00410064006B0020006D0075006E007400610068006B0061006E0020006100700065002000740075003F002000500065007200750074002000610064006B0020006E00670070003F', '+6289676764779', 'Default_No_Compression', '', '+628964011092', -1, 'Adk muntahkan ape tu? Perut adk ngp?', 105, '', 'false'),
('2016-01-24 08:51:49', '2016-01-08 03:18:08', '00410064006B0020006D0075006E007400610068006B0061006E0020006100700065002000740075003F002000500065007200750074002000610064006B0020006E00670070003F', '+6289676764779', 'Default_No_Compression', '', '+628964011092', -1, 'Adk muntahkan ape tu? Perut adk ngp?', 106, '', 'false'),
('2016-01-24 08:51:49', '2016-01-08 03:19:00', '004900790065006C0068002000640065006B002C002000610064006B00200070006500720069006B00730065006C0068002000610064006B0020006D0075006E007400610062006500720020006B006C0069002000740075', '+6289676764779', 'Default_No_Compression', '', '+628964011092', -1, 'Iyelh dek, adk perikselh adk muntaber kli tu', 107, '', 'false'),
('2016-01-24 08:51:49', '2016-01-08 03:22:26', '004900790065006C0068002000640065006B002C002000610064006B00200069007300740072006800610074006C00680020007400750020006200770061002000740064007500720020006A0061006B002000640065006B', '+6289676764779', 'Default_No_Compression', '', '+628964011092', -1, 'Iyelh dek, adk istrhatlh tu bwa tdur jak dek', 108, '', 'false'),
('2016-01-26 15:01:23', '2016-01-26 15:01:20', '00490073006900200075006C0061006E006700200052007000310030003000300030002E003000200062006500720068006100730069006C002E0020004B006F006400650020007400720061006E00730061006B00730069002000390039003300330030003100320036003600380030003700390032002E002000540061006D0062006100680020006B0075006F00740061006D0075002100200049006E007400650072006E00650074002000320047004200200063006D006E0020005200700036003000720062002F0033003000680072002E002000420065006C00690020006400690020002A003100320033002A0033002A00310023', 'XL-Axiata', 'Default_No_Compression', '', '+628184422876', -1, 'Isi ulang Rp10000.0 berhasil. Kode transaksi 99330126680792. Tambah kuotamu! Internet 2GB cmn Rp60rb/30hr. Beli di *123*3*1#', 120, '', 'false'),
('2016-01-24 08:51:50', '2016-01-08 03:26:31', '0049007900610020006100640065006B002000690073007400720068006100740020006C0068002000610064006B002000740075002000790065002C002000700069006E00740075006E007900200073006500640061006C002000700061006B006500200061007000650020006B0065002000620069006100720020006E0064006B00200074006500620075006B0061006B002000740075', '+6289676764779', 'Default_No_Compression', '', '+628964011092', -1, 'Iya adek istrhat lh adk tu ye, pintuny sedal pake ape ke biar ndk tebukak tu', 110, '', 'false'),
('2016-01-24 08:51:50', '2016-01-08 10:56:05', '003100310020006A0074002E002E', '+6285252856339', 'Default_No_Compression', '', '+6281100000', -1, '11 jt..', 111, '', 'false'),
('2016-01-24 08:51:50', '2016-01-08 11:26:32', '00790067002000640069006D006E002000790061', '+6282254698688', 'Default_No_Compression', '', '+6281100000', -1, 'yg dimn ya', 112, '', 'false'),
('2016-01-24 08:51:50', '2016-01-08 11:28:08', '003100310020006A00740020006200730020006E00650067006F', '+6282254698688', 'Default_No_Compression', '', '+6281100000', -1, '11 jt bs nego', 113, '', 'false'),
('2016-01-24 08:51:51', '2016-01-08 13:53:53', '004900790065002000640065006B002C00200061006200670020006400680020006400690020006B006F0073007400200062007500640061006B0020006E0069', '+6289676764779', 'Default_No_Compression', '', '+628964011092', -1, 'Iye dek, abg dh di kost budak ni', 116, '', 'false'),
('2016-01-25 09:05:53', '2016-01-25 09:05:50', '004A006D', '+6289694184564', 'Default_No_Compression', '', '+628964011092', -1, 'Jm', 118, '', 'false'),
('2016-01-27 03:22:33', '2015-05-28 12:22:44', '004900440020005400720061006E00730061006B0073006900200030003500320038003100390032003200340032003100350033003500340036003300300032002E0020004E006F006D006F007200200041006E00640061002000740065006C00610068002000640069002D0074006F007000200075007000200035002C00300030003000200070006100640061002000320038002D00300035002D0032003000310035002000310039003A00320032003A00340032', 'V-Tri', 'Default_No_Compression', '', '+628964011091', -1, 'ID Transaksi 0528192242153546302. Nomor Anda telah di-top up 5,000 pada 28-05-2015 19:22:42', 121, '', 'false'),
('2016-01-27 03:22:34', '2015-05-28 12:22:45', '00500065006E00670069007300690061006E0020005200700035003000300030002000730075006B007300650073002E0020004D00610073006100200061006B0074006900660020006200650072006C0061006B007500200073002F0064002000310032002F00300034002F0032003000310036002E00200041006B0068006900720020006D006100730061002000740065006E006700670061006E0067002000310031002F00300036002F0032003000310036002E00200041006C00770061007900730020004F006E002E00420065006200610073002000420042004D002D0061006E0020003100740068006E0020006400690041006E00640072006F00690064002C004900700068006F006E0065002E002000540065006B0061006E002A003100320033002A0033002A00310023', '+3', 'Default_No_Compression', '', '+628964011091', -1, 'Pengisian Rp5000 sukses. Masa aktif berlaku s/d 12/04/2016. Akhir masa tenggang 11/06/2016. Always On.Bebas BBM-an 1thn diAndroid,Iphone. Tekan*123*3*1#', 122, '', 'false'),
('2016-01-27 03:22:34', '2015-06-05 15:07:07', '0054006B0072006D0020006B0020006E00640061006B00200068006100680061', '+628982168343', 'Default_No_Compression', '', '+628964011098', -1, 'Tkrm k ndak haha', 123, '', 'false'),
('2016-01-27 03:26:26', '2016-01-27 04:26:20', '0023004800410052004900530045004E0049004E', '+6285654579953', 'Default_No_Compression', '', '+62816124', -1, '#HARISENIN', 124, '', 'false'),
('2017-07-17 03:28:17', '2017-07-17 03:26:49', '0054006500730020006B006900720069006D00200053004D005300200064006100720069002000640061007400610062006100730065', '+6289693838709', 'Default_No_Compression', '', '+628964011092', -1, 'Tes kirim SMS dari database', 126, '', 'false'),
('2017-07-17 04:23:47', '2017-07-17 04:22:20', '0054006500730020006B006900720069006D00200053004D005300200064006100720069002000640061007400610062006100730065', '+6289693838709', 'Default_No_Compression', '', '+628964011092', -1, 'Tes kirim SMS dari database', 127, '', 'false'),
('2017-07-17 05:05:40', '2017-07-17 05:04:10', '004B00680075007300750073002000750074006B0020006B0061006D007500210020004B0075006F007400610020003200300030004D0042002000680061007200670061006E007900610020006B0065006D00620061006C00690020006D0065006E006A0061006400690020005200700032002C00300030003000200028006800610072006700610020006E006F0072006D0061006C0020005200700033002C00300030003000290021002000420061006C0061007300200053004D005300200069006E00690020006B006500740069006B0020004D00410055002000750074006B0020006D0065006D00620065006C0069002E002000500065006E00610077006100720061006E002000680061006E0079006100200073002E00640020003300310020004A0075006C00690020003100370020004E0031003800300035', '111', 'Default_No_Compression', '', '+628964011092', -1, 'Khusus utk kamu! Kuota 200MB harganya kembali menjadi Rp2,000 (harga normal Rp3,000)! Balas SMS ini ketik MAU utk membeli. Penawaran hanya s.d 31 Juli 17 N1805', 128, '', 'false');

--
-- Triggers `inbox`
--
DELIMITER $$
CREATE TRIGGER `inbox_timestamp` BEFORE INSERT ON `inbox` FOR EACH ROW BEGIN
    IF NEW.ReceivingDateTime = '0000-00-00 00:00:00' THEN
        SET NEW.ReceivingDateTime = CURRENT_TIMESTAMP();
    END IF;
END
$$
DELIMITER ;

-- --------------------------------------------------------

--
-- Table structure for table `log_stok_buku`
--

CREATE TABLE `log_stok_buku` (
  `log_id` int(50) NOT NULL,
  `kd_buku` varchar(50) NOT NULL,
  `stok_lama` int(25) NOT NULL,
  `stok_baru` int(25) NOT NULL,
  `tgl` date NOT NULL,
  `keterangan` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `manager`
--

CREATE TABLE `manager` (
  `id_manager` varchar(20) NOT NULL,
  `nama_manager` varchar(25) NOT NULL,
  `alamat_manager` varchar(25) NOT NULL,
  `no_telp_manager` varchar(25) NOT NULL,
  `wilayah_manager` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `manager`
--

INSERT INTO `manager` (`id_manager`, `nama_manager`, `alamat_manager`, `no_telp_manager`, `wilayah_manager`) VALUES
('m01', 'Agus', 'Jl. Putri Candramidi', '089693838710', 'Pontianak Kota'),
('m02', 'Muji', 'Jl. A.Yani', '089693838711', 'Pontianak Selatan'),
('m03', 'Budi', 'Jl. Alianyang', '089693838712', 'Pontianak Timur');

-- --------------------------------------------------------

--
-- Table structure for table `outbox`
--

CREATE TABLE `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',
  `SendBefore` time NOT NULL DEFAULT '23:59:59',
  `SendAfter` time NOT NULL DEFAULT '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` text NOT NULL,
  `ID` int(10) UNSIGNED NOT NULL,
  `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
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Triggers `outbox`
--
DELIMITER $$
CREATE TRIGGER `outbox_timestamp` BEFORE INSERT ON `outbox` FOR EACH ROW BEGIN
    IF NEW.InsertIntoDB = '0000-00-00 00:00:00' THEN
        SET NEW.InsertIntoDB = CURRENT_TIMESTAMP();
    END IF;
    IF NEW.SendingDateTime = '0000-00-00 00:00:00' THEN
        SET NEW.SendingDateTime = CURRENT_TIMESTAMP();
    END IF;
    IF NEW.SendingTimeOut = '0000-00-00 00:00:00' THEN
        SET NEW.SendingTimeOut = CURRENT_TIMESTAMP();
    END IF;
END
$$
DELIMITER ;

-- --------------------------------------------------------

--
-- Table structure for table `outbox_multipart`
--

CREATE TABLE `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` text,
  `ID` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `SequencePosition` int(11) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `pbk`
--

CREATE TABLE `pbk` (
  `ID` int(11) NOT NULL,
  `GroupID` varchar(10) NOT NULL,
  `Name` varchar(20) NOT NULL,
  `Number` varchar(15) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `pbk_groups`
--

CREATE TABLE `pbk_groups` (
  `Name` varchar(10) NOT NULL,
  `ID` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `pelanggan`
--

CREATE TABLE `pelanggan` (
  `kd_pelanggan` varchar(25) NOT NULL,
  `no_sales` varchar(20) NOT NULL,
  `nama_pelanggan` varchar(20) NOT NULL,
  `alamat_pelanggan` varchar(20) NOT NULL,
  `no_telp_pelanggan` varchar(20) NOT NULL,
  `limits` int(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pelanggan`
--

INSERT INTO `pelanggan` (`kd_pelanggan`, `no_sales`, `nama_pelanggan`, `alamat_pelanggan`, `no_telp_pelanggan`, `limits`) VALUES
('a01-00002', 'a01', 'MAN2', 'JL. A.YANI NO 9', '0561764907', 5000000),
('a01-00003', 'a01', 'SD MUHAMMADIYAH 2', 'JL. A.YANI', '056178116', 3000000),
('a03-00001', 'a03', 'MTS NEGERI 1', 'JL ALIANYANG', '0891212131', 1000000);

-- --------------------------------------------------------

--
-- Table structure for table `pembayaran`
--

CREATE TABLE `pembayaran` (
  `no_kwitansi` varchar(25) NOT NULL,
  `no_jual` varchar(25) NOT NULL,
  `no_plgn` varchar(25) NOT NULL,
  `tgl` date NOT NULL,
  `jumlah_bayar` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pembayaran`
--

INSERT INTO `pembayaran` (`no_kwitansi`, `no_jual`, `no_plgn`, `tgl`, `jumlah_bayar`) VALUES
('KW-16081701', 'FJ17-001', 'a01-00003', '2017-08-16', 200);

--
-- Triggers `pembayaran`
--
DELIMITER $$
CREATE TRIGGER `updateSaldoandPiutang` AFTER INSERT ON `pembayaran` FOR EACH ROW BEGIN
 UPDATE piutang SET 
 saldo=saldo-new.jumlah_bayar
 where kode_fjual=new.no_jual;
 UPDATE saldo_plgn SET 
 saldo=saldo-new.jumlah_bayar,
 id_pelanggan=new.no_plgn
 where id_pelanggan=new.no_plgn;
 END
$$
DELIMITER ;

-- --------------------------------------------------------

--
-- Table structure for table `phones`
--

CREATE TABLE `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 '-1',
  `Signal` int(11) NOT NULL DEFAULT '-1',
  `Sent` int(11) NOT NULL DEFAULT '0',
  `Received` int(11) NOT NULL DEFAULT '0'
) 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
('', '2016-01-27 03:33:13', '2016-01-27 03:22:33', '2016-01-27 03:33:23', 'yes', 'yes', '867895010158827', 'Gammu 1.33.0, Windows Server 2007, GCC 4.7, MinGW 3.11', 0, 81, 1, 5),
('', '2017-07-23 15:50:56', '2017-07-23 14:02:15', '2017-07-23 15:51:06', 'yes', 'yes', '863448018471349', 'Gammu 1.33.0, Windows Server 2007 SP1, GCC 4.7, MinGW 3.11', 0, 33, 0, 0);

--
-- Triggers `phones`
--
DELIMITER $$
CREATE TRIGGER `phones_timestamp` BEFORE INSERT ON `phones` FOR EACH ROW BEGIN
    IF NEW.InsertIntoDB = '0000-00-00 00:00:00' THEN
        SET NEW.InsertIntoDB = CURRENT_TIMESTAMP();
    END IF;
    IF NEW.TimeOut = '0000-00-00 00:00:00' THEN
        SET NEW.TimeOut = CURRENT_TIMESTAMP();
    END IF;
END
$$
DELIMITER ;

-- --------------------------------------------------------

--
-- Table structure for table `piutang`
--

CREATE TABLE `piutang` (
  `kode_fjual` varchar(25) NOT NULL,
  `kode_plgn` varchar(20) NOT NULL,
  `tgl` date NOT NULL,
  `saldo` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `piutang`
--

INSERT INTO `piutang` (`kode_fjual`, `kode_plgn`, `tgl`, `saldo`) VALUES
('FJ-17001', 'a01-00003', '2017-08-16', 286200);

--
-- Triggers `piutang`
--
DELIMITER $$
CREATE TRIGGER `insertSaldoPlgn` AFTER UPDATE ON `piutang` FOR EACH ROW BEGIN
 INSERT INTO saldo_plgn SET 
 id_pelanggan=new.kode_plgn,
 saldo=new.saldo
 ON DUPLICATE KEY UPDATE saldo=saldo+New.saldo;
 end
$$
DELIMITER ;

-- --------------------------------------------------------

--
-- Table structure for table `saldo_plgn`
--

CREATE TABLE `saldo_plgn` (
  `id_pelanggan` varchar(25) NOT NULL,
  `saldo` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `saldo_plgn`
--

INSERT INTO `saldo_plgn` (`id_pelanggan`, `saldo`) VALUES
('a01-00003', 286000);

-- --------------------------------------------------------

--
-- Table structure for table `sales`
--

CREATE TABLE `sales` (
  `kd_sales` varchar(20) NOT NULL,
  `kd_manager` varchar(20) NOT NULL,
  `nama_sales` varchar(20) NOT NULL,
  `alamat_sales` varchar(25) NOT NULL,
  `no_telp_sales` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sales`
--

INSERT INTO `sales` (`kd_sales`, `kd_manager`, `nama_sales`, `alamat_sales`, `no_telp_sales`) VALUES
('a01', 'm01', 'fahri', 'Jl. Perdamaian', '089623096560'),
('a02', 'm01', 'Rezat', 'Jl. Ilham', '089693838708'),
('a03', 'm02', 'Yudi', 'Jl. Danau Sentarum', '089693838701'),
('a04', 'm02', 'Meka', 'Jl. M.Yamin', '089693838702'),
('a05', 'm03', 'Nuzul', 'Jl. Dr. Wahidis', '089693838703'),
('a06', 'm02', 'Tiara R.A', 'Pontianak', '08976788');

-- --------------------------------------------------------

--
-- Table structure for table `sentitems`
--

CREATE TABLE `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` text 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
) 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
('2015-12-04 13:59:26', '2015-12-04 13:59:09', '2015-12-04 13:59:26', NULL, '005400650073002000670061006D006D0075', '089693214771', 'Default_No_Compression', '', '+6289644000001', -1, 'Tes gammu', 1, '', 1, 'SendingOKNoReport', -1, 25, 255, ''),
('2015-12-07 00:55:06', '2015-12-07 00:53:26', '2015-12-07 00:55:06', NULL, '00460061006900730061006C00200047004700570050', '089602801925', 'Default_No_Compression', '', '+6281100000', -1, 'Faisal GGWP', 2, '', 1, 'SendingOKNoReport', -1, 8, 255, ''),
('2015-12-07 00:55:41', '2015-12-07 00:55:24', '2015-12-07 00:55:41', NULL, '00460041004900530041004C0020003D002000500052004F00200053004600200041004E00440020004D004500450050004F', '089602801925', 'Default_No_Compression', '', '+6281100000', -1, 'FAISAL = PRO SF AND MEEPO', 3, '', 1, 'SendingOKNoReport', -1, 9, 255, ''),
('2015-12-07 01:27:45', '2015-12-07 01:26:50', '2015-12-07 01:27:45', NULL, '0053006100790061002000470065006E006400750074', '089693408160', 'Default_No_Compression', '', '+6281100000', -1, 'Saya Gendut', 4, '', 1, 'SendingError', -1, -1, 255, ''),
('2015-12-12 10:28:41', '2015-12-12 10:28:22', '2015-12-12 10:28:41', NULL, '00660061006900730061006C002000670061006E00740065006E0067002000650068', '085750848648', 'Default_No_Compression', '', '+6289644000001', -1, 'faisal ganteng eh', 5, '', 1, 'SendingOKNoReport', -1, 100, 255, ''),
('2015-12-13 13:05:27', '2015-12-13 13:04:49', '2015-12-13 13:05:27', NULL, '007400650073', '089693214771', 'Default_No_Compression', '', '+6289644000001', -1, 'tes', 6, '', 1, 'SendingError', -1, -1, 255, ''),
('2015-12-13 13:08:07', '2015-12-13 13:07:41', '2015-12-13 13:08:07', NULL, '0061007300640061007300640061007300640061', '089693214771', 'Default_No_Compression', '', '+6289644000001', -1, 'asdasdasda', 7, '', 1, 'SendingOKNoReport', -1, 3, 255, ''),
('2015-12-13 14:26:16', '2015-12-13 14:26:04', '2015-12-13 14:26:16', NULL, '00740065007300200061006B006800690072', '089693214771', 'Default_No_Compression', '', '+6289644000001', -1, 'tes akhir', 8, '', 1, 'SendingOKNoReport', -1, 4, 255, ''),
('2015-12-14 04:09:57', '2015-12-14 04:09:52', '2015-12-14 04:09:57', NULL, '0074006500730074006500730074006500740073', '089693214771', 'Default_No_Compression', '', '+6289644000001', -1, 'testestets', 9, '', 1, 'SendingOKNoReport', -1, 5, 255, ''),
('2015-12-14 04:49:45', '2015-12-14 04:49:07', '2015-12-14 04:49:45', NULL, '007400650073007400650073', '085750657851', 'Default_No_Compression', '', '+6289644000001', -1, 'testes', 10, '', 1, 'SendingOKNoReport', -1, 6, 255, ''),
('2016-01-19 13:11:17', '2016-01-17 04:59:07', '2016-01-19 13:11:17', NULL, '', '', 'Default_No_Compression', '', '+6289644000001', -1, '', 11, '', 1, 'SendingError', -1, -1, 255, ''),
('2016-01-19 13:12:53', '2016-01-19 13:12:25', '2016-01-19 13:12:53', NULL, '005400650073002000700065006B', '089693214771', 'Default_No_Compression', '', '+6289644000001', -1, 'Tes pek', 13, '', 1, 'SendingOKNoReport', -1, 161, 255, ''),
('2016-01-19 13:12:58', '2016-01-19 13:12:25', '2016-01-19 13:12:58', NULL, '005400650073002000700065006B', '089696292474', 'Default_No_Compression', '', '+6289644000001', -1, 'Tes pek', 12, '', 1, 'SendingOKNoReport', -1, 162, 255, ''),
('2016-01-22 14:53:30', '2016-01-22 14:53:00', '2016-01-22 14:53:30', NULL, '0074006500730020006C006F006B002000700065006B', '089693214771', 'Default_No_Compression', '', '+6289644000001', -1, 'tes lok pek', 14, '', 1, 'SendingOKNoReport', -1, 208, 255, ''),
('2016-01-22 15:18:34', '2016-01-22 15:18:30', '2016-01-22 15:18:34', NULL, '002B00620061006C006100730061006E002B', '+DBGrid1.Fields[1].V', 'Default_No_Compression', '', '+6289644000001', -1, '+balasan+', 15, '', 1, 'SendingError', -1, -1, 255, ''),
('2016-01-22 15:25:40', '2016-01-22 15:25:07', '2016-01-22 15:25:40', NULL, '006100750074006F0020007200650070006C007900200062006500720068006100730069006C', '089693214771', 'Default_No_Compression', '', '+6289644000001', -1, 'auto reply berhasil', 16, '', 1, 'SendingOKNoReport', -1, 209, 255, ''),
('2016-01-22 15:48:31', '2016-01-22 15:46:28', '2016-01-22 15:48:31', NULL, '00730068006F0077', '089696292474', 'Default_No_Compression', '', '+6289644000001', -1, 'show', 17, '', 1, 'SendingOKNoReport', -1, 211, 255, ''),
('2016-01-22 16:16:19', '2016-01-22 16:16:05', '2016-01-22 16:16:19', NULL, '004100750074006F007200650070006C00790020006200720068006100730069006C', '+6289693214771', 'Default_No_Compression', '', '+6289644000001', -1, 'Autoreply brhasil', 18, '', 1, 'SendingOKNoReport', -1, 225, 255, ''),
('2016-01-24 08:53:25', '2016-01-24 08:52:57', '2016-01-24 08:53:25', NULL, '00530069007300740065006D0020004F007000650072006100730069002000640061006E0020004D006100740065006D006100740069006B0061', '+6289693214771', 'Default_No_Compression', '', '+6289644000001', -1, 'Sistem Operasi dan Matematika', 19, '', 1, 'SendingOKNoReport', -1, 230, 255, ''),
('2016-01-25 09:06:50', '2016-01-25 09:06:27', '2016-01-25 09:06:50', NULL, '00530069007300740065006D0020004F007000650072006100730069002000640061006E0020004D006100740065006D006100740069006B0061', '+6289694184564', 'Default_No_Compression', '', '+6289644000001', -1, 'Sistem Operasi dan Matematika', 20, '', 1, 'SendingOKNoReport', -1, 61, 255, ''),
('2016-01-26 15:16:06', '2016-01-26 15:15:54', '2016-01-26 15:16:06', NULL, '00610073006400610064', '082154266124', 'Default_No_Compression', '', '+62818445009', -1, 'asdad', 21, '', 1, 'SendingOKNoReport', -1, 55, 255, ''),
('2016-01-27 03:29:41', '2016-01-27 03:29:10', '2016-01-27 03:29:41', NULL, '00530069007300740065006D0020004F007000650072006100730069002000640061006E0020004D006100740065006D006100740069006B0061', '+6285654579953', 'Default_No_Compression', '', '+6289644000001', -1, 'Sistem Operasi dan Matematika', 22, '', 1, 'SendingOKNoReport', -1, 250, 255, ''),
('2017-07-17 03:12:10', '2017-07-17 03:11:25', '2017-07-17 03:12:10', NULL, '0054006500730020006B006900720069006D00200053004D005300200064006100720069002000640061007400610062006100730065', '089623096560', 'Default_No_Compression', '', '+6289644000001', -1, 'Tes kirim SMS dari database', 23, '', 1, 'SendingOKNoReport', -1, 69, 255, 'tiara'),
('2017-07-17 03:28:15', '2017-07-17 03:28:03', '2017-07-17 03:28:15', NULL, '0054006500730020006B006900720069006D00200053004D005300200064006100720069002000640061007400610062006100730065', '089693838709', 'Default_No_Compression', '', '+6289644000001', -1, 'Tes kirim SMS dari database', 24, '', 1, 'SendingOKNoReport', -1, 70, 255, 'agusph'),
('2017-07-17 04:23:46', '2017-07-17 04:16:55', '2017-07-17 04:23:46', NULL, '0054006500730020006B006900720069006D00200053004D005300200064006100720069002000640061007400610062006100730065', '089693838709', 'Default_No_Compression', '', '+6289644000001', -1, 'Tes kirim SMS dari database', 25, '', 1, 'SendingOKNoReport', -1, 71, 255, 'agusph'),
('2017-07-17 04:23:49', '2017-07-17 04:22:28', '2017-07-17 04:23:49', NULL, '0054006500730020006B006900720069006D00200053004D005300200064006100720069002000640061007400610062006100730065', '089623096560', 'Default_No_Compression', '', '+6289644000001', -1, 'Tes kirim SMS dari database', 26, '', 1, 'SendingOKNoReport', -1, 72, 255, ''),
('2017-07-17 04:33:55', '2017-07-17 04:33:36', '2017-07-17 04:33:55', NULL, '00500069007300750064006100680020006D0065006C006500770061007400690020006A0061007400750068002000740065006D0070006F002C002000680061007200610070002000640069006B006F006E006600690072006D006100730069', '089623096560', 'Default_No_Compression', '', '+6289644000001', -1, 'Pisudah melewati jatuh tempo, harap dikonfirmasi', 27, '', 1, 'SendingOKNoReport', -1, 73, 255, 'Pisu'),
('2017-07-17 04:37:00', '2017-07-17 04:36:30', '2017-07-17 04:37:00', NULL, '00500069007500740061006E0067002000610074006100730020004E0061006D0061002000500065006C0061006E006700670061006E0020003A0020005300440020004D005500480041004D004D004100440049005900410048002000320020007300750064006100680020006D0065006C006500770061007400690020006A0061007400750068002000740065006D0070006F002C002000680061007200610070002000640069006B006F006E006600690072006D006100730069', '089623096560', 'Default_No_Compression', '', '+6289644000001', -1, 'Piutang atas Nama Pelanggan : SD MUHAMMADIYAH 2 sudah melewati jatuh tempo, harap dikonfirmasi', 28, '', 1, 'SendingOKNoReport', -1, 74, 255, ''),
('2017-07-17 04:38:35', '2017-07-17 04:38:20', '2017-07-17 04:38:35', NULL, '00500069007500740061006E0067002000610074006100730020004E0061006D0061002000500065006C0061006E006700670061006E0020003A0020005300440020004D005500480041004D004D004100440049005900410048002000320020007300750064006100680020006D0065006C006500770061007400690020006A0061007400750068002000740065006D0070006F002C002000680061007200610070002000640069006B006F006E006600690072006D006100730069', '089623096560', 'Default_No_Compression', '', '+6289644000001', -1, 'Piutang atas Nama Pelanggan : SD MUHAMMADIYAH 2 sudah melewati jatuh tempo, harap dikonfirmasi', 29, '', 1, 'SendingOKNoReport', -1, 75, 255, '');

--
-- Triggers `sentitems`
--
DELIMITER $$
CREATE TRIGGER `sentitems_timestamp` BEFORE INSERT ON `sentitems` FOR EACH ROW BEGIN
    IF NEW.InsertIntoDB = '0000-00-00 00:00:00' THEN
        SET NEW.InsertIntoDB = CURRENT_TIMESTAMP();
    END IF;
    IF NEW.SendingDateTime = '0000-00-00 00:00:00' THEN
        SET NEW.SendingDateTime = CURRENT_TIMESTAMP();
    END IF;
END
$$
DELIMITER ;

-- --------------------------------------------------------

--
-- Table structure for table `stok`
--

CREATE TABLE `stok` (
  `no_buku` varchar(20) NOT NULL,
  `jumlah` int(35) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stok`
--

INSERT INTO `stok` (`no_buku`, `jumlah`) VALUES
('B001', 0),
('B002', 13),
('B003', 20),
('B004', 4),
('M001', 0),
('M002', 0),
('M003', 0),
('M004', 0),
('S001', 0),
('S002', 0),
('S003', 0),
('S004', 23);

-- --------------------------------------------------------

--
-- Table structure for table `surat_pemesanan`
--

CREATE TABLE `surat_pemesanan` (
  `kd_sp` varchar(50) NOT NULL,
  `kd_pelanggan` varchar(25) NOT NULL,
  `kd_sales` varchar(10) NOT NULL,
  `tgl` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `surat_pemesanan`
--

INSERT INTO `surat_pemesanan` (`kd_sp`, `kd_pelanggan`, `kd_sales`, `tgl`) VALUES
('SP-12071701', 'a01-00003', 'a01', '2017-07-12'),
('SP17-001', 'a01-00003', 'a01', '2017-08-16'),
('SP17-002', 'a03-00001', 'a03', '2017-08-16');

-- --------------------------------------------------------

--
-- Table structure for table `total_jual`
--

CREATE TABLE `total_jual` (
  `kd_faktur` varchar(25) NOT NULL,
  `total` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `total_jual`
--

INSERT INTO `total_jual` (`kd_faktur`, `total`) VALUES
('FJ-17001', 437250);

--
-- Triggers `total_jual`
--
DELIMITER $$
CREATE TRIGGER `deletePiutang` AFTER DELETE ON `total_jual` FOR EACH ROW Begin
Delete from piutang where kode_fjual = old.kd_faktur;
end
$$
DELIMITER ;
DELIMITER $$
CREATE TRIGGER `insertUpdateSaldoPiutang` AFTER INSERT ON `total_jual` FOR EACH ROW BEGIN
 INSERT INTO piutang SET 
 kode_fjual = new.kd_faktur,
  saldo=new.total
 ON DUPLICATE KEY UPDATE saldo=saldo+new.total;
 END
$$
DELIMITER ;

-- --------------------------------------------------------

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `username` varchar(10) NOT NULL,
  `password` varchar(10) NOT NULL,
  `level` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`username`, `password`, `level`) VALUES
('admin', 'admin', 'accountant'),
('gudang', 'gudang', 'gudang'),
('manager', 'manager', 'manager');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `buku`
--
ALTER TABLE `buku`
  ADD PRIMARY KEY (`kd_buku`);

--
-- Indexes for table `buku_masuk`
--
ALTER TABLE `buku_masuk`
  ADD PRIMARY KEY (`no_faktur`);

--
-- Indexes for table `cek_pesanan`
--
ALTER TABLE `cek_pesanan`
  ADD PRIMARY KEY (`kd_sp`);

--
-- Indexes for table `data_buku`
--
ALTER TABLE `data_buku`
  ADD PRIMARY KEY (`kode_buku`);

--
-- Indexes for table `detail_fbuku`
--
ALTER TABLE `detail_fbuku`
  ADD PRIMARY KEY (`id_fbuku`);

--
-- Indexes for table `detail_fjual`
--
ALTER TABLE `detail_fjual`
  ADD PRIMARY KEY (`id_fjual`);

--
-- Indexes for table `detail_sp`
--
ALTER TABLE `detail_sp`
  ADD PRIMARY KEY (`id_sp`);

--
-- Indexes for table `faktur_buku`
--
ALTER TABLE `faktur_buku`
  ADD PRIMARY KEY (`no_fbuku`);

--
-- Indexes for table `faktur_jual`
--
ALTER TABLE `faktur_jual`
  ADD PRIMARY KEY (`no_fjual`);

--
-- Indexes for table `harga`
--
ALTER TABLE `harga`
  ADD PRIMARY KEY (`id_buku`);

--
-- Indexes for table `harga_buku`
--
ALTER TABLE `harga_buku`
  ADD PRIMARY KEY (`id_meta`);

--
-- Indexes for table `inbox`
--
ALTER TABLE `inbox`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `log_stok_buku`
--
ALTER TABLE `log_stok_buku`
  ADD PRIMARY KEY (`log_id`);

--
-- Indexes for table `manager`
--
ALTER TABLE `manager`
  ADD PRIMARY KEY (`id_manager`);

--
-- Indexes for table `outbox`
--
ALTER TABLE `outbox`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `outbox_date` (`SendingDateTime`,`SendingTimeOut`),
  ADD KEY `outbox_sender` (`SenderID`);

--
-- Indexes for table `outbox_multipart`
--
ALTER TABLE `outbox_multipart`
  ADD PRIMARY KEY (`ID`,`SequencePosition`);

--
-- Indexes for table `pbk`
--
ALTER TABLE `pbk`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `pbk_groups`
--
ALTER TABLE `pbk_groups`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `pelanggan`
--
ALTER TABLE `pelanggan`
  ADD PRIMARY KEY (`kd_pelanggan`);

--
-- Indexes for table `pembayaran`
--
ALTER TABLE `pembayaran`
  ADD PRIMARY KEY (`no_kwitansi`);

--
-- Indexes for table `phones`
--
ALTER TABLE `phones`
  ADD PRIMARY KEY (`IMEI`);

--
-- Indexes for table `piutang`
--
ALTER TABLE `piutang`
  ADD PRIMARY KEY (`kode_fjual`);

--
-- Indexes for table `saldo_plgn`
--
ALTER TABLE `saldo_plgn`
  ADD PRIMARY KEY (`id_pelanggan`);

--
-- Indexes for table `sales`
--
ALTER TABLE `sales`
  ADD PRIMARY KEY (`kd_sales`);

--
-- Indexes for table `sentitems`
--
ALTER TABLE `sentitems`
  ADD PRIMARY KEY (`ID`,`SequencePosition`),
  ADD KEY `sentitems_date` (`DeliveryDateTime`),
  ADD KEY `sentitems_tpmr` (`TPMR`),
  ADD KEY `sentitems_dest` (`DestinationNumber`),
  ADD KEY `sentitems_sender` (`SenderID`);

--
-- Indexes for table `stok`
--
ALTER TABLE `stok`
  ADD PRIMARY KEY (`no_buku`);

--
-- Indexes for table `surat_pemesanan`
--
ALTER TABLE `surat_pemesanan`
  ADD PRIMARY KEY (`kd_sp`);

--
-- Indexes for table `total_jual`
--
ALTER TABLE `total_jual`
  ADD PRIMARY KEY (`kd_faktur`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`username`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `detail_fbuku`
--
ALTER TABLE `detail_fbuku`
  MODIFY `id_fbuku` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
--
-- AUTO_INCREMENT for table `detail_fjual`
--
ALTER TABLE `detail_fjual`
  MODIFY `id_fjual` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `harga_buku`
--
ALTER TABLE `harga_buku`
  MODIFY `id_meta` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `inbox`
--
ALTER TABLE `inbox`
  MODIFY `ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=129;
--
-- AUTO_INCREMENT for table `log_stok_buku`
--
ALTER TABLE `log_stok_buku`
  MODIFY `log_id` int(50) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `outbox`
--
ALTER TABLE `outbox`
  MODIFY `ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;
--
-- AUTO_INCREMENT for table `pbk`
--
ALTER TABLE `pbk`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;
--
-- AUTO_INCREMENT for table `pbk_groups`
--
ALTER TABLE `pbk_groups`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;