PHP Classes

File: SQL File

Recommend this page to a friend!
  Packages of Matthew Asham   Binkterm PHP   database/migrations/v1.10.18_add_user_locale_preference.sql   Download  
File: database/migrations/v1.10.18_add_user_locale_preference.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Binkterm PHP
Bulletin board system based on the Web
Author: By
Last change:
Date: 5 days ago
Size: 329 bytes
 

Contents

Class file image Download 
-- Migration: 1.10.18 - Add locale preference to user settings
-- Created: 2026-03-05

ALTER TABLE user_settings
    ADD COLUMN IF NOT EXISTS locale VARCHAR(16) DEFAULT 'en';

UPDATE user_settings
SET locale = 'en'
WHERE locale IS NULL OR BTRIM(locale) = '';

ALTER TABLE user_settings
    ALTER COLUMN locale SET DEFAULT 'en';