You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
162 lines
6.9 KiB
162 lines
6.9 KiB
DROP TABLE IF EXISTS `destoon_job_9`;
|
|
CREATE TABLE `destoon_job_9` (
|
|
`itemid` bigint(20) unsigned NOT NULL auto_increment,
|
|
`catid` int(10) unsigned NOT NULL default '0',
|
|
`areaid` int(10) unsigned NOT NULL default '0',
|
|
`level` tinyint(1) unsigned NOT NULL default '0',
|
|
`title` varchar(100) NOT NULL default '',
|
|
`style` varchar(50) NOT NULL default '',
|
|
`fee` float NOT NULL default '0',
|
|
`award` decimal(10,2) unsigned NOT NULL default '0.00',
|
|
`introduce` varchar(255) NOT NULL default '',
|
|
`keyword` varchar(255) NOT NULL default '',
|
|
`pptword` varchar(255) NOT NULL default '',
|
|
`department` varchar(100) NOT NULL default '',
|
|
`total` smallint(4) unsigned NOT NULL default '0',
|
|
`minsalary` int(10) unsigned NOT NULL default '0',
|
|
`maxsalary` int(10) unsigned NOT NULL default '0',
|
|
`type` tinyint(1) unsigned NOT NULL default '0',
|
|
`gender` tinyint(1) unsigned NOT NULL default '0',
|
|
`marriage` tinyint(1) unsigned NOT NULL default '0',
|
|
`education` smallint(2) unsigned NOT NULL default '0',
|
|
`experience` smallint(2) unsigned NOT NULL default '0',
|
|
`minage` smallint(2) unsigned NOT NULL default '0',
|
|
`maxage` smallint(2) unsigned NOT NULL default '0',
|
|
`hits` int(10) unsigned NOT NULL default '0',
|
|
`likes` int(10) unsigned NOT NULL default '0',
|
|
`hates` int(10) unsigned NOT NULL default '0',
|
|
`favorites` int(10) unsigned NOT NULL default '0',
|
|
`awards` int(10) unsigned NOT NULL default '0',
|
|
`shares` int(10) unsigned NOT NULL default '0',
|
|
`reports` int(10) unsigned NOT NULL default '0',
|
|
`comments` int(10) unsigned NOT NULL default '0',
|
|
`thumb` varchar(255) NOT NULL,
|
|
`apply` int(10) unsigned NOT NULL default '0',
|
|
`username` varchar(30) NOT NULL default '',
|
|
`groupid` smallint(4) unsigned NOT NULL default '0',
|
|
`company` varchar(100) NOT NULL default '',
|
|
`vip` smallint(2) unsigned NOT NULL default '0',
|
|
`validated` tinyint(1) unsigned NOT NULL default '0',
|
|
`truename` varchar(30) NOT NULL default '',
|
|
`telephone` varchar(50) NOT NULL default '',
|
|
`mobile` varchar(50) NOT NULL default '',
|
|
`address` varchar(255) NOT NULL default '',
|
|
`email` varchar(50) NOT NULL default '',
|
|
`qq` varchar(20) NOT NULL default '',
|
|
`wx` varchar(50) NOT NULL default '',
|
|
`ali` varchar(30) NOT NULL default '',
|
|
`skype` varchar(30) NOT NULL default '',
|
|
`sex` tinyint(1) unsigned NOT NULL default '1',
|
|
`totime` int(10) unsigned NOT NULL default '0',
|
|
`editor` varchar(30) NOT NULL default '',
|
|
`edittime` int(10) unsigned NOT NULL default '0',
|
|
`editdate` date NOT NULL default '0000-00-00',
|
|
`addtime` int(10) unsigned NOT NULL default '0',
|
|
`adddate` date NOT NULL default '0000-00-00',
|
|
`ip` varchar(50) NOT NULL default '',
|
|
`template` varchar(30) NOT NULL default '0',
|
|
`status` tinyint(1) NOT NULL default '0',
|
|
`linkurl` varchar(255) NOT NULL default '',
|
|
`filepath` varchar(255) NOT NULL default '',
|
|
`note` varchar(255) NOT NULL default '',
|
|
PRIMARY KEY (`itemid`),
|
|
KEY `username` (`username`),
|
|
KEY `editdate` (`editdate`,`vip`,`edittime`),
|
|
KEY `edittime` (`edittime`),
|
|
KEY `catid` (`catid`),
|
|
KEY `areaid` (`areaid`)
|
|
) TYPE=MyISAM COMMENT='招聘';
|
|
|
|
DROP TABLE IF EXISTS `destoon_job_apply_9`;
|
|
CREATE TABLE `destoon_job_apply_9` (
|
|
`applyid` bigint(20) unsigned NOT NULL auto_increment,
|
|
`jobid` bigint(20) unsigned NOT NULL default '0',
|
|
`resumeid` bigint(20) unsigned NOT NULL default '0',
|
|
`job_username` varchar(30) NOT NULL default '',
|
|
`apply_username` varchar(30) NOT NULL default '',
|
|
`applytime` int(10) unsigned NOT NULL default '0',
|
|
`updatetime` int(10) unsigned NOT NULL default '0',
|
|
`status` tinyint(1) NOT NULL default '0',
|
|
PRIMARY KEY (`applyid`),
|
|
KEY `job_username` (`job_username`),
|
|
KEY `apply_username` (`apply_username`)
|
|
) TYPE=MyISAM COMMENT='应聘工作';
|
|
|
|
DROP TABLE IF EXISTS `destoon_job_data_9`;
|
|
CREATE TABLE `destoon_job_data_9` (
|
|
`itemid` bigint(20) unsigned NOT NULL default '0',
|
|
`content` mediumtext NOT NULL,
|
|
PRIMARY KEY (`itemid`)
|
|
) TYPE=MyISAM COMMENT='招聘内容';
|
|
|
|
DROP TABLE IF EXISTS `destoon_job_resume_9`;
|
|
CREATE TABLE `destoon_job_resume_9` (
|
|
`itemid` bigint(20) unsigned NOT NULL auto_increment,
|
|
`catid` int(10) unsigned NOT NULL default '0',
|
|
`areaid` int(10) unsigned NOT NULL default '0',
|
|
`level` tinyint(1) unsigned NOT NULL default '0',
|
|
`title` varchar(100) NOT NULL default '',
|
|
`style` varchar(50) NOT NULL default '',
|
|
`fee` float NOT NULL default '0',
|
|
`introduce` varchar(255) NOT NULL default '',
|
|
`keyword` varchar(255) NOT NULL default '',
|
|
`truename` varchar(30) NOT NULL default '',
|
|
`gender` tinyint(1) unsigned NOT NULL default '0',
|
|
`birthday` date NOT NULL default '0000-00-00',
|
|
`age` smallint(2) unsigned NOT NULL default '0',
|
|
`marriage` tinyint(1) unsigned NOT NULL default '0',
|
|
`height` smallint(2) unsigned NOT NULL default '0',
|
|
`weight` smallint(2) unsigned NOT NULL default '0',
|
|
`education` smallint(2) unsigned NOT NULL default '0',
|
|
`school` varchar(100) NOT NULL default '',
|
|
`major` varchar(100) NOT NULL default '',
|
|
`skill` varchar(255) NOT NULL default '',
|
|
`language` varchar(255) NOT NULL default '',
|
|
`minsalary` int(10) unsigned NOT NULL default '0',
|
|
`maxsalary` int(10) unsigned NOT NULL default '0',
|
|
`type` tinyint(1) unsigned NOT NULL default '0',
|
|
`experience` smallint(2) unsigned NOT NULL default '0',
|
|
`mobile` varchar(50) NOT NULL default '',
|
|
`telephone` varchar(50) NOT NULL default '',
|
|
`address` varchar(255) NOT NULL default '',
|
|
`email` varchar(50) NOT NULL default '',
|
|
`qq` varchar(20) NOT NULL default '',
|
|
`wx` varchar(50) NOT NULL default '',
|
|
`ali` varchar(30) NOT NULL default '',
|
|
`skype` varchar(30) NOT NULL default '',
|
|
`hits` int(10) unsigned NOT NULL default '0',
|
|
`thumb` varchar(255) NOT NULL default '',
|
|
`username` varchar(30) NOT NULL default '',
|
|
`addtime` int(10) unsigned NOT NULL default '0',
|
|
`editor` varchar(30) NOT NULL default '',
|
|
`edittime` int(10) unsigned NOT NULL default '0',
|
|
`ip` varchar(50) NOT NULL default '',
|
|
`template` varchar(30) NOT NULL default '0',
|
|
`situation` tinyint(1) NOT NULL default '0',
|
|
`status` tinyint(1) NOT NULL default '0',
|
|
`open` tinyint(1) NOT NULL default '0',
|
|
`linkurl` varchar(255) NOT NULL default '',
|
|
`note` varchar(255) NOT NULL default '',
|
|
PRIMARY KEY (`itemid`),
|
|
KEY `username` (`username`),
|
|
KEY `edittime` (`edittime`),
|
|
KEY `catid` (`catid`),
|
|
KEY `areaid` (`areaid`)
|
|
) TYPE=MyISAM COMMENT='简历';
|
|
|
|
DROP TABLE IF EXISTS `destoon_job_resume_data_9`;
|
|
CREATE TABLE `destoon_job_resume_data_9` (
|
|
`itemid` bigint(20) unsigned NOT NULL default '0',
|
|
`content` mediumtext NOT NULL,
|
|
PRIMARY KEY (`itemid`)
|
|
) TYPE=MyISAM COMMENT='简历内容';
|
|
|
|
DROP TABLE IF EXISTS `destoon_job_talent_9`;
|
|
CREATE TABLE `destoon_job_talent_9` (
|
|
`talentid` bigint(20) unsigned NOT NULL auto_increment,
|
|
`username` varchar(30) NOT NULL default '',
|
|
`resumeid` bigint(20) unsigned NOT NULL default '0',
|
|
`jointime` int(10) unsigned NOT NULL default '0',
|
|
PRIMARY KEY (`talentid`),
|
|
KEY `username` (`username`)
|
|
) TYPE=MyISAM COMMENT='人才库';
|