PHP Classes

File: SQL File

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

Contents

Class file image Download 
-- Migration: 1.11.0.8 - Preserve raw imported message bytes for art rendering

ALTER TABLE netmail
    ADD COLUMN IF NOT EXISTS raw_message_bytes BYTEA NULL,
    ADD COLUMN IF NOT EXISTS message_charset VARCHAR(32) NULL,
    ADD COLUMN IF NOT EXISTS art_format VARCHAR(32) NULL;

ALTER TABLE echomail
    ADD COLUMN IF NOT EXISTS raw_message_bytes BYTEA NULL,
    ADD COLUMN IF NOT EXISTS message_charset VARCHAR(32) NULL,
    ADD COLUMN IF NOT EXISTS art_format VARCHAR(32) NULL;