20171214.sql 355 B

1234
  1. ALTER TABLE `order` ADD COLUMN `goods_id` int NOT NULL DEFAULT 0 COMMENT '商品ID' AFTER `user_id`;
  2. ALTER TABLE `order` ADD COLUMN `expire_at` datetime DEFAULT NULL COMMENT '过期时间' AFTER `totalPrice`;
  3. ALTER TABLE `order` ADD COLUMN `is_expire` tinyint NOT NULL DEFAULT 0 COMMENT '是否已过期:0-未过期、1-已过期' AFTER `expire_at`;