Package er.extensions.migration

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

73
74
75
76
77
78
79
80
81
82
83
    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);
    movieRoleTable.newIntegerColumn("TALENT_ID", false);
    movieRoleTable.create();
     movieRoleTable.setPrimaryKey("TALENT_ID", "MOVIE_ID");
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
     talentTable.setPrimaryKey("TALENT_ID");

    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);
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
    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);
    reviewTable.newStringColumn("REVIEWER", 50, true);
    reviewTable.newIntegerColumn("REVIEW_ID", false);
    reviewTable.create();
     reviewTable.setPrimaryKey("REVIEW_ID");
View Full Code Here
83
84
85
86
87
88
89
90
91
92
93
    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);
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
    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);
    userTable.newStringColumn("PASSWORD", 20, false);
    userTable.newIntegerColumn("USER_ID", false);
    userTable.newStringColumn("LOGIN", 20, false);
    userTable.create();
View Full Code Here
89
90
91
92
93
94
95
96
97
98
99
    reviewTable.create();
     reviewTable.setPrimaryKey("REVIEW_ID");
    
    ERXMigrationTable userTable = database.newTableNamed("rentalsuser");
    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");
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
    
    ERXMigrationTable userTable = database.newTableNamed("rentalsuser");
    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");
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
    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);
    rentalTable.newTimestampColumn("DATE_RETURNED", true);
    rentalTable.newIntegerColumn("RENTAL_ID", false);
    rentalTable.newIntegerColumn("UNIT_ID", false);
    rentalTable.create();
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
    ERXMigrationTable rentalTable = database.newTableNamed("rental");
    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");
View Full Code Here
101
102
103
104
105
106
107
108
109
110
111
    ERXMigrationTable rentalTable = database.newTableNamed("rental");
    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);
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.