
CREATE TABLE IF NOT EXISTS pop_access (
  autoinc int(12) NOT NULL auto_increment,
  id varchar(32) NOT NULL default '',
  uid int(11) NOT NULL default '65534',
  gid int(11) NOT NULL default '65534',
  home varchar(255) NOT NULL default '',
  shell varchar(255) NOT NULL default '',
  mbox_host varchar(120) NOT NULL default '',
  crypt varchar(255) NOT NULL default '',
  passwd varchar(255) NOT NULL default '',
  active int(11) NOT NULL default '1',
  start_date date NOT NULL default '0000-00-00',
  expire_date date NOT NULL default '0000-00-00',
  quota_size int(11) NOT NULL default '0',
  type varchar(20) NOT NULL default 'default',
  memo text,du bigint(20) NOT NULL default '0',
  another_perso varchar(5) NOT NULL default 'no',
  redirect1 varchar(255) default NULL,
  redirect2 varchar(255) default NULL,
  localdeliver varchar(10) NOT NULL default 'yes',
  pop3_login_count int(9) NOT NULL default '0',
  pop3_transfered_bytes int(14) NOT NULL default '0',
  imap_login_count int(9) NOT NULL default '0',
  imap_transfered_bytes int(14) NOT NULL default '0',
  last_login int(14) NOT NULL default '0',
  bounce_msg text NOT NULL,
  spf_protect enum('yes','no') NOT NULL default 'no',
  clamav_protect enum('yes','no') NOT NULL default 'no',
  spam_mailbox_enable enum('yes','no') NOT NULL default 'no',
  spam_mailbox varchar(255) NOT NULL default 'SPAM',
  pass_next_req varchar(128) NOT NULL default '',
  pass_expire int(12) NOT NULL default '0',
  vacation_flag enum('yes','no') default 'no',
  vacation_text text NOT NULL,
  UNIQUE id (id,mbox_host),
  PRIMARY KEY (autoinc)
) TYPE=MyISAM
