PHP Classes

File: SQL File

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

Contents

Class file image Download 
ALTER TABLE user_echomail_ignore_rules
    ADD COLUMN IF NOT EXISTS sender_address VARCHAR(255) NOT NULL DEFAULT '';

ALTER TABLE user_echomail_ignore_rules
    DROP CONSTRAINT IF EXISTS user_echomail_ignore_rules_user_id_sender_name_subject_cont_key;

ALTER TABLE user_echomail_ignore_rules
    DROP CONSTRAINT IF EXISTS user_echomail_ignore_rules_user_id_sender_name_subject_contains_key;

ALTER TABLE user_echomail_ignore_rules
    DROP CONSTRAINT IF EXISTS user_echomail_ignore_rules_sender_identity_unique;

DROP INDEX IF EXISTS user_echomail_ignore_rules_sender_identity_unique;

CREATE UNIQUE INDEX IF NOT EXISTS user_echomail_ignore_rules_sender_identity_unique
    ON user_echomail_ignore_rules(user_id, sender_name, sender_address, subject_contains);