wp_artzioam_artworks
StaticStores artzioam artworks data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT(20) UNSIGNED | NO |
| artist_id | BIGINT(20) UNSIGNED | NO |
| title | VARCHAR(255) | NO |
| description | TEXT | YES |
| image_url | VARCHAR(512) | NO |
| dpi | INT | YES |
| created_at | TIMESTAMP | YES |
| artist_id | BIGINT(20) UNSIGNED | NO |
| artwork_id | BIGINT(20) UNSIGNED | NO |
| status | VARCHAR(20) | NO |
| submitted_at | TIMESTAMP | YES |
| artist_id | BIGINT(20) UNSIGNED | NO |
| order_id | BIGINT(20) UNSIGNED | NO |
| product_id | BIGINT(20) UNSIGNED | NO |
| amount | DECIMAL(10,2) | NO |
| earned_at | TIMESTAMP | YES |
| user_id | BIGINT(20) UNSIGNED | NO |
| message | TEXT | NO |
| type | VARCHAR(50) | NO |
| is_read | TINYINT(1) | NO |
| created_at | TIMESTAMP | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_artzioam_artworks ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, artist_id BIGINT(20) UNSIGNED NOT NULL, title VARCHAR(255) NOT NULL, description TEXT NULL, image_url VARCHAR(512) NOT NULL, dpi INT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY artist_id (artist_id) ) $charset_collate;"; $tables[] = "CREATE TABLE IF NOT EXISTS wp_artzioam_submissions ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, artist_id BIGINT(20) UNSIGNED NOT NULL, artwork_id BIGINT(20) UNSIGNED NOT NULL, status VARCHAR(20) NOT NULL DEFAULT 'pending', submitted_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY artist_id (artist_id), KEY artwork_id (artwork_id) ) $charset_collate;"; $tables[] = "CREATE TABLE IF NOT EXISTS wp_artzioam_earnings ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, artist_id BIGINT(20) UNSIGNED NOT NULL, order_id BIGINT(20) UNSIGNED NOT NULL, product_id BIGINT(20) UNSIGNED NOT NULL, amount DECIMAL(10,2) NOT NULL, earned_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY artist_id (artist_id), KEY order_id (order_id), KEY product_id (product_id) ) $charset_collate;"; $tables[] = "CREATE TABLE IF NOT EXISTS wp_artzioam_notifications ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT(20) UNSIGNED NOT NULL, message TEXT NOT NULL, type VARCHAR(50) NOT NULL DEFAULT 'info', is_read TINYINT(1) NOT NULL DEFAULT 0, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY user_id (user_id) ) $charset_collate;"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ($tables as $sql) { dbDelta($sql);Safe to delete?
If you have uninstalled Artzio Artist Marketplace for 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_artzioam_artworks`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Artzio Artist Marketplace for WooCommerce