wp_loi25_consent_log
StaticA logging table that records activity, events, or audit history.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT(20) UNSIGNED | NO |
| session_id | VARCHAR(64) | NO |
| user_ip | VARCHAR(45) | NO |
| lang | VARCHAR(10) | NO |
| action | VARCHAR(20) | NO |
| categories | TEXT | YES |
| user_agent | TEXT | YES |
| created_at | DATETIME | NO |
| prenom | VARCHAR(100) | NO |
| nom | VARCHAR(100) | NO |
| titre | VARCHAR(150) | NO |
| courriel | VARCHAR(150) | NO |
| telephone | VARCHAR(30) | NO |
| updated_at | DATETIME | NO |
| lang | VARCHAR(10) | NO |
| text_key | VARCHAR(50) | NO |
| text_value | TEXT | NO |
| updated_at | DATETIME | NO |
CREATE TABLE Statement
CREATE TABLE wp_loi25_consent_log ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, session_id VARCHAR(64) NOT NULL, user_ip VARCHAR(45) NOT NULL DEFAULT '', lang VARCHAR(10) NOT NULL DEFAULT 'fr', action VARCHAR(20) NOT NULL DEFAULT 'accept', categories TEXT, user_agent TEXT, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY session_id (session_id), KEY created_at (created_at) ) $charset;"; // Table : designation du RPRP (Module 3) $sql[] = "CREATE TABLE wp_loi25_rprp ( id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, prenom VARCHAR(100) NOT NULL DEFAULT '', nom VARCHAR(100) NOT NULL DEFAULT '', titre VARCHAR(150) NOT NULL DEFAULT '', courriel VARCHAR(150) NOT NULL DEFAULT '', telephone VARCHAR(30) NOT NULL DEFAULT '', updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset;"; // Table : textes de la banniere par langue (Module 1) $sql[] = "CREATE TABLE wp_loi25_banner_texts ( id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, lang VARCHAR(10) NOT NULL DEFAULT 'fr', text_key VARCHAR(50) NOT NULL DEFAULT '', text_value TEXT NOT NULL, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY lang_key (lang, text_key) ) $charset;"; foreach ( $sql as $query ) { dbDelta( $query );Safe to delete?
If you have uninstalled Loi 25 Comply, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_loi25_consent_log`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Loi 25 Comply