[mv] transaction table SQL configuration

[Shane Roberts <shane@shaneroberts.com>]

******    message to minivend-users from Shane Roberts <shane@shaneroberts.com>     ******

Anyone understand the use of the "transaction" table with an SQL
database?

I am using MySQL.

The "transaction" table of a default MiniVend configuration is
actually broken into two tables in the database.

A normal "Database" configuration tag in MiniVend specifies a
database identifier such as "products" for the products database.

How does one describe the "transaction" database for a MySQL
configuration in MiniVend, since it is two tables not just one?
Or perhaps it is not really two tables, but on table with
different kinds of records in it, the "header" record and the
"product item" record.

And how are "transaction" fields referenced in MiniVend tags to
distinguish which table they are coming from, of the two
transaction tables?

I am having trouble making sense of the "transaction" table.
Can anyone help to clear up this confusion for me?

Thanks,
Shane Roberts

--
Shane Roberts              E-mail: shane@shaneroberts.com
Software Strategies
Voice: (530) 265-4155

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list