PHP Classes

File: SQL File

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

Contents

Class file image Download 
-- Add soft delete columns for netmail
-- Allows sender and recipient to independently delete their copy
ALTER TABLE netmail ADD COLUMN IF NOT EXISTS deleted_by_sender BOOLEAN DEFAULT FALSE;
ALTER TABLE netmail ADD COLUMN IF NOT EXISTS deleted_by_recipient BOOLEAN DEFAULT FALSE;

-- Create index for efficient querying
CREATE INDEX IF NOT EXISTS idx_netmail_deleted_flags ON netmail(deleted_by_sender, deleted_by_recipient);