dolibarr/htdocs/install/mysql/migration
VIAL-GOUTEYRON Quentin 5847c6b687
NEW : Add llx_socpeople.use_thirdparty_address column (#39499)
Data structure only, submitted standalone as asked by CONTRIBUTING.md, so it can be
reviewed and accepted before the code that uses it.

A contact can either carry its own address or reuse the address of its thirdparty.
Today the choice is guessed from the content of the address fields, which cannot tell
an empty address from a deliberate "use the thirdparty address". The new column stores
the choice explicitly.

  0     = use the address of the contact
  1     = use the address of the linked thirdparty
  NULL  = legacy resolution, the value for every existing record, so an existing
          alternative address stays independent from its thirdparty address.

Code side: #38118.
2026-08-19 02:41:55 +02:00
..
3.0.0-3.1.0.sql
3.1.0-3.2.0.sql
3.2.0-3.3.0.sql
3.3.0-3.4.0.sql
3.4.0-3.5.0.sql
3.5.0-3.6.0.sql
3.6.0-3.7.0.sql
3.7.0-3.8.0.sql
3.8.0-3.9.0.sql
3.9.0-4.0.0.sql
4.0.0-5.0.0.sql
5.0.0-6.0.0.sql
6.0.0-7.0.0.sql
7.0.0-8.0.0.sql
8.0.0-9.0.0.sql FIX : Fix SQL request for fix duplicate accounting account and remove wrong and obsolete SQL request who break the accounting account when we launch repair with multi-entities (#37430) 2026-03-12 13:57:57 +01:00
9.0.0-10.0.0.sql
10.0.0-11.0.0.sql
11.0.0-12.0.0.sql
12.0.0-13.0.0.sql
13.0.0-14.0.0.sql Removed exceptions 2026-05-22 10:26:25 +02:00
14.0.0-15.0.0.sql
15.0.0-16.0.0.sql
16.0.0-17.0.0.sql
17.0.0-18.0.0.sql Automated merge from 22.0 to 23.0 by tool pullmerge.sh 2026-06-19 03:49:56 +02:00
18.0.0-19.0.0.sql fix adherent table name (#38871) 2026-06-19 03:19:40 +02:00
19.0.0-20.0.0.sql fix adherent table name (#38872) 2026-06-19 04:00:36 +02:00
20.0.0-21.0.0.sql Automated merge from 21.0 to 22.0 by tool pullmerge.sh 2026-06-23 15:54:36 +02:00
21.0.0-22.0.0.sql Automated merge from 23.0 to develop 2026-07-15 02:06:09 +02:00
22.0.0-23.0.0.sql Automated merge from 23.0 to develop 2026-06-19 03:59:57 +02:00
23.0.0-24.0.0.sql Create migration script 24.0.0-25.0.0.sql 2026-07-27 17:27:42 +02:00
24.0.0-25.0.0.sql NEW : Add llx_socpeople.use_thirdparty_address column (#39499) 2026-08-19 02:41:55 +02:00
repair.sql Removed exceptions 2026-05-22 10:26:25 +02:00