DB structure of WP Job Manager

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

Job manager region plugin

additional values for options

Reviews for WP Job Manager plugin

Added values for options table


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;


Products for WP Job Manager

Added values to options table


Listing Payments for WP Job Manager

bdrwcpl_user_packages

No data

Values added to options table


Stats for WP Job Manager

bdrjob_manager_stats

Added values to options table


Listing Labels for WP Job Manager

Added values to options table


After data importing

栗田 創 (Hajime Kurita): Search Engineer/AWS Solution Architect/Professional Scrum Master/Web Master

I am using Twitter for announcing updates and my thought, so if you are interested in my articles, please follow me on twitter.