1
/***************************************************************************
4
* Database schema for MSSQL server *
7
* isql -S db_ip_addr -d db_name -U db_login -P db_passwd -i db_mssql.sql *
9
* Based on: db_mysql.sql (Mike Machado <mike@innercite.com>) *
11
* Dmitri Ageev <d_ageev@ortcc.ru> *
12
***************************************************************************/
14
/****** Object: Table [radacct] Script Date: 26.03.02 16:55:17 ******/
15
CREATE TABLE [radacct] (
16
[RadAcctId] [numeric](21, 0) IDENTITY (1, 1) NOT NULL ,
17
[AcctSessionId] [varchar] (32) NOT NULL ,
18
[AcctUniqueId] [varchar] (32) NOT NULL ,
19
[UserName] [varchar] (64) NOT NULL ,
20
[Realm] [varchar] (64) NULL ,
21
[NASIPAddress] [varchar] (15) NOT NULL ,
22
[NASPortId] [varchar] (15) NULL ,
23
[NASPortType] [varchar] (32) NULL ,
24
[AcctStartTime] [datetime] NOT NULL ,
25
[AcctStopTime] [datetime] NOT NULL ,
26
[AcctSessionTime] [int] NULL ,
27
[AcctAuthentic] [varchar] (32) NULL ,
28
[ConnectInfo_start] [varchar] (32) NULL ,
29
[ConnectInfo_stop] [varchar] (32) NULL ,
30
[AcctInputOctets] [int] NULL ,
31
[AcctOutputOctets] [int] NULL ,
32
[CalledStationId] [varchar] (30) NOT NULL ,
33
[CallingStationId] [varchar] (30) NOT NULL ,
34
[AcctTerminateCause] [varchar] (32) NOT NULL ,
35
[ServiceType] [varchar] (32) NULL ,
36
[FramedProtocol] [varchar] (32) NULL ,
37
[FramedIPAddress] [varchar] (15) NOT NULL ,
38
[AcctStartDelay] [int] NULL ,
39
[AcctStopDelay] [int] NULL
43
/****** Object: Table [radcheck] Script Date: 26.03.02 16:55:17 ******/
44
CREATE TABLE [radcheck] (
45
[id] [int] IDENTITY (1, 1) NOT NULL ,
46
[UserName] [varchar] (64) NOT NULL ,
47
[Attribute] [varchar] (32) NOT NULL ,
48
[Value] [varchar] (253) NOT NULL ,
53
/****** Object: Table [radgroupcheck] Script Date: 26.03.02 16:55:17 ******/
54
CREATE TABLE [radgroupcheck] (
55
[id] [int] IDENTITY (1, 1) NOT NULL ,
56
[GroupName] [varchar] (64) NOT NULL ,
57
[Attribute] [varchar] (32) NOT NULL ,
58
[Value] [varchar] (253) NOT NULL ,
63
/****** Object: Table [radgroupreply] Script Date: 26.03.02 16:55:17 ******/
64
CREATE TABLE [radgroupreply] (
65
[id] [int] IDENTITY (1, 1) NOT NULL ,
66
[GroupName] [varchar] (64) NOT NULL ,
67
[Attribute] [varchar] (32) NOT NULL ,
68
[Value] [varchar] (253) NOT NULL ,
69
[op] [char] (2) NULL ,
74
/****** Object: Table [radreply] Script Date: 26.03.02 16:55:18 ******/
75
CREATE TABLE [radreply] (
76
[id] [int] IDENTITY (1, 1) NOT NULL ,
77
[UserName] [varchar] (64) NOT NULL ,
78
[Attribute] [varchar] (32) NOT NULL ,
79
[Value] [varchar] (253) NOT NULL ,
84
/****** Object: Table [usergroup] Script Date: 26.03.02 16:55:18 ******/
85
CREATE TABLE [usergroup] (
86
[id] [int] IDENTITY (1, 1) NOT NULL ,
87
[UserName] [varchar] (64) NOT NULL ,
88
[GroupName] [varchar] (64) NULL
92
ALTER TABLE [radacct] WITH NOCHECK ADD
93
CONSTRAINT [DF_radacct_AcctSessionId] DEFAULT ('') FOR [AcctSessionId],
94
CONSTRAINT [DF_radacct_AcctUniqueId] DEFAULT ('') FOR [AcctUniqueId],
95
CONSTRAINT [DF_radacct_UserName] DEFAULT ('') FOR [UserName],
96
CONSTRAINT [DF_radacct_Realm] DEFAULT ('') FOR [Realm],
97
CONSTRAINT [DF_radacct_NASIPAddress] DEFAULT ('') FOR [NASIPAddress],
98
CONSTRAINT [DF_radacct_NASPortId] DEFAULT (null) FOR [NASPortId],
99
CONSTRAINT [DF_radacct_NASPortType] DEFAULT (null) FOR [NASPortType],
100
CONSTRAINT [DF_radacct_AcctStartTime] DEFAULT ('1900-01-01 00:00:00') FOR [AcctStartTime],
101
CONSTRAINT [DF_radacct_AcctStopTime] DEFAULT ('1900-01-01 00:00:00') FOR [AcctStopTime],
102
CONSTRAINT [DF_radacct_AcctSessionTime] DEFAULT (null) FOR [AcctSessionTime],
103
CONSTRAINT [DF_radacct_AcctAuthentic] DEFAULT (null) FOR [AcctAuthentic],
104
CONSTRAINT [DF_radacct_ConnectInfo_start] DEFAULT (null) FOR [ConnectInfo_start],
105
CONSTRAINT [DF_radacct_ConnectInfo_stop] DEFAULT (null) FOR [ConnectInfo_stop],
106
CONSTRAINT [DF_radacct_AcctInputOctets] DEFAULT (null) FOR [AcctInputOctets],
107
CONSTRAINT [DF_radacct_AcctOutputOctets] DEFAULT (null) FOR [AcctOutputOctets],
108
CONSTRAINT [DF_radacct_CalledStationId] DEFAULT ('') FOR [CalledStationId],
109
CONSTRAINT [DF_radacct_CallingStationId] DEFAULT ('') FOR [CallingStationId],
110
CONSTRAINT [DF_radacct_AcctTerminateCause] DEFAULT ('') FOR [AcctTerminateCause],
111
CONSTRAINT [DF_radacct_ServiceType] DEFAULT (null) FOR [ServiceType],
112
CONSTRAINT [DF_radacct_FramedProtocol] DEFAULT (null) FOR [FramedProtocol],
113
CONSTRAINT [DF_radacct_FramedIPAddress] DEFAULT ('') FOR [FramedIPAddress],
114
CONSTRAINT [DF_radacct_AcctStartDelay] DEFAULT (null) FOR [AcctStartDelay],
115
CONSTRAINT [DF_radacct_AcctStopDelay] DEFAULT (null) FOR [AcctStopDelay],
116
CONSTRAINT [PK_radacct] PRIMARY KEY NONCLUSTERED
122
ALTER TABLE [radcheck] WITH NOCHECK ADD
123
CONSTRAINT [DF_radcheck_UserName] DEFAULT ('') FOR [UserName],
124
CONSTRAINT [DF_radcheck_Attribute] DEFAULT ('') FOR [Attribute],
125
CONSTRAINT [DF_radcheck_Value] DEFAULT ('') FOR [Value],
126
CONSTRAINT [DF_radcheck_op] DEFAULT (null) FOR [op],
127
CONSTRAINT [PK_radcheck] PRIMARY KEY NONCLUSTERED
133
ALTER TABLE [radgroupcheck] WITH NOCHECK ADD
134
CONSTRAINT [DF_radgroupcheck_GroupName] DEFAULT ('') FOR [GroupName],
135
CONSTRAINT [DF_radgroupcheck_Attribute] DEFAULT ('') FOR [Attribute],
136
CONSTRAINT [DF_radgroupcheck_Value] DEFAULT ('') FOR [Value],
137
CONSTRAINT [DF_radgroupcheck_op] DEFAULT (null) FOR [op],
138
CONSTRAINT [PK_radgroupcheck] PRIMARY KEY NONCLUSTERED
144
ALTER TABLE [radgroupreply] WITH NOCHECK ADD
145
CONSTRAINT [DF_radgroupreply_GroupName] DEFAULT ('') FOR [GroupName],
146
CONSTRAINT [DF_radgroupreply_Attribute] DEFAULT ('') FOR [Attribute],
147
CONSTRAINT [DF_radgroupreply_Value] DEFAULT ('') FOR [Value],
148
CONSTRAINT [DF_radgroupreply_op] DEFAULT (null) FOR [op],
149
CONSTRAINT [DF_radgroupreply_prio] DEFAULT (0) FOR [prio],
150
CONSTRAINT [PK_radgroupreply] PRIMARY KEY NONCLUSTERED
156
ALTER TABLE [radreply] WITH NOCHECK ADD
157
CONSTRAINT [DF_radreply_UserName] DEFAULT ('') FOR [UserName],
158
CONSTRAINT [DF_radreply_Attribute] DEFAULT ('') FOR [Attribute],
159
CONSTRAINT [DF_radreply_Value] DEFAULT ('') FOR [Value],
160
CONSTRAINT [DF_radreply_op] DEFAULT (null) FOR [op],
161
CONSTRAINT [PK_radreply] PRIMARY KEY NONCLUSTERED
167
ALTER TABLE [usergroup] WITH NOCHECK ADD
168
CONSTRAINT [DF_usergroup_UserName] DEFAULT ('') FOR [UserName],
169
CONSTRAINT [DF_usergroup_GroupName] DEFAULT ('') FOR [GroupName],
170
CONSTRAINT [PK_usergroup] PRIMARY KEY NONCLUSTERED
176
CREATE INDEX [UserName] ON [radacct]([UserName]) ON [PRIMARY]
179
CREATE INDEX [FramedIPAddress] ON [radacct]([FramedIPAddress]) ON [PRIMARY]
182
CREATE INDEX [AcctSessionId] ON [radacct]([AcctSessionId]) ON [PRIMARY]
185
CREATE INDEX [AcctUniqueId] ON [radacct]([AcctUniqueId]) ON [PRIMARY]
188
CREATE INDEX [AcctStartTime] ON [radacct]([AcctStartTime]) ON [PRIMARY]
191
CREATE INDEX [AcctStopTime] ON [radacct]([AcctStopTime]) ON [PRIMARY]
194
CREATE INDEX [NASIPAddress] ON [radacct]([NASIPAddress]) ON [PRIMARY]
197
CREATE INDEX [UserName] ON [radcheck]([UserName]) ON [PRIMARY]
200
CREATE INDEX [GroupName] ON [radgroupcheck]([GroupName]) ON [PRIMARY]
203
CREATE INDEX [GroupName] ON [radgroupreply]([GroupName]) ON [PRIMARY]
206
CREATE INDEX [UserName] ON [radreply]([UserName]) ON [PRIMARY]
209
CREATE INDEX [UserName] ON [usergroup]([UserName]) ON [PRIMARY]