Subversion Repositories ALCASAR

Rev

Go to most recent revision | Details | Last modification | View Log

Rev Author Line No. Line
1 root 1
-- MySQL dump 10.11
2
--
3
-- Host: localhost    Database: radius
4
-- ------------------------------------------------------
5
-- Server version	5.0.67
6
 
7
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10
/*!40101 SET NAMES utf8 */;
11
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12
/*!40103 SET TIME_ZONE='+00:00' */;
13
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
 
18
--
19
-- Current Database: `radius`
20
--
21
 
22
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `radius` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
23
 
24
USE `radius`;
25
 
26
--
27
-- Table structure for table `mtotacct`
28
--
29
 
30
DROP TABLE IF EXISTS `mtotacct`;
31
SET @saved_cs_client     = @@character_set_client;
32
SET character_set_client = utf8;
33
CREATE TABLE `mtotacct` (
34
  `MTotAcctId` bigint(21) NOT NULL auto_increment,
35
  `UserName` varchar(64) collate utf8_unicode_ci NOT NULL default '',
36
  `AcctDate` date NOT NULL default '0000-00-00',
37
  `ConnNum` bigint(12) default NULL,
38
  `ConnTotDuration` bigint(12) default NULL,
39
  `ConnMaxDuration` bigint(12) default NULL,
40
  `ConnMinDuration` bigint(12) default NULL,
41
  `InputOctets` bigint(12) default NULL,
42
  `OutputOctets` bigint(12) default NULL,
43
  `NASIPAddress` varchar(15) collate utf8_unicode_ci default NULL,
44
  PRIMARY KEY  (`MTotAcctId`),
45
  KEY `UserName` (`UserName`),
46
  KEY `AcctDate` (`AcctDate`),
47
  KEY `UserOnDate` (`UserName`,`AcctDate`),
48
  KEY `NASIPAddress` (`NASIPAddress`)
49
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
50
SET character_set_client = @saved_cs_client;
51
 
52
--
53
-- Dumping data for table `mtotacct`
54
--
55
 
56
LOCK TABLES `mtotacct` WRITE;
57
/*!40000 ALTER TABLE `mtotacct` DISABLE KEYS */;
58
/*!40000 ALTER TABLE `mtotacct` ENABLE KEYS */;
59
UNLOCK TABLES;
60
 
61
--
62
-- Table structure for table `radacct`
63
--
64
 
65
DROP TABLE IF EXISTS `radacct`;
66
SET @saved_cs_client     = @@character_set_client;
67
SET character_set_client = utf8;
68
CREATE TABLE `radacct` (
69
  `radacctid` bigint(21) NOT NULL auto_increment,
70
  `acctsessionid` varchar(32) collate utf8_unicode_ci NOT NULL default '',
71
  `acctuniqueid` varchar(32) collate utf8_unicode_ci NOT NULL default '',
72
  `username` varchar(64) collate utf8_unicode_ci NOT NULL default '',
73
  `groupname` varchar(64) collate utf8_unicode_ci NOT NULL default '',
74
  `realm` varchar(64) collate utf8_unicode_ci default '',
75
  `nasipaddress` varchar(15) collate utf8_unicode_ci NOT NULL default '',
76
  `nasportid` varchar(15) collate utf8_unicode_ci default NULL,
77
  `nasporttype` varchar(32) collate utf8_unicode_ci default NULL,
78
  `acctstarttime` datetime default NULL,
79
  `acctstoptime` datetime default NULL,
80
  `acctsessiontime` int(12) default NULL,
81
  `acctauthentic` varchar(32) collate utf8_unicode_ci default NULL,
82
  `connectinfo_start` varchar(50) collate utf8_unicode_ci default NULL,
83
  `connectinfo_stop` varchar(50) collate utf8_unicode_ci default NULL,
84
  `acctinputoctets` bigint(20) default NULL,
85
  `acctoutputoctets` bigint(20) default NULL,
86
  `calledstationid` varchar(50) collate utf8_unicode_ci NOT NULL default '',
87
  `callingstationid` varchar(50) collate utf8_unicode_ci NOT NULL default '',
88
  `acctterminatecause` varchar(32) collate utf8_unicode_ci NOT NULL default '',
89
  `servicetype` varchar(32) collate utf8_unicode_ci default NULL,
90
  `framedprotocol` varchar(32) collate utf8_unicode_ci default NULL,
91
  `framedipaddress` varchar(15) collate utf8_unicode_ci NOT NULL default '',
92
  `acctstartdelay` int(12) default NULL,
93
  `acctstopdelay` int(12) default NULL,
94
  `xascendsessionsvrkey` varchar(10) collate utf8_unicode_ci default NULL,
95
  PRIMARY KEY  (`radacctid`),
96
  KEY `username` (`username`),
97
  KEY `framedipaddress` (`framedipaddress`),
98
  KEY `acctsessionid` (`acctsessionid`),
99
  KEY `acctsessiontime` (`acctsessiontime`),
100
  KEY `acctuniqueid` (`acctuniqueid`),
101
  KEY `acctstarttime` (`acctstarttime`),
102
  KEY `acctstoptime` (`acctstoptime`),
103
  KEY `nasipaddress` (`nasipaddress`)
104
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
105
SET character_set_client = @saved_cs_client;
106
 
107
--
108
-- Dumping data for table `radacct`
109
--
110
 
111
LOCK TABLES `radacct` WRITE;
112
/*!40000 ALTER TABLE `radacct` DISABLE KEYS */;
113
/*!40000 ALTER TABLE `radacct` ENABLE KEYS */;
114
UNLOCK TABLES;
115
 
116
--
117
-- Table structure for table `radcheck`
118
--
119
 
120
DROP TABLE IF EXISTS `radcheck`;
121
SET @saved_cs_client     = @@character_set_client;
122
SET character_set_client = utf8;
123
CREATE TABLE `radcheck` (
124
  `id` int(11) unsigned NOT NULL auto_increment,
125
  `username` varchar(64) collate utf8_unicode_ci NOT NULL default '',
126
  `attribute` varchar(32) collate utf8_unicode_ci NOT NULL default '',
127
  `op` char(2) collate utf8_unicode_ci NOT NULL default '==',
128
  `value` varchar(253) collate utf8_unicode_ci NOT NULL default '',
129
  PRIMARY KEY  (`id`),
130
  KEY `username` (`username`(32))
131
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
132
SET character_set_client = @saved_cs_client;
133
 
134
--
135
-- Dumping data for table `radcheck`
136
--
137
 
138
LOCK TABLES `radcheck` WRITE;
139
/*!40000 ALTER TABLE `radcheck` DISABLE KEYS */;
140
/*!40000 ALTER TABLE `radcheck` ENABLE KEYS */;
141
UNLOCK TABLES;
142
 
143
--
144
-- Table structure for table `radgroupcheck`
145
--
146
 
147
DROP TABLE IF EXISTS `radgroupcheck`;
148
SET @saved_cs_client     = @@character_set_client;
149
SET character_set_client = utf8;
150
CREATE TABLE `radgroupcheck` (
151
  `id` int(11) unsigned NOT NULL auto_increment,
152
  `groupname` varchar(64) collate utf8_unicode_ci NOT NULL default '',
153
  `attribute` varchar(32) collate utf8_unicode_ci NOT NULL default '',
154
  `op` char(2) collate utf8_unicode_ci NOT NULL default '==',
155
  `value` varchar(253) collate utf8_unicode_ci NOT NULL default '',
156
  PRIMARY KEY  (`id`),
157
  KEY `groupname` (`groupname`(32))
158
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
159
SET character_set_client = @saved_cs_client;
160
 
161
--
162
-- Dumping data for table `radgroupcheck`
163
--
164
 
165
LOCK TABLES `radgroupcheck` WRITE;
166
/*!40000 ALTER TABLE `radgroupcheck` DISABLE KEYS */;
167
/*!40000 ALTER TABLE `radgroupcheck` ENABLE KEYS */;
168
UNLOCK TABLES;
169
 
170
--
171
-- Table structure for table `radgroupreply`
172
--
173
 
174
DROP TABLE IF EXISTS `radgroupreply`;
175
SET @saved_cs_client     = @@character_set_client;
176
SET character_set_client = utf8;
177
CREATE TABLE `radgroupreply` (
178
  `id` int(11) unsigned NOT NULL auto_increment,
179
  `groupname` varchar(64) collate utf8_unicode_ci NOT NULL default '',
180
  `attribute` varchar(32) collate utf8_unicode_ci NOT NULL default '',
181
  `op` char(2) collate utf8_unicode_ci NOT NULL default '=',
182
  `value` varchar(253) collate utf8_unicode_ci NOT NULL default '',
183
  PRIMARY KEY  (`id`),
184
  KEY `groupname` (`groupname`(32))
185
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
186
SET character_set_client = @saved_cs_client;
187
 
188
--
189
-- Dumping data for table `radgroupreply`
190
--
191
 
192
LOCK TABLES `radgroupreply` WRITE;
193
/*!40000 ALTER TABLE `radgroupreply` DISABLE KEYS */;
194
/*!40000 ALTER TABLE `radgroupreply` ENABLE KEYS */;
195
UNLOCK TABLES;
196
 
197
--
198
-- Table structure for table `radpostauth`
199
--
200
 
201
DROP TABLE IF EXISTS `radpostauth`;
202
SET @saved_cs_client     = @@character_set_client;
203
SET character_set_client = utf8;
204
CREATE TABLE `radpostauth` (
205
  `id` int(11) NOT NULL auto_increment,
206
  `username` varchar(64) collate utf8_unicode_ci NOT NULL default '',
207
  `reply` varchar(32) collate utf8_unicode_ci NOT NULL default '',
208
  `authdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
209
  PRIMARY KEY  (`id`)
210
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
211
SET character_set_client = @saved_cs_client;
212
 
213
--
214
-- Dumping data for table `radpostauth`
215
--
216
 
217
LOCK TABLES `radpostauth` WRITE;
218
/*!40000 ALTER TABLE `radpostauth` DISABLE KEYS */;
219
/*!40000 ALTER TABLE `radpostauth` ENABLE KEYS */;
220
UNLOCK TABLES;
221
 
222
--
223
-- Table structure for table `radreply`
224
--
225
 
226
DROP TABLE IF EXISTS `radreply`;
227
SET @saved_cs_client     = @@character_set_client;
228
SET character_set_client = utf8;
229
CREATE TABLE `radreply` (
230
  `id` int(11) unsigned NOT NULL auto_increment,
231
  `username` varchar(64) collate utf8_unicode_ci NOT NULL default '',
232
  `attribute` varchar(32) collate utf8_unicode_ci NOT NULL default '',
233
  `op` char(2) collate utf8_unicode_ci NOT NULL default '=',
234
  `value` varchar(253) collate utf8_unicode_ci NOT NULL default '',
235
  PRIMARY KEY  (`id`),
236
  KEY `username` (`username`(32))
237
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
238
SET character_set_client = @saved_cs_client;
239
 
240
--
241
-- Dumping data for table `radreply`
242
--
243
 
244
LOCK TABLES `radreply` WRITE;
245
/*!40000 ALTER TABLE `radreply` DISABLE KEYS */;
246
/*!40000 ALTER TABLE `radreply` ENABLE KEYS */;
247
UNLOCK TABLES;
248
 
249
--
250
-- Table structure for table `radusergroup`
251
--
252
 
253
DROP TABLE IF EXISTS `radusergroup`;
254
SET @saved_cs_client     = @@character_set_client;
255
SET character_set_client = utf8;
256
CREATE TABLE `radusergroup` (
257
  `username` varchar(64) collate utf8_unicode_ci NOT NULL default '',
258
  `groupname` varchar(64) collate utf8_unicode_ci NOT NULL default '',
259
  `priority` int(11) NOT NULL default '1',
260
  KEY `username` (`username`(32))
261
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
262
SET character_set_client = @saved_cs_client;
263
 
264
--
265
-- Dumping data for table `radusergroup`
266
--
267
 
268
LOCK TABLES `radusergroup` WRITE;
269
/*!40000 ALTER TABLE `radusergroup` DISABLE KEYS */;
270
/*!40000 ALTER TABLE `radusergroup` ENABLE KEYS */;
271
UNLOCK TABLES;
272
 
273
--
274
-- Table structure for table `totacct`
275
--
276
 
277
DROP TABLE IF EXISTS `totacct`;
278
SET @saved_cs_client     = @@character_set_client;
279
SET character_set_client = utf8;
280
CREATE TABLE `totacct` (
281
  `TotAcctId` bigint(21) NOT NULL auto_increment,
282
  `UserName` varchar(64) collate utf8_unicode_ci NOT NULL default '',
283
  `AcctDate` date NOT NULL default '0000-00-00',
284
  `ConnNum` bigint(12) default NULL,
285
  `ConnTotDuration` bigint(12) default NULL,
286
  `ConnMaxDuration` bigint(12) default NULL,
287
  `ConnMinDuration` bigint(12) default NULL,
288
  `InputOctets` bigint(12) default NULL,
289
  `OutputOctets` bigint(12) default NULL,
290
  `NASIPAddress` varchar(15) collate utf8_unicode_ci default NULL,
291
  PRIMARY KEY  (`TotAcctId`),
292
  KEY `UserName` (`UserName`),
293
  KEY `AcctDate` (`AcctDate`),
294
  KEY `UserOnDate` (`UserName`,`AcctDate`),
295
  KEY `NASIPAddress` (`NASIPAddress`),
296
  KEY `NASIPAddressOnDate` (`AcctDate`,`NASIPAddress`)
297
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
298
SET character_set_client = @saved_cs_client;
299
 
300
--
301
-- Dumping data for table `totacct`
302
--
303
 
304
LOCK TABLES `totacct` WRITE;
305
/*!40000 ALTER TABLE `totacct` DISABLE KEYS */;
306
/*!40000 ALTER TABLE `totacct` ENABLE KEYS */;
307
UNLOCK TABLES;
308
 
309
--
310
-- Table structure for table `userinfo`
311
--
312
 
313
DROP TABLE IF EXISTS `userinfo`;
314
SET @saved_cs_client     = @@character_set_client;
315
SET character_set_client = utf8;
316
CREATE TABLE `userinfo` (
317
  `id` int(10) NOT NULL auto_increment,
318
  `UserName` varchar(30) collate utf8_unicode_ci default NULL,
319
  `Name` varchar(200) collate utf8_unicode_ci default NULL,
320
  `Mail` varchar(200) collate utf8_unicode_ci default NULL,
321
  `Department` varchar(200) collate utf8_unicode_ci default NULL,
322
  `WorkPhone` varchar(200) collate utf8_unicode_ci default NULL,
323
  `HomePhone` varchar(200) collate utf8_unicode_ci default NULL,
324
  `Mobile` varchar(200) collate utf8_unicode_ci default NULL,
325
  PRIMARY KEY  (`id`),
326
  KEY `UserName` (`UserName`),
327
  KEY `Department` (`Department`)
328
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
329
SET character_set_client = @saved_cs_client;
330
 
331
--
332
-- Dumping data for table `userinfo`
333
--
334
 
335
LOCK TABLES `userinfo` WRITE;
336
/*!40000 ALTER TABLE `userinfo` DISABLE KEYS */;
337
/*!40000 ALTER TABLE `userinfo` ENABLE KEYS */;
338
UNLOCK TABLES;
339
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
340
 
341
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
342
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
343
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
344
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
345
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
346
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
347
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
348
 
349
-- Dump completed on 2009-01-01 21:20:42