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

[Christoph Baudson]

Thomas Baschetti schrieb:
> 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.

Thanks for being so thorough. I guess we do not need a default here.

Thanks

Christoph

>
> Bye
> Thomas
>


-- 
********************************************
INTERGEO 2009
22.-24. September 2009 in Karlsruhe
Halle 1, Stand 1.417
www.intergeo.de
******************************************** 

_______________________________________

W h e r e G r o u p GmbH & Co. KG

Siemensstraße 8
53121 Bonn
Germany

Christoph Baudson
Anwendungsentwickler

Fon: +49 (0)228 / 90 90 38 - 15
Fax: +49 (0)228 / 90 90 38 - 11
christoph.baudson at wheregroup.com
www.wheregroup.com
Amtsgericht Bonn, HRA 6788
_______________________________________

Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Olaf Knopp, Peter Stamm
_______________________________________