|
-- 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;
|