sql.sql

UCH求职招聘插件。 1.个人简历发布（可设置简历状态隐私

CREATE TABLE `uchome_job_collect` (
  `cid` int(10) unsigned NOT NULL auto_increment COMMENT '序列',
  `cuid` int(10) unsigned NOT NULL COMMENT 'UID',
  `collect` int(10) unsigned NOT NULL COMMENT '收藏',
  `apply` int(10) unsigned NOT NULL COMMENT '应聘',
  `corpid` int(10) unsigned NOT NULL COMMENT '公司',
  `jobid` int(10) unsigned NOT NULL COMMENT '工作',
  `applyinfo` mediumtext NOT NULL COMMENT '状态',
  `dateline` int(10) unsigned NOT NULL COMMENT '时间',
  PRIMARY KEY  (`cid`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk;

CREATE TABLE `uchome_job_company` (
  `id` int(10) unsigned NOT NULL auto_increment COMMENT '公司序列',
  `uid` int(10) unsigned NOT NULL COMMENT 'UID',
  `corptitle` varchar(200) NOT NULL COMMENT '公司名称',
  `industry` varchar(50) NOT NULL COMMENT '行业',
  `subindustry` varchar(50) NOT NULL COMMENT '行业',
  `corpprovince` varchar(50) NOT NULL COMMENT '公司地点省',
  `corpcity` varchar(50) NOT NULL COMMENT '公司地点市',
  `corptype` int(2) unsigned NOT NULL COMMENT '公司类型',
  `corpsize` int(2) unsigned NOT NULL COMMENT '公司规模',
  `corpcontact` varchar(20) NOT NULL COMMENT '联系人',
  `corpemail` varchar(50) NOT NULL COMMENT '邮件',
  `corpphone` int(20) unsigned NOT NULL COMMENT '电话',
  `corpfax` int(20) unsigned NOT NULL COMMENT '传真',
  `corpaddress` varchar(200) NOT NULL COMMENT '地址',
  `corpzipcode` varchar(10) NOT NULL COMMENT '邮编',
  `corpregarea` int(2) unsigned NOT NULL COMMENT '注册所在地',
  `corpregyear` int(4) unsigned NOT NULL COMMENT '注册时间年',
  `corpregmonth` int(2) unsigned NOT NULL COMMENT '注册时间月',
  `corpreguser` varchar(20) NOT NULL COMMENT '注册人',
  `corpdescription` text NOT NULL COMMENT '公司简介',
  `corpintro` text NOT NULL COMMENT '详细介绍',
  PRIMARY KEY  (`id`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk;

CREATE TABLE `uchome_job_newjobs` (
  `id` int(10) unsigned NOT NULL auto_increment COMMENT '工作序列',
  `uid` int(10) unsigned NOT NULL,
  `title` varchar(200) character set gb2312 NOT NULL COMMENT '招聘名称',
  `department` varchar(150) NOT NULL COMMENT '招聘部门',
  `number` varchar(100) NOT NULL COMMENT '招聘编号',
  `corpid` int(10) unsigned NOT NULL COMMENT '公司名称id',
  `corptitle` varchar(200) NOT NULL COMMENT '公司名称',
  `jobtype` int(2) unsigned NOT NULL COMMENT '工作类型',
  `days` int(10) unsigned NOT NULL COMMENT '有效期',
  `pcount` int(10) unsigned NOT NULL COMMENT '招聘人数',
  `displayorder` int(10) unsigned NOT NULL COMMENT '职位排序',
  `jobprovince` varchar(50) NOT NULL COMMENT '工作地点省',
  `jobcity` varchar(50) NOT NULL COMMENT '工作地点市',
  `industry` varchar(50) NOT NULL COMMENT '工作行业',
  `subindustry` varchar(50) NOT NULL COMMENT '工作行业',
  `position` varchar(50) NOT NULL COMMENT '职位职能',
  `subposition` varchar(50) NOT NULL COMMENT '职位职能',
  `emolumenttype` int(2) unsigned NOT NULL COMMENT '薪资范围币种',
  `emolument` int(2) unsigned NOT NULL COMMENT '薪资范围数量',
  `subsidy` varchar(200) NOT NULL COMMENT '其他待遇',
  `jobintro` mediumtext NOT NULL COMMENT '职位介绍',
  `seniority` int(2) unsigned NOT NULL COMMENT '工作经验',
  `entrytype` int(2) unsigned NOT NULL COMMENT '到岗时间',
  `edudegree` int(2) unsigned NOT NULL COMMENT '学历要求',
  `language` int(2) unsigned NOT NULL COMMENT '语言要求',
  `languagelevel` int(2) unsigned NOT NULL COMMENT '语言要求',
  `jobcontact` varchar(20) NOT NULL COMMENT '联系人',
  `jobemail` varchar(50) NOT NULL COMMENT '联系邮件',
  `jobphone` int(15) unsigned NOT NULL COMMENT '联系电话',
  `jobaddress` varchar(100) NOT NULL COMMENT '地址',
  `jobzipcode` int(15) unsigned NOT NULL COMMENT '邮政编码',
  `jobstatus` mediumtext NOT NULL COMMENT '发布类型',
  `resumefilter` varchar(100) NOT NULL COMMENT '应聘条件',
  `dateline` int(10) unsigned NOT NULL,
  `num` int(20) unsigned NOT NULL COMMENT '收藏数',
  `view` int(20) unsigned NOT NULL COMMENT '浏览数',
  `verify` int(2) unsigned NOT NULL COMMENT '审核',
  `draft` int(2) unsigned NOT NULL COMMENT '草稿',
  PRIMARY KEY  (`id`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk;

CREATE TABLE `uchome_job_resumes` (
  `resumetitle` varchar(30) NOT NULL COMMENT '简历名称',
  `hasexperience` int(1) unsigned NOT NULL COMMENT '工作经验',
  `workstatus` int(1) unsigned NOT NULL COMMENT '求职状态',
  `resumestatus` int(1) unsigned NOT NULL COMMENT '简历状态',
  `name` varchar(10) NOT NULL COMMENT '姓名',
  `email` varchar(50) NOT NULL COMMENT 'Email',
  `sex` int(1) unsigned NOT NULL COMMENT '性别',
  `marry` int(1) unsigned NOT NULL COMMENT '婚恋状态',
  `birthyear` int(4) unsigned NOT NULL COMMENT '生日-年',
  `birthmonth` int(2) unsigned NOT NULL COMMENT '生日-月',
  `birthday` int(2) unsigned NOT NULL COMMENT '生日-日',
  `blood` int(1) unsigned NOT NULL COMMENT '血型',
  `birthprovince` varchar(20) NOT NULL COMMENT '出生地-省',
  `birthcity` varchar(20) NOT NULL COMMENT '出生地-市',
  `resideprovince` varchar(20) NOT NULL COMMENT '居住地-省',
  `residecity` varchar(20) NOT NULL COMMENT '居住地-市',
  `area` int(2) unsigned NOT NULL COMMENT '国家或地区',
  `nationality` int(2) unsigned NOT NULL COMMENT '民族',
  `politicsstatus` int(2) unsigned NOT NULL COMMENT '政治面貌',
  `censusprovince` varchar(20) NOT NULL COMMENT '户口所在地-省',
  `censuscity` varchar(20) NOT NULL COMMENT '户口所在地-市',
  `idcardtype` int(2) unsigned NOT NULL COMMENT '证件类型',
  `idcard` int(20) unsigned NOT NULL COMMENT '证件序号',
  `edudegree` int(2) unsigned NOT NULL COMMENT '教育程度',
  `school` varchar(255) NOT NULL COMMENT '毕业院校',
  `emolumenttype` int(2) unsigned NOT NULL COMMENT '目前年薪-币种',
  `emolument` int(2) unsigned NOT NULL COMMENT '目前年薪-数量',
  `seniority` int(2) unsigned NOT NULL COMMENT '工作年限',
  `contacttype` int(2) unsigned NOT NULL COMMENT '联系方式',
  `mophone` varchar(15) NOT NULL COMMENT '手机',
  `homephone` varchar(15) NOT NULL COMMENT '家庭电话',
  `officephone` varchar(20) NOT NULL COMMENT '公司电话',
  `address` varchar(200) NOT NULL COMMENT '地址',
  `postcode` int(6) unsigned NOT NULL COMMENT '邮编',
  `blogurl` varchar(100) NOT NULL COMMENT '博客地址',
  `homepageurl` varchar(100) NOT NULL COMMENT '个人主页',
  `description` mediumtext NOT NULL COMMENT '自我评价',
  `hopejobtype` int(2) unsigned NOT NULL COMMENT '工作类型',
  `hasoverseas` int(2) unsigned NOT NULL COMMENT '海外工作经验',
  `hopesubposition` varchar(255) NOT NULL COMMENT '意向工作职能',
  `hopeposition` varchar(255) NOT NULL,
  `hopesubindustry` varchar(255) NOT NULL COMMENT '意向工作行业',
  `hopeindustry` varchar(255) NOT NULL,
  `specialty` varchar(100) NOT NULL COMMENT '专业特长',
  `hopeprovince1` varchar(20) NOT NULL COMMENT '首选工作地点-省',
  `hopecity1` varchar(20) NOT NULL COMMENT '首选工作地点-市',
  `hopeprovince2` varchar(20) NOT NULL COMMENT '二选工作地点-省',
  `hopecity2` varchar(20) NOT NULL COMMENT '二选工作地点-市',
  `hopeprovince3` varchar(20) NOT NULL COMMENT '三选工作地点-省',
  `hopecity3` varchar(20) NOT NULL COMMENT '三选工作地点-市',
  `language1` int(2) unsigned NOT NULL COMMENT '第一语言-语种',
  `language1level` int(2) unsigned NOT NULL COMMENT '第一语言-等级',
  `language2` int(2) unsigned NOT NULL COMMENT '第二语言-语种',
  `language2level` int(2) unsigned NOT NULL COMMENT '第二语言-等级',
  `language3` int(2) unsigned NOT NULL COMMENT '第三语言-语种',
  `language3level` int(2) unsigned NOT NULL COMMENT '第三语言-等级',
  `hopeemolumenttype` int(2) unsigned NOT NULL COMMENT '期望薪资-币种',
  `hopeemolument` int(2) unsigned NOT NULL COMMENT '期望薪资-数量',
  `entrytype` int(2) unsigned NOT NULL COMMENT '到岗时间',
  `customresume` mediumtext NOT NULL COMMENT '自定义简历',
  `industry` varchar(50) NOT NULL COMMENT '当前工作行业-主类',
  `subindustry` varchar(50) NOT NULL COMMENT '当前工作行业-辅类',
  `position` varchar(50) NOT NULL COMMENT '当前工作职能-主类',
  `subposition` varchar(50) NOT NULL COMMENT '当前工作职能-辅类',
  `id` int(20) unsigned NOT NULL auto_increment COMMENT '简历序列',
  `uid` mediumint(10) unsigned NOT NULL COMMENT 'UID',
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `dateline` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk;

CREATE TABLE `uchome_job_study` (
  `id` int(10) unsigned NOT NULL auto_increment COMMENT '序列',
  `uid` int(10) unsigned NOT NULL COMMENT 'UID',
  `beginyear` int(4) unsigned NOT NULL COMMENT '开始时间年',
  `beginmonth` int(2) unsigned NOT NULL COMMENT '开始时间月',
  `finishyear` int(4) unsigned NOT NULL COMMENT '结束时间年',
  `finishmonth` int(2) unsigned NOT NULL COMMENT '结束时间月',
  `school` varchar(60) NOT NULL COMMENT '学校',
  `major` varchar(40) NOT NULL COMMENT '专业',
  `submajor` varchar(40) NOT NULL COMMENT '专业',
  `edudegree` int(2) unsigned NOT NULL COMMENT '学历',
  `description` text NOT NULL COMMENT '学业描述',
  PRIMARY KEY  (`id`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk;

CREATE TABLE `uchome_job_visitor` (
  `vid` mediumint(8) unsigned NOT NULL default '0',
  `vuid` mediumint(8) unsigned NOT NULL default '0',
  `vusername` char(15) NOT NULL,
  `type` varchar(50) NOT NULL,
  `dateline` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`vid`,`vuid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

CREATE TABLE `uchome_job_work` (
  `id` int(10) unsigned NOT NULL auto_increment COMMENT '序列',
  `uid` int(10) unsigned NOT NULL COMMENT 'UID',
  `beginyear` int(4) unsigned NOT NULL COMMENT '开始时间年',
  `beginmonth` int(2) unsigned NOT NULL COMMENT '开始时间月',
  `finishyear` int(4) unsigned NOT NULL COMMENT '截止时间年',
  `finishmonth` int(2) unsigned NOT NULL COMMENT '截止时间月',
  `company` varchar(40) NOT NULL COMMENT '公司',
  `companysite` varchar(40) NOT NULL COMMENT '公司网址',
  `industry` varchar(50) NOT NULL COMMENT '行业',
  `subindustry` varchar(50) NOT NULL COMMENT '行业',
  `companytype` int(2) unsigned NOT NULL COMMENT '公司类型',
  `department` varchar(40) NOT NULL COMMENT '部门',
  `position` varchar(50) NOT NULL COMMENT '职位',
  `subposition` varchar(50) NOT NULL COMMENT '职位',
  `description` text NOT NULL COMMENT '工作描述',
  `reportto` varchar(20) NOT NULL COMMENT '汇报对象',
  `underlingnumber` varchar(20) NOT NULL COMMENT '下属人数',
  `witness` varchar(20) NOT NULL COMMENT '证明人',
  `leavingreason` varchar(60) NOT NULL COMMENT '离职原因',
  `achievement` text NOT NULL COMMENT '主要业绩',
  PRIMARY KEY  (`id`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk;