Subversion Repositories ALCASAR

Rev

Rev 2371 | 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
 -