Updating SQL for PO number

[stevemkrenz]

I installed the Puchase Order Number contribution and it said to use a SQL editor to add to the table..

 

Add these 3 fields to table orders by running these lines in phpmyadmin or what ever you prefer.

# Add customers purchase orders values to each order

ALTER TABLE `orders` ADD `account_name` VARCHAR( 32 ) NOT NULL AFTER `currency_value` ;

ALTER TABLE `orders` ADD `account_number` VARCHAR ( 20 ) AFTER `account_name` ;

ALTER TABLE `orders` ADD `po_number` VARCHAR ( 12 ) AFTER `account_number` ;

 

. I couldnt get a editor to work so I opened the SQL file in HTML kit and added the lines...

 

account_name varchar(32) ,

account_number varchar(20) ,

po_number varchar(12) ,

 

in the table. Then I loaded it onto the server. In the admin area, looking at the orders, it says Purchase order, but it does not say the customer number or name. Is there something I did wrong?