Subversion Repositories ALCASAR

Rev

Rev 2371 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log

Rev 2371 Rev 2372
Line 1... Line -...
1
-- MySQL dump 10.15  Distrib 10.0.23-MariaDB, for Linux (x86_64)
-
 
2
--
-
 
3
-- Host: localhost    Database: radius
-
 
4
-- ------------------------------------------------------
-
 
5
-- Server version	10.0.23-MariaDB
-
 
6
 
-
 
7
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
2
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
3
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10
/*!40101 SET NAMES utf8 */;
4
/*!40101 SET NAMES utf8 */;
11
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
5
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
Line 14... Line 8...
14
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
8
/*!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' */;
9
/*!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 */;
10
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
 
11
 
18
--
12
--
19
-- Table structure for table `mtotacct`
-
 
20
--
-
 
21
 
-
 
22
DROP TABLE IF EXISTS `mtotacct`;
-
 
23
/*!40101 SET @saved_cs_client     = @@character_set_client */;
-
 
24
/*!40101 SET character_set_client = utf8 */;
-
 
25
CREATE TABLE `mtotacct` (
-
 
26
  `MTotAcctId` bigint(21) NOT NULL AUTO_INCREMENT,
-
 
27
  `UserName` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
-
 
28
  `AcctDate` date NOT NULL DEFAULT '0000-00-00',
-
 
29
  `ConnNum` bigint(12) DEFAULT NULL,
-
 
30
  `ConnTotDuration` bigint(12) DEFAULT NULL,
-
 
31
  `ConnMaxDuration` bigint(12) DEFAULT NULL,
-
 
32
  `ConnMinDuration` bigint(12) DEFAULT NULL,
-
 
33
  `InputOctets` bigint(12) DEFAULT NULL,
-
 
34
  `OutputOctets` bigint(12) DEFAULT NULL,
-
 
35
  `NASIPAddress` varchar(15) COLLATE utf8_bin DEFAULT NULL,
-
 
36
  PRIMARY KEY (`MTotAcctId`),
-
 
37
  KEY `UserName` (`UserName`),
-
 
38
  KEY `AcctDate` (`AcctDate`),
-
 
39
  KEY `UserOnDate` (`UserName`,`AcctDate`),
-
 
40
  KEY `NASIPAddress` (`NASIPAddress`)
-
 
41
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
 
42
/*!40101 SET character_set_client = @saved_cs_client */;
-
 
43
 
-
 
44
--
-
 
45
-- Table structure for table `radacct`
13
-- Table structure for table `radacct`
46
--
14
--
47
 
15
 
48
DROP TABLE IF EXISTS `radacct`;
16
DROP TABLE IF EXISTS `radacct`;
49
/*!40101 SET @saved_cs_client     = @@character_set_client */;
17
/*!40101 SET @saved_cs_client     = @@character_set_client */;
50
/*!40101 SET character_set_client = utf8 */;
18
/*!40101 SET character_set_client = utf8 */;
51
CREATE TABLE `radacct` (
19
CREATE TABLE `radacct` (
52
  `radacctid` bigint(21) NOT NULL AUTO_INCREMENT,
20
  `radacctid`            bigint(21)  NOT NULL AUTO_INCREMENT,
53
  `acctsessionid` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
21
  `acctsessionid`        varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
54
  `acctuniqueid` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
22
  `acctuniqueid`         varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
55
  `username` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
23
  `username`             varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
56
  `groupname` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
24
  `groupname`            varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
57
  `realm` varchar(64) COLLATE utf8_bin DEFAULT '',
25
  `realm`                varchar(64) COLLATE utf8_bin DEFAULT '',
58
  `nasipaddress` varchar(15) COLLATE utf8_bin NOT NULL DEFAULT '',
26
  `nasipaddress`         varchar(15) COLLATE utf8_bin NOT NULL DEFAULT '',
59
  `nasportid` varchar(15) COLLATE utf8_bin DEFAULT NULL,
27
  `nasportid`            varchar(15) COLLATE utf8_bin DEFAULT NULL,
60
  `nasporttype` varchar(32) COLLATE utf8_bin DEFAULT NULL,
28
  `nasporttype`          varchar(32) COLLATE utf8_bin DEFAULT NULL,
61
  `acctstarttime` datetime DEFAULT NULL,
29
  `acctstarttime`        datetime    DEFAULT NULL,
62
  `acctstoptime` datetime DEFAULT NULL,
30
  `acctstoptime`         datetime    DEFAULT NULL,
63
  `acctsessiontime` int(12) DEFAULT NULL,
31
  `acctsessiontime`      int(12)     DEFAULT NULL,
64
  `acctauthentic` varchar(32) COLLATE utf8_bin DEFAULT NULL,
32
  `acctauthentic`        varchar(32) COLLATE utf8_bin DEFAULT NULL,
65
  `connectinfo_start` varchar(50) COLLATE utf8_bin DEFAULT NULL,
33
  `connectinfo_start`    varchar(50) COLLATE utf8_bin DEFAULT NULL,
66
  `connectinfo_stop` varchar(50) COLLATE utf8_bin DEFAULT NULL,
34
  `connectinfo_stop`     varchar(50) COLLATE utf8_bin DEFAULT NULL,
67
  `acctinputoctets` bigint(20) DEFAULT NULL,
35
  `acctinputoctets`      bigint(20)  DEFAULT NULL,
68
  `acctoutputoctets` bigint(20) DEFAULT NULL,
36
  `acctoutputoctets`     bigint(20)  DEFAULT NULL,
69
  `calledstationid` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '',
37
  `calledstationid`      varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '',
70
  `callingstationid` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '',
38
  `callingstationid`     varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '',
71
  `acctterminatecause` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
39
  `acctterminatecause`   varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
72
  `servicetype` varchar(32) COLLATE utf8_bin DEFAULT NULL,
40
  `servicetype`          varchar(32) COLLATE utf8_bin DEFAULT NULL,
73
  `framedprotocol` varchar(32) COLLATE utf8_bin DEFAULT NULL,
41
  `framedprotocol`       varchar(32) COLLATE utf8_bin DEFAULT NULL,
74
  `framedipaddress` varchar(15) COLLATE utf8_bin NOT NULL DEFAULT '',
42
  `framedipaddress`      varchar(15) COLLATE utf8_bin NOT NULL DEFAULT '',
75
  `acctstartdelay` int(12) DEFAULT NULL,
43
  `acctstartdelay`       int(12)     DEFAULT NULL,
76
  `acctstopdelay` int(12) DEFAULT NULL,
44
  `acctstopdelay`        int(12)     DEFAULT NULL,
77
  `xascendsessionsvrkey` varchar(10) COLLATE utf8_bin DEFAULT NULL,
45
  `xascendsessionsvrkey` varchar(10) COLLATE utf8_bin DEFAULT NULL,
78
  PRIMARY KEY (`radacctid`),
46
  PRIMARY KEY (`radacctid`),
79
  KEY `username` (`username`),
47
  KEY `username` (`username`),
80
  KEY `framedipaddress` (`framedipaddress`),
48
  KEY `framedipaddress` (`framedipaddress`),
81
  KEY `acctsessionid` (`acctsessionid`),
49
  KEY `acctsessionid` (`acctsessionid`),
Line 93... Line 61...
93
 
61
 
94
DROP TABLE IF EXISTS `radcheck`;
62
DROP TABLE IF EXISTS `radcheck`;
95
/*!40101 SET @saved_cs_client     = @@character_set_client */;
63
/*!40101 SET @saved_cs_client     = @@character_set_client */;
96
/*!40101 SET character_set_client = utf8 */;
64
/*!40101 SET character_set_client = utf8 */;
97
CREATE TABLE `radcheck` (
65
CREATE TABLE `radcheck` (
98
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
66
  `id`        int(11)      unsigned NOT NULL AUTO_INCREMENT,
99
  `username` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
67
  `username`  varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
100
  `attribute` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
68
  `attribute` varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
101
  `op` char(2) COLLATE utf8_bin NOT NULL DEFAULT '==',
69
  `op`        char(2)      COLLATE utf8_bin NOT NULL DEFAULT '==',
102
  `value` varchar(253) COLLATE utf8_bin NOT NULL DEFAULT '',
70
  `value`     varchar(253) COLLATE utf8_bin NOT NULL DEFAULT '',
103
  PRIMARY KEY (`id`),
71
  PRIMARY KEY (`id`),
104
  KEY `username` (`username`(32))
72
  KEY `username` (`username`(32))
105
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
73
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
106
/*!40101 SET character_set_client = @saved_cs_client */;
74
/*!40101 SET character_set_client = @saved_cs_client */;
107
 
75
 
Line 111... Line 79...
111
 
79
 
112
DROP TABLE IF EXISTS `radgroupcheck`;
80
DROP TABLE IF EXISTS `radgroupcheck`;
113
/*!40101 SET @saved_cs_client     = @@character_set_client */;
81
/*!40101 SET @saved_cs_client     = @@character_set_client */;
114
/*!40101 SET character_set_client = utf8 */;
82
/*!40101 SET character_set_client = utf8 */;
115
CREATE TABLE `radgroupcheck` (
83
CREATE TABLE `radgroupcheck` (
116
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
84
  `id`        int(11)      unsigned NOT NULL AUTO_INCREMENT,
117
  `groupname` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
85
  `groupname` varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
118
  `attribute` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
86
  `attribute` varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
119
  `op` char(2) COLLATE utf8_bin NOT NULL DEFAULT '==',
87
  `op`        char(2)      COLLATE utf8_bin NOT NULL DEFAULT '==',
120
  `value` varchar(253) COLLATE utf8_bin NOT NULL DEFAULT '',
88
  `value`     varchar(253) COLLATE utf8_bin NOT NULL DEFAULT '',
121
  PRIMARY KEY (`id`),
89
  PRIMARY KEY (`id`),
122
  KEY `groupname` (`groupname`(32))
90
  KEY `groupname` (`groupname`(32))
123
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
91
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
124
/*!40101 SET character_set_client = @saved_cs_client */;
92
/*!40101 SET character_set_client = @saved_cs_client */;
125
 
93
 
126
--
94
--
127
-- Table structure for table `radgroupreply`
95
-- Table structure for table `radgroupreply`
128
--
96
--
129
 
97
 
130
DROP TABLE IF EXISTS `radgroupreply`;
98
DROP TABLE IF EXISTS `radgroupreply`;
131
/*!40101 SET @saved_cs_client     = @@character_set_client */;
99
/*!40101 SET @saved_cs_client     = @@character_set_client */;
132
/*!40101 SET character_set_client = utf8 */;
100
/*!40101 SET character_set_client = utf8 */;
133
CREATE TABLE `radgroupreply` (
101
CREATE TABLE `radgroupreply` (
134
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
102
  `id`        int(11)      unsigned NOT NULL AUTO_INCREMENT,
135
  `groupname` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
103
  `groupname` varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
136
  `attribute` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
104
  `attribute` varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
137
  `op` char(2) COLLATE utf8_bin NOT NULL DEFAULT '=',
105
  `op`        char(2)      COLLATE utf8_bin NOT NULL DEFAULT '=',
138
  `value` varchar(253) COLLATE utf8_bin NOT NULL DEFAULT '',
106
  `value`     varchar(253) COLLATE utf8_bin NOT NULL DEFAULT '',
139
  PRIMARY KEY (`id`),
107
  PRIMARY KEY (`id`),
140
  KEY `groupname` (`groupname`(32))
108
  KEY `groupname` (`groupname`(32))
141
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
109
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
142
/*!40101 SET character_set_client = @saved_cs_client */;
110
/*!40101 SET character_set_client = @saved_cs_client */;
143
 
111
 
144
--
112
--
145
-- Table structure for table `radpostauth`
-
 
146
--
-
 
147
 
-
 
148
DROP TABLE IF EXISTS `radpostauth`;
-
 
149
/*!40101 SET @saved_cs_client     = @@character_set_client */;
-
 
150
/*!40101 SET character_set_client = utf8 */;
-
 
151
CREATE TABLE `radpostauth` (
-
 
152
  `id` int(11) NOT NULL AUTO_INCREMENT,
-
 
153
  `username` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
-
 
154
  `reply` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
-
 
155
  `authdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
-
 
156
  PRIMARY KEY (`id`)
-
 
157
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
 
158
/*!40101 SET character_set_client = @saved_cs_client */;
-
 
159
 
-
 
160
--
-
 
161
-- Table structure for table `radreply`
113
-- Table structure for table `radreply`
162
--
114
--
163
 
115
 
164
DROP TABLE IF EXISTS `radreply`;
116
DROP TABLE IF EXISTS `radreply`;
165
/*!40101 SET @saved_cs_client     = @@character_set_client */;
117
/*!40101 SET @saved_cs_client     = @@character_set_client */;
166
/*!40101 SET character_set_client = utf8 */;
118
/*!40101 SET character_set_client = utf8 */;
167
CREATE TABLE `radreply` (
119
CREATE TABLE `radreply` (
168
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
120
  `id`        int(11)      unsigned NOT NULL AUTO_INCREMENT,
169
  `username` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
121
  `username`  varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
170
  `attribute` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
122
  `attribute` varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
171
  `op` char(2) COLLATE utf8_bin NOT NULL DEFAULT '=',
123
  `op`        char(2)      COLLATE utf8_bin NOT NULL DEFAULT '=',
172
  `value` varchar(253) COLLATE utf8_bin NOT NULL DEFAULT '',
124
  `value`     varchar(253) COLLATE utf8_bin NOT NULL DEFAULT '',
173
  PRIMARY KEY (`id`),
125
  PRIMARY KEY (`id`),
174
  KEY `username` (`username`(32))
126
  KEY `username` (`username`(32))
175
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
127
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
176
/*!40101 SET character_set_client = @saved_cs_client */;
128
/*!40101 SET character_set_client = @saved_cs_client */;
177
 
129
 
Line 181... Line 133...
181
 
133
 
182
DROP TABLE IF EXISTS `radusergroup`;
134
DROP TABLE IF EXISTS `radusergroup`;
183
/*!40101 SET @saved_cs_client     = @@character_set_client */;
135
/*!40101 SET @saved_cs_client     = @@character_set_client */;
184
/*!40101 SET character_set_client = utf8 */;
136
/*!40101 SET character_set_client = utf8 */;
185
CREATE TABLE `radusergroup` (
137
CREATE TABLE `radusergroup` (
186
  `username` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
138
  `username`  varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
187
  `groupname` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
139
  `groupname` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
188
  `priority` int(11) NOT NULL DEFAULT '1',
140
  `priority`  int(11)     NOT NULL DEFAULT '1',
189
  KEY `username` (`username`(32))
141
  KEY `username` (`username`(32))
190
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
142
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
191
/*!40101 SET character_set_client = @saved_cs_client */;
143
/*!40101 SET character_set_client = @saved_cs_client */;
192
 
144
 
193
--
145
--
-
 
146
-- Table structure for table `radpostauth`
-
 
147
--
-
 
148
 
-
 
149
DROP TABLE IF EXISTS `radpostauth`;
-
 
150
/*!40101 SET @saved_cs_client     = @@character_set_client */;
-
 
151
/*!40101 SET character_set_client = utf8 */;
-
 
152
CREATE TABLE `radpostauth` (
-
 
153
  `id`       int(11)     NOT NULL AUTO_INCREMENT,
-
 
154
  `username` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
-
 
155
  `pass`     varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
-
 
156
  `reply`    varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
-
 
157
  `authdate` timestamp   NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
-
 
158
  PRIMARY KEY (`id`)
-
 
159
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
 
160
/*!40101 SET character_set_client = @saved_cs_client */;
-
 
161
 
-
 
162
--
-
 
163
-- Table structure for table `mtotacct`
-
 
164
--
-
 
165
 
-
 
166
DROP TABLE IF EXISTS `mtotacct`;
-
 
167
/*!40101 SET @saved_cs_client     = @@character_set_client */;
-
 
168
/*!40101 SET character_set_client = utf8 */;
-
 
169
CREATE TABLE `mtotacct` (
-
 
170
  `mtotacctid`      bigint(21)  NOT NULL AUTO_INCREMENT,
-
 
171
  `username`        varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
-
 
172
  `acctdate`        date        NOT NULL DEFAULT '0000-00-00',
-
 
173
  `connnum`         bigint(12)  DEFAULT NULL,
-
 
174
  `conntotduration` bigint(12)  DEFAULT NULL,
-
 
175
  `connmaxduration` bigint(12)  DEFAULT NULL,
-
 
176
  `connminduration` bigint(12)  DEFAULT NULL,
-
 
177
  `inputoctets`     bigint(12)  DEFAULT NULL,
-
 
178
  `outputoctets`    bigint(12)  DEFAULT NULL,
-
 
179
  `nasipaddress`    varchar(15) COLLATE utf8_bin DEFAULT NULL,
-
 
180
  PRIMARY KEY (`mtotacctid`),
-
 
181
  KEY `username` (`username`),
-
 
182
  KEY `acctdate` (`acctdate`),
-
 
183
  KEY `UserOnDate` (`username`,`acctdate`),
-
 
184
  KEY `nasipaddress` (`nasipaddress`)
-
 
185
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
 
186
/*!40101 SET character_set_client = @saved_cs_client */;
-
 
187
 
-
 
188
--
194
-- Table structure for table `totacct`
189
-- Table structure for table `totacct`
195
--
190
--
196
 
191
 
197
DROP TABLE IF EXISTS `totacct`;
192
DROP TABLE IF EXISTS `totacct`;
198
/*!40101 SET @saved_cs_client     = @@character_set_client */;
193
/*!40101 SET @saved_cs_client     = @@character_set_client */;
199
/*!40101 SET character_set_client = utf8 */;
194
/*!40101 SET character_set_client = utf8 */;
200
CREATE TABLE `totacct` (
195
CREATE TABLE `totacct` (
201
  `TotAcctId` bigint(21) NOT NULL AUTO_INCREMENT,
196
  `totacctid`       bigint(21)  NOT NULL AUTO_INCREMENT,
202
  `UserName` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
197
  `username`        varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
203
  `AcctDate` date NOT NULL DEFAULT '0000-00-00',
198
  `acctdate`        date        NOT NULL DEFAULT '0000-00-00',
204
  `ConnNum` bigint(12) DEFAULT NULL,
199
  `connnum`         bigint(12)  DEFAULT NULL,
205
  `ConnTotDuration` bigint(12) DEFAULT NULL,
200
  `conntotduration` bigint(12)  DEFAULT NULL,
206
  `ConnMaxDuration` bigint(12) DEFAULT NULL,
201
  `connmaxduration` bigint(12)  DEFAULT NULL,
207
  `ConnMinDuration` bigint(12) DEFAULT NULL,
202
  `connminduration` bigint(12)  DEFAULT NULL,
208
  `InputOctets` bigint(12) DEFAULT NULL,
203
  `inputoctets`     bigint(12)  DEFAULT NULL,
209
  `OutputOctets` bigint(12) DEFAULT NULL,
204
  `outputoctets`    bigint(12)  DEFAULT NULL,
210
  `NASIPAddress` varchar(15) COLLATE utf8_bin DEFAULT NULL,
205
  `nasipaddress`    varchar(15) COLLATE utf8_bin DEFAULT NULL,
211
  PRIMARY KEY (`TotAcctId`),
206
  PRIMARY KEY (`totacctid`),
212
  KEY `UserName` (`UserName`),
207
  KEY `username` (`username`),
213
  KEY `AcctDate` (`AcctDate`),
208
  KEY `acctdate` (`acctdate`),
214
  KEY `UserOnDate` (`UserName`,`AcctDate`),
209
  KEY `UserOnDate` (`username`,`acctdate`),
215
  KEY `NASIPAddress` (`NASIPAddress`),
210
  KEY `nasipaddress` (`nasipaddress`),
216
  KEY `NASIPAddressOnDate` (`AcctDate`,`NASIPAddress`)
211
  KEY `nasipaddressOnDate` (`acctdate`,`nasipaddress`)
217
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
212
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
218
/*!40101 SET character_set_client = @saved_cs_client */;
213
/*!40101 SET character_set_client = @saved_cs_client */;
219
 
214
 
220
--
215
--
221
-- Table structure for table `userinfo`
216
-- Table structure for table `userinfo`
Line 223... Line 218...
223
 
218
 
224
DROP TABLE IF EXISTS `userinfo`;
219
DROP TABLE IF EXISTS `userinfo`;
225
/*!40101 SET @saved_cs_client     = @@character_set_client */;
220
/*!40101 SET @saved_cs_client     = @@character_set_client */;
226
/*!40101 SET character_set_client = utf8 */;
221
/*!40101 SET character_set_client = utf8 */;
227
CREATE TABLE `userinfo` (
222
CREATE TABLE `userinfo` (
228
  `id` int(10) NOT NULL AUTO_INCREMENT,
223
  `id`         int(10)      NOT NULL AUTO_INCREMENT,
229
  `UserName` varchar(64) COLLATE utf8_bin DEFAULT NULL,
224
  `username`   varchar(64)  COLLATE utf8_bin DEFAULT NULL,
230
  `Name` varchar(200) COLLATE utf8_bin DEFAULT NULL,
225
  `name`       varchar(200) COLLATE utf8_bin DEFAULT NULL,
231
  `Mail` varchar(200) COLLATE utf8_bin DEFAULT NULL,
226
  `mail`       varchar(200) COLLATE utf8_bin DEFAULT NULL,
232
  `Department` varchar(200) COLLATE utf8_bin DEFAULT NULL,
227
  `department` varchar(200) COLLATE utf8_bin DEFAULT NULL,
233
  `WorkPhone` varchar(200) COLLATE utf8_bin DEFAULT NULL,
228
  `workphone`  varchar(200) COLLATE utf8_bin DEFAULT NULL,
234
  `HomePhone` varchar(200) COLLATE utf8_bin DEFAULT NULL,
229
  `homephone`  varchar(200) COLLATE utf8_bin DEFAULT NULL,
235
  `Mobile` varchar(200) COLLATE utf8_bin DEFAULT NULL,
230
  `mobile`     varchar(200) COLLATE utf8_bin DEFAULT NULL,
236
  PRIMARY KEY (`id`),
231
  PRIMARY KEY (`id`),
237
  KEY `UserName` (`UserName`),
232
  KEY `username` (`username`),
238
  KEY `Department` (`Department`)
233
  KEY `department` (`department`)
239
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
234
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
240
/*!40101 SET character_set_client = @saved_cs_client */;
235
/*!40101 SET character_set_client = @saved_cs_client */;
241
 
236
 
242
 
237
 
243
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
238
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
Line 246... Line 241...
246
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
241
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
247
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
242
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
248
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
243
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
249
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
244
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
250
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
245
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
251
 
-
 
252
-- Dump completed on 2016-02-28 18:01:42
-