1BEGIN; 2 3ALTER TABLE device_port_vlan ADD COLUMN "egress_tag" boolean not null default true; 4 5UPDATE device_port_vlan SET egress_tag = true; 6 7UPDATE device_port_vlan SET egress_tag = false WHERE native = TRUE; 8 9COMMIT; 10
1BEGIN; 2 3ALTER TABLE device_port_vlan ADD COLUMN "egress_tag" boolean not null default true; 4 5UPDATE device_port_vlan SET egress_tag = true; 6 7UPDATE device_port_vlan SET egress_tag = false WHERE native = TRUE; 8 9COMMIT; 10