diff options
| author | Harald Eilertsen <haraldei@anduin.net> | 2021-04-22 08:46:09 +0200 |
|---|---|---|
| committer | Harald Eilertsen <haraldei@anduin.net> | 2021-04-22 08:46:09 +0200 |
| commit | fddb00eddf98db76405ac4dc1f5aebe5d505aba8 (patch) | |
| tree | df2366bd0c6a67583db81b8a0071fb71e11b424e /includes/admin/register_db_tables.php | |
| parent | fe17cad373ab1788cea39a4c3c774fb4c93451e5 (diff) | |
| download | gigologadmin-fddb00eddf98db76405ac4dc1f5aebe5d505aba8.tar.gz gigologadmin-fddb00eddf98db76405ac4dc1f5aebe5d505aba8.tar.bz2 gigologadmin-fddb00eddf98db76405ac4dc1f5aebe5d505aba8.zip | |
Fix typo in register_db_table.
Also moved dropping of band foreign key from concerts table into the db
version 5 changeset.
Diffstat (limited to 'includes/admin/register_db_tables.php')
| -rw-r--r-- | includes/admin/register_db_tables.php | 22 |
1 files 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); } |