Make schema more in line with the schema for other SQL servers

diff --git a/raddb/sql/mssql/schema.sql b/raddb/sql/mssql/schema.sql
index bf113a8..80c92d0 100644 (file)
--- a/raddb/sql/mssql/schema.sql
+++ b/raddb/sql/mssql/schema.sql
@@ -16,29 +16,29 @@
 /****** Object:  Table [radacct]    Script Date: 26.03.02 16:55:17 ******/
 CREATE TABLE [radacct] (
        [RadAcctId] [numeric](21, 0) IDENTITY (1, 1) NOT NULL ,
-       [AcctSessionId] [varchar] (64) NOT NULL ,
-       [AcctUniqueId] [varchar] (32) NOT NULL ,
-       [UserName] [varchar] (64) NOT NULL ,
-       [GroupName] [varchar] (64) NOT NULL ,
-       [Realm] [varchar] (64) NULL ,
-       [NASIPAddress] [varchar] (15) NOT NULL ,
+       [AcctSessionId] [varchar] (64) DEFAULT ('') FOR [AcctSessionId],
+       [AcctUniqueId] [varchar] (32) DEFAULT ('') FOR [AcctUniqueId],
+       [UserName] [varchar] (64) DEFAULT ('') FOR [UserName],
+       [GroupName] [varchar] (64) DEFAULT ('') FOR [GroupName],
+       [Realm] [varchar] (64) DEFAULT ('') FOR [Realm],
+       [NASIPAddress] [varchar] (15) DEFAULT ('') FOR [NASIPAddress],
        [NASPortId] [varchar] (15) NULL ,
        [NASPortType] [varchar] (32) NULL ,
        [AcctStartTime] [datetime] NOT NULL ,
        [AcctStopTime] [datetime] NOT NULL ,
        [AcctSessionTime] [bigint] NULL ,
        [AcctAuthentic] [varchar] (32) NULL ,
-       [ConnectInfo_start] [varchar] (32) NULL ,
-       [ConnectInfo_stop] [varchar] (32) NULL ,
+       [ConnectInfo_start] [varchar] (32) DEFAULT (null) FOR [ConnectInfo_start],
+       [ConnectInfo_stop] [varchar] (32) DEFAULT (null) FOR [ConnectInfo_stop],
        [AcctInputOctets] [bigint] NULL ,
        [AcctOutputOctets] [bigint] NULL ,
-       [CalledStationId] [varchar] (30) NOT NULL ,
-       [CallingStationId] [varchar] (30) NOT NULL ,
-       [AcctTerminateCause] [varchar] (32) NOT NULL ,
+       [CalledStationId] [varchar] (30) DEFAULT ('') FOR [CalledStationId],
+       [CallingStationId] [varchar] (30) DEFAULT ('') FOR [CallingStationId],
+       [AcctTerminateCause] [varchar] (32) DEFAULT ('') FOR [AcctTerminateCause],
        [ServiceType] [varchar] (32) NULL ,
        [FramedProtocol] [varchar] (32) NULL ,
-       [FramedIPAddress] [varchar] (15) NOT NULL ,
-       [XAscendSessionSvrKey] [varchar] (10) NOT NULL ,
+       [FramedIPAddress] [varchar] (15) DEFAULT ('') FOR [FramedIPAddress],
+       [XAscendSessionSvrKey] [varchar] (10) DEFAULT (null) FOR [XAscendSessionSvrKey],
        [AcctStartDelay] [int] NULL ,
        [AcctStopDelay] [int] NULL
 ) ON [PRIMARY]