[cvs] commit: ansel/scripts/sql ansel.sql

[Michael Rubinsky]

Quoting "Jan Schneider" <jan at horde.org>:

> jan         2008-06-06 06:46:13 EDT
>
>   Modified files:
>     scripts/sql          ansel.sql
>   Log:
>   attribute_category may of course be empty, if not specifying a category.

The NOT NULL DEFAULT '' was intentional:

1) An empty value is considered 'Unfiled' - When saving a category of  
Unfiled, the empty string is saved since that's the value the HTML  
form returns, which is different than NULL when querying with DISTINCT  
  so the grouping code breaks.

2) Oracle doesn't differentiate between NULL and empty string, this  
simplifies keeping the queries Oracle compatible.

-- 
Thanks
Mike

"Time just hates me, that's why it made me an adult." - Josh Joplin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: PGP Digital Signature
Url : http://lists.horde.org/archives/cvs/attachments/20080606/6dc97144/attachment.bin