/**
   * The doBuild() method builds the DatabaseMap
   *
   * @throws TorqueException
   */
  public void doBuild() throws TorqueException {
    dbMap = Torque.getDatabaseMap("brihaspati");

    dbMap.addTable("DB_RECEIVE");
    TableMap tMap = dbMap.getTable("DB_RECEIVE");

    tMap.setPrimaryKeyMethod("none");

    tMap.addPrimaryKey("DB_RECEIVE.MSG_ID", new Integer(0));
    tMap.addPrimaryKey("DB_RECEIVE.RECEIVER_ID", new Integer(0));
    tMap.addColumn("DB_RECEIVE.GROUP_ID", new Integer(0));
    tMap.addColumn("DB_RECEIVE.READ_FLAG", new Integer(0));
  }
  /**
   * The doBuild() method builds the DatabaseMap
   *
   * @throws TorqueException
   */
  public void doBuild() throws TorqueException {
    dbMap = Torque.getDatabaseMap("inventorysystemdb");

    dbMap.addTable("user");
    TableMap tMap = dbMap.getTable("user");

    tMap.setPrimaryKeyMethod(TableMap.NATIVE);

    tMap.addPrimaryKey("user.USER_ID", new Integer(0));
    tMap.addColumn("user.EMPLOYEENUMBER", new String());
    tMap.addColumn("user.FIRSTNAME", new String());
    tMap.addColumn("user.MIDDLENAME", new String());
    tMap.addColumn("user.LASTNAME", new String());
    tMap.addColumn("user.USERNAME", new String());
    tMap.addColumn("user.PASSWORD", new String());
    tMap.addPrimaryKey("user.CONTACTNUMBER", new String());
    tMap.addColumn("user.DIVISION", new String());
    tMap.addColumn("user.TYPE", new String());
    tMap.addColumn("user.STATUS", new Integer(0));
  }
Example #3
0
  /**
   * The doBuild() method builds the DatabaseMap
   *
   * @throws TorqueException
   */
  public void doBuild() throws TorqueException {
    dbMap = Torque.getDatabaseMap("dream");

    dbMap.addTable("DISTRIBUTOR");
    TableMap tMap = dbMap.getTable("DISTRIBUTOR");

    tMap.setPrimaryKeyMethod(TableMap.NATIVE);

    tMap.setPrimaryKeyMethodInfo("DISTRIBUTOR_SEQ");

    tMap.addPrimaryKey("DISTRIBUTOR.DISTRIBUTOR_ID", new Integer(0));
    tMap.addColumn("DISTRIBUTOR.DISTRIBUTOR_CODE", new String());
    tMap.addColumn("DISTRIBUTOR.STATUS", new Integer(0));
    tMap.addColumn("DISTRIBUTOR.DISTRIBUTOR_NAME_1", new String());
    tMap.addColumn("DISTRIBUTOR.DISTRIBUTOR_NAME_2", new String());
    tMap.addColumn("DISTRIBUTOR.DISTRIBUTOR_DISPLAY", new String());
    tMap.addColumn("DISTRIBUTOR.DEAR", new String());
    tMap.addColumn("DISTRIBUTOR.DISTRIBUTOR_TYPE", new Integer(0));
    tMap.addColumn("DISTRIBUTOR.GENDER", new Integer(0));
    tMap.addForeignKey(
        "DISTRIBUTOR.DISTRIBUTOR_CAT_ID",
        new Integer(0),
        "DISTRIBUTOR_CATEGORY",
        "DISTRIBUTOR_CAT_ID");
    tMap.addForeignKey("DISTRIBUTOR.LANGUAGE_ID", new Integer(0), "LANGUAGE", "LANGUAGE_ID");
    tMap.addColumn("DISTRIBUTOR.ADDRESS_1", new String());
    tMap.addColumn("DISTRIBUTOR.ADDRESS_2", new String());
    tMap.addColumn("DISTRIBUTOR.CITY", new String());
    tMap.addColumn("DISTRIBUTOR.ZIP", new String());
    tMap.addColumn("DISTRIBUTOR.STATE", new String());
    tMap.addForeignKey("DISTRIBUTOR.COUNTRY_ID", new Integer(0), "COUNTRY", "COUNTRY_ID");
    tMap.addForeignKey("DISTRIBUTOR.REGION_ID", new Integer(0), "REGION", "REGION_ID");
    tMap.addColumn("DISTRIBUTOR.PHONE_1", new String());
    tMap.addColumn("DISTRIBUTOR.PHONE_2", new String());
    tMap.addColumn("DISTRIBUTOR.FAX", new String());
    tMap.addColumn("DISTRIBUTOR.EMAIL", new String());
    tMap.addColumn("DISTRIBUTOR.EMAIL_FORMAT", new Integer(0));
    tMap.addColumn("DISTRIBUTOR.SEND_NEWS", new Integer(0));
    tMap.addColumn("DISTRIBUTOR.WEB_URL", new String());
    tMap.addColumn("DISTRIBUTOR.CUSTOM_1", new String());
    tMap.addColumn("DISTRIBUTOR.CUSTOM_2", new String());
    tMap.addColumn("DISTRIBUTOR.CUSTOM_3", new String());
    tMap.addColumn("DISTRIBUTOR.CUSTOM_4", new String());
    tMap.addColumn("DISTRIBUTOR.CUSTOM_5", new String());
    tMap.addColumn("DISTRIBUTOR.CUSTOM_6", new String());
    tMap.addColumn("DISTRIBUTOR.NOTES", new String());
    tMap.addColumn("DISTRIBUTOR.CREATED", new Date());
    tMap.addColumn("DISTRIBUTOR.MODIFIED", new Date());
    tMap.addColumn("DISTRIBUTOR.CREATED_BY", new String());
    tMap.addColumn("DISTRIBUTOR.MODIFIED_BY", new String());
  }
  /**
   * The doBuild() method builds the DatabaseMap
   *
   * @throws TorqueException
   */
  public void doBuild() throws TorqueException {
    dbMap = Torque.getDatabaseMap("brihaspati");

    dbMap.addTable("USER_CONFIGURATION");
    TableMap tMap = dbMap.getTable("USER_CONFIGURATION");

    tMap.setPrimaryKeyMethod("none");

    tMap.addPrimaryKey("USER_CONFIGURATION.USER_ID", new Integer(0));
    tMap.addColumn("USER_CONFIGURATION.QUESTION_ID", new Integer(0));
    tMap.addColumn("USER_CONFIGURATION.ANSWER", new String());
    tMap.addColumn("USER_CONFIGURATION.LIST_CONFIGURATION", new Integer(0));
    tMap.addColumn("USER_CONFIGURATION.PHOTO", new String());
    tMap.addColumn("USER_CONFIGURATION.TASK_CONFIGURATION", new Integer(0));
  }
  /**
   * The doBuild() method builds the DatabaseMap
   *
   * @throws TorqueException
   */
  public void doBuild() throws TorqueException {
    dbMap = Torque.getDatabaseMap("default");

    dbMap.addTable("JETSPEED_USER_PROFILE");
    TableMap tMap = dbMap.getTable("JETSPEED_USER_PROFILE");

    tMap.setPrimaryKeyMethod(TableMap.NATIVE);

    tMap.setPrimaryKeyMethodInfo("JETSPEED_USER_PROFILE");

    tMap.addPrimaryKey("JETSPEED_USER_PROFILE.PSML_ID", new Integer(0));
    tMap.addColumn("JETSPEED_USER_PROFILE.USER_NAME", new String());
    tMap.addColumn("JETSPEED_USER_PROFILE.MEDIA_TYPE", new String());
    tMap.addColumn("JETSPEED_USER_PROFILE.LANGUAGE", new String());
    tMap.addColumn("JETSPEED_USER_PROFILE.COUNTRY", new String());
    tMap.addColumn("JETSPEED_USER_PROFILE.PAGE", new String());
    tMap.addColumn("JETSPEED_USER_PROFILE.PROFILE", new Object());
  }
  /**
   * The doBuild() method builds the DatabaseMap
   *
   * @throws TorqueException
   */
  public void doBuild() throws TorqueException {
    dbMap = Torque.getDatabaseMap("brihaspati");

    dbMap.addTable("TURBINE_USER");
    TableMap tMap = dbMap.getTable("TURBINE_USER");

    tMap.setPrimaryKeyMethod(TableMap.ID_BROKER);

    tMap.setPrimaryKeyMethodInfo(tMap.getName());

    tMap.addPrimaryKey("TURBINE_USER.USER_ID", new Integer(0));
    tMap.addColumn("TURBINE_USER.LOGIN_NAME", new String());
    tMap.addColumn("TURBINE_USER.PASSWORD_VALUE", new String());
    tMap.addColumn("TURBINE_USER.FIRST_NAME", new String());
    tMap.addColumn("TURBINE_USER.LAST_NAME", new String());
    tMap.addColumn("TURBINE_USER.EMAIL", new String());
    tMap.addColumn("TURBINE_USER.CONFIRM_VALUE", new String());
    tMap.addColumn("TURBINE_USER.MODIFIED", new Date());
    tMap.addColumn("TURBINE_USER.CREATED", new Date());
    tMap.addColumn("TURBINE_USER.LAST_LOGIN", new Date());
    tMap.addColumn("TURBINE_USER.OBJECTDATA", new Object());
    tMap.addColumn("TURBINE_USER.QUOTA", new BigDecimal(0));
  }
Example #7
0
  /**
   * The doBuild() method builds the DatabaseMap
   *
   * @throws TorqueException
   */
  public void doBuild() throws TorqueException {
    dbMap = Torque.getDatabaseMap("default");

    dbMap.addTable("TURBINE_USER");
    TableMap tMap = dbMap.getTable("TURBINE_USER");

    tMap.setPrimaryKeyMethod(TableMap.NATIVE);

    tMap.setPrimaryKeyMethodInfo("TURBINE_USER");

    tMap.addPrimaryKey("TURBINE_USER.USER_ID", new Integer(0));
    tMap.addColumn("TURBINE_USER.LOGIN_NAME", new String());
    tMap.addColumn("TURBINE_USER.PASSWORD_VALUE", new String());
    tMap.addColumn("TURBINE_USER.FIRST_NAME", new String());
    tMap.addColumn("TURBINE_USER.LAST_NAME", new String());
    tMap.addColumn("TURBINE_USER.EMAIL", new String());
    tMap.addColumn("TURBINE_USER.CONFIRM_VALUE", new String());
    tMap.addColumn("TURBINE_USER.MODIFIED", new Date());
    tMap.addColumn("TURBINE_USER.CREATED", new Date());
    tMap.addColumn("TURBINE_USER.LAST_LOGIN", new Date());
    tMap.addColumn("TURBINE_USER.DISABLED", new String());
    tMap.addColumn("TURBINE_USER.OBJECTDATA", new Object());
    tMap.addColumn("TURBINE_USER.PASSWORD_CHANGED", new Date());
  }