Skip to content

Releases

DBSteward 1.4.3

Choose a tag to compare

@bstoots bstoots released this 04 Feb 17:37

Changes

  • Fix for #136 Table ordering not properly calculated when using foreignKey element #137

DBSteward 1.4.2

Choose a tag to compare

@nkiraly nkiraly released this 19 Nov 18:25

Maintenance Release

New

Changes

  • Fix pgsql8 partial index where clause output SQL #105
  • Fix mysql5 type conversion for boolean to tinyint(1) #107
  • One usage mode, with pretty colors #116
  • Fix --dbpassword usage for blank passwords #115
  • Add pgsql8 ltree type support #129
  • Drop and Re-add mysql5 and pgsql8 foreign key constraints when target column type changes #132
  • Fix compound foreign key element reordering #121 #135

DBSteward 1.4.1

Choose a tag to compare

@nkiraly nkiraly released this 15 Sep 21:58

API 1.4 features follow up and bugfixes

  • Slony ID numbering tools --slonyid et al issue #101
  • mysql5 foreign key index extraction and handling improvements issue #88
  • foreign key definition additions for ON DELETE, ON UPDATE issue #100

DBSteward 1.4.0

Choose a tag to compare

@nkiraly nkiraly released this 21 Aug 20:27

Changes

  • Update docs/ to match 1.4 API CLI and output changes
  • Drop PEAR package support. Please use composer: https://github.com/nkiraly/DBSteward/blob/v1.4.0-alpha1/doc/INSTALLING.md
  • Add additional quotereservednames flag and separate quoteillegalnames to only affect those #69
  • New and Improved Logging features via switching to monolog #82
  • Make foreignSchema attribute optional and default to the current schema #81
  • Add unit test coverage information via Coveralls https://coveralls.io/r/nkiraly/DBSteward #83
  • Fix pgsql8 DEFAULT parenthesis wrapping #84
  • Fix pgsql8 index name generation to not exceed maximum length #86
  • Add pgsql8 CREATE INDEX CONCURRENTLY support to definition XML
  • Reorganized slonik output files for --generateslonik slony replication to include preamble #90
  • Include execute script and and subscribe set statements in revamped slonik output files #90
  • XML foreignKey element support and constraint definition refactoring #87

DBSteward 1.4.0 Alpha 2

Pre-release

Choose a tag to compare

@nkiraly nkiraly released this 17 Aug 18:56

Changes

  • Drop PEAR package support. Please use composer: https://github.com/nkiraly/DBSteward/blob/v1.4.0-alpha1/doc/INSTALLING.md
  • Add additional quotereservednames flag and separate quoteillegalnames to only affect those #69
  • New and Improved Logging features via switching to monolog #82
  • Make foreignSchema attribute optional and default to the current schema #81
  • Add unit test coverage information via Coveralls https://coveralls.io/r/nkiraly/DBSteward #83
  • Fix pgsql8 DEFAULT parenthesis wrapping #84
  • Fix pgsql8 index name generation to not exceed maximum length #86
  • Add pgsql8 CREATE INDEX CONCURRENTLY support to definition XML
  • Reoranized slonik output files for --generateslonik slony replication to include preamble #90
  • Include execute script and and subscribe set statements in revamped slonik output files #90
  • XML foreignKey element support and constraint definition refactoring #87

DBSteward 1.4.0 Alpha 1

Pre-release

Choose a tag to compare

@nkiraly nkiraly released this 17 Aug 18:49

Changes

  • Drop PEAR package support. Please use composer: https://github.com/nkiraly/DBSteward/blob/v1.4.0-alpha1/doc/INSTALLING.md
  • Add additional quotereservednames flag and separate quoteillegalnames to only affect those #69
  • New and Improved Logging features via switching to monolog #82
  • Make foreignSchema attribute optional and default to the current schema #81
  • Add unit test coverage information via Coveralls https://coveralls.io/r/nkiraly/DBSteward #83
  • Fix pgsql8 DEFAULT parenthesis wrapping #84
  • Fix pgsql8 index name generation to not exceed maximum length #86
  • Add pgsql8 CREATE INDEX CONCURRENTLY support to definition XML
  • Reoranized slonik output files for --generateslonik slony replication to include preamble #90
  • Include execute script and and subscribe set statements in revamped slonik output files #90

DBSteward 1.3.12

Choose a tag to compare

@nkiraly nkiraly released this 29 Apr 19:57

NOTICE: DBSteward 1.3.x is the end of PEAR packaging support for DBSteward

Changes

  • allow infinite includeFile depth of definition fragment XML files
  • update outdated sample XML
  • View definition dependency support with new view element dependsOnViews attribute github/nkiraly/DBSteward PR #75
  • fix SQL output file transactionality when generating stage files for execution by slonik github/nkiraly/DBSteward PR #76
  • mysql5 column default removal fix github/nkiraly/DBSteward PR #77
  • Contextualize pgsql8 VIEW Slony Replica Set ID DROP / CREATE
  • Drop and recreate pgsql8 functions referring to types modified in the definition github/nkiraly/DBSteward PR #78
  • Optional tabrow delimiter specificity github/nkiraly/DBSteward PR #79

DBSteward 1.3.11

Choose a tag to compare

@nkiraly nkiraly released this 28 Aug 18:40

Changes

  • fix cross-schema references of table-inherited columns
  • fix double quote support in sql tags
  • pgsql8 fix extraction of foreign key ON actions
  • mysql5 function characteristic definition and extraction support

DBSteward 1.3.10

Choose a tag to compare

@nkiraly nkiraly released this 24 Jun 21:16

DBSteward 1.3.10 Release Package

Changes include

  • psql8 inherited table static row definition bugfixes
  • mysql5 table partition support for extracton and diffing
  • mysql5 stored procedure extraction and diffing support

DBSteward 1.3.9

Choose a tag to compare

@nkiraly nkiraly released this 27 May 19:00

DBSteward Release Version 1.3.9

Changes

  • mysql5 duplicate implicit index create statement bug fix
  • pgsql8 index extraction PHP runtime error
  • miscellaneous PHP runtime warning polish
  • fix for slonyId slony set association to be consistent between sequences and tables
  • fix for parent table dependency order calculations when diffing

Supported Platform DDL Generation and Differencing:

  • pgsql8 - PostgreSQL 8
  • mssql10 - Microsoft SQL Server 2008
  • mysql5 - MySQL 5

Supported Platform Structure Extraction into XML:

  • pgsql8 - PostgreSQL 8
  • mysql5 - MySQL 5