wp_parcelsales

Static

Stores parcelsales data created by this plugin.

Column Definitions

ColumnTypeNullable
regionUUIDchar(36)NO
parcelnamevarchar(255)NO
parcelUUIDchar(36)NO
areaint(6)NO
salepriceint(11)NO
landingpointvarchar(255)NO
infoUUIDchar(36)NO
dwellint(11)NO
parentestateint(11)NO
maturevarchar(10)NO
gatekeeperURLvarchar(255)YES

CREATE TABLE Statement

CREATE TABLE IF NOT EXISTS `parcelsales` ( `regionUUID` char(36) NOT NULL, `parcelname` varchar(255) NOT NULL, `parcelUUID` char(36) NOT NULL, `area` int(6) NOT NULL, `saleprice` int(11) NOT NULL, `landingpoint` varchar(255) NOT NULL, `infoUUID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000', `dwell` int(11) NOT NULL, `parentestate` int(11) NOT NULL default '1', `mature` varchar(10) NOT NULL default 'PG', `gatekeeperURL` varchar(255), PRIMARY KEY (`regionUUID`,`parcelUUID`) ) 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_parcelsales`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from w4os – OpenSimulator Web Interface