From 6c87819f1b0e28c98385204454f25b11846ac560 Mon Sep 17 00:00:00 2001 From: Anthony Talarico Date: Thu, 19 Oct 2017 15:22:38 -0400 Subject: [PATCH] fixing data fields default db values fixing default table values for the create and update scripts --- setup/databaseScripts/update_database_V0.0.4.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/setup/databaseScripts/update_database_V0.0.4.sql b/setup/databaseScripts/update_database_V0.0.4.sql index d32183d..ce026b4 100644 --- a/setup/databaseScripts/update_database_V0.0.4.sql +++ b/setup/databaseScripts/update_database_V0.0.4.sql @@ -14,8 +14,8 @@ ALTER TABLE {prefix}custom_fields ADD COLUMN uid TINYTEXT NOT NULL DEFAULT ''; ---- -ALTER TABLE {prefix}custom_field_data ADD COLUMN entity_id INT NOT NULL; +ALTER TABLE {prefix}custom_field_data ADD COLUMN entity_id INT NOT NULL DEFAULT 0; ---- -ALTER TABLE {prefix}custom_fields ADD COLUMN entity_id INT NOT NULL DEFAULT 0; +ALTER TABLE {prefix}custom_fields ADD COLUMN entity_id INT NULL; -- 2.17.1