Jason Pell edited this page Jun 21, 2013 · 1 revision

New Item Type

The following information is not relevant to OpenDb 1.0

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:
  • patch/item_types/{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

Use link below to upload your New Item Type

Upload your New Item Type

You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.
Press h to open a hovercard with more details.