{"table_name":"parcelsales","full_table_name":"wp_parcelsales","description":"Stores parcelsales data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"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","columns":[{"name":"regionUUID","type":"char(36)","nullable":false,"primary_key":false},{"name":"parcelname","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"parcelUUID","type":"char(36)","nullable":false,"primary_key":false},{"name":"area","type":"int(6)","nullable":false,"primary_key":false},{"name":"saleprice","type":"int(11)","nullable":false,"primary_key":false},{"name":"landingpoint","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"infoUUID","type":"char(36)","nullable":false,"primary_key":false},{"name":"dwell","type":"int(11)","nullable":false,"primary_key":false},{"name":"parentestate","type":"int(11)","nullable":false,"primary_key":false},{"name":"mature","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"gatekeeperURL","type":"varchar(255)","nullable":true,"primary_key":false}],"plugin":{"slug":"w4os-opensimulator-web-interface","name":"w4os – OpenSimulator Web Interface","active_installs":20,"version":"2.8","wp_org_url":"https://wordpress.org/plugins/w4os-opensimulator-web-interface/"}}