Creating a new table...
Date: 05/06/06
(MySQL Communtiy) Keywords: php, sql
Ok, I'm a newbie at this so I'm not sure what to do. I've got a MOD for a phpBB forum I run, and it says the following:
#-----[ SQL ]------------------------------------------
#
CREATE TABLE phpbb_invitations (
invitation_id MEDIUMINT( 8 ) NOT NULL AUTO_INCREMENT ,
invitation_code VARCHAR( 8 ) NOT NULL ,
invitation_description TEXT NOT NULL,
invitation_uses MEDIUMINT(8) NOT NULL DEFAULT '1',
invitation_group MEDIUMINT(8) NOT NULL DEFAULT '0',
invitation_email TEXT NOT NULL,
PRIMARY KEY ( invitation_id )
);
CREATE TABLE phpbb_invitation_users (
invitation_id MEDIUMINT( 8 ) NOT NULL,
user_id MEDIUMINT( 8 ) NOT NULL,
PRIMARY KEY ( user_id )
);
INSERT INTO phpbb_config ( config_name , config_value )
VALUES ('invite_only', '1');
I'm not sure how to do this, but I'm thinking that I have to go into the phpMyAdmin on my server and create the "phpbb_invitations" table first, then past in this code.... right? Wrong?
Much thanks in advance for you help.
Kristi
Source: http://community.livejournal.com/mysql/94911.html