diff options
Diffstat (limited to 'admin/upgrade_inc.php')
| -rw-r--r-- | admin/upgrade_inc.php | 39 |
1 files changed, 22 insertions, 17 deletions
diff --git a/admin/upgrade_inc.php b/admin/upgrade_inc.php index 7e6f64b..d82240a 100644 --- a/admin/upgrade_inc.php +++ b/admin/upgrade_inc.php @@ -7,23 +7,23 @@ $upgrades = array( // STEP 1 array( 'DATADICT' => array( -array( 'RENAMECOLUMN' => array( - 'messu_messages' => array( - '`msgId`' => '`msg_id` I4 AUTO', - '`isRead`' => '`is_read` VARCHAR(1)', - '`isReplied`' => '`is_replied` VARCHAR(1)', - '`isFlagged`' => '`is_flagged` VARCHAR(1)', - '`user_to`' => '`msg_to` X', - '`user_cc`' => '`msg_cc` X', - '`user_bcc`' => '`msg_bcc` X', - ), -)), -array( 'ALTER' => array( - 'messu_messages' => array( - 'to_user_id' => array( '`to_user_id`', 'I4' ), - 'from_user_id' => array( '`from_user_id`', 'I4' ), - ), -)) + array( 'RENAMECOLUMN' => array( + 'messu_messages' => array( + '`msgId`' => '`msg_id` I4 AUTO', + '`isRead`' => '`is_read` VARCHAR(1)', + '`isReplied`' => '`is_replied` VARCHAR(1)', + '`isFlagged`' => '`is_flagged` VARCHAR(1)', + '`user_to`' => '`msg_to` X', + '`user_cc`' => '`msg_cc` X', + '`user_bcc`' => '`msg_bcc` X', + ), + )), + array( 'ALTER' => array( + 'messu_messages' => array( + 'to_user_id' => array( '`to_user_id`', 'I4' ), + 'from_user_id' => array( '`from_user_id`', 'I4' ), + ), + )) )), // STEP 3 @@ -72,6 +72,11 @@ array( 'DATADICT' => array( CONSTRAINT ', CONSTRAINT `messages_system_message_ref` FOREIGN KEY (`msg_id`) REFERENCES `".BIT_DB_PREFIX."messages` (`msg_id`)' " )), + array( 'RENAMECOLUMN' => array( + 'messages' => array( + '`date`' => 'msg_date' + ), + )), )), ) |