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 | ALTER TABLE compta_journal RENAME TO compta_journal_old; .read schema.sql 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; | > > > < < < > > > > | 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; DROP TABLE compta_journal_old; -- CREATE TABLE IF NOT EXISTS compta_comptes_soldes -- -- Soldes des comptes -- ( -- compte TEXT NOT NULL REFERENCES compta_comptes(id) ON DELETE CASCADE, -- exercice INTEGER NULL REFERENCES compta_exercices(id) ON DELETE CASCADE, -- solde INTEGER NOT NULL, -- PRIMARY KEY(compte, exercice) -- ); -- CREATE TRIGGER IF NOT EXISTS ON compta_journal_ecritures -- Transfert des rapprochements UPDATE compta_journal_lignes SET rapprochement = 1 WHERE id_journal IN (SELECT id_operation FROM compta_rapprochement); -- Suppression de la table rapprochements DROP TABLE compta_rapprochement; -- Ajout moyens de paiement INSERT OR IGNORE INTO compta_moyens_paiement (code, nom) VALUES ('AU', 'Autre'); INSERT OR IGNORE INTO compta_moyens_paiement (code, nom) VALUES ('AC', 'Autres chèques (vacances, cadeau, etc.)'); |
Modified src/include/data/schema.sql from [f849555ddc] to [75bcb1da76].
︙ | ︙ | |||
344 345 346 347 348 349 350 | ( signal TEXT NOT NULL, plugin TEXT NOT NULL REFERENCES plugins (id), callback TEXT NOT NULL, PRIMARY KEY (signal, plugin) ); | < < < < < < < < | 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) ); CREATE TABLE IF NOT EXISTS fichiers -- Données sur les fichiers ( id INTEGER NOT NULL PRIMARY KEY, nom TEXT NOT NULL, -- nom de fichier (par exemple image1234.jpeg) type TEXT NULL, -- Type MIME image INTEGER NOT NULL DEFAULT 0, -- 1 = image reconnue |
︙ | ︙ |