/** * 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)); }
/** * 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)); }
/** * 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()); }