ThreadsDemo0.java

package wowodc.eof.migrations;

import com.webobjects.eocontrol.EOEditingContext;
import com.webobjects.foundation.NSArray;

import er.extensions.migration.ERXMigrationDatabase;
import er.extensions.migration.ERXMigrationTable;
import er.extensions.migration.ERXModelVersion;

public class ThreadsDemo0 extends ERXMigrationDatabase.Migration {
  @Override
  public NSArray<ERXModelVersion> modelDependencies() {
    return null;
  }
  
  @Override
  public void downgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable {
    // DO NOTHING
  }

  @Override
  public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable {
    ERXMigrationTable resultItemTable = database.newTableNamed("resultitem");
    resultItemTable.newBigIntegerColumn("closestfactorial", true);
    resultItemTable.newIntegerColumn("factornumber", true);
    resultItemTable.newIntegerColumn("id", false);
    resultItemTable.newIntBooleanColumn("isfactorialprime", false);
    resultItemTable.newIntBooleanColumn("isprime", false);
    resultItemTable.newTimestampColumn("modificationtime", false);
    resultItemTable.newBigIntegerColumn("numbertocheck", false);
    resultItemTable.newIntegerColumn("taskinfoid", false);
    resultItemTable.newStringColumn("workflowstate", 255, false);
    resultItemTable.create();
    resultItemTable.setPrimaryKey("id");

    ERXMigrationTable taskInfoTable = database.newTableNamed("taskinfo");
    taskInfoTable.newBigIntegerColumn("duration", false);
    taskInfoTable.newBigIntegerColumn("endnumber", true);
    taskInfoTable.newTimestampColumn("endtime", true);
    taskInfoTable.newIntegerColumn("id", false);
    taskInfoTable.newBigIntegerColumn("startnumber", false);
    taskInfoTable.newTimestampColumn("starttime", true);
    taskInfoTable.newStringColumn("workflowstate", 255, false);
    taskInfoTable.create();
    taskInfoTable.setPrimaryKey("id");

    resultItemTable.addForeignKey("taskinfoid", "taskinfo", "id");
  }
}