PHP Classes

File: SQL File

Recommend this page to a friend!
  Packages of Matthew Asham   Binkterm PHP   database/migrations/v1.9.3.7_add_echolist_preference.sql   Download  
File: database/migrations/v1.9.3.7_add_echolist_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: 435 bytes
 

Contents

Class file image Download 
-- Migration: 1.9.3.7 - Add echolist filter preference to user_settings

-- Add column for echolist subscribed filter preference (default false = show all)
ALTER TABLE user_settings
ADD COLUMN IF NOT EXISTS echolist_subscribed_only BOOLEAN DEFAULT FALSE;

-- Add comment for documentation
COMMENT ON COLUMN user_settings.echolist_subscribed_only IS 'Whether to show only subscribed echoareas in /echolist (default: false - show all)';