github.com/oinume/lekcije@v0.0.0-20231017100347-5b4c5eb6ab24/backend/db/migrations/20170218050000_update_datetime_as_utc.sql (about)

     1  -- +goose Up
     2  -- SQL in section 'Up' is executed when this migration is applied
     3  BEGIN;
     4  
     5  UPDATE following_teacher SET
     6    created_at = DATE_ADD(created_at, INTERVAL -9 HOUR),
     7    updated_at = DATE_ADD(updated_at, INTERVAL -9 HOUR);
     8  UPDATE lesson SET
     9      created_at = DATE_ADD(created_at, INTERVAL -9 HOUR),
    10      updated_at = DATE_ADD(updated_at, INTERVAL -9 HOUR);
    11  UPDATE teacher SET
    12      created_at = DATE_ADD(created_at, INTERVAL -9 HOUR),
    13      updated_at = DATE_ADD(updated_at, INTERVAL -9 HOUR);
    14  UPDATE user SET
    15      created_at = DATE_ADD(created_at, INTERVAL -9 HOUR),
    16      updated_at = DATE_ADD(updated_at, INTERVAL -9 HOUR);
    17  UPDATE user_api_token SET
    18      created_at = DATE_ADD(created_at, INTERVAL -9 HOUR),
    19      updated_at = DATE_ADD(updated_at, INTERVAL -9 HOUR);
    20  UPDATE user_google SET
    21      created_at = DATE_ADD(created_at, INTERVAL -9 HOUR),
    22      updated_at = DATE_ADD(updated_at, INTERVAL -9 HOUR);
    23  
    24  COMMIT;
    25  
    26  -- +goose Down
    27  -- SQL section 'Down' is executed when this migration is rolled back
    28  
    29  BEGIN;
    30  
    31  UPDATE following_teacher SET
    32    created_at = DATE_ADD(created_at, INTERVAL 9 HOUR),
    33    updated_at = DATE_ADD(updated_at, INTERVAL 9 HOUR);
    34  UPDATE lesson SET
    35      created_at = DATE_ADD(created_at, INTERVAL 9 HOUR),
    36      updated_at = DATE_ADD(updated_at, INTERVAL 9 HOUR);
    37  UPDATE teacher SET
    38      created_at = DATE_ADD(created_at, INTERVAL 9 HOUR),
    39      updated_at = DATE_ADD(updated_at, INTERVAL 9 HOUR);
    40  UPDATE user SET
    41      created_at = DATE_ADD(created_at, INTERVAL 9 HOUR),
    42      updated_at = DATE_ADD(updated_at, INTERVAL 9 HOUR);
    43  UPDATE user_api_token SET
    44      created_at = DATE_ADD(created_at, INTERVAL 9 HOUR),
    45      updated_at = DATE_ADD(updated_at, INTERVAL 9 HOUR);
    46  UPDATE user_google SET
    47      created_at = DATE_ADD(created_at, INTERVAL 9 HOUR),
    48      updated_at = DATE_ADD(updated_at, INTERVAL 9 HOUR);
    49  
    50  COMMIT;