- CREATE TABLE user_table (
- user_id BIGINT NOT NULL AUTO_INCREMENT,
- user_name TEXT NOT NULL DEFAULT '',
- password TEXT NOT NULL DEFAULT '',
- login_deny INT( 1 ) NOT NULL DEFAULT 0,
- domain_id BIGINT NOT NULL DEFAULT 0,
- last_update DATETIME NOT NULL,
- PRIMARY KEY( user_id ),
- INDEX( user_id )
- )