<< Click to Display Table of Contents >> Navigation: Extensibility Add On upgrade to iVend Retail 6.6 > Change 1 Primary keys are now GUIDs |
Navigation: Extensibility Add On upgrade to iVend Retail 6.6 >
In iVend Retail ver. 6.6, all primary keys are now GUIDs. Therefore, primary key for any UDT (user defined table) would be created as data type nVarchar instead of BigInt.
On upgrade from previous version of iVend Retail, Installer will do the necessary changes in the DB structure while upgrading the base iVend product.
Any existing Add-on program do not need to make any change in the primary key of existing UDTs while upgrading the add-on to the latest version.
However, if any reference key has been created in any UDT to make the foreign-key relationship between any two DB tables. i.e. primary key of any UDT referenced in another UDT field, that must be converted to data type string in add-on code. This will result in nVarchar db type in the table structure in the database.
iVend Retail ver. 6.5.X DB table structure and data type for primary key
iVend Retail ver. 6.6 DB table structure and data type for primary key