1,234
edits
Changes
no edit summary
[[category: NexJ Express PostgreSQL]][[category: NexJ Express Development]] [[category: NexJ Express]]
==Summary==
* SQLSchemaManager is used in maintaining database schemas (DDL)
== Task Summary Tasks ==
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
|-
| Implement <code>getCreateEtcScriptName()</code> method
| DONE
|DONE
|-
| Implement <code>getDefaultIndexspace()</code> method
| DONE
|DONE
|-
| Implement <code>getDefaultLongspace()</code> method
| Implement <code>getNowExpr()</code> method
| DONE
|DONE
|-
| Implement <code>getSeparator()</code> method
| DONE
|DONE
|-
| Implement <code>getSetupEtcScriptName()</code> method
| DONE
|DONE
|-
| Override <code>renameTable</code>[http://www.postgresql.org/docs/8.0/static/sql-altertable.html](+ recreate functions)| DONE
| DONE
|-
| Override <code>renameColumn</code>[http://www.postgresql.org/docs/8.0/static/sql-altertable.html]
| DONE
|DONE
|-
| Override <code>renameIndex</code>[http://www.postgresql.org/docs/8.0/static/sql-alterindex.html]
| DONE
|DONE
|-
| Override <code>getIndexName()</code>
| DONE
|DONE|-| Override <code>createIndex(Index)</code> to add full text search| DONE| DONE|-| Override <code>dropTable(table)</code> (+ drop functions)| DONE| DONE
|-
| Port <code>mysql_insert.sql</code> script to <code>postgresql_insert</code>
| DONE
| DONE
|-
| Add <code>dropTriggers(columnName, table)</code> <br/>to drop full-text triggers when column is dropped
| DONE
| DONE
|-
| Add <code>dropTrigerFunctions(column)</code> <br/>to drop full-text trigger functions when column or table is dropped
| DONE
| DONE
== Task Details ==
=== Extend SQLSchemaManager to support PostgreSQL ===
Create a new class PostgreSQLSchemaManager by extending SQLSchemaManager and implementing all necessary abstract classesmethods
=== Research and add Maximum column Precision ===
