Package er.extensions.migration

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

38
39
40
41
42
43
44
45
46
47
48
    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);
    petTable.newStringColumn("name", 255, false);
View Full Code Here
45
46
47
48
49
50
51
52
53
54
55
    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");
    petTable.addForeignKey("ownerID", "Person", "id");
  }
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
    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");
    sPPersonTable.newBooleanColumn("admin", false);
    sPPersonTable.newIntegerColumn("avatarID", true);
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
    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);
    sPSecretPalTable.newIntegerColumn("giverID", false);
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
    ERXMigrationTable sPSecretPalTable = database.newTableNamed("SPSecretPal");
    sPSecretPalTable.newIntegerColumn("eventID", false);
    sPSecretPalTable.newIntegerColumn("giverID", false);
    sPSecretPalTable.newIntegerColumn("id", false);
    sPSecretPalTable.newIntegerColumn("receiverID", false);
    sPSecretPalTable.create();
     sPSecretPalTable.setPrimaryKey("id");

    ERXMigrationTable sPWishTable = database.newTableNamed("SPWish");
    sPWishTable.newBigDecimalColumn("cost", 38, 4, true);
    sPWishTable.newStringColumn("description", 1000, true);
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
    sPWishTable.newStringColumn("description", 1000, true);
    sPWishTable.newIntegerColumn("id", false);
    sPWishTable.newBooleanColumn("purchased", false);
    sPWishTable.newIntegerColumn("suggestedByID", false);
    sPWishTable.newIntegerColumn("suggestedForID", false);
    sPWishTable.create();
     sPWishTable.setPrimaryKey("id");

    ERXMigrationTable sPMembershipTable = database.newTableNamed("SPMembership");
    sPMembershipTable.newBooleanColumn("admin", false);
    sPMembershipTable.newIntegerColumn("groupID", false);
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
    sPMembershipTable.newBooleanColumn("admin", false);
    sPMembershipTable.newIntegerColumn("groupID", false);
    sPMembershipTable.newIntegerColumn("personID", false);
    sPMembershipTable.newStringColumn("confirmationCode", 100, true);
    sPMembershipTable.newBooleanColumn("confirmed", false);
    sPMembershipTable.create();
     sPMembershipTable.setPrimaryKey("groupID", "personID");

    ERXMigrationTable sPEventTable = database.newTableNamed("SPEvent");
    sPEventTable.newBooleanColumn("active", false);
    sPEventTable.newStringColumn("description", 1000, true);
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
    sPEventTable.newBooleanColumn("active", false);
    sPEventTable.newStringColumn("description", 1000, true);
    sPEventTable.newIntegerColumn("groupID", false);
    sPEventTable.newIntegerColumn("id", false);
    sPEventTable.newStringColumn("name", 255, false);
    sPEventTable.create();
     sPEventTable.setPrimaryKey("id");

    sPGroupTable.addForeignKey("ownerID", "SPPerson", "id");
    sPPersonTable.addForeignKey("avatarID", "ERAttachment", "id");
    sPSecretPalTable.addForeignKey("eventID", "SPEvent", "id");
View Full Code Here
31
32
33
34
35
36
37
38
39
40
41
  public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable {
    ERXMigrationTable companyTable = database.newTableNamed("Company");
    companyTable.newIntegerColumn("id", false);
    companyTable.newStringColumn("name", 255, false);
    companyTable.newStringColumn("location", 255, true);
    companyTable.create();
    companyTable.setPrimaryKey("id");

    ERXMigrationTable employeeTable = database.newTableNamed("Employee");
    employeeTable.newIntBooleanColumn("admin", false);
    employeeTable.newIntegerColumn("companyID", false);
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
    employeeTable.newBooleanColumn("insured", false);
    employeeTable.newStringColumn("lastName", 255, false);
    employeeTable.newIntegerColumn("photoID", true);
    employeeTable.newBigDecimalColumn("salary", 38, 4, true);
    employeeTable.newStringColumn("status", 50, false);
    employeeTable.create();
    employeeTable.setPrimaryKey("id");

    employeeTable.addForeignKey("companyID", "Company", "id");
    employeeTable.addForeignKey("photoID", "ERAttachment", "id");
  }
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.