Jason Pell edited this page Aug 20, 2013 · 2 revisions

ZIP File Structure

The zip file must consist of files with the following extensions only:

  • .sql
  • .gif
  • .png
  • .jpeg
  • .jpg
  • .psd
  • .txt
The zip file must include at least two files with the following format:
  • admin/s_item_type/sql/{s_item_type}.sql
  • images/{s_item_type}.[gif|jpg|png]

SQL Restrictions

The ZIP file must have one and only one Item Type definition

The SQL script can only provide INSERT (no DELETE / UPDATE) statements for the following tables:

  • s_item_type
  • s_item_attribute_type
  • s_attribute_type
    • The SITE_TYPE field must be NULL
    • Do not include statements for attributes delivered as part of OpenDb core
  • s_attribute_type_lookup