Metatron Posted March 10, 2006 Posted March 10, 2006 Hello Everybody! I am installing the contribution protx_direct and need help running the SQL code as I am not sure how to put it in PhpMyAdmin. In PhpMyAdmin do I click on the 'Query' button at the top of my databases main page and then insert the code into the "SQL query on database MY_DATABASE" text area and then click the submit query button? BTW the code is: CREATE TABLE `protx_direct` ( `id` int(11) unsigned NOT NULL auto_increment, `customer_id` int(11) NOT NULL default '0', `order_id` int(11) NOT NULL default '0', `vpstxid` varchar(50) NOT NULL default '0', `status` varchar(10) default NULL, `statusdetail` varchar(100) default NULL, `txauthno` varchar(10) NOT NULL default '0', `securitykey` varchar(50) NOT NULL default '0', `avscv2` varchar(50) NOT NULL default '0', `address_result` varchar(20) NOT NULL default '0', `postcode_result` varchar(20) NOT NULL default '0', `CV2_result` varchar(20) NOT NULL default '0', UNIQUE KEY `id` (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ;
gscreations Posted March 10, 2006 Posted March 10, 2006 Hello Everybody! I am installing the contribution protx_direct and need help running the SQL code as I am not sure how to put it in PhpMyAdmin. In PhpMyAdmin do I click on the 'Query' button at the top of my databases main page and then insert the code into the "SQL query on database MY_DATABASE" text area and then click the submit query button? BTW the code is: CREATE TABLE `protx_direct` ( `id` int(11) unsigned NOT NULL auto_increment, `customer_id` int(11) NOT NULL default '0', `order_id` int(11) NOT NULL default '0', `vpstxid` varchar(50) NOT NULL default '0', `status` varchar(10) default NULL, `statusdetail` varchar(100) default NULL, `txauthno` varchar(10) NOT NULL default '0', `securitykey` varchar(50) NOT NULL default '0', `avscv2` varchar(50) NOT NULL default '0', `address_result` varchar(20) NOT NULL default '0', `postcode_result` varchar(20) NOT NULL default '0', `CV2_result` varchar(20) NOT NULL default '0', UNIQUE KEY `id` (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; Yes, some phpmyadmin have different buttons, some use Query some use SQL but all have a help file which will give you the answers you need.
jasonabc Posted March 10, 2006 Posted March 10, 2006 Select the OSC database in PhpMyAdmin and then click the SQL button at the top (*not* the Query one). Paste that CREATE statement in the box and hit "Go". Jason My Contributions: Paypal Payflow PRO | Rollover Category Images | Authorize.net Invoice Number Fix
Metatron Posted March 10, 2006 Author Posted March 10, 2006 Select the OSC database in PhpMyAdmin and then click the SQL button at the top (*not* the Query one). Paste that CREATE statement in the box and hit "Go". Thankyou Jason. That was the answer I was looking for. :thumbsup:
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.