CREATE TABLE `em_contact` (
  `id` int(11) NOT NULL auto_increment,
  `login_id` int(11) NOT NULL default '0',
  `givenname` varchar(30) collate latin1_general_ci NOT NULL default '',
  `sn` varchar(30) collate latin1_general_ci NOT NULL default '',
  `cn` varchar(60) collate latin1_general_ci NOT NULL default '',
  `mozillaNickname` varchar(30) collate latin1_general_ci NOT NULL,
  `mail` varchar(60) collate latin1_general_ci NOT NULL default '',
  `mozillaSecondEmail` varchar(60) collate latin1_general_ci NOT NULL default '',
  `telephoneNumber` varchar(30) collate latin1_general_ci NOT NULL default '',
  `homePhone` varchar(30) collate latin1_general_ci NOT NULL default '',
  `fax` varchar(30) collate latin1_general_ci NOT NULL,
  `mobile` varchar(30) collate latin1_general_ci NOT NULL default '',
  `homeStreet` varchar(60) collate latin1_general_ci NOT NULL,
  `mozillaHomeLocalityName` varchar(30) collate latin1_general_ci NOT NULL default '',
  `mozillaHomePostalCode` varchar(30) collate latin1_general_ci NOT NULL default '',
  `mozillaHomeCountryName` varchar(30) collate latin1_general_ci NOT NULL default '',
  `mozillaHomeUrl` varchar(90) collate latin1_general_ci NOT NULL,
  `description` varchar(255) collate latin1_general_ci NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `login_id` (`login_id`)
) 

INSERT INTO `em_user` VALUES (1, 'administrator', 'kRSuh9gEjGRzg', '1');