PHP Classes

File: SQL File

Recommend this page to a friend!
  Packages of Matthew Asham   Binkterm PHP   database/migrations/v1.1.1_add_user_preferences.sql   Download  
File: database/migrations/v1.1.1_add_user_preferences.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: 1 month ago
Size: 429 bytes
 

Contents

Class file image Download 
-- Migration: 1.1.1 - Add user preferences
-- Created: 2025-08-25 06:45:00

-- Add email notification preferences for users
ALTER TABLE user_settings ADD COLUMN email_notifications BOOLEAN DEFAULT TRUE;

-- Add signature field for users
ALTER TABLE users ADD COLUMN signature TEXT;

-- Create index for faster user settings lookups
CREATE INDEX IF NOT EXISTS idx_user_settings_notifications ON user_settings(email_notifications);