Upgrading instructions
SQL Commands
As Kokonotsuba is updated, the structure of the database may change. To adapt, run these commands starting from the date of your last upgrade to the latest version:
2025/08/24ALTER TABLE threads ADD COLUMN is_sticky BOOL DEFAULT FALSE;
2025/08/27ALTER TABLE posts ADD COLUMN poster_hash VARCHAR(255) DEFAULT NULL;
2025/09/18
Create deleted posts and files tables
2025/10/09
Alter file and deleted posts table
2025/10/16
Create capcodes table
2025/11/23
Move file information to the dedicated table
2026/01/02
Create anti-spam system table.
2026/01/04
Alter posts table to prevent multiple posts on the same board having the same post number.
2026/01/04
Add fulltext indexes to certain columns so they become searchable.
2026/02/01
Add soudane table.
2026/02/13
Add thread themes table.
2026/02/13
Create thread submission time table (for antiFlood).
Refactors
Occasionally, there are large changes to the code and some may require further instruction to successfully update. Particularly if it involves altering configurations.
2026/02/13
Update namespaces in configuration.