Michael Chus
20309d1f0e
Renamed module path git.mchus.pro/mchus/quoteforge → git.mchus.pro/mchus/priceforge, renamed package quoteforge → priceforge, moved binary from cmd/qfs to cmd/pfs.
8 lines
254 B
SQL
8 lines
254 B
SQL
ALTER TABLE qt_projects
|
|
ADD COLUMN tracker_url VARCHAR(500) NULL AFTER name;
|
|
|
|
UPDATE qt_projects
|
|
SET tracker_url = CONCAT('https://tracker.yandex.ru/', TRIM(name))
|
|
WHERE (tracker_url IS NULL OR tracker_url = '')
|
|
AND TRIM(COALESCE(name, '')) <> '';
|