[Phpgroupware-developers] Re: SV: sitemgr - setup

[totschnig . michael]

Sigurd makes two comments on sitemgr in HEAD CVS.

> 1) The name 'view' in the table 'phpgw_sitemgr_content' is a reserved
> word for mssql database

and Chris replies:

> do you have an all encompassing list of reserved words for all current and 
> future
> RDBMS's?  i didn't think so.  This is why each RDBMS provides a way to use 
> reserved
> words as field and table names, MySql's is `reserved` MSSQL is [reserved].

I do not fully understand what your reply implies, Chris. Does it
mean, that the problem Sigurd has when using sitemgr with MSSQL should
be resolved in class.db_mssql.inc.php and that there should be no
restrictions on any reserved words for phpgw applications?

> 2) The datatype "auto" for  'module_id' in table
> 'phpgw_sitemgr_active_modules' makes it difficult (mssql) to insert
> default values during install. - why not define the type as int and have
> a next_id function

You are right. This is a bug. In this context, auto does not make
sense, since in table phpgw_sitemgr_active_modules module_id actually
is a foreign key. Apparently this is no problem for MySQL. I will
correct this immediately. Thanks.

Michael