直接新安装飞鸟招聘重构版新版招聘插件后旧版路径访问报错1146缺失数据库表字段的SQL升级语句
直接新安装飞鸟招聘重构版新版招聘插件后旧版路径访问报错1146缺失数据库表字段的SQL升级语句:
(适用于旧版招聘入口/plugin.php?id=fn_job 造成的问题,新版H5页面的暂时不用,该操作有时效性,如果你没有遇到访问 /plugin.php?id=fn_job 入口的界面报错的问题可以不执行以下语句)
(适用于旧版招聘入口/plugin.php?id=fn_job 造成的问题,新版H5页面的暂时不用,该操作有时效性,如果你没有遇到访问 /plugin.php?id=fn_job 入口的界面报错的问题可以不执行以下语句)
- CREATE TABLE IF NOT EXISTS `pre_fn_job_company` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `uid` int(11) unsigned NOT NULL,
- `username` varchar(30) NOT NULL,
- `contacts` varchar(30) NOT NULL,
- `phone` varchar(20) NOT NULL,
- `group_id` smallint(5) unsigned NOT NULL,
- `name` varchar(50) NOT NULL,
- `short_name` varchar(50) NOT NULL,
- `logo` varchar(255) NOT NULL,
- `license` varchar(255) NOT NULL,
- `type` tinyint(2) unsigned NOT NULL DEFAULT '1',
- `scale` tinyint(2) unsigned NOT NULL,
- `classid` int(11) unsigned NOT NULL,
- `region` int(11) unsigned NOT NULL,
- `address` varchar(255) NOT NULL,
- `lat` varchar(20) NOT NULL,
- `lng` varchar(20) NOT NULL,
- `content` text NOT NULL,
- `remarks` text NOT NULL,
- `album` text NOT NULL,
- `welfare` varchar(100) NOT NULL,
- `video_type` tinyint(1) unsigned NOT NULL,
- `video_url` varchar(255) NOT NULL,
- `video_pic` varchar(255) NOT NULL,
- `verify` tinyint(1) unsigned NOT NULL DEFAULT '2',
- `verify_tips` varchar(100) NOT NULL,
- `display` tinyint(1) unsigned NOT NULL DEFAULT '1',
- `seal` tinyint(1) unsigned NOT NULL,
- `audit_state` tinyint(1) unsigned NOT NULL DEFAULT '1',
- `refuse_tips` varchar(255) NOT NULL,
- `channel` tinyint(2) unsigned NOT NULL DEFAULT '1',
- `source` tinyint(2) unsigned NOT NULL DEFAULT '1',
- `vip_stop` tinyint(1) unsigned NOT NULL,
- `vip_stop_date` int(11) unsigned NOT NULL,
- `vip_due_date` int(11) unsigned NOT NULL,
- `click` int(11) unsigned NOT NULL,
- `dateline` int(11) unsigned NOT NULL,
- `updateline` int(11) unsigned NOT NULL,
- `login_dateline` int(11) unsigned NOT NULL,
- `topdateline` int(11) unsigned NOT NULL,
- `currency` int(11) unsigned NOT NULL,
- `vip_currency` int(11) unsigned NOT NULL,
- `vip_info_count` int(11) unsigned NOT NULL,
- `vip_info_add_audit` tinyint(1) unsigned NOT NULL,
- `vip_info_edit_audit` tinyint(1) unsigned NOT NULL,
- `vip_info_refresh_type` tinyint(1) unsigned NOT NULL DEFAULT '2',
- `vip_info_day_refresh_count` int(11) unsigned NOT NULL,
- `vip_info_refresh_count` int(11) unsigned NOT NULL,
- `vip_info_top_discount` varchar(10) NOT NULL,
- `vip_info_auto_refresh` tinyint(1) unsigned NOT NULL,
- `vip_resume_count` int(11) unsigned NOT NULL,
- `vip_resume_day_limit_count` int(11) unsigned NOT NULL,
- `vip_resume_apply_free` tinyint(1) unsigned NOT NULL,
- `vip_stop_count` smallint(3) unsigned NOT NULL,
- `vip_experience` tinyint(1) unsigned NOT NULL,
- `resume_package_count` int(11) unsigned NOT NULL,
- `collect_resume_count` int(11) unsigned NOT NULL,
- `down_resume_count` int(11) unsigned NOT NULL,
- `interview_resume_count` int(11) unsigned NOT NULL,
- `apply_count` int(11) unsigned NOT NULL,
- `work_phone_count` int(11) unsigned NOT NULL,
- `resume_rate` tinyint(3) unsigned NOT NULL,
- UNIQUE KEY `id` (`id`),
- KEY `uid` (`uid`),
- KEY `dateline` (`dateline`),
- KEY `name` (`name`),
- KEY `scale` (`scale`),
- KEY `classid` (`classid`)
- ) ENGINE=MyISAM;
- CREATE TABLE IF NOT EXISTS `pre_fn_job_resume` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `uid` int(11) unsigned NOT NULL,
- `username` varchar(50) NOT NULL,
- `head_portrait` varchar(255) NOT NULL,
- `life` text NOT NULL,
- `full_name` varchar(20) NOT NULL,
- `phone` varchar(20) NOT NULL,
- `wx` varchar(30) NOT NULL,
- `sex` tinyint(1) unsigned NOT NULL,
- `birth_year` smallint(4) unsigned NOT NULL,
- `age` tinyint(3) unsigned NOT NULL,
- `marriage` tinyint(1) unsigned NOT NULL,
- `education` tinyint(2) unsigned NOT NULL,
- `experience` tinyint(2) unsigned NOT NULL,
- `expect_job` varchar(255) NOT NULL,
- `expect_job_classid` varchar(100) NOT NULL,
- `expect_salary` tinyint(2) unsigned NOT NULL,
- `expect_region` varchar(255) NOT NULL,
- `state` tinyint(1) unsigned NOT NULL DEFAULT '1',
- `nature` tinyint(1) unsigned NOT NULL DEFAULT '1',
- `tag` varchar(100) NOT NULL,
- `special` varchar(100) NOT NULL,
- `percent` tinyint(3) unsigned NOT NULL,
- `works` text NOT NULL,
- `work_experience` text NOT NULL,
- `educational_experience` text NOT NULL,
- `content` text NOT NULL,
- `remarks` text NOT NULL,
- `channel` tinyint(2) unsigned NOT NULL DEFAULT '1',
- `verify` tinyint(1) unsigned NOT NULL DEFAULT '2',
- `verify_tips` varchar(100) NOT NULL,
- `source` tinyint(2) unsigned NOT NULL DEFAULT '1',
- `display` tinyint(1) unsigned NOT NULL DEFAULT '1',
- `audit_state` tinyint(1) unsigned NOT NULL DEFAULT '1',
- `seal` tinyint(1) unsigned NOT NULL DEFAULT '0',
- `refuse_tips` varchar(100) NOT NULL,
- `click` int(11) unsigned NOT NULL,
- `down_count` int(11) unsigned NOT NULL,
- `apply_count` int(11) unsigned NOT NULL,
- `interview_count` int(11) unsigned NOT NULL,
- `follow_com_count` int(11) unsigned NOT NULL,
- `collect_work_count` int(11) unsigned NOT NULL,
- `share_count` int(11) unsigned NOT NULL,
- `phone_count` int(11) unsigned NOT NULL,
- `chat_count` int(11) unsigned NOT NULL,
- `dateline` int(11) unsigned NOT NULL,
- `updateline` int(11) unsigned NOT NULL,
- `topdateline` int(11) unsigned NOT NULL,
- KEY `id` (`id`),
- KEY `uid` (`uid`),
- KEY `d_a_s_s` (`display`,`audit_state`,`seal`,`state`),
- KEY `dateline` (`dateline`),
- KEY `education` (`education`),
- KEY `experience` (`experience`),
- FULLTEXT KEY `content` (`content`)
- ) ENGINE=MyISAM;
- CREATE TABLE IF NOT EXISTS `pre_fn_job_company_group` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `title` varchar(30) NOT NULL,
- `ico` varchar(255) NOT NULL,
- `refresh_count` int(11) unsigned NOT NULL,
- `day_refresh_count` tinyint(3) unsigned NOT NULL,
- `refresh_type` tinyint(1) unsigned NOT NULL DEFAULT '1',
- `day_info_count` int(11) unsigned NOT NULL,
- `info_count` int(11) unsigned NOT NULL,
- `resume_count` int(11) unsigned NOT NULL,
- `resume_day_count` int(11) unsigned NOT NULL,
- `examine` tinyint(1) unsigned NOT NULL,
- `top_discount` varchar(20) NOT NULL,
- `currency` int(11) unsigned NOT NULL,
- `hot` tinyint(1) unsigned NOT NULL,
- `hide` tinyint(1) unsigned NOT NULL,
- `money` varchar(20) NOT NULL,
- `content` text NOT NULL,
- `group_time` tinyint(3) unsigned NOT NULL,
- `displayorder` tinyint(3) unsigned NOT NULL,
- `display` tinyint(1) unsigned NOT NULL DEFAULT '1',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM;
- CREATE TABLE IF NOT EXISTS `pre_fn_job_company_group_log` (
- `company_id` int(11) unsigned NOT NULL,
- `refresh_count` int(11) unsigned NOT NULL,
- `day_refresh_count` tinyint(3) unsigned NOT NULL,
- `refresh_type` tinyint(1) unsigned NOT NULL DEFAULT '1',
- `day_info_count` int(11) unsigned NOT NULL,
- `info_count` int(11) unsigned NOT NULL,
- `resume_count` int(11) unsigned NOT NULL,
- `resume_day_count` int(11) unsigned NOT NULL,
- `examine` tinyint(1) unsigned NOT NULL,
- `top_discount` varchar(20) NOT NULL,
- `hot` tinyint(1) unsigned NOT NULL,
- `hide` tinyint(1) unsigned NOT NULL,
- UNIQUE KEY `uid` (`company_id`)
- ) ENGINE=MyISAM;