From fddb00eddf98db76405ac4dc1f5aebe5d505aba8 Mon Sep 17 00:00:00 2001 From: Harald Eilertsen Date: Thu, 22 Apr 2021 08:46:09 +0200 Subject: Fix typo in register_db_table. Also moved dropping of band foreign key from concerts table into the db version 5 changeset. --- includes/admin/register_db_tables.php | 22 +++++++++++----------- 1 file changed, 11 insertions(+), 11 deletions(-) diff --git a/includes/admin/register_db_tables.php b/includes/admin/register_db_tables.php index 90ce473..760d997 100644 --- a/includes/admin/register_db_tables.php +++ b/includes/admin/register_db_tables.php @@ -427,20 +427,20 @@ if ( !function_exists( "giglog_register_db_tables") ) if ($db_version == NULL || $db_version < 5) { - $wpdb->query( - "ALTER TABLE `wpg_concerts` + $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` + `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`;"); + `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`;"); } - $wpdb->query( - "ALTER TABLE `wpg_concerts` DROP FOREIGN KEY `wpgconcert_band`;"); - ) update_option("giglogadmin_db_version", 5); } -- cgit v1.2.3