Package er.extensions.migration

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

126
127
128
129
130
131
132
133
134
135
136
    ERXMigrationTable videoTable = database.newTableNamed("video");
    videoTable.newIntegerColumn("MOVIE_ID", false);
    videoTable.newIntegerColumn("RENTAL_TERMS_ID", false);
    videoTable.newIntegerColumn("VIDEO_ID", false);
    videoTable.create();
     videoTable.setPrimaryKey("VIDEO_ID");

    ERXMigrationTable rentalTermsTable = database.newTableNamed("rentalterms");
    rentalTermsTable.newIntegerColumn("CHECK_OUT_LENGTH", false);
    rentalTermsTable.newBigDecimalColumn("COST", 10, 2, false);
View Full Code Here
135
136
137
138
139
140
141
142
143
144
145
    rentalTermsTable.newIntegerColumn("CHECK_OUT_LENGTH", false);
    rentalTermsTable.newBigDecimalColumn("COST", 10, 2, false);
    rentalTermsTable.newBigDecimalColumn("DEPOSIT_AMOUNT", 10, 2, false);
    rentalTermsTable.newStringColumn("NAME", 20, false);
    rentalTermsTable.newIntegerColumn("RENTAL_TERMS_ID", false);
    rentalTermsTable.create();
     rentalTermsTable.setPrimaryKey("RENTAL_TERMS_ID");

    ERXMigrationTable customerTable = database.newTableNamed("customer");
    customerTable.newStringColumn("CITY", 20, false);
    customerTable.newIntegerColumn("CUSTOMER_ID", false);
View Full Code Here
148
149
150
151
152
153
154
155
156
157
158
    customerTable.newTimestampColumn("MEMBER_SINCE", true);
    customerTable.newStringColumn("PHONE", 10, true);
    customerTable.newStringColumn("STATE", 2, true);
    customerTable.newStringColumn("STREET_ADDRESS", 50, true);
    customerTable.newStringColumn("ZIP", 10, true);
    customerTable.create();
     customerTable.setPrimaryKey("CUSTOMER_ID");

    ERXMigrationTable creditCardTable = database.newTableNamed("creditcard");
    creditCardTable.newTimestampColumn("AUTHORIZATION_DATE", false);
    creditCardTable.newStringColumn("AUTHORIZATION_NUM", 10, false);
View Full Code Here
158
159
160
161
162
163
164
165
166
167
168
    creditCardTable.newStringColumn("AUTHORIZATION_NUM", 10, false);
    creditCardTable.newStringColumn("CARD_NUMBER", 25, false);
    creditCardTable.newIntegerColumn("CUSTOMER_ID", false);
    creditCardTable.newTimestampColumn("EXPIRATION_DATE", false);
    creditCardTable.newBigDecimalColumn("CLIMIT", 10, 2, false);
    creditCardTable.create();
     creditCardTable.setPrimaryKey("CUSTOMER_ID");

    ERXMigrationTable feeTypeTable = database.newTableNamed("feetype");
    feeTypeTable.newIntegerColumn("ENABLED", false);
    feeTypeTable.newStringColumn("FEE_TYPE", 15, false);
View Full Code Here
166
167
168
169
170
171
172
173
174
175
176
    ERXMigrationTable feeTypeTable = database.newTableNamed("feetype");
    feeTypeTable.newIntegerColumn("ENABLED", false);
    feeTypeTable.newStringColumn("FEE_TYPE", 15, false);
    feeTypeTable.newIntegerColumn("FEE_TYPE_ID", false);
    feeTypeTable.newIntegerColumn("ORDER_BY", 9, false);
    feeTypeTable.create();
     feeTypeTable.setPrimaryKey("FEE_TYPE_ID"); 
   
    ERXJDBCUtilities.executeUpdateScriptFromResourceNamed(database
        .adaptorChannel(), "Movies0-"
        + ERXJDBCUtilities.databaseProductName(database
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
    public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable {
       
        ERXMigrationTable eRCAuditBlobTable = database.newTableNamed("ERCAuditBlob");
        eRCAuditBlobTable.newBlobColumn("BLOB_VALUE", NOT_NULL);
        eRCAuditBlobTable.newIntegerColumn("ID", NOT_NULL);
        eRCAuditBlobTable.create();
        eRCAuditBlobTable.setPrimaryKey("ID");

        ERXMigrationTable eRCAuditTrailTable = database.newTableNamed("ERCAuditTrail");
        eRCAuditTrailTable.newStringColumn("GID", 255, ALLOWS_NULL);
        eRCAuditTrailTable.newIntegerColumn("ID", NOT_NULL);
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
        ERXMigrationTable eRCAuditTrailTable = database.newTableNamed("ERCAuditTrail");
        eRCAuditTrailTable.newStringColumn("GID", 255, ALLOWS_NULL);
        eRCAuditTrailTable.newIntegerColumn("ID", NOT_NULL);
        eRCAuditTrailTable.newIntBooleanColumn("IS_DELETED", NOT_NULL);
        eRCAuditTrailTable.create();
        eRCAuditTrailTable.setPrimaryKey("ID");

        ERXMigrationTable eRCAuditTrailEntryTable = database.newTableNamed("ERCAuditTrailEntry");
        eRCAuditTrailEntryTable.newTimestampColumn("CREATED", NOT_NULL);
        eRCAuditTrailEntryTable.newIntegerColumn("ID", NOT_NULL);
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
        eRCAuditTrailEntryTable.newStringColumn("OLD_VALUES", 1000, ALLOWS_NULL);
        eRCAuditTrailEntryTable.newIntegerColumn("TRAIL_ID", NOT_NULL);
        eRCAuditTrailEntryTable.newStringColumn("TYPE", 50, NOT_NULL);
        eRCAuditTrailEntryTable.newStringColumn("USER_GLOBAL_ID", 255, ALLOWS_NULL);
        eRCAuditTrailEntryTable.newBlobColumn("USER_INFO", ALLOWS_NULL);
        eRCAuditTrailEntryTable.create();
        eRCAuditTrailEntryTable.setPrimaryKey("ID");
        eRCAuditTrailEntryTable.addForeignKey("NEW_BLOB_VALUE_ID", "ERCAuditBlob", "id");
        eRCAuditTrailEntryTable.addForeignKey("OLD_BLOB_VALUE_ID", "ERCAuditBlob", "id");
        eRCAuditTrailEntryTable.addForeignKey("TRAIL_ID", "ERCAuditTrail", "id");
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
        ERXMigrationTable eRCHelpTextTable = database.newTableNamed("ERCHELP_TEXT");
        eRCHelpTextTable.newIntegerColumn("ID", NOT_NULL);
        eRCHelpTextTable.newStringColumn("KEY_", 100, NOT_NULL);
        eRCHelpTextTable.newLocalizedClobColumns("VALUE_", ALLOWS_NULL);
        eRCHelpTextTable.create();
        eRCHelpTextTable.setPrimaryKey("ID");

        ERXMigrationTable eRCLogEntryTable = database.newTableNamed("ERCLOG_ENTRY");
        eRCLogEntryTable.newTimestampColumn("CREATED", NOT_NULL);
        eRCLogEntryTable.newIntegerColumn("ID", NOT_NULL);
View Full Code Here
72
73
74
75
76
77
78
79
80
81
82
        ERXMigrationTable eRCLogEntryTable = database.newTableNamed("ERCLOG_ENTRY");
        eRCLogEntryTable.newTimestampColumn("CREATED", NOT_NULL);
        eRCLogEntryTable.newIntegerColumn("ID", NOT_NULL);
        eRCLogEntryTable.newClobColumn("TEXT_", NOT_NULL);
        eRCLogEntryTable.newIntegerColumn("USER_ID", NOT_NULL);
        eRCLogEntryTable.create();
        eRCLogEntryTable.setPrimaryKey("ID");

        ERXMigrationTable eRCPreferenceTable = database.newTableNamed("ERCPREFER");
        eRCPreferenceTable.newIntegerColumn("ID", NOT_NULL);
        eRCPreferenceTable.newStringColumn("KEY_", 100, NOT_NULL);
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.