Issues encountered in porting to Firebird


ball.gif Database needs to be created manually.
ball.gif Porting was simplified by creating domains for every datatype. This enabled a lot of cut and paste.
ball.gif Handling AUTOINCREMENT required a special stored procedure
ball.gif Biggest problem was caused by not specifying ADODB_ASSOC_CASE. Firebird returns columns in UPPERCASE by default. Flyspray was expecting lower case (as per mySQL and postgres.)
ball.gif A few changes were required to the setup.php.
ball.gif Lets look at the finished schema.