From 53766a76936bf26031ff4fa39c743840635f2c8a Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Fri, 5 Aug 2016 16:14:08 -0400 Subject: [PATCH] Plugin DB Updates NEW Table Adding a table for ical feeds. This will store the ical feed for the site. with the url it has created date and updated date. --- index.php | 2 +- ...V0.0.18.sql => create_database_V0.0.19.sql} | 18 ++++++++++++++---- setup/databaseScripts/dbVersions.php | 3 ++- .../update_database_V0.0.19.sql | 17 +++++++++++++++++ 4 files changed, 34 insertions(+), 6 deletions(-) rename setup/databaseScripts/{create_database_V0.0.18.sql => create_database_V0.0.19.sql} (95%) create mode 100644 setup/databaseScripts/update_database_V0.0.19.sql diff --git a/index.php b/index.php index 6d0b654..f3e753c 100644 --- a/index.php +++ b/index.php @@ -39,7 +39,7 @@ * version from this plugin. */ define('GLM_MEMBERS_EVENTS_PLUGIN_VERSION', '1.2.29'); -define('GLM_MEMBERS_EVENTS_PLUGIN_DB_VERSION', '0.0.18'); +define('GLM_MEMBERS_EVENTS_PLUGIN_DB_VERSION', '0.0.19'); // This is the minimum version of the GLM Members DB plugin require for this plugin. define('GLM_MEMBERS_EVENTS_PLUGIN_MIN_MEMBERS_REQUIRED_VERSION', '1.0.58'); diff --git a/setup/databaseScripts/create_database_V0.0.18.sql b/setup/databaseScripts/create_database_V0.0.19.sql similarity index 95% rename from setup/databaseScripts/create_database_V0.0.18.sql rename to setup/databaseScripts/create_database_V0.0.19.sql index 47dac5b..150d368 100644 --- a/setup/databaseScripts/create_database_V0.0.18.sql +++ b/setup/databaseScripts/create_database_V0.0.19.sql @@ -1,6 +1,6 @@ -- Gaslight Media Members Database - Events Add-On -- File Created: 12/02/15 15:27:15 --- Database Version: 0.0.1 +-- Database Version: 0.0.19 -- Database Creation Script -- -- This file is called to create a new set of tables for this @@ -129,11 +129,11 @@ CREATE TABLE {prefix}events ( descr TEXT NULL, -- Full description text image TINYTEXT NULL, -- Image file name file1 TINYTEXT NULL, -- File name for a single uploaded file #1 - file1_descr TINYTEXT NULL, -- Description for file uploaded in field "file" #1 + file1_descr TINYTEXT NULL, -- Description for file uploaded in field "file" #1 file2 TINYTEXT NULL, -- File name for a single uploaded file #2 - file2_descr TINYTEXT NULL, -- Description for file uploaded in field "file" #2 + file2_descr TINYTEXT NULL, -- Description for file uploaded in field "file" #2 file3 TINYTEXT NULL, -- File name for a single uploaded file #3 - file3_descr TINYTEXT NULL, -- Description for file uploaded in field "file" #3 + file3_descr TINYTEXT NULL, -- Description for file uploaded in field "file" #3 url TINYTEXT NULL, -- Event URL ticket_url TINYTEXT NULL, -- Ticket URL cost TINYTEXT NULL, -- Description of event cost @@ -183,3 +183,13 @@ INSERT INTO {prefix}management ( 1, 'event-detail' ) ; +---- + +-- Event iCal Feed imports +CREATE TABLE {prefix}feed_import ( + id INT NOT NULL AUTO_INCREMENT, + feed_url TEXT NOT NULL, -- The ical feed url to import + created DATETIME NULL, -- The date this feed was created + updated DATETIME NULL, -- Last time this feed was updated + PRIMARY KEY (id) +); diff --git a/setup/databaseScripts/dbVersions.php b/setup/databaseScripts/dbVersions.php index c2382c2..c49c6d0 100644 --- a/setup/databaseScripts/dbVersions.php +++ b/setup/databaseScripts/dbVersions.php @@ -29,6 +29,7 @@ $glmMembersEventsDbVersions = array( '0.0.15' => array('version' => '0.0.15', 'tables' => 7, 'date' => '4/11/2016'), '0.0.16' => array('version' => '0.0.16', 'tables' => 7, 'date' => '4/11/2016'), '0.0.17' => array('version' => '0.0.17', 'tables' => 7, 'date' => '5/5/2016'), - '0.0.18' => array('version' => '0.0.18', 'tables' => 7, 'date' => '5/26/2016') + '0.0.18' => array('version' => '0.0.18', 'tables' => 7, 'date' => '5/26/2016'), + '0.0.19' => array('version' => '0.0.19', 'tables' => 8, 'date' => '8/05/2016'), ); diff --git a/setup/databaseScripts/update_database_V0.0.19.sql b/setup/databaseScripts/update_database_V0.0.19.sql new file mode 100644 index 0000000..4340c80 --- /dev/null +++ b/setup/databaseScripts/update_database_V0.0.19.sql @@ -0,0 +1,17 @@ +-- Gaslight Media Members Database - Events Add-On +-- File Created: 12/09/14 15:27:15 +-- Database Version: 0.0.18 +-- Database Update From Previous Version Script +-- +-- To permit each query below to be executed separately, +-- all queries must be separated by a line with four dashses + + +-- Event iCal Feed imports +CREATE TABLE {prefix}feed_import ( + id INT NOT NULL AUTO_INCREMENT, + feed_url TEXT NOT NULL, -- The ical feed url to import + created DATETIME NULL, -- The date this feed was created + updated DATETIME NULL, -- Last time this feed was updated + PRIMARY KEY (id) +); -- 2.17.1