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

« moving hosts || Mysql Question... »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home