2017-03-30.sql 211 B

123456
  1. ALTER TABLE `admin`
  2. add COLUMN `province` VARCHAR(12) NULL COMMENT '所在省份',
  3. ADD INDEX index_number(number),
  4. MODIFY COLUMN `number` int(6) NOT NULL auto_increment;
  5. ALTER TABLE `admin` auto_increment = 1;