PHP Classes

File: SQL File

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

Contents

Class file image Download 
-- Migration v1.11.0.86: Add echomail_badge_mode user setting
--
-- Controls what the dashboard echomail badge counts:
--   'new'    (default) ? messages arrived since the user last visited an echomail page
--   'unread'           ? total messages above the user's last-read watermark (per area)

ALTER TABLE user_settings
    ADD COLUMN IF NOT EXISTS echomail_badge_mode VARCHAR(10) NOT NULL DEFAULT 'new';