Wersje 1.9 i starsze - [problem sql] brak read_history
paniczow - 18-11-2005, 19:52 Temat postu: [problem sql] brak read_history 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ć??
Hlopcyk - 18-11-2005, 20:01
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...
|
|
|