phpBB2 by Przemo

[mateyko]

NIechcący usunąłem tabelę stats_modules' doesn't exist i przez to niedziałają statystyki. chciałbym wrzucić pustą, nie zależy mi na starych statystykach.

Próbowałem przez polecenie create table lecz nie znam jej struktury :I

[Gadatliwa Kasia]

[m@rcin...]

Kod:

CREATE TABLE phpbb_stats_modules (   module_id tinyint(8) NOT NULL DEFAULT '0',   name varchar(150) NOT NULL DEFAULT '',   active tinyint(1) NOT NULL DEFAULT '0',   installed tinyint(1) NOT NULL DEFAULT '0',   display_order mediumint(8) UNSIGNED NOT NULL DEFAULT '0',   update_time mediumint(8) UNSIGNED NOT NULL DEFAULT '0',   auth_value tinyint(2) NOT NULL DEFAULT '0',   module_info_cache blob,   module_db_cache blob,   module_result_cache blob,   module_info_time int(10) UNSIGNED NOT NULL DEFAULT '0',   module_cache_time int(10) UNSIGNED NOT NULL DEFAULT '0',   PRIMARY KEY (module_id) ); INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (1, 'new_posts_by_month', 1, 1, 10, 24, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0'); INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (2, 'new_topics_by_month', 1, 1, 20, 24, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0'); INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (3, 'new_users_by_month', 1, 1, 30, 24, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0'); INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (4, 'most_active_topics', 1, 1, 40, 0, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0'); INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (5, 'most_viewed_topics', 1, 1, 50, 0, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0'); INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (6, 'latest_topics', 1, 1, 60, 0, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0'); INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (7, 'priv_msgs', 1, 1, 70, 48, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0'); INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (8, 'top_posters', 1, 1, 80, 24, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0'); INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (9, 'last_active_users', 1, 1, 90, 0, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0'); INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (10, 'users_from_where', 1, 1, 100, 48, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0'); INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (11, 'age_statistics', 1, 1, 110, 48, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0'); INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (12, 'users_gender', 1, 1, 120, 48, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0'); INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (13, 'top_smilies', 1, 1, 130, 64, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0'); INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (14, 'top_words', 1, 1, 140, 64, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0'); INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (15, 'user_agent', 1, 1, 150, 64, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0');

Jeśli masz kopie bazy to przywróć