{"table_name":"loi25_consent_log","full_table_name":"wp_loi25_consent_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","create_sql":"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 );","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"session_id","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"user_ip","type":"VARCHAR(45)","nullable":false,"primary_key":false},{"name":"lang","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"action","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"categories","type":"TEXT","nullable":true,"primary_key":false},{"name":"user_agent","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"prenom","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"nom","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"titre","type":"VARCHAR(150)","nullable":false,"primary_key":false},{"name":"courriel","type":"VARCHAR(150)","nullable":false,"primary_key":false},{"name":"telephone","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"lang","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"text_key","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"text_value","type":"TEXT","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false}],"plugin":{"slug":"loi-25-comply","name":"Loi 25 Comply","active_installs":0,"version":"1.9.6","wp_org_url":"https://wordpress.org/plugins/loi-25-comply/"}}