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

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


class  XoopensimSearcheventsdbObject extends XoopsSimpleObject
{
	function XoopensimSearcheventsdbObject()
	{
		$this->initVar('uid',			XOBJ_DTYPE_INT, 0);
		$this->initVar('owneruuid',		XOBJ_DTYPE_STRING, '');
		$this->initVar('name',			XOBJ_DTYPE_STRING, '');
		$this->initVar('eventid',	  	XOBJ_DTYPE_INT, 0);
		$this->initVar('creatoruuid',	XOBJ_DTYPE_STRING, '');
		$this->initVar('category',		XOBJ_DTYPE_STRING, '');
		$this->initVar('description',	XOBJ_DTYPE_TEXT, '');
		$this->initVar('dateUTC',		XOBJ_DTYPE_INT, 0);
		$this->initVar('duration',		XOBJ_DTYPE_INT, 0);
		$this->initVar('covercharge',	XOBJ_DTYPE_INT, 0);
		$this->initVar('coveramount',	XOBJ_DTYPE_INT, 0);
		$this->initVar('simname',		XOBJ_DTYPE_STRING, '');
		$this->initVar('globalPos',		XOBJ_DTYPE_STRING, '');
		$this->initVar('eventflags',	XOBJ_DTYPE_INT, 0);
	}
}


class  XoopensimSearcheventsdbHandler extends XoopsObjectGenericHandler
{
	var  $mTable   = 'xoopensim_search_events';
	var  $mPrimary = 'eventid';
	var  $mClass   = 'XoopensimSearcheventsdbObject';

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


/*
CREATE TABLE `{prefix}_{dirname}_search_events` (
    `uid`           mediumint(8) unsigned NOT NULL default 0,
    `owneruuid`     char(36) NOT NULL,
    `name`          varchar(255) NOT NULL,
    `eventid`       int(11)  NOT NULL auto_increment,
    `creatoruuid`   char(36) NOT NULL,
    `category`      int(2)   NOT NULL,
    `description`   text NOT NULL,
    `dateUTC`       int(10) NOT NULL,
    `duration`      int(10) NOT NULL,
    `covercharge`   int(10) 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 ROW_FORMAT=DEFAULT;
*/


?>