Changing the table structure allows the (0.7.5 beta) script to runs w/o error, you're right; but are we sure all server componants will manage that change ??Quote:
search colum ReqLuc > if its Setting on "Smallint" change it in "Int" and save ... or not
first, the issue is (of course) a nice new and not fully tested feature of the text stream, in short a f... bug; all numerical types are signed in SQL, in typed language they can be signed or unsigned; the ReqLuc field uses 2 bytes in client and in ps_game, the item table also stores it as a 2-bytes field (the smallint type), so all values in 0x8000 ... 0xFFFF (32768 .. 65535) will read as -32768 .. -1 in SQL script; and the scripts generated by shStudio shall contain such signed values instead of unsigned ones.
your proposal fixes the loading of the (buggy) script but may introduce bugs in ps_game when it reads items; it may work if the code is using a high level API of the ODBC layer (to which it will requires a 2-byte data type whatever the actual storage of the data, and ODBC will manage the coercion) but it can also read the returned columns with code that assumes fixed length of numerical columns (and expects 2 bytes for this one).
howsoever, it was a bug, Dave, it is fixed now, thank for the report.