From 532787d4d1d0b59d9610f76276c2fd65fa039fb5 Mon Sep 17 00:00:00 2001 From: David Walter Seikel Date: Fri, 15 Mar 2013 01:05:46 +1000 Subject: Add the SQL update scripts. --- sql/ossearch.sql | 187 +++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 187 insertions(+) create mode 100644 sql/ossearch.sql (limited to 'sql/ossearch.sql') 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; -- cgit v1.1