salix/db/versions/11172-blueFern/10-firstScript.sql

6 lines
172 B
MySQL
Raw Permalink Normal View History

2024-08-26 12:39:30 +00:00
UPDATE vn.invoiceOut
SET id = (SELECT MAX(id) + 1 FROM vn.invoiceOut)
WHERE id = 0;
ALTER TABLE vn.invoiceOut MODIFY COLUMN id int(10) unsigned auto_increment NOT NULL;