SV: [Phpgroupware-developers] sitemgr - setup

[Sigurd Nes]

I was referring to the latest /sitemgr/setup/tables_current.inc.php
(attatched) - I think both reserved fieldnames and datatypes causing
trouble for (any) databasesystems should be avoided.

Sigurd


> 
> Sigurd Nes (address@hidden) wrote*:
> >
> >Two comments on setup:
> >1) The name 'view' in the table 'phpgw_sitemgr_content' is a reserved
> >word for mssql database
> 
> use [view] in your mssql queries to escape the field name.
> 
> >
> >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
> >
> 
> I don't have sitemgr install, but I do code for MSSQL as well as
MySql.  I
> just "installed" sitemgr and I don't have either of the 2 tables you
talk
> about
> here, so I'm probably missing something.  Can you paste in the full
> definition of
> this "auto" datatype?  Or is that just part of the setup routine?  If
it's
> the
> later, "auto" means to make a field of type int with autoincrement,
the
> exact sql
> for that varies by database.
> 
> For MySql that would be:
> field_name int(11) NOT NULL auto_increment,
> 
> For MSSQL it's:
> field_name int Not Null Identity (1, 1),
> 
> where (1, 1) means start counting at 1 and increment by 1.
> 
> 
> 
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>

tables_current.inc.php
Description: Binary data