wp_aieo_order_stats
StaticStores order records and related transaction data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| name | varchar(255) | YES |
| orderid | decimal(12,0) | YES |
| customeremail | varchar(255) | YES |
| customerid | decimal(12,0) | YES |
| birthyear | decimal(12,0) | YES |
| birthday | varchar(50) | YES |
| firstname | varchar(60) | YES |
| lastname | varchar(90) | YES |
| city | varchar(255) | YES |
| postcode | varchar(50) | YES |
| numberofitemsperorder | decimal(12,0) | YES |
| numberoforders | decimal(12,0) | YES |
| orderspend | decimal(12,2) | YES |
| shippingcharged | decimal(12,2) | YES |
| shippingtype | varchar(255) | YES |
| freeshipping | varchar(5) | YES |
| totalshipping | decimal(12,2) | YES |
| netspendonproducts | decimal(12,2) | YES |
| orderdate | date | NO |
| orderdatetime | datetime | NO |
| orderday | decimal(2,0) | YES |
| orderdaymonth | decimal(2,0) | YES |
| buyerspayrol | varchar(20) | YES |
| buyersday | varchar(20) | YES |
| buyerstime | varchar(20) | YES |
| buyersdevice | varchar(100) | YES |
| link_to_order_details | varchar(200) | YES |
| paymenttype | varchar(80) | YES |
| pickuplocation | varchar(150) | YES |
| phoneorder | varchar(5) | YES |
| orderstatus | varchar(50) | YES |
| ordersource | varchar(255) | YES |
| orderutmsource | varchar(255) | YES |
| orderutmmedium | varchar(255) | YES |
| orderutmcampaign | varchar(255) | YES |
| orderutmterm | varchar(255) | YES |
| orderutmcontent | varchar(255) | YES |
| statsclientid | int(10) unsigned | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_aieo_order_stats` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `orderid` decimal(12,0) DEFAULT NULL, `customeremail` varchar(255) DEFAULT NULL, `customerid` decimal(12,0) DEFAULT NULL, `birthyear` decimal(12,0) DEFAULT NULL, `birthday` varchar(50) DEFAULT NULL, `firstname` varchar(60) DEFAULT NULL, `lastname` varchar(90) DEFAULT NULL, `city` varchar(255) DEFAULT NULL, `postcode` varchar(50) DEFAULT NULL, `numberofitemsperorder` decimal(12,0) DEFAULT NULL, `numberoforders` decimal(12,0) DEFAULT NULL, `orderspend` decimal(12,2) DEFAULT NULL, `shippingcharged` decimal(12,2) DEFAULT NULL, `shippingtype` varchar(255) DEFAULT NULL, `freeshipping` varchar(5) DEFAULT NULL, `totalshipping` decimal(12,2) DEFAULT NULL, `netspendonproducts` decimal(12,2) DEFAULT NULL, `orderdate` date NOT NULL DEFAULT '0000-00-00', `orderdatetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `orderday` decimal(2,0) DEFAULT NULL, `orderdaymonth` decimal(2,0) DEFAULT NULL, `buyerspayrol` varchar(20) DEFAULT NULL, `buyersday` varchar(20) DEFAULT NULL, `buyerstime` varchar(20) DEFAULT NULL, `buyersdevice` varchar(100) DEFAULT NULL, `link_to_order_details` varchar(200) DEFAULT NULL, `paymenttype` varchar(80) DEFAULT NULL, `pickuplocation` varchar(150) DEFAULT NULL, `phoneorder` varchar(5) DEFAULT NULL, `orderstatus` varchar(50) DEFAULT NULL, `ordersource` varchar(255) DEFAULT NULL, `orderutmsource` varchar(255) DEFAULT NULL, `orderutmmedium` varchar(255) DEFAULT NULL, `orderutmcampaign` varchar(255) DEFAULT NULL, `orderutmterm` varchar(255) DEFAULT NULL, `orderutmcontent` varchar(255) DEFAULT NULL, `statsclientid` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `order_id_idx` (`orderid`,`customeremail`), KEY `idx_customeremail` (`customeremail`) ) ENGINE
Safe to delete?
If you have uninstalled AI eShop Optimizer, 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_aieo_order_stats`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from AI eShop Optimizer