Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Help Running SQL query


bmac

Recommended Posts

Hey all,

 

I'm trying to install the Purchase Orders 1.4 contribution and need to run a few SQL queries. However, I'm pretty useless with SQL and am not sure about the specifics. Here are the instructions:

 

 

---------------- 1. -------------------

Table: customers

 

Need to do:

 

Addition of column 'customers_allow_purchase_order_entry'

varchar(6)

NOT NULL

Default value = 'false'

 

---------------- 2. -------------------

Table: orders

 

Need to do:

 

Addition of column 'purchase_order_number'

varchar(12)

NULL

No default value

 

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

 

Could someone please show me what precise strings (?) I need to pop into the phpmyadmin text box? THANK YOU!

 

best,

 

Brian

Link to comment
Share on other sites

did the contribution come with a sql file or dies it have the exact sql statement to run?

if not, you will need to go in via phpmyadmin and edit the tables listed and add them manually, click on the table and then there should be a spot where you can add a field at the end of the table.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...