OTRS Firebird/Interbase Port Underway

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

On Monday, February 02, 2004 4:24 PM
Charles R. "Rusty" Thompson
Also, has anyone produced a visual schema of the database as it currently exists?
See these: ftp://ftp.otrs.org/pub/otrs/misc/otrs-1.1-database.png ftp://ftp.otrs.org/pub/otrs/misc/otrs-1.2-database.png hth, Robert Kehl -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Tel. +49 (0)6172 4832388
participants (2)
-
Charles R. "Rusty" Thompson
-
Robert Kehl