wp_greatrealestate_listings
StaticStores greatrealestate listings data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | mediumint | NO |
| pageid | bigint | NO |
| address | VARCHAR(100) | YES |
| city | VARCHAR(50) | YES |
| state | VARCHAR(40) | YES |
| postcode | VARCHAR(10) | YES |
| mlsid | VARCHAR(15) | YES |
| status | tinyint | NO |
| blurb | VARCHAR(255) | YES |
| bedrooms | VARCHAR(10) | YES |
| bathrooms | VARCHAR(10) | YES |
| halfbaths | VARCHAR(10) | YES |
| garage | VARCHAR(10) | YES |
| acsf | VARCHAR(10) | YES |
| totsf | VARCHAR(10) | YES |
| acres | VARCHAR(10) | YES |
| featureid | VARCHAR(30) | YES |
| listprice | int | NO |
| saleprice | int | YES |
| listdate | date | YES |
| saledate | date | YES |
| galleryid | VARCHAR(30) | YES |
| videoid | VARCHAR(30) | YES |
| downloadid | VARCHAR(30) | YES |
| panoid | VARCHAR(30) | YES |
| latitude | VARCHAR(20) | YES |
| longitude | VARCHAR(20) | YES |
| featured | VARCHAR(30) | YES |
| agentid | VARCHAR(20) | YES |
CREATE TABLE Statement
CREATE TABLE wp_greatrealestate_listings ( id mediumint NOT NULL AUTO_INCREMENT, pageid bigint NOT NULL, address VARCHAR(100), city VARCHAR(50), state VARCHAR(40), postcode VARCHAR(10), mlsid VARCHAR(15), status tinyint NOT NULL, blurb VARCHAR(255), bedrooms VARCHAR(10), bathrooms VARCHAR(10), halfbaths VARCHAR(10), garage VARCHAR(10), acsf VARCHAR(10), totsf VARCHAR(10), acres VARCHAR(10), featureid VARCHAR(30), listprice int NOT NULL, saleprice int, listdate date, saledate date, galleryid VARCHAR(30), videoid VARCHAR(30), downloadid VARCHAR(30), panoid VARCHAR(30), latitude VARCHAR(20), longitude VARCHAR(20), featured VARCHAR(30), agentid VARCHAR(20), UNIQUE KEY id (id) );
Safe to delete?
If you have uninstalled Great Real Estate: WordPress Real Estate and Property Management Plugin, 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_greatrealestate_listings`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.