How do you create a table?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • eJM
    Senior Member
    • Sep 2004
    • 916
    • 3.8.x

    How do you create a table?

    Okay, I'm clueless. This is part of the 404.impex.readme.txt:
    You will need to create this table in your vBulletin database :

    CREATE TABLE `404_actions` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
    `time` INT UNSIGNED NOT NULL ,
    `incomming` VARCHAR( 250 ) NOT NULL ,
    `outgoing` VARCHAR( 250 ) NOT NULL ,
    `action` TINYINT UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY ( `id` )
    ) TYPE = MYISAM ;
    Exactly how do you do that? I do have access to phpMyAdmin and I can see the "Create a new table on database...". There's a place for the name and another for the number of fields, but I have a bad feeling that if I just take a wild guess the name is 404_actions, I still don't know how many fields there are, not to mention what any of that means or what input boxes to put it in, so I'd prob'y get database errors or even corrupt a perfectly good database trying.

    Can someone explain this a step at a time for me and anyone else who isn't exactly proficient in "database", but can follow directions really well?

    Thank you,

    Jim
    If my post was helpful to you, please take the time to register at my forum and ask a question you've always wanted to know about floors.
    www.TheFloorPro.com
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    Run this query in the SQL tab in phpMyAdmin:

    CREATE TABLE `404_actions` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
    `time` INT UNSIGNED NOT NULL ,
    `incomming` VARCHAR( 250 ) NOT NULL ,
    `outgoing` VARCHAR( 250 ) NOT NULL ,
    `action` TINYINT UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY ( `id` )
    ) TYPE = MYISAM ;
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    • eJM
      Senior Member
      • Sep 2004
      • 916
      • 3.8.x

      #3
      Thank you, Steve.
      If my post was helpful to you, please take the time to register at my forum and ask a question you've always wanted to know about floors.
      www.TheFloorPro.com

      Comment

      Related Topics

      Collapse

      Working...
      😀
      😂
      🥰
      😘
      🤢
      😎
      😞
      😡
      👍
      👎