· 6 years ago · Apr 01, 2019, 11:06 AM
1<?xml version="1.0"?>
2<addon scheme="3.0">
3 <id>my_hartono</id>
4 <version>1.0</version>
5 <priority>10000</priority>
6 <position>0</position>
7 <status>active</status>
8 <has_icon>Y</has_icon>
9 <default_language>en</default_language>
10 <auto_install>MULTIVENDOR,ULTIMATE</auto_install>
11 <queries>
12 <item>DROP TABLE IF EXISTS ?:hartono_home_content;</item>
13 <item>DROP TABLE IF EXISTS ?:hartono_home_content_items;</item>
14 <item>DROP TABLE IF EXISTS ?:hartono_payment_category;</item>
15 <item>DROP TABLE IF EXISTS ?:hartono_shipping_vendor;</item>
16 <item>DROP TABLE IF EXISTS ?:hartono_shipping_vendor_destinations;</item>
17 <item>DROP TABLE IF EXISTS ?:hartono_customer_own_courier;</item>
18 <item>DROP TABLE IF EXISTS ?:hartono_hpc;</item>
19 <item>DROP TABLE IF EXISTS ?:hartono_sales_affiliate</item>
20 <item>DROP TABLE IF EXISTS ?:hartono_payment_doku_references</item>
21 <item>DROP TABLE IF EXISTS ?:hartono_payment_faspay_debit_references</item>
22 <item>DROP TABLE IF EXISTS ?:hartono_locations;</item>
23 <item>DROP TABLE IF EXISTS ?:hartono_store</item>
24 <item>DROP TABLE IF EXISTS ?:hartono_in_store_promo;</item>
25 <item>DROP TABLE IF EXISTS ?:hartono_my_cash</item>
26 <item>DROP TABLE IF EXISTS ?:hartono_my_cash_usage</item>
27 <item>DROP TABLE IF EXISTS ?:hartono_my_voucher</item>
28 <item>DROP TABLE IF EXISTS ?:hartono_my_voucher_usage</item>
29 <item>DROP TABLE IF EXISTS ?:hartono_user_point_reward</item>
30 <item>DROP TABLE IF EXISTS ?:hartono_user_point_and_cash</item>
31 <item>DROP TABLE IF EXISTS ?:hartono_settings;</item>
32 <item>DROP TABLE IF EXISTS ?:hartono_customer_scan;</item>
33 <item>DROP TABLE IF EXISTS ?:hartono_customer_store_visit;</item>
34 <item>DROP TABLE IF EXISTS ?:hartono_product_tenor;</item>
35 <item>DROP TABLE IF EXISTS ?:hartono_mobile_banner;</item>
36 <item>DROP TABLE IF EXISTS ?:hartono_new_so_logs;</item>
37 <item>DROP TABLE IF EXISTS ?:hartono_new_fk_logs;</item>
38 <item>DROP TABLE IF EXISTS ?:hartono_new_fk_failed_logs;</item>
39 <item>DROP TABLE IF EXISTS ?:hartono_sap_master_data_logs;</item>
40 <item>DROP TABLE IF EXISTS ?:hartono_sap_stock_data_logs;</item>
41 <item>DROP TABLE IF EXISTS ?:hartono_hpc_logs;</item>
42 <item>DROP TABLE IF EXISTS ?:hartono_category_mapping;</item>
43 <item>DROP TABLE IF EXISTS ?:hartono_product_promo;</item>
44 <item>DROP TABLE IF EXISTS ?:hartono_push_notification;</item>
45 <item>DROP TABLE IF EXISTS ?:hartono_external_warranty;</item>
46 <item>DROP TABLE IF EXISTS ?:hartono_kecamatan;</item>
47 <item>DROP TABLE IF EXISTS ?:hartono_kelurahan;</item>
48 <item>DROP TABLE IF EXISTS ?:hartono_data_kelurahan;</item>
49 <item>DROP TABLE IF EXISTS ?:hartono_product_characteristic_mapping;</item>
50 <item>DROP TABLE IF EXISTS ?:hartono_sap_article_grouping_log;</item>
51 <item>DROP TABLE IF EXISTS ?:hartono_notification_message_template;</item>
52 <item>DROP TABLE IF EXISTS ?:hartono_sap_product_characteristic_log;</item>
53 <item>DROP TABLE IF EXISTS ?:hartono_bca_virtual_account;</item>
54 <item>DROP TABLE IF EXISTS ?:hartono_bca_va_get_bill_log;</item>
55 <item>DROP TABLE IF EXISTS ?:hartono_bca_va_payment_log;</item>
56 <item>DROP TABLE IF EXISTS ?:hartono_carts;</item>
57 <item>DROP TABLE IF EXISTS ?:hartono_cart_orders;</item>
58 <item>DROP TABLE IF EXISTS ?:hartono_sapmasterdata_sync;</item>
59 <item>DROP TABLE IF EXISTS ?:hartono_saparticlegrouping_sync;</item>
60 <item>DROP TABLE IF EXISTS ?:hartono_sapmyhpc_sync;</item>
61 <item>DROP TABLE IF EXISTS ?:hartono_sappchar_sync;</item>
62 <item>DROP TABLE IF EXISTS ?:hartono_sapstock_sync;</item>
63 <item>DROP TABLE IF EXISTS ?:hartono_product_price_per_store;</item>
64 <item>DROP TABLE IF EXISTS ?:hartono_product_stock_per_store;</item>
65 <item>DROP TABLE IF EXISTS ?:hartono_sappromo_sync;</item>
66 <item>DROP TABLE IF EXISTS ?:hartono_sappromofreeitem_sync;</item>
67 <item>DROP TABLE IF EXISTS ?:hartono_sap_promo_logs;</item>
68 <item>DROP TABLE IF EXISTS ?:hartono_sap_promo_free_item_logs;</item>
69 <item>DROP TABLE IF EXISTS ?:hartono_product_promo_free_item;</item>
70 <item>DROP TABLE IF EXISTS ?:hartono_app_version;</item>
71 <item>DROP TABLE IF EXISTS ?:hartono_insurance_options;</item>
72 <item>DROP TABLE IF EXISTS ?:hartono_insurance_product_link;</item>
73 <item>DROP TABLE IF EXISTS ?:hartono_insurance_variants;</item>
74
75 <item>
76 CREATE TABLE `?:hartono_home_content` (
77 `home_content_id` mediumint(8) unsigned NOT NULL auto_increment,
78 `title` varchar(100) NOT NULL default '',
79 `banner_image_url` varchar(255) default '',
80 `background_image_url` varchar(255) default '',
81 `show_banner_image` tinyint(1),
82 `view_type` varchar(100) NOT NULL default 'LIST',
83 `has_landing_page` tinyint(1) default 0,
84 `category_id` mediumint(8) default 0,
85 `position` smallint(5) NOT NULL default 0,
86 PRIMARY KEY (`home_content_id`)
87 ) Engine=MyISAM DEFAULT CHARSET UTF8;
88 </item>
89 <item>
90 CREATE TABLE `?:hartono_home_content_items` (
91 `id` mediumint(8) unsigned NOT NULL auto_increment,
92 `home_content_id` mediumint(8) unsigned NOT NULL,
93 `product_id` mediumint(8) unsigned default 0,
94 `category_id` mediumint(8) unsigned default 0,
95 `position` smallint(5) NOT NULL default '0',
96 PRIMARY KEY (`id`)
97 ) Engine=MyISAM DEFAULT CHARSET UTF8;
98 </item>
99 <item>
100 CREATE TABLE `?:hartono_home_content_item_products` (
101 `id` mediumint(8) unsigned NOT NULL auto_increment,
102 `home_content_item_id` mediumint(8) unsigned NOT NULL,
103 `product_id` mediumint(8) unsigned NOT NULL,
104 `position` smallint(5) NOT NULL default '0',
105 PRIMARY KEY (`id`)
106 ) Engine=MyISAM DEFAULT CHARSET UTF8;
107 </item>
108 <item>
109 CREATE TABLE `?:hartono_payment_category` (
110 `payment_category_id` mediumint(8) unsigned NOT NULL auto_increment,
111 `name` varchar(100) NOT NULL default '',
112 `value` varchar(100) NOT NULL default '',
113 `position` smallint(5) NOT NULL default '0',
114 PRIMARY KEY (`payment_category_id`)
115 ) Engine=MyISAM DEFAULT CHARSET UTF8;
116 </item>
117 <item>
118 CREATE TABLE `?:hartono_shipping_vendor` (
119 `id` mediumint(8) unsigned NOT NULL auto_increment,
120 `name` varchar(255) NOT NULL default '',
121 `identifier` varchar(50) NOT NULL default '',
122 `api_key` varchar(255) NOT NULL default '',
123 `get_destination_url` varchar(255) NOT NULL default '',
124 `get_rate_url` varchar(255) NOT NULL default '',
125 `additional_data` varchar(500) NOT NULL default '',
126 `use_api` BOOLEAN NOT NULL DEFAULT FALSE,
127 `status` varchar(2) NOT NULL default 'D',
128 PRIMARY KEY (`id`)
129 ) Engine=MyISAM DEFAULT CHARSET UTF8;
130 </item>
131 <item>
132 CREATE TABLE `?:hartono_shipping_vendor_destinations` (
133 `id` mediumint(8) unsigned NOT NULL auto_increment,
134 `shipping_vendor_id` mediumint(8) unsigned NOT NULL,
135 `destination_id` mediumint(8) unsigned NOT NULL,
136 `destination_code` varchar(255) NOT NULL default '',
137 `destination` varchar(255) NOT NULL default '',
138 `rate` DECIMAL NOT NULL DEFAULT '0',
139 PRIMARY KEY (`id`)
140 ) Engine=MyISAM DEFAULT CHARSET UTF8;
141 </item>
142 <item>
143 CREATE TABLE `?:hartono_customer_own_courier` (
144 `id` mediumint(8) unsigned NOT NULL auto_increment,
145 `user_id` mediumint(8) unsigned NOT NULL,
146 `nama_ekspedisi` varchar(100) NOT NULL default '',
147 `alamat_ekspedisi` varchar(255) NOT NULL default '',
148 `phone_number` varchar(20) NOT NULL default '',
149 `pic` varchar(50) NOT NULL default '',
150 `notes` varchar(255) NOT NULL default '',
151 `country_code` VARCHAR(15) NOT NULL DEFAULT '',
152 `state_code` VARCHAR(15) NOT NULL DEFAULT '',
153 `kecamatan_code` VARCHAR(15) NOT NULL DEFAULT '',
154 `kelurahan_code` VARCHAR(15) NOT NULL DEFAULT '',
155 `kelurahan` VARCHAR(255) NOT NULL DEFAULT '',
156 PRIMARY KEY (`id`)
157 ) Engine=MyISAM DEFAULT CHARSET UTF8;
158 </item>
159 <item>
160 CREATE TABLE `?:hartono_hpc` (
161 `id` mediumint(8) unsigned NOT NULL auto_increment,
162 `card_no` varchar(50) NOT NULL UNIQUE,
163 `member_no` varchar(16) NOT NULL DEFAULT '',
164 `user_id` int(11) DEFAULT NULL,
165 `email` varchar(128) NOT NULL DEFAULT '',
166 `place_of_birth` varchar(32) NOT NULL DEFAULT '',
167 `birth_date` int(11) DEFAULT NULL,
168 `id_card_number` varchar(32) NOT NULL DEFAULT '',
169 `member_name` varchar(50) DEFAULT NULL,
170 `address` varchar(255) NOT NULL DEFAULT '',
171 `state` varchar(32) NOT NULL DEFAULT '',
172 `zipcode` varchar(16) NOT NULL,
173 `mobile_phone` varchar(20) DEFAULT NULL,
174 `gender` char(1) NOT NULL DEFAULT 'M',
175 `point` int(11) DEFAULT NULL,
176 `point_redeem` int(11) DEFAULT '0',
177 `get_credit` varchar(2) DEFAULT NULL,
178 `status` char(1) DEFAULT 'D',
179 `create_date` int(11) DEFAULT NULL,
180 `doc_capture` varchar(64) NOT NULL DEFAULT '',
181 PRIMARY KEY (`id`)
182 ) Engine=MyISAM DEFAULT CHARSET UTF8;
183 </item>
184 <item>
185 CREATE TABLE `?:hartono_sales_affiliate` (
186 `sales_id` int(11) NOT NULL AUTO_INCREMENT,
187 `sales_code` varchar(15) NOT NULL DEFAULT '0',
188 `name` varchar(64) NOT NULL DEFAULT '',
189 `brand_id` mediumint(8) NOT NULL DEFAULT '0',
190 `store_code` varchar(5) NOT NULL DEFAULT '',
191 PRIMARY KEY (`sales_id`) USING BTREE,
192 KEY `sales_code` (`sales_code`)
193 ) Engine=MyISAM DEFAULT CHARSET UTF8;
194 </item>
195 <item>
196 CREATE TABLE `?:hartono_payment_doku_references` (
197 `order_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
198 `payment_params` text,
199 `payment_date` int(11),
200 `payment_channel` varchar(32),
201 `total_amount` decimal,
202 `words` text,
203 `notify_response_code` varchar(10),
204 `redirect_response_code` varchar(10),
205 `notify` text NOT NULL,
206 `identify` text NOT NULL,
207 `redirect` text NOT NULL,
208 PRIMARY KEY (`order_id`)
209 ) Engine=MyISAM DEFAULT CHARSET UTF8;
210 </item>
211 <item>
212 CREATE TABLE `?:hartono_payment_faspay_debit_references` (
213 `order_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
214 `payment_params` text,
215 `payment_date` int(11),
216 `payment_channel` varchar(32),
217 `total_amount` decimal,
218 `signature` text,
219 `trx_id` varchar(100),
220 `response_code` varchar(10),
221 `response` text,
222 `notify_response_code` varchar(10),
223 `notify` text NOT NULL,
224 `callback_response_code` varchar(10),
225 `callback` text NOT NULL,
226 PRIMARY KEY (`order_id`)
227 ) Engine=MyISAM DEFAULT CHARSET UTF8;
228 </item>
229 <item>
230 CREATE TABLE `?:hartono_locations` (
231 `location_id` mediumint(8) unsigned NOT NULL auto_increment,
232 `store_name` varchar(100),
233 `address` varchar(255),
234 `opening_hours` varchar(150),
235 `phone` varchar(20),
236 `phone_2` varchar(20),
237 `fax` varchar(20),
238 `service_center` varchar(2),
239 `brand_id` mediumint(8) unsigned NOT NULL,
240 `city` varchar(100),
241 `longitude` float,
242 `latitude` float,
243 `mobile_phone` varchar(100),
244 `mobile_whatsapp` varchar(100),
245 PRIMARY KEY (`location_id`)
246 ) Engine=MyISAM DEFAULT CHARSET UTF8;
247 </item>
248 <item>
249 CREATE TABLE `?:hartono_store` (
250 `store_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
251 `store_code` varchar(5) NOT NULL DEFAULT '',
252 `initial` varchar(5) NOT NULL DEFAULT '',
253 `store` varchar(32) NOT NULL DEFAULT '',
254 `location` int(11) unsigned NOT NULL DEFAULT '0',
255 PRIMARY KEY (`store_id`,`store_code`,`initial`) USING BTREE
256 ) Engine=MyISAM DEFAULT CHARSET UTF8;
257 </item>
258 <item>
259 CREATE TABLE `?:hartono_in_store_promo` (
260 `id` mediumint(8) unsigned NOT NULL auto_increment,
261 `location_id` mediumint(8) unsigned NOT NULL,
262 `title` varchar(100) NOT NULL default '',
263 `banner_image_url` varchar(255) NOT NULL default '',
264 `description` text NOT NULL default '',
265 PRIMARY KEY (`id`)
266 ) Engine=MyISAM DEFAULT CHARSET UTF8;
267 </item>
268 <item>
269 CREATE TABLE `?:hartono_my_cash` (
270 `my_cash_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
271 `user_id` int(11) unsigned NOT NULL DEFAULT '0',
272 `type` varchar(255) NOT NULL default '',
273 `voucher_code` varchar(255) NOT NULL default '',
274 `point_used` int NOT NULL DEFAULT '0',
275 `valid_from` int(11),
276 `valid_to` int(11),
277 `redeemed` tinyint(1),
278 `redemption_date` int(11),
279 `nominal` decimal,
280 `used` tinyint(1),
281 PRIMARY KEY (`my_cash_id`)
282 ) Engine=MyISAM DEFAULT CHARSET UTF8;
283 </item>
284 <item>
285 CREATE TABLE `?:hartono_my_cash_usage` (
286 `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
287 `my_cash_id` int(11) unsigned NOT NULL DEFAULT '0',
288 `order_id` int(11) unsigned NOT NULL DEFAULT '0',
289 `used_date` int(11),
290 PRIMARY KEY (`id`)
291 ) Engine=MyISAM DEFAULT CHARSET UTF8;
292 </item>
293 <item>
294 CREATE TABLE `?:hartono_my_voucher` (
295 `my_voucher_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
296 `user_id` int(11) unsigned NOT NULL DEFAULT '0',
297 `type` varchar(255) NOT NULL default '',
298 `voucher_code` varchar(255) NOT NULL default '',
299 `valid_from` int(11),
300 `valid_to` int(11),
301 `redeemed` tinyint(1),
302 `redemption_date` int(11),
303 `nominal` decimal,
304 `used` tinyint(1),
305 PRIMARY KEY (`my_voucher_id`)
306 ) Engine=MyISAM DEFAULT CHARSET UTF8;
307 </item>
308 <item>
309 CREATE TABLE `?:hartono_my_voucher_usage` (
310 `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
311 `my_voucher_id` int(11) unsigned NOT NULL DEFAULT '0',
312 `order_id` int(11) unsigned NOT NULL DEFAULT '0',
313 `used_date` int(11),
314 PRIMARY KEY (`id`)
315 ) Engine=MyISAM DEFAULT CHARSET UTF8;
316 </item>
317 <item>
318 CREATE TABLE `?:hartono_user_point_reward` (
319 `point_reward_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
320 `user_id` int(11) unsigned NOT NULL DEFAULT '0',
321 `order_id` int(11) unsigned NOT NULL DEFAULT '0',
322 `order_date` int,
323 `total` decimal,
324 `conversion_rate` float,
325 `point` int,
326 PRIMARY KEY (`point_reward_id`)
327 ) Engine=MyISAM DEFAULT CHARSET UTF8;
328 </item>
329 <item>
330 CREATE TABLE `?:hartono_user_point_and_cash` (
331 `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
332 `user_id` int(11) unsigned NOT NULL DEFAULT '0',
333 `redeemed_point` int,
334 `outstanding_point` int,
335 `my_cash` decimal,
336 PRIMARY KEY (`id`)
337 ) Engine=MyISAM DEFAULT CHARSET UTF8;
338 </item>
339 <item>
340 CREATE TABLE `?:hartono_settings` (
341 `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
342 `setting` varchar(128) NOT NULL UNIQUE,
343 `section` varchar(128) NOT NULL,
344 `sub_section` varchar(64) DEFAULT NULL,
345 `type` varchar(64) DEFAULT 'input',
346 `value` text,
347 PRIMARY KEY (`id`, `setting`)
348 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
349
350 </item>
351 <item>
352 CREATE TABLE `?:hartono_customer_scan` (
353 `id` int(11) NOT NULL AUTO_INCREMENT,
354 `scan_id` varchar(50) NOT NULL default '',
355 `created_date` int(11) NOT NULL default 0,
356 `customer_id` varchar(50) NOT NULL default '',
357 `customer_name` varchar(255) NOT NULL default '',
358 `store_id` varchar(50) NOT NULL default 0,
359 `store_name` varchar(255) NOT NULL default '',
360 `area_id` varchar(50) NOT NULL default '',
361 `area_name` varchar(255) NOT NULL default '',
362 `sales_id` varchar(50) NOT NULL default '',
363 `sales_name` varchar(255) NOT NULL default '',
364 `status` varchar(50) NOT NULL COMMENT 'opened, sales_accepted, sales_met, finished, completed, failed, cs_called, user_canceled',
365 `time_out_duration` int(11) NOT NULL default 0,
366 `sales_accepted_date` int(11) NOT NULL default 0,
367 `sales_met_date` int(11) NOT NULL default 0,
368 `finished_date` int(11) NOT NULL default 0,
369 `completed_date` int(11) NOT NULL default 0,
370 `failed_date` int(11) NOT NULL default 0,
371 `cs_called_date` int(11) NOT NULL default 0,
372 `user_cancelled_date` int(11) NOT NULL default 0,
373 `user_met_cancelled_date` int(11) NOT NULL default 0,
374 `sales_met_cancelled_date` int(11) NOT NULL default 0,
375 `cancelled_reason` varchar(255) NOT NULL default '',
376 `rating` int(1) NOT NULL default 0,
377 `feedback` varchar(255) NOT NULL default '',
378 PRIMARY KEY (`id`)
379 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
380 </item>
381 <item>
382 CREATE TABLE `?:hartono_customer_store_visit` (
383 `id` int(11) NOT NULL AUTO_INCREMENT,
384 `store_visit_id` varchar(50) NOT NULL default '',
385 `created_date` int(11) NOT NULL default 0,
386 `customer_id` varchar(50) NOT NULL default '',
387 `customer_name` varchar(255) NOT NULL default '',
388 `store_id` varchar(50) NOT NULL default 0,
389 `store_name` varchar(255) NOT NULL default '',
390 `sales_id` varchar(50) NOT NULL default '',
391 `sales_name` varchar(255) NOT NULL default '',
392 `status` varchar(50) NOT NULL,
393 `time_out_duration` int(11) NOT NULL default 0,
394 `toleration_duration` int(11) NOT NULL default 0,
395 `sales_accepted_date` int(11) NOT NULL default 0,
396 `sales_met_date` int(11) NOT NULL default 0,
397 `finished_date` int(11) NOT NULL default 0,
398 `completed_date` int(11) NOT NULL default 0,
399 `failed_date` int(11) NOT NULL default 0,
400 `cs_called_date` int(11) NOT NULL default 0,
401 `customer_not_coming_date` int(11) NOT NULL default 0,
402 `rating` int(1) NOT NULL default 0,
403 `feedback` varchar(255) NOT NULL default '',
404 PRIMARY KEY (`id`)
405 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
406 </item>
407 <item>
408 CREATE TABLE `?:hartono_product_tenor` (
409 `id` mediumint(8) unsigned NOT NULL auto_increment,
410 `product_id` mediumint(8) unsigned NOT NULL,
411 `payment_id` mediumint(8) unsigned NOT NULL,
412 `tenor` int DEFAULT 0,
413 PRIMARY KEY (`id`)
414 ) Engine=MyISAM DEFAULT CHARSET UTF8;
415 </item>
416 <item>
417 CREATE TABLE `?:hartono_mobile_banner` (
418 `id` mediumint(8) unsigned NOT NULL auto_increment,
419 `type` varchar(10) NOT NULL default '',
420 `title` varchar(255)default '',
421 `banner_image_url` varchar(255) default '',
422 `description` varchar(1000) default '',
423 `available_from` int(11),
424 `available_to` int(11),
425 `qrcode_url` varchar(255) default '',
426 `product_id` mediumint(8) unsigned NOT NULL,
427 `category_id` mediumint(8) unsigned NOT NULL,
428 `position` smallint(5) NOT NULL default 0,
429 PRIMARY KEY (`id`)
430 ) Engine=MyISAM DEFAULT CHARSET UTF8;
431 </item>
432 <item>
433 CREATE TABLE `?:hartono_new_so_logs` (
434 `order_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
435 `send_action` varchar(16) NOT NULL DEFAULT '',
436 `post_data` text NOT NULL,
437 `response` text NOT NULL,
438 `send_status` varchar(16) NOT NULL DEFAULT '',
439 `so_number` varchar(32) NOT NULL DEFAULT '',
440 PRIMARY KEY (`order_id`) USING BTREE
441 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
442 </item>
443 <item>
444 CREATE TABLE `?:hartono_new_fk_logs` (
445 `order_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
446 `post_data` text NOT NULL,
447 `response` text NOT NULL,
448 `send_status` varchar(16) NOT NULL DEFAULT '',
449 `fk_number` varchar(32) NOT NULL DEFAULT '',
450 PRIMARY KEY (`order_id`) USING BTREE
451 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
452 </item>
453 <item>
454 CREATE TABLE `?:hartono_new_fk_failed_logs` (
455 `order_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
456 `post_data` text NOT NULL,
457 `response` text NOT NULL,
458 `send_status` varchar(16) NOT NULL DEFAULT '',
459 PRIMARY KEY (`order_id`) USING BTREE
460 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
461
462 </item>
463 <item>
464 CREATE TABLE `?:hartono_sap_master_data_logs` (
465 `log_id` mediumint(11) NOT NULL AUTO_INCREMENT,
466 `created_date` int(11) NOT NULL DEFAULT '0',
467 `success` int NOT NULL DEFAULT '0',
468 `failed` int NOT NULL DEFAULT '0',
469 `total` int NOT NULL DEFAULT '0',
470 `source_file` varchar(500) NOT NULL DEFAULT '',
471 `server_data` TEXT,
472 `failed_data` text,
473 PRIMARY KEY (`log_id`)
474 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
475
476 </item>
477 <item>
478 CREATE TABLE `?:hartono_sap_stock_data_logs` (
479 `log_id` mediumint(11) NOT NULL AUTO_INCREMENT,
480 `created_date` int(11) NOT NULL DEFAULT '0',
481 `success` int NOT NULL DEFAULT '0',
482 `failed` int NOT NULL DEFAULT '0',
483 `total` int NOT NULL DEFAULT '0',
484 `source_file` varchar(500) NOT NULL DEFAULT '',
485 `server_data` TEXT,
486 `failed_data` text,
487 PRIMARY KEY (`log_id`)
488 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
489 </item>
490 <item>
491 CREATE TABLE `?:hartono_hpc_logs` (
492 `log_id` mediumint(11) NOT NULL AUTO_INCREMENT,
493 `created_date` int(11) NOT NULL DEFAULT '0',
494 `success` int NOT NULL DEFAULT '0',
495 `failed` int NOT NULL DEFAULT '0',
496 `total` int NOT NULL DEFAULT '0',
497 `source_file` varchar(500) NOT NULL DEFAULT '',
498 `server_data` TEXT,
499 `failed_data` text,
500 PRIMARY KEY (`log_id`)
501 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
502
503 </item>
504 <item>
505 CREATE TABLE `?:hartono_category_mapping` (
506 `mapping_id` mediumint(8) NOT NULL AUTO_INCREMENT,
507 `category_id` mediumint(8) NOT NULL,
508 `category_path` varchar(255) NOT NULL,
509 PRIMARY KEY (`mapping_id`)
510 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
511
512 </item>
513 <item>
514 CREATE TABLE `?:hartono_product_promo` (
515 `id` mediumint(11) NOT NULL AUTO_INCREMENT,
516 `kode_promo` varchar(50) NOT NULL DEFAULT '',
517 `nama_promo` varchar(200) NOT NULL DEFAULT '',
518 `kuota_promo` int NOT NULL DEFAULT 0,
519 `member_only` varchar(2) NOT NULL DEFAULT '',
520 `from_date` int(11) NOT NULL DEFAULT 0,
521 `to_date` int(11) NOT NULL DEFAULT 0,
522 `status` varchar(10) NOT NULL DEFAULT '',
523 `kode_barang_utama` varchar(32) NOT NULL DEFAULT '',
524 `potongan_vpr` decimal NOT NULL DEFAULT 0,
525 `jenis_nilai` varchar(5) NOT NULL DEFAULT '',
526 `store_code` varchar(5) NOT NULL DEFAULT '',
527 PRIMARY KEY (`id`)
528 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
529
530 </item>
531 <item>
532 CREATE TABLE `?:hartono_push_notification` (
533 `id` mediumint(8) NOT NULL AUTO_INCREMENT,
534 `category` varchar(32) NOT NULL DEFAULT '',
535 `type` varchar(32) NOT NULL DEFAULT '',
536 `type_id` mediumint(8) NOT NULL DEFAULT '0',
537 `user_id` mediumint(8) NOT NULL DEFAULT '0',
538 `title` varchar(100) NOT NULL DEFAULT '',
539 `message` varchar(255) NOT NULL DEFAULT '',
540 `message_template` varchar(100) NOT NULL DEFAULT '',
541 `created_date` int(11),
542 `thumbnail` varchar(255) NOT NULL DEFAULT '',
543 `read` varchar(1) NOT NULL DEFAULT 'N',
544 PRIMARY KEY (`id`)
545 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
546 </item>
547 <item>
548 CREATE TABLE `?:hartono_external_warranty` (
549 `id` int(8) NOT NULL AUTO_INCREMENT,
550 `invoice_number` varchar(20) NOT NULL,
551 `barcode_number` varchar(30) DEFAULT NULL,
552 `full_name` varchar(100) NOT NULL,
553 `phone` varchar(20) NOT NULL,
554 `no_ktp` varchar(20) NOT NULL,
555 `kronologis` text,
556 `kerusakan` varchar(255),
557 `noseri` varchar(255),
558 `kartu_garansi` varchar(255),
559 `lokasi_kejadian` varchar(255),
560 `box_kelengkapan` varchar(255),
561 `ktp` varchar(255),
562 `surat_kehilangan` varchar(255) NOT NULL,
563 `surat_estimasi` varchar(255) NOT NULL,
564 `status` char(10) NOT NULL,
565 `user_id` int(11) NOT NULL,
566 `resiko` text,
567 `reason` text,
568 `voucher_type` varchar(50) DEFAULT NULL,
569 `created_date` int(11) DEFAULT NULL,
570 PRIMARY KEY (`id`)
571 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
572 </item>
573 <item>
574 CREATE TABLE `?:hartono_kecamatan` (
575 `kecamatan_id` mediumint(10) NOT NULL AUTO_INCREMENT,
576 `country_code` varchar(50) NOT NULL,
577 `state_code` varchar(50) NOT NULL,
578 `state_id` mediumint(8) NOT NULL,
579 `kecamatan_code` varchar(10) NOT NULL,
580 `kecamatan` varchar(255) NOT NULL,
581 PRIMARY KEY (`kecamatan_id`),
582 KEY `kecamatan_code` (`kecamatan_code`),
583 KEY `country_code` (`country_code`)
584 ) ENGINE=InnoDB AUTO_INCREMENT=3104 DEFAULT CHARSET=latin1;
585 </item>
586 <item>
587 CREATE TABLE `?:hartono_kelurahan` (
588 `kelurahan_id` mediumint(10) NOT NULL AUTO_INCREMENT,
589 `country_code` varchar(50) NOT NULL,
590 `state_code` varchar(50) NOT NULL,
591 `kecamatan_code` varchar(10) NOT NULL,
592 `code` varchar(10) NOT NULL,
593 `kelurahan` varchar(255) NOT NULL,
594 `kode_pos` mediumint(11) NOT NULL,
595 `so_code` varchar(50) NOT NULL,
596 PRIMARY KEY (`kelurahan_id`),
597 KEY `kecamatan_code` (`kecamatan_code`)
598 ) ENGINE=InnoDB AUTO_INCREMENT=34529 DEFAULT CHARSET=latin1;
599 </item>
600 <item>
601 CREATE TABLE `?:hartono_data_kelurahan` (
602 `kode_kelurahan` varchar(30) NOT NULL,
603 `nama_kelurahan` varchar(255) NOT NULL,
604 `kode_kota` varchar(30) NOT NULL,
605 PRIMARY KEY (`kode_kelurahan`)
606 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
607
608 </item>
609 <item>
610 CREATE TABLE `?:hartono_product_characteristic_mapping` (
611 `kode_barang` varchar(100) NOT NULL,
612 `characteristic` varchar(100) NOT NULL,
613 `characteristic_desc` varchar(100) DEFAULT NULL,
614 `characteristic_value` varchar(100) NOT NULL,
615 `characteristic_value_desc` varchar(100) NOT NULL,
616 `show` INT(1) NULL DEFAULT '1'
617 PRIMARY KEY (`kode_barang`,`characteristic`)
618 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
619 </item>
620 <item>
621 CREATE TABLE `?:hartono_sap_article_grouping_log` (
622 `log_id` mediumint(11) NOT NULL AUTO_INCREMENT,
623 `created_date` int(11) NOT NULL DEFAULT '0',
624 `success` int NOT NULL DEFAULT '0',
625 `failed` int NOT NULL DEFAULT '0',
626 `total` int NOT NULL DEFAULT '0',
627 `source_file` varchar(500) NOT NULL DEFAULT '',
628 `failed_data` text,
629 PRIMARY KEY (`log_id`)
630 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
631 </item>
632 <item>
633 CREATE TABLE `?:hartono_notification_message_template` (
634 `message_template` varchar(100) NOT NULL,
635 `category` varchar(32) NOT NULL DEFAULT '',
636 `type` varchar(32) NOT NULL DEFAULT '',
637 `title` varchar(100) NOT NULL DEFAULT '',
638 `message` varchar(255) NOT NULL DEFAULT '',
639 `thumbnail` varchar(255) NOT NULL DEFAULT '',
640 PRIMARY KEY (`message_template`)
641 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
642 </item>
643 <item>
644 CREATE TABLE `?:hartono_sap_product_characteristic_log` (
645 `log_id` mediumint(11) NOT NULL AUTO_INCREMENT,
646 `created_date` int(11) NOT NULL DEFAULT '0',
647 `success` int NOT NULL DEFAULT '0',
648 `failed` int NOT NULL DEFAULT '0',
649 `total` int NOT NULL DEFAULT '0',
650 `source_file` varchar(500) NOT NULL DEFAULT '',
651 `failed_data` text,
652 PRIMARY KEY (`log_id`)
653 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
654 </item>
655 <item>
656 CREATE TABLE `?:hartono_bca_virtual_account` (
657 `id` mediumint(8) unsigned NOT NULL auto_increment,
658 `va_number` varchar(255) NOT NULL DEFAULT '',
659 `user_id` mediumint(8) default 0,
660 PRIMARY KEY (`id`)
661 ) Engine=MyISAM DEFAULT CHARSET UTF8;
662 </item>
663 <item>
664 CREATE TABLE `?:hartono_bca_va_get_bill_log` (
665 `id` mediumint(8) unsigned NOT NULL auto_increment,
666 `cart_id` mediumint(8) default 0,
667 `company_code` varchar(255) NOT NULL DEFAULT '',
668 `customer_number` varchar(255) NOT NULL DEFAULT '',
669 `request_id` varchar(255) NOT NULL DEFAULT '',
670 `channel_type` varchar(255) NOT NULL DEFAULT '',
671 `transaction_date` varchar(255) NOT NULL DEFAULT '',
672 `additional_data` varchar(999) NOT NULL DEFAULT '',
673 PRIMARY KEY (`id`)
674 ) Engine=MyISAM DEFAULT CHARSET UTF8;
675 </item>
676 <item>
677 CREATE TABLE `?:hartono_bca_va_payment_log` (
678 `id` mediumint(8) unsigned NOT NULL auto_increment,
679 `cart_id` mediumint(8) default 0,
680 `company_code` varchar(255) NOT NULL DEFAULT '',
681 `customer_number` varchar(255) NOT NULL DEFAULT '',
682 `request_id` varchar(255) NOT NULL DEFAULT '',
683 `channel_type` varchar(255) NOT NULL DEFAULT '',
684 `customer_name` varchar(255) NOT NULL DEFAULT '',
685 `currency_code` varchar(255) NOT NULL DEFAULT '',
686 `paid_amount` varchar(255) NOT NULL DEFAULT '',
687 `total_amount` varchar(255) NOT NULL DEFAULT '',
688 `sub_company` varchar(255) NOT NULL DEFAULT '',
689 `transaction_date` varchar(255) NOT NULL DEFAULT '',
690 `reference` varchar(255) NOT NULL DEFAULT '',
691 `detail_bills` varchar(255) NOT NULL DEFAULT '',
692 `flag_advice` varchar(255) NOT NULL DEFAULT '',
693 `additional_data` varchar(255) NOT NULL DEFAULT '',
694 `status` varchar(255) NOT NULL DEFAULT '',
695 PRIMARY KEY (`id`)
696 ) Engine=MyISAM DEFAULT CHARSET UTF8;
697 </item>
698 <item>
699 CREATE TABLE `?:hartono_carts` (
700 `cart_id` mediumint(8) unsigned NOT NULL auto_increment,
701 `total` decimal default 0,
702 `payment_id` mediumint(8) default 0,
703 `status` varchar(255) NOT NULL DEFAULT '',
704 PRIMARY KEY (`cart_id`)
705 ) Engine=MyISAM DEFAULT CHARSET UTF8;
706 </item>
707 <item>
708 CREATE TABLE `?:hartono_cart_orders` (
709 `id` mediumint(8) unsigned NOT NULL auto_increment,
710 `cart_id` mediumint(8) default 0,
711 `order_id` mediumint(8) default 0
712 PRIMARY KEY (`id`)
713 ) Engine=MyISAM DEFAULT CHARSET UTF8;
714 </item>
715 <item>
716 CREATE TABLE `?:hartono_sapmasterdata_sync` (
717 `id` mediumint(8) unsigned NOT NULL auto_increment,
718 `path` varchar(255) NOT NULL DEFAULT '',
719 `received_date` int(11) NOT NULL default 0,
720 `synced_date` int(11) NOT NULL default 0,
721 `synced` tinyint(1) default 0,
722 PRIMARY KEY (`id`)
723 ) Engine=MyISAM DEFAULT CHARSET UTF8;
724 </item>
725 <item>
726 CREATE TABLE `?:hartono_saparticlegrouping_sync` (
727 `id` mediumint(8) unsigned NOT NULL auto_increment,
728 `path` varchar(255) NOT NULL DEFAULT '',
729 `received_date` int(11) NOT NULL default 0,
730 `synced_date` int(11) NOT NULL default 0,
731 `synced` tinyint(1) default 0,
732 PRIMARY KEY (`id`)
733 ) Engine=MyISAM DEFAULT CHARSET UTF8;
734 </item>
735 <item>
736 CREATE TABLE `?:hartono_sapmyhpc_sync` (
737 `id` mediumint(8) unsigned NOT NULL auto_increment,
738 `path` varchar(255) NOT NULL DEFAULT '',
739 `received_date` int(11) NOT NULL default 0,
740 `synced_date` int(11) NOT NULL default 0,
741 `synced` tinyint(1) default 0,
742 PRIMARY KEY (`id`)
743 ) Engine=MyISAM DEFAULT CHARSET UTF8;
744 </item>
745 <item>
746 CREATE TABLE `?:hartono_sappchar_sync` (
747 `id` mediumint(8) unsigned NOT NULL auto_increment,
748 `path` varchar(255) NOT NULL DEFAULT '',
749 `received_date` int(11) NOT NULL default 0,
750 `synced_date` int(11) NOT NULL default 0,
751 `synced` tinyint(1) default 0,
752 PRIMARY KEY (`id`)
753 ) Engine=MyISAM DEFAULT CHARSET UTF8;
754 </item>
755 <item>
756 CREATE TABLE `?:hartono_sapstock_sync` (
757 `id` mediumint(8) unsigned NOT NULL auto_increment,
758 `path` varchar(255) NOT NULL DEFAULT '',
759 `received_date` int(11) NOT NULL default 0,
760 `synced_date` int(11) NOT NULL default 0,
761 `synced` tinyint(1) default 0,
762 PRIMARY KEY (`id`)
763 ) Engine=MyISAM DEFAULT CHARSET UTF8;
764 </item>
765 <item>
766 CREATE TABLE `?:hartono_product_price_per_store` (
767 `id` mediumint(8) unsigned NOT NULL auto_increment,
768 `product_id` mediumint(8) unsigned NOT NULL DEFAULT 0,
769 `product_code` varchar(64) NOT NULL DEFAULT '',
770 `price` decimal NOT NULL default 0,
771 `store_code` varchar(5) NOT NULL default '',
772 PRIMARY KEY (`id`)
773 ) Engine=MyISAM DEFAULT CHARSET UTF8;
774 </item>
775 <item>
776 CREATE TABLE `?:hartono_product_stock_per_store` (
777 `id` mediumint(8) unsigned NOT NULL auto_increment,
778 `product_code` varchar(64) NOT NULL DEFAULT '',
779 `in_stock_display` mediumint(8) NOT NULL DEFAULT 0,
780 `in_stock_gudang` mediumint(8) NOT NULL DEFAULT 0,
781 `store_code` varchar(5) NOT NULL default '',
782 PRIMARY KEY (`id`)
783 ) Engine=MyISAM DEFAULT CHARSET UTF8;
784 </item>
785 <item>
786 CREATE TABLE `?:hartono_sappromo_sync` (
787 `id` mediumint(8) unsigned NOT NULL auto_increment,
788 `path` varchar(255) NOT NULL DEFAULT '',
789 `received_date` int(11) NOT NULL default 0,
790 `synced_date` int(11) NOT NULL default 0,
791 `synced` tinyint(1) default 0,
792 PRIMARY KEY (`id`)
793 ) Engine=MyISAM DEFAULT CHARSET UTF8;
794 </item>
795 <item>
796 CREATE TABLE `?:hartono_sappromofreeitem_sync` (
797 `id` mediumint(8) unsigned NOT NULL auto_increment,
798 `path` varchar(255) NOT NULL DEFAULT '',
799 `received_date` int(11) NOT NULL default 0,
800 `synced_date` int(11) NOT NULL default 0,
801 `synced` tinyint(1) default 0,
802 PRIMARY KEY (`id`)
803 ) Engine=MyISAM DEFAULT CHARSET UTF8;
804 </item>
805 <item>
806 CREATE TABLE `?:hartono_sap_promo_logs` (
807 `log_id` mediumint(11) NOT NULL AUTO_INCREMENT,
808 `created_date` int(11) NOT NULL DEFAULT '0',
809 `success` int NOT NULL DEFAULT '0',
810 `failed` int NOT NULL DEFAULT '0',
811 `total` int NOT NULL DEFAULT '0',
812 `source_file` varchar(500) NOT NULL DEFAULT '',
813 `server_data` TEXT,
814 `failed_data` text,
815 PRIMARY KEY (`log_id`)
816 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
817
818 </item>
819 <item>
820 CREATE TABLE `?:hartono_sap_promo_free_item_logs` (
821 `log_id` mediumint(11) NOT NULL AUTO_INCREMENT,
822 `created_date` int(11) NOT NULL DEFAULT '0',
823 `success` int NOT NULL DEFAULT '0',
824 `failed` int NOT NULL DEFAULT '0',
825 `total` int NOT NULL DEFAULT '0',
826 `source_file` varchar(500) NOT NULL DEFAULT '',
827 `server_data` TEXT,
828 `failed_data` text,
829 PRIMARY KEY (`log_id`)
830 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
831
832 </item>
833 <item>
834 CREATE TABLE `?:hartono_product_promo_free_item` (
835 `id` mediumint(11) NOT NULL AUTO_INCREMENT,
836 `promo_id` mediumint(11) NOT NULL DEFAULT 0,
837 `kode_barang_free` varchar(32) NOT NULL DEFAULT '',
838 `qty_barang_free` int NOT NULL DEFAULT 0,
839 PRIMARY KEY (`id`)
840 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
841
842 </item>
843 <item>
844 CREATE TABLE `?:hartono_app_version` (
845 `id` mediumint(8) NOT NULL auto_increment,
846 `link varchar(255) NOT NULL,
847 `message` varchar(255) NOT NULL,
848 `version` varchar(10) NOT NULL,
849 `type` varchar(100) NOT NULL,
850 PRIMARY KEY (`id`)
851 ) Engine=MyISAM DEFAULT CHARSET UTF8;
852 </item>
853 <item>
854 CREATE TABLE `?:hartono_insurance_options` (
855 `option_id` mediumint(8) NOT NULL AUTO_INCREMENT,
856 `company_id` int(11) NOT NULL DEFAULT '0',
857 `option_name` varchar(255) NOT NULL,
858 `internal_name` varchar(255) NOT NULL,
859 `description` mediumtext NOT NULL,
860 `comment` varchar(255) NOT NULL,
861 `status` char(1) NOT NULL DEFAULT 'A',
862 PRIMARY KEY (`option_id`)
863 ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
864 </item>
865 <item>
866 CREATE TABLE `?:hartono_insurance_product_link` (
867 `option_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
868 `product_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
869 PRIMARY KEY (`product_id`) USING BTREE,
870 KEY `option_id` (`option_id`) USING BTREE
871 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
872 </item>
873 <item>
874 CREATE TABLE `?:hartono_insurance_variants` (
875 `variant_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
876 `option_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
877 `position` smallint(5) unsigned NOT NULL DEFAULT '0',
878 `variant_name` varchar(255) NOT NULL,
879 `modifier` decimal(13,3) NOT NULL DEFAULT '0.000',
880 `status` char(1) NOT NULL DEFAULT 'A',
881 `modifier_type` char(1) NOT NULL DEFAULT 'A',
882 `so_code` varchar(50) NOT NULL,
883 PRIMARY KEY (`variant_id`),
884 KEY `variant_id` (`variant_id`,`option_id`,`position`)
885 ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;
886 </item>
887
888
889 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_home_content;</item>
890 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_home_content_items;</item>
891 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_payment_category;</item>
892 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_shipping_vendor;</item>
893 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_shipping_vendor_destinations;</item>
894 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_customer_own_courier;</item>
895 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_locations;</item>
896 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_hpc;</item>
897 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_in_store_promo;</item>
898 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_sales_affiliate</item>
899 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_payment_doku_references</item>
900 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_payment_faspay_debit_references</item>
901 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_store</item>
902 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_my_cash</item>
903 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_my_cash_usage</item>
904 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_my_voucher</item>
905 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_my_voucher_usage</item>
906 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_user_point_reward</item>
907 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_user_point_and_cash</item>
908 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_settings;</item>
909 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_customer_scan;</item>
910 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_customer_store_visit;</item>
911 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_product_tenor;</item>
912 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_mobile_banner;</item>
913 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_new_so_logs;</item>
914 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_new_fk_logs;</item>
915 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_new_fk_failed_logs;</item>
916 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_sap_master_data_logs;</item>
917 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_sap_stock_data_logs;</item>
918 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_hpc_logs;</item>
919 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_category_mapping;</item>
920 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_product_promo;</item>
921 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_push_notification;</item>
922 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_external_warranty;</item>
923 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_kecamatan;</item>
924 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_kelurahan;</item>
925 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_data_kelurahan;</item>
926 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_product_characteristic_mapping;</item>
927 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_sap_article_grouping_log;</item>
928 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_notification_message_template;</item>
929 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_sap_product_characteristic_log;</item>
930 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_bca_va_get_bill_log;</item>
931 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_bca_va_payment_log;</item>
932 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_cart_orders;</item>
933 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_carts;</item>
934 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_cart_orders;</item>
935 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_sapmasterdata_sync;</item>
936 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_saparticlegrouping_sync;</item>
937 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_sapmyhpc_sync;</item>
938 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_sappchar_sync;</item>
939 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_sapstock_sync;</item>
940 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_product_price_per_store;</item>
941 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_product_stock_per_store;</item>
942 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_sappromo_sync;</item>
943 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_sappromofreeitem_sync;</item>
944 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_sap_promo_logs;</item>
945 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_sap_promo_free_item_logs;</item>
946 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_product_promo_free_item;</item>
947 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_app_version;</item>
948 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_insurance_options</item>
949 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_insurance_product_link;</item>
950 <item for="uninstall">DROP TABLE IF EXISTS ?:hartono_insurance_variants;</item>
951
952 <item>ALTER TABLE `?:countries` CHANGE `code` `code` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''</item>
953 <item>ALTER TABLE `?:country_descriptions` CHANGE `code` `code` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''</item>
954 <item>ALTER TABLE `?:states` CHANGE `code` `code` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''</item>
955 <item>ALTER TABLE `?:states` CHANGE `country_code` `country_code` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''</item>
956 <item>ALTER TABLE `?:destination_elements` CHANGE `element` `element` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';</item>
957
958 <item>ALTER TABLE `?:user_profiles` CHANGE `b_country` `b_country` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''</item>
959 <item>ALTER TABLE `?:user_profiles` CHANGE `b_state` `b_state` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''</item>
960 <item>ALTER TABLE `?:user_profiles` CHANGE `s_country` `s_country` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''</item>
961 <item>ALTER TABLE `?:user_profiles` CHANGE `s_state` `s_state` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''</item>
962
963
964 <item>ALTER TABLE `?:orders` ADD `shipping_notes` varchar(255) NOT NULL default ''</item>
965 <item>ALTER TABLE `?:orders` ADD `pickup_store_date` int(11)</item>
966 <item>ALTER TABLE `?:orders` ADD `my_cash_total` int default 0</item>
967 <item>ALTER TABLE `?:orders` ADD `my_voucher_total` int default 0</item>
968 <item>ALTER TABLE `?:orders` ADD `uniquecode` int(3) default 0</item>
969 <item>ALTER TABLE `?:shippings` ADD `type` VARCHAR(50) default 'ekspedisi'</item>
970 <item>ALTER TABLE `?:shippings` ADD `vendor_id` mediumint(8) unsigned default 0</item>
971 <item>ALTER TABLE `?:shippings` ADD `identifier` varchar(50) NOT NULL default ''</item>
972 <item>ALTER TABLE `?:shipping_rates` ADD `simple_rate` decimal NOT NULL default 0</item>
973
974 <item>ALTER TABLE `?:product_option_variants` ADD `discount_modifier` decimal NOT NULL default 0</item>
975 <item>ALTER TABLE `?:payments` ADD `payment_vendor` VARCHAR(255) NOT NULL;</item>
976 <item>ALTER TABLE `?:payments` ADD `payment_identifier` VARCHAR(255) NOT NULL;</item>
977 <item>ALTER TABLE `?:order_details` ADD `store_id` VARCHAR(255) NOT NULL;</item>
978 <item>ALTER TABLE `?:categories` ADD `used_landing` char(1) NOT NULL DEFAULT 'N'</item>
979 <item>ALTER TABLE `?:product_descriptions` ADD `mobile_description` mediumtext </item>
980
981 <item>ALTER TABLE `?:products`
982 ADD `min_price` decimal(12,2) not null default 0 COMMENT 'max price for product combination',
983 ADD `max_price` decimal(12,2) not null default 0 COMMENT 'min price for product combination',
984 ADD `min_member_price` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '',
985 ADD `max_member_price` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '',
986 ADD `heavy_air` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT 'berat barang untuk pengiriman udara',
987 ADD `feature_comparison` char(1) NOT NULL DEFAULT 'N' COMMENT '',
988 ADD `is_ndd` char(1) NOT NULL COMMENT 'badge status for product with "Next Day Delivery" service',
989 ADD `is_shipping_promo` char(1) NOT NULL DEFAULT 'N' COMMENT '',
990 ADD `is_shipping_pickup` char(1) NOT NULL DEFAULT 'N' COMMENT '',
991 ADD `is_mshipping_promo` char(1) NOT NULL DEFAULT 'N' COMMENT '',
992 ADD `is_mshipping_pickup` char(1) NOT NULL DEFAULT 'N' COMMENT '',
993 ADD `is_negotiate` char(1) NOT NULL COMMENT '',
994 ADD `is_promo` char(1) NOT NULL COMMENT '',
995 ADD `invoice_info` mediumtext COMMENT '',
996 ADD `site_stock` varchar(32) NOT NULL DEFAULT '' COMMENT '',
997 ADD `s_loc` varchar(32) NOT NULL DEFAULT '' COMMENT '',
998 ADD `fitur_unggulan` text;
999 </item>
1000
1001 <item for="uninstall">ALTER TABLE `?:orders` DROP `shipping_notes`</item>
1002 <item for="uninstall">ALTER TABLE `?:orders` DROP `pickup_store_date`</item>
1003 <item for="uninstall">ALTER TABLE `?:orders` DROP `my_cash_total`</item>
1004 <item for="uninstall">ALTER TABLE `?:orders` DROP `my_voucher_total`</item>
1005 <item for="uninstall">ALTER TABLE `?:orders` DROP `uniquecode`</item>
1006 <item for="uninstall">ALTER TABLE `?:shippings` DROP `type`</item>
1007 <item for="uninstall">ALTER TABLE `?:shippings` DROP `vendor_id`</item>
1008 <item for="uninstall">ALTER TABLE `?:shippings` DROP `identifier`</item>
1009 <item for="uninstall">ALTER TABLE `?:shipping_rates` DROP `simple_rate`</item>
1010
1011 <item for="uninstall">ALTER TABLE `?:product_option_variants` DROP `discount_modifier`</item>
1012 <item for="uninstall">ALTER TABLE `?:payments` DROP `payment_vendor`</item>
1013 <item for="uninstall">ALTER TABLE `?:payments` DROP `payment_identifier`</item>
1014 <item for="uninstall">ALTER TABLE `?:order_details` DROP `store_id`</item>
1015 <item for="uninstall">ALTER TABLE `?:categories` DROP `used_landing`</item>
1016 <item for="uninstall">ALTER TABLE `?:product_descriptions` DROP `mobile_description` </item>
1017
1018 <item for="uninstall">
1019 ALTER TABLE `?:products`
1020 DROP `min_price`,
1021 DROP `max_price`,
1022 DROP `min_member_price`,
1023 DROP `max_member_price`,
1024 DROP `heavy_air`,
1025 DROP `feature_comparison`,
1026 DROP `is_ndd` char(1),
1027 DROP `is_shipping_promo`,
1028 DROP `is_shipping_pickup`,
1029 DROP `is_mshipping_promo`,
1030 DROP `is_mshipping_pickup`,
1031 DROP `is_negotiate` char(1),
1032 DROP `is_promo` char(1),
1033 DROP `invoice_info`,
1034 DROP `site_stock`,
1035 DROP `s_loc`,
1036 DROP `fitur_unggulan` text;
1037 </item>
1038
1039 </queries>
1040</addon>