HTML-Code:
#
# Table structure for table 'tx_tptest_items'
#
CREATE TABLE tx_tptest_items (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
title tinytext NOT NULL,
date int(11) DEFAULT '0' NOT NULL,
text text NOT NULL,
image blob NOT NULL,
link tinytext NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);