Package er.extensions.migration

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

37
38
39
40
41
42
43
44
45
46
47
    ERXMigrationTable departmentTable = database.newTableNamed("Department");
    departmentTable.newIntegerColumn("companyID", false);
    departmentTable.newStringColumn("departmentCode", 255, false);
    departmentTable.newIntegerColumn("id", false);
    departmentTable.newStringColumn("name", 255, false);
    departmentTable.create();
     departmentTable.setPrimaryKey("id");

    ERXMigrationTable companyTable = database.newTableNamed("Company");
    companyTable.newStringColumn("address1", 255, true);
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
    departmentTable.newStringColumn("name", 255, false);
    departmentTable.create();
     departmentTable.setPrimaryKey("id");

    ERXMigrationTable companyTable = database.newTableNamed("Company");
    companyTable.newStringColumn("address1", 255, true);
    companyTable.newStringColumn("address2", 255, true);
    companyTable.newStringColumn("city", 255, true);
    companyTable.newIntegerColumn("id", false);
    companyTable.newStringColumn("name", 255, false);
    companyTable.newStringColumn("state", 255, true);
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
    departmentTable.create();
     departmentTable.setPrimaryKey("id");

    ERXMigrationTable companyTable = database.newTableNamed("Company");
    companyTable.newStringColumn("address1", 255, true);
    companyTable.newStringColumn("address2", 255, true);
    companyTable.newStringColumn("city", 255, true);
    companyTable.newIntegerColumn("id", false);
    companyTable.newStringColumn("name", 255, false);
    companyTable.newStringColumn("state", 255, true);
    companyTable.newStringColumn("zipcode", 255, true);
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
     departmentTable.setPrimaryKey("id");

    ERXMigrationTable companyTable = database.newTableNamed("Company");
    companyTable.newStringColumn("address1", 255, true);
    companyTable.newStringColumn("address2", 255, true);
    companyTable.newStringColumn("city", 255, true);
    companyTable.newIntegerColumn("id", false);
    companyTable.newStringColumn("name", 255, false);
    companyTable.newStringColumn("state", 255, true);
    companyTable.newStringColumn("zipcode", 255, true);
    companyTable.create();
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
    ERXMigrationTable companyTable = database.newTableNamed("Company");
    companyTable.newStringColumn("address1", 255, true);
    companyTable.newStringColumn("address2", 255, true);
    companyTable.newStringColumn("city", 255, true);
    companyTable.newIntegerColumn("id", false);
    companyTable.newStringColumn("name", 255, false);
    companyTable.newStringColumn("state", 255, true);
    companyTable.newStringColumn("zipcode", 255, true);
    companyTable.create();
     companyTable.setPrimaryKey("id");
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
    companyTable.newStringColumn("address1", 255, true);
    companyTable.newStringColumn("address2", 255, true);
    companyTable.newStringColumn("city", 255, true);
    companyTable.newIntegerColumn("id", false);
    companyTable.newStringColumn("name", 255, false);
    companyTable.newStringColumn("state", 255, true);
    companyTable.newStringColumn("zipcode", 255, true);
    companyTable.create();
     companyTable.setPrimaryKey("id");

    ERXMigrationTable partial_AuthenticatedPersonTable = database.existingTableNamed("Person");
View Full Code Here
48
49
50
51
52
53
54
55
56
57
58
    companyTable.newStringColumn("address2", 255, true);
    companyTable.newStringColumn("city", 255, true);
    companyTable.newIntegerColumn("id", false);
    companyTable.newStringColumn("name", 255, false);
    companyTable.newStringColumn("state", 255, true);
    companyTable.newStringColumn("zipcode", 255, true);
    companyTable.create();
     companyTable.setPrimaryKey("id");

    ERXMigrationTable partial_AuthenticatedPersonTable = database.existingTableNamed("Person");
    partial_AuthenticatedPersonTable.newTimestampColumn("lastLoginDate", true);
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
    companyTable.create();
     companyTable.setPrimaryKey("id");

    ERXMigrationTable partial_AuthenticatedPersonTable = database.existingTableNamed("Person");
    partial_AuthenticatedPersonTable.newTimestampColumn("lastLoginDate", true);
    partial_AuthenticatedPersonTable.newStringColumn("password", 255, true);
    partial_AuthenticatedPersonTable.newStringColumn("username", 255, true);

    ERXMigrationTable partial_EmployeePersonTable = database.existingTableNamed("Person");
    partial_EmployeePersonTable.newIntegerColumn("departmentID", true);
    partial_EmployeePersonTable.newStringColumn("employeeNumber", 255, true);
View Full Code Here
55
56
57
58
59
60
61
62
63
64
65
     companyTable.setPrimaryKey("id");

    ERXMigrationTable partial_AuthenticatedPersonTable = database.existingTableNamed("Person");
    partial_AuthenticatedPersonTable.newTimestampColumn("lastLoginDate", true);
    partial_AuthenticatedPersonTable.newStringColumn("password", 255, true);
    partial_AuthenticatedPersonTable.newStringColumn("username", 255, true);

    ERXMigrationTable partial_EmployeePersonTable = database.existingTableNamed("Person");
    partial_EmployeePersonTable.newIntegerColumn("departmentID", true);
    partial_EmployeePersonTable.newStringColumn("employeeNumber", 255, true);
    partial_EmployeePersonTable.newIntegerColumn("employeeTypeID", true);
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
    partial_AuthenticatedPersonTable.newStringColumn("password", 255, true);
    partial_AuthenticatedPersonTable.newStringColumn("username", 255, true);

    ERXMigrationTable partial_EmployeePersonTable = database.existingTableNamed("Person");
    partial_EmployeePersonTable.newIntegerColumn("departmentID", true);
    partial_EmployeePersonTable.newStringColumn("employeeNumber", 255, true);
    partial_EmployeePersonTable.newIntegerColumn("employeeTypeID", true);
    partial_EmployeePersonTable.newBigDecimalColumn("salary", 38, 2, true);

    partial_EmployeePersonTable.addForeignKey("departmentID", "Department", "id");
    partial_EmployeePersonTable.addForeignKey("employeeTypeID", "EmployeeType", "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.