# Php-Jobsite 1.32 MySQL-Dump
#
# Host: localhost
#Php-Jobsite 1.32 - php-jobsite@null.com
#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
没有合适的资源?快使用搜索试试~ 我知道了~
[人才房产]php-JobSite v1.32 特别版_php-jobsite.zip源码PHP项目源代码下载
共2000个文件
php:2912个
html:2231个
gif:1649个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 91 浏览量
2022-03-15
23:06:57
上传
评论
收藏 7.99MB ZIP 举报
温馨提示
[人才房产]php-JobSite v1.32 特别版_php-jobsite.zip源码PHP项目源代码下载[人才房产]php-JobSite v1.32 特别版_php-jobsite.zip源码PHP项目源代码下载 1.适合个人搭建网站项目参考 2.适合学生毕业设计搭建网站参考 3.适合小公司搭建网站项目参考
资源推荐
资源详情
资源评论
收起资源包目录
[人才房产]php-JobSite v1.32 特别版_php-jobsite.zip源码PHP项目源代码下载 (2000个子文件)
job.css 9KB
job.css 7KB
job.css 7KB
job.css 7KB
job.css 7KB
job.css 7KB
job.css 7KB
job.css 7KB
job.css 7KB
job.css 7KB
job.css 7KB
job.css 7KB
job.css 7KB
job.css 7KB
job.css 7KB
job.css 7KB
job.css 7KB
job.css 6KB
job.css 6KB
job.css 6KB
job.css 6KB
job.css 6KB
job.css 6KB
job.css 6KB
job.css 6KB
job.css 6KB
job.css 6KB
job.css 6KB
job.css 6KB
job.css 6KB
job.css 6KB
job.css 6KB
job.css 6KB
job.css 6KB
job.css 6KB
job.css 6KB
job.css 6KB
job.css 6KB
job.css 6KB
job.css 6KB
job.css 6KB
jobn.css 6KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
job.css 5KB
job.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 5KB
jobn.css 4KB
jobn.css 4KB
terms_conditions_jobseeker.html 15KB
terms_conditions_jobseeker.html 15KB
terms_conditions_jobseeker.html 15KB
terms_conditions_jobseeker.html 15KB
terms_conditions_jobseeker.html 15KB
terms_conditions_jobseeker.html 15KB
terms_conditions_jobseeker.html 15KB
terms_conditions_jobseeker.html 15KB
terms_conditions_employer.html 15KB
terms_conditions_employer.html 15KB
terms_conditions_employer.html 15KB
terms_conditions_employer.html 15KB
terms_conditions_employer.html 15KB
terms_conditions_employer.html 15KB
共 2000 条
- 1
- 2
- 3
- 4
- 5
- 6
- 20
资源评论
yxkfw
- 粉丝: 76
- 资源: 2万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功