PHP Classes

File: SQL File

Recommend this page to a friend!
  Packages of Matthew Asham   Binkterm PHP   database/migrations/v1.4.5_add_netmail_threaded_view.sql   Download  
File: database/migrations/v1.4.5_add_netmail_threaded_view.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: 2 months ago
Size: 440 bytes
 

Contents

Class file image Download 
-- Migration: Add netmail threading preference
-- Version: 1.4.5
-- Description: Add netmail_threaded_view column for separate netmail threading preference

-- Add netmail threading preference column
ALTER TABLE user_settings 
ADD COLUMN IF NOT EXISTS netmail_threaded_view BOOLEAN DEFAULT FALSE;

-- Update existing records to have default values
UPDATE user_settings 
SET netmail_threaded_view = FALSE
WHERE netmail_threaded_view IS NULL;