# MySQL dump 8.13
#
# Host: localhost    Database: proftpd
#--------------------------------------------------------
# Server version	3.23.37-log

#
# Table structure for table 'ftp'
#

CREATE TABLE ftp (
  username varchar(60) binary default NULL,
  uid int(11) default NULL,
  gid int(11) default NULL,
  password varchar(30) default NULL,
  homedir varchar(250) default NULL,
  count int(11) default NULL,
  ui bigint(20) NOT NULL auto_increment,
  shell varchar(60) default NULL,
  letzter_zugriff datetime default NULL,
  zugang char(1) default NULL,
  PRIMARY KEY  (ui)
) TYPE=ISAM PACK_KEYS=1;

#
# Table structure for table 'xfer_stat'
#

CREATE TABLE xfer_stat (
  username tinytext,
  filename text,
  size bigint(20) default NULL,
  host tinytext,
  ip tinytext,
  aktion tinytext,
  dauer tinytext,
  zeit_lokal datetime default NULL,
  success char(1) default NULL,
  ui bigint(20) NOT NULL auto_increment,
  PRIMARY KEY  (ui)
) TYPE=MyISAM;