wp_classifieds
StaticStores classifieds data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| classifieduuid | char(36) | NO |
| creatoruuid | char(36) | NO |
| creationdate | int(20) | NO |
| expirationdate | int(20) | NO |
| category | varchar(20) | NO |
| name | varchar(255) | NO |
| description | text | NO |
| parceluuid | char(36) | NO |
| parentestate | int(11) | NO |
| snapshotuuid | char(36) | NO |
| simname | varchar(255) | NO |
| posglobal | varchar(255) | NO |
| parcelname | varchar(255) | NO |
| classifiedflags | int(8) | NO |
| priceforlisting | int(5) | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `classifieds` ( `classifieduuid` char(36) NOT NULL, `creatoruuid` char(36) NOT NULL, `creationdate` int(20) NOT NULL, `expirationdate` int(20) NOT NULL, `category` varchar(20) NOT NULL, `name` varchar(255) NOT NULL, `description` text NOT NULL, `parceluuid` char(36) NOT NULL, `parentestate` int(11) NOT NULL, `snapshotuuid` char(36) NOT NULL, `simname` varchar(255) NOT NULL, `posglobal` varchar(255) NOT NULL, `parcelname` varchar(255) NOT NULL, `classifiedflags` int(8) NOT NULL, `priceforlisting` int(5) NOT NULL, PRIMARY KEY (`classifieduuid`) ) ENGINE
Safe to delete?
If you have uninstalled w4os – OpenSimulator Web Interface, 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_classifieds`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from w4os – OpenSimulator Web Interface