Jak zrobic tabele?

[Revan7]

Aby zainstalowac shoutboxa, musze zrobic tabele w SQL, ale nie wiem jak ta tabele zrobic... moglby mi ktos napisac krok po kroku gdzie klikac zeby ja zrobic i jakie dane? powpisywac? z gory thx

[MSX2]

Nigdy nie rozumiałem, po jaką cholerę do forum wciskać takie bezsensowne mody, jak shoutbox chociażby.
Heh, powiedz przynajmniej czy chodzi ci o shoutboxa by przemo, z downloadu phpbb2.pl ?

[Revan7]

Tak, chodzi mi o shoutbox by przemo

[MSX2]

Oto kod tabel (ale to chyba wiesz, co nie?):

Kod: Zaznacz cały

CREATE TABLE phpbb_shoutbox (
  id int(11) NOT NULL auto_increment,
  sb_user_id int(11) NOT NULL,
  msg varchar(255) NOT NULL,
  timestamp int(10) unsigned NOT NULL,
  sb_username varchar(255) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE phpbb_shoutbox_config ( 
    config_name varchar(255) NOT NULL, 
    config_value varchar(255) NOT NULL, 
    PRIMARY KEY (config_name)
);

INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_guest_view','1');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_guest','0');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_delete_all','0');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_delete','0');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_edit_all','0');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_edit','0');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_bbcode','1');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_smilies','1');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('links_names','1');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('make_links','1');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('count_msg','100');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('delete_days','30');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('text_lenght','500');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('word_lenght','90');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('date_format','D G:i');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('date_on','1');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('shoutbox_on','1');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('shout_width','630');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('shout_height','130');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('banned_user_id','');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('banned_user_id_view','');

a utworzyć ją możesz poprzez phpMyAdmin i opcję SQL...