CREATE TABLE members(
id INT PRIMARY KEY auto_increment COMMENT 'primary key',
username VARCHAR(128) COMMENT 'login name',
password VARCHAR(64) COMMENT 'password',
realname VARCHAR(384) COMMENT 'real name',
email VARCHAR(384) COMMENT 'e-mail',
authority INT COMMENT 'authority in application',
pwremind_ticket VARCHAR(64) COMMENT 'ticket id for password reminder',
last_login DATETIME COMMENT 'datetime of last login',
login_count INT COMMENT 'login count',
login_fail INT COMMENT 'count for login failure',
enabled INT COMMENT 'enabled flag',
insert_time DATETIME COMMENT 'create datetime',
insert_user INT COMMENT 'create user',
update_time DATETIME COMMENT 'update datetime',
update_user INT COMMENT 'update user'
) type=InnoDB, COMMENT = 'Application user'
;

INSERT INTO members ( id, username, password, realname, email, authority, pwremind_ticket, last_login, login_count, login_fail, enabled, insert_time, insert_user, update_time, update_user ) VALUES (1,'admin','21232f297a57a5a743894a0e4a801fc3','Administrator','',1,'',null,null,null,1,'2009-11-29 16:04:53',5,'2009-11-29 16:04:53',5)
;
