<?php
defined('_JEXEC') or die('Restricted access');
class Tablejob extends JTable {
var $id = null;
var $job_title = null;
var $employer_id = null;
var $id_degree_level = null;
var $id_pos_type = null;
var $id_salary_type = null;
var $id_job_exp = null;
var $id_job_spec = null;
var $salary = null;
var $currency_salary = null;
var $id_country = null;
var $state = null;
var $city = null;
var $short_desc = null;
var $long_desc = null;
var $publish_date = null;
var $expire_date = null;
var $is_active = null;
var $is_featured = null;
var $glng = null;
var $glat = null;
var $gzoom = null;
var $address_geocode = null;
var $hotjob_expire = null;
var $manage_applicant= null;
var $ext_apply_url = null;
/**
* @param database A database connector object
*/
function __construct(&$db){
parent::__construct('#__jbjobs_job', 'id', $db);
}
}
?>
--
-- Структура таблицы `jos_jbjobs_job`
--
CREATE TABLE IF NOT EXISTS `jos_jbjobs_job` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`job_title` varchar(100) NOT NULL DEFAULT '',
`employer_id` int(11) DEFAULT NULL,
`id_degree_level` int(11) NOT NULL DEFAULT '0',
`id_pos_type` int(11) NOT NULL DEFAULT '0',
`id_salary_type` int(11) NOT NULL DEFAULT '0',
`id_job_exp` int(11) NOT NULL DEFAULT '0',
`id_job_spec` int(11) NOT NULL DEFAULT '0',
`salary` float DEFAULT NULL,
`currency_salary` char(10) DEFAULT NULL,
`id_country` int(11) NOT NULL DEFAULT '0',
`state` varchar(100) NOT NULL DEFAULT '',
`city` varchar(100) NOT NULL DEFAULT '',
`short_desc` tinytext,
`long_desc` mediumtext,
`publish_date` datetime DEFAULT '0000-00-00 00:00:00',
`expire_date` datetime DEFAULT '0000-00-00 00:00:00',
`is_active` char(1) NOT NULL DEFAULT 'y',
`is_featured` tinyint(1) NOT NULL DEFAULT '0',
`hits` int(11) NOT NULL DEFAULT '0',
`glng` varchar(15) DEFAULT NULL,
`glat` varchar(15) DEFAULT NULL,
`gzoom` varchar(2) DEFAULT NULL,
`address_geocode` varchar(250) DEFAULT NULL,
`hotjob_expire` datetime DEFAULT '0000-00-00 00:00:00',
`manage_applicant` tinyint(1) NOT NULL DEFAULT '0',
`ext_apply_url` varchar(200) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
CREATE TABLE IF NOT EXISTS `jos_zhyandexmaps_markers` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`catid` int(11) NOT NULL DEFAULT '0',
`title` varchar(250) NOT NULL DEFAULT '',
`latitude` varchar(20) NOT NULL DEFAULT '',
`longitude` varchar(20) NOT NULL DEFAULT '',
`mapid` int(11) NOT NULL DEFAULT '0',
`openbaloon` tinyint(1) NOT NULL DEFAULT '0',
`icontype` varchar(50) NOT NULL DEFAULT '',
`description` text NOT NULL,
`descriptionhtml` text NOT NULL,
`hrefsite` text NOT NULL,
`hrefimage` text NOT NULL,
`hrefsitename` text NOT NULL,
`markergroup` int(11) NOT NULL DEFAULT '0',
`showiconcontent` tinyint(1) NOT NULL DEFAULT '0',
`published` tinyint(1) NOT NULL DEFAULT '0',
`createdbyuser` int(11) NOT NULL DEFAULT '0',
`markercontent` tinyint(1) NOT NULL DEFAULT '0',
`userprotection` tinyint(1) NOT NULL DEFAULT '0',
`contactid` int(11) NOT NULL DEFAULT '0',
`iconofsetx` tinyint(1) NOT NULL DEFAULT '0',
`iconofsety` tinyint(1) NOT NULL DEFAULT '0',
`showcontact` tinyint(1) NOT NULL DEFAULT '0',
`showuser` tinyint(1) NOT NULL DEFAULT '0',
`publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`actionbyclick` tinyint(1) NOT NULL DEFAULT '1',
`zoombyclick` int(3) NOT NULL DEFAULT '100',
`params` text NOT NULL,
`attribute1` text NOT NULL,
`attribute2` text NOT NULL,
`attribute3` text NOT NULL,
`attribute4` text NOT NULL,
`attribute5` text NOT NULL,
`attribute6` text NOT NULL,
`attribute7` text NOT NULL,
`attribute8` text NOT NULL,
`attribute9` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
Если Вы уже зарегистрированы на Портале - войдите в систему, если Вы еще не регистрировались - пройдите простую процедуру регистрации.