13平台总收入-增加字段.sql 365 B

123456789
  1. -- Active: xiaoding_test@@192.168.110.85@3306@xiaoding_test
  2. /*
  3. 向wallet_trans_records表中添加省份、城市、地区字段
  4. */
  5. ALTER TABLE wallet_trans_records
  6. ADD COLUMN `province` varchar(255) COMMENT '省份' AFTER `state`,
  7. ADD COLUMN `city` varchar(255) COMMENT '城市' AFTER `province`,
  8. ADD COLUMN `district` varchar(255) COMMENT '地区' AFTER `city`;