Kód: Vybrat vše
#-----[ SQL ]------------------------------------------
#
INSERT INTO `phpbb_config` VALUES ('shoutbox_floodinterval', '3');
INSERT INTO `phpbb_config` VALUES ('display_shouts', '10');
INSERT INTO `phpbb_config` VALUES ('stored_shouts', '25');
INSERT INTO `phpbb_config` VALUES ('shoutbox_refreshtime', '4000');
INSERT INTO `phpbb_config` VALUES ('shout_allow_guest', '1');
CREATE TABLE phpbb_shoutbox (
shout_id MEDIUMINT(9) UNSIGNED NOT NULL AUTO_INCREMENT,
user_id MEDIUMINT(8) NOT NULL,
shouter_name VARCHAR(30) NOT NULL DEFAULT 'guest',
shout_text TEXT NOT NULL,
shouter_ip VARCHAR(8) NOT NULL DEFAULT '',
shout_uid VARCHAR(10) NOT NULL DEFAULT '',
shout_time INT(11) NOT NULL,
PRIMARY KEY ( shout_id )
);
CREATE TABLE `phpbb_shoutbox_sessions` (
`session_id` int(10) NOT NULL auto_increment,
`session_user_id` mediumint(8) NOT NULL default '0',
`session_username` varchar(25) NOT NULL default '',
`session_ip` varchar(8) NOT NULL default '0',
`session_start` int(11) NOT NULL default '0',
`session_time` int(11) NOT NULL default '0',
PRIMARY KEY (`session_id`)
);
#
Děkuji.