4 lines
287 B
SQL
4 lines
287 B
SQL
INSERT INTO customer_property (customer_id, property_id, property_value, DATE_ADD)
|
|
SELECT customer_id, 1, weight, NOW() FROM customer WHERE weight IS NOT NULL AND weight != 0;
|
|
|
|
UPDATE configuration set config_value = "1.0.13", date_change=CURRENT_DATE WHERE config_key = "db_version"; |