Table: nornix_site.user
Structure | Name | Type | Null | Key | Default | Extra | Comment |
|---|
| No | int(10) unsigned | NO | PRI | | auto_increment | |
|---|
| Login | varchar(64) | NO | UNI | | | |
|---|
| Hash | varchar(128) | NO | | | | |
|---|
| Name | varchar(128) | NO | | | | |
|---|
| Email | varchar(64) | NO | | | | |
|---|
| Language | varchar(3) | NO | | en | | |
|---|
Indexes| Non-unique | Key | Seq | Column | Collation | Cardinality | Sub part | Packed | Null | Type | Comment |
|---|
| 0 | UniqueLogin | 1 | Login | A | 1 | | | | BTREE | |
Information| Engine | Row format | Table collation | Create options |
|---|
| MyISAM | Dynamic | utf8_general_ci | |
CREATE TABLE `user` (
`No` int(10) unsigned NOT NULL auto_increment,
`Login` varchar(64) NOT NULL,
`Hash` varchar(128) NOT NULL,
`Name` varchar(128) NOT NULL,
`Email` varchar(64) NOT NULL,
`Language` varchar(3) NOT NULL default 'en',
PRIMARY KEY (`No`),
UNIQUE KEY `UniqueLogin` (`Login`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8