wp_ald_posts
StaticStores ald posts data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑ID | bigint unsigned | YES |
| post_author | bigint unsigned | NO |
| post_date | datetime | NO |
| post_date_gmt | datetime | NO |
| post_content | longtext | NO |
| post_title | text | NO |
| post_excerpt | text | NO |
| post_status | varchar(20) | NO |
| comment_status | varchar(20) | NO |
| ping_status | varchar(20) | NO |
| post_password | varchar(255) | NO |
| post_name | varchar(200) | NO |
| to_ping | text | NO |
| pinged | text | NO |
| post_modified | datetime | NO |
| post_modified_gmt | datetime | NO |
| post_content_filtered | longtext | NO |
| post_parent | bigint unsigned | NO |
| guid | varchar(255) | NO |
| menu_order | int | NO |
| post_type | varchar(20) | NO |
| post_mime_type | varchar(100) | NO |
| comment_count | bigint | NO |
| ald_post_id | bigint(20) unsigned | NO |
| meta_key | varchar(255) | YES |
| meta_value | longtext | YES |
CREATE TABLE Statement
create table if not exists wp_ald_posts ( ID bigint unsigned auto_increment primary key, post_author bigint unsigned default 0 not null, post_date datetime default '0000-00-00 00:00:00' not null, post_date_gmt datetime default '0000-00-00 00:00:00' not null, post_content longtext not null, post_title text not null, post_excerpt text not null, post_status varchar(20) default 'publish' not null, comment_status varchar(20) default 'open' not null, ping_status varchar(20) default 'open' not null, post_password varchar(255) default '' not null, post_name varchar(200) default '' not null, to_ping text not null, pinged text not null, post_modified datetime default '0000-00-00 00:00:00' not null, post_modified_gmt datetime default '0000-00-00 00:00:00' not null, post_content_filtered longtext not null, post_parent bigint unsigned default 0 not null, guid varchar(255) default '' not null, menu_order int default 0 not null, post_type varchar(20) default 'post' not null, post_mime_type varchar(100) default '' not null, comment_count bigint default 0 not null, KEY post_name (post_name($max_index_length)), KEY type_status_date (post_type,post_status,post_date,ID), KEY post_parent (post_parent), KEY post_author (post_author) ) {$collate}"; $query_meta = "create table if not exists wp_ald_postmeta ( meta_id bigint(20) unsigned NOT NULL auto_increment, ald_post_id bigint(20) unsigned NOT NULL default '0', meta_key varchar(255) default NULL, meta_value longtext, PRIMARY KEY (meta_id), KEY ald_post_id (ald_post_id), KEY meta_key (meta_key($max_index_length)) ) {$collate}"; $wpdb->query( $query );Safe to delete?
If you have uninstalled ALD – Dropshipping and Fulfillment for AliExpress and WooCommerce, 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_ald_posts`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from ALD – Dropshipping and Fulfillment for AliExpress and WooCommerce