·设为首页收藏本站📧邮箱修改🎁免费下载专区💎积分✅卡密📒收藏夹👽聊天室
返回列表 发布新帖

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

997 5
发表于 2023-4-12 22:36:43 | 查看全部 阅读模式 | Chrome| Windows 10

马上注册,免费下载更多dz插件网资源。

您需要 登录 才可以下载或查看,没有账号?立即注册

×
直接新安装飞鸟招聘重构版新版招聘插件后旧版路径访问报错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;
复制代码



我要说一句 收起回复
最后回复时间:2023-04-21 14:30:07论坛官方发言人回复了此贴
一花一世界,一叶一追寻。一曲一场叹,一生为一人。
创宇盾启航版免费网站防御网站加速服务

评论5

admin楼主Lv.9 发表于 2023-4-13 19:51:30 | 查看全部 | Chrome| Windows 10
补充:(挨段执行!!!!)

  1. CREATE TABLE IF NOT EXISTS `pre_fn_job_info` (
  2.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  3.   `company_id` int(11) unsigned NOT NULL,
  4.   `uid` int(11) unsigned NOT NULL,
  5.   `username` varchar(30) NOT NULL,
  6.   `title` varchar(255) NOT NULL,
  7.   `class` tinyint(1) NOT NULL,
  8.   `bbclassid` varchar(20) NOT NULL,
  9.   `bclassid` varchar(20) NOT NULL,
  10.   `classid` varchar(20) NOT NULL,
  11.   `province` varchar(20) NOT NULL,
  12.   `city` varchar(20) NOT NULL,
  13.   `dist` varchar(20) NOT NULL,
  14.   `community` varchar(100) NOT NULL,
  15.   `lat` varchar(20) NOT NULL,
  16.   `lng` varchar(20) NOT NULL,
  17.   `month_wages` int(11) NOT NULL,
  18.   `month_wages_type` tinyint(2) unsigned NOT NULL,
  19.   `settlement` tinyint(2) unsigned NOT NULL,
  20.   `cycle` tinyint(2) unsigned NOT NULL,
  21.   `number` int(11) unsigned NOT NULL,
  22.   `education` tinyint(2) NOT NULL,
  23.   `experience` tinyint(2) NOT NULL,
  24.   `content` text NOT NULL,
  25.   `tag` varchar(128) NOT NULL,
  26.   `param` mediumtext NOT NULL,
  27.   `remarks` varchar(255) NOT NULL,
  28.   `mobile` varchar(20) NOT NULL,
  29.   `display` tinyint(1) NOT NULL,
  30.   `hide` tinyint(1) unsigned NOT NULL DEFAULT '1',
  31.   `payment_state` tinyint(1) unsigned NOT NULL,
  32.   `payment_type` tinyint(1) unsigned NOT NULL DEFAULT '1',
  33.   `expiry_push` tinyint(1) unsigned NOT NULL,
  34.   `top_expiry_push` tinyint(3) unsigned NOT NULL,
  35.   `apply_count` int(10) unsigned NOT NULL,
  36.   `click` int(11) NOT NULL,
  37.   `dateline` int(11) NOT NULL,
  38.   `edit_dateline` int(11) NOT NULL,
  39.   `updateline` int(11) NOT NULL,
  40.   `topdateline` int(11) NOT NULL,
  41.   PRIMARY KEY (`id`)
  42. ) ENGINE=MyISAM;


  43. CREATE TABLE IF NOT EXISTS `pre_fn_job_info_apply_log` (
  44.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  45.   `uid` int(11) unsigned NOT NULL,
  46.   `username` varchar(50) NOT NULL,
  47.   `iid` int(11) unsigned NOT NULL,
  48.   `company_id` int(11) unsigned NOT NULL,
  49.   `fid` int(11) unsigned NOT NULL,
  50.   `see` tinyint(1) unsigned NOT NULL,
  51.   `type` tinyint(1) unsigned NOT NULL DEFAULT '1',
  52.   `dateline` int(11) unsigned NOT NULL,
  53.   PRIMARY KEY (`id`)
  54. ) ENGINE=MyISAM;


  55. CREATE TABLE IF NOT EXISTS `pre_fn_job_info_collection` (
  56.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  57.   `uid` int(11) unsigned NOT NULL,
  58.   `username` varchar(50) NOT NULL,
  59.   `iid` int(11) unsigned NOT NULL,
  60.   `dateline` int(11) unsigned NOT NULL,
  61.   PRIMARY KEY (`id`)
  62. ) ENGINE=MyISAM;


  63. CREATE TABLE IF NOT EXISTS `pre_fn_job_info_refresh_log` (
  64.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  65.   `iid` int(11) unsigned NOT NULL,
  66.   `type` tinyint(1) unsigned NOT NULL DEFAULT '1',
  67.   `uid` int(11) unsigned NOT NULL,
  68.   `company_id` int(11) unsigned NOT NULL,
  69.   `username` varchar(100) NOT NULL,
  70.   `dateline` int(11) unsigned NOT NULL,
  71.   PRIMARY KEY (`id`)
  72. ) ENGINE=MyISAM;


  73. CREATE TABLE IF NOT EXISTS `pre_fn_job_info_report` (
  74.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  75.   `uid` int(11) unsigned NOT NULL,
  76.   `username` varchar(50) NOT NULL,
  77.   `ip` varchar(30) NOT NULL,
  78.   `iid` int(11) unsigned NOT NULL,
  79.   `content` varchar(2000) NOT NULL,
  80.   `state` tinyint(1) unsigned NOT NULL,
  81.   `handle_dateline` int(11) unsigned NOT NULL,
  82.   `dateline` int(11) unsigned NOT NULL,
  83.   PRIMARY KEY (`id`)
  84. ) ENGINE=MyISAM;
复制代码
  1. ALTER TABLE `pre_fn_job_company` ADD `due_time` int(11) unsigned NOT NULL AFTER `click` ;
复制代码
  1. CREATE TABLE IF NOT EXISTS `pre_fn_job_resume_see_log` (
  2.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  3.   `uid` int(11) unsigned NOT NULL,
  4.   `rid` int(11) unsigned NOT NULL,
  5.   `company_id` int(11) unsigned NOT NULL,
  6.   `mode` tinyint(1) unsigned NOT NULL,
  7.   `dateline` int(11) unsigned NOT NULL,
  8.   `updateline` int(11) unsigned NOT NULL,
  9.   PRIMARY KEY (`id`)
  10. ) ENGINE=MyISAM;


  11. CREATE TABLE IF NOT EXISTS `pre_fn_job_resume_sign` (
  12.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  13.   `uid` int(11) unsigned NOT NULL,
  14.   `company_id` int(11) unsigned NOT NULL,
  15.   `rid` int(11) unsigned NOT NULL,
  16.   `sign` tinyint(2) unsigned NOT NULL,
  17.   `dateline` int(11) unsigned NOT NULL,
  18.   PRIMARY KEY (`id`)
  19. ) ENGINE=MyISAM;
复制代码


我要说一句 收起回复
一花一世界,一叶一追寻。一曲一场叹,一生为一人。
admin楼主Lv.9 发表于 2023-4-13 20:14:06 | 查看全部 | Chrome| Windows 10
2023.04.13:

解决新建添加公司无法添加的问题:
直接新安装飞鸟招聘重构版新版招聘插件后旧版路径访问报错1146缺失数据库表字段的SQL升级语句 直接,新安,安装,飞鸟,招聘


  1. ALTER TABLE `pre_fn_job_companys` ADD `offline_verify_pic` varchar(100) NOT NULL;
复制代码


我要说一句 收起回复
一花一世界,一叶一追寻。一曲一场叹,一生为一人。
admin楼主Lv.9 发表于 2023-4-16 11:41:29 | 查看全部 | Chrome| Windows 10
  1. CREATE TABLE IF NOT EXISTS `pre_fn_job_fair` (
  2.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  3.   `type` tinyint(1) unsigned NOT NULL DEFAULT '1',
  4.   `title` varchar(255) NOT NULL,
  5.   `banner` varchar(255) NOT NULL,
  6.   `start_time` int(11) unsigned NOT NULL,
  7.   `end_time` int(11) unsigned NOT NULL,
  8.   `content` text NOT NULL,
  9.   `param` mediumtext NOT NULL,
  10.   `money` varchar(20) NOT NULL,
  11.   `groups` varchar(30) NOT NULL,
  12.   `tel` varchar(30) NOT NULL,
  13.   `display` tinyint(1) unsigned NOT NULL,
  14.   `click` int(11) unsigned NOT NULL,
  15.   `dateline` int(11) unsigned NOT NULL,
  16.   PRIMARY KEY (`id`),
  17.   KEY `type` (`type`)
  18. ) ENGINE=MyISAM;
复制代码
  1. CREATE TABLE IF NOT EXISTS `pre_fn_job_interview` (
  2.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  3.   `company_id` int(11) unsigned NOT NULL,
  4.   `username` varchar(50) NOT NULL,
  5.   `rid` int(11) unsigned NOT NULL,
  6.   `title` varchar(255) NOT NULL,
  7.   `contacts` varchar(50) NOT NULL,
  8.   `mobile` varchar(20) NOT NULL,
  9.   `interview_dateline` int(11) unsigned NOT NULL,
  10.   `address` varchar(100) NOT NULL,
  11.   `content` varchar(255) NOT NULL,
  12.   `param` mediumtext NOT NULL,
  13.   `state` tinyint(1) unsigned NOT NULL DEFAULT '1',
  14.   `dateline` int(11) unsigned NOT NULL,
  15.   `updateline` int(11) unsigned NOT NULL,
  16.   PRIMARY KEY (`id`)
  17. ) ENGINE=MyISAM;
复制代码
  1. CREATE TABLE IF NOT EXISTS `pre_fn_job_resume_report` (
  2.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  3.   `company_id` int(11) unsigned NOT NULL,
  4.   `uid` int(11) unsigned NOT NULL,
  5.   `username` varchar(50) NOT NULL,
  6.   `ip` varchar(30) NOT NULL,
  7.   `rid` int(11) unsigned NOT NULL,
  8.   `content` varchar(2000) NOT NULL,
  9.   `state` tinyint(1) unsigned NOT NULL,
  10.   `handle_dateline` int(11) unsigned NOT NULL,
  11.   `dateline` int(11) unsigned NOT NULL,
  12.   PRIMARY KEY (`id`),
  13.   KEY `company_id` (`company_id`),
  14.   KEY `uid` (`uid`),
  15.   KEY `rid` (`rid`),
  16.   KEY `state` (`state`)
  17. ) ENGINE=MyISAM;
复制代码
  1. CREATE TABLE IF NOT EXISTS `pre_fn_job_fair_company` (
  2.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  3.   `fid` int(11) unsigned NOT NULL,
  4.   `company_id` int(11) unsigned NOT NULL,
  5.   `type` tinyint(1) unsigned NOT NULL DEFAULT '1',
  6.   `hot` tinyint(1) unsigned NOT NULL,
  7.   `display` tinyint(1) unsigned NOT NULL DEFAULT '1',
  8.   `dateline` int(11) unsigned NOT NULL,
  9.   `updateline` int(11) unsigned NOT NULL,
  10.   `topdateline` int(11) unsigned NOT NULL,
  11.   PRIMARY KEY (`id`),
  12.   KEY `fid` (`fid`),
  13.   KEY `company_id` (`company_id`)
  14. ) ENGINE=MyISAM;
复制代码
  1. CREATE TABLE IF NOT EXISTS `pre_fn_job_company_wallet_log` (
  2.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  3.   `uid` int(11) NOT NULL,
  4.   `username` varchar(50) NOT NULL,
  5.   `company_id` int(11) unsigned NOT NULL,
  6.   `content` varchar(255) NOT NULL,
  7.   `money` int(11) unsigned NOT NULL,
  8.   `dateline` int(11) unsigned NOT NULL,
  9.   PRIMARY KEY (`id`),
  10.   KEY `uid` (`uid`),
  11.   KEY `company_id` (`company_id`)
  12. ) ENGINE=MyISAM;
复制代码
  1. CREATE TABLE IF NOT EXISTS `pre_fn_job_company_follow` (
  2.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  3.   `rid` int(11) unsigned NOT NULL,
  4.   `company_id` int(11) unsigned NOT NULL,
  5.   `dateline` int(11) unsigned NOT NULL,
  6.   PRIMARY KEY (`id`)
  7. ) ENGINE=MyISAM;
复制代码
  1. CREATE TABLE IF NOT EXISTS `pre_fn_job_hr_tools` (
  2.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  3.   `title` varchar(255) NOT NULL,
  4.   `content` varchar(255) NOT NULL,
  5.   `ico` varchar(255) NOT NULL,
  6.   `displayorder` tinyint(3) NOT NULL,
  7.   `display` tinyint(1) NOT NULL,
  8.   PRIMARY KEY (`id`)
  9. ) ENGINE=MyISAM;
复制代码
  1. CREATE TABLE IF NOT EXISTS `pre_fn_job_hr_tools_info` (
  2.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  3.   `classid` int(11) NOT NULL,
  4.   `title` varchar(255) NOT NULL,
  5.   `file_url` varchar(255) NOT NULL,
  6.   `display` tinyint(1) NOT NULL,
  7.   `dateline` int(11) NOT NULL,
  8.   `topdateline` int(11) unsigned NOT NULL,
  9.   PRIMARY KEY (`id`),
  10.   KEY `classid` (`classid`)
  11. ) ENGINE=MyISAM;
复制代码


我要说一句 收起回复
一花一世界,一叶一追寻。一曲一场叹,一生为一人。
admin楼主Lv.9 发表于 2023-4-16 21:38:15 | 查看全部 | Chrome| Windows 10
  1. CREATE TABLE IF NOT EXISTS `pre_fn_job_resume_collection` (
  2.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  3.   `uid` int(11) unsigned NOT NULL,
  4.   `username` varchar(50) NOT NULL,
  5.   `rid` int(11) unsigned NOT NULL,
  6.   `dateline` int(11) unsigned NOT NULL,
  7.   PRIMARY KEY (`id`),
  8.   KEY `rid` (`rid`),
  9.   KEY `uid` (`uid`)
  10. ) ENGINE=MyISAM;
复制代码


我要说一句 收起回复
一花一世界,一叶一追寻。一曲一场叹,一生为一人。
admin楼主Lv.9 发表于 2023-4-21 14:30:07 | 查看全部 | Chrome| Windows 10
  1. ALTER TABLE `pre_fn_job_work` ADD COLUMN `call_phone_resumes` varchar(255) NOT NULL DEFAULT '';
复制代码


我要说一句 收起回复
一花一世界,一叶一追寻。一曲一场叹,一生为一人。

回复

 懒得打字嘛,点击右侧快捷回复【查看最新发布】   【应用商城享更多资源】
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

创宇盾启航版免费网站防御网站加速服务
投诉/建议联系

discuzaddons@vip.qq.com

未经授权禁止转载,复制和建立镜像,
如有违反,按照公告处理!!!
  • 联系QQ客服
  • 添加微信客服

联系DZ插件网微信客服|最近更新|Archiver|手机版|小黑屋|DZ插件网! ( 鄂ICP备20010621号-1 )|网站地图 知道创宇云防御

您的IP:3.145.104.192,GMT+8, 2024-11-9 03:13 , Processed in 0.265086 second(s), 114 queries , Gzip On, Redis On.

Powered by Discuz! X5.0 Licensed

© 2001-2024 Discuz! Team.

关灯 在本版发帖
扫一扫添加微信客服
QQ客服返回顶部
快速回复 返回顶部 返回列表