one more alter statement

2026-10-28 04:22:51 -04:00 · 2026-03-05 20:19:30 -05:00
3 changed files with 18 additions and 0 deletions
@@ -0,0 +1,7 @@
+-- noinspection SqlDialectInspectionForFile
+-- noinspection SqlNoDataSourceInspectionForFile
+-- noinspection SqlResolveForFile
+
+ALTER TABLE web_referrals
+DROP COLUMN ip_address,
+DROP COLUMN anonymous_visitor_token;
@@ -0,0 +1,7 @@
+-- noinspection SqlDialectInspectionForFile
+-- noinspection SqlNoDataSourceInspectionForFile
+-- noinspection SqlResolveForFile
+
+ALTER TABLE web_referrals
+ADD COLUMN ip_address VARCHAR(40) NOT NULL,
+ADD COLUMN anonymous_visitor_token VARCHAR(32) DEFAULT NULL;
@@ -19,6 +19,10 @@ CREATE TABLE web_referrals (

  utm_campaign VARCHAR(255) DEFAULT NULL,

+  ip_address VARCHAR(40) NOT NULL,
+
+  anonymous_visitor_token VARCHAR(32) DEFAULT NULL,
+
  created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

  -- ========== INDICES ==========