phpBB2 by Przemo

[Jazz_01]

Wcięło mi tabelę topics. Przeinstalowanie forum trwa wieki, bo mam obecnie bardzo wolny internet. Bardzo proszę o podanie zapytania do bazy, które utworzy mi nową tabelę.

[Gadatliwa Kasia]

[Woytec]

[Jazz_01]

Tak wiem, ale niestety wyszło jak wyszło. Wystarczy mi pusta tabela.


A czy na podstawie tabeli posts da się odtworzyć topics?

[Woytec]

Kod:

CREATE TABLE phpbb_topics (   topic_id mediumint(8) UNSIGNED NOT NULL auto_increment,   forum_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL,   topic_title char(60) NOT NULL default '',   topic_poster mediumint(8) DEFAULT '0' NOT NULL,   topic_time int(11) DEFAULT '0' NOT NULL,   topic_views mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,   topic_replies mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,   topic_status tinyint(1) DEFAULT '0' NOT NULL,   topic_vote tinyint(1) DEFAULT '0' NOT NULL,   topic_type tinyint(1) DEFAULT '0' NOT NULL,   topic_first_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,   topic_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,   topic_moved_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,   topic_attachment tinyint(1) DEFAULT '0' NOT NULL,   topic_icon tinyint(2) UNSIGNED DEFAULT '0' NOT NULL,   topic_expire int(11) DEFAULT '0' NOT NULL,   topic_color varchar(8) DEFAULT NULL,   topic_title_e char(100) NOT NULL DEFAULT '',   topic_action tinyint(1) DEFAULT '0',   topic_action_user mediumint(8) NOT NULL DEFAULT '0',   topic_action_date int(11) DEFAULT '0' NOT NULL,   topic_tree_width smallint(2) DEFAULT '0' NOT NULL,   topic_accept TINYINT( 1 ) NOT NULL DEFAULT '1',   PRIMARY KEY (topic_id),   KEY forum_id (forum_id),   KEY topic_moved_id (topic_moved_id),   KEY topic_status (topic_status),   KEY topic_type (topic_type),   KEY topic_poster (topic_poster),   KEY topic_last_post_id (topic_last_post_id),   KEY topic_first_post_id (topic_first_post_id),   KEY topic_vote (topic_vote) ) DEFAULT CHARSET latin2 COLLATE latin2_general_ci;