From 733e3ffc9a8dd73c86900849770214e6f5bae063 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Thu, 15 Jun 2017 13:26:50 -0400 Subject: [PATCH] One for for primary key update Need to get all fields in this primary key --- setup/databaseScripts/create_database_V1.1.31.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/setup/databaseScripts/create_database_V1.1.31.sql b/setup/databaseScripts/create_database_V1.1.31.sql index d9146e1f..bb66a67f 100644 --- a/setup/databaseScripts/create_database_V1.1.31.sql +++ b/setup/databaseScripts/create_database_V1.1.31.sql @@ -99,8 +99,8 @@ CREATE TABLE {prefix}cities ( -- Member Click Through Stats Data - Totals of URL click-throughs - Preserved for 2 years CREATE TABLE {prefix}clickthrough_stats ( member INT NOT NULL, -- ID of member - stat_type INT NULL, -- Type of stat 1 = day, 2 = week, 3 = month - stat_date DATE NULL, -- Date for which these stats are accumulated (date or first date of week or month) + stat_type INT NOT NULL, -- Type of stat 1 = day, 2 = week, 3 = month + stat_date DATE NOT NULL, -- Date for which these stats are accumulated (date or first date of week or month) clicks INT NULL, -- Number of Clicks PRIMARY KEY (member, stat_type, stat_date), INDEX (member), -- 2.17.1