Bazy danych SQL - Jak utworzyć pustą tabelę stats_modules?
mateyko - 28-11-2007, 11:03
Temat postu: Jak utworzyć pustą tabelę stats_modules?
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
m@rcin... - 28-11-2007, 11:11
| 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óć 
|
|
|
