widen fields

2026-10-22 17:49:30 -04:00 · 2026-03-05 21:30:31 -05:00
4 changed files with 22 additions and 6 deletions
@@ -0,0 +1,8 @@
+-- noinspection SqlDialectInspectionForFile
+-- noinspection SqlNoDataSourceInspectionForFile
+-- noinspection SqlResolveForFile
+
+ALTER TABLE web_referrals
+MODIFY COLUMN utm_source VARCHAR(32) DEFAULT NULL,
+MODIFY COLUMN utm_medium VARCHAR(32) DEFAULT NULL,
+MODIFY COLUMN utm_campaign VARCHAR(255) DEFAULT NULL;
@@ -0,0 +1,8 @@
+-- noinspection SqlDialectInspectionForFile
+-- noinspection SqlNoDataSourceInspectionForFile
+-- noinspection SqlResolveForFile
+
+ALTER TABLE web_referrals
+MODIFY COLUMN utm_source VARCHAR(150) DEFAULT NULL,
+MODIFY COLUMN utm_medium VARCHAR(150) DEFAULT NULL,
+MODIFY COLUMN utm_campaign VARCHAR(150) DEFAULT NULL;
@@ -13,11 +13,11 @@ CREATE TABLE web_referrals (
  -- The parsed out referral domain
  domain VARCHAR(255) DEFAULT NULL,

-  utm_source VARCHAR(32) DEFAULT NULL,
+  utm_source VARCHAR(150) DEFAULT NULL,

-  utm_medium  VARCHAR(32) DEFAULT NULL,
+  utm_medium  VARCHAR(150) DEFAULT NULL,

-  utm_campaign VARCHAR(255) DEFAULT NULL,
+  utm_campaign VARCHAR(150) DEFAULT NULL,

  ip_address VARCHAR(40) NOT NULL,

@@ -91,9 +91,9 @@ pub async fn log_web_referral_handler(
  let avt_token_str = avt_token.to_string();

  // Truncate UTM fields to fit the schema.
-  let utm_source = utm_source.map(|s| s.chars().take(32).collect::<String>());
-  let utm_medium = utm_medium.map(|s| s.chars().take(32).collect::<String>());
-  let utm_campaign = utm_campaign.map(|s| s.chars().take(255).collect::<String>());
+  let utm_source = utm_source.map(|s| s.chars().take(150).collect::<String>());
+  let utm_medium = utm_medium.map(|s| s.chars().take(150).collect::<String>());
+  let utm_campaign = utm_campaign.map(|s| s.chars().take(150).collect::<String>());

  // Insert into the database.
  insert_web_referral(&server_state.mysql_pool, InsertWebReferralArgs {