CREATE TABLE `members` ( 
 `id` mediumint(9) NOT NULL auto_increment,
 `timestamp` timestamp(14) NOT NULL,
 `givenName`  text NOT NULL,
 `sn`  text NOT NULL,
 `mail`  text NOT NULL,
 `mobile` text,
 `postalAddress` text,
 `postalCode` text,
 `labeledURI` text,
 `uid`  text NOT NULL,
 `userPassword`  text NOT NULL,
  PRIMARY KEY  (`id`)
);

CREATE TABLE `status` ( 
 `id` mediumint(9) NOT NULL auto_increment,
 `timestamp` timestamp(14) NOT NULL,
 `uid`  text NOT NULL,
 `home_created` tinyint(4) NOT NULL default '0',
 `ldap_account_created` tinyint(4) NOT NULL default '0',
 `mysql_dbase` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
);

