wp_gabc_notices
StaticStores gabc notices data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) | NO |
| title | varchar(255) | NO |
| text | text | NO |
| button_text | varchar(100) | YES |
| button_url | varchar(500) | YES |
| button_new_tab | tinyint(1) | YES |
| bg_color | varchar(100) | YES |
| text_color | varchar(20) | YES |
| button_color | varchar(100) | YES |
| padding | int(11) | YES |
| font_size | int(11) | YES |
| position | varchar(20) | YES |
| sticky | tinyint(1) | YES |
| show_location | varchar(50) | YES |
| selected_pages | text | YES |
| selected_categories | text | YES |
| selected_tags | text | YES |
| selected_post_types | text | YES |
| user_roles | text | YES |
| hide_logged_in | tinyint(1) | YES |
| dismissible | tinyint(1) | YES |
| start_date | datetime | YES |
| end_date | datetime | YES |
| priority | int(11) | YES |
| enabled | tinyint(1) | YES |
| trigger_delay | int(11) | YES |
| trigger_scroll | int(11) | YES |
| trigger_exit_intent | tinyint(1) | YES |
| animation | varchar(30) | YES |
| animation_duration | int(11) | YES |
| text_align | varchar(10) | YES |
| font_weight | varchar(10) | YES |
| button_text_color | varchar(20) | YES |
| button_border_radius | int(11) | YES |
| button_padding_x | int(11) | YES |
| button_padding_y | int(11) | YES |
| mobile_font_size | int(11) | YES |
| mobile_padding | int(11) | YES |
| mobile_layout | varchar(20) | YES |
| created_at | datetime | YES |
| updated_at | datetime | YES |
CREATE TABLE Statement
CREATE TABLE wp_gabc_notices ( id bigint(20) NOT NULL AUTO_INCREMENT, title varchar(255) NOT NULL, text text NOT NULL, button_text varchar(100) DEFAULT NULL, button_url varchar(500) DEFAULT NULL, button_new_tab tinyint(1) DEFAULT 0, bg_color varchar(100) DEFAULT '#f0f0f0', text_color varchar(20) DEFAULT '#333333', button_color varchar(100) DEFAULT '#007bff', padding int(11) DEFAULT 15, font_size int(11) DEFAULT 16, position varchar(20) DEFAULT 'top', sticky tinyint(1) DEFAULT 1, show_location varchar(50) DEFAULT 'all', selected_pages text DEFAULT NULL, selected_categories text DEFAULT NULL, selected_tags text DEFAULT NULL, selected_post_types text DEFAULT NULL, user_roles text DEFAULT NULL, hide_logged_in tinyint(1) DEFAULT 0, dismissible tinyint(1) DEFAULT 1, start_date datetime DEFAULT NULL, end_date datetime DEFAULT NULL, priority int(11) DEFAULT 0, enabled tinyint(1) DEFAULT 1, trigger_delay int(11) DEFAULT 0, trigger_scroll int(11) DEFAULT 0, trigger_exit_intent tinyint(1) DEFAULT 0, animation varchar(30) DEFAULT 'none', animation_duration int(11) DEFAULT 400, text_align varchar(10) DEFAULT 'left', font_weight varchar(10) DEFAULT 'normal', button_text_color varchar(20) DEFAULT '#ffffff', button_border_radius int(11) DEFAULT 4, button_padding_x int(11) DEFAULT 20, button_padding_y int(11) DEFAULT 8, mobile_font_size int(11) DEFAULT 0, mobile_padding int(11) DEFAULT 0, mobile_layout varchar(20) DEFAULT 'auto', created_at datetime DEFAULT CURRENT_TIMESTAMP, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY enabled (enabled), KEY priority (priority), KEY start_date (start_date), KEY end_date (end_date) ) $charset_collate;"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql );
Safe to delete?
If you have uninstalled Gridxflex Announcement Bars with CTA, 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_gabc_notices`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Gridxflex Announcement Bars with CTA