09-08-25, 05:50 AM
Takaful Malaysia Data Leaked By @N1KA
![[Image: p_3507ik8y41.png]](https://c.top4top.io/p_3507ik8y41.png)
FORMAT SQL
COMPRESSED 20MB.ZIP
U COMPRESSED 600MB.SQL
Quote:id` bigint(11) NOT NULL AUTO_INCREMENT,
`incoming_timestamp` int(11) NOT NULL,
`vehreg_no` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
`apname` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
`apaddress` text COLLATE utf8_unicode_ci,
`nric` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
`nric_type` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`name` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
`phone` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
`order_id` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
`insurer` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
`cover_type` char(10) COLLATE utf8_unicode_ci NOT NULL,
`sum_insured` decimal(10,2) NOT NULL,
`roadtax_period` tinyint(4) NOT NULL DEFAULT '12',
`nvic` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`vmake_text` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`vmodel_text` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`vmodel_variant_text` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`vmake_year` int(11) DEFAULT NULL,
`ncd` decimal(10,2) DEFAULT NULL,
`ncd_val` decimal(10,2) NOT NULL,
`ncd_next_eff_dt` int(11) DEFAULT NULL,
`txn_id` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
`txn_timestamp` int(11) DEFAULT NULL,
`txn_message` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
`txn_hash` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`txn_type` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`revisit_date` int(11) DEFAULT NULL,
`remote_ip` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
`total_amt_payable` decimal(10,2) DEFAULT NULL,
`post_data` longtext COLLATE utf8_unicode_ci,
`delivery_mode` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
`delivery_address` text COLLATE utf8_unicode_ci,
`delivery_postcode` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`delivery_statename` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
`delivery_contact_name` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
`delivery_contact_phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
`delivery_note` text COLLATE utf8_unicode_ci,
`loading_amt` decimal(10,2) DEFAULT NULL,
`schedule_premium` decimal(10,2) DEFAULT NULL,
`total_addon` decimal(10,2) NOT NULL DEFAULT '0.00',
`total_addon_before_tax` decimal(10,2) DEFAULT NULL,
`total_tax` decimal(10,2) DEFAULT NULL,
`total_stampduty` decimal(10,2) DEFAULT NULL,
`total_roadtax` decimal(10,2) DEFAULT NULL,
`total_delivery` decimal(10,2) DEFAULT NULL,
`total_nameddrivers` decimal(10,2) DEFAULT NULL,
`total_savings` decimal(10,2) DEFAULT NULL,
`total_premium` decimal(10,2) NOT NULL DEFAULT '0.00',
`total_premium_before_tax` decimal(10,2) NOT NULL DEFAULT '0.00',
`total_rounding` decimal(10,2) NOT NULL DEFAULT '0.00',
`handled_by` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
`invno` int(11) DEFAULT NULL,
`status_flag` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`action_type` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
`lastupd_timestamp` int(11) DEFAULT NULL,
`xfr_flag` tinyint(4) DEFAULT '0',
`outgoing_hash` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
`receipt_content` mediumtext COLLATE utf8_unicode_ci,
`apmobile` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
`apemail` tinytext COLLATE utf8_unicode_ci,
`ph_name` text COLLATE utf8_unicode_ci,
`ph_address` mediumtext COLLATE utf8_unicode_ci,
`ph_address_lane` mediumtext COLLATE utf8_unicode_ci,
`ph_address_postcode` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`ph_address_district` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
`ph_address_state` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
`cn_mobile_1` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
`cn_mobile_2` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
`cn_phone_homeoffice` mediumtext COLLATE utf8_unicode_ci,
`cn_email` text COLLATE utf8_unicode_ci,
`trnx_comm` decimal(10,2) NOT NULL DEFAULT '0.00',
`trnx_cost` decimal(10,2) NOT NULL DEFAULT '0.00',
`trnx_surplus` decimal(10,2) NOT NULL DEFAULT '0.00',
`process_stage` tinyint(4) DEFAULT NULL,
`process_stage_label` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
`process_lastupdate` int(11) DEFAULT NULL,
`process_updated_by` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
`delivery_by` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
`delivery_lastupdate` int(11) DEFAULT NULL,
`delivery_status` tinyint(4) DEFAULT NULL,
`delivery_status_label` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
`memo` longtext COLLATE utf8_unicode_ci,
PRIMARY KEY (`id`),
KEY `incoming_timestamp` (`incoming_timestamp`,`remote_ip`,`invno`),
KEY `action_type` (`action_type`),
KEY `lastupd_timestamp` (`lastupd_timestamp`),
KEY `vehreg_no` (`vehreg_no`),
KEY `process_stage` (`process_stage`)
Quote:id` bigint(20) NOT NULL AUTO_INCREMENT,
`pool_fk` bigint(20) NOT NULL,
`delivery_parent_fk` bigint(20) DEFAULT '0',
`vehreg_no` varchar(15) NOT NULL,
`delivery_type` varchar(15) DEFAULT NULL,
`delivery_by` varchar(20) DEFAULT NULL,
`delivery_tracking_no` varchar(30) DEFAULT NULL,
`contact_name` varchar(40) DEFAULT NULL,
`contact_phone` varchar(40) DEFAULT NULL,
`delivery_address` text,
`delivery_postcode` varchar(15) DEFAULT NULL,
`delivery_statecode` varchar(10) DEFAULT NULL,
`delivery_notes` text,
`delivery_status` varchar(10) DEFAULT 'pending',
`updated_by` varchar(10) DEFAULT NULL,
`update_timestamp` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `pool_fk` (`pool_fk`),
KEY `vehreg_no` (`vehreg_no`)
Code:
DESPATCH','','','abdul ghani bin abdul ghafar','0182101492','no.58 jalan diplomatik persint 15, ','62050','A','sebelah kk mart','delivered',NULL,2147483647),(2,20,0,'WC1204B','DESPATCH','SYAHRIL','','Kartini Norisha bt Abu Hassan','0169079698','No. 55, jalan ss15/2d,\r\nsubang jaya, selangor','47500','A','Please send on date and time below\r\nDate: 28 Sept 2016\r\nTime: 3.30pm','delivered','SARAH',2147483647),(3,27,0,'DCR6960','COURIER','','','Mohd haiqal b hashim','019-9909927','A-2-18 Green villa apartment, jalan bistari, persiaran cemerlang, jalan sungai tangkas','43000 Kaja','A','DONE','delivered','AIZAT',2147483647),(4,28,0,'WRU6096','DESPATCH','','','andria\' adi bin agus','0176013297','Restoran mak limah\r\n3g dataran selayang 2,\r\ndataran selayang','68100','A','','delivered','AIZAT',2147483647),(5,30,0,'WC294W','DESPATCH','HAIRI-0162294757','','ROHAIZAM BIN ROSLI','013-4386019','E-09-03, LEVEL 9, BLOCK E, CAPITAL 5, OASIS SQUARE, JALAN PJU 1A/7A, ARA DAMANSARA, PETALING JAYA','47301','A','','delivered','HAYANI',2147483647),(6,34,0,'W5932T','COURIER','SYAHRIL 0162294751','','Tristan Edward Lynch','0193887660','Bakels Malaysia\r\nNo 2 Jalan Pendamar 27/90\r\nSeksyen 27\r\nShah Alam','40400','A','','delivered','SARAH',2147483647),(7,37,0,'BNH2939','COURIER','','','gokilaveni a/p karunakaram','0162880798 / 0176676','1606, menara bakti\r\n14/20 jln petaling jaya\r\npetaling jaya','46100','A','please delivery to home with ajeeth','delivered','SARAH',2147483647),(8,41,0,'WB4506R','COURIER','JAMAL','','THOO KAH WEI','01126606170','No 22, jalan seksyen 3/18, taman kajang utama, 43000 kajang, selangor.','43000','A','4506 Axia','delivered','SARAH',2147483647),(9,42,0,'W5855J','DESPATCH','HERI','','Ameerul\'ameen pishal','0172604290','Suite 23-02, oval tower damansara, no 685, jalan damansara, 60000 kuala lumpur','60000','A','This is my office address','delivered','SARAH',2147483647),(10,52,0,'KEE5636','DESPATCH','HAIRI-0162294757','','MUHAMAD RAMZAN BIN MUHAMAD NOR','0163019066','PRASARANA MALAYSIA BHD\r\nNO 1 JALAN PJU 1A/46\r\nOFF JALAN LAPANGAN TERBANG SUBANG, PETALING JAYA','47301','A','','delivered','SARAH',2147483647),(11,49,0,'JQW64','COURIER','POSLAJU','EN841162000MY','MOHAMAD QAsri bin md noh','+60127222206','No 8 jalan mewah ria ? taman bukit mewah tampoi ','81200','A','Kilang otak2 jb\r\nItem delivered to QASRI','delivered','HAYANI',2147483647),(12,50,0,'JKY743','COURIER','POSLAJU','EN841162013MY','Norzilawati binti ali','0108282870','SMK Felda Ulu tebrau\r\nFelda Ulu tebrau','81810','A','Item delivered to SALLEH\r\n','delivered','HAYANI',2147483647),(13,58,0,'WA1650L','DESPATCH','ARIF 0162294754','','AZNAIM BIN ABDUL AZIZ','0164040590','BLOK 41-07-08\r\nPPR GOMBAK SETIA','53100','A','','delivered','SARAH',2147483647),(14,69,0,'WB8416T','COURIER','HAIRI-0162294757','','Siti Nur Atiqah Baharom','0183869707','No 32 Jalan bp13a, taman bukit permata, batu caves','68100','A','','delivered','SARAH',2147483647),(15,67,0,'WEW7091','COURIER','JAMAL-0162294753','','Khairul ridhuwan','01126263114','No 42 jalan 5/7 taman langat jaya\r\nWest country','43000','A','112269006461 MBB REFUND','delivered','SARAH',2147483647),(16,46,0,'BHM3258','COURIER','POSLAJU','DONE','muhammad firdaus bin aJaman','0102031103','poslaju ipc shah alam 4300 sHah alam selangOr','40300','A','','delivered','SARAH',2147483647),(17,47,0,'WD4574A','COURIER','POSLAJU','','TING NGUONG LIYEK','01119337145','DHL ASIA PACIFIC SHARED SERVICES SDN BHD,LEVEL 11,menara axis,2 jalam 51A/223','46100','A','','delivered','SARAH',2147483647),(18,82,0,'PFW9459','COURIER','POSLAJU','EN841161914MY','Sharin bin khalid','0195197766','Bank islam Malaysia berhad\r\nVarsity Mall\r\nUniversiti utara Malaysia\r\nsintok','06010','A','','delivered','SARAH',2147483647),(19,83,0,'JPL8847','COURIER','POSLAJU','EN841161928MY','ADILAH BINTI MADON','01121904108','No 1,JALAN KEJAYAAN 2, TAMAN UNIVERSITI, 81300 SKUDAI, JOHOR BAHRU','81300','A','','delivered','SARAH',2147483647),(20,53,0,'PJF1751','COURIER','POSLAJU','XXX','Lewynd Nishel Arumugam','0162014386','15, Jalan 4/149A, Taman Bukit Intan, SRi Petaling.','57000','A','','delivered','SARAH',2147483647),(21,87,0,'WRL3598','DESPATCH','ARIF-0162294754','','wan mohd hidir bin wan sallehudin','0193885184','nO. 14 & 16, JALAN 29/10A,\r\nTAMAN PERINDUSTRIAN IKS MUKIM BATU,','68100','A','ATTN : WAN MOHD HIDIR BIN WAN SALLEHUDIN.','delivered','SARAH',2147483647),(22,55,0,'QMM2205','COURIER','POSLAJU','XXX','HAZLI','0123966753','1177 JALAN 3/4\r\nNUSARI AMAN 2\r\nBANDAR SRI SENDAYAN','71950','A','','delivered','SARAH',2147483647),(23,91,0,'LE210','COURIER','POS LAJU','EN841161018MY','abdul rahim bin ahmad','0173100686','268 Lorong 2\r\nlarut tin sambungan\r\ntaiping','34000','A','','delivered','SARAH',2147483647),(24,96,0,'MCV1265','COURIER','POSLAJU','EN841160998MY','Zabariah bte ahmad','0193652747','Asatana intan 02/07\r\nJalan astana 13/2\r\nBandar puncak alam\r\nSelagor','42300','A','','delivered','SARAH',2147483647),(25,88,0,'PMQ5451','COURIER','POSLAJU','EN841160975MY','MUHAMMAD HARZARUL BIN SOBLI','0178711265','SHELL HELIX SERVICE CENTRE\r\n345, JALAN JELUTONG,\r\nJELUTONG','11600','A','MONDAY -
