wp_aeroscroll_gallery
StaticStores aeroscroll gallery data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| created_at | TIMESTAMP | YES |
| updated_at | TIMESTAMP | YES |
| title | VARCHAR(120) | YES |
| subtitle | VARCHAR(256) | YES |
| shortcode | VARCHAR(30) | NO |
| orientation | VARCHAR(30) | NO |
| height | VARCHAR(30) | NO |
| layout | VARCHAR(30) | NO |
| type | VARCHAR(30) | NO |
| categories | TEXT | NO |
| theme | VARCHAR(30) | NO |
| numrows | INT | NO |
| numcolumns | INT | NO |
| numcolumns_mid | INT | NO |
| numcolumns_low | INT | NO |
| cellsize | INT | NO |
| cellsquared | TINYINT | NO |
| scrollspeed | TINYINT | NO |
| isinfinite | TINYINT | NO |
| scrollbar | TINYINT | NO |
| hoveranimation | VARCHAR(30) | NO |
| published | TINYINT | NO |
| cellgap | INT(11) | YES |
| sortby | VARCHAR(30) | NO |
| sortbydir | VARCHAR(30) | NO |
| sidegap | INT(11) | YES |
| marginX | INT(11) | YES |
| marginY | INT(11) | YES |
| usemousewheel | TINYINT | YES |
| autoscroll | TINYINT | YES |
| imagegallery_id | INT(11) | YES |
| themeonhover | TINYINT | NO |
| color_theme_desc | VARCHAR(30) | NO |
| color_theme_title | VARCHAR(30) | NO |
| color_theme_a | VARCHAR(30) | NO |
| color_cell_bg | VARCHAR(30) | NO |
| showreadmore | TINYINT | NO |
| color_bg | VARCHAR(30) | NO |
| social_share_facebook | TINYINT | YES |
| social_share_twitter | TINYINT | YES |
| social_share_pinterest | TINYINT | YES |
| social_share_instagram | TINYINT | YES |
| social_share_tumblr | TINYINT | YES |
| social_share_email | TINYINT | YES |
| watermark_type | TINYINT | YES |
| watermark_text | VARCHAR(120) | NO |
| watermark_fontsize | INT | NO |
| watermark_color | VARCHAR(30) | NO |
| watermark_opacity | TINYINT | YES |
| watermark_position | TINYINT | YES |
| watermark_image_url | VARCHAR(2048) | NO |
| watermark_image_size | TINYINT | YES |
| advertisment_type | TINYINT | YES |
| advertisment_text | VARCHAR(120) | NO |
| advertisment_link | VARCHAR(2048) | NO |
| advertisment_fontsize | INT | NO |
| advertisment_color | VARCHAR(30) | NO |
| advertisment_opacity | TINYINT | YES |
| advertisment_position | TINYINT | YES |
| advertisment_image_url | VARCHAR(2048) | NO |
| advertisment_image_size | TINYINT | YES |
| poweredbyactive | TINYINT | YES |
CREATE TABLE Statement
CREATE TABLE wp_aeroscroll_gallery ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, title VARCHAR(120) DEFAULT '', subtitle VARCHAR(256) DEFAULT '', shortcode VARCHAR(30) NOT NULL DEFAULT '', orientation VARCHAR(30) NOT NULL DEFAULT 'vertical', height VARCHAR(30) NOT NULL DEFAULT '400px', layout VARCHAR(30) NOT NULL, type VARCHAR(30) NOT NULL, categories TEXT NOT NULL, theme VARCHAR(30) NOT NULL, numrows INT NOT NULL DEFAULT 2, numcolumns INT NOT NULL DEFAULT 3, numcolumns_mid INT NOT NULL DEFAULT 2, numcolumns_low INT NOT NULL DEFAULT 1, cellsize INT NOT NULL DEFAULT 200, cellsquared TINYINT NOT NULL DEFAULT 0, scrollspeed TINYINT NOT NULL DEFAULT 6, isinfinite TINYINT NOT NULL DEFAULT 1, scrollbar TINYINT NOT NULL DEFAULT 1, hoveranimation VARCHAR(30) NOT NULL DEFAULT 'none', published TINYINT NOT NULL DEFAULT 1, cellgap INT(11) DEFAULT 0, sortby VARCHAR(30) NOT NULL DEFAULT 'id', sortbydir VARCHAR(30) NOT NULL DEFAULT 'ASC', sidegap INT(11) DEFAULT 0, marginX INT(11) DEFAULT 0, marginY INT(11) DEFAULT 0, usemousewheel TINYINT DEFAULT 1, autoscroll TINYINT DEFAULT 0, imagegallery_id INT(11) DEFAULT 0, themeonhover TINYINT NOT NULL DEFAULT 1, color_theme_desc VARCHAR(30) NOT NULL DEFAULT '#bfbfbfff', color_theme_title VARCHAR(30) NOT NULL DEFAULT '#ffffffff', color_theme_a VARCHAR(30) NOT NULL DEFAULT '#2d2f31ff', color_cell_bg VARCHAR(30) NOT NULL DEFAULT '#dbdfe5ff', showreadmore TINYINT NOT NULL DEFAULT 1, color_bg VARCHAR(30) NOT NULL DEFAULT '#ffffff00', social_share_facebook TINYINT DEFAULT 0, social_share_twitter TINYINT DEFAULT 0, social_share_pinterest TINYINT DEFAULT 0, social_share_instagram TINYINT DEFAULT 0, social_share_tumblr TINYINT DEFAULT 0, social_share_email TINYINT DEFAULT 0, watermark_type TINYINT DEFAULT 0, watermark_text VARCHAR(120) NOT NULL DEFAULT '', watermark_fontsize INT NOT NULL DEFAULT 16, watermark_color VARCHAR(30) NOT NULL DEFAULT '#000000', watermark_opacity TINYINT DEFAULT 30, watermark_position TINYINT DEFAULT 7, watermark_image_url VARCHAR(2048) NOT NULL DEFAULT '', watermark_image_size TINYINT DEFAULT 20, advertisment_type TINYINT DEFAULT 0, advertisment_text VARCHAR(120) NOT NULL DEFAULT '', advertisment_link VARCHAR(2048) NOT NULL DEFAULT '', advertisment_fontsize INT NOT NULL DEFAULT 16, advertisment_color VARCHAR(30) NOT NULL DEFAULT '#000000', advertisment_opacity TINYINT DEFAULT 30, advertisment_position TINYINT DEFAULT 7, advertisment_image_url VARCHAR(2048) NOT NULL DEFAULT '', advertisment_image_size TINYINT DEFAULT 20, poweredbyactive TINYINT DEFAULT 0, PRIMARY KEY (id) ) $collate;"; dbDelta($schema);
Safe to delete?
If you have uninstalled Aeroscroll Gallery – Infinite Scroll Image Gallery & Post Grid with Photo Gallery, 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_aeroscroll_gallery`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Aeroscroll Gallery – Infinite Scroll Image Gallery & Post Grid with Photo Gallery