Revision history for CXC-DB-DDL

0.13      2024-04-04 12:23:58-04:00 America/New_York

  [API BREAKAGE]

    * signature for CXC::DB::DDL::table->add_to_schema has changed

  [ENHANCEMENT]

    * CREATE_IF_NOT_EXISTS now creates only the tables which are missing,
      rather than dropping everything.

  [MISC]

    * CPAN release


0.12      2023-11-22 22:22:14-05:00 America/New_York

  [ENHANCEMENT]

    * foreign key on_delete and on_update attributes are now supported

0.11      2023-09-17 17:41:02-04:00 America/New_York

  [BUG FIX]

    * properly catch and report db errors and the sql statement which
      generated them.

    * don't run empty sql (with just comments)

0.10      2023-08-06 23:30:28-04:00 America/New_York


  [ENHANCEMENT]

    * CXC::DB::DDL::sql now sports new options to pass on to the
      SQL::Translator constructor, such as to turn on debug, trace, or
      quote identifiers

0.09      2023-07-25 13:51:20-04:00 America/New_York

  [BUG FIX]

    * really fix the bug that 0.08 tried to fix.

0.08      2023-07-25 13:26:41-04:00 America/New_York

  [BUG FIX]

    * table names are used to generate constraint/index/check names, but must not
      include a schema (which results in an unacceptable name in PostgreSQL)

0.07      2023-07-21 17:22:00-04:00 America/New_York


  [BUG FIX]

    * fix typo in subroutine name

0.06      2023-07-21 16:26:50-04:00 America/New_York

  [ENHANCEMENT]

    * ::Table now knows a little bit about database schema

    * Field data_type is now an array to be able to match against multiple
      sql types to be more database agnostic

    * DDL->drop drops tables in reverse order of addition to try and avoid
      the need for a DROP CASCADE.

  [BUG FIXES]

    * SQLT's producer may not have the same name as the DBD module (e.g. Pg vs PostgreSQL

0.05      2023-07-20 23:36:47-04:00 America/New_York

  [ENHANCEMENT]

    * CXC::DB::DDL::Util: All of the SQL types recognized by DBI are
      now available as CXC::DB::DDL::Field generators.

0.04      2023-01-10 17:52:31-05:00 America/New_York

  [BUILD]

    * require at least SQL::Translator 1.61 to fix issue with Sybase Producer


0.03      2022-12-22 22:42:06-05:00 America/New_York

  [BUG FIX]

    * add table schema to top-level schema before adding fields so
      that field schema which require the table schema can find it.

0.02      2022-11-04 19:22:41-04:00 America/New_York

  [BUG FIX]

    * add fields to table before adding constraints/indices.

0.01      2022-10-24 23:53:24-04:00 America/New_York

* First release upon an unsuspecting world.