From 964e15325884ed7b3d9ff9217a9c11a36c017200 Mon Sep 17 00:00:00 2001 From: Jams H Thompson Date: Wed, 16 Aug 2006 06:03:54 +0000 Subject: Improve SQL performance and add liberty_content_hits table --- admin/upgrade_inc.php | 1 + 1 file changed, 1 insertion(+) diff --git a/admin/upgrade_inc.php b/admin/upgrade_inc.php index 9f9fc11..d37caf3 100644 --- a/admin/upgrade_inc.php +++ b/admin/upgrade_inc.php @@ -333,6 +333,7 @@ array( 'CREATEINDEX' => array( 'users_groupperms_group_idx' => array( 'users_grouppermissions', '`group_id`,`perm_name`', array( 'UNIQUE' ) ), 'users_groups_inc_group_idx' => array( 'users_groups_inclusion', '`group_id`', array() ), 'users_groups_inc_gi_idx' => array( 'users_groups_inclusion', '`group_id`,`include_group_id`', array( 'UNIQUE' ) ), + 'users_groups_gi_idx' => array( 'users_groups', '`group_id`', array('UNIQUE') ), )), )), -- cgit v1.3