WordPress.org
Get WordPress

Plugin Directory

Changeset 2361312


Ignore:
Timestamp:
08/14/2020 04:45:39 PM (6 years ago)
Author:
Will Brownsberger
Message:

no longer use MyISAM

Location:
wp-issues-crm
Files:
20 edited
1 copied

Legend:

Unmodified
Added
Removed

  • wp-issues-crm/tags/4.5.4/php/admin/class-wic-admin-settings.php

    r2190225 r2361312  
    577577                        }
    578578                ?></tr>
    579                 <tr><td>MySQL Version</td><td>5.6</td><td>5.6</td><td><?php $version = self::get_mysql_version(); echo $version; ?></td>
     579                <tr><td>MySQL Version</td><td>5.6.4</td><td>5.6.4</td><td><?php $version = self::get_mysql_version(); echo $version; ?></td>
    580580                    <?php
    581581                        if ( version_compare ( $version, 5.6, '>=' ) ) {

  • wp-issues-crm/tags/4.5.4/php/entity/class-wic-entity-email-inbox-parse.php

    r2149005 r2361312  
    138138    // no change
    139139    public static function get_max_packet_size () {
     140       
     141        // allow for local max packet size
     142        if( defined('LOCAL_MAX_PACKET_SIZE') ) {
     143            return LOCAL_MAX_PACKET_SIZE;
     144        }
     145   
    140146        global $wpdb;
    141147        // determine maximum packet size

  • wp-issues-crm/tags/4.5.4/php/entity/class-wic-entity-email-md5.php

    r2037806 r2361312  
    116116            sentence_md5_temp varchar(50) NOT NULL,
    117117            KEY  (sentence_md5_temp(50))
    118             ) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4;
     118            ) DEFAULT CHARSET=utf8mb4;
    119119            ");
    120120        $md5_table = $wpdb->prefix . 'wic_inbox_md5_issue_map';

  • wp-issues-crm/tags/4.5.4/php/entity/class-wic-entity-email-oauth-synch.php

    r2134249 r2361312  
    155155            thread_id varchar(512) NOT NULL,
    156156            KEY  (message_id(300))
    157             ) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4;
     157            ) DEFAULT CHARSET=utf8mb4;
    158158            ");
    159159        if ( 1 != $result ) {

  • wp-issues-crm/tags/4.5.4/php/entity/class-wic-entity-upload-match.php

    r2019577 r2361312  
    277277                    PRIMARY KEY (STAGING_TABLE_ID),
    278278                    KEY MATCH_PASS (FIRST_NOT_FOUND_MATCH_PASS) )
    279                     ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4;';
     279                    DEFAULT CHARSET=utf8mb4;';
    280280        $result = $wpdb->query ( $sql );
    281281        if ( false === $result ) {

  • wp-issues-crm/tags/4.5.4/php/entity/class-wic-entity-upload-set-defaults.php

    r2076584 r2361312  
    7676            PRIMARY KEY (new_issue_ID),         
    7777            KEY new_issue_title (new_issue_title)
    78             ) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 ";
     78            ) DEFAULT CHARSET=utf8mb4 ";
    7979        $result = $wpdb->query( $sql );
    8080       

  • wp-issues-crm/tags/4.5.4/php/entity/class-wic-entity-upload-upload.php

    r2160765 r2361312  
    455455                    'PRIMARY KEY (STAGING_TABLE_ID), ' .
    456456                    'KEY MATCHED_CONSTITUENT_ID (MATCHED_CONSTITUENT_ID) ' .
    457                     ') ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;';
     457                    ') DEFAULT CHARSET=utf8mb4;';
    458458
    459459        $result = $wpdb->query ( $sql );
    … …  
    534534        *  only reason NOT to break into smaller packets is to avoid partial saves -- user can see this result in staging and redo if necessary
    535535        *  SO: APPROACH THIS CONSERVATIVELY DO BREAK INTO SMALLISH INSERT PACKETS
    536         *       -- set rows per packet at 7500000 / max line length -- this will keep packet size under 1M and memory requirements modest
     536        *       -- set rows per packet at 750000 / max line length -- this will keep packet size under 1M and memory requirements modest
    537537        *            -- short rows with high overhead could blow this formula up . . . . go with row_count of 100 if this is lower 
    538538        *   -- set max execution time at 1500 with user in control -- should cover a million records at under 1000/second
    … …  
    546546        $insert_count = 0;           
    547547               
    548         // loop until end of file; would like to do transaction processing, but not supported by myisam
     548        // loop until end of file; would like to do transaction processing, but not supported by myisam (could now modify since no myisam)
    549549        // http://stackoverflow.com/questions/19153986/how-to-use-mysql-transaction-in-wordpress
    550550        while ( ! feof ( $handle ) ) {

  • wp-issues-crm/tags/4.5.4/readme.txt

    r2298368 r2361312  
    44Tags: contact, crm, constituent, customer, issues, list, email, forms, database, upload
    55Requires at least: 5
    6 Tested up to: 5.4.1
    7 Stable tag: 4.5.3.11
     6Tested up to: 5.5
     7Stable tag: 4.5.4
    88License: GPLv2 or later
    99License URI: http://www.gnu.org/licenses/gpl-2.0.html
    … …  
    108108
    109109== Changelog ==
     110= 4.5.4
     111* Change SQL engine to default (InnoDB) instead of MyISAM (note this change does not self implement on existing installations and requires MYSQL 5.6.4)
     112* Add option to define LOCAL_MAX_PACKET_SIZE in case working in environment where it is not acceessible through show variables
    110113= 4.5.3.11
    111114* Handle Office 365 IMAP non-standard behavior (return 0 instead of false on bad num_msg calld)

  • wp-issues-crm/tags/4.5.4/sql/wic_structures.sql

    r2147379 r2361312  
    2727KEY related_inbox_image_record (related_inbox_image_record),
    2828KEY related_outbox_record (related_outbox_record)
    29 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     29) DEFAULT CHARSET=utf8mb4;
    3030CREATE TABLE wp_wic_address (
    3131ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    5151KEY lat (lat),
    5252KEY lon (lon)
    53 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     53) DEFAULT CHARSET=utf8mb4;
    5454CREATE TABLE wp_wic_address_geocode_cache (
    5555ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    6868KEY lat (lat),
    6969KEY lon (lon)
    70 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     70) DEFAULT CHARSET=utf8mb4;
    7171CREATE TABLE wp_wic_constituent (
    7272ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    118118KEY last_updated_by (last_updated_by),
    119119KEY registration_id (registration_id(180))
    120 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     120) DEFAULT CHARSET=utf8mb4;
    121121CREATE TABLE wp_wic_data_dictionary (
    122122ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    149149KEY entity_slug (entity_slug),
    150150KEY field_group (group_slug)
    151 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     151) DEFAULT CHARSET=utf8mb4;
    152152CREATE TABLE wp_wic_email (
    153153ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    163163KEY last_updated_time (last_updated_time),
    164164KEY last_updated_by (last_updated_by)
    165 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     165) DEFAULT CHARSET=utf8mb4;
    166166CREATE TABLE wp_wic_external (
    167167ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    188188last_updated_by bigint(20) NOT NULL,
    189189PRIMARY KEY  (ID)
    190 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     190) DEFAULT CHARSET=utf8mb4;
    191191CREATE TABLE wp_wic_form_field_groups (
    192192ID bigint(20) NOT NULL AUTO_INCREMENT,
    … …  
    201201last_updated_by bigint(20) NOT NULL,
    202202PRIMARY KEY  (ID)
    203 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     203) DEFAULT CHARSET=utf8mb4;
    204204CREATE TABLE wp_wic_inbox_incoming_filter (
    205205ID bigint(20) NOT NULL AUTO_INCREMENT,
    … …  
    211211PRIMARY KEY  (ID),
    212212KEY email_address_reverse (from_email_domain(100),from_email_box(80))
    213 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     213) DEFAULT CHARSET=utf8mb4;
    214214CREATE TABLE wp_wic_inbox_image (
    215215ID bigint(20) NOT NULL AUTO_INCREMENT,
    … …  
    257257KEY staff_subject (inbox_defined_staff,subject(100)),
    258258KEY staff_final_subject (inbox_defined_staff,inbox_defined_reply_is_final,subject(100))
    259 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     259) DEFAULT CHARSET=utf8mb4;
    260260CREATE TABLE wp_wic_inbox_image_attachments (
    261261ID bigint(20) NOT NULL AUTO_INCREMENT,
    … …  
    270270PRIMARY KEY  (ID),
    271271KEY message_id_attachment_number (message_id,attachment_number(100))
    272 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     272) DEFAULT CHARSET=utf8mb4;
    273273CREATE TABLE wp_wic_inbox_image_attachments_xref (
    274274ID bigint(20) NOT NULL AUTO_INCREMENT,
    … …  
    287287KEY message_id_plus_key (message_in_outbox,message_id,attachment_id,message_attachment_number(80)),
    288288KEY message_attachment_filename_key (message_attachment_filename(100))
    289 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     289) DEFAULT CHARSET=utf8mb4;
    290290CREATE TABLE wp_wic_inbox_md5 (
    291291inbox_message_id bigint(20) NOT NULL,
    … …  
    294294KEY inbox_message_id (inbox_message_id),
    295295KEY message_sentence_md5 (message_sentence_md5)
    296 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     296) DEFAULT CHARSET=utf8mb4;
    297297CREATE TABLE wp_wic_inbox_md5_issue_map (
    298298sentence_md5 varchar(32) NOT NULL,
    … …  
    303303KEY sentence_md5 (sentence_md5),
    304304KEY map_utc_time_stamp (map_utc_time_stamp)
    305 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     305) DEFAULT CHARSET=utf8mb4;
    306306CREATE TABLE wp_wic_inbox_synch_log (
    307307ID bigint(20) NOT NULL AUTO_INCREMENT,
    … …  
    326326process_moves_time double NOT NULL,
    327327PRIMARY KEY  (ID)
    328 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     328) DEFAULT CHARSET=utf8mb4;
    329329CREATE TABLE wp_wic_interface (
    330330upload_field_name varchar(255) NOT NULL,
    … …  
    332332matched_field varchar(255) NOT NULL,
    333333PRIMARY KEY  (upload_field_name(180))
    334 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     334) DEFAULT CHARSET=utf8mb4;
    335335CREATE TABLE wp_wic_option_group (
    336336ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    342342is_system_reserved tinyint(1) NOT NULL DEFAULT '0',
    343343PRIMARY KEY  (ID)
    344 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     344) DEFAULT CHARSET=utf8mb4;
    345345CREATE TABLE wp_wic_option_value (
    346346ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    356356PRIMARY KEY  (ID),
    357357KEY enabled (enabled,option_group_id,value_order)
    358 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     358) DEFAULT CHARSET=utf8mb4;
    359359CREATE TABLE wp_wic_outbox (
    360360ID bigint(20) NOT NULL AUTO_INCREMENT,
    … …  
    375375KEY to_address_concat_key (to_address_concat(180)),
    376376KEY is_reply_to (is_reply_to)
    377 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     377) DEFAULT CHARSET=utf8mb4;
    378378CREATE TABLE wp_wic_phone (
    379379ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    390390KEY last_updated_time (last_updated_time),
    391391KEY last_updated_by (last_updated_by)
    392 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     392) DEFAULT CHARSET=utf8mb4;
    393393CREATE TABLE wp_wic_search_log (
    394394ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    409409KEY user_favorite_time (user_id,favorite,search_time),
    410410KEY named_user_favorite_time (is_named,share_name,user_id,favorite,search_time)
    411 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     411) DEFAULT CHARSET=utf8mb4;
    412412CREATE TABLE wp_wic_subject_issue_map (
    413413ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    420420KEY reverse_st (email_batch_time_stamp,incoming_email_subject(150)),
    421421KEY stamp (email_batch_time_stamp)
    422 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     422) DEFAULT CHARSET=utf8mb4;
    423423CREATE TABLE wp_wic_uid_reservation (
    424424ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    429429PRIMARY KEY  (uid),
    430430KEY internal_id (ID)
    431 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     431) DEFAULT CHARSET=utf8mb4;
    432432CREATE TABLE wp_wic_upload (
    433433ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    448448PRIMARY KEY  (ID),
    449449KEY upload_time_upload_by (upload_time,upload_by)
    450 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     450) DEFAULT CHARSET=utf8mb4;
    451451CREATE TABLE wp_wic_upload_temp (
    452452ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    456456PRIMARY KEY  (ID),
    457457KEY upload_chunk (upload_id,chunk_id)
    458 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     458) DEFAULT CHARSET=utf8mb4;

  • wp-issues-crm/tags/4.5.4/wp-issues-crm.php

    r2298368 r2361312  
    44 * Plugin URI: http://wp-issues-crm.com
    55 * Description: Constituent Relationship Management for organizations that respond to constituents.  Organizes constituent contacts ( calls, etc. ) around Wordpress posts and categories.
    6  * Version: 4.5.3.11
     6 * Version: 4.5.4
    77 * Author: Will Brownsberger
    88 * Author URI: http://willbrownsberger.com
    … …  
    3939// set database version global;
    4040global $wp_issues_crm_db_version;
    41 $wp_issues_crm_db_version = '4.5.3.8';
     41$wp_issues_crm_db_version = '4.5.4';
    4242/*
    4343* set js_css version global -- three possibilities:
    … …  
    4848*/
    4949global $wp_issues_crm_js_css_version;
    50 $wp_issues_crm_js_css_version = '4.5.3.8'; // may or not be set at release time
     50$wp_issues_crm_js_css_version = '4.5.4'; // may or not be set at release time
    5151if ( '' == $wp_issues_crm_js_css_version ) {
    5252    if ( strpos ( site_url(), 'localhost' ) > 0 ) {

  • wp-issues-crm/trunk/php/admin/class-wic-admin-settings.php

    r2190225 r2361312  
    577577                        }
    578578                ?></tr>
    579                 <tr><td>MySQL Version</td><td>5.6</td><td>5.6</td><td><?php $version = self::get_mysql_version(); echo $version; ?></td>
     579                <tr><td>MySQL Version</td><td>5.6.4</td><td>5.6.4</td><td><?php $version = self::get_mysql_version(); echo $version; ?></td>
    580580                    <?php
    581581                        if ( version_compare ( $version, 5.6, '>=' ) ) {

  • wp-issues-crm/trunk/php/entity/class-wic-entity-email-inbox-parse.php

    r2149005 r2361312  
    138138    // no change
    139139    public static function get_max_packet_size () {
     140       
     141        // allow for local max packet size
     142        if( defined('LOCAL_MAX_PACKET_SIZE') ) {
     143            return LOCAL_MAX_PACKET_SIZE;
     144        }
     145   
    140146        global $wpdb;
    141147        // determine maximum packet size

  • wp-issues-crm/trunk/php/entity/class-wic-entity-email-md5.php

    r2037806 r2361312  
    116116            sentence_md5_temp varchar(50) NOT NULL,
    117117            KEY  (sentence_md5_temp(50))
    118             ) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4;
     118            ) DEFAULT CHARSET=utf8mb4;
    119119            ");
    120120        $md5_table = $wpdb->prefix . 'wic_inbox_md5_issue_map';

  • wp-issues-crm/trunk/php/entity/class-wic-entity-email-oauth-synch.php

    r2134249 r2361312  
    155155            thread_id varchar(512) NOT NULL,
    156156            KEY  (message_id(300))
    157             ) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4;
     157            ) DEFAULT CHARSET=utf8mb4;
    158158            ");
    159159        if ( 1 != $result ) {

  • wp-issues-crm/trunk/php/entity/class-wic-entity-upload-match.php

    r2019577 r2361312  
    277277                    PRIMARY KEY (STAGING_TABLE_ID),
    278278                    KEY MATCH_PASS (FIRST_NOT_FOUND_MATCH_PASS) )
    279                     ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4;';
     279                    DEFAULT CHARSET=utf8mb4;';
    280280        $result = $wpdb->query ( $sql );
    281281        if ( false === $result ) {

  • wp-issues-crm/trunk/php/entity/class-wic-entity-upload-set-defaults.php

    r2076584 r2361312  
    7676            PRIMARY KEY (new_issue_ID),         
    7777            KEY new_issue_title (new_issue_title)
    78             ) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 ";
     78            ) DEFAULT CHARSET=utf8mb4 ";
    7979        $result = $wpdb->query( $sql );
    8080       

  • wp-issues-crm/trunk/php/entity/class-wic-entity-upload-upload.php

    r2160765 r2361312  
    455455                    'PRIMARY KEY (STAGING_TABLE_ID), ' .
    456456                    'KEY MATCHED_CONSTITUENT_ID (MATCHED_CONSTITUENT_ID) ' .
    457                     ') ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;';
     457                    ') DEFAULT CHARSET=utf8mb4;';
    458458
    459459        $result = $wpdb->query ( $sql );
    … …  
    534534        *  only reason NOT to break into smaller packets is to avoid partial saves -- user can see this result in staging and redo if necessary
    535535        *  SO: APPROACH THIS CONSERVATIVELY DO BREAK INTO SMALLISH INSERT PACKETS
    536         *       -- set rows per packet at 7500000 / max line length -- this will keep packet size under 1M and memory requirements modest
     536        *       -- set rows per packet at 750000 / max line length -- this will keep packet size under 1M and memory requirements modest
    537537        *            -- short rows with high overhead could blow this formula up . . . . go with row_count of 100 if this is lower 
    538538        *   -- set max execution time at 1500 with user in control -- should cover a million records at under 1000/second
    … …  
    546546        $insert_count = 0;           
    547547               
    548         // loop until end of file; would like to do transaction processing, but not supported by myisam
     548        // loop until end of file; would like to do transaction processing, but not supported by myisam (could now modify since no myisam)
    549549        // http://stackoverflow.com/questions/19153986/how-to-use-mysql-transaction-in-wordpress
    550550        while ( ! feof ( $handle ) ) {

  • wp-issues-crm/trunk/readme.txt

    r2298368 r2361312  
    44Tags: contact, crm, constituent, customer, issues, list, email, forms, database, upload
    55Requires at least: 5
    6 Tested up to: 5.4.1
    7 Stable tag: 4.5.3.11
     6Tested up to: 5.5
     7Stable tag: 4.5.4
    88License: GPLv2 or later
    99License URI: http://www.gnu.org/licenses/gpl-2.0.html
    … …  
    108108
    109109== Changelog ==
     110= 4.5.4
     111* Change SQL engine to default (InnoDB) instead of MyISAM (note this change does not self implement on existing installations and requires MYSQL 5.6.4)
     112* Add option to define LOCAL_MAX_PACKET_SIZE in case working in environment where it is not acceessible through show variables
    110113= 4.5.3.11
    111114* Handle Office 365 IMAP non-standard behavior (return 0 instead of false on bad num_msg calld)

  • wp-issues-crm/trunk/sql/wic_structures.sql

    r2147379 r2361312  
    2727KEY related_inbox_image_record (related_inbox_image_record),
    2828KEY related_outbox_record (related_outbox_record)
    29 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     29) DEFAULT CHARSET=utf8mb4;
    3030CREATE TABLE wp_wic_address (
    3131ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    5151KEY lat (lat),
    5252KEY lon (lon)
    53 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     53) DEFAULT CHARSET=utf8mb4;
    5454CREATE TABLE wp_wic_address_geocode_cache (
    5555ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    6868KEY lat (lat),
    6969KEY lon (lon)
    70 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     70) DEFAULT CHARSET=utf8mb4;
    7171CREATE TABLE wp_wic_constituent (
    7272ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    118118KEY last_updated_by (last_updated_by),
    119119KEY registration_id (registration_id(180))
    120 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     120) DEFAULT CHARSET=utf8mb4;
    121121CREATE TABLE wp_wic_data_dictionary (
    122122ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    149149KEY entity_slug (entity_slug),
    150150KEY field_group (group_slug)
    151 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     151) DEFAULT CHARSET=utf8mb4;
    152152CREATE TABLE wp_wic_email (
    153153ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    163163KEY last_updated_time (last_updated_time),
    164164KEY last_updated_by (last_updated_by)
    165 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     165) DEFAULT CHARSET=utf8mb4;
    166166CREATE TABLE wp_wic_external (
    167167ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    188188last_updated_by bigint(20) NOT NULL,
    189189PRIMARY KEY  (ID)
    190 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     190) DEFAULT CHARSET=utf8mb4;
    191191CREATE TABLE wp_wic_form_field_groups (
    192192ID bigint(20) NOT NULL AUTO_INCREMENT,
    … …  
    201201last_updated_by bigint(20) NOT NULL,
    202202PRIMARY KEY  (ID)
    203 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     203) DEFAULT CHARSET=utf8mb4;
    204204CREATE TABLE wp_wic_inbox_incoming_filter (
    205205ID bigint(20) NOT NULL AUTO_INCREMENT,
    … …  
    211211PRIMARY KEY  (ID),
    212212KEY email_address_reverse (from_email_domain(100),from_email_box(80))
    213 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     213) DEFAULT CHARSET=utf8mb4;
    214214CREATE TABLE wp_wic_inbox_image (
    215215ID bigint(20) NOT NULL AUTO_INCREMENT,
    … …  
    257257KEY staff_subject (inbox_defined_staff,subject(100)),
    258258KEY staff_final_subject (inbox_defined_staff,inbox_defined_reply_is_final,subject(100))
    259 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     259) DEFAULT CHARSET=utf8mb4;
    260260CREATE TABLE wp_wic_inbox_image_attachments (
    261261ID bigint(20) NOT NULL AUTO_INCREMENT,
    … …  
    270270PRIMARY KEY  (ID),
    271271KEY message_id_attachment_number (message_id,attachment_number(100))
    272 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     272) DEFAULT CHARSET=utf8mb4;
    273273CREATE TABLE wp_wic_inbox_image_attachments_xref (
    274274ID bigint(20) NOT NULL AUTO_INCREMENT,
    … …  
    287287KEY message_id_plus_key (message_in_outbox,message_id,attachment_id,message_attachment_number(80)),
    288288KEY message_attachment_filename_key (message_attachment_filename(100))
    289 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     289) DEFAULT CHARSET=utf8mb4;
    290290CREATE TABLE wp_wic_inbox_md5 (
    291291inbox_message_id bigint(20) NOT NULL,
    … …  
    294294KEY inbox_message_id (inbox_message_id),
    295295KEY message_sentence_md5 (message_sentence_md5)
    296 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     296) DEFAULT CHARSET=utf8mb4;
    297297CREATE TABLE wp_wic_inbox_md5_issue_map (
    298298sentence_md5 varchar(32) NOT NULL,
    … …  
    303303KEY sentence_md5 (sentence_md5),
    304304KEY map_utc_time_stamp (map_utc_time_stamp)
    305 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     305) DEFAULT CHARSET=utf8mb4;
    306306CREATE TABLE wp_wic_inbox_synch_log (
    307307ID bigint(20) NOT NULL AUTO_INCREMENT,
    … …  
    326326process_moves_time double NOT NULL,
    327327PRIMARY KEY  (ID)
    328 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     328) DEFAULT CHARSET=utf8mb4;
    329329CREATE TABLE wp_wic_interface (
    330330upload_field_name varchar(255) NOT NULL,
    … …  
    332332matched_field varchar(255) NOT NULL,
    333333PRIMARY KEY  (upload_field_name(180))
    334 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     334) DEFAULT CHARSET=utf8mb4;
    335335CREATE TABLE wp_wic_option_group (
    336336ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    342342is_system_reserved tinyint(1) NOT NULL DEFAULT '0',
    343343PRIMARY KEY  (ID)
    344 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     344) DEFAULT CHARSET=utf8mb4;
    345345CREATE TABLE wp_wic_option_value (
    346346ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    356356PRIMARY KEY  (ID),
    357357KEY enabled (enabled,option_group_id,value_order)
    358 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     358) DEFAULT CHARSET=utf8mb4;
    359359CREATE TABLE wp_wic_outbox (
    360360ID bigint(20) NOT NULL AUTO_INCREMENT,
    … …  
    375375KEY to_address_concat_key (to_address_concat(180)),
    376376KEY is_reply_to (is_reply_to)
    377 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     377) DEFAULT CHARSET=utf8mb4;
    378378CREATE TABLE wp_wic_phone (
    379379ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    390390KEY last_updated_time (last_updated_time),
    391391KEY last_updated_by (last_updated_by)
    392 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     392) DEFAULT CHARSET=utf8mb4;
    393393CREATE TABLE wp_wic_search_log (
    394394ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    409409KEY user_favorite_time (user_id,favorite,search_time),
    410410KEY named_user_favorite_time (is_named,share_name,user_id,favorite,search_time)
    411 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     411) DEFAULT CHARSET=utf8mb4;
    412412CREATE TABLE wp_wic_subject_issue_map (
    413413ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    420420KEY reverse_st (email_batch_time_stamp,incoming_email_subject(150)),
    421421KEY stamp (email_batch_time_stamp)
    422 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     422) DEFAULT CHARSET=utf8mb4;
    423423CREATE TABLE wp_wic_uid_reservation (
    424424ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    429429PRIMARY KEY  (uid),
    430430KEY internal_id (ID)
    431 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     431) DEFAULT CHARSET=utf8mb4;
    432432CREATE TABLE wp_wic_upload (
    433433ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    448448PRIMARY KEY  (ID),
    449449KEY upload_time_upload_by (upload_time,upload_by)
    450 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     450) DEFAULT CHARSET=utf8mb4;
    451451CREATE TABLE wp_wic_upload_temp (
    452452ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    … …  
    456456PRIMARY KEY  (ID),
    457457KEY upload_chunk (upload_id,chunk_id)
    458 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
     458) DEFAULT CHARSET=utf8mb4;

  • wp-issues-crm/trunk/wp-issues-crm.php

    r2298368 r2361312  
    44 * Plugin URI: http://wp-issues-crm.com
    55 * Description: Constituent Relationship Management for organizations that respond to constituents.  Organizes constituent contacts ( calls, etc. ) around Wordpress posts and categories.
    6  * Version: 4.5.3.11
     6 * Version: 4.5.4
    77 * Author: Will Brownsberger
    88 * Author URI: http://willbrownsberger.com
    … …  
    3939// set database version global;
    4040global $wp_issues_crm_db_version;
    41 $wp_issues_crm_db_version = '4.5.3.8';
     41$wp_issues_crm_db_version = '4.5.4';
    4242/*
    4343* set js_css version global -- three possibilities:
    … …  
    4848*/
    4949global $wp_issues_crm_js_css_version;
    50 $wp_issues_crm_js_css_version = '4.5.3.8'; // may or not be set at release time
     50$wp_issues_crm_js_css_version = '4.5.4'; // may or not be set at release time
    5151if ( '' == $wp_issues_crm_js_css_version ) {
    5252    if ( strpos ( site_url(), 'localhost' ) > 0 ) {
Note: See TracChangeset for help on using the changeset viewer.