From 92b59c2a5ca874d58603671b5210422ccc317fff Mon Sep 17 00:00:00 2001 From: Anthony Talarico Date: Thu, 19 Oct 2017 15:20:34 -0400 Subject: [PATCH] fixing default values for the uid in the create db script updating create db script to set the default values and datatypes --- setup/databaseScripts/create_database_V0.0.4.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/setup/databaseScripts/create_database_V0.0.4.sql b/setup/databaseScripts/create_database_V0.0.4.sql index c98235f..a731cd5 100644 --- a/setup/databaseScripts/create_database_V0.0.4.sql +++ b/setup/databaseScripts/create_database_V0.0.4.sql @@ -20,8 +20,8 @@ CREATE TABLE {prefix}custom_fields ( field_order SMALLINT NOT NULL DEFAULT 0, -- Order for Field admin_search BOOLEAN NOT NULL DEFAULT '0', -- If the field is added to member list filters. required BOOLEAN NOT NULL DEFAULT '0', -- If the field is required. - uid TINYTEXT NOT NULL, -- id for the series of custom fields associated with an entity - entity_id INT NOT NULL DEFAULT 0, -- id for the specific field associated with an entity + uid TINYTEXT NOT NULL DEFAULT '', -- id for the series of custom fields associated with an entity + entity_id INT NULL, -- id for the specific field associated with an entity PRIMARY KEY (id), INDEX(field_name(20)) ); -- 2.17.1