From 8324829f4a4b113bf3ba7c2e70da909fba2861a2 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Fri, 28 Oct 2016 11:19:12 -0400 Subject: [PATCH] Update the sql scripts so there's default names. For the singular and plural names to have default of Amenity and Amenities. --- setup/databaseScripts/create_database_V0.1.0.sql | 8 ++++---- setup/databaseScripts/update_database_V0.1.0.sql | 6 +++++- 2 files changed, 9 insertions(+), 5 deletions(-) diff --git a/setup/databaseScripts/create_database_V0.1.0.sql b/setup/databaseScripts/create_database_V0.1.0.sql index e269bce..0b5a33f 100644 --- a/setup/databaseScripts/create_database_V0.1.0.sql +++ b/setup/databaseScripts/create_database_V0.1.0.sql @@ -219,8 +219,8 @@ CREATE TABLE {prefix}management ( to_email TINYTEXT NULL, -- Email address of the recipient from_email TINYTEXT NULL, -- Email address of the sender email_notification TEXT NULL, -- Email notification message - calendar_view TINYTEXT NULL, -- Default calendar view - event_default_state TINYTEXT NULL, -- Default calendar view + calendar_view TINYTEXT NULL, -- Default calendar view + event_default_state TINYTEXT NULL, -- Default calendar view term_event_amenities_singular TINYTEXT NULL, -- Singular term to use for event amenities term_event_amenities_plural TINYTEXT NULL, -- Plural term to use for event amenities use_event_amenities BOOLEAN NULL, -- Whether amenities are used at all for events @@ -231,9 +231,9 @@ CREATE TABLE {prefix}management ( -- Set default event management entry INSERT INTO {prefix}management - ( id, canonical_event_page ) + ( id, canonical_event_page, term_event_amenities_singular, term_event_amenities_plural ) VALUES - ( 1, 'event-detail' ) + ( 1, 'event-detail', 'Amenity', 'Amenities' ) ; ---- diff --git a/setup/databaseScripts/update_database_V0.1.0.sql b/setup/databaseScripts/update_database_V0.1.0.sql index 999d876..e500622 100644 --- a/setup/databaseScripts/update_database_V0.1.0.sql +++ b/setup/databaseScripts/update_database_V0.1.0.sql @@ -15,4 +15,8 @@ ALTER TABLE {prefix}management ADD COLUMN term_event_amenities_plural TINYTEXT N ---- -ALTER TABLE {prefix}management ADD COLUMN use_event_amenities BOOLEAN NULL; -- Whether amenities are used at all for events \ No newline at end of file +ALTER TABLE {prefix}management ADD COLUMN use_event_amenities BOOLEAN NULL; -- Whether amenities are used at all for events + +---- + +UPDATE {prefix}management SET term_event_amenities_singular = 'Amenity', term_event_amenities_plural = 'Amenities' WHERE id = 1; -- 2.17.1