Menu

DB structure of WP Job Manager

2018-11-18 - Plugin, Wordpress

What is this plugin?

Manage job listings from the WordPress admin panel, and allow users to post jobs directly to your site.

DB structure

Added data to options

select option_id, option_name, substring(option_value, 1,50), autoload from options where option_name not like "%transient%" and option_id >315;
+-----------+
|       326 | job_listing_type_children                           | a:0:{}                                             | yes      |
|       327 | job_manager_installed_terms                         | 1                                                  | yes      |
|       328 | widget_listify_widget_panel_listing_content         | a:1:{s:12:"_multiwidget";i:1;}                     | yes      |
|       329 | widget_listify_widget_panel_listing_comments        | a:1:{s:12:"_multiwidget";i:1;}                     | yes      |
|       330 | widget_listify_widget_panel_listing_gallery         | a:1:{s:12:"_multiwidget";i:1;}                     | yes      |
|       331 | widget_listify_widget_panel_listing_gallery_slider  | a:1:{s:12:"_multiwidget";i:1;}                     | yes      |
|       332 | widget_listify_widget_panel_listing_map             | a:1:{s:12:"_multiwidget";i:1;}                     | yes      |
|       333 | widget_listify_widget_panel_listing_business_hours  | a:1:{s:12:"_multiwidget";i:1;}                     | yes      |
|       334 | widget_listify_widget_panel_listing_auhtor          | a:1:{s:12:"_multiwidget";i:1;}                     | yes      |
|       335 | widget_listify_widget_panel_listing_video           | a:1:{s:12:"_multiwidget";i:1;}                     | yes      |
|       336 | widget_listify_widget_panel_listing_social_profiles | a:1:{s:12:"_multiwidget";i:1;}                     | yes      |
|       337 | widget_listify_related_listings                     | a:1:{s:12:"_multiwidget";i:1;}                     | yes      |
|       338 | widget_listify_widget_recent_listings               | a:1:{s:12:"_multiwidget";i:1;}                     | yes      |
|       339 | widget_listify_widget_search_listings               | a:1:{s:12:"_multiwidget";i:1;}                     | yes      |
|       340 | widget_listify_widget_taxonomy_image_grid           | a:1:{s:12:"_multiwidget";i:1;}                     | yes      |
|       341 | widget_listify_widget_map_listings                  | a:1:{s:12:"_multiwidget";i:1;}                     | yes      |
|       342 | widget_listify_widget_tabbed_listings               | a:1:{s:12:"_multiwidget";i:1;}                     | yes      |
|       343 | widget_listify_widget_taxonomy_term_lists           | a:1:{s:12:"_multiwidget";i:1;}                     | yes      |
|       344 | job_manager_date_format                             | relative                                           | yes      |
|       345 | job_manager_google_maps_api_key                     |                                                    | yes      |
|       346 | job_manager_delete_data_on_uninstall                | 0                                                  | yes      |
|       347 | job_manager_usage_tracking_enabled                  | 0                                                  | yes      |
|       348 | job_manager_per_page                                | 10                                                 | yes      |
|       349 | job_manager_hide_filled_positions                   | 0                                                  | yes      |
|       350 | job_manager_hide_expired                            | 0                                                  | yes      |
|       351 | job_manager_hide_expired_content                    | 1                                                  | yes      |
|       352 | job_manager_enable_default_category_multiselect     | 0                                                  | yes      |
|       353 | job_manager_category_filter_type                    | any                                                | yes      |
|       354 | job_manager_enable_types                            | 1                                                  | yes      |
|       355 | job_manager_multi_job_type                          | 0                                                  | yes      |
|       356 | job_manager_user_requires_account                   | 1                                                  | yes      |
|       357 | job_manager_enable_registration                     | 1                                                  | yes      |
|       358 | job_manager_generate_username_from_email            | 1                                                  | yes      |
|       359 | job_manager_use_standard_password_setup_email       | 1                                                  | yes      |
|       360 | job_manager_registration_role                       | employer                                           | yes      |
|       361 | job_manager_submission_requires_approval            | 1                                                  | yes      |
|       362 | job_manager_user_can_edit_pending_submissions       | 0                                                  | yes      |
|       363 | job_manager_user_edit_published_submissions         | yes                                                | yes      |
|       364 | job_manager_submission_duration                     | 30                                                 | yes      |
|       365 | job_manager_allowed_application_method              |                                                    | yes      |
|       366 | job_manager_recaptcha_label                         | Are you human?                                     | yes      |
|       367 | job_manager_recaptcha_site_key                      |                                                    | yes      |
|       368 | job_manager_recaptcha_secret_key                    |                                                    | yes      |
|       369 | job_manager_enable_recaptcha_job_submission         | 0                                                  | yes      |
|       370 | job_manager_submit_job_form_page_id                 |                                                    | yes      |
|       371 | job_manager_job_dashboard_page_id                   |                                                    | yes      |
|       372 | job_manager_jobs_page_id                            |                                                    | yes      |
|       373 | job_manager_email_admin_new_job                     | a:2:{s:7:"enabled";s:1:"1";s:10:"plain_text";s:1:" | yes      |
|       374 | job_manager_email_admin_updated_job                 | a:2:{s:7:"enabled";s:1:"1";s:10:"plain_text";s:1:" | yes      |
|       375 | job_manager_email_admin_expiring_job                | a:3:{s:7:"enabled";s:1:"0";s:10:"plain_text";s:1:" | yes      |
|       376 | job_manager_email_employer_expiring_job             | a:3:{s:7:"enabled";s:1:"0";s:10:"plain_text";s:1:" | yes      |
+-----------+

Job manager region plugin

additional values for options

select option_id, option_name, substring(option_value, 1,50), autoload from bdroptions where option_name not like "%transient%" and option_id >376;
+-----------+-----------------------------------+-------------------------------+----------+
| option_id | option_name                       | substring(option_value, 1,50) | autoload |
+-----------+-----------------------------------+-------------------------------+----------+
|       379 | job_manager_enable_regions_filter | 1                             | yes      |
|       380 | job_manager_regions_filter        | 0                             | yes      |
+-----------+-----------------------------------+-------------------------------+----------+

Reviews for WP Job Manager plugin

Added values for options table

select option_id, option_name, substring(option_value, 1,50), autoload from bdroptions where option_name not like "%transient%" and option_id >380;
+-----------+
| option_id | option_name                        | substring(option_value, 1,50)                      | autoload |
+-----------+
|       381 | wpjmr_star_count                   | 5                                                  | yes      |
|       382 | wpjmr_star_default                 | 3                                                  | yes      |
|       383 | wpjmr_categories                   | Speed
Quality
Price                                | yes      |
|       384 | wpjmr_listing_authors_can_moderate | 0                                                  | yes      |
|       385 | wpjmr_allow_owner                  | 0                                                  | yes      |
|       386 | wpjmr_allow_multiple               | 0                                                  | yes      |
|       387 | wpjmr_allow_guests                 | 1                                                  | yes      |
|       388 | wpjmr_allow_blank_comment          | 0                                                  | yes      |
|       389 | wpjmr_restrict_review              | 0                                                  | yes      |
|       390 | wpjmr_allow_images                 | 1                                                  | yes      |
|       391 | wpjmr_dashboard_actions            | a:4:{i:0;s:7:"approve";i:1;s:9:"unapprove";i:2;s:4 | yes      |
|       392 | wp-job-manager-reviews             |                                                    | yes      |
+-----------+

Private messages

Following values are added to options table
select option_id, option_name, substring(option_value, 1,50), autoload from bdroptions where option_name not like "%transient%" and option_id >392;
+-----------+
| option_id | option_name                                   | substring(option_value, 1,50)  | autoload |
+-----------+
|       395 | pm_version                                    | 1.10.1                                 | yes      |
|       396 | widget_listify_widget_author_private_messages | a:1:{s:12:"_multiwidget";i:1;}         | yes      |
|       397 | private-messages-setup                        | 1                                      | yes      |
|       398 | pm_settings                                   | a:1:{s:20:"pm_dashboard_page_id";i:9;} | yes      |

Claim Listing for WP Job Manager

Added values to options table

select option_id, option_name, substring(option_value, 1,50), autoload from bdroptions where option_name not like "%transient%" and option_id >398;
+-----------+
| option_id | option_name | substring(option_value, 1,50) | autoload |
+-----------+
| 400 | job_manager_claim_listing_page_id | 10 | yes |
| 401 | wpjmcl_submit_claim_data | 0 | yes |
| 402 | wpjmcl_claim_own_listing | | yes |
| 403 | wp-job-manager-claim-listing | | yes |
| 404 | wpjmcl_email_message_new_claim_claimer | Hi %claimer_name%,
On %claim_date% you submitted a | yes |
| 405 | wpjmcl_email_message_new_claim_admin | Hi Admin,
New claim submitted, here's the details. | yes |
| 406 | wpjmcl_email_message_status_update_claimer | Hi %claimer_name%,
On %claim_date% you submitted a | yes |
| 407 | wpjmcl_email_message_status_update_admin | Hi Admin,
Claim status for listing %listing_title% | yes |
| 408 | wp-job-manager-claim-listing-setup | 1 | yes |
| 410 | job_manager_usage_tracking_opt_in_hide | 1 | yes |
+-----------+


Favorites by Astoundify

Added values to options table

select option_id, option_name, substring(option_value, 1,50), autoload from bdroptions where option_name not like “%transient%” and option_id >410;

+-----------+
| option_id | option_name                            | substring(option_value, 1,50)     | autoload |
+-----------+----------------------------------------+-----------------------------------+----------+
|       414 | astoundify_favorites                   | a:1:{s:14:"dashboard-page";i:12;} | yes      |
|       417 | widget_listify_widget_author_favorites | a:1:{s:12:"_multiwidget";i:1;}    | yes      |
+-----------+

Products for WP Job Manager

Added values to options table

+-----------+---------------------------------------------------+---------------------------------+----------+
| option_id | option_name                                       | substring(option_value, 1,50)   | autoload |
+-----------+---------------------------------------------------+---------------------------------+----------+
|       418 | widget_listify_widget_panel_listing_products      | a:1:{s:12:"_multiwidget";i:1;}  | yes      |
|       419 | widget_listify_widget_panel_listing_products_main | a:1:{s:12:"_multiwidget";i:1;}  | yes      |
|       420 | wpjmcl_transfer_product_ownership                 | 0                               | yes      |
|       421 | wpjmp_select_products_text                        | Select Your Services & Products | yes      |
|       422 | wpjmp_listing_products_text                       | Listing products                | yes      |
|       423 | wpjmp_enable_products_on_listings                 | 1                               | yes      |
|       424 | wpjmp_draft_products_on_listing_expiration        | 1                               | yes      |
+-----------+---------------------------------------------------+---------------------------------+----------+

Listing Payments for WP Job Manager

bdrwcpl_user_packages

CREATE TABLE `bdrwcpl_user_packages` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL,
  `product_id` bigint(20) NOT NULL,
  `order_id` bigint(20) NOT NULL DEFAULT '0',
  `package_featured` int(1) DEFAULT NULL,
  `package_duration` bigint(20) DEFAULT NULL,
  `package_limit` bigint(20) NOT NULL,
  `package_count` bigint(20) NOT NULL,
  `package_type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

No data

Values added to options table

+-----------+------------------------------------------------+--------------------------------+----------+
| option_id | option_name                                    | substring(option_value, 1,50)  | autoload |
+-----------+------------------------------------------------+--------------------------------+----------+
|       425 | wpjmlp_db_version                              | 2.2.1                          | yes      |
|       427 | widget_listify_widget_panel_wcpl_pricing_table | a:1:{s:12:"_multiwidget";i:1;} | yes      |
|       428 | job_manager_paid_listings_flow                 |                                | yes      |
|       429 | wpjmcl_paid_claiming                           | 0                              | yes      |
|       430 | wpjmcl_register_on_checkout                    |                                | yes      |
|       431 | job_manager_paid_listings_simple_checkout      |                                | yes      |
|       432 | job_manager_paid_listings_switch_package       |                                | yes      |
|       433 | wp-job-manager-listing-payments                |                                | yes      |
+-----------+------------------------------------------------+--------------------------------+----------+

Stats for WP Job Manager

bdrjob_manager_stats

CREATE TABLE `bdrjob_manager_stats` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `post_id` bigint(20) DEFAULT NULL,
  `stat_date` date DEFAULT NULL,
  `stat_id` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stat_value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci 

Added values to options table

select option_id, option_name, substring(option_value, 1,50), autoload from bdroptions where option_name not like "%transient%" and option_id >433;
+-----------+
| option_id | option_name                               | substring(option_value, 1,50) | autoload |
+-----------+
|       435 | wp_job_manger_stats_version               | 2.7.0                         | yes      |
|       436 | wp_job_manager_stats_page_id              | 0                             | yes      |
|       437 | wp_job_manager_stats_purge_data           | 0                             | yes      |
|       438 | wp_job_manager_stats_default_stat_days    | 7                             | yes      |
|       439 | wp_job_manager_stats_require_paid_listing | 0                             | yes      |
|       440 | wp-job-manager-stats                      |                               | yes      |
|       441 | wp-job-manager-stats-setup                | 1                             | yes      |
+-----------+

Listing Labels for WP Job Manager

Added values to options table

select option_id, option_name, substring(option_value, 1,50), autoload from bdroptions where option_name not like "%transient%" and option_id >445;
+-----------+
| option_id | option_name                                 | substring(option_value, 1,50)                      | autoload |
+-----------+
|       448 | 6e361ad50b52483d2d489e40d5995522            | a:2:{s:7:"timeout";i:1542560681;s:5:"value";s:2760 | yes      |
|       449 | 835b3f14e88b0fade082367ba1da84fc            | a:2:{s:7:"timeout";i:1542560682;s:5:"value";s:1098 | yes      |
|       450 | 66511b32be65edc2b244d22142cad222            | a:2:{s:7:"timeout";i:1542560683;s:5:"value";s:3355 | yes      |
|       451 | af45ad85d6cc4e9c6475aa4c11fadd29            | a:2:{s:7:"timeout";i:1542560683;s:5:"value";s:3399 | yes      |
|       452 | 86f7fad7b81769b05547b0f91dab4402            | a:2:{s:7:"timeout";i:1542560684;s:5:"value";s:7773 | yes      |
|       453 | 7907c80ce144dac5efd77264bedf4061            | a:2:{s:7:"timeout";i:1542560685;s:5:"value";s:6267 | yes      |
|       454 | 4a39827842745a9586e2d63dc2b3f2f8            | a:2:{s:7:"timeout";i:1542560686;s:5:"value";s:7139 | yes      |
|       457 | widget_listify_widget_panel_listing_tags    | a:1:{s:12:"_multiwidget";i:1;}                     | yes      |
|       458 | job_manager_enable_tag_archive              |                                                    | yes      |
|       459 | job_manager_tags_filter_type                | any                                                | yes      |
|       460 | astoundify_wpjmll_filter_results_all_labels |                                                    | yes      |
|       461 | job_manager_max_tags                        |                                                    | yes      |
|       462 | job_manager_tag_input                       |                                                    | yes      |
|       463 | astoundify_wpjmll_order_by                  | count                                              | yes      |
|       464 | astoundify_wpjmll_order                     | DESC                                               | yes      |
+-----------+

After data importing

select option_id, option_name, substring(option_value, 1,50), autoload from bdroptions where option_name not like "%transient%" and option_id >464;
+-----------+
| option_id | option_name                                | substring(option_value, 1,50)                      | autoload |
+-----------+
|       465 | theme_mods_listify                         | a:9:{s:8:"nav-cart";d:0;s:13:"nav-secondary";d:0;s | yes      |
|       487 | job_listing_region_children                | a:0:{}                                             | yes      |
|       494 | product_cat_children                       | a:0:{}                                             | yes      |
|       503 | job_listing_category_children              | a:2:{i:53;a:3:{i:0;i:55;i:1;i:56;i:2;i:57;}i:59;a: | yes      |
|       504 | category_children                          | a:0:{}                                             | yes      |
|       520 | job_manager_stats_page_id                  |                                                    | yes      |
|       541 | widget_listify_widget_panel_business_hours | a:3:{i:1;a:2:{s:5:"title";s:5:"Hours";s:4:"icon";s | yes      |
+-----------+