From 963a6a16a500f81a57d3c1b02aacf7307047add7 Mon Sep 17 00:00:00 2001 From: Aleksey Filippov Date: Fri, 29 Mar 2024 23:43:57 +0300 Subject: [PATCH] =?utf8?q?=D0=BC=D0=B8=D0=B3=D1=80=D0=B0=D1=86=D0=B8=D1=8F?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- docker/migrationToPgsql/mysql/command.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/docker/migrationToPgsql/mysql/command.sql b/docker/migrationToPgsql/mysql/command.sql index ab3958d2..e98c63ea 100644 --- a/docker/migrationToPgsql/mysql/command.sql +++ b/docker/migrationToPgsql/mysql/command.sql @@ -163,4 +163,6 @@ UPDATE `moving` SET `date`='1970-01-01 00:00:01' WHERE `date`<'1970-01-01 00:00: UPDATE `store_orders` SET `date_end`='1970-01-01' WHERE `date_end`<'1970-01-01'; UPDATE `store_orders` SET `date_update`='1970-01-01 00:00:01' WHERE `date_update`<'1970-01-01 00:00:01'; -UPDATE `store_orders` SET `delivery_date_fact`='1970-01-01' WHERE `delivery_date_fact`<'1970-01-01'; \ No newline at end of file +UPDATE `store_orders` SET `delivery_date_fact`='1970-01-01' WHERE `delivery_date_fact`<'1970-01-01'; + +UPDATE `users_events` SET `date` = '1970-01-01' WHERE `date` < '1970-01-01' AND `date` IS NOT NULL; \ No newline at end of file -- 2.39.5