wp_cirm_diary

Static

Stores cirm diary data created by this plugin.

Column Definitions

ColumnTypeNullable
🔑idBIGINT UNSIGNEDNO
entry_dateDATETIMENO
titleTEXTNO
noteLONGTEXTYES
target_urlTEXTYES
entry_typeVARCHAR(40)NO
impactVARCHAR(20)NO
created_atDATETIMENO

CREATE TABLE Statement

CREATE TABLE wp_cirm_diary ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, entry_date DATETIME NOT NULL, title TEXT NOT NULL, note LONGTEXT NULL, target_url TEXT NULL, entry_type VARCHAR(40) NOT NULL DEFAULT 'note', impact VARCHAR(20) NOT NULL DEFAULT 'neutral', created_at DATETIME NOT NULL, PRIMARY KEY (id), KEY entry_date (entry_date), KEY entry_type (entry_type) ) {$charset};");

Safe to delete?

If you have uninstalled LineSW Search Rank Monitor, 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_cirm_diary`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from LineSW Search Rank Monitor