Need Help with adding sql files

  Post new topicReply to topicPrintable Version
<< View previous topic View next topic >>
Share: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
#1   Need Help with adding sql files
WeigelRich
CZ Active Member
WeigelRich has been a member for over 19 year's 19 Year Member
usa.gif pennsylvania.gif
Occupation: Safety Specialist
Age: 45
Gender: Male
Website:
Status: Offline
Joined: Jul 06, 2005
0.02 posts per day
Posts: 123
Points: 4,498
 Yahoo Messenger MSN Messenger 
Hello,

I am not very good with sql files. Well I know how to load them when it is a SQL Dump. I don't know how to upload them when it is in an install file or how to open and edit them. Is there anyway to make an SQL dump for this or could someone possible explain how to do it. Here is the text.

#
#-----[ ADD SQL ]------------------------------------------
#
# Remember to change the table prefix used on your database
CREATE TABLE `phpbb_medal` (
  `medal_id` mediumint(8) NOT NULL auto_increment,
  `cat_id` mediumint(8) unsigned NOT NULL default '1',
  `medal_name` varchar(40) NOT NULL default '',
  `medal_description` varchar(255) NOT NULL default '',
  `medal_image` varchar(40) default NULL,
  PRIMARY KEY  (`medal_id`)
) TYPE=MyISAM;

#
#-----[ ADD SQL ]------------------------------------------
#
# Remember to change the table prefix used on your database
CREATE TABLE `nuke_phpbb_medal_user` (
  `issue_id` mediumint(8) NOT NULL auto_increment,
  `medal_id` mediumint(8) NOT NULL default '',
  `user_id` mediumint(8) NOT NULL default '',
  `issue_reason` varchar(255) NOT NULL default '',
  `issue_time` int(11) NOT NULL default '',
  PRIMARY KEY  (`issue_id`)
) TYPE=MyISAM;

#
#-----[ ADD SQL ]------------------------------------------
#
# Remember to change the table prefix used on your database
CREATE TABLE `nuke_phpbb_medal_mod` (
  `mod_id` mediumint(8) unsigned NOT NULL auto_increment,
  `medal_id` mediumint(8) NOT NULL default '',
  `user_id` mediumint(8) NOT NULL default '',
  PRIMARY KEY  (`mod_id`)
) TYPE=MyISAM;

#
#-----[ ADD SQL ]------------------------------------------
#
# Remember to change the table prefix used on your database
CREATE TABLE `nuke_phpbb_medal_cat` (
  `cat_id` mediumint(8) unsigned NOT NULL auto_increment,
  `cat_title` varchar(100) NOT NULL default '',
  `cat_order` mediumint(8) UNSIGNED NOT NULL default '0',
  PRIMARY KEY  (`cat_id`),
  KEY `cat_order` (`cat_order`) 
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
#-----[ ADD SQL ]------------------------------------------
#
# Remember to change the table prefix used on your database
INSERT INTO `phpbb_config` VALUES ('allow_medal_dispaly', '0');
INSERT INTO `phpbb_config` VALUES ('medal_display_row', '1');
INSERT INTO `phpbb_config` VALUES ('medal_display_col', '1');
INSERT INTO `phpbb_config` VALUES ('medal_display_width', '');
INSERT INTO `phpbb_config` VALUES ('medal_display_height', '');
INSERT INTO `phpbb_config` VALUES ('medal_display_order', '');
INSERT INTO `phpbb_medal_cat` VALUES ('1', 'Default', '10');


I don't know what change the table prefix used on your database. What is the table prefix. Insert Into lines I have no idea at all how to add them in.

Thanks for the help in advance.



_________________
Back to top Reply with quote
#2   re: Need Help with adding sql files
Kelly_Hero
PayPal Donation
CZ Revered Member
 Codezwiz Site Donator
usa.gif southcarolina.gif
Occupation: Web Developer
Age: 59
Gender: Female
Website:
Status: Offline
Joined: Aug 20, 2003
0.49 posts per day
Posts: 3765
Points: 351,412
   
This should help you.
[ Register or login to view links on this board. ]

Your table prefix comes from your config.php page. I think the default is set to "nuke".
You can check your config file to make sure.

$prefix = "nuke";



Back to top Reply with quote
Display posts from previous:      
Add To: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
<< View previous topic View next topic >>
Post new topicReply to topic

Jump to 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum