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

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


class  XoopensimSearchparcelsalesdbObject extends XoopsSimpleObject
{
	function XoopensimSearchparcelsalesdbObject()
	{
		$this->initVar('regionUUID',	XOBJ_DTYPE_STRING, '');
		$this->initVar('parcelname',	XOBJ_DTYPE_STRING, '');
		$this->initVar('parcelUUID',	XOBJ_DTYPE_STRING, '');
		$this->initVar('area',			XOBJ_DTYPE_INT, 0);
		$this->initVar('saleprice',		XOBJ_DTYPE_INT, 0);
		$this->initVar('landingpoint',	XOBJ_DTYPE_STRING, '');
		$this->initVar('infoUUID',		XOBJ_DTYPE_STRING, '00000000-0000-0000-0000-000000000000');
		$this->initVar('dwell',			XOBJ_DTYPE_INT, 0);
		$this->initVar('parentestate',	XOBJ_DTYPE_INT, 1);
		$this->initVar('mature',		XOBJ_DTYPE_STRING, 'PG');
	}
}


class  XoopensimSearchparcelsalesdbHandler extends XoopsObjectGenericHandler
{
	var  $mTable   = 'xoopensim_search_parcelsales';
	var  $mPrimary = 'regionUUID,parcelUUID';
	var  $mClass   = 'XoopensimSearchparcelsalesdbObject';

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


/*
CREATE TABLE `{prefix}_{dirname}_search_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(32) NOT NULL default 'PG',
	PRIMARY KEY  (`regionUUID`,`parcelUUID`)
) ENGINE=InnoDB ROW_FORMAT=DEFAULT;
*/

?>