wp_krdisk_files
StaticStores krdisk files data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(11) | NO |
| time_add | timestamp | NO |
| name_file | char(255) | NO |
| crc32_name_file | int(10) unsigned | NO |
| url_open | char(32) | NO |
| mode_access | smallint(6) | NO |
| crc32_url_open | int(10) unsigned | NO |
| direct_link | char(255) | NO |
| type | int(11) | NO |
| type_file | char(32) | NO |
| mime | char(128) | NO |
| size_file | bigint(11) | NO |
| image_pre_1 | blob | YES |
| image_pre_2 | blob | YES |
| image_pre_3 | mediumblob | YES |
| cx | int(11) | NO |
| cy | int(11) | NO |
| user_prm | int(10) unsigned | NO |
| time_add_old | timestamp | NO |
| ftime | timestamp | NO |
| make_work | int(11) | NO |
| json_info | char(255) | NO |
| Description | char(255) | NO |
| uName | char(128) | NO |
| cnt_views | int(10) unsigned | NO |
| time_last_view | timestamp | NO |
CREATE TABLE Statement
CREATE TABLE `wp_krdisk_files` ( `id` int(11) NOT NULL AUTO_INCREMENT, `time_add` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `name_file` char(255) NOT NULL, `crc32_name_file` int(10) unsigned NOT NULL, `url_open` char(32) NOT NULL, `mode_access` smallint(6) NOT NULL DEFAULT '0', `crc32_url_open` int(10) unsigned NOT NULL, `direct_link` char(255) NOT NULL, `type` int(11) NOT NULL DEFAULT '0', `type_file` char(32) NOT NULL DEFAULT '', `mime` char(128) NOT NULL DEFAULT '', `size_file` bigint(11) NOT NULL DEFAULT '0', `image_pre_1` blob, `image_pre_2` blob, `image_pre_3` mediumblob, `cx` int(11) NOT NULL DEFAULT '0', `cy` int(11) NOT NULL DEFAULT '0', `user_prm` int(10) unsigned NOT NULL, `time_add_old` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `ftime` timestamp NOT NULL DEFAULT '2021-01-01 00:00:00', `make_work` int(11) NOT NULL DEFAULT '0', `json_info` char(255) NOT NULL DEFAULT '', `Description` char(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', `uName` char(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', `cnt_views` int(10) unsigned NOT NULL DEFAULT '0', `time_last_view` timestamp NOT NULL DEFAULT '2021-01-01 00:00:00', PRIMARY KEY (`name_file`,`crc32_name_file`), UNIQUE KEY `crc32_name_file` (`name_file`,`crc32_name_file`), UNIQUE KEY `url_open` (`url_open`), UNIQUE KEY `id` (`id`), KEY `crc32_url_open` (`crc32_url_open`), KEY `make_work` (`make_work`) ) ENGINE
Safe to delete?
If you have uninstalled KDisk, 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_krdisk_files`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from KDisk