Package er.extensions.migration

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

41
42
43
44
45
46
47
48
49
50
51
    employeeTable.setPrimaryKey("id");
    employeeTable.addForeignKey("companyID", "Company", "id");

    ERXMigrationTable roleTable = database.newTableNamed("Role");
    roleTable.newIntegerColumn("id", false);
    roleTable.create();
    roleTable.setPrimaryKey("id");

    ERXMigrationTable employeeRoleTable = database.newTableNamed("EmployeeRole");
    employeeRoleTable.newIntegerColumn("employeeId", false);
    employeeRoleTable.newIntegerColumn("roleId", false);
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
    roleTable.setPrimaryKey("id");

    ERXMigrationTable employeeRoleTable = database.newTableNamed("EmployeeRole");
    employeeRoleTable.newIntegerColumn("employeeId", false);
    employeeRoleTable.newIntegerColumn("roleId", false);
    employeeRoleTable.create();
    employeeRoleTable.setPrimaryKey("employeeId", "roleId");
    employeeRoleTable.addForeignKey("employeeId", "Employee", "id");
    employeeRoleTable.addForeignKey("roleId", "Role", "id");

    ERXMigrationTable paycheckTable = database.newTableNamed("Paycheck");
View Full Code Here
58
59
60
61
62
63
64
65
66
67
    paycheckTable.newBigDecimalColumn("amount", 38, 2, false);
    paycheckTable.newBooleanColumn("cashed", false);
    paycheckTable.newIntegerColumn("employeeID", false);
    paycheckTable.newIntegerColumn("id", false);
    paycheckTable.newTimestampColumn("paymentDate", false);
    paycheckTable.create();
    paycheckTable.setPrimaryKey("id");
    paycheckTable.addForeignKey("employeeID", "Employee", "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.