PHP Classes

File: SQL File

Recommend this page to a friend!
  Packages of Matthew Asham   Binkterm PHP   database/migrations/v1.10.6_add_echolist_unread_preference.sql   Download  
File: database/migrations/v1.10.6_add_echolist_unread_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: 447 bytes
 

Contents

Class file image Download 
-- Migration: v1.10.6 - Add echolist unread-only preference
-- Adds a persistent preference for "Show only areas with unread messages"
-- to match the existing echolist_subscribed_only preference.

ALTER TABLE user_settings
    ADD COLUMN IF NOT EXISTS echolist_unread_only BOOLEAN DEFAULT FALSE;

COMMENT ON COLUMN user_settings.echolist_unread_only IS
    'Whether to show only echoareas with unread messages in the echo list (default: false)';