From fd601918d085aa39754d18c4eb04ecae71adc710 Mon Sep 17 00:00:00 2001 From: Laury GvR Date: Wed, 6 Jul 2016 16:01:54 -0400 Subject: [PATCH] Changed database scripts to use right syntax Update scripts were using some wrong syntax for altering tables. --- .../update_database_V1.1.1.sql | 54 +++++++++---------- .../update_database_V1.1.2.sql | 44 +++++++-------- 2 files changed, 47 insertions(+), 51 deletions(-) diff --git a/setup/databaseScripts/update_database_V1.1.1.sql b/setup/databaseScripts/update_database_V1.1.1.sql index 9c385ea..e9cfcf0 100644 --- a/setup/databaseScripts/update_database_V1.1.1.sql +++ b/setup/databaseScripts/update_database_V1.1.1.sql @@ -7,108 +7,108 @@ -- all queries must be separated by a line with four dashses -- Package Management Settings -ALTER TABLE {prefix}packages ADD COLUMN offsite_url TINYTEXT NULL; +ALTER TABLE {prefix}packages ADD offsite_url TINYTEXT NULL; ---- -ALTER TABLE {prefix}management ADD COLUMN package_detail_show_image BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_detail_show_image BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_detail_show_offsite_url BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_detail_show_offsite_url BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_detail_show_offsite_url_newtarget BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_detail_show_offsite_url_newtarget BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_detail_show_member_link BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_detail_show_member_link BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_detail_show_member_link_newtarget BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_detail_show_member_link_newtarget BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_detail_show_member_address BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_detail_show_member_address BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_detail_show_member_street BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_detail_show_member_street BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_detail_show_member_citystatezip BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_detail_show_member_citystatezip BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_detail_show_member_country BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_detail_show_member_country BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_detail_show_member_region BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_detail_show_member_region BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_detail_show_member_phone BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_detail_show_member_phone BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_detail_show_member_tollfree BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_detail_show_member_tollfree BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_detail_show_member_email BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_detail_show_member_email BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_image BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_image BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_offsite_url BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_offsite_url BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_offsite_url_newtarget BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_offsite_url_newtarget BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_member_link BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_member_link BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_member_link_newtarget BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_member_link_newtarget BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_member_address BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_member_address BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_member_street BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_member_street BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_member_citystatezip BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_member_citystatezip BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_member_country BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_member_country BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_member_region BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_member_region BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_member_phone BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_member_phone BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_member_tollfree BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_member_tollfree BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_member_email BOOLEAN DEFAULT '1'; \ No newline at end of file +ALTER TABLE {prefix}management ADD package_list_show_member_email BOOLEAN NULL DEFAULT TRUE; \ No newline at end of file diff --git a/setup/databaseScripts/update_database_V1.1.2.sql b/setup/databaseScripts/update_database_V1.1.2.sql index eb8aa04..1989aad 100644 --- a/setup/databaseScripts/update_database_V1.1.2.sql +++ b/setup/databaseScripts/update_database_V1.1.2.sql @@ -7,84 +7,80 @@ -- all queries must be separated by a line with four dashses -- Package Management Settings -ALTER TABLE {prefix}management ADD COLUMN package_list_show_image BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_offsite_url BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_offsite_url BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_offsite_url_newtarget BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_offsite_url_newtarget BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_member_link BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_member_link BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_member_link_newtarget BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_member_link_newtarget BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_member_address BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_member_address BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_member_street BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_member_street BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_member_citystatezip BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_member_citystatezip BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_member_country BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_member_country BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_member_region BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_member_region BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_member_phone BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_member_phone BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_member_tollfree BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_member_tollfree BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_member_email BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_member_email BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_pricing BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_pricing BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_short_descr BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_short_descr BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_expire_date BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_expire_date BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_member_image BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_member_image BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_member_short_descr BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_member_short_descr BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_member_second_address BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_member_second_address BOOLEAN DEFAULT '1'; +ALTER TABLE {prefix}management ADD package_list_show_member_website_url BOOLEAN NULL DEFAULT TRUE; ---- -ALTER TABLE {prefix}management ADD COLUMN package_list_show_member_website_url BOOLEAN DEFAULT '1'; - ----- - -ALTER TABLE {prefix}management ADD COLUMN package_list_show_member_website_url_newtarget BOOLEAN DEFAULT '1'; \ No newline at end of file +ALTER TABLE {prefix}management ADD package_list_show_member_website_url_newtarget BOOLEAN NULL DEFAULT TRUE; \ No newline at end of file -- 2.17.1