drop table if exists `saas_users`; create table `saas_users` ( `id` int unsigned not null auto_increment primary key, `login` char(255) not null, `passwd` char(32) not null, `creation_date` timestamp not null default NOW(), `last_login` timestamp not null, `perms` enum('nobody','admin','readonly') not null default 'nobody', key `login` (`login`) ) engine=innodb;