Subversion Repositories ALCASAR

Rev

Rev 2371 | Details | Compare with Previous | Last modification | View Log

Rev Author Line No. Line
1800 richard 1 
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2 
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
3 
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
4 
/*!40101 SET NAMES utf8 */;
5 
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
6 
/*!40103 SET TIME_ZONE='+00:00' */;
7 
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
8 
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
9 
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
10 
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
11 
 
12 
--
13 
-- Table structure for table `radacct`
14 
--
15 
 
16 
DROP TABLE IF EXISTS `radacct`;
17 
/*!40101 SET @saved_cs_client     = @@character_set_client */;
18 
/*!40101 SET character_set_client = utf8 */;
19 
CREATE TABLE `radacct` (
2372 tom.houday 20 
  `radacctid`            bigint(21)  NOT NULL AUTO_INCREMENT,
21 
  `acctsessionid`        varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
22 
  `acctuniqueid`         varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
23 
  `username`             varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
24 
  `groupname`            varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
25 
  `realm`                varchar(64) COLLATE utf8_bin DEFAULT '',
26 
  `nasipaddress`         varchar(15) COLLATE utf8_bin NOT NULL DEFAULT '',
27 
  `nasportid`            varchar(15) COLLATE utf8_bin DEFAULT NULL,
28 
  `nasporttype`          varchar(32) COLLATE utf8_bin DEFAULT NULL,
29 
  `acctstarttime`        datetime    DEFAULT NULL,
30 
  `acctstoptime`         datetime    DEFAULT NULL,
31 
  `acctsessiontime`      int(12)     DEFAULT NULL,
32 
  `acctauthentic`        varchar(32) COLLATE utf8_bin DEFAULT NULL,
33 
  `connectinfo_start`    varchar(50) COLLATE utf8_bin DEFAULT NULL,
34 
  `connectinfo_stop`     varchar(50) COLLATE utf8_bin DEFAULT NULL,
35 
  `acctinputoctets`      bigint(20)  DEFAULT NULL,
36 
  `acctoutputoctets`     bigint(20)  DEFAULT NULL,
37 
  `calledstationid`      varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '',
38 
  `callingstationid`     varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '',
39 
  `acctterminatecause`   varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
40 
  `servicetype`          varchar(32) COLLATE utf8_bin DEFAULT NULL,
41 
  `framedprotocol`       varchar(32) COLLATE utf8_bin DEFAULT NULL,
42 
  `framedipaddress`      varchar(15) COLLATE utf8_bin NOT NULL DEFAULT '',
43 
  `acctstartdelay`       int(12)     DEFAULT NULL,
44 
  `acctstopdelay`        int(12)     DEFAULT NULL,
2063 raphael.pi 45 
  `xascendsessionsvrkey` varchar(10) COLLATE utf8_bin DEFAULT NULL,
1800 richard 46 
  PRIMARY KEY (`radacctid`),
47 
  KEY `username` (`username`),
48 
  KEY `framedipaddress` (`framedipaddress`),
49 
  KEY `acctsessionid` (`acctsessionid`),
50 
  KEY `acctsessiontime` (`acctsessiontime`),
51 
  KEY `acctuniqueid` (`acctuniqueid`),
52 
  KEY `acctstarttime` (`acctstarttime`),
53 
  KEY `acctstoptime` (`acctstoptime`),
54 
  KEY `nasipaddress` (`nasipaddress`)
2371 tom.houday 55 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1800 richard 56 
/*!40101 SET character_set_client = @saved_cs_client */;
57 
 
58 
--
59 
-- Table structure for table `radcheck`
60 
--
61 
 
62 
DROP TABLE IF EXISTS `radcheck`;
63 
/*!40101 SET @saved_cs_client     = @@character_set_client */;
64 
/*!40101 SET character_set_client = utf8 */;
65 
CREATE TABLE `radcheck` (
2372 tom.houday 66 
  `id`        int(11)      unsigned NOT NULL AUTO_INCREMENT,
67 
  `username`  varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
68 
  `attribute` varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
69 
  `op`        char(2)      COLLATE utf8_bin NOT NULL DEFAULT '==',
70 
  `value`     varchar(253) COLLATE utf8_bin NOT NULL DEFAULT '',
1800 richard 71 
  PRIMARY KEY (`id`),
72 
  KEY `username` (`username`(32))
2371 tom.houday 73 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1800 richard 74 
/*!40101 SET character_set_client = @saved_cs_client */;
75 
 
76 
--
77 
-- Table structure for table `radgroupcheck`
78 
--
79 
 
80 
DROP TABLE IF EXISTS `radgroupcheck`;
81 
/*!40101 SET @saved_cs_client     = @@character_set_client */;
82 
/*!40101 SET character_set_client = utf8 */;
83 
CREATE TABLE `radgroupcheck` (
2372 tom.houday 84 
  `id`        int(11)      unsigned NOT NULL AUTO_INCREMENT,
85 
  `groupname` varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
86 
  `attribute` varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
87 
  `op`        char(2)      COLLATE utf8_bin NOT NULL DEFAULT '==',
88 
  `value`     varchar(253) COLLATE utf8_bin NOT NULL DEFAULT '',
1800 richard 89 
  PRIMARY KEY (`id`),
90 
  KEY `groupname` (`groupname`(32))
2372 tom.houday 91 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1800 richard 92 
/*!40101 SET character_set_client = @saved_cs_client */;
93 
 
94 
--
95 
-- Table structure for table `radgroupreply`
96 
--
97 
 
98 
DROP TABLE IF EXISTS `radgroupreply`;
99 
/*!40101 SET @saved_cs_client     = @@character_set_client */;
100 
/*!40101 SET character_set_client = utf8 */;
101 
CREATE TABLE `radgroupreply` (
2372 tom.houday 102 
  `id`        int(11)      unsigned NOT NULL AUTO_INCREMENT,
103 
  `groupname` varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
104 
  `attribute` varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
105 
  `op`        char(2)      COLLATE utf8_bin NOT NULL DEFAULT '=',
106 
  `value`     varchar(253) COLLATE utf8_bin NOT NULL DEFAULT '',
1800 richard 107 
  PRIMARY KEY (`id`),
108 
  KEY `groupname` (`groupname`(32))
2371 tom.houday 109 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1800 richard 110 
/*!40101 SET character_set_client = @saved_cs_client */;
111 
 
112 
--
113 
-- Table structure for table `radreply`
114 
--
115 
 
116 
DROP TABLE IF EXISTS `radreply`;
117 
/*!40101 SET @saved_cs_client     = @@character_set_client */;
118 
/*!40101 SET character_set_client = utf8 */;
119 
CREATE TABLE `radreply` (
2372 tom.houday 120 
  `id`        int(11)      unsigned NOT NULL AUTO_INCREMENT,
121 
  `username`  varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
122 
  `attribute` varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
123 
  `op`        char(2)      COLLATE utf8_bin NOT NULL DEFAULT '=',
124 
  `value`     varchar(253) COLLATE utf8_bin NOT NULL DEFAULT '',
1800 richard 125 
  PRIMARY KEY (`id`),
126 
  KEY `username` (`username`(32))
2371 tom.houday 127 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1800 richard 128 
/*!40101 SET character_set_client = @saved_cs_client */;
129 
 
130 
--
131 
-- Table structure for table `radusergroup`
132 
--
133 
 
134 
DROP TABLE IF EXISTS `radusergroup`;
135 
/*!40101 SET @saved_cs_client     = @@character_set_client */;
136 
/*!40101 SET character_set_client = utf8 */;
137 
CREATE TABLE `radusergroup` (
2372 tom.houday 138 
  `username`  varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
2063 raphael.pi 139 
  `groupname` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
2372 tom.houday 140 
  `priority`  int(11)     NOT NULL DEFAULT '1',
1800 richard 141 
  KEY `username` (`username`(32))
2371 tom.houday 142 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1800 richard 143 
/*!40101 SET character_set_client = @saved_cs_client */;
144 
 
145 
--
2372 tom.houday 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 
--
1800 richard 189 
-- Table structure for table `totacct`
190 
--
191 
 
192 
DROP TABLE IF EXISTS `totacct`;
193 
/*!40101 SET @saved_cs_client     = @@character_set_client */;
194 
/*!40101 SET character_set_client = utf8 */;
195 
CREATE TABLE `totacct` (
2372 tom.houday 196 
  `totacctid`       bigint(21)  NOT NULL AUTO_INCREMENT,
197 
  `username`        varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
198 
  `acctdate`        date        NOT NULL DEFAULT '0000-00-00',
199 
  `connnum`         bigint(12)  DEFAULT NULL,
200 
  `conntotduration` bigint(12)  DEFAULT NULL,
201 
  `connmaxduration` bigint(12)  DEFAULT NULL,
202 
  `connminduration` bigint(12)  DEFAULT NULL,
203 
  `inputoctets`     bigint(12)  DEFAULT NULL,
204 
  `outputoctets`    bigint(12)  DEFAULT NULL,
205 
  `nasipaddress`    varchar(15) COLLATE utf8_bin DEFAULT NULL,
206 
  PRIMARY KEY (`totacctid`),
207 
  KEY `username` (`username`),
208 
  KEY `acctdate` (`acctdate`),
209 
  KEY `UserOnDate` (`username`,`acctdate`),
210 
  KEY `nasipaddress` (`nasipaddress`),
211 
  KEY `nasipaddressOnDate` (`acctdate`,`nasipaddress`)
2371 tom.houday 212 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1800 richard 213 
/*!40101 SET character_set_client = @saved_cs_client */;
214 
 
215 
--
216 
-- Table structure for table `userinfo`
217 
--
218 
 
219 
DROP TABLE IF EXISTS `userinfo`;
220 
/*!40101 SET @saved_cs_client     = @@character_set_client */;
221 
/*!40101 SET character_set_client = utf8 */;
222 
CREATE TABLE `userinfo` (
2372 tom.houday 223 
  `id`         int(10)      NOT NULL AUTO_INCREMENT,
224 
  `username`   varchar(64)  COLLATE utf8_bin DEFAULT NULL,
225 
  `name`       varchar(200) COLLATE utf8_bin DEFAULT NULL,
226 
  `mail`       varchar(200) COLLATE utf8_bin DEFAULT NULL,
227 
  `department` varchar(200) COLLATE utf8_bin DEFAULT NULL,
228 
  `workphone`  varchar(200) COLLATE utf8_bin DEFAULT NULL,
229 
  `homephone`  varchar(200) COLLATE utf8_bin DEFAULT NULL,
230 
  `mobile`     varchar(200) COLLATE utf8_bin DEFAULT NULL,
1800 richard 231 
  PRIMARY KEY (`id`),
2372 tom.houday 232 
  KEY `username` (`username`),
233 
  KEY `department` (`department`)
2371 tom.houday 234 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1800 richard 235 
/*!40101 SET character_set_client = @saved_cs_client */;
236 
 
237 
 
238 
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
239 
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
240 
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
241 
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
242 
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
243 
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
244 
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
245 
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;