{"slug":"great-real-estate","name":"Great Real Estate: WordPress Real Estate and Property Management Plugin","description":"Great Real Estate WordPress Plugin allows you to create and manage any kind of real estate on your WordPress site, from commercial and residential lis …","author":"daverod","active_installs":20,"version":"1.6","wp_org_url":"https://wordpress.org/plugins/great-real-estate/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"greatrealestate_listings","full_table_name":"wp_greatrealestate_listings","description":"Stores greatrealestate listings data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"mediumint","nullable":false,"primary_key":true},{"name":"pageid","type":"bigint","nullable":false,"primary_key":false},{"name":"address","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"city","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"state","type":"VARCHAR(40)","nullable":true,"primary_key":false},{"name":"postcode","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"mlsid","type":"VARCHAR(15)","nullable":true,"primary_key":false},{"name":"status","type":"tinyint","nullable":false,"primary_key":false},{"name":"blurb","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"bedrooms","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"bathrooms","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"halfbaths","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"garage","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"acsf","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"totsf","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"acres","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"featureid","type":"VARCHAR(30)","nullable":true,"primary_key":false},{"name":"listprice","type":"int","nullable":false,"primary_key":false},{"name":"saleprice","type":"int","nullable":true,"primary_key":false},{"name":"listdate","type":"date","nullable":true,"primary_key":false},{"name":"saledate","type":"date","nullable":true,"primary_key":false},{"name":"galleryid","type":"VARCHAR(30)","nullable":true,"primary_key":false},{"name":"videoid","type":"VARCHAR(30)","nullable":true,"primary_key":false},{"name":"downloadid","type":"VARCHAR(30)","nullable":true,"primary_key":false},{"name":"panoid","type":"VARCHAR(30)","nullable":true,"primary_key":false},{"name":"latitude","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"longitude","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"featured","type":"VARCHAR(30)","nullable":true,"primary_key":false},{"name":"agentid","type":"VARCHAR(20)","nullable":true,"primary_key":false}],"create_sql":"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) );"}],"table_count":1}