[Mapbender-dev] Mysql/mb_monitor: BLOB and TEXT columns cannot have DEFAULT values.

[Thomas Baschetti]

Hi,

while porting update_2.5.1_to_2.6rc1_pgsql_UTF-8.sql
to mysql i stumbled across the line

   ALTER TABLE mb_monitor ALTER COLUMN caps_diff SET DEFAULT ''::text;

this can't be ported, according to
http://dev.mysql.com/doc/refman/5.0/en/blob.html
because:
BLOB and TEXT columns cannot have DEFAULT values.

Do we need a default value in this context? Never used mb_monitor, so i 
don't know.

Bye
Thomas

-- 

Thomas Baschetti - Systemanalyse Geographische Informationssysteme
Hakenstraße 8D
49074 Osnabrück

Tel: 0541 25 91 90 | mobil 01577 189 25 91
E-Mail: info at thomas-baschetti.de
www.thomas-baschetti.de
Ust-IdNr.: DE264355072