phpBB.de

$sql = "CREATE TABLE " . $table_prefix . "qform_data (
q_id MEDIUMINT(11) DEFAULT '0' NOT NULL AUTO_INCREMENT,
question VARCHAR(255) NOT NULL,
answer_1 VARCHAR(255) NOT NULL,
answer_2 VARCHAR(255) NOT NULL,
answer_3 VARCHAR(255) NOT NULL,
answer_4 VARCHAR(255) NOT NULL,
bbcode_uid VARCHAR(32) NOT NULL,
points_1 SMALLINT(8) DEFAULT '0' NOT NULL,
points_2 SMALLINT(8) DEFAULT '0' NOT NULL,
points_3 SMALLINT(8) DEFAULT '0' NOT NULL,
points_4 SMALLINT(8) DEFAULT '0' NOT NULL,
group_id_1 MEDIUMINT(11) DEFAULT '0' NOT NULL,
group_id_2 MEDIUMINT(11) DEFAULT '0' NOT NULL,
group_id_3 MEDIUMINT(11) DEFAULT '0' NOT NULL,
group_id_4 MEDIUMINT(11) DEFAULT '0' NOT NULL,
sort SMALLINT(5) DEFAULT '0' NOT NULL,
PRIMARY KEY (q_id))";