[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r4358 - phpcompta/trunk/sql
From: |
phpcompta-dev |
Subject: |
[Phpcompta-dev] r4358 - phpcompta/trunk/sql |
Date: |
Tue, 15 Nov 2011 14:28:50 +0100 (CET) |
Author: danydb
Date: 2011-11-15 14:28:49 +0100 (Tue, 15 Nov 2011)
New Revision: 4358
Added:
phpcompta/trunk/sql/mode_paiement.sql
Log:
SQL Script: #447 mode de paiement par journaux -
Added: phpcompta/trunk/sql/mode_paiement.sql
===================================================================
--- phpcompta/trunk/sql/mode_paiement.sql (rev 0)
+++ phpcompta/trunk/sql/mode_paiement.sql 2011-11-15 13:28:49 UTC (rev
4358)
@@ -0,0 +1,13 @@
+-- Mode de paiement par journaux
+
+
+alter table mod_payment add jrn_def_id bigint;
+update mod_payment set jrn_def_id=2 where mp_type='VEN';
+update mod_payment set jrn_def_id=3 where mp_type='ACH';
+
+alter table mod_payment drop mp_type;
+
+
+alter table mod_payment add constraint foreign key (jrn_def_id) references
jrn_def(jrn_def_id);
+
+comment on column mod_payment.jrn_def_id is 'Ledger using this payment method';
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpcompta-dev] r4358 - phpcompta/trunk/sql,
phpcompta-dev <=