PHP Classes

File: SQL File

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

Contents

Class file image Download 
-- Migration: 1.9.3.5 - Add security flag to track insecure sessions
-- Add received_insecure column to netmail table to track messages received
-- through insecure/unauthenticated binkp sessions

ALTER TABLE netmail
ADD COLUMN IF NOT EXISTS received_insecure BOOLEAN DEFAULT FALSE;

CREATE INDEX IF NOT EXISTS idx_netmail_received_insecure
ON netmail(received_insecure) WHERE received_insecure = TRUE;