Package er.extensions.migration

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

49
50
51
52
53
54
55
56
57
58
59
    movieTable.newStringColumn("RATED", 10, true);
    movieTable.newBigDecimalColumn("REVENUE", 10, 2, true);
    movieTable.newIntegerColumn("STUDIO_ID", true);
    movieTable.newStringColumn("TITLE", 255, false);
    movieTable.newStringColumn("TRAILER_NAME", 255, true);
    movieTable.create();
     movieTable.setPrimaryKey("MOVIE_ID");

    ERXMigrationTable plotSummaryTable = database.newTableNamed("PlotSummary");
    plotSummaryTable.newIntegerColumn("MOVIE_ID", 9, false);
    plotSummaryTable.newStringColumn("SUMMARY", 10000000, true);
View Full Code Here
55
56
57
58
59
60
61
62
63
64
65
     movieTable.setPrimaryKey("MOVIE_ID");

    ERXMigrationTable plotSummaryTable = database.newTableNamed("PlotSummary");
    plotSummaryTable.newIntegerColumn("MOVIE_ID", 9, false);
    plotSummaryTable.newStringColumn("SUMMARY", 10000000, true);
    plotSummaryTable.create();
     plotSummaryTable.setPrimaryKey("MOVIE_ID");

    ERXMigrationTable studioTable = database.newTableNamed("studio");
    studioTable.newBigDecimalColumn("BUDGET", 15, 2, false);
    studioTable.newStringColumn("NAME", 40, false);
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
    ERXMigrationTable studioTable = database.newTableNamed("studio");
    studioTable.newBigDecimalColumn("BUDGET", 15, 2, false);
    studioTable.newStringColumn("NAME", 40, false);
    studioTable.newIntegerColumn("STUDIO_ID", false);
    studioTable.create();
     studioTable.setPrimaryKey("STUDIO_ID");

    ERXMigrationTable talentTable = database.newTableNamed("talent");
    talentTable.newStringColumn("FIRST_NAME", 20, false);
    talentTable.newStringColumn("LAST_NAME", 30, false);
View Full Code Here
69
70
71
72
73
74
75
76
77
78
79
    ERXMigrationTable talentTable = database.newTableNamed("talent");
    talentTable.newStringColumn("FIRST_NAME", 20, false);
    talentTable.newStringColumn("LAST_NAME", 30, false);
    talentTable.newIntegerColumn("TALENT_ID", 9, false);
    talentTable.create();
     talentTable.setPrimaryKey("TALENT_ID");

    ERXMigrationTable movieRoleTable = database.newTableNamed("movierole");
    movieRoleTable.newIntegerColumn("MOVIE_ID", false);
    movieRoleTable.newStringColumn("ROLE_NAME", 30, true);
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
    ERXMigrationTable movieRoleTable = database.newTableNamed("movierole");
    movieRoleTable.newIntegerColumn("MOVIE_ID", false);
    movieRoleTable.newStringColumn("ROLE_NAME", 30, true);
    movieRoleTable.newIntegerColumn("TALENT_ID", false);
    movieRoleTable.create();
     movieRoleTable.setPrimaryKey("TALENT_ID", "MOVIE_ID");

    ERXMigrationTable reviewTable = database.newTableNamed("review");
    reviewTable.newIntegerColumn("MOVIE_ID", false);
    reviewTable.newStringColumn("REVIEW", 10000000, true);
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
    ERXMigrationTable reviewTable = database.newTableNamed("review");
    reviewTable.newIntegerColumn("MOVIE_ID", false);
    reviewTable.newStringColumn("REVIEW", 10000000, true);
    reviewTable.newStringColumn("REVIEWER", 50, true);
    reviewTable.newIntegerColumn("REVIEW_ID", false);
    reviewTable.create();
     reviewTable.setPrimaryKey("REVIEW_ID");
    
    ERXMigrationTable userTable = database.newTableNamed("rentalsuser");
    userTable.newIntegerColumn("ACCESS_LEVEL", false);
    userTable.newIntegerColumn("CUSTOMER_ID", true);
View Full Code Here
93
94
95
96
97
98
99
100
101
102
103
    userTable.newIntegerColumn("ACCESS_LEVEL", false);
    userTable.newIntegerColumn("CUSTOMER_ID", true);
    userTable.newStringColumn("PASSWORD", 20, false);
    userTable.newIntegerColumn("USER_ID", false);
    userTable.newStringColumn("LOGIN", 20, false);
    userTable.create();
     userTable.setPrimaryKey("USER_ID");

    ERXMigrationTable rentalTable = database.newTableNamed("rental");
    rentalTable.newIntegerColumn("CUSTOMER_ID", false);
    rentalTable.newTimestampColumn("DATE_OUT", false);
View Full Code Here
102
103
104
105
106
107
108
109
110
111
112
    rentalTable.newIntegerColumn("CUSTOMER_ID", false);
    rentalTable.newTimestampColumn("DATE_OUT", false);
    rentalTable.newTimestampColumn("DATE_RETURNED", true);
    rentalTable.newIntegerColumn("RENTAL_ID", false);
    rentalTable.newIntegerColumn("UNIT_ID", false);
    rentalTable.create();
     rentalTable.setPrimaryKey("RENTAL_ID");

    ERXMigrationTable feeTable = database.newTableNamed("fee");
    feeTable.newBigDecimalColumn("AMOUNT", 10, 2, false);
    feeTable.newTimestampColumn("DATE_PAID", true);
View Full Code Here
111
112
113
114
115
116
117
118
119
120
121
    feeTable.newBigDecimalColumn("AMOUNT", 10, 2, false);
    feeTable.newTimestampColumn("DATE_PAID", true);
    feeTable.newIntegerColumn("FEE_ID", false);
    feeTable.newIntegerColumn("FEE_TYPE_ID", false);
    feeTable.newIntegerColumn("RENTAL_ID", false);
    feeTable.create();
     feeTable.setPrimaryKey("FEE_ID");

    ERXMigrationTable unitTable = database.newTableNamed("unit");
    unitTable.newTimestampColumn("DATE_ACQUIRED", false);
    unitTable.newStringColumn("NOTES", 100, true);
View Full Code Here
119
120
121
122
123
124
125
126
127
128
129
    ERXMigrationTable unitTable = database.newTableNamed("unit");
    unitTable.newTimestampColumn("DATE_ACQUIRED", false);
    unitTable.newStringColumn("NOTES", 100, true);
    unitTable.newIntegerColumn("UNIT_ID", false);
    unitTable.newIntegerColumn("VIDEO_ID", false);
    unitTable.create();
     unitTable.setPrimaryKey("UNIT_ID");

    ERXMigrationTable videoTable = database.newTableNamed("video");
    videoTable.newIntegerColumn("MOVIE_ID", false);
    videoTable.newIntegerColumn("RENTAL_TERMS_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.