-- phpMyAdmin SQL Dump
-- version 2.11.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 20, 2008 at 02:39 AM
-- Server version: 5.0.41
-- PHP Version: 5.2.5
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `jobberbase`
--
-- --------------------------------------------------------
--
-- Table structure for table `admin`
--
CREATE TABLE IF NOT EXISTS `admin` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(16) NOT NULL,
`password` varchar(32) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `admin`
--
INSERT INTO `admin` (`id`, `username`, `password`) VALUES
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3');
-- --------------------------------------------------------
--
-- Table structure for table `categories`
--
CREATE TABLE IF NOT EXISTS `categories` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(32) NOT NULL,
`var_name` varchar(32) NOT NULL,
`category_order` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `category_order` (`category_order`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='programming/design/admin/etc.' AUTO_INCREMENT=15 ;
--
-- Dumping data for table `categories`
--
INSERT INTO `categories` (`id`, `name`, `var_name`, `category_order`) VALUES
(1, 'Programmers', 'programmers', 7),
(2, 'Designers', 'designers', 3),
(3, 'Administrators', 'administrators', 0),
(7, 'Marketers', 'marketers', 2),
(5, 'Testers', 'testers', 5),
(6, 'Editors', 'editors', 1),
(8, 'Managers', 'managers', 4),
(9, 'Consultants', 'consultants', 6);
-- --------------------------------------------------------
--
-- Table structure for table `cities`
--
CREATE TABLE IF NOT EXISTS `cities` (
`id` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`ascii_name` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `cities`
--
INSERT INTO `cities` (`id`, `name`, `ascii_name`) VALUES
(1, 'Adjud', 'Adjud'),
(2, 'Alba Iulia', 'Alba-iulia'),
(3, 'Alexandria', 'Alexandria'),
(4, 'Arad', 'Arad'),
(5, 'Bac', 'Bacau'),
(6, 'Baia-Mare', 'Baia-mare'),
(7, 'B', 'Barlad'),
(8, 'Bistri', 'Bistrita'),
(9, 'Boto', 'Botosani'),
(10, 'Br', 'Braila'),
(11, 'Bra', 'Brasov'),
(12, 'Breaza', 'Breaza'),
(13, 'Bucure', 'Bucuresti'),
(14, 'Buz', 'Buzau'),
(15, 'C', 'Calarasi'),
(16, 'C', 'Campina'),
(18, 'Caracal', 'Caracal'),
(19, 'Caransebe', 'Caransebes'),
(20, 'Cernavod', 'Cernavoda'),
(22, 'Cluj-Napoca', 'Cluj-napoca'),
(23, 'Constan', 'Constanta'),
(24, 'Covasna', 'Covasna'),
(25, 'Craiova', 'Craiova'),
(26, 'Curtea de Arge', 'Curtea-de-arges'),
(27, 'Deva', 'Deva'),
(28, 'Drobeta T. Severin', 'Drobeta-t-severin'),
(29, 'Foc', 'Focsani'),
(30, 'G', 'Gaesti'),
(31, 'Gala', 'Galati'),
(32, 'Giurgiu', 'Giurgiu'),
(33, 'Hunedoara', 'Hunedoara'),
(34, 'Ia', 'Iasi'),
(36, 'Lugoj', 'Lugoj'),
(37, 'Mangalia', 'Mangalia'),
(38, 'Media', 'Medias'),
(39, 'Miercurea-Ciuc', 'Miercurea-ciuc'),
(40, 'One', 'Onesti'),
(41, 'Oradea', 'Oradea'),
(42, 'Or', 'Orsova'),
(43, 'Otopeni', 'Otopeni'),
(44, 'Pa', 'Pascani'),
(46, 'Piatra Neam', 'Piatra-neamt'),
(47, 'Pite', 'Pitesti'),
(48, 'Ploie', 'Ploiesti'),
(49, 'Reghin', 'Reghin'),
(50, 'Re', 'Resita'),
(51, 'R', 'Rimnicu-sarat'),
(52, 'R', 'Rimnicu-vilcea'),
(53, 'Roman', 'Roman'),
(54, 'Satu-Mare', 'Satu-mare'),
(55, 'Secuieni', 'Secuieni'),
(56, 'Sf', 'Sfantu-gheorghe'),
(57, 'Sibiu', 'Sibiu'),
(58, 'Sinaia', 'Sinaia'),
(59, 'Sl', 'Slanic-moldova'),
(60, 'Slatina', 'Slatina'),
(61, 'Slobozia', 'Slobozia'),
(62, 'Suceava', 'Suceava'),
(63, 'T', 'Targoviste'),
(64, 'T', 'Targu-jiu'),
(65, 'T', 'Targu Ocna'),
(66, 'Tecuci', 'Tecuci'),
(67, 'Timi', 'Timisoara'),
(68, 'T', 'Tirgu-mures'),
(69, 'Tulcea', 'Tulcea'),
(70, 'Turda', 'Turda'),
(71, 'Vaslui', 'Vaslui'),
(72, 'Zalau', 'Zalau'),
(-1, 'Anywhere', 'Anywhere');
-- --------------------------------------------------------
--
-- Table structure for table `hits`
--
CREATE TABLE IF NOT EXISTS `hits` (
`job_id` int(10) unsigned NOT NULL,
`created_on` datetime NOT NULL,
`ip` varchar(15) NOT NULL,
KEY `job_id` (`job_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `hits`
--
INSERT INTO `hits` (`job_id`, `created_on`, `ip`) VALUES
(11, '2008-08-20 02:36:27', '::1');
-- --------------------------------------------------------
--
-- Table structure for table `jobs`
--
CREATE TABLE IF NOT EXISTS `jobs` (
`id` int(10) unsigned NOT NULL auto_increment,
`type_id` int(11) NOT NULL,
`category_id` int(11) NOT NULL,
`title` varchar(100) default '',
`description` text,
`company` varchar(150) default '',
`city_id` int(11) NOT NULL,
`url` varchar(150) default NULL,
`apply` varchar(200) default '',
`created_on` timestamp NOT NULL default '0000-00-00 00:00:00',
`is_temp` tinyint(4) NOT NULL,
`is_active` tinyint(4) NOT NULL,
`views_count` int(11) NOT NULL,
`auth` varchar(32) NOT NULL,
`outside_location` varchar(150) NOT NULL,
`poster_email` varchar(100) NOT NULL,
`apply_online` tinyint(4) NOT NULL,
PRIMARY KEY (`id`),
KEY `type_id` (`type_id`),
KEY `category_id` (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
--
-- Dumping data for table `jobs`
--
INSERT INTO `jobs` (`id`, `type_id`, `category_id`, `title`, `description`, `company`, `city_id`, `url`, `apply`, `created_on`, `is_temp`, `is_active`, `views_count`, `auth`, `outside_location`, `poster_email`, `apply_online`) VALUES
(1, 1, 1, 'web developer', 'We\\''re a startup searching for a cool web developer that masters following technologies:\r\n* php, mysql\r\n* javascript, dom, ajax\r\n* html, css\r\n\r\nPerson should also have a good sens of user behavior.\r\n\r\nExcellent payment! ;)', 'Foo Inc.', -1, 'http://www.fooinc.com', '', '2008-08-20 02:35:29', 0, 1, 10, 'f1acd80152446f4cf8a0bb8242398be7', 'sss', 'jobs@fooinc.com', 1),
(2, 3, 2, 'Illustrator/Photoshop expert', 'Could you redraw in Illustrator da Vinci\\''s Gioconda, blindfolded?\r\nLet us know! :)', 'UnrealExpectations', -1, 'http://unrealexpectations.com', '', '2008-08-20 02:35:37', 0, 1, 6, '6ebcfde637d98a9738c024c6074e945d', '', 'jobs@unrealexpectations.com', 1),
(4, 1, 1, 'web developer 3', 'We\\''re a startup searching for a cool web developer that masters following technologies:\r\n* php, mysql\r\n* javascript, dom, ajax\r\n* html, css\r\n\r\nPerson should also have a good sens of user behavior.\r\n\r\nExcellent payment! ;)', 'Foo Inc.', -1, 'http://www.fooinc.com', '', '2008-08-20 02:35:45', 0, 1, 8, 'f1acd80152446f4cf8a0bb8242398be7', 'London, UK', 'jobs@fooinc.com', 1),
(5, 1, 1, 'web developer 2', 'We\\''re a startup searching for a cool web developer that masters following technologies:\r\n* php, mysql\r\n* javascript, dom, ajax\r\n* html, css\r\n\r\nPerson should also have a good sens of user behavior.\r\n\r\nExcellent payment! ;)', 'Foo Inc.', -1, 'http://www.fooinc.com', '', '2008-08-20 02:35:52', 0, 1, 6, 'f1acd80152446f4cf8a0bb8242398be7', 'London, UK', 'jobs@fooinc.com', 1),
(11, 1, 3, 'nice developer needed', 'asdfsd', 'temp name', 1, 'http://google.com', '', '2008-08-20 02:35:57', 0, 1, 2, '2e3f1e857af3a4e191f453d747fbf212', '', 'jobs@fooinc.com', 1);
-- --------------------------------------------------------
--
-- Table structure for table `job_applications`
--
CREATE TABLE IF NOT EXISTS `job_applications` (
`id` int(10) unsigned NOT NULL auto_increment,
`job_id` int(10) unsigned NOT NULL,
`created_on` datetime NOT NULL,
`ip` varchar(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `job_applications`
--
-- --------------------------------------------------------
--
-- Table structure for table `job_params`
--
CREATE TABLE IF NOT EXISTS `job_params` (
`id` int(11) unsigned NOT NULL auto_increment,
`value` varchar(50) NOT NULL,
`categ` varchar(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=33 ;
--
-- Dumping data for table `job_params`
--
INSERT INTO `job_params` (`id`, `value`, `categ`) VALUES
(1, 'php/mysql', 'know-how'),
(2, '.net', 'know-how'),
(3, 'xhtml/css', 'know-how'),
(4, 'graphic design', 'know-how'),
(5, 'small team', 'company'),
(6, 'large company', 'company'),
(7, 'ruby/rails', 'know-how'),
(8, 'oracle', 'know-how'),
(9, 'c/c++/c#', 'know-how'),
(10, 'javascript/ajax', 'know-how'),
(11, 'java', 'know-how'),
(12, 'flash', 'know-how'),
(13, 'junior', 'level'),
(14, 'senior', 'level'),
(15, 'full-time', 'type'),
(16, 'part-time', 'type'),
(17, 'freelance', 'type'),
(18, 'sysadmin', 'know-how'),
(19, 'linux/server admin', 'know-how'),
(20, 'erp/sap', 'know-how'),
(21, 'copywriting/editare', 'know-how'),
(22, 'seo/sem', 'know-how'),
(23, 'manager', 'know-how'),
(24, 'work from home', 'company'),
(25, 'work at the office', 'company'),
(28, 'internship', 'type'),
(29, 'medium', 'level'),
(30, 'python', 'know-how'),
(31, 'bonuses', 'company'),
(32, 'training', 'company');
-- --------------------------------------------------------
--
-- Table structure for table `job_requests`
--
CREATE TABLE IF NOT EXISTS `job_requests` (
`id` int(11) unsigned NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
`email` varchar(50) NOT NULL,
`created_on` datetime NOT NULL,
`ip` varchar(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `job_requests`
--
INSERT INTO `job_requests` (`id`, `name`, `email`, `created_on`, `ip`) VALUES
(1, 'asdf', 'me@filipcte.ro', '2008-01-30 00:10:28', '127.0.0.1'),
(2, 'asdf', 'me@filipcte.ro', '2008-01-30 00:10:48', '127.0.0.1'),
(3, 'asdf', 'me@filipcte.ro', '2008-01-30 00:11:56', '127.0.0.1');
-- --------------------------------------------------------
--
-- Table structure for table `job_requests_params`
--
CREATE TABLE IF NOT EXISTS `job_requests_params` (
`request_id` int(10) unsigned NOT NULL,
`param_id` int(10) unsigned NOT NULL,
KEY `request_id` (`request_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `job_requests_params`
--
INSERT INTO `job_requests_params` (`request_id`, `param_id`) VALUES
(1, 17),
(1, 31),
(1, 5),
(1, 32),
(1, 10),
(1, 1),
(1, 3),
(1, 14),
(2, 17),
(2, 31),
(2, 5),
(2, 32),
(2, 10),
(2, 1),
(2, 3),
(2, 14),
(3, 17),
(3, 31),
(3, 5),
(3, 32),
(3, 10),
(3, 1),
(3, 3),
(3, 14);
-- --------------------------------------------------------
--
-- Table structure for table `pages`
--
CREATE TABLE IF NOT EXISTS `pages` (
`id` int(11) NOT NULL auto_increment,
`url` varchar(255) NOT NULL,
`page_title` varchar(255) NOT NULL,
`keywords` text NOT NULL,
`description` text NOT NULL,
`title` varchar(255) NOT NULL,
`content` text NOT NULL,
`has_form` enum('0','1') NOT NULL,
`form_message` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
--
-- Dumping data for table `pages`
--
INSERT INTO `pages` (`id`, `url`, `page_title`, `keywords`, `description`, `title`, `content`, `has_form`, `form_message`) VALUES
(1, 'about', 'About Us', '', '', 'About Us', 'Hello!
\r\nThis job board is an open source implementation of www.jobber.ro.
\r\nDon''t hesitate to contact us!
', '0', ''),
(5, 'contact', 'Contact Us', '', '', 'We really appreciate feedback!', 'E-mail us at hello [at] domain [dot] com or use the form below:
', '1', 'Thank you for your message! :)
'),
(4, 'widgets', 'Widgets', '', '', 'Site widget', 'Would you like to display our latest jobs on your site?
\r\nInsert one of the following snippets in your page''s HTML code, in the position where the ads should appear:
\r\n\r\n- Get latest 5 jobs from all categories and all types, posted in the past 7 days, in random order:\r\n
<script src="http://localhost/jobber/api/api.php?action=getJobs
&type=0&category=0&count=5&random=1&days_behind=7&response=js" type="text/javascript"></script>
<script type="text/javascript">showJobs(''jobber-container'', ''jobber-list'');</script>
\r\n \r\n- Get last 10 full-time jobs for programmers, posted in the past 15 days, ordered by publish date (newest on top):\r\n
<script src="http://localhost/jobber/api/api.php?action=getJobs
&type=fulltime&category=programmers&count=10&random=0&days_behind=15&response=js"
type="text/javascript"></script>
<script type="text/javascript">showJobs(''jobber-container'', ''jobber-list'');</script>
\r\n \r\n- Get latest jobs published by a company (e.g. Google):\r\n
<script src="http://localhost/jobber/api/api.php?action=getJobsByCompany
&company=google&count=10&response=js" type="text/javascript"></script>
<script type="text/javascript">showJobs(''jobber-container'', ''jobber-list'');</script>
\r\n \r\n
\r\nThe parameters you can use when calling the API, are:
\r\n\r\n- action: "getJobs" - all jobs / "getJobsByCompany" - a single company''s jobs
\r\n- type: "0" - toate / "fulltime" / "parttime" / "freelance";
\r\n- category: "0" - all / "programmers" / "designers" / "administrators" / "managers" / "testers" / "editors";
\r\n- count: number of job ads to display;
\r\n- random: "1" - display randomly / "0" - display ordered by publish date (newest on top);
\r\n- days_behind: get only jobs posted in the past X days (type "0" if you don''t want to limit this);
\r\n- response: "js" - returns jobs as JavaScript code / "json" - returns only a JSON string / "xml" - returns an XML.
\r\n
\r\nUse CSS to style the list:
\r\nul.jobber-list {
list-style-type: none;
margin: 0;
padding: 0;
}
ul.jobber-list li {
margin-bottom: 5px;
}', '0', '');
-- --------------------------------------------------------
--
-- Table structure for table `searches`
--
CREATE TABLE IF NOT EXISTS `searches` (
`id` int(10) unsigned NOT NULL auto_increment,
`keywords` varchar(100) NOT NULL,
`created_on` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `searches`
--
-- --------------------------------------------------------
--
-- Table structure for table `spam_reports`
--
CREATE TABLE IF NOT EXISTS `spam_reports` (
`id` int(11) NOT NULL auto_increment,
`the_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`ip` varchar(15) NOT NULL,
`job_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `spam_reports`
--
-- --------------------------------------------------------
--
-- Table structure for table `types`
--
CREATE TABLE IF NOT EXISTS `types` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(16) NOT NULL,
`var_name` varchar(32) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='full-time/freelance' AUTO_INCREMENT=4 ;
--
-- Dumping data for table `types`
--
INSERT INTO `types` (`id`, `name`, `var_name`) VALUES
(1, 'Full-time', 'fulltime'),
(2, 'Part-time', 'parttime'),
(3, 'Freelance', 'freelance');