#
# Table structure for table 'tx_p123_motive'
#
CREATE TABLE tx_p123_motive (
	uid int(11) DEFAULT '0' NOT NULL auto_increment,
	pid int(11) DEFAULT '0' NOT NULL,
	tstamp int(11) unsigned DEFAULT '0' NOT NULL,
	crdate int(11) unsigned DEFAULT '0' NOT NULL,
	fe_cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
	hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
	deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
	
	sid int(11) DEFAULT '0' NOT NULL,
	hash varchar(32) DEFAULT '' NOT NULL,
	format varchar(10) DEFAULT '' NOT NULL,
	format_desc mediumtext NOT NULL,
	poster tinytext NOT NULL,
	preview blob NOT NULL,
	poster_later tinyint(4) unsigned DEFAULT '0' NOT NULL,
	poster_description text NOT NULL,
	postercount tinyint(4) DEFAULT '0' NOT NULL,
	spare tinyint(4) unsigned DEFAULT '0' NOT NULL,
	additional int(11) unsigned DEFAULT '0' NOT NULL,
	no_production tinyint(4) unsigned DEFAULT '0' NOT NULL,
	
	PRIMARY KEY (uid),
	KEY parent (pid)
);