summaryrefslogtreecommitdiff
path: root/admin/upgrade_inc.php
diff options
context:
space:
mode:
Diffstat (limited to 'admin/upgrade_inc.php')
-rw-r--r--admin/upgrade_inc.php91
1 files changed, 0 insertions, 91 deletions
diff --git a/admin/upgrade_inc.php b/admin/upgrade_inc.php
deleted file mode 100644
index 836e93b..0000000
--- a/admin/upgrade_inc.php
+++ /dev/null
@@ -1,91 +0,0 @@
-<?php
-global $gBitSystem, $gUpgradeFrom, $gUpgradeTo;
-
-$upgrades = array(
- 'BONNIE' => array(
- 'BWR1' => 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' ),
- ),
- ))
-)),
-
-// STEP 3
-array( 'QUERY' =>
- array( 'SQL92' => array(
- "UPDATE `".BIT_DB_PREFIX."messu_messages` SET `to_user_id`=(SELECT `user_id` FROM `".BIT_DB_PREFIX."users_users` WHERE `".BIT_DB_PREFIX."users_users`.`login`=`".BIT_DB_PREFIX."messu_messages`.`user`)",
- "UPDATE `".BIT_DB_PREFIX."messu_messages` SET `from_user_id`=(SELECT `user_id` FROM `".BIT_DB_PREFIX."users_users` WHERE `".BIT_DB_PREFIX."users_users`.`login`=`".BIT_DB_PREFIX."messu_messages`.`user_from`)",
- ),
-)),
-
-// STEP 4
-array( 'DATADICT' => array(
- array( 'DROPCOLUMN' => array(
- 'messu_messages' => array( '`user`', '`user_from`' ),
- )),
-)),
-
- )
- ),
-
-
-
-// next upgrade path
- 'BWR1' => array(
- 'BWR2' => array(
-
-array( 'DATADICT' => array(
- array( 'ALTER' => array(
- 'messu_messages' => array(
- 'group_id' => array( '`group_id`', 'I4' ),
- ),
- )),
- // de-tikify tables
- array( 'RENAMETABLE' => array(
- 'messu_messages' => 'messages',
- )),
- array( 'CREATE' => array (
- 'messages_system_map' => "
- msg_id I4,
- to_user_id I4 NOTNULL,
- is_read C(1),
- is_flagged C(1),
- is_replied C(1),
- priority I4,
- is_hidden C(1)
- 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` I8'
- ),
- )),
-)),
-
- )
- ),
-);
-
-if( isset( $upgrades[$gUpgradeFrom][$gUpgradeTo] ) ) {
- $gBitSystem->registerUpgrade( MESSAGES_PKG_NAME, $upgrades[$gUpgradeFrom][$gUpgradeTo] );
-}
-
-
-?>