Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

deleting some some code from SQL database


sinryder

Recommended Posts

Posted

hello i ran this sql while installing pwa contribution ( need no account to checkout )

 

now i have installed amazon login script and want to remove all files from pwa

 

can some on help me remove the sql code that i ran in phpmyadmin

below is the copy of the code that i installed.

 

 

STEP 3:

 

Go into your server's backend and use a SQL tool such as PHPMYADMIN to run the following SQL scripts. Make sure you have backed up your database first:

 

ALTER TABLE customers ADD purchased_without_account TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL AFTER customers_id;

ALTER TABLE customers ADD INDEX (purchased_without_account);

INSERT INTO configuration_group VALUES (40, 'Accounts', 'Configuration of Account settings', 40, 1);

INSERT INTO configuration VALUES ('', 'Purchase Without Account', 'PWA_ON', 'true', 'Allow Customers to purchase without an account', 40, 1, '2003-04-08 13:07:44', '2003-04-08 12:10:51', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');

ALTER TABLE orders ADD purchased_without_account TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL;

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...