<?php
////////////////////////////////////////////////////////////////////////////////
//
//
//	Xoops用 _profile_ データベースアクセス用オブジェクト
//

if (!defined('XOOPS_ROOT_PATH')) exit();


class  XoopensimSearchparcelsdbObject extends XoopsSimpleObject
{
	function XoopensimSearchparcelsdbObject()
	{
		$this->initVar('regionUUID',		XOBJ_DTYPE_STRING, '');
		$this->initVar('parcelname',		XOBJ_DTYPE_STRING, '');
		$this->initVar('parcelUUID',		XOBJ_DTYPE_STRING, '');
		$this->initVar('landingpoint',		XOBJ_DTYPE_STRING, '');
		$this->initVar('description',		XOBJ_DTYPE_STRING, '');
		$this->initVar('searchcategory',	XOBJ_DTYPE_STRING, '');
		$this->initVar('build',				XOBJ_DTYPE_BOOL, false);
		$this->initVar('script',			XOBJ_DTYPE_BOOL, false);
		$this->initVar('public',			XOBJ_DTYPE_BOOL, false);
		$this->initVar('dwell',				XOBJ_DTYPE_FLOAT, 0);
		$this->initVar('infouuid',			XOBJ_DTYPE_STRING, '');
		$this->initVar('marture',			XOBJ_DTYPE_STRING, '');
	}
}


class  XoopensimSearchparcelsdbHandler extends XoopsObjectGenericHandler
{
	var  $mTable   = 'xoopensim_search_parcels';
	var  $mPrimary = 'regionUUID,parcelUUID';
	var  $mClass   = 'XoopensimSearchparcelsdbObject';

	function XoopensimSearchparcelsdbHandler(&$db)
	{
		parent::XoopsObjectGenericHandler($db);
	}
}


/*
CREATE TABLE `{prefix}_{dirname}_search_parcels` (
    `regionUUID`        char(36)  NOT NULL,
    `parcelname`        varchar(255) NOT NULL,
    `parcelUUID`        char(36)  NOT NULL,
    `landingpoint`      varchar(255) NOT NULL,
    `description`       varchar(255) NOT NULL,
    `searchcategory`    varchar(50)  NOT NULL, 
    `build`             enum('true','false') NOT NULL default 'false',
    `script`            enum('true','false') NOT NULL default 'false',
    `public`            enum('true','false') NOT NULL default 'false',
    `dwell`             float NOT NULL default '0',
    `infouuid`          char(36)  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=InnoDB ROW_FORMAT=DEFAULT;
*/


?>