Executing MYSQL code through phpmyadmin

[lironofer]

Hi There

 

I'm trying to install the credit card with CVV2 module, and I had this part in the installation but couldn't understand how to do it:

 

2) Execute the following MYSQL code in your database using phpMyAdmin or similar utility:

(Note: If you don't know how to do this then ask in the forums, most anyone can explain it.)

 

ALTER TABLE `orders` ADD `cc_cvv2` VARCHAR(4) AFTER `cc_expires`;

 

# NEW for version 2.3

DROP TABLE IF EXISTS credit_cards;

CREATE TABLE credit_cards (

card_id int NOT NULL auto_increment,

credit_card_name varchar(70) NOT NULL,

pattern varchar(255) NOT NULL,

accept_card enum('no', 'yes') NOT NULL default 'no',

sort_order tinyint default '0',

logo_image varchar(64) default null,

cvv_length tinyint unsigned not null default 0 comment '0 means not used for this card',

PRIMARY KEY (card_id)

);

 

# Regular expression patterns from http://www.creditcardcode.net

INSERT INTO credit_cards VALUES (1,'American Express','/^(34|37)\\d{13}$/','no','4','Amex_logo.jpeg',4);

INSERT INTO credit_cards VALUES (2,'Diners Club','/^(30|36|38)\\d{12}$/','no','5','Diners_Club_logo.jpeg',3);

INSERT INTO credit_cards VALUES (3,'JCB','/^((2131|1800)\\d{11}|3[0135]\\d{14})$/','no','9','JCB_logo.gif',3);

INSERT INTO credit_cards VALUES (4,'MasterCard','/^5[1-5]\\d{14}$/','yes','2','MasterCard_logo.gif',3);

INSERT INTO credit_cards VALUES (5,'Visa','/^4\\d{12}(\\d{3})?$/','yes','1','Visa_logo.gif',3);

INSERT INTO credit_cards VALUES (6,'Discover','/^6011\\d{12}$/','no','3','Discover_logo.jpg',3);

INSERT INTO credit_cards VALUES (7,'Solo','/^(6334|6767)\\d{12}(\\d{2,3})?$/','no','9','Solo_logo.gif',0);

INSERT INTO credit_cards VALUES (8,'Switch','/^(4903|4905|4911|4936|5641|6331|6333|6759)\\d{12}(\\d{2,3})?$/','no','9','Switch_card_logo.jpg',0);

INSERT INTO credit_cards VALUES (9,'Laser','/^(6304|6706|6771|6709)\\d{12}(\\d{1,3})?$/','no','9','Laser_card_logo.jpeg',0);

INSERT INTO credit_cards VALUES (10,'Maestro','/^(5018|5020|5038|6304|6759|6761|6763)\\d{8}(\\d{1,7})?$/','no','9','Maestro_logo.jpeg',0);

INSERT INTO credit_cards VALUES (11,'Saferpay Test Card','/^9451123100000004$/','no','127',null,0);

 

----------------------------------------------------------------------

 

Could someone please explain me what to do step by step?

 

Many thanks!

[Mort-lemur]

OK,

 

Go to your host control panel.

 

Open phpmyadmin

 

select your database on the left of the screen.

 

Select the "SQL" tab (in the middle towards the top)

 

Paste the contents of the sql file into the box that opens.

 

click on the "go" button.

 

you will get a message of either success or error.

 

Thanks

[lironofer]

Thank you very much, wish I knew it's that simple :-)

[Mort-lemur]

no problem,

 

But to handle CC Data on your store you need to be PCI compliant - just a comment.

[lironofer]

Sure, thanks.