CREATE TABLE IF NOT EXISTS `users` (
  `id` smallint(6) NOT NULL auto_increment,
  `name` varchar(32) NOT NULL,
  `password` varchar(40) NOT NULL,
  `password_forcechange` enum('Y','N') NOT NULL,
  `last_ip` varchar(15) default NULL,
  `last_login` timestamp NULL default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;


CREATE TABLE IF NOT EXISTS `users_contact` (
  `user_id` smallint(6) NOT NULL,
  `email` varchar(128) default NULL,
  `homepage` varchar(256) default NULL,
  `phone` text,
  `messenger` text,
  PRIMARY KEY  (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


ALTER TABLE `users_contact`
  ADD CONSTRAINT `users_contact_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;