Re: Missing line in mssql-schema

Sebastian Heil wrote:

Hello everybody,

in the mssql-database-schema, there is one line missing.

For the table radacct, in the section "ALTER TABLE [radacct] WITH NOCHECK ADD", there is no information for the column groupname. So, if the accounting packet has no information about the groupname, the insert/update-statement will fail.

The following line in the schema.sql should fix this:

ALTER TABLE [radacct] WITH NOCHECK ADD ........ CONSTRAINT [DF_radacct_GroupName] DEFAULT ('') FOR [GroupName], ........

Maybe someone can verify this, and add this to the current development-tree?

I've added it, thanks. Alan DeKok.