From 58cd322800c0f40ec7d3b1c0b8d213bcc7ca8498 Mon Sep 17 00:00:00 2001 From: Chuck Scott Date: Wed, 24 Feb 2016 09:42:06 -0500 Subject: [PATCH] Fixed errors in database create sql script. --- setup/databaseScripts/create_database_V0.0.1.sql | 8 +++----- 1 file changed, 3 insertions(+), 5 deletions(-) diff --git a/setup/databaseScripts/create_database_V0.0.1.sql b/setup/databaseScripts/create_database_V0.0.1.sql index 257bbd6..763f970 100644 --- a/setup/databaseScripts/create_database_V0.0.1.sql +++ b/setup/databaseScripts/create_database_V0.0.1.sql @@ -47,7 +47,7 @@ CREATE TABLE {prefix}recurrences ( day_of_week TINYINT UNSIGNED NULL, -- Day of the week (bitmap) day_of_month INTEGER UNSIGNED NULL, -- Day of the month (bitmap) holiday INT NULL, -- Pointer to holidays list (for future development) - holiday_offset TINYINT -- Offset from holiday (from -128 to +127 days) + holiday_offset TINYINT, -- Offset from holiday (from -128 to +127 days) PRIMARY KEY (id), INDEX(event) ); @@ -92,8 +92,7 @@ CREATE TABLE {prefix}locations ( contact_lname TINYTEXT NULL, -- Contact last name for this location (optional) contact_phone TINYTEXT NULL, -- Contact phone for this location (optional) contact_email TINYTEXT NULL, -- Contact E-Mail address (optional) - PRIMARY KEY (id), - INDEX(name) + PRIMARY KEY (id) ); ---- @@ -128,6 +127,5 @@ CREATE TABLE {prefix}events ( INDEX(ref_dest), INDEX(featured), INDEX(slideshow), - INDEX(major), - INDEX(name) + INDEX(major) ); -- 2.17.1