History of the file that is called src/include/data/1.2.0_schema.sql at checkin 3ba8ecbcc00cecce

2024-03-14
16:06
Implement new stored shares file: [a7be02e03f] check-in: [53cf713641] user: bohwaz, branch: sharing, size: 22037 [annotate] [blame] [check-ins using] [diff]
2024-02-11
22:49
Refactor email address status file: [1057212392] check-in: [6104fadc92] user: bohwaz, branch: dev, size: 22313 [annotate] [blame] [check-ins using] [diff]
19:55
Rename Email entity to Address, continue work on refactoring email management file: [5939d4ab83] check-in: [f095ad6150] user: bohwaz, branch: dev, size: 22391 [annotate] [blame] [check-ins using] [diff]
2024-01-27
23:52
Renamed src/include/migrations/1.3/schema.sql → src/include/migrations/schema.sql. Remove symbolic link for schema, should be easier to manage file: [ebe077ae58] check-in: [fe3af2b646] user: bohwaz, branch: dev, size: 22129 [annotate] [blame] [check-ins using] [diff]
2024-01-20
16:34
Revert split of acc_transactions_users in two tables as it would make fiscal receipts SQL code much more complex file: [08334028d4] check-in: [20c66e6cb7] user: bohwaz, branch: dev, size: 22003 [annotate] [blame] [check-ins using] [diff]
2024-01-17
22:41
Rename table services_users to services_subscriptions, and split acc_transactions_users in two tables, one for users and one for subscriptions file: [b00a242280] check-in: [28a33baea9] user: bohwaz, branch: dev, size: 22345 [annotate] [blame] [check-ins using] [diff]
2024-01-02
18:01
Revert condition, to be easier to understand file: [789e6d39a6] check-in: [45781f1679] user: bohwaz, branch: dev, size: 21737 [annotate] [blame] [check-ins using] [diff]
17:42
Allow to exclude people from the past when creating a new reminder file: [4d9635e3da] check-in: [8310973994] user: bohwaz, branch: dev, size: 21740 [annotate] [blame] [check-ins using] [diff]
2023-12-20
21:32
Don't delete reminders history when deleting a reminder file: [5d2be4214e] check-in: [4fb212486e] user: bohwaz, branch: dev, size: 21563 [annotate] [blame] [check-ins using] [diff]
2023-12-19
14:46
Merge trunk into dev file: [768414860e] check-in: [21dfb2e461] user: bohwaz, branch: dev, size: 21566 [annotate] [blame] [check-ins using] [diff]
2023-12-15
13:14
Missing blank line file: [65f1fda055] check-in: [1bde1c22dc] user: bohwaz, branch: trunk, size: 21210 [annotate] [blame] [check-ins using] [diff]
2023-12-10
17:10
Merge trunk into dev file: [30fbb3d113] check-in: [4fae0e1e45] user: bohwaz, branch: dev, size: 21565 [annotate] [blame] [check-ins using] [diff]
2023-11-30
16:54
Change transactions relations to many-to-many so that a transaction can be linked to multiple transactions, either way file: [11a7cf703c] check-in: [575966b182] user: bohwaz, branch: related-transactions, size: 21209 [annotate] [blame] [check-ins using] [diff]
2023-10-22
19:14
Move list of optout addresses to a separate page file: [0a02bba0cd] check-in: [57c2fe250f] user: bohwaz, branch: dev, size: 21264 [annotate] [blame] [check-ins using] [diff]
13:52
Handle optouts specific to each mailing target file: [f3a54b719a] check-in: [d7745722b2] user: bohwaz, branch: dev, size: 21235 [annotate] [blame] [check-ins using] [diff]
2023-09-24
21:49
Flatten web directories for attachments, don't keep all folder hierarchy as it's too much work file: [cc2e6bf0f7] check-in: [67e3eab21e] user: bohwaz, branch: web-flatten, size: 20908 [annotate] [blame] [check-ins using] [diff]
2023-09-21
15:30
Change fields access to allow fine-grained access control file: [72bf471c1c] check-in: [f1e3a00037] user: bohwaz, branch: dev, size: 21184 [annotate] [blame] [check-ins using] [diff]
2023-08-28
13:18
Merge with dev file: [c5654cc51d] check-in: [4494033917] user: alinaar, branch: payment, size: 23134 [annotate] [blame] [check-ins using] [diff]
2023-08-17
02:20
Add index for file size, makes the SUM of all files 4 times quicker file: [5bf54f0c5b] check-in: [2a1ed85dbb] user: bohwaz, branch: dev, size: 21167 [annotate] [blame] [check-ins using] [diff]
02:12
Improve indexes and queries for listing transactions files file: [1afa29d343] check-in: [9874e56671] user: bohwaz, branch: dev, size: 21112 [annotate] [blame] [check-ins using] [diff]
2023-08-15
14:24
Implement web pages versioning file: [aeb8973dcd] check-in: [4f04b20bd1] user: bohwaz, branch: dev, size: 21036 [annotate] [blame] [check-ins using] [diff]
2023-08-12
16:03
Drop foreign key between web_pages and files file: [7ae6558c81] check-in: [07e2a35828] user: bohwaz, branch: dev, size: 20664 [annotate] [blame] [check-ins using] [diff]
2023-07-26
12:02
Missing indexes for user categories when using order by clause (as on default view of admin/users/index.php) file: [ac4076532b] check-in: [19b5d6dac8] user: alinaar, branch: dev, size: 20705 [annotate] [blame] [check-ins using] [diff]
2023-07-19
17:32
Merge dev branch file: [48b0ecb28a] check-in: [3aa5e09a30] user: alinaar, branch: payment, size: 22503 [annotate] [blame] [check-ins using] [diff]
2023-07-16
21:15
Payment status selection added to payment creation form + Transaction ID display on payment details page fixed + User binding to transaction fixed for payment creation file: [e60c0af705] check-in: [3c124f415e] user: alinaar, branch: payment, size: 20842 [annotate] [blame] [check-ins using] [diff]
20:17
Database indexes improved for payments file: [da8294f82a] check-in: [e53d2d23e6] user: alinaar, branch: payment, size: 20756 [annotate] [blame] [check-ins using] [diff]
2023-07-14
17:45
Payer deletion fixed (foreign key misconfiguration) file: [2fb53d79cd] check-in: [724a07456b] user: alinaar, branch: payment, size: 20612 [annotate] [blame] [check-ins using] [diff]
16:23
Fix transaction reference conflict between multiple providers using same payment reference + fix duplicate storage of transaction ID file: [d3a1dd1ca9] check-in: [10c8ec25f8] user: alinaar, branch: payment, size: 20574 [annotate] [blame] [check-ins using] [diff]
13:59
Payments author/payer/beneficiary/linked users reorganized + Providers users added (for transaction traceability) file: [563e03ca08] check-in: [af48174873] user: alinaar, branch: payment, size: 20491 [annotate] [blame] [check-ins using] [diff]
04:46
Only create triggers if they don't exist file: [102cf43252] check-in: [59a72e7d71] user: bohwaz, branch: dev, size: 20536 [annotate] [blame] [check-ins using] [diff]
2023-07-12
18:41
Missing index for transaction reference (e.g., payment ID) file: [82b65cfd47] check-in: [7cc8384945] user: bohwaz, branch: dev, size: 20494 [annotate] [blame] [check-ins using] [diff]
00:31
SQL schema quotes fixed file: [abd6da5ce8] check-in: [1da5a895b4] user: alinaar, branch: payment, size: 19988 [annotate] [blame] [check-ins using] [diff]
2023-07-11
20:58
Missing index for transaction reference (e.g., payment ID) file: [1c148c6c42] check-in: [58b5b6bd00] user: alinaar, branch: payment, size: 19988 [annotate] [blame] [check-ins using] [diff]
2023-07-08
09:42
Merge with #5d1b222c70 file: [c896f16761] check-in: [1ab0a84ab2] user: alinaar, branch: payment, size: 19901 [annotate] [blame] [check-ins using] [diff]
2023-07-07
01:38
Stop trying to maintain file path and name between local filesystem and database, it is just too much work and complexity, just store files using the hash of their ID file: [a7815b4452] check-in: [40ca76655c] user: bohwaz, branch: dev, size: 20407 [annotate] [blame] [check-ins using] [diff]
2023-07-06
16:45
Improve link between users/transactions and files file: [8669fc7adb] check-in: [763339ca91] user: bohwaz, branch: dev, size: 19837 [annotate] [blame] [check-ins using] [diff]
02:27
Use specific tables to link transactions and users to files, as joining on LIKE is just too slow file: [81aee05c00] check-in: [d6ad927e5a] user: bohwaz, branch: dev, size: 19542 [annotate] [blame] [check-ins using] [diff]
2023-07-05
20:12
Remove sync between web pages and index.txt files file: [3a54339b85] check-in: [5dd8cf0116] user: bohwaz, branch: dev, size: 18854 [annotate] [blame] [check-ins using] [diff]
2023-07-04
23:24
Refactor file storage to always store metadata in database making it easier to join data with other tables file: [b31adb6573] check-in: [2bc339ce69] user: bohwaz, branch: dev, size: 18702 [annotate] [blame] [check-ins using] [diff]
2023-06-27
21:31
author_name cannot be required file: [55e536edc8] check-in: [5d1b222c70] user: bohwaz, branch: payment, size: 19714 [annotate] [blame] [check-ins using] [diff]
12:12
Merge dev branch file: [dae3cd2a93] check-in: [a55661aa63] user: alinaar, branch: payment, size: 19905 [annotate] [blame] [check-ins using] [diff]
2023-06-24
20:45
Implement attachments to emails in modules file: [b6c00d7b60] check-in: [cdfd7ebd30] user: bohwaz, branch: dev, size: 18722 [annotate] [blame] [check-ins using] [diff]
2023-06-20
14:48
Add method to check user service existence + unique key constraint added to user service table file: [02b8ea4fe9] check-in: [a7983ee62d] user: alinaar, branch: payment, size: 19718 [annotate] [blame] [check-ins using] [diff]
2023-05-28
17:05
Merge dev branch file: [ada0a9d6e2] check-in: [e67d821296] user: alinaar, branch: payment, size: 19629 [annotate] [blame] [check-ins using] [diff]
2023-05-13
19:53
Payment's transaction implemented file: [c30d9fd741] check-in: [3a2039f0b5] user: alinaar, branch: payment, size: 20523 [annotate] [blame] [check-ins using] [diff]
2023-05-12
16:00
Payment details support added + code cleaning file: [04386da16a] check-in: [1e673fc4b4] user: alinaar, branch: payment, size: 20455 [annotate] [blame] [check-ins using] [diff]
2023-05-11
21:46
Standalone Payment support added file: [443905f571] check-in: [7b0344f2e9] user: alinaar, branch: payment, size: 20459 [annotate] [blame] [check-ins using] [diff]
21:16
Change whitespaces to tabs file: [f03a9de193] check-in: [6b7b7a4fd4] user: bohwaz, branch: dev, size: 18535 [annotate] [blame] [check-ins using] [diff]
2023-05-08
20:05
Allow to change the mailing sender name and address file: [114a7105ec] check-in: [15cff907d3] user: bohwaz, branch: dev, size: 19429 [annotate] [blame] [check-ins using] [diff]
2023-04-28
20:29
Refactor mailing creation, preview and sending file: [087090ad55] check-in: [9b5769ef8f] user: bohwaz, branch: dev, size: 19374 [annotate] [blame] [check-ins using] [diff]
2023-03-24
16:46
Move default receipt header/footer/CSS to the default "receipt" module file: [4a0d9aed5d] check-in: [d824e60c07] user: bohwaz, branch: dev, size: 18740 [annotate] [blame] [check-ins using] [diff]
2023-03-15
00:16
Move skeleton code to modules, move web skeletons inside a new "web" module file: [10e7016be7] check-in: [d57345262c] user: bohwaz, branch: dev, size: 18701 [annotate] [blame] [check-ins using] [diff]
2023-02-17
12:38
Rename 'url' to 'author_url' in module/plugin.ini, add "open" button in extensions list, better handle errors in plugin.ini file: [a912bda722] check-in: [f95cf4f0aa] user: bohwaz, branch: dev, size: 18665 [annotate] [blame] [check-ins using] [diff]
2023-02-14
22:29
Refactor plugins to have the same UI for plugins and modules, also modernize code of plugins management file: [c3e1dca3f5] check-in: [a8251477ac] user: bohwaz, branch: dev, size: 18651 [annotate] [blame] [check-ins using] [diff]
15:02
Use INI file instead of JSON for Module metadata (easier to use), allow to add home button and menu item without any code file: [aef26e336a] check-in: [366dbe8987] user: bohwaz, branch: dev, size: 18514 [annotate] [blame] [check-ins using] [diff]
2023-02-05
12:42
Remove code linked to official plugins, after 10 years this won't be implemented file: [5d55bc7389] check-in: [c2e2b50ff7] user: bohwaz, branch: dev, size: 18205 [annotate] [blame] [check-ins using] [diff]
2023-01-22
18:16
Fix SQL schema: there's a missing foreign key column file: [4232e4cc2b] check-in: [3364656fe4] user: bohwaz, branch: dev, size: 18273 [annotate] [blame] [check-ins using] [diff]
2023-01-04
16:47
Rename user forms to modules file: [b5f7dce8e6] check-in: [04eece5397] user: bohwaz, branch: dev, size: 18268 [annotate] [blame] [check-ins using] [diff]
2022-11-19
11:57
Implement locking of accounting transactions file: [5e01430e3a] check-in: [2519c199bf] user: bohwaz, branch: dev, size: 18288 [annotate] [blame] [check-ins using] [diff]
2022-11-17
23:41
Add date filter on accounting reports file: [0452cc5ed5] check-in: [9a298da40c] user: bohwaz, branch: trunk, size: 17229 [annotate] [blame] [check-ins using] [diff]
2022-11-08
14:26
Fix update of 1.3.0 file: [a73c5c454c] check-in: [a2b1e503a3] user: bohwaz, branch: dev, size: 18287 [annotate] [blame] [check-ins using] [diff]
00:42
Merge with trunk file: [e5107d635f] check-in: [3ca70608d9] user: bohwaz, branch: dev, size: 18296 [annotate] [blame] [check-ins using] [diff]
00:25
Renamed src/include/data/1.2.0_schema.sql → src/include/migrations/1.3/schema.sql. Move migrations file: [3c3e1f77d9] check-in: [443e5220c8] user: bohwaz, branch: dev, size: 17682 [annotate] [blame] [check-ins using] [diff]
2022-11-07
13:37
Always show other bookmarked accounts in grouped lists file: [da30dfe665] check-in: [6d2d1a3bbb] user: bohwaz, branch: next2, size: 16420 [annotate] [blame] [check-ins using] [diff]
2022-11-06
20:03
Renamed src/include/data/1.2.0_schema.sql → src/include/migrations/1.2/schema.sql. Do not allow all countries in charts, only allow supported countries, other countries won't have categorization of accounts file: [cd987f6e1b] check-in: [f8c8398d30] user: bohwaz, branch: next2, size: 16398 [annotate] [blame] [check-ins using] [diff]
00:59
Added: Add missing schema file: [978228af21] check-in: [dcffd10912] user: bohwaz, branch: accounts_refactor, size: 16402 [annotate] [blame] [check-ins using]
2022-10-25
21:48
Remove webdav properties and locks, we don't really need them, I think? file: [3c3e1f77d9] check-in: [26c6e91e04] user: bohwaz, branch: dev, size: 17682 [annotate] [blame] [check-ins using] [diff]
21:15
Add table to store WebDAV properties file: [725a5846e7] check-in: [b6f468aa2e] user: bohwaz, branch: dev, size: 18250 [annotate] [blame] [check-ins using] [diff]
2022-10-15
22:28
Move migration to separate file file: [09e830246b] check-in: [e06579be26] user: bohwaz, branch: dev, size: 18009 [annotate] [blame] [check-ins using] [diff]
2022-09-27
01:09
Allow multiple subscriptions to the same activity the same day, if the fee is different as well file: [32e70419b8] check-in: [b33097fa7a] user: bohwaz, branch: dev, size: 18186 [annotate] [blame] [check-ins using] [diff]
2022-09-15
14:56
Fix install process file: [9152febf43] check-in: [4118bdd695] user: bohwaz, branch: dev, size: 18178 [annotate] [blame] [check-ins using] [diff]
2022-09-06
16:27
Implement user log file: [9ad3141b79] check-in: [bfc0704c53] user: bohwaz, branch: dev, size: 18178 [annotate] [blame] [check-ins using] [diff]
02:29
Log entities changes file: [f2956189b4] check-in: [5ac7bca013] user: bohwaz, branch: dev, size: 18166 [annotate] [blame] [check-ins using] [diff]
2022-08-28
05:34
schema: Fix webdav locks table, change sessions table to have the primary key on the selector file: [99e642cb57] check-in: [bf01e0222f] user: bohwaz, branch: dev, size: 18148 [annotate] [blame] [check-ins using] [diff]
2022-08-27
20:13
Add missing changes from trunk lost when changing the symlink file: [5d015730f5] check-in: [9f4e4538a8] user: bohwaz, branch: dev, size: 18136 [annotate] [blame] [check-ins using] [diff]
2022-08-26
04:36
Start implementing WebDAV file: [8701148cc0] check-in: [d5f42076b0] user: bohwaz, branch: dev, size: 17708 [annotate] [blame] [check-ins using] [diff]
2022-08-20
20:25
Add membership card file: [d256401cc8] check-in: [bb7569e547] user: bohwaz, branch: dev, size: 17423 [annotate] [blame] [check-ins using] [diff]
2022-08-19
16:29
Allow to have multiple services from the same user linked to a transaction file: [19622609e1] check-in: [bf0e406ebc] user: bohwaz, branch: dev, size: 17383 [annotate] [blame] [check-ins using] [diff]
2022-08-15
00:08
Fix missing tables from templates branch, fix multiple issues with membres table being removed file: [206294d138] check-in: [ac78239b94] user: bohwaz, branch: dev, size: 17366 [annotate] [blame] [check-ins using] [diff]
2022-08-13
22:28
Add missing emails columns, add recipient_pgp_key column to emails_queue table file: [83d4c24ba9] check-in: [87acf30756] user: bohwaz, branch: dev, size: 16767 [annotate] [blame] [check-ins using] [diff]
12:04
Refactor password change form, customize for first password file: [18fc632152] check-in: [ff4431861d] user: bohwaz, branch: dev, size: 15528 [annotate] [blame] [check-ins using] [diff]
2022-07-31
03:21
Implement generated columns as dynamic user fields file: [9e6714862a] check-in: [3b12525b6e] user: bohwaz, branch: dev, size: 15528 [annotate] [blame] [check-ins using] [diff]
2022-03-16
02:03
Implement edit and adding new fields file: [bbc725b503] check-in: [c2c72edead] user: bohwaz, branch: dev, size: 15509 [annotate] [blame] [check-ins using] [diff]
2022-03-14
21:15
Improve Upgrade process if something fails file: [deb0df031b] check-in: [22b37319aa] user: bohwaz, branch: dev, size: 15493 [annotate] [blame] [check-ins using] [diff]
2022-01-10
20:08
Fix upgrade file: [6c2af0cde1] check-in: [4e37103dd8] user: bohwaz, branch: dev, size: 14336 [annotate] [blame] [check-ins using] [diff]
2022-01-02
18:28
Add ID to config_user_fields file: [4e47558368] check-in: [dcb692e174] user: bohwaz, branch: dev, size: 14294 [annotate] [blame] [check-ins using] [diff]
2021-12-04
02:38
Progress on migration of custom fields file: [04057102f4] check-in: [004b9a67f6] user: bohwaz, branch: dev, size: 14178 [annotate] [blame] [check-ins using] [diff]
2021-10-28
03:05
Rename Membres\Session class to Users\Session, and adapt to new DB schema file: [97ed5bad7c] check-in: [6c4430703c] user: bohwaz, branch: dev, size: 14142 [annotate] [blame] [check-ins using] [diff]
2021-10-11
01:19
Migrate user fields to entities (still not functional) file: [40fe01db9c] check-in: [f36db2fd2e] user: bohwaz, branch: dev, size: 14136 [annotate] [blame] [check-ins using] [diff]
2021-10-05
02:59
Start of implementation of 1.2.0 schema upgrade file: [517b1d4939] check-in: [38dcbce920] user: bohwaz, branch: dev, size: 13586 [annotate] [blame] [check-ins using] [diff]
02:02
Implement logging of actions (well just the logs data yet) file: [21b3465811] check-in: [f082d3c8b0] user: bohwaz, branch: dev, size: 13309 [annotate] [blame] [check-ins using] [diff]
2021-04-30
23:11
Rename tables and columns to english file: [684d261842] check-in: [3ba8ecbcc0] user: bohwaz, branch: dev, size: 12880 [annotate] [blame] [check-ins using] [diff]
22:40
Added: Schema for 1.2.0 release file: [26acbef5df] check-in: [50afc211c6] user: bohwaz, branch: dev, size: 12757 [annotate] [blame] [check-ins using]