2017-03-30.sql 206 B

123456
  1. ALTER TABLE `admin`
  2. add COLUMN `province` int(2) 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;