Hard Light Productions Forums

Off-Topic Discussion => General Discussion => Topic started by: Hippo on February 13, 2005, 08:04:31 am

Title: I suck at sql! Help!
Post by: Hippo on February 13, 2005, 08:04:31 am

Ok, i downloaded phpMyAdmin 2.6.1 off their site, and i have to execute the following:

Code: [Select]


#
#-----[ SQL ]------------------------------------------
#
CREATE TABLE `phpbb_faq` (
  `lang_id` varchar(50) NOT NULL default 'english',
  `faq_id` tinyint(11) NOT NULL default '0',
  `faq_title` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`faq_id`,`lang_id`)
) TYPE=MyISAM;

#
#-----[ SQL ]------------------------------------------
#
CREATE TABLE `phpbb_faq_text` (
  `lang_id` varchar(50) NOT NULL default 'english',
  `q_id` tinyint(11) NOT NULL default '0',
  `faq_id` tinyint(11) NOT NULL default '0',
  `q` text NOT NULL,
  `a` text NOT NULL,
  PRIMARY KEY  (`q_id`,`lang_id`)
) TYPE=MyISAM;

#
#-----[ SQL ]------------------------------------------
#
CREATE TABLE `phpbb_bbcode` (
  `lang_id` varchar(50) NOT NULL default 'english',
  `faq_id` tinyint(11) NOT NULL default '0',
  `faq_title` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`faq_id`,`lang_id`)
) TYPE=MyISAM;

#
#-----[ SQL ]------------------------------------------
#
CREATE TABLE `phpbb_bbcode_text` (
  `lang_id` varchar(50) NOT NULL default 'english',
  `q_id` tinyint(11) NOT NULL default '0',
  `faq_id` tinyint(11) NOT NULL default '0',
  `q` text NOT NULL,
  `a` text NOT NULL,
  PRIMARY KEY  (`q_id`,`lang_id`)
) TYPE=MyISAM;



And I can't even ge phpmyadmin to RUN anything, let alone how to use it, since the documentation didn't even tell me how to install or start it... Help!

Title: I suck at sql! Help!
Post by: MatthewPapa on February 13, 2005, 08:37:17 am

I have lots of experience with mySQL getting GW to work and all with as many times as we have switched hosts.  I may be able to help.

First question, what exactly are you tring to do first of all?
Second question, do you have acces too ssh.

Title: I suck at sql! Help!
Post by: Register on February 13, 2005, 08:38:31 am

I'd help, but I'm banned.

Title: I suck at sql! Help!
Post by: Hippo on February 13, 2005, 08:39:40 am

:wtf: @ Register

wait...

its...


*goes on NW IRC and contacts MP at same time*

Title: I suck at sql! Help!
Post by: Hippo on February 13, 2005, 09:23:06 am

Ok... We got it working, so i'm good now

Title: I suck at sql! Help!
Post by: Taristin on February 13, 2005, 09:28:25 am

I'm waiting to laugh at the first person to give Register the welcome beam. :p

Title: I suck at sql! Help!
Post by: Primus on February 13, 2005, 09:55:21 am

Quote

Originally posted by Raa
I'm waiting to laugh at the first person to give Register the welcome beam. :p

Already happened.. (I didn't do it)

Title: I suck at sql! Help!
Post by: Taristin on February 13, 2005, 09:56:48 am

Such trigger happy fools... :p