Overview
Comment: | Suppression table rapprochement, intégration dans la table journal |
---|---|
Downloads: | Tarball | ZIP archive | SQL archive |
Timelines: | family | ancestors | descendants | both | dev |
Files: | files | file ages | folders |
SHA1: |
9136b307eac0e43bc7a16e000be365d6 |
User & Date: | bohwaz on 2019-02-15 10:16:36 |
Other Links: | branch diff | manifest | tags |
Context
2019-02-15
| ||
15:14 | Ces fonctions ne sont pas utilisées check-in: 9d82c5edcb user: bohwaz tags: dev | |
10:16 | Suppression table rapprochement, intégration dans la table journal check-in: 9136b307ea user: bohwaz tags: dev | |
10:16 | Ajout configuration compta expert check-in: b65e46e08c user: bohwaz tags: dev | |
Changes
Modified src/include/data/0.10.0.sql from [254225a2e4] to [2f94b4a011].
1 2 3 4 5 6 7 8 9 10 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 | + + + - - - + + + + | ALTER TABLE compta_journal RENAME TO compta_journal_old; .read schema.sql INSERT INTO compta_journal (id, libelle, remarques, numero_piece, date, moyen_paiement, numero_cheque, id_exercice, id_auteur, id_categorie, id_projet) SELECT id, libelle, remarques, numero_piece, date, moyen_paiement, numero_cheque, id_exercice, id_auteur, id_categorie, id_projet FROM compta_journal_old; INSERT INTO compta_journal_ecritures (id_journal, compte, debit, credit, montant) SELECT id, compte_credit, 0, CAST(montant * 100 AS INT) FROM compta_journal_old; INSERT INTO compta_journal_ecritures (id_journal, compte, debit, credit, montant) SELECT id, compte_debit, CAST(montant * 100 AS INT), 0 FROM compta_journal_old; |
Modified src/include/data/schema.sql from [f849555ddc] to [75bcb1da76].
︙ | |||
344 345 346 347 348 349 350 | 344 345 346 347 348 349 350 351 352 353 354 355 356 357 | - - - - - - - - | ( signal TEXT NOT NULL, plugin TEXT NOT NULL REFERENCES plugins (id), callback TEXT NOT NULL, PRIMARY KEY (signal, plugin) ); |
︙ |