Author: echatellier Date: 2012-05-15 10:29:37 +0200 (Tue, 15 May 2012) New Revision: 3418 Url: http://chorem.org/repositories/revision/lima/3418 Log: Remove financialperiod column in table financialtransaction Modified: trunk/lima-business/src/main/java/org/chorem/lima/business/migration/MigrationV0_6.java Modified: trunk/lima-business/src/main/java/org/chorem/lima/business/migration/MigrationV0_6.java =================================================================== --- trunk/lima-business/src/main/java/org/chorem/lima/business/migration/MigrationV0_6.java 2012-05-15 08:23:51 UTC (rev 3417) +++ trunk/lima-business/src/main/java/org/chorem/lima/business/migration/MigrationV0_6.java 2012-05-15 08:29:37 UTC (rev 3418) @@ -64,17 +64,21 @@ queries.add("Alter table FINANCIALTRANSACTION drop column AMOUNTDEBIT"); queries.add("Alter table FINANCIALTRANSACTION drop column AMOUNTCREDIT"); - // modele refactoring + // model refactoring queries.add("drop table record"); queries.add("alter table account drop column masteraccount"); queries.add("alter table account drop column generalledger"); + queries.add("alter table financialtransaction drop column financialperiod"); + queries.add("alter table entry add column lettering varchar(30)"); queries.add("update entry e set lettering = (select l.code from Letter l where l.topiaid = e.letter)"); queries.add("alter table entry drop column letter"); queries.add("drop table letter"); queries.add("alter table vatstatement drop column amount"); + + } }