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