Subversion Repositories ALCASAR

Rev

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

Rev Author Line No. Line
1800 richard 1 
--
2 
-- Table structure for table `radacct`
3 
--
4 
 
5 
DROP TABLE IF EXISTS `radacct`;
6 
CREATE TABLE `radacct` (
3202 rexy 7 
  `radacctid`            bigint(21)   NOT NULL AUTO_INCREMENT,
8 
  `acctsessionid`        varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
9 
  `acctuniqueid`         varchar(32)  COLLATE utf8_bin NOT NULL DEFAULT '',
10 
  `username`             varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
11 
  `realm`                varchar(64)  COLLATE utf8_bin DEFAULT '',
12 
  `nasipaddress`         varchar(15)  COLLATE utf8_bin NOT NULL DEFAULT '',
13 
  `nasportid`            varchar(32)  COLLATE utf8_bin DEFAULT NULL,
14 
  `nasporttype`          varchar(32)  COLLATE utf8_bin DEFAULT NULL,
15 
  `acctstarttime`        datetime     DEFAULT NULL,
16 
  `acctupdatetime`       datetime     DEFAULT NULL,
17 
  `acctstoptime`         datetime     DEFAULT NULL,
18 
  `acctinterval`         int(12)      DEFAULT NULL,
19 
  `acctsessiontime`      int(12)      DEFAULT NULL,
20 
  `acctauthentic`        varchar(32)  COLLATE utf8_bin DEFAULT NULL,
21 
  `connectinfo_start`    varchar(128) COLLATE utf8_bin DEFAULT NULL,
22 
  `connectinfo_stop`     varchar(128) COLLATE utf8_bin DEFAULT NULL,
23 
  `acctinputoctets`      bigint(20)   DEFAULT NULL,
24 
  `acctoutputoctets`     bigint(20)   DEFAULT NULL,
25 
  `calledstationid`      varchar(50)  COLLATE utf8_bin NOT NULL DEFAULT '',
26 
  `callingstationid`     varchar(50)  COLLATE utf8_bin NOT NULL DEFAULT '',
27 
  `acctterminatecause`   varchar(32)  COLLATE utf8_bin NOT NULL DEFAULT '',
28 
  `servicetype`          varchar(32)  COLLATE utf8_bin DEFAULT NULL,
29 
  `framedprotocol`       varchar(32)  COLLATE utf8_bin DEFAULT NULL,
30 
  `framedipaddress`      varchar(15)  COLLATE utf8_bin NOT NULL DEFAULT '',
31 
  `framedipv6address`    varchar(45)  COLLATE utf8_bin NOT NULL DEFAULT '',
32 
  `framedipv6prefix`     varchar(45)  COLLATE utf8_bin NOT NULL DEFAULT '',
33 
  `framedinterfaceid`    varchar(45)  COLLATE utf8_bin NOT NULL DEFAULT '',
34 
  `delegatedipv6prefix`  varchar(45)  COLLATE utf8_bin NOT NULL DEFAULT '',
35 
  `class`                varchar(64)  DEFAULT NULL,
1800 richard 36 
  PRIMARY KEY (`radacctid`),
3202 rexy 37 
  UNIQUE KEY `acctuniqueid` (`acctuniqueid`),
1800 richard 38 
  KEY `username` (`username`),
39 
  KEY `framedipaddress` (`framedipaddress`),
3202 rexy 40 
  KEY `framedipv6address` (`framedipv6address`),
41 
  KEY `framedipv6prefix` (`framedipv6prefix`),
42 
  KEY `framedinterfaceid` (`framedinterfaceid`),
43 
  KEY `delegatedipv6prefix` (`delegatedipv6prefix`),
1800 richard 44 
  KEY `acctsessionid` (`acctsessionid`),
45 
  KEY `acctsessiontime` (`acctsessiontime`),
46 
  KEY `acctstarttime` (`acctstarttime`),
3202 rexy 47 
  KEY `acctinterval` (`acctinterval`),
1800 richard 48 
  KEY `acctstoptime` (`acctstoptime`),
3202 rexy 49 
  KEY `nasipaddress` (`nasipaddress`),
50 
  KEY `class` (`class`)
2371 tom.houday 51 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1800 richard 52 
 
53 
--
54 
-- Table structure for table `radcheck`
55 
--
56 
 
57 
DROP TABLE IF EXISTS `radcheck`;
58 
CREATE TABLE `radcheck` (
2372 tom.houday 59 
  `id`        int(11)      unsigned NOT NULL AUTO_INCREMENT,
60 
  `username`  varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
61 
  `attribute` varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
62 
  `op`        char(2)      COLLATE utf8_bin NOT NULL DEFAULT '==',
63 
  `value`     varchar(253) COLLATE utf8_bin NOT NULL DEFAULT '',
1800 richard 64 
  PRIMARY KEY (`id`),
65 
  KEY `username` (`username`(32))
2371 tom.houday 66 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1800 richard 67 
 
68 
--
69 
-- Table structure for table `radgroupcheck`
70 
--
71 
 
72 
DROP TABLE IF EXISTS `radgroupcheck`;
73 
CREATE TABLE `radgroupcheck` (
2372 tom.houday 74 
  `id`        int(11)      unsigned NOT NULL AUTO_INCREMENT,
75 
  `groupname` varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
76 
  `attribute` varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
77 
  `op`        char(2)      COLLATE utf8_bin NOT NULL DEFAULT '==',
78 
  `value`     varchar(253) COLLATE utf8_bin NOT NULL DEFAULT '',
1800 richard 79 
  PRIMARY KEY (`id`),
80 
  KEY `groupname` (`groupname`(32))
2372 tom.houday 81 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1800 richard 82 
 
83 
--
84 
-- Table structure for table `radgroupreply`
85 
--
86 
 
87 
DROP TABLE IF EXISTS `radgroupreply`;
88 
CREATE TABLE `radgroupreply` (
2372 tom.houday 89 
  `id`        int(11)      unsigned NOT NULL AUTO_INCREMENT,
90 
  `groupname` varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
91 
  `attribute` varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
92 
  `op`        char(2)      COLLATE utf8_bin NOT NULL DEFAULT '=',
93 
  `value`     varchar(253) COLLATE utf8_bin NOT NULL DEFAULT '',
1800 richard 94 
  PRIMARY KEY (`id`),
95 
  KEY `groupname` (`groupname`(32))
2371 tom.houday 96 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1800 richard 97 
 
98 
--
99 
-- Table structure for table `radreply`
100 
--
101 
 
102 
DROP TABLE IF EXISTS `radreply`;
103 
CREATE TABLE `radreply` (
2372 tom.houday 104 
  `id`        int(11)      unsigned NOT NULL AUTO_INCREMENT,
105 
  `username`  varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
106 
  `attribute` varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
107 
  `op`        char(2)      COLLATE utf8_bin NOT NULL DEFAULT '=',
108 
  `value`     varchar(253) COLLATE utf8_bin NOT NULL DEFAULT '',
1800 richard 109 
  PRIMARY KEY (`id`),
110 
  KEY `username` (`username`(32))
2371 tom.houday 111 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1800 richard 112 
 
113 
--
114 
-- Table structure for table `radusergroup`
115 
--
116 
 
117 
DROP TABLE IF EXISTS `radusergroup`;
118 
CREATE TABLE `radusergroup` (
2372 tom.houday 119 
  `username`  varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
2063 raphael.pi 120 
  `groupname` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
2372 tom.houday 121 
  `priority`  int(11)     NOT NULL DEFAULT '1',
1800 richard 122 
  KEY `username` (`username`(32))
2371 tom.houday 123 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1800 richard 124 
 
125 
--
2372 tom.houday 126 
-- Table structure for table `radpostauth`
127 
--
128 
 
129 
DROP TABLE IF EXISTS `radpostauth`;
130 
CREATE TABLE `radpostauth` (
3202 rexy 131 
  `id`       int(11)      NOT NULL AUTO_INCREMENT,
132 
  `username` varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
133 
  `pass`     varchar(64)  COLLATE utf8_bin NOT NULL DEFAULT '',
134 
  `reply`    varchar(32)  COLLATE utf8_bin NOT NULL DEFAULT '',
135 
  `authdate` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
136 
  `class`    varchar(64)  DEFAULT NULL,
137 
  PRIMARY KEY (`id`),
138 
  KEY `username` (`username`),
139 
  KEY `class` (`class`)
2372 tom.houday 140 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
141 
 
142 
--
3202 rexy 143 
-- Table structure for table `nas`
144 
--
145 
 
146 
DROP TABLE IF EXISTS `nas`;
147 
CREATE TABLE `nas` (
148 
  `id`          int(10)      NOT NULL AUTO_INCREMENT,
149 
  `nasname`     varchar(128) NOT NULL,
150 
  `shortname`   varchar(32),
151 
  `type`        varchar(30)  DEFAULT 'other',
152 
  `ports`       int(5),
153 
  `secret`      varchar(60)  DEFAULT 'secret' NOT NULL,
154 
  `server`      varchar(64),
155 
  `community`   varchar(50),
156 
  `description` varchar(200) DEFAULT 'RADIUS Client',
157 
  PRIMARY KEY (id),
158 
  KEY `nasname` (`nasname`)
159 
);
160 
 
161 
--
2372 tom.houday 162 
-- Table structure for table `mtotacct`
163 
--
164 
 
165 
DROP TABLE IF EXISTS `mtotacct`;
166 
CREATE TABLE `mtotacct` (
167 
  `mtotacctid`      bigint(21)  NOT NULL AUTO_INCREMENT,
168 
  `username`        varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
169 
  `acctdate`        date        NOT NULL DEFAULT '0000-00-00',
170 
  `connnum`         bigint(12)  DEFAULT NULL,
171 
  `conntotduration` bigint(12)  DEFAULT NULL,
172 
  `connmaxduration` bigint(12)  DEFAULT NULL,
173 
  `connminduration` bigint(12)  DEFAULT NULL,
174 
  `inputoctets`     bigint(12)  DEFAULT NULL,
175 
  `outputoctets`    bigint(12)  DEFAULT NULL,
176 
  `nasipaddress`    varchar(15) COLLATE utf8_bin DEFAULT NULL,
177 
  PRIMARY KEY (`mtotacctid`),
178 
  KEY `username` (`username`),
179 
  KEY `acctdate` (`acctdate`),
180 
  KEY `UserOnDate` (`username`,`acctdate`),
181 
  KEY `nasipaddress` (`nasipaddress`)
182 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
183 
 
184 
--
1800 richard 185 
-- Table structure for table `totacct`
186 
--
187 
 
188 
DROP TABLE IF EXISTS `totacct`;
189 
CREATE TABLE `totacct` (
2372 tom.houday 190 
  `totacctid`       bigint(21)  NOT NULL AUTO_INCREMENT,
191 
  `username`        varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
192 
  `acctdate`        date        NOT NULL DEFAULT '0000-00-00',
193 
  `connnum`         bigint(12)  DEFAULT NULL,
194 
  `conntotduration` bigint(12)  DEFAULT NULL,
195 
  `connmaxduration` bigint(12)  DEFAULT NULL,
196 
  `connminduration` bigint(12)  DEFAULT NULL,
197 
  `inputoctets`     bigint(12)  DEFAULT NULL,
198 
  `outputoctets`    bigint(12)  DEFAULT NULL,
199 
  `nasipaddress`    varchar(15) COLLATE utf8_bin DEFAULT NULL,
200 
  PRIMARY KEY (`totacctid`),
201 
  KEY `username` (`username`),
202 
  KEY `acctdate` (`acctdate`),
203 
  KEY `UserOnDate` (`username`,`acctdate`),
204 
  KEY `nasipaddress` (`nasipaddress`),
205 
  KEY `nasipaddressOnDate` (`acctdate`,`nasipaddress`)
2371 tom.houday 206 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1800 richard 207 
 
208 
--
209 
-- Table structure for table `userinfo`
210 
--
211 
 
212 
DROP TABLE IF EXISTS `userinfo`;
213 
CREATE TABLE `userinfo` (
2372 tom.houday 214 
  `id`         int(10)      NOT NULL AUTO_INCREMENT,
215 
  `username`   varchar(64)  COLLATE utf8_bin DEFAULT NULL,
216 
  `name`       varchar(200) COLLATE utf8_bin DEFAULT NULL,
217 
  `mail`       varchar(200) COLLATE utf8_bin DEFAULT NULL,
218 
  `department` varchar(200) COLLATE utf8_bin DEFAULT NULL,
219 
  `workphone`  varchar(200) COLLATE utf8_bin DEFAULT NULL,
220 
  `homephone`  varchar(200) COLLATE utf8_bin DEFAULT NULL,
221 
  `mobile`     varchar(200) COLLATE utf8_bin DEFAULT NULL,
1800 richard 222 
  PRIMARY KEY (`id`),
2372 tom.houday 223 
  KEY `username` (`username`),
224 
  KEY `department` (`department`)
2371 tom.houday 225 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;