From 14b961de6d5667aa05a2b2f1eeecd0b92279217c Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Thu, 15 Jun 2017 13:49:05 -0400 Subject: [PATCH] One more update for primary key Found another table mysql 5.7 doesn't like. --- 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 bb66a67f..108162de 100644 --- a/setup/databaseScripts/create_database_V1.1.31.sql +++ b/setup/databaseScripts/create_database_V1.1.31.sql @@ -174,8 +174,8 @@ CREATE TABLE {prefix}members ( -- Member Detail Display Stats Data - Totals of times detail page is displayed - Preserved for 2 years CREATE TABLE {prefix}member_detail_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