1 /***************************************************************************
6 * Database schema for MSSQL server *
9 * isql -S db_ip_addr -d db_name -U db_login -P db_passwd -i db_mssql.sql *
11 * Based on: db_mysql.sql (Mike Machado <mike@innercite.com>) *
13 * Dmitri Ageev <d_ageev@ortcc.ru> *
14 ***************************************************************************/
16 /****** Object: Table [radacct] Script Date: 26.03.02 16:55:17 ******/
17 CREATE TABLE [radacct] (
18 [RadAcctId] [numeric](21, 0) IDENTITY (1, 1) NOT NULL ,
19 [AcctSessionId] [varchar] (64) NOT NULL ,
20 [AcctUniqueId] [varchar] (32) NOT NULL ,
21 [UserName] [varchar] (64) NOT NULL ,
22 [GroupName] [varchar] (64) NOT NULL ,
23 [Realm] [varchar] (64) NULL ,
24 [NASIPAddress] [varchar] (15) NOT NULL ,
25 [NASPortId] [varchar] (15) NULL ,
26 [NASPortType] [varchar] (32) NULL ,
27 [AcctStartTime] [datetime] NOT NULL ,
28 [AcctStopTime] [datetime] NOT NULL ,
29 [AcctSessionTime] [bigint] NULL ,
30 [AcctAuthentic] [varchar] (32) NULL ,
31 [ConnectInfo_start] [varchar] (32) NULL ,
32 [ConnectInfo_stop] [varchar] (32) NULL ,
33 [AcctInputOctets] [bigint] NULL ,
34 [AcctOutputOctets] [bigint] NULL ,
35 [CalledStationId] [varchar] (30) NOT NULL ,
36 [CallingStationId] [varchar] (30) NOT NULL ,
37 [AcctTerminateCause] [varchar] (32) NOT NULL ,
38 [ServiceType] [varchar] (32) NULL ,
39 [FramedProtocol] [varchar] (32) NULL ,
40 [FramedIPAddress] [varchar] (15) NOT NULL ,
41 [XAscendSessionSvrKey] [varchar] (10) NOT NULL ,
42 [AcctStartDelay] [int] NULL ,
43 [AcctStopDelay] [int] NULL
47 /****** Object: Table [radcheck] Script Date: 26.03.02 16:55:17 ******/
48 CREATE TABLE [radcheck] (
49 [id] [int] IDENTITY (1, 1) NOT NULL ,
50 [UserName] [varchar] (64) NOT NULL ,
51 [Attribute] [varchar] (32) NOT NULL ,
52 [Value] [varchar] (253) NOT NULL ,
57 /****** Object: Table [radgroupcheck] Script Date: 26.03.02 16:55:17 ******/
58 CREATE TABLE [radgroupcheck] (
59 [id] [int] IDENTITY (1, 1) NOT NULL ,
60 [GroupName] [varchar] (64) NOT NULL ,
61 [Attribute] [varchar] (32) NOT NULL ,
62 [Value] [varchar] (253) NOT NULL ,
67 /****** Object: Table [radgroupreply] Script Date: 26.03.02 16:55:17 ******/
68 CREATE TABLE [radgroupreply] (
69 [id] [int] IDENTITY (1, 1) NOT NULL ,
70 [GroupName] [varchar] (64) NOT NULL ,
71 [Attribute] [varchar] (32) NOT NULL ,
72 [Value] [varchar] (253) NOT NULL ,
73 [op] [char] (2) NULL ,
78 /****** Object: Table [radreply] Script Date: 26.03.02 16:55:18 ******/
79 CREATE TABLE [radreply] (
80 [id] [int] IDENTITY (1, 1) NOT NULL ,
81 [UserName] [varchar] (64) NOT NULL ,
82 [Attribute] [varchar] (32) NOT NULL ,
83 [Value] [varchar] (253) NOT NULL ,
88 /****** Object: Table [radusergroup] Script Date: 26.03.02 16:55:18 ******/
89 CREATE TABLE [radusergroup] (
90 [id] [int] IDENTITY (1, 1) NOT NULL ,
91 [UserName] [varchar] (64) NOT NULL ,
92 [GroupName] [varchar] (64) NULL
96 /****** Object: Table [radusergroup] Script Date: 16.04.08 19:44:11 ******/
97 CREATE TABLE [radpostauth] (
98 [id] [int] IDENTITY (1, 1) NOT NULL ,
99 [userName] [varchar] (64) NOT NULL ,
100 [pass] [varchar] (64) NOT NULL ,
101 [reply] [varchar] (32) NOT NULL ,
102 [authdate] [datetime] NOT NULL
106 ALTER TABLE [radacct] WITH NOCHECK ADD
107 CONSTRAINT [DF_radacct_GroupName] DEFAULT ('') FOR [GroupName],
108 CONSTRAINT [DF_radacct_AcctSessionId] DEFAULT ('') FOR [AcctSessionId],
109 CONSTRAINT [DF_radacct_AcctUniqueId] DEFAULT ('') FOR [AcctUniqueId],
110 CONSTRAINT [DF_radacct_UserName] DEFAULT ('') FOR [UserName],
111 CONSTRAINT [DF_radacct_Realm] DEFAULT ('') FOR [Realm],
112 CONSTRAINT [DF_radacct_NASIPAddress] DEFAULT ('') FOR [NASIPAddress],
113 CONSTRAINT [DF_radacct_NASPortId] DEFAULT (null) FOR [NASPortId],
114 CONSTRAINT [DF_radacct_NASPortType] DEFAULT (null) FOR [NASPortType],
115 CONSTRAINT [DF_radacct_AcctStartTime] DEFAULT ('1900-01-01 00:00:00') FOR [AcctStartTime],
116 CONSTRAINT [DF_radacct_AcctStopTime] DEFAULT ('1900-01-01 00:00:00') FOR [AcctStopTime],
117 CONSTRAINT [DF_radacct_AcctSessionTime] DEFAULT (null) FOR [AcctSessionTime],
118 CONSTRAINT [DF_radacct_AcctAuthentic] DEFAULT (null) FOR [AcctAuthentic],
119 CONSTRAINT [DF_radacct_ConnectInfo_start] DEFAULT (null) FOR [ConnectInfo_start],
120 CONSTRAINT [DF_radacct_ConnectInfo_stop] DEFAULT (null) FOR [ConnectInfo_stop],
121 CONSTRAINT [DF_radacct_AcctInputOctets] DEFAULT (null) FOR [AcctInputOctets],
122 CONSTRAINT [DF_radacct_AcctOutputOctets] DEFAULT (null) FOR [AcctOutputOctets],
123 CONSTRAINT [DF_radacct_CalledStationId] DEFAULT ('') FOR [CalledStationId],
124 CONSTRAINT [DF_radacct_CallingStationId] DEFAULT ('') FOR [CallingStationId],
125 CONSTRAINT [DF_radacct_AcctTerminateCause] DEFAULT ('') FOR [AcctTerminateCause],
126 CONSTRAINT [DF_radacct_ServiceType] DEFAULT (null) FOR [ServiceType],
127 CONSTRAINT [DF_radacct_FramedProtocol] DEFAULT (null) FOR [FramedProtocol],
128 CONSTRAINT [DF_radacct_FramedIPAddress] DEFAULT ('') FOR [FramedIPAddress],
129 CONSTRAINT [DF_radacct_AcctStartDelay] DEFAULT (null) FOR [AcctStartDelay],
130 CONSTRAINT [DF_radacct_AcctStopDelay] DEFAULT (null) FOR [AcctStopDelay],
131 CONSTRAINT [PK_radacct] PRIMARY KEY NONCLUSTERED
137 ALTER TABLE [radcheck] WITH NOCHECK ADD
138 CONSTRAINT [DF_radcheck_UserName] DEFAULT ('') FOR [UserName],
139 CONSTRAINT [DF_radcheck_Attribute] DEFAULT ('') FOR [Attribute],
140 CONSTRAINT [DF_radcheck_Value] DEFAULT ('') FOR [Value],
141 CONSTRAINT [DF_radcheck_op] DEFAULT (null) FOR [op],
142 CONSTRAINT [PK_radcheck] PRIMARY KEY NONCLUSTERED
148 ALTER TABLE [radgroupcheck] WITH NOCHECK ADD
149 CONSTRAINT [DF_radgroupcheck_GroupName] DEFAULT ('') FOR [GroupName],
150 CONSTRAINT [DF_radgroupcheck_Attribute] DEFAULT ('') FOR [Attribute],
151 CONSTRAINT [DF_radgroupcheck_Value] DEFAULT ('') FOR [Value],
152 CONSTRAINT [DF_radgroupcheck_op] DEFAULT (null) FOR [op],
153 CONSTRAINT [PK_radgroupcheck] PRIMARY KEY NONCLUSTERED
159 ALTER TABLE [radgroupreply] WITH NOCHECK ADD
160 CONSTRAINT [DF_radgroupreply_GroupName] DEFAULT ('') FOR [GroupName],
161 CONSTRAINT [DF_radgroupreply_Attribute] DEFAULT ('') FOR [Attribute],
162 CONSTRAINT [DF_radgroupreply_Value] DEFAULT ('') FOR [Value],
163 CONSTRAINT [DF_radgroupreply_op] DEFAULT (null) FOR [op],
164 CONSTRAINT [DF_radgroupreply_prio] DEFAULT (0) FOR [prio],
165 CONSTRAINT [PK_radgroupreply] PRIMARY KEY NONCLUSTERED
171 ALTER TABLE [radreply] WITH NOCHECK ADD
172 CONSTRAINT [DF_radreply_UserName] DEFAULT ('') FOR [UserName],
173 CONSTRAINT [DF_radreply_Attribute] DEFAULT ('') FOR [Attribute],
174 CONSTRAINT [DF_radreply_Value] DEFAULT ('') FOR [Value],
175 CONSTRAINT [DF_radreply_op] DEFAULT (null) FOR [op],
176 CONSTRAINT [PK_radreply] PRIMARY KEY NONCLUSTERED
182 ALTER TABLE [radusergroup] WITH NOCHECK ADD
183 CONSTRAINT [DF_radusergroup_UserName] DEFAULT ('') FOR [UserName],
184 CONSTRAINT [DF_radusergroup_GroupName] DEFAULT ('') FOR [GroupName],
185 CONSTRAINT [PK_radusergroup] PRIMARY KEY NONCLUSTERED
191 ALTER TABLE [radpostauth] WITH NOCHECK ADD
192 CONSTRAINT [DF_radpostauth_userName] DEFAULT ('') FOR [userName],
193 CONSTRAINT [DF_radpostauth_pass] DEFAULT ('') FOR [pass],
194 CONSTRAINT [DF_radpostauth_reply] DEFAULT ('') FOR [reply],
195 CONSTRAINT [DF_radpostauth_authdate] DEFAULT (getdate()) FOR [authdate],
196 CONSTRAINT [PK_radpostauth] PRIMARY KEY NONCLUSTERED
202 CREATE INDEX [UserName] ON [radacct]([UserName]) ON [PRIMARY]
205 CREATE INDEX [FramedIPAddress] ON [radacct]([FramedIPAddress]) ON [PRIMARY]
208 CREATE INDEX [AcctSessionId] ON [radacct]([AcctSessionId]) ON [PRIMARY]
211 CREATE INDEX [AcctUniqueId] ON [radacct]([AcctUniqueId]) ON [PRIMARY]
214 CREATE INDEX [AcctStartTime] ON [radacct]([AcctStartTime]) ON [PRIMARY]
217 CREATE INDEX [AcctStopTime] ON [radacct]([AcctStopTime]) ON [PRIMARY]
220 CREATE INDEX [NASIPAddress] ON [radacct]([NASIPAddress]) ON [PRIMARY]
223 CREATE INDEX [UserName] ON [radcheck]([UserName]) ON [PRIMARY]
226 CREATE INDEX [GroupName] ON [radgroupcheck]([GroupName]) ON [PRIMARY]
229 CREATE INDEX [GroupName] ON [radgroupreply]([GroupName]) ON [PRIMARY]
232 CREATE INDEX [UserName] ON [radreply]([UserName]) ON [PRIMARY]
235 CREATE INDEX [UserName] ON [radusergroup]([UserName]) ON [PRIMARY]