Mssql does not understand ON DELETE RESTRICT

[dbsrgits/SQL-Translator.git] / Changes

diff --git a/Changes b/Changes
index a52440e..361bcf8 100644 (file)
--- a/Changes
+++ b/Changes
@@ -1,6 +1,18 @@
 # ----------------------------------------------------------
 # x.xxxxx xxxx-xx-xx
 # ----------------------------------------------------------
+
+# ----------------------------------------------------------
+# 0.09006 2009-06-10
+# ----------------------------------------------------------
+* Multiple test and dependency adhustments to make smokers happy
+* Fix YAML producer wrt extra attribute
+* Added support for "time(stamp) (p) with time zone" for Pg producer (mo)
+
+# ----------------------------------------------------------
+# 0.09005 2009-06-08
+# ----------------------------------------------------------
+* Add parser support for MySQL default values with a single quote
 * Properly quote absolute table names in the MySQL producer
 * Added semi-colon for (DROP|CREATE) TYPE statements in the Pg producer (wreis)
 * Added CREATE VIEW subrules for mysql parser (wreis)
@@ -12,6 +24,23 @@
 * MySQL producer skips length attribute for columns which do not support that
   attribute. Currently following column types are added to that list:
   date time timestamp datetime year
+* Switch to Module::Install (mandates minimum perl 5.005)
+* Major cleanup of GraphViz proucer
+* Massive amount of fixes to SQLite/Pg/Mysql/MSSQL parsers/producers
+  Fix most of the problems uncovered by the roundtrip test framework
+  Some highlights:
+    - Rewind exhausted globs before attempting a read
+    - Do not add xml comment header if no_comments is set
+    - table/field counts are held per schema object, not globally
+    - no more variable table and column names in SQLite and MSSQL
+    - VIEW support for Pg parser, also some cleanups
+    - The way we generate Pg create view statements was not standards compliant
+      (per RhodiumToad in #postgresql)
+    - Disable MSSQL view/procedure production - they never worked in the first place
+    - SQLite/MSSQL improvements:
+      - Support parsing of all DROP clauses
+      - Support parsing of field-level comments
+      - When producing do not append table names to constraint/index names
 
 # ----------------------------------------------------------
 # 0.09004 2009-02-13