1
edit
Changes
→Modifying Syntax
=== Modifying Syntax ===
* '''''PostgreSQLSchemaManager.java'''''
: <code> CREATE TABLE test.xxx </code>
:: 1- '''DATA TYPE''': data types are changed in <code> appendColumnType() </code> in ''PostgreSQLSchemaManager.java'' based on each jdbc type's equivalent in PostgreSQL. [http://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL#Data_Types Here] is a tabular comparison between Postgre and MySQL data types. Also [http://db.apache.org/ddlutils/databases/postgresql.html here] is a mapping JDBC data types to PostgreSQL data types.
:: 2- '''STORAGE ENGINE''': In MySQL, the storage engine is set to a transactional safe engine such as [http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL#MySQL:InnoDB InnoDB], whereas PostgreSQL has a single built in engine. So, implementation of <code> appendTableSuffix() </code> in PostgreSQLManager.java was removed
</source>
:<code> crateTextTable CREATE TEXT TABLE </code>
::The implementation in <code> crateTextTable </code> in file ''PostgreSQLSchemaManager.java'' is removed for now (base class's version is being called).
: <code>CREATE INDEX test.xxx </code> : <code> CREATE Trigger test.xxx // if it's needed for PostgreSQL as well as MySQL</code>
{|class="collapsible collapsed" style="border-style:solid;border-width:thin;border-color:black"