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
_______________________________________________
Phpcompta est un logiciel libre de comptabilité en ligne
(http://www.phpcompta.eu)
Phpcompta-dev mailing list
[email protected]
https://lists.nongnu.org/mailman/listinfo/phpcompta-dev
