Posted on: 07/09/06 01:40pm
By: Anonymous (Masabu)
mysql> describe gl_users; +----------------+----------------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+----------------------+------+-----+---------------------+-------+ | uid | mediumint(8) | | PRI | 0 | | | username | varchar(16) | | MUL | | | | remoteusername | varchar(60) | YES | | NULL | | | remoteservice | varchar(60) | YES | | NULL | | | fullname | varchar(80) | YES | MUL | NULL | | | passwd | varchar(32) | | MUL | | | | email | varchar(96) | YES | MUL | NULL | | | homepage | varchar(96) | YES | | NULL | | | sig | varchar(160) | | | | | | regdate | datetime | | | 0000-00-00 00:00:00 | | | photo | varchar(128) | YES | | NULL | | | cookietimeout | int(8) unsigned | YES | | 0 | | | theme | varchar(64) | YES | | NULL | | | language | varchar(64) | YES | | NULL | | | pwrequestid | varchar(16) | YES | MUL | NULL | | | status | smallint(5) unsigned | | | 1 | | +----------------+----------------------+------+-----+---------------------+-------+ 16 rows in set (0.00 sec)
mysql> describe gl_users; +----------------+----------------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+----------------------+------+-----+---------------------+----------------+ | uid | mediumint(8) | | PRI | NULL | auto_increment | | username | varchar(16) | | MUL | | | | remoteusername | varchar(60) | YES | | NULL | | | remoteservice | varchar(60) | YES | | NULL | | | fullname | varchar(80) | YES | MUL | NULL | | | passwd | varchar(32) | | MUL | | | | email | varchar(96) | YES | MUL | NULL | | | homepage | varchar(96) | YES | | NULL | | | sig | varchar(160) | | | | | | regdate | datetime | | | 0000-00-00 00:00:00 | | | photo | varchar(128) | YES | | NULL | | | cookietimeout | int(8) unsigned | YES | | 28800 | | | theme | varchar(64) | YES | | NULL | | | language | varchar(64) | YES | | NULL | | | pwrequestid | varchar(16) | YES | MUL | NULL | | | status | smallint(5) unsigned | | | 1 | | +----------------+----------------------+------+-----+---------------------+----------------+ 16 rows in set (0.00 sec)