PHP Classes

File: SQL File

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

Contents

Class file image Download 
CREATE TABLE IF NOT EXISTS user_echomail_ignore_rules (
    id SERIAL PRIMARY KEY,
    user_id INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE,
    sender_name VARCHAR(255) NOT NULL,
    subject_contains VARCHAR(255) NOT NULL,
    created_at TIMESTAMPTZ NOT NULL DEFAULT (NOW() AT TIME ZONE 'UTC'),
    UNIQUE (user_id, sender_name, subject_contains)
);

CREATE INDEX IF NOT EXISTS idx_user_echomail_ignore_rules_user_id
    ON user_echomail_ignore_rules(user_id);