Subversion Repositories ALCASAR

Rev

Rev 2372 | 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 */;
-