Subversion Repositories ALCASAR

Rev

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

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