update_for_20250507.sql 521 B

1234567891011121314
  1. ALTER TABLE `mt_cart`
  2. CHANGE `NUM` `NUM` DOUBLE (10, 2) DEFAULT 1 NULL COMMENT '数量';
  3. ALTER TABLE `mt_goods`
  4. CHANGE `STOCK` `STOCK` DOUBLE (10, 2) UNSIGNED DEFAULT 0 NULL COMMENT '库存';
  5. ALTER TABLE `mt_goods`
  6. CHANGE `INIT_SALE` `INIT_SALE` DOUBLE (10, 2) DEFAULT 0 NULL COMMENT '初始销量';
  7. ALTER TABLE `mt_goods_sku`
  8. CHANGE `STOCK` `STOCK` DOUBLE (10, 2) DEFAULT 0 NOT NULL COMMENT '库存';
  9. ALTER TABLE `mt_order_goods`
  10. CHANGE `NUM` `NUM` DOUBLE (10, 2) DEFAULT 0 NOT NULL COMMENT '商品数量';