· 6 years ago · Mar 11, 2019, 06:22 AM
1-- Adminer 4.7.0 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `pointofsale_nasa`;
9CREATE TABLE `pointofsale_nasa` (
10 `place_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Place ID',
11 `customer_group` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Customer group',
12 `store_id` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Store views',
13 `position` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Store position',
14 `store_code` varchar(255) NOT NULL COMMENT 'Store code',
15 `store_area` varchar(255) NOT NULL COMMENT 'Store area',
16 `name` varchar(255) NOT NULL COMMENT 'Store name?',
17 `address_line_1` varchar(255) DEFAULT NULL COMMENT 'Address 1',
18 `address_line_2` varchar(255) DEFAULT NULL COMMENT 'Address 2',
19 `city` varchar(255) DEFAULT NULL COMMENT 'Store City',
20 `state` varchar(50) DEFAULT NULL COMMENT 'Store State',
21 `postal_code` varchar(50) DEFAULT NULL COMMENT 'Store zipcode',
22 `country_code` varchar(50) DEFAULT NULL COMMENT 'Store country code',
23 `main_phone` varchar(50) DEFAULT NULL COMMENT 'Store phone',
24 `email` varchar(255) DEFAULT NULL COMMENT 'Store email',
25 `hours` text COMMENT 'Store opening hours',
26 `description` text COMMENT 'Store description?',
27 `longitude` varchar(20) DEFAULT NULL COMMENT 'Store location, longitude',
28 `latitude` varchar(20) DEFAULT NULL COMMENT 'Store location, latitude',
29 `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Store status',
30 `image` varchar(255) DEFAULT NULL COMMENT 'Store image',
31 `pickup_fee` float DEFAULT NULL COMMENT 'Pickup fee',
32 `store_erafone_id` int(11) NOT NULL COMMENT 'Store Erafone ID',
33 PRIMARY KEY (`place_id`),
34 KEY `POINTOFSALE_PLACE_ID` (`place_id`)
35) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Point of sales and Warehouses';
36
37INSERT INTO `pointofsale_nasa` (`place_id`, `customer_group`, `store_id`, `position`, `store_code`, `store_area`, `name`, `address_line_1`, `address_line_2`, `city`, `state`, `postal_code`, `country_code`, `main_phone`, `email`, `hours`, `description`, `longitude`, `latitude`, `status`, `image`, `pickup_fee`, `store_erafone_id`) VALUES
38(776, '1,2,3', '1', 0, 'SP-BDG-001', '', 'SEP UBERTOS', 'Jl,AH.Nasution kav.46A Ujung berung Bandung Lantai dasar unit Gf-21', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '022-63733912', '', '{}', 'NULL', '107.6966507', '6.9156817', 9, NULL, 0, 5),
39(777, '1,2,3', '1', 0, 'SP-BGR-001', '', 'SEP METROPOLITAN MALL CILEUNGSI', 'Jln metlend transyogi cilengsi Lt 1 no15', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-80875244', 'samsung.mallcileungsi@mynasa.com', '{}', 'NULL', '106.97601', '-6.39909', 9, NULL, 0, 5),
40(778, '1,2,3', '1', 0, 'SP-DPK-001', '', 'SEP MAL CINERE', 'MALL CINERE LANTAI DASAR NO 22, JL.CINERE RAYA NO 1 PANGKALAN JATI', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-7540738', 'samsung.cinere@mynasa.com', '{}', 'NULL', '106.782745', '-6.317555', 9, NULL, 0, 5),
41(779, '1,2,3', '1', 0, 'SP-DPK-002', '', 'SEP ITC DEPOK', 'ITC Depok Lantai 3 No. 12B & 15 Jalan Margonda Raya No. 56, Pancoran MAS', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '', 'samsung.itcdepok@mynasa.com', '{}', 'NULL', '', '', 9, NULL, 0, 5),
42(780, '1,2,3', '1', 0, 'SP-DPK-003', '', 'SEP 2 ITC DEPOK', 'JL. Margonda Raya Depok, ITC Depok Lt. G Main Lobby 1', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '', '', '{}', 'NULL', '106.823782', '-6.39308', 9, NULL, 0, 5),
43(781, '1,2,3', '1', 0, 'SP-JKB-001', '', 'SEP ROXY ITC MAS', 'JL. K.H Asyari Kel.Cideng Kec. Gambir, Jakarta Pusat . Gedung ITC ROXY MAS Lt.GF Area Void A,', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '', '', '{}', 'NULL', '106.803013', '-6.16651', 9, NULL, 0, 5),
44(782, '1,2,3', '1', 0, 'SP-JKP-001', '', 'SEP ITC CEMPAKA MAS', 'Jl.letjen suprapto itc cempaka mas lt4 blok a1-2, jakarta Pusat', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-42901212', '', '{}', 'NULL', '106.876984', '-6.164649', 9, NULL, 0, 5),
45(783, '1,2,3', '1', 0, 'SP-JKS-002', '', 'SEP MAL BASSURA', 'Jln.basuki rahmat no.1A JakTim, Lt.GF No.20A', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-22807173', 'samsung.bassura@mynasa.com', '{}', 'NULL', '106.878257', '-6.223457', 9, NULL, 0, 5),
46(784, '1,2,3', '1', 0, 'SP-JKS-003', '', 'SEP PLAZA SEMANGGI', 'Jalan Jendral Sudirman No.50, RT.1/RW.4, Karet Semanggi, Setiabudi, Kota Jakarta Selatan, 12930 GF 101-103', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '', '', '{}', 'NULL', '106.81448', '-6.21941', 9, NULL, 0, 5),
47(785, '1,2,3', '1', 0, 'SP-SLO-001', '', 'SEP SOLO SQUARE', 'JL. IR SOEKARNO MADEGONDO GROGOL KABUPATEN SUKOHARJO (THE PARK MALL LANTAI LG)', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '', '', '{}', 'NULL', '106.806273', '-6.601951', 9, NULL, 0, 5),
48(786, '1,2,3', '1', 0, 'SP-SUM-001', '', 'SEP JATINANGOR TOWN SQUARE', 'JL.JATINANGOR NO 150 MALL JATINANGOR TOWN SQUARE LANTAI 1 BLOK FFB1 01', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '022-87920048 ', 'samsung.jatinangor@mynasa.com', '{}', 'NULL', '107.771633', '-6.934298', 9, NULL, 0, 5),
49(787, '1,2,3', '1', 0, 'SP-TGR-001', '', 'SEP E-Center Supermall Karawaci', 'E-Center Karawaci, Lt. UG Blok C5 No. 3-3A, Supermall Karawaci, Tangerang - Banten', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '', '', '{}', 'NULL', '106.60798', '-6.22747', 9, NULL, 0, 5),
50(788, '1,2,3', '1', 0, 'SS-ABN-001', '', 'SES AMBON CITY CENTER', 'Jln.Woltermonginsidi,Passo.Lt.GF no 20-22 ( 97232 )', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '0911-3869997', 'samsung.ambon@mynasa.com', '{}', 'NULL', '128.249317', '-3.62044', 9, NULL, 0, 5),
51(789, '1,2,3', '1', 0, 'SS-BDG-002', '', 'SES TRANS STUDIO MALL', 'JL.GATOT SUBROTO NO 289 TRANS STUDIO BANDUNGLT GF BLOCK B 088 (SAMSUNG STORE TSM) DEPAN TRANSMART', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '022-91091842', 'samsung-tsm@mynasa.com', '{}', 'NULL', '107.636468', '6.926378', 9, NULL, 0, 5),
52(790, '1,2,3', '1', 0, 'SS-BGR-001', '', 'SES GIANT EKSTRA SENTUL CITY', 'Sentul City Unit I -1 No.6 SENTUL BOGOR', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-296 867 21', 'samsung.giantsentul@mynasa.com', '{}', 'NULL', '106.855814', '-6.567644', 9, NULL, 0, 5),
53(791, '1,2,3', '1', 0, 'SS-BGR-002', '', 'SES CIBINONG CITY MALL', 'CIBINONG CITY MALL Unit Lt LG No. 37 & 38. Jl. Tegar Beriman No.1', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-29860111', 'samsung.cibinongcity@mynasa.com', '{}', 'NULL', '160.842217', '-6.484148', 9, NULL, 0, 5),
54(792, '1,2,3', '1', 0, 'SS-BGR-003', '', 'SES PLAZA JAMBU 2', 'Jln.Jend Ahmad Yani Plaza Jambu Dua Bogor Lt 1', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '0251-8357450', 'samsung.jambu2@mynasa.com', '{}', 'NULL', '106.806847', '-6570870', 9, NULL, 0, 5),
55(793, '1,2,3', '1', 0, 'SS-BGR-004', '', 'SES PLAZA EKALOKASARI', 'Unit GF No. 7, Jl. Siliwangi No. 123', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '0251-8375078', 'samsung.ekalokasari@mynasa.com', '{}', 'NULL', '106.817535', '6.621581', 9, NULL, 0, 5),
56(794, '1,2,3', '1', 0, 'SS-BJM-001', '', 'SES DUTA MALL BANJARMASIN', 'jln. A yani km 2 duta mall lt. 3 block 3F10-11', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '0511-4368303', 'samsung.dutamall@mynasa.com', '{}', 'NULL', '114.603182', '-3.32243', 9, NULL, 0, 5),
57(795, '1,2,3', '1', 0, 'SS-BKL-001', '', 'SES BENCOOLEN MALL ', 'Jl. Putri Gading Cempaka, Penurunan Bengkulu, Bencoolen Indah Mall Lt.1 Blok B No. 9-10 Kode POS 38223', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '0736-5611067', 'samsung.becolen@mynasa.com', '{}', 'NULL', '102268484', '-3811183', 9, NULL, 0, 5),
58(796, '1,2,3', '1', 0, 'SS-BKS-001', '', 'SES 2 SUMMARECON MALL BEKASI', 'Lantai G No. 129, Jl. Bulevar Ahmad Yani blok M, Sentra Summarecon Bekasi', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-29572726', 'samsung.summareconmal@mynasa.com', '{}', 'NULL', '107.00086', '-6.22634', 9, NULL, 0, 5),
59(797, '1,2,3', '1', 0, 'SS-BKS-002', '', 'SES GRAND METROPOLITAN MALL', 'Mall Grand Galaxy Park Bekasi Lt. Dasar B12. Jl. Grand Galaxy Boulevard No. 1 Kel. Jaka setia, Kec Bekasi selatan', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-29613021', 'samsung.grandmetmall@mynasa.com', '{}', 'NULL', '106.98477', '-6.24961', 9, NULL, 0, 5),
60(798, '1,2,3', '1', 0, 'SS-BKS-004', '', 'SES GRAND GALAXY PARK', 'Grand Galaxy Park Lt. 2 unit D8, Jl. Grand Galaxy Boulevard No. 1', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-29613183', 'samsung.grandgalaxy@mynasa.com', '{}', 'NULL', '106.9723', '-6.27099', 9, NULL, 0, 5),
61(799, '1,2,3', '1', 0, 'SS-BLG-001', '', 'SES MAL KARTINI LAMPUNG', 'Jln RA Kartini No.49 Blok A11-12 Lt.1 Mall Kartini Lampung. Kode POS 35117', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '0721- 240093', 'samsung.mallkartini@mynasa.com', '{}', 'NULL', '105.253055', '-5.416609', 9, NULL, 0, 5),
62(800, '1,2,3', '1', 0, 'SS-BLG-002', '', 'SES MAL BOEMI KEDATON', 'Mall Boemi Kedaton Lantai Ground Jalan Teuku Umar Lantai 1 Kode POS 35132', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '0721-8015699', 'samsung.boemikedaton@mynasa.com', '{}', 'NULL', '105.259002', '-5.382268', 9, NULL, 0, 5),
63(801, '1,2,3', '1', 0, 'SS-BLP-002', '', 'SES PENTACITY SHOPPING AVENUE', 'Mall Penta City Balikpapan , JL. Jend Sudirman Lt. FF No 39', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '0542-8521880', 'samsungstorepentacity.002@mynasa.com', '{}', 'NULL', '116.85787', '-1.274206', 9, NULL, 0, 5),
64(802, '1,2,3', '1', 0, 'SS-CLG-001', '', 'SES CILEGON SUPERMALL', 'Supermall Cilegon Jl.S.A Tirtayasa Simpang Tiga Cilegon', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '0254-8484472', 'samsung.cilegon@mynasa.com', '{}', 'NULL', '106.045302', '-6.013587', 9, NULL, 0, 5),
65(803, '1,2,3', '1', 0, 'SS-CLG-002', '', 'SES CILEGON CENTER MALL', 'Unit GF 11-12 Lt. Ground Floor Cilegon Center Mall, Jln. Jendral Ahmad Yani, Sukmajaya, Kec, Jombang, Kota Cilegon, Banten 42416', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '0254-7817772', '', '{}', 'NULL', '10613634', '-611404', 9, NULL, 0, 5),
66(804, '1,2,3', '1', 0, 'SS-DPK-001', '', 'SES MARGO CITY', 'Jln. Margonda Raya Depok Mall Margo City Depok Lt. 2 No. 48', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-78870940', 'samsung.margocity@mynasa.com', '{}', 'NULL', '106.834799', '-6.372892', 9, NULL, 0, 5),
67(805, '1,2,3', '1', 0, 'SS-DPK-002', '', 'SES PESONA SQUARE DEPOK', 'PESONA SQUARE MALL - Jl. IR H. Juanda N0.99. DEPOK', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '', '', '{}', 'NULL', '106.844683', '-6.380066', 9, NULL, 0, 5),
68(806, '1,2,3', '1', 0, 'SS-GRS-001', '', 'SES ICON MALL GRESIK', 'Icon Mall Gresik Lt GF unit 20. jl. dr wahidin sudiro husodo no 788, kembangan, Kebomas, gresik ', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '031-30002522', 'samsung.icongresik@gmail.com', '{}', 'NULL', '112.602352', '-7.16682', 9, NULL, 0, 5),
69(807, '1,2,3', '1', 0, 'SS-JBR-001', '', 'SES LIPPO PLAZA JEMBER', ' Lippo Plaza Jember, Lt. GF unit 18, Jl Gajah Mada No 175 kali wates, Jember', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '', 'samsung.lippojember@mynasa.com', '{}', 'NULL', '113.687911', '-8.17352', 9, NULL, 0, 5),
70(808, '1,2,3', '1', 0, 'SS-JKB-001', '', 'SES 2 ITC ROXY MAS', 'ITC Roxy Mas Lantai Dasar No 86-88 Jakarta Pusat', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-6304781', 'samsung01.itcroxy@mynasa.com', '{}', 'NULL', '106.803013', '-6.16651', 9, NULL, 0, 5),
71(809, '1,2,3', '1', 0, 'SS-JKB-002', '', 'SES 1 ITC ROXY MAS', 'Itc roxy mas lt.1 blok C no.1-2 jakarta barat', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-98283629', 'samsung.itcroxy@mynasa.com', '{}', 'NULL', '106.803013', '-6.16651', 9, NULL, 0, 5),
72(810, '1,2,3', '1', 0, 'SS-JKB-003', '', 'SES ST MORITZ MALL', 'PX PAVILION ST.MORITS L1-17, JAKARTA BARAT', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-22582763', 'samsung.stmorist@mynasa.com', '{}', 'NULL', '106.73872', '-6.18786', 9, NULL, 0, 5),
73(811, '1,2,3', '1', 0, 'SS-JKM-001', '', 'SES CIPINANG INDAH MALL', 'Jl Cipinang Indah Raya 1 Mall Cipinang Indah Lantai LG No. 28, Jakarta Timur', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-29486912', 'samsung.cipinangindah@mynasa.com', '{}', 'NULL', '106.894348', '-6.238276', 9, NULL, 0, 5),
74(812, '1,2,3', '1', 0, 'SS-JKM-002', '', 'SES AEON MALL JGC', 'Lantai LG lot G-53 Mall AEON Cakung', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-806075167', 'samsung.jgcaeon@mynasa.com', '{}', 'NULL', '106.951861', '-6.17261', 9, NULL, 0, 5),
75(813, '1,2,3', '1', 0, 'SS-JKP-003', '', 'SES GREEN PRAMUKA SQUARE', 'Jl. Jend. Ahmad Yani Kav 49, Rt 16/Rw 9, Rawasari, Cempaka Putih Lt. GF NO.5', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-29624935', 'samsung.greenpramukasquare@mynasa.com', '{}', 'NULL', '106.874386', '-6.187847', 9, NULL, 0, 5),
76(814, '1,2,3', '1', 0, 'SS-JKS-001', '', 'SES GANDARIA CITY', 'Jl.sultan iskandar muda mall gandaria city samsung store lt.1 unit 190-191 jakarta selatan', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-29053267', 'samsung.gancy@mynasa.com', '{}', 'NULL', '106.78367', '-6.243833', 9, NULL, 0, 5),
77(815, '1,2,3', '1', 0, 'SS-JKS-002', '', 'SES SENAYAN CITY', 'JL.asia afrika lot 19,senayan city lt 4 unit 37-38', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-72781406', 'samsung.sency@mynasa.com', '{}', 'NULL', '106.797246', '-6.227063', 9, NULL, 0, 5),
78(816, '1,2,3', '1', 0, 'SS-JKS-004', '', 'SES MAL AMBASADOR', 'Jl. Prof. Dr Satrio, Mall of Ambassador Lt 3 No. 21, ', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-576 0050', 'samsung.ambasador@mynasa.com', '{}', 'NULL', '106.826619', '-6.223782', 9, NULL, 0, 5),
79(817, '1,2,3', '1', 0, 'SS-JKS-005', '', 'SES LIPPO MALL KEMANG', 'Lippo Mal Kemang kemang village, 36 P.Antasari, jakarta 12150, Lt.2 unit 22', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-22210189', 'samsung.exionkemang@mynasa.com', '{}', 'NULL', '106.81346', '-6.261228', 9, NULL, 0, 5),
80(818, '1,2,3', '1', 0, 'SS-JKS-006', '', 'SES KALIBATA CITY', 'Jl kalibata raya 1 , Mall kalibata city square Lt GF block E No.10', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-29317076', 'samsung.kalibata@mynasa.com', '{}', 'NULL', '106.8522258', '-6.2563315', 9, NULL, 0, 5),
81(819, '1,2,3', '1', 0, 'SS-JKS-007', '', 'SES KOTA KASABLANKA', 'Jl. Casablanca Kav no 88, Mall Kota Kasablanka Lantai 1 No 106', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021–29612719 / 021–29612720', 'samsung.kasablanca@mynasa.com', '{}', 'NULL', '106.84275', '-6.22399', 9, NULL, 0, 5),
82(820, '1,2,3', '1', 0, 'SS-JKS-008', '', 'SES LOTTE SHOPPING AVENUE', 'Mall Lotte Shopping Evenue lantai GF No. 01A', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-29889139', 'sslotte21@mynasa.com', '{}', 'NULL', '106.82355', '-6.2239', 9, NULL, 0, 5),
83(821, '1,2,3', '1', 0, 'SS-JKS-009', '', 'SES ONE BELPARK ', 'Jln. Rs Fatmawati one belpark mall, Samsung experience store lantai LG no.40 pondok labu Jakarta selatan', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-29864875', 'samsung.belpark@mynasa.com', '{}', 'NULL', '106.79494', '-6.304515', 9, NULL, 0, 5),
84(822, '1,2,3', '1', 0, 'SS-JKS-012', '', 'SES PLAZA SENAYAN', 'Plaza Senayan Lt. LG Unit No.DB 19 Jln.Asia Afrika No.8 GBK Senayan Jakarta Pusat 10270', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-29678497', 'samsung.plazasenayan@mynasa.com', '{}', 'NULL', '106.799104', '-6.225811', 9, NULL, 0, 5),
85(823, '1,2,3', '1', 0, 'SS-JKS-014', '', 'SES PEJATEN VILLAGE', 'Pejaten Village Mall Lantai L2 No. 05-06 Jl. Warung Jati Barat No. 39, Jati Padang, Pasar Minggu, Jakarta Selatan, DKI Jakarta, Kota Jakarta Selatan, DKI Jakarta', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '', '', '{}', 'NULL', '106.829185', '-6.28049', 9, NULL, 0, 5),
86(824, '1,2,3', '1', 0, 'SS-JKU-002', '', 'SES BAYWALK PLUIT', 'Jl.pluit karang ayu, baywalk mall zona F lt.4 no.35 apartment greenbay pluit jakarta utara', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', 'Jalan Pluit Karang Ayu B1 Utara, Pluit, Penjaringa', 'samsung.baywalk@mynasa.com', '{}', 'NULL', '106.779324', '-6.107697', 9, NULL, 0, 5),
87(825, '1,2,3', '1', 0, 'SS-JKU-003', '', 'SES 2 MAL KELAPA GADING', 'Jl boulvard kelapa gading, Mall kelapa gading 3 Lt GF no. G 51 ', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-45853754', 'samsung.mkg2@mynasa.com', '{}', 'NULL', '106.908839', '-6.156255', 9, NULL, 0, 5),
88(826, '1,2,3', '1', 0, 'SS-JKU-004', '', 'SES PANTAI INDAH KAPUK MALL', 'PIK AVANUE MALL lantai 2F C16, Jakarta Utara', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-22570889', 'samsung.pik@mynasa.com', '{}', 'NULL', '106.740219', '-6.109628', 9, NULL, 0, 5),
89(827, '1,2,3', '1', 0, 'SS-JKU-005', '', 'SES MALL OF INDONESIA', 'Mall Of Indonesia Lantai GF - 06B', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '', 'samsung.mallofindonesia@mynasa.com', '{}', 'NULL', '106.891951', '-6.150923', 9, NULL, 0, 5),
90(828, '1,2,3', '1', 0, 'SS-JMB-001', '', 'SES JAMBI TOWN SQUARE', 'Lt. Dasar K7-K8 JL KP. Bakararudin No. 88, Jambi Town Square Mall', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '0741-670756', 'samsung.jambitownsquare@mynasa.com', '{}', 'NULL', '103.586981', '-1.621149', 9, NULL, 0, 5),
91(829, '1,2,3', '1', 0, 'SS-KDI-001', '', 'SES KEDIRI TOWN SQUARE', 'Kediri Town Square, Lantai GF unit 35, Jln.Hasanuddin No.2, Dandangan, kediri', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '0354 - 673913', 'samsung.kediri@mynasa.com', '{}', 'NULL', '112.0155518', '-7.8122982', 9, NULL, 0, 5),
92(830, '1,2,3', '1', 0, 'SS-KPG-001', '', 'SES LIPPO PLAZA KUPANG', 'Lippo Plaza Ku pang, Lt GF No 30-30A, Jln. Veteran, kel fatululi,kec Oebobo, Kupang', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '0380-8439102', 'samsung.kupang@mynasa.com', '{}', 'NULL', '123.61135673', '-10.15935467', 9, NULL, 0, 5),
93(831, '1,2,3', '1', 0, 'SS-KRW-001', '', 'SES RESINDA PARK KARAWANG', 'Lantai GF-18 Jalan Resinda Raya No.2 Karawang Barat – Karawang 41361', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '0267-8407638', 'samsung.resinda@mynasa.com', '{}', 'NULL', '107.27154', '-6.29965', 9, NULL, 0, 5),
94(832, '1,2,3', '1', 0, 'SS-MAD-001', '', 'SES SUNCITY FESTIVAL MALL', 'Suncity Mall Madiun, Lantai G, Jln S.parman B56-57, Madiun', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '0351 4472165', 'samsung.suncitymadiun@mynasa.com', '{}', 'NULL', '111.535435', '-7.622405', 9, NULL, 0, 5),
95(833, '1,2,3', '1', 0, 'SS-MDN-001', '', 'SES SUN PLAZA ', 'Jl. Zainul Arifin, Sun Plaza Lt.LG No 30-31c Medan ', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '061-4501078', 'samsung.sunplaza@mynasa.com', '{}', 'NULL', '98.680803', '-3.591904', 9, NULL, 0, 5),
96(834, '1,2,3', '1', 0, 'SS-MDN-002', '', 'SES PLAZA MILENIUM', 'JL. Kapten Muslim,Plaza Millenium Lt.3 No.69 Medan', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '061-8476224', 'samsung.millenium@mynasa.com', '{}', 'NULL', '98.680803', '-3.591904', 9, NULL, 0, 5),
97(835, '1,2,3', '1', 0, 'SS-MDN-003', '', 'SES CRYSTAL SQUARE MEDAN', 'Jl. Imam Bonjol No.6 Gedung Mall Crystal Square/Lippo Plaza Medan Unit UG 16', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '061-80511011', 'samsung.crystalsquare@mynasa.com', '{}', 'NULL', '98.680803', '-3.591904', 9, NULL, 0, 5),
98(836, '1,2,3', '1', 0, 'SS-MDN-004', '', 'SES CENTER POINT MEDAN', 'Jln Jawa, Gg Buntu , Gedung Centre Point Lt LG No.36 Medan Timur - Kota Medan 20236 ', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '061-80510025', 'samsung.centerpoint@mynasa.com', '{}', 'NULL', '98.680844', '3.607827', 9, NULL, 0, 5),
99(837, '1,2,3', '1', 0, 'SS-MDN-005', '', 'SES BINJAI SUPERMALL MEDAN', 'Jl. Soekarno - Hatta No. 14 Gedung Binjai Supermall Unit GFK No. 15- 18 Kode POS 20735', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '061-8820702', 'samsung.binjai@mynasa.com', '{}', 'NULL', '98.496715', '3.607827', 9, NULL, 0, 5),
100(838, '1,2,3', '1', 0, 'SS-MDN-006', '', 'SES MEDAN FOCAL POINT', 'Jl. Setia Budi Indah II Blok. XL Gedung Medan Focal Point Unit F1 No. 09', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '061-88802262', 'samsung.focalpoint@mynasa.com', '{}', 'NULL', '98.496715', '3.607827', 9, NULL, 0, 5),
101(839, '1,2,3', '1', 0, 'SS-MDN-007', '', 'SES PLAZA MEDAN FAIR', 'Jl. Gatot Subroto, Plaza Medan Fair Lantai 4 No. 7 Medan Kode POS 20113', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '', '', '{}', 'NULL', '98.496715', '3.607827', 9, NULL, 0, 5),
102(840, '1,2,3', '1', 0, 'SS-MKS-001', '', 'SES MAL PANAKUKANG', 'Jl. Boulevard Komplek Panakkukang Mas. Gedung D Lt Dasar Unit D1 12', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '0411-4820384', 'samsung.panakukang@mynasa.com', '{}', 'NULL', '119.44664287', '-5.15780106', 9, NULL, 0, 5),
103(841, '1,2,3', '1', 0, 'SS-MKS-002', '', 'SES MAL RATU INDAH', 'Jl. Dr. Samratulangi no. 35 unit 2 FL No.233 Makasar', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '0411-834362', 'samsung.ratuindah@mynasa.com', '{}', 'NULL', '119.41776207', '-5.15340126', 9, NULL, 0, 5),
104(842, '1,2,3', '1', 0, 'SS-MKS-003', '', 'SES CITY MARKET PALOPO', 'City Market Palopo, Jl. Dr. Sam Ratulangi No. 78, Palopo LT.1 NO : 10', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '0471-22703', 'samsung.palopo@mynasa.com', '{}', 'NULL', '120.18714112', '-2.98982249', 9, NULL, 0, 5),
105(843, '1,2,3', '1', 0, 'SS-MKS-004', '', 'SES NIPAH MALL MAKASSAR', 'Ground Floor, GF#10, Jl. DR. Ratulangi No. 8-10 Makassar, Sulawesi Selatan', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '', '', '{}', 'NULL', '119.45026087', '-5.13919607', 9, NULL, 0, 5),
106(844, '1,2,3', '1', 0, 'SS-MKS-005', '', 'Ses Karebosi Link', 'Karebosi Ground Blok L-01,02,03,11,12,15,16,17(8 Kios Dan LT Ground, Lokasi SLN,Samping Tenant Pizza', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '', '', '{}', 'NULL', '119.4117383', '-5.13344546', 9, NULL, 0, 5),
107(845, '1,2,3', '1', 0, 'SS-MND-002', '', 'SES MEGAMALL MANADO', 'Mega Mall lantai LG no. 48 Jl. Piere Tendean Boulevard Manado 95111', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '', '', '{}', 'NULL', '124.8346601', '1.4841349', 9, NULL, 0, 5),
108(846, '1,2,3', '1', 0, 'SS-PKB-001', '', 'SES LIVING WORLD PEKANBARU', 'Lt. Upper Ground Unit UG-30A, UG-30B, UG-30C', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '', '', '{}', 'NULL', '101.420177', '0.500248', 9, NULL, 0, 5),
109(847, '1,2,3', '1', 0, 'SS-PKB-002', '', 'SES CIPUTRA SERAYA', 'MALL CIPUTRA SERAYA LT. UG UNIT 01-L01, JL RIAU NO 58 PEKANBARU 28514, RIAU', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '0761-868858', '', '{}', 'NULL', '101.430134', '0.535442', 9, NULL, 0, 5),
110(848, '1,2,3', '1', 0, 'SS-PLB-001', '', 'SES PALEMBANG SQUARE', 'Jln.Angk 45 Ruko Palembang Square Mall No.R25-C5, Kode POS 30137', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '0711 - 380280', 'samsung.palembangsquare@mynasa.com', '{}', 'NULL', '104.745417', '-2.978917', 9, NULL, 0, 5),
111(849, '1,2,3', '1', 0, 'SS-PLB-002', '', 'SES PALEMBANG ICON', 'Jln POM IX, Lt.2 Unit 53 Kel Lorok Pakjo Kota Palembang, Kode POS 30137', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '0711-5649454', 'samsung.palembangicon@mynasa.com', '{}', 'NULL', '104.745824', '-2.978917', 9, NULL, 0, 5),
112(850, '1,2,3', '1', 0, 'SS-PLB-003', '', 'SES PALEMBANG TRADE CENTER', 'Jln.R.Sukamto Mall Palembang Trade Center Lt.1 No.7 Palembang ', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '0711-382167', 'samsung.palembangsquare@mynasa.com', '{}', 'NULL', '104.761517', '-2.978917', 9, NULL, 0, 5),
113(851, '1,2,3', '1', 0, 'SS-PLB-004', '', 'SES 2 PALEMBANG SQUARE', 'Jln.Angk 45 Ruko Palembang Square Mall No.R25-C5, Kode POS 30137', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '', '', '{}', 'NULL', '104.742412', '-2.978917', 9, NULL, 0, 5),
114(852, '1,2,3', '1', 0, 'SS-PTK-001', '', 'SES A YANI MEGAMALL', 'Lantai 2 (dua) Unit B2-26 & B2-27, Jl. Ahmad Yani, Pontianak 78112', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '', '', '{}', 'NULL', '109.3425039', '-0.0263303', 9, NULL, 0, 5),
115(853, '1,2,3', '1', 0, 'SS-SBY-001', '', 'SES SUN CITY SIDOARJO', 'Sun City Mall , Lt.1 blok B No 29-30, Jl. Pahlawan No.1 Sidoarjo', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '031 - 8077620', 'samsung.suncitysdj@mynasa.com', '{}', 'NULL', '112.71128314', '-7.44906855', 9, NULL, 0, 5),
116(854, '1,2,3', '1', 0, 'SS-SBY-002', '', 'SES GALAXY MALL', 'Galaxy Mall, lantai 3 no 321B, Jlnl.dharma husada indah timur, Surabaya', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '031-5912898', 'samsung.galaxysurabaya@mynasa.com', '{}', 'NULL', '112.71128314', '-7.44906855', 9, NULL, 0, 5),
117(855, '1,2,3', '1', 0, 'SS-SBY-003', '', 'SES TUNJUNGAN PLAZA 6', 'Tunjungan Plaza 6 Lt.3 No.7 Jl. Embong Malang No. 21-31 Surabaya 60261', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '', '', '{}', 'NULL', '112.7382523', '-7.26166587', 9, NULL, 0, 5),
118(856, '1,2,3', '1', 0, 'SS-SLO-001', '', 'SES THE PARK SOLO', 'JL. IR SOEKARNO MADEGONDO GROGOL KABUPATEN SUKOHARJO (THE PARK MALL LANTAI LG)', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '0271-7891207', 'samsung.parksolo@mynasa.com', '{}', 'NULL', '110.8156663', '-7.5989858', 9, NULL, 0, 5),
119(857, '1,2,3', '1', 0, 'SS-SMD-001', '', 'SES SAMARINDA BIG MALL', 'Lt.2. No.20. Jln. Pangeran Untung Suropati No.8', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '0541-4112527', 'samsung.bigmall@mynasa.com', '{}', 'NULL', '117.116038', '-0.526396', 9, NULL, 0, 5),
120(858, '1,2,3', '1', 0, 'SS-SMG-001', '', 'SES DP MALL SEMARANG', 'JL PEMUDA NO 150 DP MALL SEMARANG LANTAI DASAR SAMSUNG STORE DP MALL. Lt LG NO 09-10', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '024- 86578201', 'samsung.dpmall@mynasa.com', '{}', 'NULL', '106.806272', '-6.601951', 9, NULL, 0, 5),
121(859, '1,2,3', '1', 0, 'SS-TGR-001', '', 'SES TANGERANG CITY MALL', 'Jln. Jendral Sudirman Tangerang City Lt.LG A-17 Tangerang.', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-29309850', 'samsung.tangcy@mynasa.com', '{}', 'NULL', '106.72779', '-6.28563', 9, NULL, 0, 5),
122(860, '1,2,3', '1', 0, 'SS-TGR-003', '', 'SES BINTARO X CHANGE', 'JL M.H. Thamrin CBD Area Kav. Blok B7 / 01-06 Bintaro Jaya Sektor 7', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-29864875', 'samsung.bintaro@mynasa.com', '{}', 'NULL', '106.72779', '-6.28563', 9, NULL, 0, 5),
123(861, '1,2,3', '1', 0, 'SS-TGR-004', '', 'SES AEON MALL BSD CITY', 'AEON MAL UNIT LANTAI 3 LOT 3 -12 JL. GRAND BOULEVARD BSD CITY DESA PAGEDANGAN KEC PAGEDANGAN', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-29168321', 'samsung.aeonmall@mynasa.com', '{}', 'NULL', '106.643292', '-6.305355', 9, NULL, 0, 5),
124(862, '1,2,3', '1', 0, 'SS-TGR-005', '', 'SES SUMMARECON MALL SERPONG', 'Jalan boulevard gading Serpong kelapa dua Tangerang Lt GF no 22', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '021-29310464', 'samsung.sms@mynasa.com', '{}', 'NULL', '106.6285', '-6.24111', 9, NULL, 0, 5),
125(863, '1,2,3', '1', 0, 'SS-YKT-001', '', 'SES JOGJA CITY MALL', 'Jl.Magelang Km.5,8 No.18, Lt.1 Unit 22, Sinduadi, Mlati, Sleman, Daerah Istimewa Yogyakata 55284 ', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '0274-6429224', 'samsung.jogjacity@mynasa.com', '{}', 'NULL', '110.3583607', '-7.7534809', 9, NULL, 0, 5),
126(864, '1,2,3', '1', 0, 'SS-YKT-002', '', 'SES MAL MALIOBORO', 'MALIOBORO MALL LT UG-20C YOGYAKARTA 55213', 'NULL', 'JAKARTA', 'ID-JK', '11000', 'ID', '0274-588059', 'samsung.malioboro@mynasa.com', '{}', 'NULL', '110.3638713', '-7.7930927', 9, NULL, 0, 5);
127
128-- 2019-03-11 06:18:12