# MySQL-Front Dump 2.5
#
# Host: eis.bru.lan   Database: hobr
# --------------------------------------------------------
# Server version 3.23.47


#
# Table structure for table 'adr'
#

CREATE TABLE adr (
  AdNr_ID smallint(6) unsigned NOT NULL auto_increment,
  Key1 char(3) default NULL,
  Key2 char(3) default NULL,
  Partnersatz enum('Ja','Nein') default 'Nein',
  Nachname varchar(30) default NULL,
  Vorname varchar(30) default NULL,
  Nachname2 varchar(30) default NULL,
  Vorname2 varchar(30) default NULL,
  Anrede_ID smallint(3) unsigned default '10',
  Anrede2_ID smallint(3) unsigned default '10',
  Titel1 varchar(15) default NULL,
  Titel2 varchar(15) default NULL,
  Firma varchar(50) default NULL,
  Zusatz varchar(50) default NULL,
  Strasse varchar(50) default NULL,
  Land_ID varchar(5) default NULL,
  Plz varchar(6) default NULL,
  Ort varchar(30) default NULL,
  Angelegt_am date NOT NULL default '0000-00-00',
  Geaendert_am date default NULL,
  Telefon varchar(20) default NULL,
  Telefon2 varchar(20) default NULL,
  Natel varchar(20) default NULL,
  Fax varchar(20) default NULL,
  Anrede1 varchar(10) default NULL,
  Anrede2 varchar(10) default NULL,
  Briefanrede1 varchar(50) default NULL,
  Briefanrede2 varchar(50) default NULL,
  Briefanrede2b varchar(50) default NULL,
  Kontonummer varchar(20) default NULL,
  Bankleitzahl int(10) unsigned default NULL,
  Bankname varchar(30) default NULL,
  Kurzmemo varchar(255) default NULL,
  E_mail varchar(50) default NULL,
  HTTP varchar(30) default NULL,
  Geb1 date default NULL,
  Geb2 date default NULL,
  PRIMARY KEY  (AdNr_ID),
  KEY LandX (Land_ID),
  KEY nachname (Nachname),
  KEY nachname2 (Nachname2)
) TYPE=MyISAM COMMENT='Adressen';



#
# Dumping data for table 'adr'
#

INSERT INTO adr VALUES("1", NULL, NULL, "Nein", "Bruenjes", "Holger", NULL, NULL, "11", "10", NULL, NULL, NULL, NULL, "Baechliweg 53", "FL", "9495", "Triesen", "2003-06-14", NULL, NULL, NULL, NULL, NULL, NULL, NULL, "Hallo Holger", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO adr VALUES("2", NULL, NULL, "Nein", "Meierhans", "Eva", NULL, NULL, "21", "10", NULL, NULL, NULL, NULL, "Zugangweg 36", "D", "28201", "Bremen", "2003-06-14", "2003-06-14", NULL, NULL, NULL, NULL, NULL, NULL, "Sehr geehrte Frau Meierhans", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO adr VALUES("3", NULL, NULL, "Nein", "Zuwohl", "Hans", NULL, NULL, "11", "10", NULL, NULL, NULL, NULL, "Irgendwo", "NL", "23493", "LG Groningen", "2003-06-14", "2003-06-14", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);


#
# Table structure for table 'anreden'
#

CREATE TABLE anreden (
  Anrede_ID tinyint(3) unsigned NOT NULL default '0',
  Anrede varchar(20) default NULL,
  PRIMARY KEY  (Anrede_ID)
) TYPE=MyISAM;



#
# Dumping data for table 'anreden'
#

INSERT INTO anreden VALUES("10", NULL);
INSERT INTO anreden VALUES("11", "Herrn");
INSERT INTO anreden VALUES("12", "Herrn");
INSERT INTO anreden VALUES("15", "Signor");
INSERT INTO anreden VALUES("21", "Frau");
INSERT INTO anreden VALUES("22", "Frau");
INSERT INTO anreden VALUES("25", "Signora");


#
# Table structure for table 'briefanrede'
#

CREATE TABLE briefanrede (
  Briefanrede_ID tinyint(3) unsigned NOT NULL default '0',
  Briefanrede varchar(30) default NULL,
  PRIMARY KEY  (Briefanrede_ID)
) TYPE=MyISAM;



#
# Dumping data for table 'briefanrede'
#

INSERT INTO briefanrede VALUES("10", "Sehr geehrte Damen und Herren");
INSERT INTO briefanrede VALUES("11", "Sehr geehrter Herr");
INSERT INTO briefanrede VALUES("12", "Hallo");
INSERT INTO briefanrede VALUES("15", "Egregio Signore");
INSERT INTO briefanrede VALUES("20", "Egregio Signori");
INSERT INTO briefanrede VALUES("21", "Sehr geehrte Frau");
INSERT INTO briefanrede VALUES("22", "Hallo");
INSERT INTO briefanrede VALUES("25", "Egregio Signora");


#
# Table structure for table 'laender'
#

CREATE TABLE laender (
  Land_ID char(3) NOT NULL default '',
  LandName varchar(50) NOT NULL default '',
  WEBLKZ char(3) default NULL,
  VWREIN smallint(5) unsigned default NULL,
  VWRAUS smallint(5) unsigned default NULL,
  GN char(3) NOT NULL default '',
  PRIMARY KEY  (Land_ID)
) TYPE=MyISAM COMMENT='Laendertabelle';



#
# Dumping data for table 'laender'
#

INSERT INTO laender VALUES("D", "Deutschland", "de", "49", "0", "n");
INSERT INTO laender VALUES("CH", "Schweiz", "ch", "41", "0", "n");
INSERT INTO laender VALUES("B", "Belgien", "be", "32", "0", "g");
INSERT INTO laender VALUES("DK", "Daenemark", "dk", "45", "9", "g");
INSERT INTO laender VALUES("F", "Frankreich", "fr", "33", "19", "g");
INSERT INTO laender VALUES("GB", "Groábritannien", "uk", "44", "10", "g");
INSERT INTO laender VALUES("IL", "Israel", "il", "255", "0", "g");
INSERT INTO laender VALUES("I", "Italien", "it", "39", "0", "g");
INSERT INTO laender VALUES("NL", "Niederlande", "nl", "31", "0", "g");
INSERT INTO laender VALUES("N", "Norwegen", "no", "47", "95", "g");
INSERT INTO laender VALUES("S", "Schweden", "sw", "46", "9", "g");
INSERT INTO laender VALUES("TR", "Tuerkei", "tr", "90", "99", "g");
INSERT INTO laender VALUES("USA", "USA", "us", "1", "11", "g");
INSERT INTO laender VALUES("L", "Luxemburg", "lx", "35", "0", "g");
INSERT INTO laender VALUES("A", "Oesterreich", "at", "43", "0", "n");
INSERT INTO laender VALUES("FL", "Fuerstentum Liechtenstein", "li", "423", "0", "n");
INSERT INTO laender VALUES("CZ", "Tschechien", "cz", "255", "0", "g");
INSERT INTO laender VALUES("PL", "Polen", "pl", "48", "0", "g");
INSERT INTO laender VALUES("AL", "Albanien", "al", "255", "0", "g");
INSERT INTO laender VALUES("AND", "Andorra", "an", "255", "0", "g");
INSERT INTO laender VALUES("ARM", "Armenien", "am", "7", "0", "g");
INSERT INTO laender VALUES("AUS", "Australien", "au", "61", "0", "g");
INSERT INTO laender VALUES("BG", "Bulgarien", "bg", "255", "0", "g");
INSERT INTO laender VALUES("BIH", "Bosnien Herzegowina", "bi", "255", "0", "g");
INSERT INTO laender VALUES("BY", "Weissrussland", "by", "7", "0", "g");
INSERT INTO laender VALUES("CY", "Zypern", "cy", "255", "0", "g");
INSERT INTO laender VALUES("DZ", "Algerien", "dz", "213", "0", "g");
INSERT INTO laender VALUES("EST", "Estland", "es", "255", "0", "g");
INSERT INTO laender VALUES("FJI", "Fidschi", "fj", "255", "0", "g");
INSERT INTO laender VALUES("GBZ", "Gibraltar", "gb", "255", "0", "g");
INSERT INTO laender VALUES("GE", "Georgien", "ge", "255", "0", "g");
INSERT INTO laender VALUES("HR", "Kroatien", "hr", "255", "0", "g");
INSERT INTO laender VALUES("IS", "Island", "is", "255", "0", "g");
INSERT INTO laender VALUES("J", "Japan", "jp", "81", "0", "g");
INSERT INTO laender VALUES("JOR", "Jordanien", "jo", "255", "0", "g");
INSERT INTO laender VALUES("KS", "Kirgistan", "ks", "7", "0", "g");
INSERT INTO laender VALUES("KZ", "Kasachstan", "kz", "7", "0", "g");
INSERT INTO laender VALUES("LT", "Litauen", "lt", "255", "0", "g");
INSERT INTO laender VALUES("LV", "Lettland", "lv", "255", "0", "g");
INSERT INTO laender VALUES("M", "Malta", "mt", "255", "0", "g");
INSERT INTO laender VALUES("MA", "Marokko", "ma", "212", "0", "g");
INSERT INTO laender VALUES("MC", "Monaco", "mc", "33", "0", "g");
INSERT INTO laender VALUES("MD", "Moldau", "md", "255", "0", "g");
INSERT INTO laender VALUES("NZ", "Neuseeland", "nz", "64", "0", "g");
INSERT INTO laender VALUES("RC", "Taiwan", "rc", "255", "0", "g");
INSERT INTO laender VALUES("RO", "Rumaenien", "ro", "40", "0", "g");
INSERT INTO laender VALUES("RUS", "Russland", "ru", "7", "0", "g");
INSERT INTO laender VALUES("SK", "Slowakei", "sk", "42", "0", "g");
INSERT INTO laender VALUES("SLO", "Slowenien", "sl", "255", "0", "g");
INSERT INTO laender VALUES("TJ", "Tadschikistan", "tj", "7", "0", "g");
INSERT INTO laender VALUES("TN", "Tunesien", "tn", "216", "0", "g");
INSERT INTO laender VALUES("TO", "Tonga", "to", "255", "0", "g");
INSERT INTO laender VALUES("UA", "Ukraine", "ua", "70", "0", "g");
INSERT INTO laender VALUES("UZB", "Usbekistan", "uz", "7", "0", "g");
INSERT INTO laender VALUES("VN", "Vietnam", "vn", "84", "0", "g");
INSERT INTO laender VALUES("YU", "Jugoslawien", "yu", "38", "0", "g");
INSERT INTO laender VALUES("ZA", "Suedafrika", "za", "27", "0", "g");
INSERT INTO laender VALUES("VRC", "Volksrepublik China", "vc", "86", "0", "g");
INSERT INTO laender VALUES("", "", NULL, NULL, NULL, "");