diff options
author | Harald Eilertsen <haraldei@anduin.net> | 2023-01-20 20:22:06 +0100 |
---|---|---|
committer | Harald Eilertsen <haraldei@anduin.net> | 2023-01-20 20:22:06 +0100 |
commit | 277fedffc624f55c6ecc8bd80ed8db370134e47e (patch) | |
tree | ac22560f978c3789a63c80284fbd314e11d0b396 /includes/admin/register_db_tables.php | |
parent | f499d9e657fe79e4413eec9e20ae13d616fac6f5 (diff) | |
download | gigologadmin-277fedffc624f55c6ecc8bd80ed8db370134e47e.tar.gz gigologadmin-277fedffc624f55c6ecc8bd80ed8db370134e47e.tar.bz2 gigologadmin-277fedffc624f55c6ecc8bd80ed8db370134e47e.zip |
Rename and reorganize more source files.
Diffstat (limited to 'includes/admin/register_db_tables.php')
-rw-r--r-- | includes/admin/register_db_tables.php | 55 |
1 files changed, 0 insertions, 55 deletions
diff --git a/includes/admin/register_db_tables.php b/includes/admin/register_db_tables.php deleted file mode 100644 index 5f83e25..0000000 --- a/includes/admin/register_db_tables.php +++ /dev/null @@ -1,55 +0,0 @@ -<?php -// SPDX-FileCopyrightText: 2021 Andrea Chirulescu <andrea.chirulescu@gmail.com> -// SPDX-FileCopyrightText: 2021 Harald Eilertsen <haraldei@anduin.net> -// -// SPDX-License-Identifier: AGPL-3.0-or-later - -if ( ! function_exists( 'giglog_register_db_tables' ) ) { - /** - * Registers the tables used by the GiglogAdmin plugin - */ - function giglog_register_db_tables() : void { - global $wpdb; - - $tables = array(); - $tables[] = - "CREATE TABLE IF NOT EXISTS `{$wpdb->prefix}giglogadmin_venues` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `wpgvenue_name` VARCHAR(500) NOT NULL, - `wpgvenue_city` VARCHAR(250) DEFAULT NULL, - `wpgvenue_address` VARCHAR(2000) DEFAULT NULL, - `wpgvenue_webpage` VARCHAR(200) DEFAULT NULL, - `created` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, - `updated` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, - PRIMARY KEY (`id`) - ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"; - - $tables[] = - "CREATE TABLE IF NOT EXISTS `{$wpdb->prefix}giglogadmin_concerts` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `wpgconcert_name` VARCHAR(2000) NOT NULL, - `venue` int(11) NOT NULL, - `wpgconcert_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, - `wpgconcert_tickets` VARCHAR(2000) DEFAULT NULL, - `wpgconcert_event` VARCHAR(2000) DEFAULT NULL, - `wpgconcert_type` INT NOT NULL DEFAULT '1' COMMENT '1 concert, 2 festival', - `wpgconcert_status` INT DEFAULT 1, - `wpgconcert_roles` JSON CHECK (JSON_VALID(wpgconcert_roles)), - `created` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, - `updated` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, - PRIMARY KEY (`id`), - CONSTRAINT `wpgconcert_venue` - FOREIGN KEY (`venue`) - REFERENCES `{$wpdb->prefix}giglogadmin_venues` (`id`) ON DELETE NO ACTION - ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"; - - foreach ( $tables as $tabledef ) { - $result = $wpdb->query( $tabledef ); - if ( $result === false ) { - error_log( 'Registering table failed.' ); - } - } - } - - giglog_register_db_tables(); -} |