# ablocks/2.14.0/addons/cookie-consent/database.php

aBlocks – Gutenberg Blocks, User Dashboard Builder, Popup Builder, Form Builder & Animation Builder, version 2.14.0. 60 lines.

- Page: https://pluginprobe.com/plugins/ablocks/2.14.0/code/addons/cookie-consent/database.php
- Raw: https://pluginprobe.com/plugins/ablocks/2.14.0/raw/addons/cookie-consent/database.php
- Modified: 2026-09-08T12:29:06+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/ablocks/2.14.0/code/addons/cookie-consent/database.php#L10-L20`.

```php
<?php
namespace ABlocksCookieConsent;

if ( ! defined( 'ABSPATH' ) ) {
	exit;
}

class Database {

	public static function table_name() {
		global $wpdb;
		return $wpdb->prefix . ABLOCKS_PLUGIN_SLUG . '_consent_records';
	}

	/**
	 * Created when the addon is switched on rather than at plugin install, so
	 * a site that never enables consent never grows the table.
	 */
	public static function create_table() {
		require_once ABSPATH . 'wp-admin/includes/upgrade.php';
		global $wpdb;

		$table           = self::table_name();
		$charset_collate = $wpdb->get_charset_collate();

		// `consent_id` is not unique: a visitor who changes their mind produces
		// a second row, and the history is the point — a record that only ever
		// shows the latest state cannot demonstrate what was agreed and when.
		$sql = "CREATE TABLE $table (
			id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
			consent_id VARCHAR(64) NOT NULL,
			user_id BIGINT(20) UNSIGNED NULL,
			policy_version INT(11) UNSIGNED NOT NULL DEFAULT 1,
			categories VARCHAR(255) NOT NULL DEFAULT '',
			decision VARCHAR(20) NOT NULL DEFAULT 'save',
			banner_hash VARCHAR(32) NOT NULL DEFAULT '',
			page_url VARCHAR(190) NULL,
			ip VARCHAR(100) NULL,
			user_agent VARCHAR(190) NULL,
			created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
			PRIMARY KEY (id),
			KEY consent_id (consent_id),
			KEY user_id (user_id),
			KEY created_at (created_at)
		) $charset_collate;";

		// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.InterpolatedNotPrepared
		if ( $wpdb->get_var( "SHOW TABLES LIKE '{$table}'" ) !== $table ) {
			dbDelta( $sql );
		}
	}

	public static function table_exists() {
		global $wpdb;
		$table = self::table_name();
		// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.InterpolatedNotPrepared
		return $wpdb->get_var( "SHOW TABLES LIKE '{$table}'" ) === $table;
	}
}

```