create table b_user (
ID int(18) not null auto_increment,
TIMESTAMP_X timestamp(14),
LOGIN varchar(50) not null,
`PASSWORD` varchar(50) not null,
CHECKWORD varchar(50),
ACTIVE char(1) not null default 'Y',
NAME varchar(50),
LAST_NAME varchar(50),
EMAIL varchar(255) not null,
LAST_LOGIN datetime,
DATE_REGISTER datetime not null,
LID char(2) REFERENCES b_lang(LID),
PERSONAL_PROFESSION varchar(255),
PERSONAL_WWW varchar(255),
PERSONAL_ICQ varchar(255),
PERSONAL_GENDER char(1),
PERSONAL_BIRTHDATE varchar(50),
PERSONAL_PHOTO int(18),
PERSONAL_PHONE varchar(255),
PERSONAL_FAX varchar(255),
PERSONAL_MOBILE varchar(255),
PERSONAL_PAGER varchar(255),
PERSONAL_STREET text,
PERSONAL_MAILBOX varchar(255),
PERSONAL_CITY varchar(255),
PERSONAL_STATE varchar(255),
PERSONAL_ZIP varchar(255),
PERSONAL_COUNTRY varchar(255),
PERSONAL_NOTES text,
WORK_COMPANY varchar(255),
WORK_DEPARTMENT varchar(255),
WORK_POSITION varchar(255),
WORK_WWW varchar(255),
WORK_PHONE varchar(255),
WORK_FAX varchar(255),
WORK_PAGER varchar(255),
WORK_STREET text,
WORK_MAILBOX varchar(255),
WORK_CITY varchar(255),
WORK_STATE varchar(255),
WORK_ZIP varchar(255),
WORK_COUNTRY varchar(255),
WORK_PROFILE text,
WORK_LOGO int(18),
WORK_NOTES text,
ADMIN_NOTES text,
STORED_HASH varchar(32),
XML_ID varchar(255),
PERSONAL_BIRTHDAY date,
EXTERNAL_AUTH_ID varchar(255),
CHECKWORD_TIME datetime,
primary key (ID),
unique ix_login (LOGIN, EXTERNAL_AUTH_ID)
);
