# Php-Jobsite 1.32 MySQL-Dump
#
# Host: localhost
#Php-Jobsite 1.32 -
[email protected]
#Php-Jobsite 1.32
#
# Table structure for table `delphpjob_companies`
#
CREATE TABLE delphpjob_companies (
compid int(5) NOT NULL default '0',
email varchar(255) NOT NULL default '',
password varchar(20) NOT NULL default '',
company varchar(255) NOT NULL default '',
comp_contact varchar(90) NOT NULL default '',
address varchar(255) NOT NULL default '',
city varchar(255) NOT NULL default '',
postalcode varchar(20) NOT NULL default '',
province varchar(255) NOT NULL default '',
locationid int(3) NOT NULL default '0',
phone varchar(20) NOT NULL default '',
fax varchar(20) NOT NULL default '',
logo varchar(10) NOT NULL default '',
description blob NOT NULL,
url varchar(255) NOT NULL default '',
hide_address char(3) NOT NULL default '',
hide_location char(3) NOT NULL default '',
hide_phone char(3) NOT NULL default '',
hide_fax char(3) NOT NULL default '',
hide_email char(3) NOT NULL default '',
hide_contact char(3) NOT NULL default '',
discount float(6,2) NOT NULL default '0.00',
signupdate date NOT NULL default '0000-00-00',
lastlogin datetime NOT NULL default '0000-00-00 00:00:00',
lastip varchar(50) NOT NULL default '',
comp_akey varchar(20) NOT NULL default '',
comp_akey_status tinyint(1) NOT NULL default '1',
featured tinyint(1) NOT NULL default '0',
expire date NOT NULL default '0000-00-00',
company_notes text NOT NULL,
company_suspended tinyint(1) NOT NULL default '0',
comp_type enum('E','R') NOT NULL default 'E',
hear_about varchar(255) NOT NULL default '',
hear_text varchar(255) NOT NULL default '',
comp_joblink tinyint(1) NOT NULL default '0',
KEY compid (compid)
);
#
# Table structure for table `delphpjob_jobs`
#
CREATE TABLE delphpjob_jobs (
jobid int(5) NOT NULL default '0',
compid int(5) NOT NULL default '0',
jobtitle varchar(100) NOT NULL default '',
description blob NOT NULL,
jobcategoryid int(2) NOT NULL default '0',
jobsubcategoryid int(5) NOT NULL default '0',
locationid int(3) NOT NULL default '0',
degreeid int(2) NOT NULL default '1',
jobtypeids varchar(25) NOT NULL default '0',
salary varchar(20) NOT NULL default '0',
salary_type enum('1','2','3','4') NOT NULL default '4',
salary_currency varchar(10) NOT NULL default '',
city varchar(100) NOT NULL default '',
province varchar(100) NOT NULL default '',
skills blob NOT NULL,
featuredjob char(1) NOT NULL default '',
jobdate date NOT NULL default '0000-00-00',
jobpostdate date NOT NULL default '0000-00-00',
jpostlanguage char(3) NOT NULL default '',
languageids varchar(50) NOT NULL default '',
experience int(2) NOT NULL default '0',
job_company varchar(100) NOT NULL default '',
hide_compname char(3) NOT NULL default '',
contact_name varchar(100) NOT NULL default '',
hide_contactname char(3) NOT NULL default '',
contact_email varchar(100) NOT NULL default '',
hide_contactemail char(3) NOT NULL default '',
contact_phone varchar(32) NOT NULL default '',
hide_contactphone char(3) NOT NULL default '',
contact_fax varchar(32) NOT NULL default '',
hide_contactfax char(3) NOT NULL default '',
job_link varchar(255) NOT NULL default '',
job_reference varchar(40) NOT NULL default '',
jobexpire date NOT NULL default '0000-00-00',
job_active tinyint(1) NOT NULL default '0',
job_suspended tinyint(1) NOT NULL default '0',
job_opid int(10) NOT NULL default '0',
job_externalid varchar(30) NOT NULL default '',
job_contacttype tinyint(1) NOT NULL default '1',
job_applytext text NOT NULL,
KEY jobid (jobid),
KEY `jobdate` (`jobdate`)
);
#
# Table structure for table `delphpjob_membership`
#
CREATE TABLE delphpjob_membership (
compid int(5) NOT NULL default '0',
pricing_id mediumint(3) NOT NULL default '0'
);
#
# Table structure for table `delphpjob_persons`
#
CREATE TABLE delphpjob_persons (
persid int(5) NOT NULL default '0',
email varchar(255) NOT NULL default '',
password varchar(20) NOT NULL default '',
name varchar(255) NOT NULL default '',
address varchar(255) NOT NULL default '',
city varchar(255) NOT NULL default '',
postalcode varchar(20) NOT NULL default '',
province varchar(255) NOT NULL default '',
locationid int(3) NOT NULL default '0',
phone varchar(20) NOT NULL default '',
fax varchar(20) NOT NULL default '',
gender char(1) NOT NULL default '',
birthyear varchar(4) NOT NULL default '0000',
url varchar(255) NOT NULL default '',
hide_name char(3) NOT NULL default '',
hide_address char(3) NOT NULL default '',
hide_location char(3) NOT NULL default '',
hide_phone char(3) NOT NULL default '',
hide_email char(3) NOT NULL default '',
signupdate date NOT NULL default '0000-00-00',
lastlogin datetime NOT NULL default '0000-00-00 00:00:00',
lastip varchar(50) NOT NULL default '',
pers_akey varchar(20) NOT NULL default '',
pers_akey_status tinyint(1) NOT NULL default '1',
person_notes text NOT NULL,
person_suspended tinyint(1) NOT NULL default '0',
hear_about varchar(255) NOT NULL default '',
hear_text varchar(255) NOT NULL default '',
PRIMARY KEY (persid)
);
#
# Table structure for table `delphpjob_resumes`
#
CREATE TABLE delphpjob_resumes (
resumeid int(5) NOT NULL default '0',
persid int(5) NOT NULL default '0',
summary varchar(100) NOT NULL default '',
pers_name varchar(120) NOT NULL default '',
resume blob NOT NULL,
education blob NOT NULL,
workexperience blob NOT NULL,
degreeid int(2) NOT NULL default '1',
confidential char(1) NOT NULL default '',
jobtypeids varchar(15) NOT NULL default '',
locationids blob NOT NULL,
jobcategoryids blob NOT NULL,
ressubcategoryids blob NOT NULL,
salary varchar(20) NOT NULL default '0',
salary_type enum('1','2','3','4') NOT NULL default '4',
salary_currency varchar(10) NOT NULL default '',
skills blob NOT NULL,
resumedate date NOT NULL default '0000-00-00',
languageids varchar(50) NOT NULL default '',
postlanguage char(3) NOT NULL default '',
experience int(2) NOT NULL default '0',
resume_city varchar(60) NOT NULL default '',
resume_province varchar(60) NOT NULL default '',
resumeexpire date NOT NULL default '0000-00-00',
resume_active tinyint(1) NOT NULL default '0',
resume_suspended tinyint(1) NOT NULL default '0',
resume_cv varchar(100) NOT NULL default '',
PRIMARY KEY (resumeid)
);
#
# Table structure for table `phpjob_bulkmail`
#
CREATE TABLE `phpjob_bulkmail` (
`bulk_id` int(5) NOT NULL auto_increment,
`bulk_date` date NOT NULL default '0000-00-00',
`bulk_type` varchar(20) NOT NULL default '',
`bulk_html` char(3) NOT NULL default '',
`bulk_subject` varchar(255) NOT NULL default '',
`bulk_message` longtext NOT NULL,
`bulk_addsign` char(3) NOT NULL default '',
`bulk_addheader` char(3) NOT NULL default '',
`bulk_addfooter` char(3) NOT NULL default '',
`bulk_list` longtext NOT NULL,
`bulk_processed` longtext NOT NULL,
PRIMARY KEY (`bulk_id`)
);
#
# Table structure for table `phpjob_categcount`
#
CREATE TABLE `phpjob_categcount` (
jobcategoryid int(3) NOT NULL default '0',
job_count int(11) NOT NULL default '0'
);
#
# Dumping data for table `phpjob_categcount`
#
INSERT INTO `phpjob_categcount` VALUES (10, 0);
INSERT INTO `phpjob_categcount` VALUES (11, 0);
INSERT INTO `phpjob_categcount` VALUES (12, 0);
INSERT INTO `phpjob_categcount` VALUES (13, 0);
INSERT INTO `phpjob_categcount` VALUES (14, 0);
INSERT INTO `phpjob_categcount` VALUES (15, 0);
INSERT INTO `phpjob_categcount` VALUES (16, 0);
INSERT INTO `phpjob_categcount` VALUES (17, 0);
INSERT INTO `phpjob_categcount` VALUES (18, 0);
INSERT INTO `phpjob_categcount` VALUES (19, 0);
INSERT INTO