1 files changed, 187 insertions, 0 deletions

diff --git a/sql/ossearch.sql b/sql/ossearch.sql
new file mode 100644
index 0000000..a1ef08f
--- /dev/null
+++ b/sql/ossearch.sql
@@ -0,0 +1,187 @@
+-- phpMyAdmin SQL Dump
+-- version 2.7.0-beta1
+-- http://www.phpmyadmin.net
+-- 
+-- Host: localhost
+-- Generatie Tijd: 24 Jan 2009 om 15:48
+-- Server versie: 5.0.67
+-- PHP Versie: 5.2.6-2ubuntu5
+-- 
+-- Database: `ossearch`
+-- 
+
+-- --------------------------------------------------------
+
+-- 
+-- Tabel structuur voor tabel `allparcels`
+-- 
+
+CREATE TABLE `allparcels` (
+  `regionUUID` varchar(255) 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,
+  PRIMARY KEY  (`parcelUUID`),
+  KEY `regionUUID` (`regionUUID`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
+-- 
+-- Tabel structuur voor tabel `classifieds`
+-- 
+
+CREATE TABLE `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=InnoDB DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
+-- 
+-- Tabel structuur voor tabel `events`
+-- 
+
+CREATE TABLE `events` (
+  `owneruuid` char(40) NOT NULL,
+  `name` varchar(255) NOT NULL,
+  `eventid` int(11) NOT NULL auto_increment,
+  `creatoruuid` char(40) NOT NULL,
+  `category` int(2) NOT NULL,
+  `description` text NOT NULL,
+  `dateUTC` int(10) NOT NULL,
+  `duration` int(3) NOT NULL,
+  `covercharge` tinyint(1) NOT NULL,
+  `coveramount` int(10) NOT NULL,
+  `simname` varchar(255) NOT NULL,
+  `globalPos` varchar(255) NOT NULL,
+  `eventflags` int(1) NOT NULL,
+  PRIMARY KEY  (`eventid`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+-- --------------------------------------------------------
+
+-- 
+-- Tabel structuur voor tabel `hostsregister`
+-- 
+
+CREATE TABLE `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,
+  PRIMARY KEY (`host`,`port`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
+-- 
+-- Tabel structuur voor tabel `objects`
+-- 
+
+CREATE TABLE `objects` (
+  `objectuuid` varchar(255) NOT NULL,
+  `parceluuid` varchar(255) NOT NULL,
+  `location` varchar(255) NOT NULL,
+  `name` varchar(255) NOT NULL,
+  `description` varchar(255) NOT NULL,
+  `regionuuid` varchar(255) NOT NULL default '',
+  PRIMARY KEY  (`objectuuid`,`parceluuid`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
+-- 
+-- Tabel structuur voor tabel `parcels`
+-- 
+
+CREATE TABLE `parcels` (
+  `regionUUID` varchar(255) NOT NULL,
+  `parcelname` varchar(255) NOT NULL,
+  `parcelUUID` 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(255) NOT NULL default '',
+  `mature` varchar(10) NOT NULL default 'PG',
+  PRIMARY KEY  (`regionUUID`,`parcelUUID`),
+  KEY `name` (`parcelname`),
+  KEY `description` (`description`),
+  KEY `searchcategory` (`searchcategory`),
+  KEY `dwell` (`dwell`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
+-- 
+-- Tabel structuur voor tabel `parcelsales`
+-- 
+
+CREATE TABLE `parcelsales` (
+  `regionUUID` varchar(255) NOT NULL,
+  `parcelname` varchar(255) NOT NULL,
+  `parcelUUID` varchar(255) 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',
+  PRIMARY KEY  (`regionUUID`,`parcelUUID`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
+-- 
+-- Tabel structuur voor tabel `popularplaces`
+-- 
+
+CREATE TABLE `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` tinyint(4) NOT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
+-- 
+-- Tabel structuur voor tabel `regions`
+-- 
+
+CREATE TABLE `osregions` (
+  `regionname` varchar(255) NOT NULL,
+  `regionuuid` varchar(255) NOT NULL,
+  `regionhandle` varchar(255) NOT NULL,
+  `url` varchar(255) NOT NULL,
+  `owner` varchar(255) NOT NULL,
+  `owneruuid` varchar(255) NOT NULL,
+  PRIMARY KEY  (`regionuuid`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;