Default Database Field Definitions.
During the product database setup you are offered the option to use a
default field structure for your product database. If this is your first time using
the system it might be helpful to go this route first. The wizard will generate the
MySQL table, create 3 example products in the database and generate a set of generic
website templates that will serve as a guide to build the rest of your site.
The default field structure and definitions are below. If you do not wish to use
this structure you should create
your own table.
| FIELD | LENGTH | DESCRIPTION |
| xindex | Interger | This field automatically increments and serves as the primary key for the table |
| sku | 20 | This is your SKU/Product ID number that will appear on orders |
| smimage | 240 | This is a filename of a thumbnail image of the product |
| lgimage | 240 | This is a filename of a full size image of the product |
| headline | 150 | This is the one line short description of the product that will appear on the invoice |
| xshort | text | This is a short description of the product |
| xlong | text | This is an extended description of the product |
| cat | 20 | The primary category that the product falls under (this should be a single word) |
| cat2 | 20 | The sub-category that the product falls under (this should be a single word) |
| cat3 | 20 | The third sub-category that the product falls under (this should be a single word) |
| keywords | 200 | Hidden keyword used in searches to help locate the products |
| taxable | 1 | Must be Y or N, to determine if the product should be taxed |
| priority | 5 | Used to sort search results. Value can range from a-zzzzz. 'a' being a higher priority and zzzzz being the lowest. |
If you decide to change your mind after you have
created the default product database, and would prefer to create your own table, you will
need to delete the USERNAME.wamy.cfg file in your main application directory. This
will allow you to specify your table name(s).