From f3b5ef2390880ef7cf0cf10d1c780965465ee832 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Thu, 15 Jun 2017 13:10:34 -0400 Subject: [PATCH] Update create script to have primary keys not null. Mysql 5.7 is complaining about this. --- setup/databaseScripts/create_database_V1.1.31.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/setup/databaseScripts/create_database_V1.1.31.sql b/setup/databaseScripts/create_database_V1.1.31.sql index 807a9032..d9146e1f 100644 --- a/setup/databaseScripts/create_database_V1.1.31.sql +++ b/setup/databaseScripts/create_database_V1.1.31.sql @@ -98,7 +98,7 @@ 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 NULL, -- ID of member + 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) clicks INT NULL, -- Number of Clicks @@ -173,7 +173,7 @@ 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 NULL, -- ID of member + 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) clicks INT NULL, -- Number of Clicks @@ -596,7 +596,7 @@ CREATE TABLE {prefix}cache ( html MEDIUMTEXT NULL, PRIMARY KEY (cache_code(20)), INDEX (created) -); +); ---- -- 2.17.1