[Phpgroupware-developers] sitemgr - setup

[Sigurd Nes]

Two comments on setup:
1) The name 'view' in the table 'phpgw_sitemgr_content' is a reserved
word for mssql database

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

example:
        function next_id($table='')
        {
                $GLOBALS['phpgw']->db->query("SELECT max(id) as maximum
FROM $table ",__LINE__,__FILE__);
                $GLOBALS['phpgw']->db->next_record();
                $next_id = $GLOBALS['phpgw']->db->f('maximum')+1;
                return "$next_id";
        }

Regards

Sigurd