Package er.extensions.migration

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

80
81
82
83
84
85
86
87
88
89
90
        ERXMigrationTable eRCPreferenceTable = database.newTableNamed("ERCPREFER");
        eRCPreferenceTable.newIntegerColumn("ID", NOT_NULL);
        eRCPreferenceTable.newStringColumn("KEY_", 100, NOT_NULL);
        eRCPreferenceTable.newIntegerColumn("USER_ID", ALLOWS_NULL);
        eRCPreferenceTable.newClobColumn("VALUE_", ALLOWS_NULL);
        eRCPreferenceTable.create();
        eRCPreferenceTable.setPrimaryKey("ID");

        ERXMigrationTable eRCStaticTable = database.newTableNamed("ERCSTATIC");
        eRCStaticTable.newIntegerColumn("ID", NOT_NULL);
        eRCStaticTable.newStringColumn("KEY_", 100, NOT_NULL);
View Full Code Here
87
88
89
90
91
92
93
94
95
        ERXMigrationTable eRCStaticTable = database.newTableNamed("ERCSTATIC");
        eRCStaticTable.newIntegerColumn("ID", NOT_NULL);
        eRCStaticTable.newStringColumn("KEY_", 100, NOT_NULL);
        eRCStaticTable.newStringColumn("VALUE_", 1000, ALLOWS_NULL);
        eRCStaticTable.create();
        eRCStaticTable.setPrimaryKey("ID");
    }
}
View Full Code Here
25
26
27
28
29
30
31
32
33
34
    erSessionInfoTable.newIntegerColumn("intLock", false);
    erSessionInfoTable.newBlobColumn("sessionData", false);
    erSessionInfoTable.newStringColumn("sessionID", 50, false);


    erSessionInfoTable.create();
     erSessionInfoTable.setPrimaryKey("sessionID");

  }
}
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
  public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable {
    ERXMigrationTable priorityTable = database.newTableNamed("PRIORITY");
    priorityTable.newStringColumn("ID", 4, false);
    priorityTable.newIntegerColumn("SORT_ORDER", false);
    priorityTable.newStringColumn("DESCRIPTION", 50, false);
    priorityTable.create();
    priorityTable.setPrimaryKey("ID");

    ERXMigrationTable xRequirementTestItemTable = database.newTableNamed("REQ_TEST_ITEM");
    xRequirementTestItemTable.newIntegerColumn("BUG_ID", false);
    xRequirementTestItemTable.newIntegerColumn("ID", false);
View Full Code Here
35
36
37
38
39
40
41
42
43
44
45
    priorityTable.setPrimaryKey("ID");

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

    ERXMigrationTable commentTable = database.newTableNamed("Comment");
    commentTable.newIntegerColumn("BUG_ID", false);
    commentTable.newTimestampColumn("DATE_SUBMITTED", true);
View Full Code Here
45
46
47
48
49
50
51
52
53
54
55
    commentTable.newTimestampColumn("DATE_SUBMITTED", true);
    commentTable.newIntegerColumn("id", false);
    commentTable.newIntegerColumn("ORIGINATOR_ID", false);
    commentTable.newIntegerColumn("PARENT_ID", true);
    commentTable.newLargeStringColumn("DESCRIPTION", true);
    commentTable.create();
    commentTable.setPrimaryKey("id");

    ERXMigrationTable bugTable = database.newTableNamed("BUG");
    bugTable.newIntegerColumn("COMP_ID", false);
    bugTable.newTimestampColumn("DATE_MODIFIED", true);
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
    bugTable.newStringColumn("PR_ID", 4, false);
    bugTable.newIntegerColumn("RELEASE_ID", false);
    bugTable.newStringColumn("STATE_ID", 4, false);
    bugTable.newStringColumn("SUBJECT", 50, false);
    bugTable.newStringColumn("type", 1, true);
    bugTable.create();
    bugTable.setPrimaryKey("ID");

    ERXMigrationTable releaseTable = database.newTableNamed("RELEASE");
    releaseTable.newTimestampColumn("DATE_DUE", false);
    releaseTable.newIntegerColumn("ID", false);
View Full Code Here
71
72
73
74
75
76
77
78
79
80
81
    ERXMigrationTable releaseTable = database.newTableNamed("RELEASE");
    releaseTable.newTimestampColumn("DATE_DUE", false);
    releaseTable.newIntegerColumn("ID", false);
    releaseTable.newIntBooleanColumn("IS_OPEN", false);
    releaseTable.newStringColumn("NAME", 50, false);
    releaseTable.create();
    releaseTable.setPrimaryKey("ID");

    ERXMigrationTable componentTable = database.newTableNamed("COMPONENT");
    componentTable.newIntegerColumn("ID", false);
    componentTable.newIntegerColumn("PEOPLE_ID", false);
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
    ERXMigrationTable componentTable = database.newTableNamed("COMPONENT");
    componentTable.newIntegerColumn("ID", false);
    componentTable.newIntegerColumn("PEOPLE_ID", false);
    componentTable.newIntegerColumn("PARENT_ID", true);
    componentTable.newStringColumn("DESCRIPTION", 1000, false);
    componentTable.create();
    componentTable.setPrimaryKey("ID");

    ERXMigrationTable xCommentAttachmentTable = database.newTableNamed("XCommentAttachment");
    xCommentAttachmentTable.newIntegerColumn("commentId", false);
    xCommentAttachmentTable.newIntegerColumn("eRAttachmentId", false);
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
    componentTable.setPrimaryKey("ID");

    ERXMigrationTable xCommentAttachmentTable = database.newTableNamed("XCommentAttachment");
    xCommentAttachmentTable.newIntegerColumn("commentId", false);
    xCommentAttachmentTable.newIntegerColumn("eRAttachmentId", false);
    xCommentAttachmentTable.create();
    xCommentAttachmentTable.setPrimaryKey("eRAttachmentId", "commentId");

    ERXMigrationTable xBugTestItemTable = database.newTableNamed("BUG_TEST_ITEM");
    xBugTestItemTable.newIntegerColumn("BUG_ID", false);
    xBugTestItemTable.newIntegerColumn("ID", false);
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.