> What's the intention of "Notes" in invoice_sku? in database/mysql/invoice
> function getInvoiceInfo includes:
>
>
> It's not included in the invoice_sku table and is obviously generating
> errors. In my case I've dropped it from the database/mysql/invoice queries
> and CREATE_INVOICE can proceed but I was curious if that was what you
> intended, i.e. should it be added to the database?
>

This is a bit of functionality that's only half-done.  In FT1, variations on
SKUs you put in your basket are stuffed into a serialized array.  That's
what the Notes column holds.  I decided that I didn't like that because it's
not in the spirit of relational databases.  So, I've added tables called
session_sku_variation, invoice_sku_variation and user_sku_variation.
Unfortunately, the code to deal with these tables isn't written yet.

I've made a few changes to the database, plus I have diagrams for it
now...so let me put together another release.  I'll make your fixes first.

Leon




_______________________________________________
FreeTrade-dev mailing list
[EMAIL PROTECTED]
http://share.whichever.com/mailman/listinfo/freetrade-dev

Reply via email to