History for src/include/data/schema.sql

2024-01-27
23:52
Deleted: Remove symbolic link for schema, should be easier to manage check-in: [fe3af2b646] user: bohwaz, branch: dev, size: 0
2022-11-08
00:25
Move migrations file: [57116110a2] check-in: [443e5220c8] user: bohwaz, branch: dev, size: 28 [annotate] [blame] [check-ins using] [diff]
2022-11-06
20:03
Do not allow all countries in charts, only allow supported countries, other countries won't have categorization of accounts file: [bb4040c594] check-in: [f8c8398d30] user: bohwaz, branch: next2, size: 28 [annotate] [blame] [check-ins using] [diff]
2022-10-29
20:13
Usuel -> Favori file: [978228af21] check-in: [7f8f514673] user: bohwaz, branch: accounts_refactor, size: 16402 [annotate] [blame] [check-ins using] [diff]
15:41
Finish project migration file: [e7490e8cfe] check-in: [54663039d5] user: bohwaz, branch: accounts_refactor, size: 16401 [annotate] [blame] [check-ins using] [diff]
13:42
Put analytical accounts in a separate table file: [c9b8916712] check-in: [3e0f1f992c] user: bohwaz, branch: accounts_refactor, size: 16374 [annotate] [blame] [check-ins using] [diff]
2022-07-31
00:26
Merge trunk into dev file: [784e47f46d] check-in: [9593a6f5f3] user: bohwaz, branch: dev, size: 17063 [annotate] [blame] [check-ins using] [diff]
2022-07-09
19:01
Merge with trunk file: [0336fc6ade] check-in: [6355b60f75] user: bohwaz, branch: templates, size: 16994 [annotate] [blame] [check-ins using] [diff]
2022-07-04
21:03
Implement custom key/secret for API access file: [ab4753bbe0] check-in: [90ef1eb8b1] user: bohwaz, branch: trunk, size: 15873 [annotate] [blame] [check-ins using] [diff]
2022-06-03
18:58
Merge latest trunk/emails to dev file: [e7bdc826ab] check-in: [42f4f0980c] user: bohwaz, branch: dev, size: 16715 [annotate] [blame] [check-ins using] [diff]
2022-05-30
20:52
Implement Skriv/Markdown emails + HTML + templates file: [0a44b3a9cc] check-in: [1cda3002a9] user: bohwaz, branch: emails, size: 15525 [annotate] [blame] [check-ins using] [diff]
16:18
Add ability to re-subscribe an unsubscribed address file: [89a0b562ed] check-in: [f81589e26c] user: bohwaz, branch: emails, size: 15522 [annotate] [blame] [check-ins using] [diff]
14:12
Fix missing commit Sync file with schema.sql file: [9f8fb4da93] check-in: [17e017e227] user: bohwaz, branch: emails, size: 15454 [annotate] [blame] [check-ins using] [diff]
2022-05-13
16:29
Merge with trunk file: [f967150e02] check-in: [19a0b12f84] user: bohwaz, branch: emails, size: 14218 [annotate] [blame] [check-ins using] [diff]
2022-04-05
14:10
Fix projects balances, fix [a8f507d0c033d6c8540797ea0f37e076781cc101] file: [ec0b389c55] check-in: [e50fecb397] user: bohwaz, branch: trunk, size: 15545 [annotate] [blame] [check-ins using] [diff]
2022-04-02
13:35
Delete old migrations that are now useless as we require 1.1.19 version at least file: [bbc725b503] check-in: [d5e2c38217] user: bohwaz, branch: dev, size: 15509 [annotate] [blame] [check-ins using] [diff]
2022-03-25
21:16
Fix bug in projects total view where balance was not added in multiple years, as reported by @zou file: [8475b86e68] check-in: [599540910a] user: bohwaz, branch: 1.1.23, size: 15534 [annotate] [blame] [check-ins using] [diff]
2022-03-18
01:45
Fix projects reports (thanks @zou) file: [aa8bd6edee] check-in: [c64ccd78ad] user: bohwaz, branch: 1.1.23, size: 15545 [annotate] [blame] [check-ins using] [diff]
2022-03-04
00:26
Try to always use debit - credit as the default case file: [97e41495b5] check-in: [89cbd2f12d] user: bohwaz, branch: trunk, size: 14318 [annotate] [blame] [check-ins using] [diff]
2022-03-03
18:59
Refactoring: remove getClosingSumsWithAccounts, use getAccountsBalance, fix graphs file: [1273891055] check-in: [a1ef61e8d7] user: bohwaz, branch: trunk, size: 14226 [annotate] [blame] [check-ins using] [diff]
17:47
Use a SQL view to get accounts balances, makes it much easier to create statement and balance sheet, also change trial balance to have only one column file: [25952763e8] check-in: [b2e7c79e5c] user: bohwaz, branch: trunk, size: 14159 [annotate] [blame] [check-ins using] [diff]
2022-02-07
22:54
Add ability to link a fee to a project, fix [fde0ebd9e938a3496720c1974dcd2d0f47275c5f] file: [305bf6fd27] check-in: [900e9cdb36] user: bohwaz, branch: trunk, size: 13161 [annotate] [blame] [check-ins using] [diff]
2021-12-21
01:54
Fix upgrade file: [2d18870586] check-in: [2074137b44] user: bohwaz, branch: templates, size: 13855 [annotate] [blame] [check-ins using] [diff]
01:32
Support assign and having in {{#sql}} sections, add view to get all accounts sums file: [eecb69cd6d] check-in: [3a621ae96b] user: bohwaz, branch: templates, size: 13841 [annotate] [blame] [check-ins using] [diff]
2021-12-19
19:54
Working user templates for transactions file: [1c4152517e] check-in: [5011716de7] user: bohwaz, branch: templates, size: 13346 [annotate] [blame] [check-ins using] [diff]
2021-11-14
23:10
Implement opt-out, and email verification file: [ee80d65ff4] check-in: [4e1c522d05] user: bohwaz, branch: emails, size: 16 [annotate] [blame] [check-ins using] [diff]
20:55
Implement email bounces and optout file: [19a2db773a] check-in: [8f9d4ac696] user: bohwaz, branch: emails, size: 13979 [annotate] [blame] [check-ins using] [diff]
2021-11-11
22:12
When there is no fee for the service, you can still subscribe a user to a service, it just doesn't have a fee file: [7141d7dc46] check-in: [404078a801] user: bohwaz, branch: trunk, size: 13081 [annotate] [blame] [check-ins using] [diff]
2021-11-09
01:04
Fix error in schema comment file: [1a42b63bce] check-in: [5b9ff6c8ad] user: bohwaz, branch: trunk, size: 13026 [annotate] [blame] [check-ins using] [diff]
2021-06-07
17:01
Fix issues with out of sync files and web pages, and duplicate URIs in web pages file: [ed688bac27] check-in: [cc5a0e1c1d] user: bohwaz, branch: trunk, size: 13026 [annotate] [blame] [check-ins using] [diff]
2021-06-02
21:27
Fix index reference file: [6ed1cd0bc8] check-in: [d41c517612] user: bohwaz, branch: trunk, size: 12958 [annotate] [blame] [check-ins using] [diff]
2021-06-01
21:37
Fix index file: [d61037a370] check-in: [db1d98471a] user: bohwaz, branch: trunk, size: 12954 [annotate] [blame] [check-ins using] [diff]
21:28
Fix reminders sent when that reminder was already sent before but since has been renewed file: [cce4f78c19] check-in: [85aaa801cb] user: bohwaz, branch: trunk, size: 12940 [annotate] [blame] [check-ins using] [diff]
2021-05-26
19:18
Fix: use hardlink to make sure that schema.sql has the same content as 1.1.0_schema.sql file: [26acbef5df] check-in: [0be405cc24] user: bohwaz, branch: trunk, size: 12757 [annotate] [blame] [check-ins using] [diff]
2021-03-31
13:32
Update possible issues file: [3456f2416e] check-in: [c1136e28a7] user: bohwaz, branch: dev, size: 12523 [annotate] [blame] [check-ins using] [diff]
2021-01-28
18:33
Refactor user categories file: [c56886c575] check-in: [a9a60352ba] user: bohwaz, branch: dev, size: 16 [annotate] [blame] [check-ins using] [diff]
2020-10-24
20:44
Added: Fix install issues file: [bdddcd8200] check-in: [fbf65537ea] user: bohwaz, branch: dev, size: 16 [annotate] [blame] [check-ins using]
2020-01-20
00:12
Renamed to src/include/data/1.0.0_schema.sql. Garder les anciens schémas SQL pour les migrations qui les utilisent check-in: [757810afbb] user: bohwaz, branch: dev, size: 0
2020-01-17
13:22
Ajout foreign key id_exercice sur les comptes file: [845385bf90] check-in: [9ac4c86495] user: bohwaz, branch: dev, size: 14551 [annotate] [blame] [check-ins using] [diff]
13:11
Transformation des ID de comptes en codes vers des ID auto-incrémentés, ouvrant la porte à avoir plusieurs comptes avec le même code file: [2dfcef7a46] check-in: [be95994256] user: bohwaz, branch: dev, size: 14535 [annotate] [blame] [check-ins using] [diff]
2019-12-17
16:02
Merge avec trunk file: [ed9b40a97d] check-in: [12a00549c1] user: bohwaz, branch: dev, size: 14538 [annotate] [blame] [check-ins using] [diff]
2019-12-03
17:40
Ajout vérification de mot de passe compromis avec l'API HaveIBeenPwned, et mot de passe minimum de 10 caractères au lieu de 8 file: [c8df01c2dd] check-in: [08954e712c] user: bohwaz, branch: trunk, size: 14532 [annotate] [blame] [check-ins using] [diff]
2019-02-19
16:55
Corrections mineures file: [d06d0af8c9] check-in: [acf4eb6f46] user: bohwaz, branch: dev, size: 14215 [annotate] [blame] [check-ins using] [diff]
2019-02-18
17:34
Ajout gestion des lignes dans les mouvements file: [67ca2845bf] check-in: [92219561f9] user: bohwaz, branch: dev, size: 14245 [annotate] [blame] [check-ins using] [diff]
2019-02-15
16:32
Renommer journal en mouvements file: [ae9748129e] check-in: [35af07a502] user: bohwaz, branch: dev, size: 14240 [annotate] [blame] [check-ins using] [diff]
10:16
Suppression table rapprochement, intégration dans la table journal file: [75bcb1da76] check-in: [9136b307ea] user: bohwaz, branch: dev, size: 14229 [annotate] [blame] [check-ins using] [diff]
2019-02-14
17:11
Débuts de la màj 0.10.0 file: [f849555ddc] check-in: [636b063ed2] user: bohwaz, branch: dev, size: 14613 [annotate] [blame] [check-ins using] [diff]
2019-01-29
12:41
Préparation pour refonte compta file: [899136fdb0] check-in: [4a7b339386] user: bohwaz, branch: dev, size: 14304 [annotate] [blame] [check-ins using] [diff]
2018-09-04
00:05
Recherche avancée fonctionnelle file: [efe750515a] check-in: [3ef9a80ec7] user: bohwaz, branch: dev, size: 14209 [annotate] [blame] [check-ins using] [diff]
2018-08-26
01:09
Table pour stocker les recherches sauvegardées file: [6e2d923853] check-in: [ed1a26374a] user: bohwaz, branch: dev, size: 14208 [annotate] [blame] [check-ins using] [diff]
2018-07-30
03:15
Possibilité de définir une condition d'affichage (en SQL) du plugin dans le menu, permettant de ne pas l'afficher à tous les membres file: [3637608e49] check-in: [a92458a4b5] user: bohwaz, branch: dev, size: 14606 [annotate] [blame] [check-ins using] [diff]
2018-07-26
13:07
Ajout queue d'envoi d'emails file: [21009b3120] check-in: [fa50a20dd3] user: bohwaz, branch: dev, size: 14576 [annotate] [blame] [check-ins using] [diff]
2018-07-12
00:33
Correction bug ref. #dcdw8rnr : suppression de membre impossible s'il a enregistré un rapprochement file: [4759146427] check-in: [0ee34d05e2] user: bohwaz, branch: dev, size: 13640 [annotate] [blame] [check-ins using] [diff]
2018-07-11
23:13
Déplacement de la gestion de catégories de membres vers la configuration file: [fb82ccd388] check-in: [9fa3b85730] user: bohwaz, branch: dev, size: 13621 [annotate] [blame] [check-ins using] [diff]
2018-05-10
11:18
Ajout clause ON DELETE SET NULL pour éviter les problèmes à la suppression d'une catégorie liée à une cotisation existante file: [80be656e5d] check-in: [d6b8553b10] user: bohwaz, branch: trunk, size: 13648 [annotate] [blame] [check-ins using] [diff]
2018-02-09
01:13
Correction typo file: [271bbe8e5a] check-in: [6ccbb8a8e2] user: bohwaz, branch: trunk, size: 13669 [annotate] [blame] [check-ins using] [diff]
2017-10-11
04:53
Gestion de projets (compta analytique) file: [1c0ae41b79] check-in: [f571ba3640] user: bohwaz, branch: dev, size: 13670 [annotate] [blame] [check-ins using] [diff]
2017-09-05
05:59
Corrections pour la fonctionnalité "remember me" file: [9abfe9b965] check-in: [864f2a278c] user: bohwaz, branch: dev, size: 13413 [annotate] [blame] [check-ins using] [diff]
2017-08-31
07:52
Utilisation des cascades pour nettoyer les foreign keys dans les tables (merci SQLite!) file: [666c258805] check-in: [2bcf7bd531] user: bohwaz, branch: dev, size: 13481 [annotate] [blame] [check-ins using] [diff]
2017-08-04
06:02
Corrige problèmes de mise à jour avec encore des dates bizarres pour le wiki, et l'ordre des colonnes qui a changé pour rappels_envoyes file: [bbc47a008e] check-in: [6274ecf443] user: bohwaz, branch: dev, size: 13329 [annotate] [blame] [check-ins using] [diff]
2017-08-03
04:21
Contrainte de date ici, pas de datetime file: [70b074d04f] check-in: [0a855a0a53] user: bohwaz, branch: dev, size: 13334 [annotate] [blame] [check-ins using] [diff]
2017-05-11
06:57
Déplacement de la création de table membres_sessions dans schema.sql, qui sera exécuté plus tard de toutes façons file: [68e5662649] check-in: [6b2fdac6d0] user: bohwaz, branch: dev, size: 13342 [annotate] [blame] [check-ins using] [diff]
2017-05-08
07:29
Ajout d'une contrainte sur les champs date pour empêcher d'y mettre des trucs qui ne sont pas des dates file: [917bee2324] check-in: [51a82e5421] user: bohwaz, branch: dev, size: 13023 [annotate] [blame] [check-ins using] [diff]
2017-01-26
00:19
Ajout authentification à double facteur (OTP) file: [6b49dd6beb] check-in: [633bea8e4a] user: bohwaz, branch: dev, size: 11263 [annotate] [blame] [check-ins using] [diff]
2016-05-31
05:38
Encore des soucis de foreign keys: il faut permettre de mettre id_auteur à NULL pour pouvoir supprimer des membres qui ont fait des rapprochements. file: [5ab5416f01] check-in: [795737be8a] user: bohwaz, branch: trunk, size: 11260 [annotate] [blame] [check-ins using] [diff]
2015-10-10
08:00
Oubli d'un champ dans la table rappel_envoyes, créant une erreur lors de la suppression de rappels, voici le patch qui corrige, merci à Nicolas pour le signalement. file: [255336d2fc] check-in: [cf1e84cda4] user: bohwaz, branch: trunk, size: 11248 [annotate] [blame] [check-ins using] [diff]
2015-04-14
16:56
synchro avec 0.7.0.sql file: [4641781372] check-in: [222ec93a45] user: bohwaz, branch: trunk, size: 11196 [annotate] [blame] [check-ins using] [diff]
2015-03-10
04:30
Upload de fichier fonctionnel file: [62a39221a8] check-in: [9ed4a2c5d0] user: bohwaz, branch: trunk, size: 11192 [annotate] [blame] [check-ins using] [diff]
2015-02-19
06:53
formattage rapprochement définitif file: [51479b06fb] check-in: [90f06b9e42] user: bohwaz, branch: trunk, size: 11277 [annotate] [blame] [check-ins using] [diff]
2015-02-18
19:16
Fonctionnalité rapprochement bancaire file: [7deb0e0ac2] check-in: [2fe1c3aa3e] user: bohwaz, branch: trunk, size: 11277 [annotate] [blame] [check-ins using] [diff]
2015-02-04
06:29
Débuts upload fichier file: [52605cc884] check-in: [00cedbfb6a] user: bohwaz, branch: trunk, size: 11273 [annotate] [blame] [check-ins using] [diff]
02:48
possibilité d'indiquer si un fichier est une image, ça simplifiera les galeries dans le wiki file: [55e42ab66a] check-in: [6ea3fe6cbb] user: bohwaz, branch: trunk, size: 11223 [annotate] [blame] [check-ins using] [diff]
2015-01-23
04:28
Débuts gestion de fichier, à partir d'un patch de @Got file: [290e3776d4] check-in: [f387548bd8] user: bohwaz, branch: trunk, size: 11074 [annotate] [blame] [check-ins using] [diff]
03:49
Utiliser des signaux génériques pour les boucles de squelettes, plutôt que des hooks spécifiques. Si besoin on mettra ensuite en place un cache statique des associations pour ne pas taper dans SQLite à chaque fois qu'on veut savoir si un signal est associé à qq chose. file: [aeb1567568] check-in: [10409a3353] user: bohwaz, branch: trunk, size: 9700 [annotate] [blame] [check-ins using] [diff]
2015-01-07
17:50
Débuts version 0.7.0 : possibilité pour les plugins de gérer des nouveaux types de boucles file: [1a0ccb3ec8] check-in: [d4f28a592b] user: bohwaz, branch: trunk, size: 9592 [annotate] [blame] [check-ins using] [diff]
2014-04-01
04:13
Gestion manuelle des rappels + Suivi des rappels file: [4b228fc114] check-in: [92b8bfe0a6] user: bohwaz, branch: trunk, size: 9480 [annotate] [blame] [check-ins using] [diff]
2014-03-31
21:13
Envoi automatisé des rappels file: [f478267547] check-in: [12e7f0652b] user: bohwaz, branch: trunk, size: 9505 [annotate] [blame] [check-ins using] [diff]
16:34
Associer les opérations comptables aux cotisations membres file: [f901a8e68f] check-in: [45c128dbf0] user: bohwaz, branch: trunk, size: 9495 [annotate] [blame] [check-ins using] [diff]
2014-02-14
01:13
suppression des dernières références aux transactions file: [4c09ae0edc] check-in: [cd375467bb] user: bohwaz, branch: trunk, size: 9422 [annotate] [blame] [check-ins using] [diff]
2014-01-30
17:15
Création de paiement file: [cfa66e914d] check-in: [131f09907f] user: bohwaz, branch: trunk, size: 9808 [annotate] [blame] [check-ins using] [diff]
2014-01-29
18:01
gestion des paiements membres file: [faa457c82d] check-in: [84a9e07510] user: bohwaz, branch: trunk, size: 9813 [annotate] [blame] [check-ins using] [diff]
2014-01-28
01:02
Description doit pouvoir être NULL file: [f7cfcca9bf] check-in: [4197205828] user: bohwaz, branch: trunk, size: 9780 [annotate] [blame] [check-ins using] [diff]
2014-01-27
17:06
Mise à jour 0.6 avec début transactions/activités/cotisations file: [c3ce62e89d] check-in: [4d7949c651] user: bohwaz, branch: trunk, size: 9784 [annotate] [blame] [check-ins using] [diff]
2014-01-15
19:23
Bases plugins file: [9d6aee840e] check-in: [da4017b724] user: bohwaz, branch: trunk, size: 9783 [annotate] [blame] [check-ins using] [diff]
18:23
Base plugins file: [a14bc60d26] check-in: [4dda85a74d] user: bohwaz, branch: trunk, size: 9742 [annotate] [blame] [check-ins using] [diff]
2014-01-08
17:22
Désactivation de compte file: [e3c3d57b96] check-in: [8f4579493e] user: bohwaz, branch: trunk, size: 9670 [annotate] [blame] [check-ins using] [diff]
2013-11-18
16:22
Correction schéma : les comptes ne sont pas des INT mais des TEXT (mais sqlite s'en fout, c'est juste pour rester logique) file: [a0b71d8c67] check-in: [19b35014ae] user: bohwaz, branch: trunk, size: 9591 [annotate] [blame] [check-ins using] [diff]
2013-07-27
12:20
Renamed include/data/schema.sql → src/include/data/schema.sql. Déplacement du code dans src/ file: [efb5c9c9f6] check-in: [5112ee854a] user: bohwaz, branch: trunk, size: 9548 [annotate] [blame] [check-ins using] [diff]