mysql-20191222.sql 203 B

123
  1. ALTER TABLE `device_ports` CHANGE `vlan` `vlan` INT(11) NULL DEFAULT '1';
  2. UPDATE device_ports set vlan=1 where vlan IS NULL;
  3. ALTER TABLE `device_ports` CHANGE `vlan` `vlan` INT(11) NOT NULL DEFAULT '1';