| @@ -170,24 +170,8 @@ | ||
| 170 | 170 | assigned_by integer, |
| 171 | 171 | PRIMARY KEY (id) |
| 172 | 172 | );"; |
| 173 | 173 | dbDelta( $sql ); |
| 174 | - $sql = "CREATE TABLE IF NOT EXISTS {$wpdb->prefix}wppm_project_comment_meta ( | |
| 175 | - id BIGINT NOT NULL AUTO_INCREMENT, | |
| 176 | - proj_id integer, | |
| 177 | - comment_id integer, | |
| 178 | - comment_type VARCHAR(200) NOT NULL, | |
| 179 | - PRIMARY KEY (id) | |
| 180 | - );"; | |
| 181 | - dbDelta( $sql ); | |
| 182 | - $sql = "CREATE TABLE IF NOT EXISTS {$wpdb->prefix}wppm_task_comment_meta ( | |
| 183 | - id BIGINT NOT NULL AUTO_INCREMENT, | |
| 184 | - task_id integer, | |
| 185 | - comment_id integer, | |
| 186 | - comment_type VARCHAR(200) NOT NULL, | |
| 187 | - PRIMARY KEY (id) | |
| 188 | - );"; | |
| 189 | - dbDelta( $sql ); | |
| 190 | 174 | } |
| 191 | 175 | |
| 192 | 176 | public function upgrade(){ |
| 193 | 177 | global $wpdb; |
| @@ -408,99 +392,8 @@ | ||
| 408 | 392 | 'save-changes-button-bg-color'=>'#306EFF', |
| 409 | 393 | 'save-changes-button-text-color'=>'#fff' |
| 410 | 394 | ) |
| 411 | 395 | ); |
| 412 | - } | |
| 413 | - if($installed_version < '3.0.1'){ | |
| 414 | - update_option('wppm_default_project_status', 1); | |
| 415 | - update_option('wppm_default_task_status', 1); | |
| 416 | - } | |
| 417 | - if($installed_version < '3.0.5'){ | |
| 418 | - update_option('wppm_tinymce_visibility_open_task',0); | |
| 419 | - update_option('wppm_tinymce_visibility_open_project',0); | |
| 420 | - update_option('wppm_default_email_notification_to_current_user', 1); | |
| 421 | - } | |
| 422 | - if($installed_version < '3.0.6'){ | |
| 423 | - update_option('wppm_allow_coworkers_create_task',1); | |
| 424 | - update_option('wppm_allow_coworkers_add_checklist',1); | |
| 425 | - update_option('wppm_allow_coworkers_assign_users', 0); | |
| 426 | - update_option('wppm_allow_coworkers_change_status', 1); | |
| 427 | - } | |
| 428 | - if($installed_version < '3.0.9'){ | |
| 429 | - update_option('wppm_rich_text_editor',1); | |
| 430 | - update_option( | |
| 431 | - 'wppm_toolbar_actions', | |
| 432 | - array( | |
| 433 | - 'bold' => '1', | |
| 434 | - 'italic' => '1', | |
| 435 | - 'underline' =>'1', | |
| 436 | - 'blockquote' =>'1', | |
| 437 | - 'align'=>'1', | |
| 438 | - 'bullist'=>'1', | |
| 439 | - 'numlist'=>'1', | |
| 440 | - 'rtl'=>'1', | |
| 441 | - 'link'=>'1', | |
| 442 | - 'wppm_insert_editor_img'=>'1', | |
| 443 | - 'forecolor'=>'0', | |
| 444 | - 'backcolor' => '0', | |
| 445 | - 'strikethrough' => '0' | |
| 446 | - ) | |
| 447 | - ); | |
| 448 | - } | |
| 449 | - | |
| 450 | - if($installed_version < '4.0.0'){ | |
| 451 | - update_option( | |
| 452 | - 'wppm-page-settings', | |
| 453 | - array( | |
| 454 | - 'task-url-page' => 0, | |
| 455 | - 'project-url-page' => 0 | |
| 456 | - ) | |
| 457 | - ); | |
| 458 | - } | |
| 459 | - | |
| 460 | - if($installed_version < '4.0.4'){ | |
| 461 | - update_option('wppm_date_setting','Y-m-d h:i:sa'); | |
| 462 | - } | |
| 463 | - | |
| 464 | - if($installed_version < '4.0.5'){ | |
| 465 | - update_option('wppm_hide_completed_status_proj','1'); | |
| 466 | - update_option('wppm_hide_completed_status_task','1'); | |
| 467 | - update_option('wppm_hide_proj_statuses_from_frontend','0'); | |
| 468 | - update_option('wppm_hide_task_statuses_from_frontend','0'); | |
| 469 | - update_option('wppm_proj_hide_comment_section','1'); | |
| 470 | - update_option('wppm_task_hide_comment_section','1'); | |
| 471 | - } | |
| 472 | - | |
| 473 | - if($installed_version < '5.0.0'){ | |
| 474 | - $wppm_print_settings = array( | |
| 475 | - 'wppm_print_body_font_size' => 10); | |
| 476 | - update_option('wppm_print_settings',$wppm_print_settings); | |
| 477 | - } | |
| 478 | - if($installed_version < '5.0.2'){ | |
| 479 | - $column_name = 'load_order'; | |
| 480 | - $column_type = 'int(11) NOT NULL DEFAULT 1'; | |
| 481 | - // Check if the column already exists to avoid duplicate errors | |
| 482 | - $column_exists = $wpdb->get_results( | |
| 483 | - $wpdb->prepare( | |
| 484 | - "SHOW COLUMNS FROM `{$wpdb->prefix}wppm_checklist_items` LIKE %s", | |
| 485 | - $column_name | |
| 486 | - ) | |
| 487 | - ); | |
| 488 | - if (empty($column_exists)) { | |
| 489 | - $wpdb->query("ALTER TABLE `{$wpdb->prefix}wppm_checklist_items` ADD `$column_name` $column_type"); | |
| 490 | - } | |
| 491 | - $cl_name = 'is_archived'; | |
| 492 | - $cl_type = 'TINYINT(1) DEFAULT 0'; | |
| 493 | - // Check if the column already exists to avoid duplicate errors | |
| 494 | - $cl_exists = $wpdb->get_results( | |
| 495 | - $wpdb->prepare( | |
| 496 | - "SHOW COLUMNS FROM `{$wpdb->prefix}wppm_task` LIKE %s", | |
| 497 | - $cl_name | |
| 498 | - ) | |
| 499 | - ); | |
| 500 | - if (empty($cl_exists)) { | |
| 501 | - $wpdb->query("ALTER TABLE `{$wpdb->prefix}wppm_task` ADD `$cl_name` $cl_type"); | |
| 502 | - } | |
| 503 | 396 | } |
| 504 | 397 | // update wppm_version option to plugin version |
| 505 | 398 | update_option( 'wppm_version', WPPM_VERSION ); |
| 506 | 399 | } |
