·设为首页收藏本站📧邮箱修改🎁免费下载专区🔐设置/修改密码👽群雄群聊
🔄最新发布📃文档资料库🆔加群看共享切换到窄版
立即注册
DZ插件网»🏠首页 › Discuz!交流与探讨 › Discuz!运营教程 › 飞鸟 › 直接新安装飞鸟招聘重构版新版招聘插件后旧版路径访问报 ...
返回列表 发布新帖

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

714 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;

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

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

  154. CREATE TABLE IF NOT EXISTS `pre_fn_job_company_group_log` (
  155.   `company_id` int(11) unsigned NOT NULL,
  156.   `refresh_count` int(11) unsigned NOT NULL,
  157.   `day_refresh_count` tinyint(3) unsigned NOT NULL,
  158.   `refresh_type` tinyint(1) unsigned NOT NULL DEFAULT '1',
  159.   `day_info_count` int(11) unsigned NOT NULL,
  160.   `info_count` int(11) unsigned NOT NULL,
  161.   `resume_count` int(11) unsigned NOT NULL,
  162.   `resume_day_count` int(11) unsigned NOT NULL,
  163.   `examine` tinyint(1) unsigned NOT NULL,
  164.   `top_discount` varchar(20) NOT NULL,
  165.   `hot` tinyint(1) unsigned NOT NULL,
  166.   `hide` tinyint(1) unsigned NOT NULL,
  167.   UNIQUE KEY `uid` (`company_id`)
  168. ) 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;


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


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


  69. CREATE TABLE IF NOT EXISTS `pre_fn_job_info_refresh_log` (
  70.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  71.   `iid` int(11) unsigned NOT NULL,
  72.   `type` tinyint(1) unsigned NOT NULL DEFAULT '1',
  73.   `uid` int(11) unsigned NOT NULL,
  74.   `company_id` int(11) unsigned NOT NULL,
  75.   `username` varchar(100) NOT NULL,
  76.   `dateline` int(11) unsigned NOT NULL,
  77.   PRIMARY KEY (`id`)
  78. ) ENGINE=MyISAM;


  81. CREATE TABLE IF NOT EXISTS `pre_fn_job_info_report` (
  82.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  83.   `uid` int(11) unsigned NOT NULL,
  84.   `username` varchar(50) NOT NULL,
  85.   `ip` varchar(30) NOT NULL,
  86.   `iid` int(11) unsigned NOT NULL,
  87.   `content` varchar(2000) NOT NULL,
  88.   `state` tinyint(1) unsigned NOT NULL,
  89.   `handle_dateline` int(11) unsigned NOT NULL,
  90.   `dateline` int(11) unsigned NOT NULL,
  91.   PRIMARY KEY (`id`)
  92. ) 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;


  13. CREATE TABLE IF NOT EXISTS `pre_fn_job_resume_sign` (
  14.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  15.   `uid` int(11) unsigned NOT NULL,
  16.   `company_id` int(11) unsigned NOT NULL,
  17.   `rid` int(11) unsigned NOT NULL,
  18.   `sign` tinyint(2) unsigned NOT NULL,
  19.   `dateline` int(11) unsigned NOT NULL,
  20.   PRIMARY KEY (`id`)
  21. ) 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 '';
复制代码


我要说一句 收起回复
一花一世界，一叶一追寻。一曲一场叹，一生为一人。
回复 支持 反对

使用道具 举报

返回列表 发布新帖

回复
 懒得打字嘛，点击右侧快捷回复【查看最新发布】   【应用商城享更多资源】
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

关于我们

关于我们 免责声明 应用市场 下载中心

服务支持

有问必答 优秀站点 常见问题 建站必看
投诉/建议联系

discuzaddons@vip.qq.com

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

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

您的IP:18.218.218.230,111.170.23.50,GMT+8, 2024-5-10 13:24 , Processed in 0.223200 second(s), 143 queries , Gzip On, Redis On.

Based on Discuz! W1.0 Licensed

© 2001-2024 Discuz! Team.

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