WordPress.org
Get WordPress

Plugin Directory

Changeset 1456397


Ignore:
Timestamp:
07/18/2016 12:51:15 PM (10 years ago)
Author:
daif
Message:

Use utf8 encoding "utf8mb4_unicode_ci" for all tables.
No more removing tables on deactivate the plugin.

Location:
sms-sender/trunk
Files:
3 edited

Legend:

Unmodified
Added
Removed

  • sms-sender/trunk/includes/hooks/activation.php

    r1229749 r1456397  
    1212        `group_name` varchar(120) NOT NULL,
    1313        PRIMARY KEY  (`group_id`)
    14     );';
     14    ) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;';
    1515    $wpdb->query($sql_groups);
    1616
    … …  
    2424        PRIMARY KEY  (`contact_id`) ,
    2525        KEY `contact_group_id` (`contact_group_id`)
    26     );';
     26    ) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;';
    2727    $wpdb->query($sql_contacts);
    2828
    … …  
    3434        `msg_status` int(1) NOT NULL default \'0\',
    3535        PRIMARY KEY  (`msg_id`)
    36     );';
     36    ) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;';
    3737    $wpdb->query($sql_messages);
    3838
    … …  
    4848        KEY `send_msg_id` (`send_msg_id`),
    4949        KEY `send_group` (`send_group`)
    50     );';
     50    ) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;';
    5151    $wpdb->query($sql_messages);
    5252

  • sms-sender/trunk/includes/hooks/deactivate.php

    r1229749 r1456397  
    33    defined( 'ABSPATH' ) || die( 'No direct script access allowed!' );
    44
    5     // DeActivate hook
    6     global $wpdb;
    7     //drop tables
    8     $wpdb->query('DROP TABLE IF EXISTS `'. $wpdb->prefix.'smsgw_groups`');
    9     $wpdb->query('DROP TABLE IF EXISTS `'. $wpdb->prefix.'smsgw_contacts`');
    10     $wpdb->query('DROP TABLE IF EXISTS `'. $wpdb->prefix.'smsgw_messages`');
    11     $wpdb->query('DROP TABLE IF EXISTS `'. $wpdb->prefix.'smsgw_send`');
    12 
    13     //delete options
    14     delete_option('smsgwnet_api_provider');
    15     delete_option('smsgwnet_api_user');
    16     delete_option('smsgwnet_api_pass');
    17     delete_option('smsgwnet_api_tag');
    18     delete_option('smsgwnet_credit');
    19     delete_option('smsgwnet_version');
    20     delete_option('smsgwnet_db_version');
    215?>

  • sms-sender/trunk/smsgw.php

    r1417183 r1456397  
    33/**
    44 * @package Smsgwnet
    5  * @version 0.6
     5 * @version 0.7
    66 */
    77
    … …  
    1212 * Author:      Daif Alotaibi
    1313 * Author URI:  http://daif.net/
    14  * Version:     0.6
     14 * Version:     0.7
    1515 * Text Domain: smsgwnet
    1616 * Domain Path: /languages/
    … …  
    2121
    2222// define plug-in constants
    23 define( 'SMSGW_VERSION',        '0.6' );
    24 define( 'SMSGW_DB_VERSION',     '0.1' );
     23define( 'SMSGW_VERSION',        '0.7' );
     24define( 'SMSGW_DB_VERSION',     '0.2' );
    2525define( 'SMSGW_FILE',           __FILE__ );
    2626define( 'SMSGW_PATH',           dirname( SMSGW_FILE ));
Note: See TracChangeset for help on using the changeset viewer.