⚡ Database Upgrade Guide: From SonikBB Version 0.xx to SonikBB 1.xx

👤 admin

🔴 Admin

✍️ It's not important where you are, it's important with who you are and how you live with them.

⏳ Last active: 15 Apr 2025 at 16:00

📅 Created: 03 Mar 2025 at 14:53

👀 Viewed: 53 times

✉️ Send Email

Database Upgrade Guide: From Version 0.xx to 1.xx

This guide provides the necessary SQL commands to upgrade your forum's database from version 0.xx to version 1.xx.

Steps for Database Update

ALTER TABLE `categories`
  MODIFY `cat_name` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  MODIFY `cat_desc` VARCHAR(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  MODIFY `def_icon` VARCHAR(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'images/forum.png';

-- Добавяне на `date_added_topic` в таблицата `topics`
ALTER TABLE `topics`
  ADD COLUMN `date_added_topic` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `topic_author`;

-- Добавяне на `date_added_comment` в таблицата `comments`
ALTER TABLE `comments`
  ADD COLUMN `date_added_comment` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `comment_author`;

ALTER TABLE `users`
  ADD COLUMN `created` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP;

ALTER TABLE `users`
  MODIFY `username` VARCHAR(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  MODIFY `password` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  MODIFY `signature` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'No Signature',
  MODIFY `avatar` VARCHAR(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'uploads/avatar-default.avif',
  MODIFY `last_login` DATETIME NOT NULL,
  MODIFY `email` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  MODIFY `created` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP;

ALTER TABLE `users`
  MODIFY COLUMN `password` VARCHAR(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  MODIFY COLUMN `signature` VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'No Signature' AFTER `password`;

File changes

Delete all files and folders except config.php and /uploads folder, modify /core/config.php with the setting from config.php

<?php

// Database settings
define('DB_HOST', 'localhost');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', 'password');
define('DB_NAME', 'database');

define('DB_CHARSET', 'utf8mb4');

// Other settings
define('WEBSITE', 'https://webleit.eu/forums');
define('WEBSITE_DESC', 'SonikBB Small and Lite Forum Written In PHP');
define('SITE_TITLE', 'WEBLEIT MAIN FORUMS');
define('EXCLUDED_FILES', array('.htaccess', 'config.php', 'README.md', 'hidden_file.zip', 'index.php', 'download_counts.txt'));

?>