PHP Classes

File: SQL File

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

Contents

Class file image Download 
-- v1.10.15.1: Widen MRC message columns that can contain pipe/MCI codes
--
-- BBS names (f2/from_site) and usernames (f1/from_user) may include pipe
-- colour codes, making the encoded string longer than the 30-char spec
-- display limit. Widen to 100 chars to accommodate real-world traffic.

ALTER TABLE mrc_messages
    ALTER COLUMN from_user TYPE VARCHAR(100),
    ALTER COLUMN from_site TYPE VARCHAR(100),
    ALTER COLUMN to_user   TYPE VARCHAR(100);

ALTER TABLE mrc_outbound
    ALTER COLUMN field1 TYPE VARCHAR(100),
    ALTER COLUMN field4 TYPE VARCHAR(100);