legalcase/inc inc_db_upgrade.php, 1.77, 1.78 inc_db_create.php, 1.64, 1.65

Update of /cvsroot/legalcase/legalcase/inc
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv4718

Modified Files:
	inc_db_upgrade.php inc_db_create.php 
Log Message:
drop the idx_case_stage key

Index: inc_db_upgrade.php
===================================================================
RCS file: /cvsroot/legalcase/legalcase/inc/inc_db_upgrade.php,v
retrieving revision 1.77
retrieving revision 1.78
diff -C2 -d -r1.77 -r1.78
*** inc_db_upgrade.php	1 Feb 2008 20:23:54 -0000	1.77
--- inc_db_upgrade.php	7 Apr 2008 19:24:03 -0000	1.78
***************
*** 1285,1288 ****
--- 1285,1304 ----
  	}

+ 	if ($lcm_db_version_current < 56) {
+ 		// should have been done a long time ago
+ 		lcm_query("ALTER TABLE lcm_case
+ 					DROP id_court_archive", true);
+ 
+ 		upgrade_db_version(56);
+ 	}
+ 
+ 	if ($lcm_db_version_current < 57) {
+ 		// should have been done a long time ago
+ 		lcm_query("ALTER TABLE lcm_stage
+ 					DROP key idx_case_stage");
+ 
+ 		upgrade_db_version(57);
+ 	}
+ 
  	// Update the meta, lcm_fields, keywords, etc.
  	lcm_log("Updating LCM default configuration (meta/keywords/repfields/..)", 'upgrade');

Index: inc_db_create.php
===================================================================
RCS file: /cvsroot/legalcase/legalcase/inc/inc_db_create.php,v
retrieving revision 1.64
retrieving revision 1.65
diff -C2 -d -r1.64 -r1.65
*** inc_db_create.php	1 Feb 2008 20:24:46 -0000	1.64
--- inc_db_create.php	7 Apr 2008 19:24:03 -0000	1.65
***************
*** 108,113 ****

  	lcm_query_create_table('lcm_stage', $fields, $keys);
! 	lcm_query_create_unique_index('lcm_stage', 'idx_case_stage', 'id_case, kw_case_stage');
! 

  	$fields = array (
--- 108,112 ----

  	lcm_query_create_table('lcm_stage', $fields, $keys);
! 	// [ML] 0.7.3 lcm_query_create_unique_index('lcm_stage', 'idx_case_stage', 'id_case, kw_case_stage');

  	$fields = array (

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
Register now and save $200. Hurry, offer ends at 11:59 p.m., 
Monday, April 7! Use priority code J8TLD2. 
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone