6 lines
323 B
SQL
6 lines
323 B
SQL
ALTER TABLE `product`
|
|
ADD COLUMN `app_version` char(50) NOT NULL AFTER `description`,
|
|
ADD COLUMN `product_set` int(5) NOT NULL AFTER `app_version`,
|
|
ADD COLUMN `sort` int(5) NOT NULL AFTER `product_set`;
|
|
|
|
UPDATE configuration set config_value = "1.0.22", date_change=CURRENT_DATE WHERE config_key = "db_version"; |