Make extended fields optional

• Duplicated fields created by joins are extended with the joined table name and an underscore by default, can now be turned off
• Table::getSelectSQL() method is now public
• Updated typos in the documentation

Better Table::set methods

• Added setJoin, setSelect and setUnion to clear previous values
• Renamed setSelectFields to addSelectFields

RecordCursor creation of any type

Table::getRecordCursor() takes an optional Record type so you can return a RecordCursor of a different type than the table

Migration primary key fix

Adding a primary key in a migration no longer ignores the other changes to the table in the same migration.

Fix Migration::indexExists

V3.0.2

Fix Migration::indexExists

Fixed Composite Primary Keys

• Also added composite primary key test

Full Changelog: V3.0.0...V3.0.1

PostGre support

• Added support for PostGreSQL

  • Migrations for indexes and changing columns will have to be done by custom SQL queries in the Migration class.

• Now supports SQLite insertOrIgnore and insertOrUpdate for the Record class

• Added more unit tests

• Porting to V3 from V2

  • \PHPFUI\ORM\Migration::alterColumn takes only 3 parameters and does not rename the column. Use renameColumn instead.

Revert from PostGre porting

V2.0.09

Revert some PostGre porting

PHP 8.5 Support

• PHP 8.5 Support
• Start of PostGreSQL port, but it is not fully supported yet
• Revised unit tests to support different databases for testing

Better length for Decimal fields

• Decimal fields now have the correct length
• Fields with a length of zero pass the maxlength validator
• Updated documentation