WordPress.org
Get WordPress

Plugin Directory

Changeset 996722


Ignore:
Timestamp:
09/25/2014 04:52:12 PM (12 years ago)
Author:
freshlabs
Message:

Prepared update function for storing dates as CHAR(20)

File:
1 edited

Legend:

Unmodified
Added
Removed

  • wp-simile-timeline/trunk/inc/WPSimileTimelineDatabase.class.php

    r994229 r996722  
    4040        // @since: 0.4.9
    4141        // Alter posts columns for event dates to CHAR(20) to store dates B.C.
    42         // 20 Characters: A/B für after/before christ + 19 for YYYY-MM-DD HH:ii:ss
     42        // 20 Characters: A/B für A.D/B.C + 19 for YYYY-MM-DD HH:ii:ss
     43        /*
    4344        $post_event_dates = WPSimileTimelinePost::getPostEventTypes();
    4445        foreach($post_event_dates as $column):
    4546            if(WPSimileTimelineDatabase::columnExists($wpdb->posts, $column)){
    46                 $wpdb->query("ALTER TABLE " .$wpdb->posts . " CHANGE `" . $column . "` `" . $column . "` VARCHAR(20) NOT NULL DEFAULT '0000-00-00 00:00:00'; ");
     47                $wpdb->query("ALTER TABLE " .$wpdb->posts . " CHANGE `" . $column . "` `" . $column . "` VARCHAR(20) NOT NULL DEFAULT 'A0000-00-00 00:00:00'; ");
     48                // TODO: Loop through existing datetimes and add 'A' as default prefix
    4749            }
    4850        endforeach;
    49 
     51        */
    5052
    5153        // Add column for icon in terms table
Note: See TracChangeset for help on using the changeset viewer.