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

[Sigurd Nes]

> 
> Sigurd Nes (address@hidden) wrote*:
> >
> >
> >I was referring to the latest /sitemgr/setup/tables_current.inc.php
> 
> "auto" is internal to phpgw, my example applies.


Yes I know this very well - why should I list all possibilities for
every RDBMS ? This is all taken care of by
'class.schema_proc_xxx.inc.php' 

> >(attatched) - I think both reserved fieldnames and datatypes causing
> >trouble for (any) databasesystems should be avoided.
> 
> 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].

It might be a way to build the ability to ask for reserved words into
class.db_xxx.inc.php ?

Sigurd



> 
> >
> >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
> >>
> >
> >
> 
> 
> 
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>