wp_clouansp_story_nodes
StaticStores clouansp story nodes data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| story_id | BIGINT UNSIGNED | NO |
| path_id | BIGINT UNSIGNED | YES |
| substory_id | BIGINT UNSIGNED | YES |
| title_override | VARCHAR(255) | YES |
| excerpt_override | TEXT | YES |
| x | FLOAT | NO |
| y | FLOAT | NO |
| icon_type | VARCHAR(10) | NO |
| icon_id | BIGINT UNSIGNED | YES |
| icon_color | VARCHAR(9) | NO |
| icon_size | FLOAT | NO |
| icon_border_color | VARCHAR(9) | NO |
| icon_border_width | FLOAT | NO |
| icon_bg_color | VARCHAR(9) | NO |
| icon_bg_shape | VARCHAR(10) | NO |
| marker_type | VARCHAR(10) | NO |
| marker_icon_id | BIGINT UNSIGNED | YES |
| marker_color | VARCHAR(9) | YES |
| marker_size | FLOAT | YES |
| marker_icon_offset_x | FLOAT | YES |
| marker_icon_offset_y | FLOAT | YES |
| created_at | DATETIME | NO |
| updated_at | DATETIME | NO |
CREATE TABLE Statement
CREATE TABLE wp_clouansp_story_nodes ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, story_id BIGINT UNSIGNED NOT NULL, path_id BIGINT UNSIGNED NULL DEFAULT NULL, substory_id BIGINT UNSIGNED NULL DEFAULT NULL, title_override VARCHAR(255) NULL DEFAULT NULL, excerpt_override TEXT NULL DEFAULT NULL, x FLOAT NOT NULL DEFAULT 0.5, y FLOAT NOT NULL DEFAULT 0.5, icon_type VARCHAR(10) NOT NULL DEFAULT 'round', icon_id BIGINT UNSIGNED NULL DEFAULT NULL, icon_color VARCHAR(9) NOT NULL DEFAULT '#ffffff', icon_size FLOAT NOT NULL DEFAULT 1.0, icon_border_color VARCHAR(9) NOT NULL DEFAULT '#000000', icon_border_width FLOAT NOT NULL DEFAULT 2.0, icon_bg_color VARCHAR(9) NOT NULL DEFAULT '#ffffff', icon_bg_shape VARCHAR(10) NOT NULL DEFAULT 'none', marker_type VARCHAR(10) NOT NULL DEFAULT 'inherit', marker_icon_id BIGINT UNSIGNED NULL DEFAULT NULL, marker_color VARCHAR(9) NULL DEFAULT NULL, marker_size FLOAT NULL DEFAULT NULL, marker_icon_offset_x FLOAT NULL DEFAULT NULL, marker_icon_offset_y FLOAT NULL DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_story_id (story_id), KEY idx_path_id (path_id), KEY idx_substory_id (substory_id) ) $charset_collate;");
Safe to delete?
If you have uninstalled Clouds and Spaceships, 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_clouansp_story_nodes`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Clouds and Spaceships