Ghi chú phát triển 4.5.02

ĐỔI KIỂU DỮ LIỆU

ALTER TABLE nv4_shops_block_cat CHANGE adddefault adddefault tinyint(1) NOT NULL DEFAULT '0'

ALTER TABLE nv4_shops_carrier_config_weight CHANGE weight weight double UNSIGNED NOT NULL

ALTER TABLE nv4_shops_carrier_config_weight CHANGE carrier_price carrier_price double NOT NULL

ALTER TABLE nv4_shops_coupons CHANGE discount discount double NOT NULL DEFAULT '0'

ALTER TABLE nv4_shops_coupons CHANGE total_amount total_amount double NOT NULL DEFAULT '0'

ALTER TABLE nv4_shops_coupons_history CHANGE amount amount double NOT NULL DEFAULT '0'

ALTER TABLE nv4_shops_group CHANGE viewgroup viewgroup varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'viewgrid'

ALTER TABLE nv4_shops_orders_id CHANGE price price double NOT NULL DEFAULT '0'

ALTER TABLE nv4_shops_orders_shipping CHANGE weight weight double NOT NULL DEFAULT '0'

ALTER TABLE nv4_shops_orders_shipping CHANGE ship_price ship_price double NOT NULL DEFAULT '0'

ALTER TABLE nv4_shops_rows CHANGE product_price product_price double NOT NULL DEFAULT '0'

ALTER TABLE nv4_shops_rows CHANGE product_weight product_weight double NOT NULL DEFAULT '0'

ALTER TABLE nv4_shops_transaction CHANGE payment_amount payment_amount double NOT NULL DEFAULT '0'

ALTER TABLE nv4_shops_warehouse_logs CHANGE price price double NOT NULL DEFAULT '0'

ALTER TABLE nv4_shops_warehouse_logs_group CHANGE price price double NOT NULL DEFAULT '0'

ALTER TABLE nv4_shops_money_vi CHANGE exchange exchange double NOT NULL DEFAULT '0'

ALTER TABLE nv4_shops_weight_vi CHANGE exchange exchange double NOT NULL DEFAULT '0'

THÊM CẤU HÌNH

INSERT INTO nv4_config (lang, module, config_name, config_value ) VALUES
('vi', 'shops', 'captcha_area_comm', '1'),
('vi', 'shops', 'captcha_type_comm', 'captcha'),
('vi', 'shops', 'captcha_type', 'captcha')