product price in order after discount

[FrilansReklam]

I need a quick answer. I don't sit with my working computer and can't get into the database.

If a customer buy two products and one products cost $10 and the other $15.
the customer use discount on 10%. What is the products price in the database for the order after discount? Is it updated or not?

(I know about the problem with tax so this is without tax)

I need to know this for a customers API

[IGD]

Not enough information really. is the discount from a coupon on order total, is one product 10% off or both?

depending on which the price in the order table will be either linked to order total module that is being used and the price different.

[FrilansReklam]

Ok.
Most of our administrations program in Sweden works from products not from the order total. So for a API work correctly it need to set discount on the product not in the order total.

really it dosn't metter if it's % or a amount discount. or if it's a gv. I need to know if the price change in orders_products or any other field.

If this not change is there any modules that make this for some part that I can work from?

[FrilansReklam]

I have idéas how to fix it.
1. count all products and split discount total in that pieces. then add it to products price in orders_products.
2. create a new products in orders_products that is the discount.

Last one is tricky I think. So for the first one where should I put the code for best result?

(I don't have wroten the code yet)

I use 1.3.8