{"slug":"w4os-opensimulator-web-interface","name":"w4os – OpenSimulator Web Interface","description":"WordPress interface for OpenSimulator (w4os)","author":"Olivier van Helden","active_installs":20,"version":"2.8","wp_org_url":"https://wordpress.org/plugins/w4os-opensimulator-web-interface/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"actionscheduler_actions","full_table_name":"wp_actionscheduler_actions","description":"Stores actionscheduler actions data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"actionscheduler_logs","full_table_name":"wp_actionscheduler_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"allparcels","full_table_name":"wp_allparcels","description":"Stores allparcels data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"regionUUID","type":"char(36)","nullable":false,"primary_key":false},{"name":"parcelname","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"ownerUUID","type":"char(36)","nullable":false,"primary_key":false},{"name":"groupUUID","type":"char(36)","nullable":false,"primary_key":false},{"name":"landingpoint","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"parcelUUID","type":"char(36)","nullable":false,"primary_key":false},{"name":"infoUUID","type":"char(36)","nullable":false,"primary_key":false},{"name":"parcelarea","type":"int(11)","nullable":false,"primary_key":false},{"name":"gatekeeperURL","type":"varchar(255)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `allparcels` ( `regionUUID` char(36) NOT NULL, `parcelname` varchar(255) NOT NULL, `ownerUUID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000', `groupUUID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000', `landingpoint` varchar(255) NOT NULL, `parcelUUID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000', `infoUUID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000', `parcelarea` int(11) NOT NULL, `gatekeeperURL` varchar(255), PRIMARY KEY (`parcelUUID`), KEY `regionUUID` (`regionUUID`) ) ENGINE"},{"table_name":"classifieds","full_table_name":"wp_classifieds","description":"Stores classifieds data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"classifieduuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"creatoruuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"creationdate","type":"int(20)","nullable":false,"primary_key":false},{"name":"expirationdate","type":"int(20)","nullable":false,"primary_key":false},{"name":"category","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"description","type":"text","nullable":false,"primary_key":false},{"name":"parceluuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"parentestate","type":"int(11)","nullable":false,"primary_key":false},{"name":"snapshotuuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"simname","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"posglobal","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"parcelname","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"classifiedflags","type":"int(8)","nullable":false,"primary_key":false},{"name":"priceforlisting","type":"int(5)","nullable":false,"primary_key":false}],"create_sql":"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"},{"table_name":"hostsregister","full_table_name":"wp_hostsregister","description":"Stores hostsregister data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"host","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"port","type":"int(5)","nullable":false,"primary_key":false},{"name":"register","type":"int(10)","nullable":false,"primary_key":false},{"name":"nextcheck","type":"int(10)","nullable":false,"primary_key":false},{"name":"checked","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"failcounter","type":"int(10)","nullable":false,"primary_key":false},{"name":"gatekeeperURL","type":"varchar(255)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `hostsregister` ( `host` varchar(255) NOT NULL, `port` int(5) NOT NULL, `register` int(10) NOT NULL, `nextcheck` int(10) NOT NULL, `checked` tinyint(1) NOT NULL, `failcounter` int(10) NOT NULL, `gatekeeperURL` varchar(255), PRIMARY KEY (`host`,`port`) ) ENGINE"},{"table_name":"objects","full_table_name":"wp_objects","description":"Stores objects data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"objectuuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"parceluuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"location","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"description","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"regionuuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"gatekeeperURL","type":"varchar(255)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `objects` ( `objectuuid` char(36) NOT NULL, `parceluuid` char(36) NOT NULL, `location` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `description` varchar(255) NOT NULL, `regionuuid` char(36) NOT NULL default '', `gatekeeperURL` varchar(255), PRIMARY KEY (`objectuuid`,`parceluuid`) ) ENGINE"},{"table_name":"parcels","full_table_name":"wp_parcels","description":"Stores parcels data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"parcelUUID","type":"char(36)","nullable":false,"primary_key":false},{"name":"regionUUID","type":"char(36)","nullable":false,"primary_key":false},{"name":"parcelname","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"landingpoint","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"description","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"searchcategory","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"build","type":"enum('true','false')","nullable":false,"primary_key":false},{"name":"script","type":"enum('true','false')","nullable":false,"primary_key":false},{"name":"public","type":"enum('true','false')","nullable":false,"primary_key":false},{"name":"dwell","type":"float","nullable":false,"primary_key":false},{"name":"infouuid","type":"varchar(36)","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},{"name":"imageUUID","type":"char(36)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `parcels` ( `parcelUUID` char(36) NOT NULL, `regionUUID` char(36) NOT NULL, `parcelname` varchar(255) NOT NULL, `landingpoint` varchar(255) NOT NULL, `description` varchar(255) NOT NULL, `searchcategory` varchar(50) NOT NULL, `build` enum('true','false') NOT NULL, `script` enum('true','false') NOT NULL, `public` enum('true','false') NOT NULL, `dwell` float NOT NULL default '0', `infouuid` varchar(36) NOT NULL default '', `mature` varchar(10) NOT NULL default 'PG', `gatekeeperURL` varchar(255), `imageUUID` char(36), PRIMARY KEY (`regionUUID`,`parcelUUID`), KEY `name` (`parcelname`), KEY `description` (`description`), KEY `searchcategory` (`searchcategory`), KEY `dwell` (`dwell`) ) ENGINE"},{"table_name":"parcelsales","full_table_name":"wp_parcelsales","description":"Stores parcelsales data created by this plugin.","detection_method":"static","confidence":"high","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}],"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"},{"table_name":"popularplaces","full_table_name":"wp_popularplaces","description":"Stores popularplaces data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE IF NOT EXISTS `popularplaces` ( `parcelUUID` char(36) NOT NULL, `name` varchar(255) NOT NULL, `dwell` float NOT NULL, `infoUUID` char(36) NOT NULL, `has_picture` tinyint(1) NOT NULL, `mature` varchar(10) COLLATE"}],"table_count":9}