SQL file

Nuke Soldier Joined: Apr 24, 2003 Posts: 34

i'm trying to install the shoutbox for phpbb and I'd like to ask because I was trying to do it on my own but I got an error

what is the right syntax to incorporate

Code:

INSERT IGNORE INTO forums (forum_id ,cat_id, forum_name, forum_desc, forum_status )
VALUES ("-101", "0", "SHOUTBOX_PAGE", "Shoutbox Page Control", 1 )

in an sql file (i.e. shout.sql)

I tried

Code:

INSERT IGNORE INTO nuke_bbforums VALUES ("-101", "0", "SHOUTBOX_PAGE", "Shoutbox Page Control", 1 );

but got an error

also

Code:

CREATE TABLE shout (
shout_id MEDIUMINT(8) UNSIGNED NOT NULL auto_increment,
shout_username VARCHAR(25) NOT NULL,
shout_user_id MEDIUMINT(8) NOT NULL,
shout_group_id MEDIUMINT(8) NOT NULL,
shout_session_time INT(11) NOT NULL,
shout_ip CHAR(8) NOT NULL,
shout_text VARCHAR(255) NOT NULL,
shout_active MEDIUMINT(8) NOT NULL,
enable_bbcode TINYINT (1) NOT NULL,
enable_html TINYINT (1) NOT NULL,
enable_smilies TINYINT (1) NOT NULL,
enable_sig TINYINT (1) NOT NULL,
shout_bbcode_uid VARCHAR(10) NOT NULL,
INDEX (shout_id))

and made to

Code:

CREATE TABLE nuke_shout (
shout_id MEDIUMINT(8) UNSIGNED NOT NULL auto_increment,
shout_username VARCHAR(25) NOT NULL,
shout_user_id MEDIUMINT(8) NOT NULL,
shout_group_id MEDIUMINT(8) NOT NULL,
shout_session_time INT(11) NOT NULL,
shout_ip CHAR(8) NOT NULL,
shout_text VARCHAR(255) NOT NULL,
shout_active MEDIUMINT(8) NOT NULL,
enable_bbcode TINYINT (1) NOT NULL,
enable_html TINYINT (1) NOT NULL,
enable_smilies TINYINT (1) NOT NULL,
enable_sig TINYINT (1) NOT NULL,
shout_bbcode_uid VARCHAR(10) NOT NULL,
INDEX (shout_id))

I didn't get an error on this part but was it enough because I saw other sql files with Type ISAM (??)

Thanks in advance.