mirror of
https://github.com/pi-hole/pi-hole.git
synced 2026-11-21 23:57:18 +00:00
The template is only used for a database created from scratch, so without a migration step the indexes, the `WITHOUT ROWID` tables and the corrected update triggers would reach new installations only. `20_to_21.sql` rebuilds the three junction tables and `info` through a temporary table - an `ALTER TABLE ... RENAME` would reparse the schema while the views still point at the table being replaced - adds the two group indexes and replaces the triggers that matched by content. The result has the same schema as a database created from the template. Signed-off-by: DL6ER <dl6er@dl6er.de> |
||
|---|---|---|
| .. | ||
| 1_to_2.sql | ||
| 2_to_3.sql | ||
| 3_to_4.sql | ||
| 4_to_5.sql | ||
| 5_to_6.sql | ||
| 6_to_7.sql | ||
| 7_to_8.sql | ||
| 8_to_9.sql | ||
| 9_to_10.sql | ||
| 10_to_11.sql | ||
| 11_to_12.sql | ||
| 12_to_13.sql | ||
| 13_to_14.sql | ||
| 14_to_15.sql | ||
| 15_to_16.sql | ||
| 16_to_17.sql | ||
| 17_to_18.sql | ||
| 18_to_19.sql | ||
| 19_to_20.sql | ||
| 20_to_21.sql | ||