List of newStringColumn() Examples

Examples of newStringColumn()

er.extensions.migration.ERXMigrationTable.newStringColumn()
Returns a new String column (VARCHAR). See newColumn(..) for the full docs. @param name the name of the column @param width the max width of the varchar @param allowsNull if true, the column will allow null values @return the new ERXMigrationColumn @throws SQLException if the column cannot be created

Examples of er.extensions.migration.ERXMigrationTable.newStringColumn()

    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);

View Full Code Here

Examples of er.extensions.migration.ERXMigrationTable.newStringColumn()

    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");
  }

View Full Code Here

Examples of er.extensions.migration.ERXMigrationTable.newStringColumn()

    envJoinTable.newIntegerColumn("result_pk", false);
    envJoinTable.create();
    envJoinTable.setPrimaryKey("env_pk", "result_pk");


    ERXMigrationTable environmentTable = database.newTableNamed("environments");
    environmentTable.newStringColumn("info", 64, false);
    environmentTable.newIntegerColumn("pk", false);
    environmentTable.create();
    environmentTable.setPrimaryKey("pk");


    ERXMigrationTable failureTable = database.newTableNamed("failures");

View Full Code Here

Examples of er.extensions.migration.ERXMigrationTable.newStringColumn()

    environmentTable.newIntegerColumn("pk", false);
    environmentTable.create();
    environmentTable.setPrimaryKey("pk");


    ERXMigrationTable failureTable = database.newTableNamed("failures");
    failureTable.newStringColumn("message", 511, false);
    failureTable.newIntegerColumn("pk", false);
    failureTable.newIntegerColumn("result_pk", false);
    failureTable.create();
    failureTable.setPrimaryKey("pk");

View Full Code Here

Examples of er.extensions.migration.ERXMigrationTable.newStringColumn()

    failureTable.create();
    failureTable.setPrimaryKey("pk");


    ERXMigrationTable resultTable = database.newTableNamed("results");
    resultTable.newBigIntegerColumn("duration", false);
    resultTable.newStringColumn("email", 127, false);
    resultTable.newIntegerColumn("pk", false);
    resultTable.newStringColumn("time_zone", 32, false);
    resultTable.newStringColumn("whence", 19, false);
    resultTable.create();
    resultTable.setPrimaryKey("pk");

View Full Code Here

Examples of er.extensions.migration.ERXMigrationTable.newStringColumn()


    ERXMigrationTable resultTable = database.newTableNamed("results");
    resultTable.newBigIntegerColumn("duration", false);
    resultTable.newStringColumn("email", 127, false);
    resultTable.newIntegerColumn("pk", false);
    resultTable.newStringColumn("time_zone", 32, false);
    resultTable.newStringColumn("whence", 19, false);
    resultTable.create();
    resultTable.setPrimaryKey("pk");


    ERXMigrationTable versionDigestTable = database.newTableNamed("version_digests");

View Full Code Here

Examples of er.extensions.migration.ERXMigrationTable.newStringColumn()

    ERXMigrationTable resultTable = database.newTableNamed("results");
    resultTable.newBigIntegerColumn("duration", false);
    resultTable.newStringColumn("email", 127, false);
    resultTable.newIntegerColumn("pk", false);
    resultTable.newStringColumn("time_zone", 32, false);
    resultTable.newStringColumn("whence", 19, false);
    resultTable.create();
    resultTable.setPrimaryKey("pk");


    ERXMigrationTable versionDigestTable = database.newTableNamed("version_digests");
    versionDigestTable.newStringColumn("digest", 40, false);

View Full Code Here

Examples of er.extensions.migration.ERXMigrationTable.newStringColumn()

    resultTable.newStringColumn("whence", 19, false);
    resultTable.create();
    resultTable.setPrimaryKey("pk");


    ERXMigrationTable versionDigestTable = database.newTableNamed("version_digests");
    versionDigestTable.newStringColumn("digest", 40, false);
    versionDigestTable.newIntegerColumn("pk", false);
    versionDigestTable.newIntegerColumn("result_pk", false);
    versionDigestTable.newStringColumn("rname", 255, false);
    versionDigestTable.create();
    versionDigestTable.setPrimaryKey("pk");

View Full Code Here

Examples of er.extensions.migration.ERXMigrationTable.newStringColumn()


    ERXMigrationTable versionDigestTable = database.newTableNamed("version_digests");
    versionDigestTable.newStringColumn("digest", 40, false);
    versionDigestTable.newIntegerColumn("pk", false);
    versionDigestTable.newIntegerColumn("result_pk", false);
    versionDigestTable.newStringColumn("rname", 255, false);
    versionDigestTable.create();
    versionDigestTable.setPrimaryKey("pk");


    envJoinTable.addForeignKey("env_pk", "environments", "pk");
    envJoinTable.addForeignKey("result_pk", "results", "pk");

View Full Code Here

Examples of er.extensions.migration.ERXMigrationTable.newStringColumn()


  @Override
  public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable {
    ERXMigrationTable genderTypeTable = database.newTableNamed("GenderType");
    genderTypeTable.newIntegerColumn("id", false);
    genderTypeTable.newStringColumn("name", 255, false);
    genderTypeTable.create();
     genderTypeTable.setPrimaryKey("id");


    ERXMigrationTable personTable = database.newTableNamed("Person");
    personTable.newStringColumn("firstName", 255, false);

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.