I'm working on the schema for OTRS on Interbase/Firebird and will be using the DBD/DBI for the same. In constructing the database, the only thing I've come across that isn't lining up from a data storage perspective is the BIGINT for ticket numbers. So far though, it's looking very promising given that I've only hit one snag and do have the drivers I need.
IB6, which is what I'm using for development, supports 64bit integers but I'm uncertain which data type to use. A few unrelated websites showing some comparisons hint at using a NUMERIC with precision of 18 and 0 for the resolution. Anyone have any feedback on this decision before I move forward? My research isn't turning up much so I'm a little lost as to how to handle this. Also, has anyone produced a visual schema of the database as it currently exists? Charles _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/
