Package er.extensions.migration

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

36
37
38
39
40
41
42
43
44
45
46
        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);
        eRCAuditTrailTable.newIntBooleanColumn("IS_DELETED", NOT_NULL);
        eRCAuditTrailTable.create();
        eRCAuditTrailTable.setPrimaryKey("ID");
View Full Code Here
45
46
47
48
49
50
51
52
53
54
55
        eRCAuditTrailTable.setPrimaryKey("ID");

        ERXMigrationTable eRCAuditTrailEntryTable = database.newTableNamed("ERCAuditTrailEntry");
        eRCAuditTrailEntryTable.newTimestampColumn("CREATED", NOT_NULL);
        eRCAuditTrailEntryTable.newIntegerColumn("ID", NOT_NULL);
        eRCAuditTrailEntryTable.newStringColumn("KEY_PATH", 100, ALLOWS_NULL);
        eRCAuditTrailEntryTable.newIntegerColumn("NEW_BLOB_VALUE_ID", ALLOWS_NULL);
        eRCAuditTrailEntryTable.newStringColumn("NEW_VALUES", 1000, ALLOWS_NULL);
        eRCAuditTrailEntryTable.newIntegerColumn("OLD_BLOB_VALUE_ID", ALLOWS_NULL);
        eRCAuditTrailEntryTable.newStringColumn("OLD_VALUES", 1000, ALLOWS_NULL);
        eRCAuditTrailEntryTable.newIntegerColumn("TRAIL_ID", NOT_NULL);
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
        ERXMigrationTable eRCAuditTrailEntryTable = database.newTableNamed("ERCAuditTrailEntry");
        eRCAuditTrailEntryTable.newTimestampColumn("CREATED", NOT_NULL);
        eRCAuditTrailEntryTable.newIntegerColumn("ID", NOT_NULL);
        eRCAuditTrailEntryTable.newStringColumn("KEY_PATH", 100, ALLOWS_NULL);
        eRCAuditTrailEntryTable.newIntegerColumn("NEW_BLOB_VALUE_ID", ALLOWS_NULL);
        eRCAuditTrailEntryTable.newStringColumn("NEW_VALUES", 1000, ALLOWS_NULL);
        eRCAuditTrailEntryTable.newIntegerColumn("OLD_BLOB_VALUE_ID", ALLOWS_NULL);
        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);
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
        eRCAuditTrailEntryTable.newIntegerColumn("ID", NOT_NULL);
        eRCAuditTrailEntryTable.newStringColumn("KEY_PATH", 100, ALLOWS_NULL);
        eRCAuditTrailEntryTable.newIntegerColumn("NEW_BLOB_VALUE_ID", ALLOWS_NULL);
        eRCAuditTrailEntryTable.newStringColumn("NEW_VALUES", 1000, ALLOWS_NULL);
        eRCAuditTrailEntryTable.newIntegerColumn("OLD_BLOB_VALUE_ID", ALLOWS_NULL);
        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();
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
        eRCAuditTrailEntryTable.newIntegerColumn("NEW_BLOB_VALUE_ID", ALLOWS_NULL);
        eRCAuditTrailEntryTable.newStringColumn("NEW_VALUES", 1000, ALLOWS_NULL);
        eRCAuditTrailEntryTable.newIntegerColumn("OLD_BLOB_VALUE_ID", ALLOWS_NULL);
        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");
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
        eRCAuditTrailEntryTable.newStringColumn("NEW_VALUES", 1000, ALLOWS_NULL);
        eRCAuditTrailEntryTable.newIntegerColumn("OLD_BLOB_VALUE_ID", ALLOWS_NULL);
        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");
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
        eRCAuditTrailEntryTable.addForeignKey("OLD_BLOB_VALUE_ID", "ERCAuditBlob", "id");
        eRCAuditTrailEntryTable.addForeignKey("TRAIL_ID", "ERCAuditTrail", "id");

        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");
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
        eRCLogEntryTable.create();
        eRCLogEntryTable.setPrimaryKey("ID");

        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");
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
        eRCPreferenceTable.create();
        eRCPreferenceTable.setPrimaryKey("ID");

        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
86
87
88
89
90
91
92
93
94
95
        eRCPreferenceTable.setPrimaryKey("ID");

        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
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.