Skip to content
This repository was archived by the owner on May 22, 2025. It is now read-only.

Commit fe42f62

Browse files
Jordie0608Jordie0608
authored
more query fixes
1 parent d48ce42 commit fe42f62

1 file changed

Lines changed: 4 additions & 4 deletions

File tree

‎SQL/optimisations_2017-02-19.sql‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -111,7 +111,7 @@ ALTER TABLE `feedback`.`player`
111111
ADD COLUMN `ipTEMP` INT UNSIGNED NOT NULL AFTER `ip`;
112112
SET SQL_SAFE_UPDATES = 0;
113113
UPDATE `feedback`.`player`
114-
SET `ipTEMP` = COALESCE(NULLIF(INET_ATON(SUBSTRING_INDEX(`ip`, ':', 1)), ''), INET_ATON('0.0.0.0'));
114+
SET `ipTEMP` = COALESCE(NULLIF(INET_ATON(`ip`), ''), INET_ATON('0.0.0.0'));
115115
SET SQL_SAFE_UPDATES = 1;
116116
ALTER TABLE `feedback`.`player`
117117
DROP COLUMN `ip`
@@ -128,7 +128,7 @@ ALTER TABLE `feedback`.`poll_question`
128128
, DROP COLUMN `for_trialmin`;
129129
SET SQL_SAFE_UPDATES = 0;
130130
UPDATE `feedback`.`poll_question`
131-
SET `createdby_ipTEMP` = COALESCE(NULLIF(INET_ATON(SUBSTRING_INDEX(`createdby_ip`, ':', 1)), ''), INET_ATON('0.0.0.0'));
131+
SET `createdby_ipTEMP` = COALESCE(NULLIF(INET_ATON(`ip`), ''), INET_ATON('0.0.0.0'));
132132
SET SQL_SAFE_UPDATES = 1;
133133
ALTER TABLE `feedback`.`poll_question`
134134
DROP COLUMN `createdby_ip`
@@ -141,7 +141,7 @@ ALTER TABLE `feedback`.`poll_textreply`
141141
, ADD COLUMN `ipTEMP` INT UNSIGNED NOT NULL AFTER `ip`;
142142
SET SQL_SAFE_UPDATES = 0;
143143
UPDATE `feedback`.`poll_textreply`
144-
SET `ipTEMP` = COALESCE(NULLIF(INET_ATON(SUBSTRING_INDEX(`ip`, ':', 1)), ''), INET_ATON('0.0.0.0'));
144+
SET `ipTEMP` = COALESCE(NULLIF(INET_ATON(`ip`), ''), INET_ATON('0.0.0.0'));
145145
SET SQL_SAFE_UPDATES = 1;
146146
ALTER TABLE `feedback`.`poll_textreply`
147147
DROP COLUMN `ip`
@@ -154,7 +154,7 @@ ALTER TABLE `feedback`.`poll_vote`
154154
, ADD COLUMN `ipTEMP` INT UNSIGNED NOT NULL AFTER `ip`;
155155
SET SQL_SAFE_UPDATES = 0;
156156
UPDATE `feedback`.`poll_vote`
157-
SET `ipTEMP` = COALESCE(NULLIF(INET_ATON(SUBSTRING_INDEX(`ip`, ':', 1)), ''), INET_ATON('0.0.0.0'));
157+
SET `ipTEMP` = COALESCE(NULLIF(INET_ATON(`ip`), ''), INET_ATON('0.0.0.0'));
158158
SET SQL_SAFE_UPDATES = 1;
159159
ALTER TABLE `feedback`.`poll_vote`
160160
DROP COLUMN `ip`

0 commit comments

Comments
 (0)