
CREATE TABLE `{pref}_vakancy` (
  `lid` int(11) NOT NULL auto_increment,
  `cid` int(11) NOT NULL default '0',
  `author` varchar(100) NOT NULL default '',
  `authormail` varchar(100) NOT NULL default '',
  `title` varchar(100) NOT NULL default '',
  `description` text NOT NULL,
  `offer` int(1) default NULL,
  `telefone` varchar(150) NOT NULL default '',
  `address` varchar(200) NOT NULL default '',
  `contact` varchar(150) NOT NULL default '',
  `salary` varchar(50) NOT NULL default '',
  `information` text NOT NULL,
  `ip` varchar(60) NOT NULL default '0',
  `hits` int(11) NOT NULL default '0',
  `date` varchar(16) default NULL,
  `status` int(1) default NULL,
  `expire` int(7) NOT NULL default '0',
  PRIMARY KEY  (`lid`),
  KEY `cid` (`cid`),
  KEY `title` (`author`)
);



CREATE TABLE `{pref}_vakancy_categories` (
  `cid` int(11) NOT NULL auto_increment,
  `title` varchar(50) NOT NULL default '',
  `parentid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`cid`),
  KEY `title` (`title`)
);



CREATE TABLE `{pref}_vakancy_comment` (
  `id` int(11) NOT NULL auto_increment,
  `cid` int(11) NOT NULL default '0',
  `date` datetime default NULL,
  `uid` int(11) NOT NULL default '0',
  `name` varchar(25) NOT NULL default '',
  `host_name` varchar(60) default NULL,
  `comment` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `cid` (`cid`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM;