Package er.extensions.migration

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

29
30
31
32
33
34
35
36
37
38
39
    genderTypeTable.newStringColumn("name", 255, false);
    genderTypeTable.create();
     genderTypeTable.setPrimaryKey("id");

    ERXMigrationTable personTable = database.newTableNamed("Person");
    personTable.newStringColumn("firstName", 255, false);
    personTable.newIntegerColumn("genderTypeID", false);
    personTable.newIntegerColumn("id", false);
    personTable.newStringColumn("lastName", 255, false);
    personTable.create();
     personTable.setPrimaryKey("id");
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
    ERXMigrationTable personTable = database.newTableNamed("Person");
    personTable.newStringColumn("firstName", 255, false);
    personTable.newIntegerColumn("genderTypeID", false);
    personTable.newIntegerColumn("id", false);
    personTable.newStringColumn("lastName", 255, false);
    personTable.create();
     personTable.setPrimaryKey("id");

    personTable.addForeignKey("genderTypeID", "GenderType", "id");
  }
View Full Code Here
31
32
33
34
35
36
37
38
39
40
41
  @Override
  public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable {
    ERXMigrationTable personTable = database.newTableNamed("Person");
    personTable.newIntegerColumn("companyID", true);
    personTable.newIntegerColumn("id", false);
    personTable.newStringColumn("name", 255, false);
    personTable.create();
    personTable.setPrimaryKey("id");

    ERXMigrationTable companyTable = database.newTableNamed("Company");
    companyTable.newIntegerColumn("id", false);
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
    personTable.create();
    personTable.setPrimaryKey("id");

    ERXMigrationTable companyTable = database.newTableNamed("Company");
    companyTable.newIntegerColumn("id", false);
    companyTable.newStringColumn("name", 255, false);
    companyTable.create();
    companyTable.setPrimaryKey("id");

    ERXMigrationTable petTable = database.newTableNamed("Pet");
    petTable.newIntegerColumn("id", false);
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
    companyTable.create();
    companyTable.setPrimaryKey("id");

    ERXMigrationTable petTable = database.newTableNamed("Pet");
    petTable.newIntegerColumn("id", false);
    petTable.newStringColumn("name", 255, false);
    petTable.newIntegerColumn("ownerID", false);
    petTable.create();
    petTable.setPrimaryKey("id");

    personTable.addForeignKey("companyID", "Company", "id");
View Full Code Here
30
31
32
33
34
35
36
37
38
39
40
  public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable {
    ERXMigrationTable sPGroupTable = database.newTableNamed("SPGroup");
    sPGroupTable.newStringColumn("description", 1000, true);
    sPGroupTable.newStringColumn("groupPassword", 100, true);
    sPGroupTable.newIntegerColumn("id", false);
    sPGroupTable.newStringColumn("name", 255, false);
    sPGroupTable.newIntegerColumn("ownerID", false);
    sPGroupTable.create();
     sPGroupTable.setPrimaryKey("id");

    ERXMigrationTable sPPersonTable = database.newTableNamed("SPPerson");
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
     sPGroupTable.setPrimaryKey("id");

    ERXMigrationTable sPPersonTable = database.newTableNamed("SPPerson");
    sPPersonTable.newBooleanColumn("admin", false);
    sPPersonTable.newIntegerColumn("avatarID", true);
    sPPersonTable.newStringColumn("emailAddress", 255, false);
    sPPersonTable.newBooleanColumn("emailDeliveryFailure", false);
    sPPersonTable.newIntegerColumn("id", false);
    sPPersonTable.newStringColumn("name", 255, false);
    sPPersonTable.newStringColumn("password", 100, true);
    sPPersonTable.create();
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
    sPPersonTable.newBooleanColumn("admin", false);
    sPPersonTable.newIntegerColumn("avatarID", true);
    sPPersonTable.newStringColumn("emailAddress", 255, false);
    sPPersonTable.newBooleanColumn("emailDeliveryFailure", false);
    sPPersonTable.newIntegerColumn("id", false);
    sPPersonTable.newStringColumn("name", 255, false);
    sPPersonTable.newStringColumn("password", 100, true);
    sPPersonTable.create();
     sPPersonTable.setPrimaryKey("id");

    ERXMigrationTable sPSecretPalTable = database.newTableNamed("SPSecretPal");
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
    sPPersonTable.newIntegerColumn("avatarID", true);
    sPPersonTable.newStringColumn("emailAddress", 255, false);
    sPPersonTable.newBooleanColumn("emailDeliveryFailure", false);
    sPPersonTable.newIntegerColumn("id", false);
    sPPersonTable.newStringColumn("name", 255, false);
    sPPersonTable.newStringColumn("password", 100, true);
    sPPersonTable.create();
     sPPersonTable.setPrimaryKey("id");

    ERXMigrationTable sPSecretPalTable = database.newTableNamed("SPSecretPal");
    sPSecretPalTable.newIntegerColumn("eventID", false);
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
    sPSecretPalTable.create();
     sPSecretPalTable.setPrimaryKey("id");

    ERXMigrationTable sPWishTable = database.newTableNamed("SPWish");
    sPWishTable.newBigDecimalColumn("cost", 38, 4, true);
    sPWishTable.newStringColumn("description", 1000, true);
    sPWishTable.newIntegerColumn("id", false);
    sPWishTable.newBooleanColumn("purchased", false);
    sPWishTable.newIntegerColumn("suggestedByID", false);
    sPWishTable.newIntegerColumn("suggestedForID", false);
    sPWishTable.create();
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.