/*******************************************************************************
 * Copyright (c) 1998, 2013 Oracle and/or its affiliates. All rights reserved.
 * This program and the accompanying materials are made available under the 
 * terms of the Eclipse Public License v1.0 and Eclipse Distribution License v. 1.0 
 * which accompanies this distribution. 
 * The Eclipse Public License is available at http://www.eclipse.org/legal/epl-v10.html
 * and the Eclipse Distribution License is available at 
 * http://www.eclipse.org/org/documents/edl-v10.php.
 *
 * Contributors:
 *     dminsky - initial API and implementation
 ******************************************************************************/  
package org.eclipse.persistence.testing.models.optimisticlocking;

import org.eclipse.persistence.tools.schemaframework.*;

/**
 * This class was generated by the TopLink table creator generator.
 * It stores the meta-data (tables) that define the database schema.
 * @see org.eclipse.persistence.sessions.factories.TableCreatorClassGenerator
 */

public class GamesConsoleTableCreator extends org.eclipse.persistence.tools.schemaframework.TableCreator {

public GamesConsoleTableCreator() {
    setName("GamesConsoleSystem");
    
    addTableDefinition(buildOL_CONTROLLERTable());
    addTableDefinition(buildOL_CAMERATable());
    addTableDefinition(buildOL_CONSOLETable());
    addTableDefinition(buildOL_GAMERTable());
    addTableDefinition(buildOL_CONSOLE_OL_GAMERTable());
    addTableDefinition(buildOL_SKILLTable());
}

public TableDefinition buildOL_CAMERATable() {
    TableDefinition table = new TableDefinition();
    table.setName("OL_CAMERA");
    
    FieldDefinition fieldDESCRIPTION = new FieldDefinition();
    fieldDESCRIPTION.setName("DESCRIPTION");
    fieldDESCRIPTION.setTypeName("VARCHAR2");
    fieldDESCRIPTION.setSize(32);
    fieldDESCRIPTION.setSubSize(0);
    fieldDESCRIPTION.setIsPrimaryKey(false);
    fieldDESCRIPTION.setIsIdentity(false);
    fieldDESCRIPTION.setUnique(false);
    fieldDESCRIPTION.setShouldAllowNull(true);
    table.addField(fieldDESCRIPTION);
    
    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("ID");
    fieldID.setTypeName("NUMBER");
    fieldID.setSize(0);
    fieldID.setSubSize(0);
    fieldID.setIsPrimaryKey(true);
    fieldID.setIsIdentity(false);
    fieldID.setUnique(false);
    fieldID.setShouldAllowNull(false);
    table.addField(fieldID);
    
    FieldDefinition fieldNAME = new FieldDefinition();
    fieldNAME.setName("NAME");
    fieldNAME.setTypeName("VARCHAR2");
    fieldNAME.setSize(32);
    fieldNAME.setSubSize(0);
    fieldNAME.setIsPrimaryKey(false);
    fieldNAME.setIsIdentity(false);
    fieldNAME.setUnique(false);
    fieldNAME.setShouldAllowNull(true);
    table.addField(fieldNAME);
    
    FieldDefinition fieldUPDATED = new FieldDefinition();
    fieldUPDATED.setName("UPDATED");
    fieldUPDATED.setTypeName("TIMESTAMP");
    fieldUPDATED.setSize(0);
    fieldUPDATED.setSubSize(0);
    fieldUPDATED.setIsPrimaryKey(false);
    fieldUPDATED.setIsIdentity(false);
    fieldUPDATED.setUnique(false);
    fieldUPDATED.setShouldAllowNull(true);
    table.addField(fieldUPDATED);
    
    FieldDefinition fieldVERSION = new FieldDefinition();
    fieldVERSION.setName("VERSION");
    fieldVERSION.setTypeName("NUMBER");
    fieldVERSION.setSize(0);
    fieldVERSION.setSubSize(0);
    fieldVERSION.setIsPrimaryKey(false);
    fieldVERSION.setIsIdentity(false);
    fieldVERSION.setUnique(false);
    fieldVERSION.setShouldAllowNull(true);
    table.addField(fieldVERSION);
    
    return table;
}

public TableDefinition buildOL_CONSOLETable() {
    TableDefinition table = new TableDefinition();
    table.setName("OL_CONSOLE");
    
    FieldDefinition fieldCAMERA_ID = new FieldDefinition();
    fieldCAMERA_ID.setName("CAMERA_ID");
    fieldCAMERA_ID.setTypeName("NUMBER");
    fieldCAMERA_ID.setSize(0);
    fieldCAMERA_ID.setSubSize(0);
    fieldCAMERA_ID.setIsPrimaryKey(false);
    fieldCAMERA_ID.setIsIdentity(false);
    fieldCAMERA_ID.setUnique(false);
    fieldCAMERA_ID.setShouldAllowNull(true);
    table.addField(fieldCAMERA_ID);
    
    FieldDefinition fieldDESCRIPTION = new FieldDefinition();
    fieldDESCRIPTION.setName("DESCRIPTION");
    fieldDESCRIPTION.setTypeName("VARCHAR2");
    fieldDESCRIPTION.setSize(32);
    fieldDESCRIPTION.setSubSize(0);
    fieldDESCRIPTION.setIsPrimaryKey(false);
    fieldDESCRIPTION.setIsIdentity(false);
    fieldDESCRIPTION.setUnique(false);
    fieldDESCRIPTION.setShouldAllowNull(true);
    table.addField(fieldDESCRIPTION);
    
    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("ID");
    fieldID.setTypeName("NUMBER");
    fieldID.setSize(0);
    fieldID.setSubSize(0);
    fieldID.setIsPrimaryKey(true);
    fieldID.setIsIdentity(false);
    fieldID.setUnique(false);
    fieldID.setShouldAllowNull(false);
    table.addField(fieldID);
    
    FieldDefinition fieldNAME = new FieldDefinition();
    fieldNAME.setName("NAME");
    fieldNAME.setTypeName("VARCHAR2");
    fieldNAME.setSize(32);
    fieldNAME.setSubSize(0);
    fieldNAME.setIsPrimaryKey(false);
    fieldNAME.setIsIdentity(false);
    fieldNAME.setUnique(false);
    fieldNAME.setShouldAllowNull(true);
    table.addField(fieldNAME);
    
    FieldDefinition fieldPSU_ON = new FieldDefinition();
    fieldPSU_ON.setName("PSU_ON");
    fieldPSU_ON.setTypeName("CHAR");
    fieldPSU_ON.setSize(0);
    fieldPSU_ON.setSubSize(0);
    fieldPSU_ON.setIsPrimaryKey(false);
    fieldPSU_ON.setIsIdentity(false);
    fieldPSU_ON.setUnique(false);
    fieldPSU_ON.setShouldAllowNull(true);
    table.addField(fieldPSU_ON);
    
    FieldDefinition fieldPSU_SERIAL = new FieldDefinition();
    fieldPSU_SERIAL.setName("PSU_SERIAL");
    fieldPSU_SERIAL.setTypeName("VARCHAR2");
    fieldPSU_SERIAL.setSize(32);
    fieldPSU_SERIAL.setSubSize(0);
    fieldPSU_SERIAL.setIsPrimaryKey(false);
    fieldPSU_SERIAL.setIsIdentity(false);
    fieldPSU_SERIAL.setUnique(false);
    fieldPSU_SERIAL.setShouldAllowNull(true);
    table.addField(fieldPSU_SERIAL);
    
    FieldDefinition fieldUPDATED = new FieldDefinition();
    fieldUPDATED.setName("UPDATED");
    fieldUPDATED.setTypeName("TIMESTAMP");
    fieldUPDATED.setSize(0);
    fieldUPDATED.setSubSize(0);
    fieldUPDATED.setIsPrimaryKey(false);
    fieldUPDATED.setIsIdentity(false);
    fieldUPDATED.setUnique(false);
    fieldUPDATED.setShouldAllowNull(true);
    table.addField(fieldUPDATED);
    
    FieldDefinition fieldVERSION = new FieldDefinition();
    fieldVERSION.setName("VERSION");
    fieldVERSION.setTypeName("NUMBER");
    fieldVERSION.setSize(0);
    fieldVERSION.setSubSize(0);
    fieldVERSION.setIsPrimaryKey(false);
    fieldVERSION.setIsIdentity(false);
    fieldVERSION.setUnique(false);
    fieldVERSION.setShouldAllowNull(true);
    table.addField(fieldVERSION);
    
    ForeignKeyConstraint foreignKeyOL_CONSOLE_OL_CAMERA = new ForeignKeyConstraint();
    foreignKeyOL_CONSOLE_OL_CAMERA.setName("OL_CONSOLE_OL_CAMERA");
    foreignKeyOL_CONSOLE_OL_CAMERA.setTargetTable("OL_CAMERA");
    foreignKeyOL_CONSOLE_OL_CAMERA.addSourceField("CAMERA_ID");
    foreignKeyOL_CONSOLE_OL_CAMERA.addTargetField("ID");
    table.addForeignKeyConstraint(foreignKeyOL_CONSOLE_OL_CAMERA);
    
    return table;
}

public TableDefinition buildOL_CONSOLE_OL_GAMERTable() {
    TableDefinition table = new TableDefinition();
    table.setName("OL_CONSOLE_OL_GAMER");
    
    FieldDefinition fieldCONSOLE_ID = new FieldDefinition();
    fieldCONSOLE_ID.setName("CONSOLE_ID");
    fieldCONSOLE_ID.setTypeName("NUMBER");
    fieldCONSOLE_ID.setSize(0);
    fieldCONSOLE_ID.setSubSize(0);
    fieldCONSOLE_ID.setIsPrimaryKey(false);
    fieldCONSOLE_ID.setIsIdentity(false);
    fieldCONSOLE_ID.setUnique(false);
    fieldCONSOLE_ID.setShouldAllowNull(false);
    table.addField(fieldCONSOLE_ID);
    
    FieldDefinition fieldGAMER_ID = new FieldDefinition();
    fieldGAMER_ID.setName("GAMER_ID");
    fieldGAMER_ID.setTypeName("NUMBER");
    fieldGAMER_ID.setSize(0);
    fieldGAMER_ID.setSubSize(0);
    fieldGAMER_ID.setIsPrimaryKey(false);
    fieldGAMER_ID.setIsIdentity(false);
    fieldGAMER_ID.setUnique(false);
    fieldGAMER_ID.setShouldAllowNull(false);
    table.addField(fieldGAMER_ID);
    
    return table;
}

public TableDefinition buildOL_CONTROLLERTable() {
    TableDefinition table = new TableDefinition();
    table.setName("OL_CONTROLLER");
    
    FieldDefinition fieldDESCRIPTION = new FieldDefinition();
    fieldDESCRIPTION.setName("DESCRIPTION");
    fieldDESCRIPTION.setTypeName("VARCHAR2");
    fieldDESCRIPTION.setSize(32);
    fieldDESCRIPTION.setSubSize(0);
    fieldDESCRIPTION.setIsPrimaryKey(false);
    fieldDESCRIPTION.setIsIdentity(false);
    fieldDESCRIPTION.setUnique(false);
    fieldDESCRIPTION.setShouldAllowNull(true);
    table.addField(fieldDESCRIPTION);
    
    FieldDefinition fieldCONSOLE_ID = new FieldDefinition();
    fieldCONSOLE_ID.setName("CONSOLE_ID");
    fieldCONSOLE_ID.setTypeName("NUMBER");
    fieldCONSOLE_ID.setSize(0);
    fieldCONSOLE_ID.setSubSize(0);
    fieldCONSOLE_ID.setIsPrimaryKey(false);
    fieldCONSOLE_ID.setIsIdentity(false);
    fieldCONSOLE_ID.setUnique(false);
    fieldCONSOLE_ID.setShouldAllowNull(true);
    table.addField(fieldCONSOLE_ID);
    
    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("ID");
    fieldID.setTypeName("NUMBER");
    fieldID.setSize(0);
    fieldID.setSubSize(0);
    fieldID.setIsPrimaryKey(true);
    fieldID.setIsIdentity(false);
    fieldID.setUnique(false);
    fieldID.setShouldAllowNull(false);
    table.addField(fieldID);
    
    FieldDefinition fieldNAME = new FieldDefinition();
    fieldNAME.setName("NAME");
    fieldNAME.setTypeName("VARCHAR2");
    fieldNAME.setSize(32);
    fieldNAME.setSubSize(0);
    fieldNAME.setIsPrimaryKey(false);
    fieldNAME.setIsIdentity(false);
    fieldNAME.setUnique(false);
    fieldNAME.setShouldAllowNull(true);
    table.addField(fieldNAME);
    
    FieldDefinition fieldUPDATED = new FieldDefinition();
    fieldUPDATED.setName("UPDATED");
    fieldUPDATED.setTypeName("TIMESTAMP");
    fieldUPDATED.setSize(0);
    fieldUPDATED.setSubSize(0);
    fieldUPDATED.setIsPrimaryKey(false);
    fieldUPDATED.setIsIdentity(false);
    fieldUPDATED.setUnique(false);
    fieldUPDATED.setShouldAllowNull(true);
    table.addField(fieldUPDATED);
    
    FieldDefinition fieldVERSION = new FieldDefinition();
    fieldVERSION.setName("VERSION");
    fieldVERSION.setTypeName("NUMBER");
    fieldVERSION.setSize(0);
    fieldVERSION.setSubSize(0);
    fieldVERSION.setIsPrimaryKey(false);
    fieldVERSION.setIsIdentity(false);
    fieldVERSION.setUnique(false);
    fieldVERSION.setShouldAllowNull(true);
    table.addField(fieldVERSION);
    
    ForeignKeyConstraint foreignKeyOL_CONTROLLER_OL_CONSOLE = new ForeignKeyConstraint();
    foreignKeyOL_CONTROLLER_OL_CONSOLE.setName("OL_CONTROLLER_OL_CONSOLE");
    foreignKeyOL_CONTROLLER_OL_CONSOLE.setTargetTable("OL_CONSOLE");
    foreignKeyOL_CONTROLLER_OL_CONSOLE.addSourceField("CONSOLE_ID");
    foreignKeyOL_CONTROLLER_OL_CONSOLE.addTargetField("ID");
    table.addForeignKeyConstraint(foreignKeyOL_CONTROLLER_OL_CONSOLE);
    
    return table;
}

public TableDefinition buildOL_GAMERTable() {
    TableDefinition table = new TableDefinition();
    table.setName("OL_GAMER");
    
    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("ID");
    fieldID.setTypeName("NUMBER");
    fieldID.setSize(0);
    fieldID.setSubSize(0);
    fieldID.setIsPrimaryKey(true);
    fieldID.setIsIdentity(false);
    fieldID.setUnique(false);
    fieldID.setShouldAllowNull(false);
    table.addField(fieldID);
    
    FieldDefinition fieldNAME = new FieldDefinition();
    fieldNAME.setName("NAME");
    fieldNAME.setTypeName("VARCHAR2");
    fieldNAME.setSize(32);
    fieldNAME.setSubSize(0);
    fieldNAME.setIsPrimaryKey(false);
    fieldNAME.setIsIdentity(false);
    fieldNAME.setUnique(false);
    fieldNAME.setShouldAllowNull(true);
    table.addField(fieldNAME);
    
    FieldDefinition fieldDESCRIPTION = new FieldDefinition();
    fieldDESCRIPTION.setName("DESCRIPTION");
    fieldDESCRIPTION.setTypeName("VARCHAR2");
    fieldDESCRIPTION.setSize(32);
    fieldDESCRIPTION.setSubSize(0);
    fieldDESCRIPTION.setIsPrimaryKey(false);
    fieldDESCRIPTION.setIsIdentity(false);
    fieldDESCRIPTION.setUnique(false);
    fieldDESCRIPTION.setShouldAllowNull(true);
    table.addField(fieldDESCRIPTION);
    
    FieldDefinition fieldVERSION = new FieldDefinition();
    fieldVERSION.setName("VERSION");
    fieldVERSION.setTypeName("NUMBER");
    fieldVERSION.setSize(0);
    fieldVERSION.setSubSize(0);
    fieldVERSION.setIsPrimaryKey(false);
    fieldVERSION.setIsIdentity(false);
    fieldVERSION.setUnique(false);
    fieldVERSION.setShouldAllowNull(true);
    table.addField(fieldVERSION);
    
    FieldDefinition fieldUPDATED = new FieldDefinition();
    fieldUPDATED.setName("UPDATED");
    fieldUPDATED.setTypeName("TIMESTAMP");
    fieldUPDATED.setSize(0);
    fieldUPDATED.setSubSize(0);
    fieldUPDATED.setIsPrimaryKey(false);
    fieldUPDATED.setIsIdentity(false);
    fieldUPDATED.setUnique(false);
    fieldUPDATED.setShouldAllowNull(true);
    table.addField(fieldUPDATED);
    
    FieldDefinition fieldSKILL_INDICATOR = new FieldDefinition();
    fieldSKILL_INDICATOR.setName("SKILL_INDICATOR");
    fieldSKILL_INDICATOR.setTypeName("VARCHAR2");
    fieldSKILL_INDICATOR.setSize(32);
    fieldSKILL_INDICATOR.setSubSize(0);
    fieldSKILL_INDICATOR.setIsPrimaryKey(false);
    fieldSKILL_INDICATOR.setIsIdentity(false);
    fieldSKILL_INDICATOR.setUnique(false);
    fieldSKILL_INDICATOR.setShouldAllowNull(true);
    table.addField(fieldSKILL_INDICATOR);
    
    FieldDefinition fieldSKILL_ID = new FieldDefinition();
    fieldSKILL_ID.setName("SKILL_ID");
    fieldSKILL_ID.setTypeName("NUMBER");
    fieldSKILL_ID.setSize(0);
    fieldSKILL_ID.setSubSize(0);
    fieldSKILL_ID.setIsPrimaryKey(false);
    fieldSKILL_ID.setIsIdentity(false);
    fieldSKILL_ID.setUnique(false);
    fieldSKILL_ID.setShouldAllowNull(true);
    table.addField(fieldSKILL_ID);
    
    ForeignKeyConstraint foreignKeyOL_GAMER_OL_SKILL = new ForeignKeyConstraint();
    foreignKeyOL_GAMER_OL_SKILL.setName("OL_GAMER_OL_SKILL");
    foreignKeyOL_GAMER_OL_SKILL.setTargetTable("OL_SKILL");
    foreignKeyOL_GAMER_OL_SKILL.addSourceField("SKILL_ID");
    foreignKeyOL_GAMER_OL_SKILL.addTargetField("ID");
    table.addForeignKeyConstraint(foreignKeyOL_GAMER_OL_SKILL);
    
    return table;
}

public TableDefinition buildOL_SKILLTable() {
    TableDefinition table = new TableDefinition();
    table.setName("OL_SKILL");
    
    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("ID");
    fieldID.setTypeName("NUMBER");
    fieldID.setSize(0);
    fieldID.setSubSize(0);
    fieldID.setIsPrimaryKey(true);
    fieldID.setIsIdentity(false);
    fieldID.setUnique(false);
    fieldID.setShouldAllowNull(false);
    table.addField(fieldID);
    
    FieldDefinition fieldNAME = new FieldDefinition();
    fieldNAME.setName("NAME");
    fieldNAME.setTypeName("VARCHAR2");
    fieldNAME.setSize(32);
    fieldNAME.setSubSize(0);
    fieldNAME.setIsPrimaryKey(false);
    fieldNAME.setIsIdentity(false);
    fieldNAME.setUnique(false);
    fieldNAME.setShouldAllowNull(true);
    table.addField(fieldNAME);
    
    FieldDefinition fieldVERSION = new FieldDefinition();
    fieldVERSION.setName("VERSION");
    fieldVERSION.setTypeName("NUMBER");
    fieldVERSION.setSize(0);
    fieldVERSION.setSubSize(0);
    fieldVERSION.setIsPrimaryKey(false);
    fieldVERSION.setIsIdentity(false);
    fieldVERSION.setUnique(false);
    fieldVERSION.setShouldAllowNull(true);
    table.addField(fieldVERSION);
    
    FieldDefinition fieldDESCRIPTION = new FieldDefinition();
    fieldDESCRIPTION.setName("DESCRIPTION");
    fieldDESCRIPTION.setTypeName("VARCHAR2");
    fieldDESCRIPTION.setSize(32);
    fieldDESCRIPTION.setSubSize(0);
    fieldDESCRIPTION.setIsPrimaryKey(false);
    fieldDESCRIPTION.setIsIdentity(false);
    fieldDESCRIPTION.setUnique(false);
    fieldDESCRIPTION.setShouldAllowNull(true);
    table.addField(fieldDESCRIPTION);
    
    FieldDefinition fieldUPDATED = new FieldDefinition();
    fieldUPDATED.setName("UPDATED");
    fieldUPDATED.setTypeName("TIMESTAMP");
    fieldUPDATED.setSize(0);
    fieldUPDATED.setSubSize(0);
    fieldUPDATED.setIsPrimaryKey(false);
    fieldUPDATED.setIsIdentity(false);
    fieldUPDATED.setUnique(false);
    fieldUPDATED.setShouldAllowNull(true);
    table.addField(fieldUPDATED);
    
    return table;
}

}