From 14ebd9ea76cbccc85386aa560f56ba1ce577f5ff Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Thu, 15 Jun 2017 13:54:52 -0400
Subject: [PATCH] Update one more for primary key issues

Updating the cache table primary key to be not null.
---
 setup/databaseScripts/create_database_V1.1.31.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/setup/databaseScripts/create_database_V1.1.31.sql b/setup/databaseScripts/create_database_V1.1.31.sql
index 108162de..8317b40f 100644
--- a/setup/databaseScripts/create_database_V1.1.31.sql
+++ b/setup/databaseScripts/create_database_V1.1.31.sql
@@ -591,7 +591,7 @@ INSERT INTO {prefix}settings_terms
 -- Shortcode Output Cache
 CREATE TABLE {prefix}cache (
     shortcode TINYTEXT NULL,
-    cache_code TINYTEXT NULL,
+    cache_code TINYTEXT NOT NULL,
     created DATETIME NULL,
     html MEDIUMTEXT NULL,
     PRIMARY KEY (cache_code(20)),
-- 
2.17.1