SQL
Geplaatst: 29 aug 2003, 13:15
Ik wil ff een nieuwe shoubox proberen..
Ik moet dit allemaal in de SQL dumpen?
en daarna moet ik nog db_update.php openen?
Wat moet ik hiermee precies doen:
#
#-----[ ADD SQL ]------------------------------------------
#
# remember to add the prefix, you may run with, if in doubt, run the included db_update.php file
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))
#
#-----[ ADD SQL ]------------------------------------------
#
# remember to add the prefix, you may run with, if in doubt, run the included db_update.php file
INSERT IGNORE INTO forums (forum_id ,cat_id, forum_name, forum_desc, forum_status )
VALUES ("-101", "0", "SHOUTBOX_PAGE", "Shoutbox Page Control", 1 )
#
#-----[ ADD SQL ]------------------------------------------
#
INSERT INTO config (config_name, config_value) VALUES ("prune_shouts", "0")
Ik moet dit allemaal in de SQL dumpen?
en daarna moet ik nog db_update.php openen?
Wat moet ik hiermee precies doen:
#
#-----[ ADD SQL ]------------------------------------------
#
# remember to add the prefix, you may run with, if in doubt, run the included db_update.php file
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))
#
#-----[ ADD SQL ]------------------------------------------
#
# remember to add the prefix, you may run with, if in doubt, run the included db_update.php file
INSERT IGNORE INTO forums (forum_id ,cat_id, forum_name, forum_desc, forum_status )
VALUES ("-101", "0", "SHOUTBOX_PAGE", "Shoutbox Page Control", 1 )
#
#-----[ ADD SQL ]------------------------------------------
#
INSERT INTO config (config_name, config_value) VALUES ("prune_shouts", "0")