From 277fedffc624f55c6ecc8bd80ed8db370134e47e Mon Sep 17 00:00:00 2001 From: Harald Eilertsen Date: Fri, 20 Jan 2023 20:22:06 +0100 Subject: Rename and reorganize more source files. --- includes/admin/register_db_tables.php | 55 ----------------------------------- 1 file changed, 55 deletions(-) delete mode 100644 includes/admin/register_db_tables.php (limited to 'includes/admin/register_db_tables.php') 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 @@ - -// SPDX-FileCopyrightText: 2021 Harald Eilertsen -// -// 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(); -} -- cgit v1.2.3