diff options
author | Harald Eilertsen <haraldei@anduin.net> | 2021-04-22 08:40:29 +0200 |
---|---|---|
committer | Harald Eilertsen <haraldei@anduin.net> | 2021-04-22 08:40:29 +0200 |
commit | fe17cad373ab1788cea39a4c3c774fb4c93451e5 (patch) | |
tree | 6a9ade31acecff22d8058b26695b52c3ccc6a7dc /includes/admin/register_db_tables.php | |
parent | e492cc39160c5aa94c27a084dcd90f66fab91863 (diff) | |
parent | 21ed6eeee204b27408eb20f2330cba28ec5625ab (diff) | |
download | gigologadmin-fe17cad373ab1788cea39a4c3c774fb4c93451e5.tar.gz gigologadmin-fe17cad373ab1788cea39a4c3c774fb4c93451e5.tar.bz2 gigologadmin-fe17cad373ab1788cea39a4c3c774fb4c93451e5.zip |
Merge remote-tracking branch 'andrea/andreaschanges' into dev
Diffstat (limited to 'includes/admin/register_db_tables.php')
-rw-r--r-- | includes/admin/register_db_tables.php | 20 |
1 files changed, 19 insertions, 1 deletions
diff --git a/includes/admin/register_db_tables.php b/includes/admin/register_db_tables.php index 3e26a15..90ce473 100644 --- a/includes/admin/register_db_tables.php +++ b/includes/admin/register_db_tables.php @@ -424,7 +424,25 @@ if ( !function_exists( "giglog_register_db_tables") ) $wpdb->query( "INSERT INTO `wpg_countries` (`id`, `wpgc_fullname`, `wpgcountry_name`, `wpgc_iso3`, `wpgc_numcode`) VALUES ('NN', 'UNKNOWN', 'Unknown', 'NNN', '666');"); } - update_option("giglogadmin_db_version", 4); + + if ($db_version == NULL || $db_version < 5) + { + $wpdb->query( + "ALTER TABLE `wpg_concerts` + ADD COLUMN IF NOT EXISTS + `wpgconcert_name` VARCHAR(2000) NOT NULL AFTER `id`;"); + $wpdb->query( + "ALTER TABLE `wpg_concerts` + ADD COLUMN IF NOT EXISTS + `wpgconcert_type` INT NOT NULL DEFAULT '1' COMMENT '1 concert, 2 festival';"); + $wpdb->query( + "ALTER TABLE `wpg_concerts` DROP INDEX `wpgconcert_band`;"); + } + $wpdb->query( + "ALTER TABLE `wpg_concerts` DROP FOREIGN KEY `wpgconcert_band`;"); + ) + + update_option("giglogadmin_db_version", 5); } giglog_register_db_tables(); |