Re: r203 - in trunk: db db/procs db/tests libdm

["Ilya A. Volynets-Evenbakh" <ilya@total-knowledge.com>]

Alexey Parshin wrote:
> Define 'RI', please. (I guess tha's reference information).
Referential Integrity.
> Currently, it's done by parsing a time_zones.txt file that contains a 
> list of the time zones. This file is generated from 
> /usr/share/zoneinfo by a single command. I can include that command in 
> the _create_db.pl script if you want.
> The presentation of the time zines by groups reflects the most popular 
> way of defining 'em - as two combo boxes (groups and time zones for a 
> group). The query to build a full TZ name is a trivial join.
> The reference information is necessary to avoid any TZ misspelling on 
> the user input. At the very least, we can verify the spelling and 
> existance of the user TZ.
Main point is - we need to create zone list at installation time from 
the available timezones,
not store whole list in SVN.
> 2008/7/9 Ilya A. Volynets-Evenbakh <ilya@total-knowledge.com 
> <mailto:ilya@total-knowledge.com>>:
>
>     I am not sure we really need RI on time zones (could just store tz
>     string in user prefs),
>     but even if we do, tz table should just contain TZ strings, and
>     init of TZ table should
>     be done by a separate script, which would go through server's
>     zoneinfo structure, and
>     fill out the table with all available info.
>
>       Ilya.
>
>
>
>
> --
> Alexey Parshin,
> http://www.sptk.net