马上注册,免费下载更多dz插件网资源。
您需要 登录 才可以下载或查看,没有账号?立即注册
×
直接新安装飞鸟招聘重构版新版招聘插件后旧版路径访问报错1146缺失数据库表字段的SQL升级语句:
(适用于旧版招聘入口/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;
复制代码
©DZ插件网所发布的一切资源仅限用于学习和研究目的;不得将上述内容用于商业或者非法用途,否则,一切后果请用户自负。 网站部分内容来源于网络,版权争议与本站无关。您必须在下载后的24个小时之内,从您的电脑中彻底删除上述内容。如果您喜欢该程序,请支持正版软件,得到更好的正版服务。 您在本站任何的赞助购买、下载、查阅、回复等行为等均表示接受并同意签订《DZ插件网免责声明协议》。 如有侵权请邮件与我们联系处理: discuzaddons@vip.qq.com 并出示相关证明以便删除。敬请谅解!
|
最后回复时间:2023-04-21 14:30:07论坛官方发言人回复了此贴
|