12 years agoAdd giftnuss to contributors, awesome triage work
Peter Rabbitson [Sun, 25 Dec 2011 15:27:26 +0000]
Add giftnuss to contributors, awesome triage work

12 years agoInteger default sizes are one point smaller if they are unsigned
Jaime Soriano Pastor [Tue, 20 Dec 2011 17:06:35 +0000]
Integer default sizes are one point smaller if they are unsigned

12 years agoName of unique keys are not written if empty
Jaime Soriano Pastor [Wed, 21 Dec 2011 17:16:00 +0000]
Name of unique keys are not written if empty

12 years agoNames accepted (and ignored) as types of primary keys in create tables
Jaime Soriano Pastor [Tue, 20 Dec 2011 15:57:26 +0000]
Names accepted (and ignored) as types of primary keys in create tables

12 years agoMySQL parsing fails if a table is defined more than once in the same file, if not...
Jaime Soriano Pastor [Mon, 14 Nov 2011 10:36:08 +0000]
MySQL parsing fails if a table is defined more than once in the same file, if not, indices are messed up

12 years agoDefault bits and double quoted strings are parsed now
Jaime Soriano Pastor [Thu, 10 Nov 2011 18:49:17 +0000]
Default bits and double quoted strings are parsed now

12 years agopatch from rt67989 applied, changes dependency from Digest::SHA1 to Digest::SHA
Peter Rabbitson [Sun, 25 Dec 2011 08:31:05 +0000]
patch from rt67989 applied, changes dependency from Digest::SHA1 to Digest::SHA

12 years agoquote SQLite identifiers
Arthur Axel 'fREW' Schmidt [Thu, 14 Jul 2011 15:51:54 +0000]
quote SQLite identifiers

12 years agobetter error messages for the SQLite parser
Arthur Axel 'fREW' Schmidt [Thu, 14 Jul 2011 15:40:27 +0000]
better error messages for the SQLite parser

12 years agoAdd trigger support to PostgreSQL producer and parser (including trigger scope)
Aaron Schrab [Tue, 10 May 2011 22:15:26 +0000]
Add trigger support to PostgreSQL producer and parser (including trigger scope)

PostgreSQL triggers can be fired either once for a statement (the
default), or for each row affected by the statement.  Add support to
declare which type of trigger should is wanted by setting the "scope" of
the trigger.

12 years agoAvoid warning about exiting sub with next
Aaron Schrab [Thu, 12 May 2011 17:43:27 +0000]
Avoid warning about exiting sub with next

12 years agoFix POD for Schema::Index::type method
Aaron Schrab [Thu, 12 May 2011 16:05:13 +0000]
Fix POD for Schema::Index::type method

Had some lingering text copied from doc for options method.

12 years agofix doc typo
Michal Jurosz [Thu, 28 Apr 2011 07:03:24 +0000]
fix doc typo

12 years agoour > use vars
Arthur Axel 'fREW' Schmidt [Sat, 26 Feb 2011 08:14:48 +0000]
our > use vars

12 years agouse warnings
Arthur Axel 'fREW' Schmidt [Sat, 26 Feb 2011 07:17:23 +0000]
use warnings

12 years agoremove commented copyright
Arthur Axel 'fREW' Schmidt [Sat, 26 Feb 2011 06:25:12 +0000]
remove commented copyright

12 years agotake out duplicate docs
Arthur Axel 'fREW' Schmidt [Sat, 26 Feb 2011 06:07:38 +0000]
take out duplicate docs

12 years agoWhitespace
Arthur Axel 'fREW' Schmidt [Sat, 26 Feb 2011 06:07:19 +0000]
Whitespace

12 years agoHandle on_delete => 'restrict' in Producer::Oracle
Robert Bohne [Tue, 19 Jul 2011 12:32:00 +0000]
Handle on_delete => 'restrict' in Producer::Oracle

12 years agoCall ->on_delete & ->on_update in SCALAR context not in LIST context
Robert Bohne [Tue, 19 Jul 2011 12:29:53 +0000]
Call ->on_delete & ->on_update in SCALAR context not in LIST context

12 years agoadded kaitlyn's patch for mysql->sqlite translation
Devin Austin [Tue, 7 Jun 2011 18:07:30 +0000]
added kaitlyn's patch for mysql->sqlite translation

12 years agobinmode STDOUT to not generate garbage in a UTF-8 environment (bug #71399)
Lukas Mai [Sun, 2 Oct 2011 12:07:57 +0000]
binmode STDOUT to not generate garbage in a UTF-8 environment (bug #71399)

12 years agoimage is returned, not written w/o out_file (bug #71398)
Lukas Mai [Sun, 2 Oct 2011 12:02:57 +0000]
image is returned, not written w/o out_file (bug #71398)

12 years agogitignoring
Peter Rabbitson [Sat, 24 Dec 2011 05:37:21 +0000]
gitignoring

12 years agoadded a working mechanism for naming foreign keys
Andreas 'ac0v' Specht [Wed, 6 Apr 2011 19:32:46 +0000]
added a working mechanism for naming foreign keys

12 years agofixed alter_drop_constraint for foreign keys and applying multiple changes via alter_...
Andreas 'ac0v' Specht [Wed, 6 Apr 2011 18:20:02 +0000]
fixed alter_drop_constraint for foreign keys and applying multiple changes via alter_field to a column in Postgres Producer

12 years agoget Postgres table and column descriptions
Cedric Carree [Tue, 22 Nov 2011 11:34:27 +0000]
get Postgres table and column descriptions

patch submitted by Andrew Pam

12 years agoFix index issue in Parser::DBI::PostgreSQL
Cedric Carree [Tue, 22 Nov 2011 10:15:10 +0000]
Fix index issue in Parser::DBI::PostgreSQL

pg_index.indkey does not necessaraly matches the id of the columns_name array. It happens when a column is dropped after the table was created.

12 years agoPatch to get correct SQL data types from Postgres
Cedric Carree [Tue, 22 Nov 2011 09:55:53 +0000]
Patch to get correct SQL data types from  Postgres

Patch submitted by Andrew Pam

12 years agoCreate unit test for ::Parser::DBI::PostgreSQL, fix parser namespace lookup
Cedric Carree [Thu, 17 Nov 2011 11:00:10 +0000]
Create unit test for ::Parser::DBI::PostgreSQL, fix parser namespace lookup

13 years agoRelease 0.11010 v0.11010
Amiri Barksdale at Home [Wed, 5 Oct 2011 15:40:55 +0000]
Release 0.11010

13 years agoAdd test for DROP VIEW IF EXISTS
Amiri Barksdale at Home [Wed, 5 Oct 2011 16:34:56 +0000]
Add test for DROP VIEW IF EXISTS

13 years agoFix CREATE VIEW syntax.
Amiri Barksdale at Home [Wed, 4 May 2011 18:58:59 +0000]
Fix CREATE VIEW syntax.

13 years agoAdd geiststeufel to the AUTHORs list v0.11009
Jess Robinson [Fri, 2 Sep 2011 12:23:33 +0000]
Add geiststeufel to the AUTHORs list

13 years agoUpdate to version 0.011009
Jess Robinson [Fri, 2 Sep 2011 12:18:16 +0000]
Update to version 0.011009

13 years agotest quoted for mysql
Vincent Bachelier [Fri, 2 Sep 2011 09:32:21 +0000]
test quoted for mysql

13 years agoquote properly all table name
Vincent Bachelier [Thu, 1 Sep 2011 15:30:26 +0000]
quote properly all table name

13 years agoadd quoted reference to check if the table name contain a full declaration, it quote...
Geistteufel [Wed, 31 Aug 2011 13:50:03 +0000]
add quoted reference to check if the table name contain a full declaration, it quote it properly

13 years agoquote reference_table
Geistteufel [Wed, 31 Aug 2011 13:39:33 +0000]
quote reference_table

13 years agoRelease 0.11008 v0.11008
Arthur Axel 'fREW' Schmidt [Wed, 4 May 2011 14:56:46 +0000]
Release 0.11008

13 years agoignore vim swap files
Arthur Axel 'fREW' Schmidt [Mon, 2 May 2011 23:26:24 +0000]
ignore vim swap files

13 years agorename Shim to ProducerUtils for accuracy
Arthur Axel 'fREW' Schmidt [Mon, 2 May 2011 23:25:03 +0000]
rename Shim to ProducerUtils for accuracy

13 years agoDo not depend on implicit hash ordering in YAML load
Peter Rabbitson [Mon, 25 Apr 2011 07:36:51 +0000]
Do not depend on implicit hash ordering in YAML load

13 years agoSimple change to make Postgres simple array types produce correctly
Colin Newell [Mon, 18 Apr 2011 14:11:59 +0000]
Simple change to make Postgres simple array types produce correctly

13 years agofix repo url
Arthur Axel 'fREW' Schmidt [Tue, 19 Apr 2011 16:51:59 +0000]
fix repo url

13 years agoPostGIS functions are case-sensitive
Florian Ragwitz [Tue, 5 Apr 2011 15:26:49 +0000]
PostGIS functions are case-sensitive

Use their proper names, not the lc()ed version.

13 years agoCreate and parse FK constraints in SQLite
Arthur Axel 'fREW' Schmidt [Mon, 28 Feb 2011 15:16:12 +0000]
Create and parse FK constraints in SQLite

13 years agoMake true unique constraints if needed in SQL Server
Arthur Axel 'fREW' Schmidt [Thu, 24 Feb 2011 21:30:55 +0000]
Make true unique constraints if needed in SQL Server

http://improvingsoftware.com/2010/03/26/creating-a-unique-constraint-that-ignores-nulls-in-sql-server/

13 years agoTurn off constraints before dropping tables in SQL Server
Arthur Axel 'fREW' Schmidt [Thu, 24 Feb 2011 21:49:45 +0000]
Turn off constraints before dropping tables in SQL Server

13 years agoQuote everything in SQL Server
Arthur Axel 'fREW' Schmidt [Thu, 24 Feb 2011 01:01:23 +0000]
Quote everything in SQL Server

13 years agoParse new SQL Server stuff
Peter Rabbitson [Fri, 25 Feb 2011 03:16:06 +0000]
Parse new SQL Server stuff

13 years agowhitespace changes
Arthur Axel 'fREW' Schmidt [Fri, 25 Feb 2011 16:13:30 +0000]
whitespace changes

13 years agotear out useless unreserve hash
Arthur Axel 'fREW' Schmidt [Thu, 24 Feb 2011 00:51:49 +0000]
tear out useless unreserve hash

13 years agoadd shim for non-lethal future development
Arthur Axel 'fREW' Schmidt [Thu, 24 Feb 2011 00:07:15 +0000]
add shim for non-lethal future development

13 years agoBetter diagnostics
Peter Rabbitson [Fri, 25 Feb 2011 03:15:32 +0000]
Better diagnostics

13 years agoFix RT#64728
Peter Rabbitson [Sun, 27 Feb 2011 16:11:52 +0000]
Fix RT#64728

13 years agoMake autoinc PKs show up in GraphViz
Peter Rabbitson [Sun, 27 Feb 2011 15:59:58 +0000]
Make autoinc PKs show up in GraphViz

13 years agoMake Pg producer consistent with the rest in terms of quoting
Moritz Onken [Wed, 2 Feb 2011 11:58:39 +0000]
Make Pg producer consistent with the rest in terms of quoting
and allowing functions in constraints and indices

13 years ago.gitignore
Peter Rabbitson [Wed, 2 Feb 2011 10:25:59 +0000]
.gitignore

13 years agoRevert last change becuase it broke a bunch of tests.
Darren Chamberlain [Tue, 11 Jan 2011 21:41:43 +0000]
Revert last change becuase it broke a bunch of tests.

13 years agoMerging patch from ddascalescu+perl@gmail.com, for https://rt.cpan.org/Ticket/Display...
Darren Chamberlain [Tue, 11 Jan 2011 16:56:22 +0000]
Merging patch from ddascalescu+perl@gmail.com, for https://rt.cpan.org/Ticket/Display.html?id=44769.  I've not tested it.

13 years agoRevert my previous changes (rev 1722 reverted back to rev 1721)
Jonathan Yu [Fri, 31 Dec 2010 23:32:55 +0000]
Revert my previous changes (rev 1722 reverted back to rev 1721)

13 years agoRemove copyright headers from individual scripts
Jonathan Yu [Fri, 31 Dec 2010 22:02:11 +0000]
Remove copyright headers from individual scripts
+ This information is now kept in the main SQL::Translator POD
+ Different files had copyright dates out-of-sync with each other due to excessive duplication
Remove AUTHORS file (information moved to SQL::Translator POD)
Fix Makefile.PL to correctly indicate the package is GPL-2 licensed
Update my e-mail address while we're at it

13 years agoCorrect postgis geography type insertion and linebreak fix for multiple geometry...
Peter Rabbitson [Wed, 15 Dec 2010 15:53:41 +0000]
Correct postgis geography type insertion and linebreak fix for multiple geometry/geography columns

13 years agoReleased 0.11007
Jess Robinson [Tue, 30 Nov 2010 22:35:12 +0000]
Released 0.11007

13 years agoFix MySQL producer attaching View definitions to a schema
Peter Rabbitson [Tue, 30 Nov 2010 11:54:20 +0000]
Fix MySQL producer attaching View definitions to a schema
in hash-key order (which sadly *appears* stable after 5.8.2)

13 years agoChanges from abraxxa
Peter Rabbitson [Tue, 30 Nov 2010 11:53:51 +0000]
Changes from abraxxa

13 years agotests for MySQL Producer triggers
Rafael Kitover [Tue, 30 Nov 2010 10:46:58 +0000]
tests for MySQL Producer triggers

13 years agoAdd support for triggers in the MySQL producer (RT#63452) ilmari++
Rafael Kitover [Tue, 30 Nov 2010 10:42:27 +0000]
Add support for triggers in the MySQL producer (RT#63452) ilmari++

13 years agoFix POD typo in SQL/Translator/Schema/Trigger.pm (RT#63451)
Rafael Kitover [Tue, 30 Nov 2010 10:39:15 +0000]
Fix POD typo in SQL/Translator/Schema/Trigger.pm (RT#63451)

14 years agoUse CASCADE when dropping a postgres enum type, to be consistent with table drops
Stephen Bennett [Sat, 20 Nov 2010 22:09:54 +0000]
Use CASCADE when dropping a postgres enum type, to be consistent with table drops

14 years agoFix sqlt options not matching documentation (RT#58318)
Peter Rabbitson [Wed, 17 Nov 2010 11:28:16 +0000]
Fix sqlt options not matching documentation (RT#58318)

14 years agotest + fix for Oracle multi-column constraint generation
Alexander Hartmaier [Sat, 13 Nov 2010 13:56:25 +0000]
test + fix for Oracle multi-column constraint generation

14 years agoSupport a custom_type_name hint for Pg enum creation
Peter Rabbitson [Wed, 10 Nov 2010 22:57:56 +0000]
Support a custom_type_name hint for Pg enum creation

14 years agoFix some legacy code to stop warning on newer perls
Peter Rabbitson [Wed, 10 Nov 2010 22:57:40 +0000]
Fix some legacy code to stop warning on newer perls

14 years agoAdd support for PostGIS Geometry and Geography data types
Peter Rabbitson [Wed, 10 Nov 2010 22:57:13 +0000]
Add support for PostGIS Geometry and Geography data types

14 years agoTurn the roundtrip source generation fail into a warning
Peter Rabbitson [Wed, 10 Nov 2010 22:56:54 +0000]
Turn the roundtrip source generation fail into a warning

14 years agoBump M::I dep to a version not abusing FindBin
Peter Rabbitson [Fri, 13 Aug 2010 10:35:51 +0000]
Bump M::I dep to a version not abusing FindBin

14 years agoEven though it is in the depchain due to YAML - just go ahead and declare it
Peter Rabbitson [Fri, 13 Aug 2010 10:35:38 +0000]
Even though it is in the depchain due to YAML - just go ahead and declare it

14 years agoRelease 0.11006
Peter Rabbitson [Thu, 3 Jun 2010 09:09:16 +0000]
Release 0.11006

14 years agoAwesome non-quoted numeric default patch by Stephen Clouse
Peter Rabbitson [Thu, 3 Jun 2010 09:09:02 +0000]
Awesome non-quoted numeric default patch by Stephen Clouse

14 years agoAdjust view production for stupid mysql
Peter Rabbitson [Thu, 3 Jun 2010 09:08:31 +0000]
Adjust view production for stupid mysql

14 years agoFix index quoting for mysql
Peter Rabbitson [Thu, 3 Jun 2010 09:08:14 +0000]
Fix index quoting for mysql

14 years agoMake 'default_value' behave like a real accessor
Peter Rabbitson [Wed, 2 Jun 2010 08:39:03 +0000]
Make 'default_value' behave like a real accessor

14 years agoChanges reformat
Peter Rabbitson [Wed, 2 Jun 2010 08:23:17 +0000]
Changes reformat

14 years agoupdate Changes
Rafael Kitover [Wed, 2 Jun 2010 02:21:20 +0000]
update Changes

14 years agopatch from abraxxa (Alexander Hartmaier) to truncate unique constraint names that...
Rafael Kitover [Wed, 2 Jun 2010 02:16:48 +0000]
patch from abraxxa (Alexander Hartmaier) to truncate unique constraint names that are too long

14 years agoFix SQLite producer create_view so it doesn't generate statements with semicolons.
Andrew Rodland [Wed, 2 Jun 2010 00:03:00 +0000]
Fix SQLite producer create_view so it doesn't generate statements with semicolons.

14 years agoChanges
Peter Rabbitson [Tue, 1 Jun 2010 23:37:08 +0000]
Changes

14 years agoremove unnecessary bit of code
Rafael Kitover [Tue, 1 Jun 2010 17:44:13 +0000]
remove unnecessary bit of code

14 years agonormalize SQLite and Postgres version numbers
Rafael Kitover [Tue, 1 Jun 2010 16:27:05 +0000]
normalize SQLite and Postgres version numbers

14 years agoGet SQLite to produce saner output
Peter Rabbitson [Sat, 6 Mar 2010 23:44:37 +0000]
Get SQLite to produce saner output

14 years agoMerge 'oracle_datatypes' into 'trunk'
Peter Rabbitson [Fri, 5 Mar 2010 10:23:33 +0000]
Merge 'oracle_datatypes' into 'trunk'

r1685@Thesaurus (orig r1684):  faxm0dem | 2010-02-25 10:13:29 +0100
I'm not to be trusted with the chainsaw

r1686@Thesaurus (orig r1685):  faxm0dem | 2010-02-25 13:38:04 +0100
add to changes
r1687@Thesaurus (orig r1686):  faxm0dem | 2010-02-25 14:18:30 +0100
float doesn't need to be forced to 126 either

14 years agofix a bunch of spelling errors, and add whatis entries (these are applying patches...
Jonathan Yu [Sat, 27 Feb 2010 00:28:31 +0000]
fix a bunch of spelling errors, and add whatis entries (these are applying patches from Debian)

14 years agofloat doesn't need to be forced to 126 either
Fabien Wernli [Thu, 25 Feb 2010 13:18:30 +0000]
float doesn't need to be forced to 126 either

14 years agoadd to changes
Fabien Wernli [Thu, 25 Feb 2010 12:38:04 +0000]
add to changes

14 years agoI'm not to be trusted with the chainsaw
Fabien Wernli [Thu, 25 Feb 2010 09:13:29 +0000]
I'm not to be trusted with the chainsaw

14 years agoForgot to add the test data file for r1676
Andrew Rodland [Wed, 24 Feb 2010 21:30:35 +0000]
Forgot to add the test data file for r1676

14 years agotext back to clob
Fabien Wernli [Wed, 24 Feb 2010 17:17:46 +0000]
text back to clob

14 years agotests
Fabien Wernli [Wed, 24 Feb 2010 15:26:37 +0000]
tests