#
# Table structure for table 'tx_p123'
#
CREATE TABLE tx_p123 (
	postercount tinyint(4) unsigned DEFAULT '0' 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,
	datasecurity 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,
	excel blob NOT NULL,
	xml blob NOT NULL,
	message text NOT NULL,
	litomobil tinyblob NOT NULL,
	poster_later tinyint(4) unsigned DEFAULT '0' NOT NULL,
	poster_description text NOT NULL,
	note text NOT NULL,
	express tinyint(4) unsigned DEFAULT '0' NOT NULL,
);

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