Advertisement
Guest User

#OpMerdeka - #Indonesia Get Fucked

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