SV: [Phpgroupware-developers] Database buglist (fwd)

[Sigurd Nes]

> -------------------------------------------------------------------
> 
> Property
> 
> Within the property module database part there are tables and coloumns
> that
> are not named in english language -
> this should be avoided!

I agree - I am on to it...

> 
> There is NO template_id coloumn within the fm_wo_template_hours table:
> 
>   fm_wo_template.id=fm_wo_template_hours.template_id
> ./property/inc/class.sotemplate.inc.php
 

There is now (maybe not on the second that you checked out the module)

> 
> Within fm_wo_wrkorders there are NO coloumns property_id and
apartment_id
> :
> 
>   $sql= "fm_apartment,fm_wo_wrkorders where fm_apartment.property_id
=
> fm_wo_wrkorders.property_id and fm_apartment.apartment_id =
> fm_wo_wrkorders.apartment_id
> ./property/inc/class.soXport.inc.php
> 

Thanks !

> -------------------------------------------------------------------
> 
> P.S.: I am just working on a SQL style guide - that might help improve
the
> database for the case that you will accept it.
> 
I am very much looking forward to see it.

Sigurd