1.4.1
* All improvements from 1.4.1b1 to 1.4.1b4

1.4.1b4
* Fixes for SQL parser errors when importing some kinds of keys and indexes
* Fixes for better parsing of several MySQL specific SQL fragments

1.4.1b3
* Fix for image export types being wrong
* Modifed foreign key handling with compound keys
* Some internal improvements for better performance
* Fixed undo menu text (was showing wrong object types)
* Fix for undo movement of connector control handles
* Fix for bug which caused deletion of compound foreign keys to fail when draging from on the secondary fields

1.4.1b2
* SQL Parser: Multiple instructions in single table alter
* Better ignoring of insert and update instructions affecting database data
* Fix for (null) appearing as index prefix size with mysql
* Modified MySQL export to better handle types that require index prefix sizes
* SQL Parser: Better handling of CONSTRAINT primary and foreign keys in tables
* Better error reporting for some kinds of error (instead of “no reason given”)
* SQL Parser now ignores temporary tables (with message)

1.4.1b1
* Fix SQL parsing bug: multiple parts in alter table instruction
* Fix for SQL parsing bug: error with foreign key in table body
* Better handling of SQLEditor specific JDBC driver directory
* “Open Driver Directory” button in preferences now opens SQLEditor specific directory

1.4
* Release version

1.4b26
* Fixes for auto increment with SQLite
* Final Candidate Version for 1.4

1.4b25
* Fix for an odd bug that would sometimes cause SQLEditor to quit on startup
* Fix for a bug that caused JDBC Imports to fail with foreign keys that didn’t have names
* Minor code improvements

1.4b22
* Fix for Java Update for Mac OS X 10.5 release 1 bug.

1.4b21
* Improved handling of database connection settings
* Fixes for SQL output correctness issues
* Note text field cursor jumping problem fixed
* Fix for connector control handle not dragging correctly
* Modified export naming of created indexes when specifying a schema

1.4b20
* Fix for escaping of quotes for table comments in MySQL
* Fix for WITH TIME ZONE in Postgres for TIME and TIMESTAMP
* Modified postgres types list to consolate the TIME and TIMESTAMP options together
o (This shouldn’t affect existing tables)
* Fix for BINARY type import from file
* Fix for a possible bug in index handling
* Fix for a bug in Clipboard Cut operations
* Modifications to improve compatibility with Microsoft SQL Server Import
* Added new index prefix size option for certain types (MySQL)
* Fixed an odd bug that affected files that were re-opened having incorrect uids under some conditions
* Increased starting size of Comment object
* Context (popup) menu on Comment Views now works better
* Added first version of MS SQLServer Support
* Improvements to database export for Oracle, Postgres and MySQL
* Better updating of existing databases when exporting to database
* Improved JDBC preset handling
* Importing a document now sets the document dialect to match the original database
* Better handling of the Keychain
* SQLEditor is now correctly security signed as an application
* Minor SQL parser improvements

1.4b19
* Fix for a crashing bug in inspector
* Several improvements for dragging, scrolling and resizing of objects
* Fix for enum and set values being forced to uppercase
* Fix for bug in Find Object
* Fix for a bug that prevented export if a table had the same name as a canvas object
* Added back the button to convert comments → Canvas Areas (and reverse too)
* Fix for a bug where comments weren’t loading colors correctly
* A few internal optimizations
* Parser now imports mysql KEYs (as Indexes currently)
* Fix for repeated JDBC Export of tables with foreign keys to MySQL which was failing
* Ruby on Rails table names are now forced to start with a capital letter for better compatibility
* Fix for a log window resizing bug

1.4b18
* Fix for source sidebar
* SQLEditor now allows JDBC drivers to be stored in “/Library/Application Support/SQLEditor/JDBC Drivers” (as an alternative location)
* New warning icon for possibly unsuitable default values
* Fix for Ruby on Rails Plugin issues
* Fixes and improvements for SQL Parsing (decimals in unquoted default values, fulltext with optional index and table level unique keys)
* More “ON DELETE” action types for connectors
* Modified MySQL unique keys when importing from database
* New constraint object (initially for unique keys)
* Fixes for indices when exporting (better SQL)
* Fixes for some database export bugs (indices again)
* Modified field appearance to better distinguish name from type
* Fix for Add Driver menu item not working in Import & Export from database windows
* Fix for an import bug where types would appear in lowercase then switch to uppercase
* Fix for a problem that caused the source sidebar to be empty

1.4b17
* internal release only

1.4b16
* Fix for autocomplete bug in field types
* Auto adding field types as they are entered is now optional (see Preferences→Data Types)
* Fix for occasional bug in displaying status messages when running on PowerPC

1.4b15
* Fix for oracle connection type string missing
* Changes to prevent adding an empty custom database driver
* Data type lists for Oracle, Postgres, Rails, Sybase and OpenBase now included. (Reset Dialects to use)
* Fix for a bug where type sizes imported from a MySQL database could be wrong for some types
* Fix for a bug where MySQL table types weren’t being imported correctly.
* New hand drag scroll tool (via optional document toolbar palette item)
* New modifier when scroll wheel zoom: hold down command to switch to normal scrolling mode

1.4b14
* Added default setting preference for automatic table sizing.
* Better export image cropping
* Modified image export to add a small border around the image
* Modified Canvas Areas to randomly select initial color
* Canvas Area objects can now be added from the popup menu.
* Changed zoom shortcut to display Command (PLUS) instead of Command (EQUALS), this makes no change in functionality since both work equally
* Better Rails Class naming
* New Rename underscores for table names option for rails export
* FIX: First field added to a document sometimes had incorrect type.
* FIX: for comment inspector selection bug

1.4b12
* FIX: startup failure on 10.4

1.4b11
* Added per document option to hide field types

1.4b10
* FIX: for a bug that caused objects to resize when dragged if the document was scaled
* FIX: for a crash bug related to the table inspector
* FIX: for a selection bug when copying objects with option drag
* FIX: for incorrect visibility of export plugin menu

1.4b9
* Better support for new Ruby On Rails 2.0 migrations
* New Canvas object to replace old style canvas area comments
* Minor SQL parser changes
* Fixed the button style in the SQLite import panel
* Fixed a packaging error where the disk image was unmountable on Mac OS X 10.3.9

1.4b8
* Ruby On Rails Import from migration added
* Better Ruby On Rails type conversion
* New option to align field type labels in a vertical column per table for better readability
* New “New with Dialect” to allow choosing the document dialect when creating a document
* Improved preferences window, visual and organizational improvements
* FIX: Inline rename wasn’t updating correctly
* FIX: Parse status window time was wrong
* FIX: Source view updates weren’t happening
* FIX: Correct printing system is chosen automatically
* FIX: SQLite auto-increment
* CHANGE: “Export to SQL” is now “Export to File”
* Other minor changes
* (Also the first public build built with 10.5 and XCode 3.0. Please report any problems)

1.4b7
* Improved visual appearance - rounded corner tables, with colored table headers (optional)
* Labels and colors on fields as well as tables
* Can now duplicate fields as well as tables
* FIX: Inspector now updates if you make changes using a popup menu
* FIX: Ruby on Rails auto increment output incorrect
* FIX: Fields could not be dragged between tables
* FIX: Modified type matching to ignore sizes when matching postgres SERIAL types
* FIX: Minor improvements and fixes for printing (page numbers particularly)
* FIX: Fix for some inspector issues that appeared in 1.4b6

1.4b6
* Changed toolbar icons to look better with Mac OS X 10.5 Leopard
* FIX: for Ruby On Rails join tables
* FIX: for side bar visibility
* Passwords for connections are now stored in the keychain

1.4b5
* Fix for JDBC Driver list sometimes being empty
* Fix for a bug relating to updating the source sidebar when closing a window.

1.4b4
* Modified Inspect Object to display the inspector if it is not already visible
* Fix for a bug that sometimes caused the application to crash if a source update occurred after the window had closed.

1.4b3
* Fix for undo on index fields
* Minor fix to registration window user interface

1.4b2
* Fix for a bug that caused connectors to be incorrectly deleted
* Fix for undo/redo bug
* Improved update checking (now using Sparkle)
* New beta warning message (shown once only per version release)
* Fix for live source view sometimes being blank
* Fix for live source view not changing when document export dialect changed
* Fix for a bug that sometimes caused undo to stop working.

1.4b1
* New live source view sidebar
* Improved search (now searches for fields as well)
* Image export file type now selectable
* Some SQL export fixes
* Fix for a bug that was sometimes preventing fields being added under odd conditions
* Fix for drop order with referenced tables
* Fix for a file corruption error
* Improved status window (it now idents!)
* Fixes for minor bugs in registration window
* New Show Inspector toolbar item
* Better database driver listing delete handling in preferences window
* Added option to De-Register Software (if selling a machine for instance)
* Improved undo/redo when repeatedly undoing and redoing (particularly delete)
* Fixed save/revert menus not becoming inactive
* Other minor fixes

• Fix for a crash that sometimes happened when importing or exporting
• Performance fix for selecting objects in large documents
• Parse status window: Large messages are now displayed completely and not cropped
• Better handling of java 1.5 drivers when running using java 1.4

Fix for a save bug that caused tables not to get saved correctly under certain conditions

1.3.6
* Fix for mysql auto increment not being read correctly when using jdbc database import
* further fixes for database connection issues.

1.3.5
* Fix for a bug that prevented Database connection windows from opening if there were no preset connections.

1.3.4
* Loading foreign key links now works more reliably (SQLEditor was getting confused if uid values weren’t correct)
* Types are now sorted within each dialect
* Parser is now better able to understand check constraints (although editing and exporting aren’t available yet)
* Database import window now appears even if there are no drivers present (previously didn’t appear)
* Hand icon appears when cursor is over field drag area
* Bug fix for an odd crash when drawing
* First ssl support (for postgres only at the moment) in import and export
* Improvements to Postgres JDBC support with JDBC drivers >= 8.0

1.3.3
* Internal release only

1.3.2
* Added new per dialect column type system and a new option to select a default type (see preferences - data types)
* Choosing no-preset in database connect now clears the import/export window
* Default type list for mysql now includes most (possibly all) mysql data types - please advise if there missing items
* Fix for a bug that caused altering tables in a mysql to reset some attributes on columns
* Parser recognizes (but doesn’t actually do anything with) collate and character set options