[Phpcompta-dev] r4227 - phpcompta/trunk/sql

[phpcompta-dev]

Author: danydb
Date: 2011-10-22 22:19:19 +0200 (Sat, 22 Oct 2011)
New Revision: 4227

Modified:
   phpcompta/trunk/sql/upgrade.sql
Log:
add index to avoid duplicate quickcode

Modified: phpcompta/trunk/sql/upgrade.sql
===================================================================
--- phpcompta/trunk/sql/upgrade.sql     2011-10-22 20:17:50 UTC (rev 4226)
+++ phpcompta/trunk/sql/upgrade.sql     2011-10-22 20:19:19 UTC (rev 4227)
@@ -14,4 +14,4 @@
 tmp_pcmn_ins.sql
 trigger.tmp_pcmn.sql
 */
-create unique index test_qcode_idx on fiche_detail (ad_value) where ad_id=23;
+create unique index qcode_idx on fiche_detail (ad_value) where ad_id=23;