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).
2026/03/17
Create notes table and remove notes from Deleted posts system
2026/03/29
Add blotter table
2026/03/30
Add timestamp/root index
2026/03/31
File hash banning table
2026/04/01
Add some boolean columns to ASS table
2026/04/20
Add fulltext indexes for various columns so general search queries are optimized
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.
2026/04/12
Backend/database rework and new features.
2026/04/26
Ad system