diff options
| author | bitweaver.org <bitweaver@users.sourceforge.net> | 2006-01-31 21:27:55 +0000 |
|---|---|---|
| committer | bitweaver.org <bitweaver@users.sourceforge.net> | 2006-01-31 21:27:55 +0000 |
| commit | 4b3fd1d13b7d19891cd1b951935a55cad4dcb28a (patch) | |
| tree | beade761c522a03fdd194627013d72564c2670d7 /admin | |
| parent | 4c708caa9ea6ed60ddbac44bee93222ee71569d7 (diff) | |
| download | messages-4b3fd1d13b7d19891cd1b951935a55cad4dcb28a.tar.gz messages-4b3fd1d13b7d19891cd1b951935a55cad4dcb28a.tar.bz2 messages-4b3fd1d13b7d19891cd1b951935a55cad4dcb28a.zip | |
massive table de-tikification. changed all tiki_ table prefixes with teh package_ name. have changed everything except liberty except kernel
Diffstat (limited to 'admin')
| -rw-r--r-- | admin/schema_inc.php | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index 383435d..f928d96 100644 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -2,7 +2,7 @@ $tables = array( -'messu_messages' => " +'messages' => " msg_id I4 AUTO PRIMARY, to_user_id I4 NOTNULL, from_user_id I4 NOTNULL, @@ -20,7 +20,7 @@ $tables = array( priority I4 ", -'messu_system_message_map' => " +'messages_system_map' => " msg_id I4, to_user_id I4 NOTNULL, is_read C(1), @@ -28,7 +28,7 @@ $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."messu_messages` (`msg_id`)' + CONSTRAINTS ', CONSTRAINT `tiki_messu_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) @@ -58,11 +58,11 @@ $gBitInstaller->registerUserPermissions( MESSU_PKG_NAME, array( // ### Indexes $indices = array ( - 'tiki_messu_to_user_id_idx' => array( 'table' => 'messu_messages', 'cols' => 'to_user_id', 'opts' => NULL ), - 'tiki_messu_from_user_id_idx' => array( 'table' => 'messu_messages', 'cols' => 'from_user_id', 'opts' => NULL ) + '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 ) ); // TODO - SPIDERR - following seems to cause time _decrease_ cause bigint on postgres. need more investigation -// 'tiki_blog_posts_created_idx' => array( 'table' => 'tiki_blog_posts', 'cols' => 'created', 'opts' => NULL ), +// 'blog_posts_created_idx' => array( 'table' => 'blog_posts', 'cols' => 'created', 'opts' => NULL ), $gBitInstaller->registerSchemaIndexes( MESSU_PKG_NAME, $indices ); ?> |