-- Server version	4.0.17-log

--
-- Table structure for table `users`
--

CREATE TABLE users (
  id int(11) unsigned NOT NULL auto_increment,
  username varchar(128) NOT NULL default 'NOT NULL',
  PRIMARY KEY  (id)
) TYPE=InnoDB;

--
-- Table structure for table `entries`
--

CREATE TABLE entries (
  id int(10) unsigned NOT NULL auto_increment,
  userid int(10) unsigned NOT NULL default '0',
  first varchar(32) NOT NULL default '',
  middle varchar(32) NOT NULL default '',
  last varchar(32) NOT NULL default '',
  nickname varchar(32) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY entries_fkey (userid),
  CONSTRAINT `0_39` FOREIGN KEY (`userid`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) TYPE=InnoDB;

--
-- Table structure for table `emails`
--

CREATE TABLE emails (
  id int(10) unsigned NOT NULL auto_increment,
  entryid int(10) unsigned NOT NULL default '0',
  email varchar(128) NOT NULL default '',
  isdefault tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY entry_pkey (entryid),
  CONSTRAINT `0_44` FOREIGN KEY (`entryid`) REFERENCES `entries` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) TYPE=InnoDB;

--
-- Table structure for table `identities`
--

CREATE TABLE identities (
  id int(11) unsigned NOT NULL auto_increment,
  userid int(11) unsigned NOT NULL default '0',
  name varchar(64) NOT NULL default '',
  isdefault tinyint(1) NOT NULL default '0',
  displayname varchar(128) NOT NULL default '',
  fromaddress varchar(128) NOT NULL default '',
  replyto varchar(128) NOT NULL default '',
  organization varchar(128) NOT NULL default '',
  signature text NOT NULL,
  PRIMARY KEY  (id),
  KEY identities_fkey (userid),
  CONSTRAINT `0_37` FOREIGN KEY (`userid`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) TYPE=InnoDB;

--
-- Table structure for table `settings`
--

CREATE TABLE settings (
  id int(11) unsigned NOT NULL auto_increment,
  userid int(11) unsigned NOT NULL default '0',
  setting varchar(32) NOT NULL default '',
  value varchar(32) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY settings_fkey (userid),
  CONSTRAINT `0_35` FOREIGN KEY (`userid`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) TYPE=InnoDB;