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

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


class   XoopensimProfuserpicksdbObject extends XoopsSimpleObject
{
	function XoopensimProfuserpicksdbObject()
	{
		$this->initVar('pickuuid',	  	XOBJ_DTYPE_STRING, '');
		$this->initVar('creatoruuid',	XOBJ_DTYPE_STRING, '');
		$this->initVar('toppick',	  	XOBJ_DTYPE_BOOL, false);
		$this->initVar('parceluuid',	XOBJ_DTYPE_STRING, '');
		$this->initVar('name',			XOBJ_DTYPE_STRING, '');
		$this->initVar('description',	XOBJ_DTYPE_TEXT, '');
		$this->initVar('snapshotuuid',	XOBJ_DTYPE_STRING, '');
		$this->initVar('user',			XOBJ_DTYPE_STRING, '');
		$this->initVar('originalname',	XOBJ_DTYPE_STRING, '');
		$this->initVar('simname',		XOBJ_DTYPE_STRING, '');
		$this->initVar('posglobal',		XOBJ_DTYPE_STRING, '');
		$this->initVar('sortorder',		XOBJ_DTYPE_INT, 0);
		$this->initVar('enabled',		XOBJ_DTYPE_BOOL, false);
	}
}


class  XoopensimProfuserpicksdbHandler extends XoopsObjectGenericHandler
{
	var  $mTable   = 'xoopensim_prof_userpicks';
	var  $mPrimary = 'pickuuid';
	var  $mClass   = 'XoopensimProfuserpicksdbObject';

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


/*
CREATE TABLE IF NOT EXISTS `userpicks` (
  `pickuuid` varchar(36) NOT NULL,
  `creatoruuid` varchar(36) NOT NULL,
  `toppick` enum('true','false') NOT NULL,
  `parceluuid` varchar(36) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `snapshotuuid` varchar(36) NOT NULL,
  `user` varchar(255) NOT NULL,
  `originalname` varchar(255) NOT NULL,
  `simname` varchar(255) NOT NULL,
  `posglobal` varchar(255) NOT NULL,
  `sortorder` int(2) NOT NULL,
  `enabled` enum('true','false') NOT NULL,
  PRIMARY KEY (`pickuuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
*/

?>