-- phpMyAdmin SQL Dump
-- version 2.6.2-Debian-3sarge3
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Erstellungszeit: 13. März 2007 um 10:25
-- Server Version: 4.0.24
-- PHP-Version: 5.2.0-8~bpo.2
-- 
-- Datenbank: `bigbelly`
-- 

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `tt_address`
-- 

CREATE TABLE `tt_address` (
  `module_sys_dmail_category` int(10) unsigned NOT NULL default '0',
  `module_sys_dmail_html` tinyint(3) unsigned NOT NULL default '0',
  `pid` int(11) unsigned NOT NULL default '0',
  `tstamp` int(11) unsigned NOT NULL default '0',
  `hidden` tinyint(4) unsigned NOT NULL default '0',
  `name` tinytext NOT NULL,
  `title` varchar(40) NOT NULL default '',
  `email` varchar(80) NOT NULL default '',
  `phone` varchar(30) NOT NULL default '',
  `mobile` varchar(30) NOT NULL default '',
  `www` varchar(80) NOT NULL default '',
  `address` tinytext NOT NULL,
  `company` varchar(80) NOT NULL default '',
  `city` varchar(80) NOT NULL default '',
  `zip` varchar(20) NOT NULL default '',
  `country` varchar(30) NOT NULL default '',
  `image` tinyblob NOT NULL,
  `fax` varchar(30) NOT NULL default '',
  `deleted` tinyint(3) unsigned NOT NULL default '0',
  `description` text NOT NULL,
  KEY `parent` (`pid`),
  KEY `pid` (`pid`,`email`)
) TYPE=MyISAM;