PHP Classes

File: SQL File

Recommend this page to a friend!
  Packages of Matthew Asham   Binkterm PHP   database/migrations/v1.4.7_add_netmail_original_author_address.sql   Download  
File: database/migrations/v1.4.7_add_netmail_original_author_address.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: 1 month ago
Size: 378 bytes
 

Contents

Class file image Download 
-- Add original_author_address field to netmail table for MSGID-based routing
-- This enables more accurate reply addressing by using the address from MSGID kludge

ALTER TABLE netmail ADD COLUMN original_author_address VARCHAR(20);

-- Create index for better query performance
CREATE INDEX IF NOT EXISTS idx_netmail_original_author_address ON netmail(original_author_address);