|
lic |
| users |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
ID |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
|
LANID |
varchar(15) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
CRWLOC |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CURREXPONO |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CURRMEETNO |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
|
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FNAME |
varchar(15) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
INITIALS |
varchar(3) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
PASSWORD |
varchar(8) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
LNAME |
varchar(20) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
MI |
varchar(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
NOTES |
longtext |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
RIGHTS |
varchar(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TEL |
varchar(12) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
SUPER |
tinyint(1) |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
|
USERGROUP |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
users |
0 |
PRIMARY |
1 |
ID |
A |
80 |
(NULL) |
(NULL) |
|
BTREE |
|
|
users |
1 |
LNAME |
1 |
LNAME |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
users |
1 |
LANID |
1 |
LANID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back