dev-chiefworks
18 lines
981 B
SQL
18 lines
981 B
SQL
-- common
|
|
UPDATE address SET timezone=8 WHERE timezone IS NULL AND country='FR';
|
|
UPDATE address SET timezone=21 WHERE timezone IS NULL AND country='TH';
|
|
UPDATE address SET timezone=24 WHERE timezone IS NULL AND country='UA';
|
|
UPDATE address SET timezone=28 WHERE timezone IS NULL AND country='PL';
|
|
UPDATE address SET timezone=29 WHERE timezone IS NULL AND country='RO';
|
|
UPDATE address SET timezone=34 WHERE timezone IS NULL AND country='DE';
|
|
UPDATE address SET timezone=39 WHERE timezone IS NULL AND country='TW';
|
|
-- development
|
|
UPDATE address SET timezone=289 WHERE timezone IS NULL AND country='VN';
|
|
UPDATE address SET timezone=301 WHERE timezone IS NULL AND country='IN';
|
|
UPDATE address SET timezone=476 WHERE timezone IS NULL AND country='TR';
|
|
-- production
|
|
UPDATE address SET timezone=300 WHERE timezone IS NULL AND country='VN';
|
|
UPDATE address SET timezone=312 WHERE timezone IS NULL AND country='IN';
|
|
UPDATE address SET timezone=487 WHERE timezone IS NULL AND country='TR';
|
|
|