#
# Table structure for table 'tx_webdispo'
#
CREATE TABLE tx_webdispo (
	poster tinytext NOT NULL,
	spare tinyint(4) unsigned DEFAULT '0' NOT NULL,
	additional int(11) unsigned DEFAULT '0' NOT NULL,
	expose int(11) unsigned DEFAULT '0' NOT NULL,
	exclude tinyint(4) unsigned DEFAULT '0' NOT NULL,
	revocation tinyint(4) unsigned DEFAULT '0' NOT NULL,
	printing tinyint(4) unsigned DEFAULT '0' NOT NULL,
	terms int(11) DEFAULT '0' NOT NULL,
	name varchar(80) DEFAULT '' NOT NULL,
	address tinytext NOT NULL,
	telephone varchar(20) DEFAULT '' NOT NULL,
	fax varchar(20) DEFAULT '' NOT NULL,
	email varchar(80) DEFAULT '' NOT NULL,
	title varchar(40) DEFAULT '' NOT NULL,
	zip varchar(10) DEFAULT '' NOT NULL,
	city varchar(50) DEFAULT '' NOT NULL,
	company varchar(80) DEFAULT '' NOT NULL,
	firstname varchar(80) DEFAULT '' NOT NULL,
#	bankname varchar(40) DEFAULT '' NOT NULL,
#	bankcode varchar(10) DEFAULT '' NOT NULL,
#	bankaccount varchar(20) DEFAULT '' NOT NULL,
#	bankowner varchar(80) DEFAULT '' NOT NULL,
#	deliveryname varchar(80) DEFAULT '' NOT NULL,
#	deliveryaddress tinytext NOT NULL,
#	deliverytitle varchar(40) DEFAULT '' NOT NULL,
#	deliveryzip varchar(10) DEFAULT '' NOT NULL,
#	deliverycity varchar(50) DEFAULT '' NOT NULL,
#	deliverycompany varchar(80) DEFAULT '' NOT NULL,
#	deliveryfirstname varchar(80) DEFAULT '' NOT NULL,
	poster_description varchar(80) DEFAULT '' NOT NULL,
	companyname varchar(80) DEFAULT '' NOT NULL,
	companybranch varchar(80) DEFAULT '' NOT NULL,
	companyproduct varchar(80) DEFAULT '' NOT NULL,
	companycampaign tinyint(4) DEFAULT '0' NOT NULL,
	companycampaign_name text NOT NULL,
	motifready tinyint(4) unsigned DEFAULT '0' NOT NULL,
	motifname varchar(80) DEFAULT '' NOT NULL,
	motifworktitle varchar(80) DEFAULT '' NOT NULL,
	motifhelp tinyint(4) unsigned DEFAULT '0' NOT NULL,
	printoption tinyint(4) unsigned DEFAULT '0' NOT NULL,
	printterms tinyint(4) unsigned DEFAULT '0' NOT NULL,
	excel blob NOT NULL,
	xml blob NOT NULL,
	message text NOT NULL,
	printdata tinyint(4) DEFAULT '0' NOT NULL,
	picture_1 varchar(255) DEFAULT '' NOT NULL,
	picture_8 varchar(255) DEFAULT '' NOT NULL,
	picture_18 varchar(255) DEFAULT '' NOT NULL,
	picture_36 varchar(255) DEFAULT '' NOT NULL,
	picture_40 varchar(255) DEFAULT '' NOT NULL,
	messages text NOT NULL,
	reserve tinyint(4) unsigned DEFAULT '0' NOT NULL,
);

#
# Table structure for table 'fe_users'
#
CREATE TABLE fe_users (
	firstname varchar(80) DEFAULT '' NOT NULL,
);