Ejegg has uploaded a new change for review. https://gerrit.wikimedia.org/r/322218
Change subject: Fix width of timezone column ...................................................................... Fix width of timezone column Match the source table in CiviCRM. We were getting a lot of truncation warnings. Change-Id: I06e137a37b2aa03a3cc0756dc743ad0debde0ecb --- M silverpop_export/update_table.sql 1 file changed, 3 insertions(+), 3 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/tools refs/changes/18/322218/1 diff --git a/silverpop_export/update_table.sql b/silverpop_export/update_table.sql index 06e2e5d..fc0f563 100755 --- a/silverpop_export/update_table.sql +++ b/silverpop_export/update_table.sql @@ -45,7 +45,7 @@ country varchar(2), state varchar(64), postal_code varchar(128), - timezone varchar(5), + timezone varchar(8), INDEX spex_contact_id (contact_id), INDEX spex_email (email), @@ -232,7 +232,7 @@ country varchar(2), state varchar(64), postal_code varchar(128), - timezone varchar(5) + timezone varchar(8) ) COLLATE 'utf8_unicode_ci'; -- (16 minutes) @@ -374,7 +374,7 @@ country varchar(2), state varchar(64), postal_code varchar(128), - timezone varchar(5), + timezone varchar(8), INDEX rspex_contact_id (contact_id), INDEX rspex_email (email), -- To view, visit https://gerrit.wikimedia.org/r/322218 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I06e137a37b2aa03a3cc0756dc743ad0debde0ecb Gerrit-PatchSet: 1 Gerrit-Project: wikimedia/fundraising/tools Gerrit-Branch: master Gerrit-Owner: Ejegg <eeggles...@wikimedia.org> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
