20180927.sql 649 B

1234567891011121314
  1. -- ----------------------------
  2. -- Table structure for `user_traffic_modify_log`
  3. -- ----------------------------
  4. CREATE TABLE `user_traffic_modify_log` (
  5. `id` INT(11) NOT NULL AUTO_INCREMENT,
  6. `user_id` INT(11) NOT NULL DEFAULT '0' COMMENT '用户ID',
  7. `order_id` INT(11) NOT NULL DEFAULT '0' COMMENT '发生的订单ID',
  8. `before` INT(11) NOT NULL DEFAULT '0',
  9. `after` INT(11) NOT NULL DEFAULT '0',
  10. `desc` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '描述',
  11. `created_at` DATETIME NOT NULL,
  12. `updated_at` DATETIME NOT NULL,
  13. PRIMARY KEY (`id`)
  14. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户流量变动日志';