From 19b0842ceff65e64ab192870455b1955eaf3366f Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Thu, 14 Dec 2017 10:16:30 -0500 Subject: [PATCH] Correct create script Update defaults for boolean and integer fields. --- setup/databaseScripts/create_database_V1.0.1.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/setup/databaseScripts/create_database_V1.0.1.sql b/setup/databaseScripts/create_database_V1.0.1.sql index d43f6b6..2b49609 100644 --- a/setup/databaseScripts/create_database_V1.0.1.sql +++ b/setup/databaseScripts/create_database_V1.0.1.sql @@ -33,9 +33,9 @@ CREATE TABLE {prefix}custom_field_data ( field_id INT NOT NULL DEFAULT 0, -- Pointer to ID of custom_fields table for this field record_id INT NOT NULL DEFAULT 0, -- id for this submission of this form text_data TEXT NOT NULL DEFAULT '', -- Data for a text field - checkbox_data BOOLEAN NOT NULL DEFAULT '', -- Data for a boolean field - integer_data INTEGER NOT NULL DEFAULT '', -- Data for an integer field - float_data FLOAT NOT NULL DEFAULT '', -- Data for a float field + checkbox_data BOOLEAN NOT NULL DEFAULT false, -- Data for a boolean field + integer_data INTEGER NOT NULL DEFAULT 0, -- Data for an integer field + float_data FLOAT NOT NULL DEFAULT '0.00', -- Data for a float field PRIMARY KEY (id), INDEX (field_id), INDEX (record_id) -- 2.17.1