diff options
| author | Max Kremmel <xing@synapse.plus.com> | 2006-03-29 08:22:45 +0000 |
|---|---|---|
| committer | Max Kremmel <xing@synapse.plus.com> | 2006-03-29 08:22:45 +0000 |
| commit | 880308ee043676afb8dcf0114c6fb0c17673d534 (patch) | |
| tree | 0fc10044fb360849004e4137b7ebdb37cf0a4ce1 /admin | |
| parent | 1eaf057053924e9f2627edd70e1bef4cc265f8dd (diff) | |
| download | messages-880308ee043676afb8dcf0114c6fb0c17673d534.tar.gz messages-880308ee043676afb8dcf0114c6fb0c17673d534.tar.bz2 messages-880308ee043676afb8dcf0114c6fb0c17673d534.zip | |
upgrader brought up to latest state on SchemaChangeLog except for the liberty_content_stuff
2006-02-21 and 2006-02-24 remain to be dealt with
any db changes need to go in respective upgraders from now on. chaos doesn't rule anymore - not even in HEAD
Diffstat (limited to 'admin')
| -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' + ), + )), )), ) |