Package er.extensions.migration

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

30
31
32
33
34
35
36
37
38
39
40
  @Override
  public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable {
    ERXMigrationTable employeeTypeTable = database.newTableNamed("EmployeeType");
    employeeTypeTable.newIntegerColumn("id", false);
    employeeTypeTable.newStringColumn("name", 255, false);
    employeeTypeTable.create();
     employeeTypeTable.setPrimaryKey("id");

    ERXMigrationTable departmentTable = database.newTableNamed("Department");
    departmentTable.newIntegerColumn("companyID", false);
    departmentTable.newStringColumn("departmentCode", 255, false);
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
    ERXMigrationTable departmentTable = database.newTableNamed("Department");
    departmentTable.newIntegerColumn("companyID", false);
    departmentTable.newStringColumn("departmentCode", 255, false);
    departmentTable.newIntegerColumn("id", false);
    departmentTable.newStringColumn("name", 255, false);
    departmentTable.create();
     departmentTable.setPrimaryKey("id");

    ERXMigrationTable companyTable = database.newTableNamed("Company");
    companyTable.newStringColumn("address1", 255, true);
    companyTable.newStringColumn("address2", 255, true);
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
    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 partial_AuthenticatedPersonTable = database.existingTableNamed("Person");
    partial_AuthenticatedPersonTable.newTimestampColumn("lastLoginDate", true);
    partial_AuthenticatedPersonTable.newStringColumn("password", 255, true);
View Full Code Here
23
24
25
26
27
28
29
30
31
32
33
    ERXMigrationTable spNoNoPalTable = database.newTableNamed("SPNoNoPal");
    spNoNoPalTable.newIntegerColumn("eventID", false);
    spNoNoPalTable.newIntegerColumn("giverID", false);
    spNoNoPalTable.newIntegerColumn("id", false);
    spNoNoPalTable.newIntegerColumn("receiverID", false);
    spNoNoPalTable.create();
    spNoNoPalTable.setPrimaryKey("id");

    spNoNoPalTable.addForeignKey("eventID", "SPEvent", "id");
    spNoNoPalTable.addForeignKey("giverID", "SPPerson", "id");
    spNoNoPalTable.addForeignKey("receiverID", "SPPerson", "id");
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
    attachmentTable.newStringColumn("webPath", 1000, false);
    attachmentTable.newIntegerColumn("width", true);
    attachmentTable.newIntegerColumn("attachmentDataID", true);
    attachmentTable.newStringColumn("filesystemPath", 255, true);
    attachmentTable.newStringColumn("s3Path", 1000, true);
    attachmentTable.create();
    attachmentTable.setPrimaryKey("id");
    attachmentTable.addUniqueIndex("ERAttachmentWebPath", "webPath", 1000);

    ERXMigrationTable attachmentDataTable = database.newTableNamed("ERAttachmentData");
    attachmentDataTable.newBlobColumn("data", true);
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
    attachmentTable.addUniqueIndex("ERAttachmentWebPath", "webPath", 1000);

    ERXMigrationTable attachmentDataTable = database.newTableNamed("ERAttachmentData");
    attachmentDataTable.newBlobColumn("data", true);
    attachmentDataTable.newIntegerColumn("id", false);
    attachmentDataTable.create();
    attachmentDataTable.setPrimaryKey("id");

    attachmentTable.addForeignKey("attachmentDataID", "ERAttachmentData", "id");
  }
}
View Full Code Here
21
22
23
24
25
26
27
28
29
30
  @Override
  public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable {
    ERXMigrationTable tagTable = database.newTableNamed("ERTag");
    tagTable.newIntegerColumn("id", false);
    tagTable.newStringColumn("name", 255, false);
    tagTable.create();
    tagTable.setPrimaryKey("id");
    tagTable.addUniqueIndex("uniqueTagName", "name", 255);
  }
}
View Full Code Here
23
24
25
26
27
28
29
30
31
32
33
  public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable {
   
    ERXMigrationTable talentPhotoTable = database.newTableNamed("talentphoto");
    talentPhotoTable.newBlobColumn("PHOTO", true);
    talentPhotoTable.newIntegerColumn("TALENT_ID", false);
    talentPhotoTable.create();
     talentPhotoTable.setPrimaryKey("TALENT_ID");

    ERXMigrationTable directorTable = database.newTableNamed("director");
    directorTable.newIntegerColumn("MOVIE_ID", false);
    directorTable.newIntegerColumn("TALENT_ID", false);
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
     talentPhotoTable.setPrimaryKey("TALENT_ID");

    ERXMigrationTable directorTable = database.newTableNamed("director");
    directorTable.newIntegerColumn("MOVIE_ID", false);
    directorTable.newIntegerColumn("TALENT_ID", false);
    directorTable.create();
     directorTable.setPrimaryKey("MOVIE_ID", "TALENT_ID");

    ERXMigrationTable votingTable = database.newTableNamed("voting");
    votingTable.newIntegerColumn("MOVIE_ID", false);
    votingTable.newIntegerColumn("NUMBER_OF_VOTES", true);
View Full Code Here
36
37
38
39
40
41
42
43
44
45
46
    ERXMigrationTable votingTable = database.newTableNamed("voting");
    votingTable.newIntegerColumn("MOVIE_ID", false);
    votingTable.newIntegerColumn("NUMBER_OF_VOTES", true);
    votingTable.newDoubleColumn("RUNNING_AVERAGE", 20, 9, true);
    votingTable.create();
     votingTable.setPrimaryKey("MOVIE_ID");

    ERXMigrationTable movieTable = database.newTableNamed("movie");
    movieTable.newStringColumn("CATEGORY", 20, true);
    movieTable.newTimestampColumn("DATE_RELEASED", true);
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.