[Phpcompta-dev] r4760 - phpcompta/tags/rel600/html/admin/sql/patch

[phpcompta-dev]

Author: danydb
Date: 2012-02-04 23:35:13 +0100 (Sat, 04 Feb 2012)
New Revision: 4760

Added:
   phpcompta/tags/rel600/html/admin/sql/patch/upgrade101.sql
Log:
Upgrade script


Added: phpcompta/tags/rel600/html/admin/sql/patch/upgrade101.sql
===================================================================
--- phpcompta/tags/rel600/html/admin/sql/patch/upgrade101.sql                   
        (rev 0)
+++ phpcompta/tags/rel600/html/admin/sql/patch/upgrade101.sql   2012-02-04 
22:35:13 UTC (rev 4760)
@@ -0,0 +1,11 @@
+begin;
+delete from letter_deb where ld_id in (select a.ld_id from letter_deb as a 
join letter_deb as b on (a.j_id=b.j_id  and a.ld_id > b.ld_id));
+delete from letter_cred where lc_id in (select a.lc_id from letter_cred as a 
join letter_cred as b on (a.j_id=b.j_id  and a.lc_id > b.lc_id));
+
+ALTER TABLE letter_deb  ADD CONSTRAINT letter_deb_j_id_key UNIQUE(j_id );
+ALTER TABLE letter_cred  ADD CONSTRAINT letter_cred_j_id_key UNIQUE(j_id );
+
+
+update version set val=102;
+
+commit;
\ No newline at end of file



---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu