phpBB2 by Przemo

[paniczow]

Jak mogę przez zapytanie utworzyc tabelę

read_history

??

Kod:

CREATE TABLE `phpbb_read_history` (   ` user_id` tinyint(5) NOT NULL default '0',   ` topic_id` text NOT NULL, );

coś takiego ale nie wiem jak co mam wpisać??

[Gadatliwa Kasia]

[Hlopcyk]

Kod:

CREATE TABLE phpbb_read_history (   user_id mediumint(8) NOT NULL DEFAULT '0',   forum_id smallint(5) UNSIGNED NOT NULL DEFAULT '0',   topic_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',   post_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',   post_time int(11) NOT NULL DEFAULT '0',   PRIMARY KEY (user_id, forum_id, topic_id, post_id, post_time),   KEY user_id (user_id),   KEY forum_id (forum_id),   KEY topic_id (topic_id) );

takie zapytanie w phpMyAdminie...