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

Class er.extensions.migration.ERXMigrationTable

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

er.extensions.migration.ERXMigrationTable.create()
Executes the SQL operations to create this table. @throws SQLException if the creation fails

    xCommentAttachmentTable.setPrimaryKey("eRAttachmentId", "commentId");


    ERXMigrationTable xBugTestItemTable = database.newTableNamed("BUG_TEST_ITEM");
    xBugTestItemTable.newIntegerColumn("BUG_ID", false);
    xBugTestItemTable.newIntegerColumn("ID", false);
    xBugTestItemTable.create();
    xBugTestItemTable.setPrimaryKey("BUG_ID", "ID");


    ERXMigrationTable frameworkTable = database.newTableNamed("FRAMEWORK");
    frameworkTable.newIntegerColumn("ID", false);
    frameworkTable.newStringColumn("NAME", 50, false);

View Full Code Here

    frameworkTable.newIntegerColumn("ID", false);
    frameworkTable.newStringColumn("NAME", 50, false);
    frameworkTable.newIntegerColumn("ORDERING", false);
    frameworkTable.newTimestampColumn("OWNED_SINCE", true);
    frameworkTable.newIntegerColumn("USER_ID", true);
    frameworkTable.create();
    frameworkTable.setPrimaryKey("ID");


    ERXMigrationTable testItemTable = database.newTableNamed("TEST_ITEM");
    testItemTable.newLargeStringColumn("COMMENTS", true);
    testItemTable.newIntegerColumn("MODULE_ID", false);

View Full Code Here

    testItemTable.newIntegerColumn("ID", false);
    testItemTable.newStringColumn("STATE_ID", 4, false);
    testItemTable.newIntegerColumn("TESTED_BY_ID", true);
    testItemTable.newLargeStringColumn("DESCRIPTION", true);
    testItemTable.newStringColumn("TITLE", 100, false);
    testItemTable.create();
    testItemTable.setPrimaryKey("ID");


    ERXMigrationTable peopleTable = database.newTableNamed("PEOPLE");
    peopleTable.newStringColumn("EMAIL", 50, true);
    peopleTable.newIntegerColumn("ID", false);

View Full Code Here

    peopleTable.newIntBooleanColumn("IS_ENGINEERING", false);
    peopleTable.newStringColumn("LOGIN", 16, false);
    peopleTable.newStringColumn("NAME", 50, true);
    peopleTable.newStringColumn("PASSWORD", 16, false);
    peopleTable.newStringColumn("TEAM", 16, true);
    peopleTable.create();
    peopleTable.setPrimaryKey("ID");


    ERXMigrationTable difficultyTable = database.newTableNamed("DIFFICULTY");
    difficultyTable.newStringColumn("DESCRIPTION", 50, false);
    difficultyTable.newIntegerColumn("ID", false);

View Full Code Here

    peopleTable.setPrimaryKey("ID");


    ERXMigrationTable difficultyTable = database.newTableNamed("DIFFICULTY");
    difficultyTable.newStringColumn("DESCRIPTION", 50, false);
    difficultyTable.newIntegerColumn("ID", false);
    difficultyTable.create();
    difficultyTable.setPrimaryKey("ID");


    ERXMigrationTable requirementSubTypeTable = database.newTableNamed("REQ_SUB_TYPE");
    requirementSubTypeTable.newIntegerColumn("REQ_SUB_TYPE_ID", false);
    requirementSubTypeTable.newStringColumn("SUB_TYPE_DESC", 50, false);

View Full Code Here

    difficultyTable.setPrimaryKey("ID");


    ERXMigrationTable requirementSubTypeTable = database.newTableNamed("REQ_SUB_TYPE");
    requirementSubTypeTable.newIntegerColumn("REQ_SUB_TYPE_ID", false);
    requirementSubTypeTable.newStringColumn("SUB_TYPE_DESC", 50, false);
    requirementSubTypeTable.create();
    requirementSubTypeTable.setPrimaryKey("REQ_SUB_TYPE_ID");


    ERXMigrationTable requirementTypeTable = database.newTableNamed("REQ_TYPE");
    requirementTypeTable.newIntegerColumn("REQ_TYPE_ID", false);
    requirementTypeTable.newStringColumn("TYPE_DESCRIPTION", 50, false);

View Full Code Here

    requirementSubTypeTable.setPrimaryKey("REQ_SUB_TYPE_ID");


    ERXMigrationTable requirementTypeTable = database.newTableNamed("REQ_TYPE");
    requirementTypeTable.newIntegerColumn("REQ_TYPE_ID", false);
    requirementTypeTable.newStringColumn("TYPE_DESCRIPTION", 50, false);
    requirementTypeTable.create();
    requirementTypeTable.setPrimaryKey("REQ_TYPE_ID");


    ERXMigrationTable testItemStateTable = database.newTableNamed("TEST_ITEM_STATE");
    testItemStateTable.newStringColumn("NAME", 50, false);
    testItemStateTable.newStringColumn("ID", 4, false);

View Full Code Here


    ERXMigrationTable testItemStateTable = database.newTableNamed("TEST_ITEM_STATE");
    testItemStateTable.newStringColumn("NAME", 50, false);
    testItemStateTable.newStringColumn("ID", 4, false);
    testItemStateTable.newIntegerColumn("SORT_ORDER", false);
    testItemStateTable.create();
    testItemStateTable.setPrimaryKey("ID");


    ERXMigrationTable requirementTable = database.existingTableNamed("BUG");
    requirementTable.newIntegerColumn("DIFFICULTY_ID", true);
    requirementTable.newIntegerColumn("SUB_TYPE_ID", true);

View Full Code Here

    companyTable.newStringColumn("city", 255, true);
    companyTable.newIntegerColumn("id", false);
    companyTable.newStringColumn("name", 255, false);
    companyTable.newStringColumn("state", 255, true);
    companyTable.newStringColumn("zipcode", 255, true);
    companyTable.create();
    companyTable.setPrimaryKey("id");


    ERXMigrationTable employeeTable = database.newTableNamed("Employee");
    employeeTable.newStringColumn("address1", 255, true);
    employeeTable.newStringColumn("address2", 255, true);

View Full Code Here

    employeeTable.newBooleanColumn("manager", false);
    employeeTable.newStringColumn("firstName", 255, false);
    employeeTable.newStringColumn("lastName", 255, false);
    employeeTable.newStringColumn("state", 255, true);
    employeeTable.newStringColumn("zipcode", 255, true);
    employeeTable.create();
    employeeTable.setPrimaryKey("id");
    employeeTable.addForeignKey("companyID", "Company", "id");


    ERXMigrationTable roleTable = database.newTableNamed("Role");
    roleTable.newIntegerColumn("id", false);

View Full Code Here

0 1 2 3 4 5 6 7

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.