去评论
dz插件网

直接新安装飞鸟招聘重构版新版招聘插件后旧版路径访问报错1146缺失数据库表字段的SQL升级语句

admin
2023/04/12 22:36:43
直接新安装飞鸟招聘重构版新版招聘插件后旧版路径访问报错1146缺失数据库表字段的SQL升级语句:
适用于旧版招聘入口/plugin.php?id=fn_job 造成的问题,新版H5页面的暂时不用,该操作有时效性,如果你没有遇到访问 /plugin.php?id=fn_job 入口的界面报错的问题可以不执行以下语句
  1. CREATE TABLE IF NOT EXISTS `pre_fn_job_company` (
  2.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  3.   `uid` int(11) unsigned NOT NULL,
  4.   `username` varchar(30) NOT NULL,
  5.   `contacts` varchar(30) NOT NULL,
  6.   `phone` varchar(20) NOT NULL,
  7.   `group_id` smallint(5) unsigned NOT NULL,
  8.   `name` varchar(50) NOT NULL,
  9.   `short_name` varchar(50) NOT NULL,
  10.   `logo` varchar(255) NOT NULL,
  11.   `license` varchar(255) NOT NULL,
  12.   `type` tinyint(2) unsigned NOT NULL DEFAULT '1',
  13.   `scale` tinyint(2) unsigned NOT NULL,
  14.   `classid` int(11) unsigned NOT NULL,
  15.   `region` int(11) unsigned NOT NULL,
  16.   `address` varchar(255) NOT NULL,
  17.   `lat` varchar(20) NOT NULL,
  18.   `lng` varchar(20) NOT NULL,
  19.   `content` text NOT NULL,
  20.   `remarks` text NOT NULL,
  21.   `album` text NOT NULL,
  22.   `welfare` varchar(100) NOT NULL,
  23.   `video_type` tinyint(1) unsigned NOT NULL,
  24.   `video_url` varchar(255) NOT NULL,
  25.   `video_pic` varchar(255) NOT NULL,
  26.   `verify` tinyint(1) unsigned NOT NULL DEFAULT '2',
  27.   `verify_tips` varchar(100) NOT NULL,
  28.   `display` tinyint(1) unsigned NOT NULL DEFAULT '1',
  29.   `seal` tinyint(1) unsigned NOT NULL,
  30.   `audit_state` tinyint(1) unsigned NOT NULL DEFAULT '1',
  31.   `refuse_tips` varchar(255) NOT NULL,
  32.   `channel` tinyint(2) unsigned NOT NULL DEFAULT '1',
  33.   `source` tinyint(2) unsigned NOT NULL DEFAULT '1',
  34.   `vip_stop` tinyint(1) unsigned NOT NULL,
  35.   `vip_stop_date` int(11) unsigned NOT NULL,
  36.   `vip_due_date` int(11) unsigned NOT NULL,
  37.   `click` int(11) unsigned NOT NULL,
  38.   `dateline` int(11) unsigned NOT NULL,
  39.   `updateline` int(11) unsigned NOT NULL,
  40.   `login_dateline` int(11) unsigned NOT NULL,
  41.   `topdateline` int(11) unsigned NOT NULL,
  42.   `currency` int(11) unsigned NOT NULL,
  43.   `vip_currency` int(11) unsigned NOT NULL,
  44.   `vip_info_count` int(11) unsigned NOT NULL,
  45.   `vip_info_add_audit` tinyint(1) unsigned NOT NULL,
  46.   `vip_info_edit_audit` tinyint(1) unsigned NOT NULL,
  47.   `vip_info_refresh_type` tinyint(1) unsigned NOT NULL DEFAULT '2',
  48.   `vip_info_day_refresh_count` int(11) unsigned NOT NULL,
  49.   `vip_info_refresh_count` int(11) unsigned NOT NULL,
  50.   `vip_info_top_discount` varchar(10) NOT NULL,
  51.   `vip_info_auto_refresh` tinyint(1) unsigned NOT NULL,
  52.   `vip_resume_count` int(11) unsigned NOT NULL,
  53.   `vip_resume_day_limit_count` int(11) unsigned NOT NULL,
  54.   `vip_resume_apply_free` tinyint(1) unsigned NOT NULL,
  55.   `vip_stop_count` smallint(3) unsigned NOT NULL,
  56.   `vip_experience` tinyint(1) unsigned NOT NULL,
  57.   `resume_package_count` int(11) unsigned NOT NULL,
  58.   `collect_resume_count` int(11) unsigned NOT NULL,
  59.   `down_resume_count` int(11) unsigned NOT NULL,
  60.   `interview_resume_count` int(11) unsigned NOT NULL,
  61.   `apply_count` int(11) unsigned NOT NULL,
  62.   `work_phone_count` int(11) unsigned NOT NULL,
  63.   `resume_rate` tinyint(3) unsigned NOT NULL,
  64.   UNIQUE KEY `id` (`id`),
  65.   KEY `uid` (`uid`),
  66.   KEY `dateline` (`dateline`),
  67.   KEY `name` (`name`),
  68.   KEY `scale` (`scale`),
  69.   KEY `classid` (`classid`)
  70. ) ENGINE=MyISAM;

  71. CREATE TABLE IF NOT EXISTS `pre_fn_job_resume` (
  72.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  73.   `uid` int(11) unsigned NOT NULL,
  74.   `username` varchar(50) NOT NULL,
  75.   `head_portrait` varchar(255) NOT NULL,
  76.   `life` text NOT NULL,
  77.   `full_name` varchar(20) NOT NULL,
  78.   `phone` varchar(20) NOT NULL,
  79.   `wx` varchar(30) NOT NULL,
  80.   `sex` tinyint(1) unsigned NOT NULL,
  81.   `birth_year` smallint(4) unsigned NOT NULL,
  82.   `age` tinyint(3) unsigned NOT NULL,
  83.   `marriage` tinyint(1) unsigned NOT NULL,
  84.   `education` tinyint(2) unsigned NOT NULL,
  85.   `experience` tinyint(2) unsigned NOT NULL,
  86.   `expect_job` varchar(255) NOT NULL,
  87.   `expect_job_classid` varchar(100) NOT NULL,
  88.   `expect_salary` tinyint(2) unsigned NOT NULL,
  89.   `expect_region` varchar(255) NOT NULL,
  90.   `state` tinyint(1) unsigned NOT NULL DEFAULT '1',
  91.   `nature` tinyint(1) unsigned NOT NULL DEFAULT '1',
  92.   `tag` varchar(100) NOT NULL,
  93.   `special` varchar(100) NOT NULL,
  94.   `percent` tinyint(3) unsigned NOT NULL,
  95.   `works` text NOT NULL,
  96.   `work_experience` text NOT NULL,
  97.   `educational_experience` text NOT NULL,
  98.   `content` text NOT NULL,
  99.   `remarks` text NOT NULL,
  100.   `channel` tinyint(2) unsigned NOT NULL DEFAULT '1',
  101.   `verify` tinyint(1) unsigned NOT NULL DEFAULT '2',
  102.   `verify_tips` varchar(100) NOT NULL,
  103.   `source` tinyint(2) unsigned NOT NULL DEFAULT '1',
  104.   `display` tinyint(1) unsigned NOT NULL DEFAULT '1',
  105.   `audit_state` tinyint(1) unsigned NOT NULL DEFAULT '1',
  106.   `seal` tinyint(1) unsigned NOT NULL DEFAULT '0',
  107.   `refuse_tips` varchar(100) NOT NULL,
  108.   `click` int(11) unsigned NOT NULL,
  109.   `down_count` int(11) unsigned NOT NULL,
  110.   `apply_count` int(11) unsigned NOT NULL,
  111.   `interview_count` int(11) unsigned NOT NULL,
  112.   `follow_com_count` int(11) unsigned NOT NULL,
  113.   `collect_work_count` int(11) unsigned NOT NULL,
  114.   `share_count` int(11) unsigned NOT NULL,
  115.   `phone_count` int(11) unsigned NOT NULL,
  116.   `chat_count` int(11) unsigned NOT NULL,
  117.   `dateline` int(11) unsigned NOT NULL,
  118.   `updateline` int(11) unsigned NOT NULL,
  119.   `topdateline` int(11) unsigned NOT NULL,
  120.   KEY `id` (`id`),
  121.   KEY `uid` (`uid`),
  122.   KEY `d_a_s_s` (`display`,`audit_state`,`seal`,`state`),
  123.   KEY `dateline` (`dateline`),
  124.   KEY `education` (`education`),
  125.   KEY `experience` (`experience`),
  126.   FULLTEXT KEY `content` (`content`)
  127. ) ENGINE=MyISAM;

  128. CREATE TABLE IF NOT EXISTS `pre_fn_job_company_group` (
  129.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  130.   `title` varchar(30) NOT NULL,
  131.   `ico` varchar(255) NOT NULL,
  132.   `refresh_count` int(11) unsigned NOT NULL,
  133.   `day_refresh_count` tinyint(3) unsigned NOT NULL,
  134.   `refresh_type` tinyint(1) unsigned NOT NULL DEFAULT '1',
  135.   `day_info_count` int(11) unsigned NOT NULL,
  136.   `info_count` int(11) unsigned NOT NULL,
  137.   `resume_count` int(11) unsigned NOT NULL,
  138.   `resume_day_count` int(11) unsigned NOT NULL,
  139.   `examine` tinyint(1) unsigned NOT NULL,
  140.   `top_discount` varchar(20) NOT NULL,
  141.   `currency` int(11) unsigned NOT NULL,
  142.   `hot` tinyint(1) unsigned NOT NULL,
  143.   `hide` tinyint(1) unsigned NOT NULL,
  144.   `money` varchar(20) NOT NULL,
  145.   `content` text NOT NULL,
  146.   `group_time` tinyint(3) unsigned NOT NULL,
  147.   `displayorder` tinyint(3) unsigned NOT NULL,
  148.   `display` tinyint(1) unsigned NOT NULL DEFAULT '1',
  149.   PRIMARY KEY (`id`)
  150. ) ENGINE=MyISAM;

  151. CREATE TABLE IF NOT EXISTS `pre_fn_job_company_group_log` (
  152.   `company_id` int(11) unsigned NOT NULL,
  153.   `refresh_count` int(11) unsigned NOT NULL,
  154.   `day_refresh_count` tinyint(3) unsigned NOT NULL,
  155.   `refresh_type` tinyint(1) unsigned NOT NULL DEFAULT '1',
  156.   `day_info_count` int(11) unsigned NOT NULL,
  157.   `info_count` int(11) unsigned NOT NULL,
  158.   `resume_count` int(11) unsigned NOT NULL,
  159.   `resume_day_count` int(11) unsigned NOT NULL,
  160.   `examine` tinyint(1) unsigned NOT NULL,
  161.   `top_discount` varchar(20) NOT NULL,
  162.   `hot` tinyint(1) unsigned NOT NULL,
  163.   `hide` tinyint(1) unsigned NOT NULL,
  164.   UNIQUE KEY `uid` (`company_id`)
  165. ) ENGINE=MyISAM;