Zapytania SQL do wer. 1.1.6
[sql]CREATE TABLE phpbb_logs (
id_log MEDIUMINT(10) NOT NULL DEFAULT '0' AUTO_INCREMENT,
mode VARCHAR(50) NULL DEFAULT '',
topic_id MEDIUMINT(10) NULL DEFAULT '0',
user_id MEDIUMINT(8) NULL DEFAULT '0',
username VARCHAR(255) NULL DEFAULT '',
user_ip CHAR(8) DEFAULT '0' NOT NULL,
time INT(11) NULL DEFAULT '0',
PRIMARY KEY (id_log));
CREATE TABLE phpbb_logs_config (
config_name varchar(255) NOT NULL,
config_value varchar(255) NOT NULL,
PRIMARY KEY (config_name));
INSERT INTO phpbb_logs_config (
config_name, config_value)
VALUES ('all_admin', 0);
ALTER TABLE phpbb_users
ADD user_view_log TINYINT NOT NULL DEFAULT '0';[/sql]
Autor postu otrzymał pochwałę
Jak nie to nie, łaski bez...