Code: Select all
CREATE TABLE phpbb_profile_config (
config_name VARCHAR(255) NOT NULL DEFAULT '',
config_value VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (config_name)
);
INSERT INTO phpbb_profile_config VALUES('icq','0');
INSERT INTO phpbb_profile_config VALUES('website','0');
INSERT INTO phpbb_profile_config VALUES('location','0');
INSERT INTO phpbb_profile_config VALUES('signature','0');
INSERT INTO phpbb_profile_config VALUES('aim','0');
INSERT INTO phpbb_profile_config VALUES('yim','0');
INSERT INTO phpbb_profile_config VALUES('msnm','0');
INSERT INTO phpbb_profile_config VALUES('occupation','0');
INSERT INTO phpbb_profile_config VALUES('interests','0');
#
Code: Select all
INSERT INTO phpbb_profile_config VALUES('icq','0');
INSERT INTO phpbb_profile_config VALUES('website','0');
INSERT INTO phpbb_profile_config VALUES('location','0');
INSERT INTO phpbb_profile_config VALUES('signature','0');
INSERT INTO phpbb_profile_config VALUES('aim','0');
INSERT INTO phpbb_profile_config VALUES('yim','0');
INSERT INTO phpbb_profile_config VALUES('msnm','0');
INSERT INTO phpbb_profile_config VALUES('occupation','0');
INSERT INTO phpbb_profile_config VALUES('interests','0');
Code: Select all
#
#-----[ SQL ]------------------------------------------
#
# Remember to change the table prefix used on your database
Code: Select all
#-----[ SQL ]------------------------------------------
#
# Remember to change the table prefix used on your database
CREATE TABLE wasc.phpbb_profile_config (
config_name VARCHAR(255) NOT NULL DEFAULT '',
config_value VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (config_name)
);
INSERT INTO phpbb_profile_config VALUES('icq','0');
INSERT INTO phpbb_profile_config VALUES('website','0');
INSERT INTO phpbb_profile_config VALUES('location','0');
INSERT INTO phpbb_profile_config VALUES('signature','0');
INSERT INTO phpbb_profile_config VALUES('aim','0');
INSERT INTO phpbb_profile_config VALUES('yim','0');
INSERT INTO phpbb_profile_config VALUES('msnm','0');
INSERT INTO phpbb_profile_config VALUES('occupation','0');
INSERT INTO phpbb_profile_config VALUES('interests','0');
#
Code: Select all
#-----[ SQL ]------------------------------------------
#
# Remember to change the table prefix used on your database
CREATE TABLE phpbb_profile_config (
config_name VARCHAR(255) NOT NULL DEFAULT '',
config_value VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (config_name)
);
INSERT INTO phpbb_profile_config VALUES('icq','0');
INSERT INTO phpbb_profile_config VALUES('website','0');
INSERT INTO phpbb_profile_config VALUES('location','0');
INSERT INTO phpbb_profile_config VALUES('signature','0');
INSERT INTO phpbb_profile_config VALUES('aim','0');
INSERT INTO phpbb_profile_config VALUES('yim','0');
INSERT INTO phpbb_profile_config VALUES('msnm','0');
INSERT INTO phpbb_profile_config VALUES('occupation','0');
INSERT INTO phpbb_profile_config VALUES('interests','0');
#
Code: Select all
$table_prefix = 'phpbb_';
Code: Select all
$dbname = 'wasc';