Package er.extensions.migration

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

22
23
24
25
26
27
28
29
30
31
32
  public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable {
    ERXMigrationTable erSessionInfoTable = database.newTableNamed("ERSessionInfo");
    erSessionInfoTable.newTimestampColumn("expirationDate", false);
    erSessionInfoTable.newIntegerColumn("intLock", false);
    erSessionInfoTable.newBlobColumn("sessionData", false);
    erSessionInfoTable.newStringColumn("sessionID", 50, false);


    erSessionInfoTable.create();
     erSessionInfoTable.setPrimaryKey("sessionID");
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
  @Override
  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);
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
    bugTable.newIntBooleanColumn("IS_FEATURE_REQUEST", false);
    bugTable.newIntBooleanColumn("IS_READ", false);
    bugTable.newIntegerColumn("ORIGINATOR_ID", false);
    bugTable.newIntegerColumn("PEOPLE_ID", false);
    bugTable.newIntegerColumn("PREVIOUS_OWNER_ID", true);
    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();
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
    bugTable.newIntegerColumn("ORIGINATOR_ID", false);
    bugTable.newIntegerColumn("PEOPLE_ID", false);
    bugTable.newIntegerColumn("PREVIOUS_OWNER_ID", true);
    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");
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
    bugTable.newIntegerColumn("PEOPLE_ID", false);
    bugTable.newIntegerColumn("PREVIOUS_OWNER_ID", true);
    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");
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
    bugTable.newIntegerColumn("PREVIOUS_OWNER_ID", true);
    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);
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
    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);
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
    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);
View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
    xBugTestItemTable.create();
    xBugTestItemTable.setPrimaryKey("BUG_ID", "ID");

    ERXMigrationTable frameworkTable = database.newTableNamed("FRAMEWORK");
    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");
View Full Code Here
106
107
108
109
110
111
112
113
114
115
116
    frameworkTable.setPrimaryKey("ID");

    ERXMigrationTable testItemTable = database.newTableNamed("TEST_ITEM");
    testItemTable.newLargeStringColumn("COMMENTS", true);
    testItemTable.newIntegerColumn("MODULE_ID", false);
    testItemTable.newStringColumn("CONTROLLED", 50, false);
    testItemTable.newTimestampColumn("DATE_CREATED", false);
    testItemTable.newIntegerColumn("ID", false);
    testItemTable.newStringColumn("STATE_ID", 4, false);
    testItemTable.newIntegerColumn("TESTED_BY_ID", true);
    testItemTable.newLargeStringColumn("DESCRIPTION", 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.