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.