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

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


class  XoopensimProfclassifiedsdbObject extends XoopsSimpleObject
{
	function XoopensimProfclassifiedsdbObject()
	{
		$this->initVar('classifieduuid',	XOBJ_DTYPE_STRING, '');
		$this->initVar('creatoruuid',		XOBJ_DTYPE_STRING, '');
		$this->initVar('creationdate',	  	XOBJ_DTYPE_INT, 0);
		$this->initVar('expirationdate',	XOBJ_DTYPE_INT, 0);
		$this->initVar('category',			XOBJ_DTYPE_STRING, '');
		$this->initVar('name',				XOBJ_DTYPE_STRING, '');
		$this->initVar('description',		XOBJ_DTYPE_TEXT, '');
		$this->initVar('parceluuid',		XOBJ_DTYPE_STRING, '');
		$this->initVar('parentestate',		XOBJ_DTYPE_INT, 0);
		$this->initVar('snapshotuuid',		XOBJ_DTYPE_STRING, '');
		$this->initVar('simname',			XOBJ_DTYPE_STRING, '');
		$this->initVar('posglobal',			XOBJ_DTYPE_STRING, '');
		$this->initVar('parcelname',		XOBJ_DTYPE_STRING, '');
		$this->initVar('classifiedflags',	XOBJ_DTYPE_INT, 0);
		$this->initVar('priceforlisting',	XOBJ_DTYPE_INT, 0);
	}
}


class  XoopensimProfclassifiedsdbHandler extends XoopsObjectGenericHandler
{
	var  $mTable   = 'xoopensim_prof_classifieds';
	var  $mPrimary = 'classifieduuid';
	var  $mClass   = 'XoopensimProfclassifiedsdbObject';

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


/*
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=MyISAM DEFAULT CHARSET=latin1;
*/
?>