diff options
| author | Max Kremmel <xing@synapse.plus.com> | 2006-02-02 08:15:42 +0000 |
|---|---|---|
| committer | Max Kremmel <xing@synapse.plus.com> | 2006-02-02 08:15:42 +0000 |
| commit | ce8d124fa6a8f2f10948c0ae50ceb7a989c33256 (patch) | |
| tree | 9aa6cc960ebbee922a23541db180797ca8174eef /admin | |
| parent | 550e349c84a024faae285557bdc399b2df149a83 (diff) | |
| download | messages-ce8d124fa6a8f2f10948c0ae50ceb7a989c33256.tar.gz messages-ce8d124fa6a8f2f10948c0ae50ceb7a989c33256.tar.bz2 messages-ce8d124fa6a8f2f10948c0ae50ceb7a989c33256.zip | |
detikify indeces
Diffstat (limited to 'admin')
| -rw-r--r-- | admin/schema_inc.php | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index f928d96..2739654 100644 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -28,11 +28,11 @@ $tables = array( is_replied C(1), priority I4, is_hidden C(1) - CONSTRAINTS ', CONSTRAINT `tiki_messu_system_message_ref` FOREIGN KEY (`msg_id`) REFERENCES `".BIT_DB_PREFIX."messages` (`msg_id`)' + CONSTRAINTS ', CONSTRAINT `messages_system_message_ref` FOREIGN KEY (`msg_id`) REFERENCES `".BIT_DB_PREFIX."messages` (`msg_id`)' " -// CONSTRAINT ', CONSTRAINT tiki_messu_to_user_ref FOREIGN KEY (to_user_id) REFERENCES `".BIT_DB_PREFIX."users_users` (user_id) -// , CONSTRAINT tiki_messu_from_user_ref FOREIGN KEY (from_user_id) REFERENCES `".BIT_DB_PREFIX."users_users` (user_id)' +// CONSTRAINT ', CONSTRAINT messages_to_user_ref FOREIGN KEY (to_user_id) REFERENCES `".BIT_DB_PREFIX."users_users` (user_id) +// , CONSTRAINT messages_from_user_ref FOREIGN KEY (from_user_id) REFERENCES `".BIT_DB_PREFIX."users_users` (user_id)' ); @@ -58,8 +58,8 @@ $gBitInstaller->registerUserPermissions( MESSU_PKG_NAME, array( // ### Indexes $indices = array ( - 'tiki_messu_to_user_id_idx' => array( 'table' => 'messages', 'cols' => 'to_user_id', 'opts' => NULL ), - 'tiki_messu_from_user_id_idx' => array( 'table' => 'messages', 'cols' => 'from_user_id', 'opts' => NULL ) + 'messages_to_user_id_idx' => array( 'table' => 'messages', 'cols' => 'to_user_id', 'opts' => NULL ), + 'messages_from_user_id_idx' => array( 'table' => 'messages', 'cols' => 'from_user_id', 'opts' => NULL ) ); // TODO - SPIDERR - following seems to cause time _decrease_ cause bigint on postgres. need more investigation // 'blog_posts_created_idx' => array( 'table' => 'blog_posts', 'cols' => 'created', 'opts' => NULL ), |