PHP Propel::getDatabaseMap方法代码示例

 public function doBuild()
 {
     $this->dbMap = Propel::getDatabaseMap('propel');
     $tMap = $this->dbMap->addTable('ng_test_applicant_parents');
     $tMap->setPhpName('NgTestApplicantParents');
     $tMap->setUseIdGenerator(true);
     $tMap->addPrimaryKey('ID', 'Id', 'int', CreoleTypes::INTEGER, true, null);
     $tMap->addForeignKey('NG_TEST_APPLICANT_ID', 'NgTestApplicantId', 'int', CreoleTypes::INTEGER, 'ng_test_applicant', 'ID', false, null);
     $tMap->addForeignKey('RELIGION_ID', 'ReligionId', 'int', CreoleTypes::INTEGER, 'religion', 'ID', false, null);
     $tMap->addForeignKey('DEGREE_ID', 'DegreeId', 'int', CreoleTypes::INTEGER, 'degree', 'ID', false, null);
     $tMap->addForeignKey('SALARY_ID', 'SalaryId', 'int', CreoleTypes::INTEGER, 'salary', 'ID', false, null);
     $tMap->addForeignKey('JOB_TYPE_ID', 'JobTypeId', 'int', CreoleTypes::INTEGER, 'job_type', 'ID', false, null);
     $tMap->addColumn('RELATION', 'Relation', 'int', CreoleTypes::INTEGER, false, null);
     $tMap->addColumn('NAME', 'Name', 'string', CreoleTypes::VARCHAR, false, 255);
     $tMap->addColumn('POB', 'Pob', 'string', CreoleTypes::VARCHAR, false, 128);
     $tMap->addColumn('DOB', 'Dob', 'int', CreoleTypes::DATE, false, null);
     $tMap->addColumn('JOB_DETAIL', 'JobDetail', 'string', CreoleTypes::VARCHAR, false, 255);
     $tMap->addColumn('CELLPHONE', 'Cellphone', 'string', CreoleTypes::VARCHAR, false, 128);
     $tMap->addColumn('HOMEPHONE', 'Homephone', 'string', CreoleTypes::VARCHAR, false, 128);
     $tMap->addColumn('EMAIL', 'Email', 'string', CreoleTypes::VARCHAR, false, 128);
     $tMap->addForeignKey('COUNTRY_ID', 'CountryId', 'int', CreoleTypes::INTEGER, 'country', 'ID', false, null);
     $tMap->addForeignKey('REGION_ID', 'RegionId', 'int', CreoleTypes::INTEGER, 'region', 'ID', false, null);
     $tMap->addForeignKey('CITY_ID', 'CityId', 'int', CreoleTypes::INTEGER, 'city', 'ID', false, null);
     $tMap->addForeignKey('DISTRICT_ID', 'DistrictId', 'int', CreoleTypes::INTEGER, 'district', 'ID', false, null);
     $tMap->addForeignKey('SUBDISTRICT_ID', 'SubdistrictId', 'int', CreoleTypes::INTEGER, 'subdistrict', 'ID', false, null);
     $tMap->addColumn('POSTCODE', 'Postcode', 'string', CreoleTypes::VARCHAR, false, 64);
     $tMap->addColumn('OFFICE_NAME', 'OfficeName', 'string', CreoleTypes::VARCHAR, false, 255);
     $tMap->addColumn('OFFICE_ADDRESS', 'OfficeAddress', 'string', CreoleTypes::VARCHAR, false, 255);
     $tMap->addColumn('OFFICE_PHONE', 'OfficePhone', 'string', CreoleTypes::VARCHAR, false, 128);
     $tMap->addColumn('ADDRESS', 'Address', 'string', CreoleTypes::VARCHAR, false, 255);
     $tMap->addColumn('HOME_NO', 'HomeNo', 'string', CreoleTypes::VARCHAR, false, 12);
     $tMap->addColumn('HOME_RT', 'HomeRt', 'string', CreoleTypes::VARCHAR, false, 12);
     $tMap->addColumn('HOME_RW', 'HomeRw', 'string', CreoleTypes::VARCHAR, false, 12);
     $tMap->addColumn('CREATED', 'Created', 'int', CreoleTypes::TIMESTAMP, false, null);
 }

 /**
  * The doBuild() method builds the DatabaseMap
  *
  * @return     void
  * @throws     PropelException
  */
 public function doBuild()
 {
     $this->dbMap = Propel::getDatabaseMap(ItineraryBackupPeer::DATABASE_NAME);
     $tMap = $this->dbMap->addTable(ItineraryBackupPeer::TABLE_NAME);
     $tMap->setPhpName('ItineraryBackup');
     $tMap->setClassname('ItineraryBackup');
     $tMap->setUseIdGenerator(true);
     $tMap->addPrimaryKey('ID', 'Id', 'INTEGER', true, 11);
     $tMap->addColumn('DATE_REQUESTED', 'DateRequested', 'TIMESTAMP', true, null);
     $tMap->addColumn('MISSION_REQUEST_ID', 'MissionRequestId', 'INTEGER', false, 11);
     $tMap->addColumn('MISSION_TYPE_ID', 'MissionTypeId', 'INTEGER', false, 11);
     $tMap->addColumn('APOINT_TIME', 'ApointTime', 'VARCHAR', true, 50);
     $tMap->addColumn('PASSENGER_ID', 'PassengerId', 'INTEGER', true, 11);
     $tMap->addColumn('REQUESTER_ID', 'RequesterId', 'INTEGER', false, 11);
     $tMap->addColumn('FACILITY', 'Facility', 'VARCHAR', false, 50);
     $tMap->addColumn('LODGING', 'Lodging', 'VARCHAR', false, 50);
     $tMap->addColumn('ORGIN_CITY', 'OrginCity', 'VARCHAR', false, 50);
     $tMap->addColumn('ORGIN_STATE', 'OrginState', 'VARCHAR', false, 2);
     $tMap->addColumn('DEST_CITY', 'DestCity', 'VARCHAR', false, 50);
     $tMap->addColumn('DEST_STATE', 'DestState', 'VARCHAR', false, 2);
     $tMap->addColumn('WAIVER_NEED', 'WaiverNeed', 'TINYINT', false, 4);
     $tMap->addColumn('NEED_MEDICAL_RELEASE', 'NeedMedicalRelease', 'TINYINT', false, 4);
     $tMap->addColumn('COMMENT', 'Comment', 'VARCHAR', false, 255);
     $tMap->addColumn('AGENCY_ID', 'AgencyId', 'INTEGER', true, 11);
     $tMap->addColumn('CAMP_ID', 'CampId', 'INTEGER', false, 11);
     $tMap->addColumn('LEG_ID', 'LegId', 'INTEGER', false, 11);
     $tMap->addColumn('POINT_TIME', 'PointTime', 'TIME', false, null);
 }

 /**
  * The doBuild() method builds the DatabaseMap
  *
  * @return     void
  * @throws     PropelException
  */
 public function doBuild()
 {
     $this->dbMap = Propel::getDatabaseMap(AfaOrgPeer::DATABASE_NAME);
     $tMap = $this->dbMap->addTable(AfaOrgPeer::TABLE_NAME);
     $tMap->setPhpName('AfaOrg');
     $tMap->setClassname('AfaOrg');
     $tMap->setUseIdGenerator(true);
     $tMap->addPrimaryKey('ID', 'Id', 'INTEGER', true, 11);
     $tMap->addColumn('NAME', 'Name', 'VARCHAR', true, 60);
     $tMap->addColumn('ORG_PHONE', 'OrgPhone', 'VARCHAR', false, 16);
     $tMap->addColumn('HOME_PAGE_URL', 'HomePageUrl', 'VARCHAR', false, 80);
     $tMap->addColumn('ORG_FAX', 'OrgFax', 'VARCHAR', false, 16);
     $tMap->addColumn('REF_CONTACT_NAME', 'RefContactName', 'VARCHAR', false, 25);
     $tMap->addColumn('REF_CONTACT_EMAIL', 'RefContactEmail', 'VARCHAR', false, 80);
     $tMap->addColumn('VPO_SOAP_SERVER_URL', 'VpoSoapServerUrl', 'VARCHAR', false, 125);
     $tMap->addColumn('VPO_REQUEST_POST_EMAIL', 'VpoRequestPostEmail', 'VARCHAR', false, 125);
     $tMap->addColumn('VPO_USER_ID', 'VpoUserId', 'VARCHAR', false, 25);
     $tMap->addColumn('VPO_USER_PASSWORD', 'VpoUserPassword', 'VARCHAR', false, 25);
     $tMap->addColumn('VPO_ORG_ID', 'VpoOrgId', 'VARCHAR', false, 5);
     $tMap->addColumn('AFIDS_REQUESTER_USER_NAME', 'AfidsRequesterUserName', 'VARCHAR', false, 25);
     $tMap->addColumn('AFIDS_REQUESTER_PASSWORD', 'AfidsRequesterPassword', 'VARCHAR', false, 25);
     $tMap->addColumn('AFIDS_SOAP_SERVER_URL', 'AfidsSoapServerUrl', 'VARCHAR', false, 125);
     $tMap->addColumn('AFIDS_REQUEST_POST_EMAIL', 'AfidsRequestPostEmail', 'VARCHAR', false, 125);
     $tMap->addColumn('PHONE_NUMBER1', 'PhoneNumber1', 'VARCHAR', false, 16);
     $tMap->addColumn('PHONE_NUMBER2', 'PhoneNumber2', 'VARCHAR', false, 16);
 }

 /**
  * The doBuild() method builds the DatabaseMap
  *
  * @return     void
  * @throws     PropelException
  */
 public function doBuild()
 {
     $this->dbMap = Propel::getDatabaseMap(ActivitatsPeer::DATABASE_NAME);
     $tMap = $this->dbMap->addTable(ActivitatsPeer::TABLE_NAME);
     $tMap->setPhpName('Activitats');
     $tMap->setClassname('Activitats');
     $tMap->setUseIdGenerator(true);
     $tMap->addPrimaryKey('ACTIVITATID', 'Activitatid', 'INTEGER', true, 11);
     $tMap->addForeignKey('CICLES_CICLEID', 'CiclesCicleid', 'INTEGER', 'cicles', 'CICLEID', false, 11);
     $tMap->addForeignKey('TIPUSACTIVITAT_IDTIPUSACTIVITAT', 'TipusactivitatIdtipusactivitat', 'INTEGER', 'tipusactivitat', 'IDTIPUSACTIVITAT', false, 11);
     $tMap->addColumn('NOM', 'Nom', 'LONGVARCHAR', false, null);
     $tMap->addColumn('PREU', 'Preu', 'DOUBLE', false, null);
     $tMap->addColumn('PREUREDUIT', 'Preureduit', 'DOUBLE', false, null);
     $tMap->addColumn('PUBLICABLE', 'Publicable', 'TINYINT', false, 4);
     $tMap->addColumn('ESTAT', 'Estat', 'CHAR', false, 1);
     $tMap->addColumn('DESCRIPCIO', 'Descripcio', 'LONGVARCHAR', true, null);
     $tMap->addColumn('IMATGE', 'Imatge', 'LONGVARCHAR', true, null);
     $tMap->addColumn('PDF', 'Pdf', 'LONGVARCHAR', true, null);
     $tMap->addColumn('PUBLICAWEB', 'Publicaweb', 'TINYINT', true, 1);
     $tMap->addColumn('TCURT', 'Tcurt', 'LONGVARCHAR', true, null);
     $tMap->addColumn('DCURT', 'Dcurt', 'LONGVARCHAR', true, null);
     $tMap->addColumn('TMIG', 'Tmig', 'LONGVARCHAR', true, null);
     $tMap->addColumn('DMIG', 'Dmig', 'LONGVARCHAR', true, null);
     $tMap->addColumn('TCOMPLET', 'Tcomplet', 'LONGVARCHAR', true, null);
     $tMap->addColumn('DCOMPLET', 'Dcomplet', 'LONGVARCHAR', true, null);
     $tMap->addColumn('TIPUSENVIAMENT', 'Tipusenviament', 'TINYINT', true, 4);
     $tMap->addColumn('ORGANITZADOR', 'Organitzador', 'VARCHAR', true, 250);
     $tMap->addColumn('CATEGORIES', 'Categories', 'VARCHAR', true, 100);
 }

 /**
  * The doBuild() method builds the DatabaseMap
  *
  * @return     void
  * @throws     PropelException
  */
 public function doBuild()
 {
     $this->dbMap = Propel::getDatabaseMap(ParametroPeer::DATABASE_NAME);
     $tMap = $this->dbMap->addTable(ParametroPeer::TABLE_NAME);
     $tMap->setPhpName('Parametro');
     $tMap->setClassname('Parametro');
     $tMap->setUseIdGenerator(true);
     $tMap->addPrimaryKey('ID_PARAMETRO', 'IdParametro', 'INTEGER', true, null);
     $tMap->addForeignKey('TIPOPARAMETRO', 'Tipoparametro', 'VARCHAR', 'parametro_def', 'TIPOPARAMETRO', true, 100);
     $tMap->addColumn('NOMBRE', 'Nombre', 'VARCHAR', false, 100);
     $tMap->addColumn('ORDEN', 'Orden', 'INTEGER', false, null);
     $tMap->addColumn('NUMERO', 'Numero', 'FLOAT', false, null);
     $tMap->addColumn('NUMERO2', 'Numero2', 'FLOAT', false, null);
     $tMap->addColumn('CADENA', 'Cadena', 'LONGVARCHAR', false, null);
     $tMap->addColumn('CADENA1', 'Cadena1', 'LONGVARCHAR', false, null);
     $tMap->addColumn('OTROOBJETO', 'Otroobjeto', 'INTEGER', false, null);
     $tMap->addColumn('SI_NO', 'SiNo', 'BOOLEAN', false, null);
     $tMap->addColumn('FECHA', 'Fecha', 'TIMESTAMP', false, null);
     $tMap->addColumn('CREATED_AT', 'CreatedAt', 'TIMESTAMP', false, null);
     $tMap->addColumn('UPDATED_AT', 'UpdatedAt', 'TIMESTAMP', false, null);
     $tMap->addColumn('FECHABORRADO', 'Fechaborrado', 'TIMESTAMP', false, null);
     $tMap->addColumn('NOMBREFICHERO', 'Nombrefichero', 'VARCHAR', false, 200);
     $tMap->addColumn('TIPO', 'Tipo', 'VARCHAR', false, 100);
     $tMap->addColumn('FICHERO', 'Fichero', 'LONGVARCHAR', false, null);
     $tMap->addColumn('TAMANO', 'Tamano', 'INTEGER', false, null);
 }

 public function doBuild()
 {
     $this->dbMap = Propel::getDatabaseMap('propel');
     $tMap = $this->dbMap->addTable('student');
     $tMap->setPhpName('Student');
     $tMap->setUseIdGenerator(true);
     $tMap->addPrimaryKey('ID', 'Id', 'int', CreoleTypes::INTEGER, true, null);
     $tMap->addColumn('CODE', 'Code', 'string', CreoleTypes::VARCHAR, false, 64);
     $tMap->addColumn('CODE2', 'Code2', 'string', CreoleTypes::VARCHAR, false, 64);
     $tMap->addColumn('CODE3', 'Code3', 'string', CreoleTypes::VARCHAR, false, 64);
     $tMap->addColumn('NAME', 'Name', 'string', CreoleTypes::VARCHAR, false, 255);
     $tMap->addForeignKey('CURRICULUM_ID', 'CurriculumId', 'int', CreoleTypes::INTEGER, 'curriculum', 'ID', false, null);
     $tMap->addForeignKey('ACADEMIC_CALENDAR_ID', 'AcademicCalendarId', 'int', CreoleTypes::INTEGER, 'academic_calendar', 'ID', false, null);
     $tMap->addForeignKey('CLASS_GROUP_ID', 'ClassGroupId', 'int', CreoleTypes::INTEGER, 'class_group', 'ID', false, null);
     $tMap->addForeignKey('TEST_APPLICANT_ID', 'TestApplicantId', 'int', CreoleTypes::INTEGER, 'test_applicant', 'ID', false, null);
     $tMap->addForeignKey('STUDENT_DETAIL_ID', 'StudentDetailId', 'int', CreoleTypes::INTEGER, 'student_detail', 'ID', false, null);
     $tMap->addForeignKey('MEMBER_ID', 'MemberId', 'int', CreoleTypes::INTEGER, 'member', 'ID', false, null);
     $tMap->addColumn('STATUS', 'Status', 'string', CreoleTypes::CHAR, false, null);
     $tMap->addColumn('GRADUATION_DATE', 'GraduationDate', 'int', CreoleTypes::DATE, false, null);
     $tMap->addColumn('PASSWORD', 'Password', 'string', CreoleTypes::VARCHAR, true, 40);
     $tMap->addColumn('CLASS_NAME', 'ClassName', 'string', CreoleTypes::VARCHAR, false, 2);
     $tMap->addColumn('YEAR', 'Year', 'string', CreoleTypes::VARCHAR, false, 4);
     $tMap->addColumn('DATE_IN', 'DateIn', 'int', CreoleTypes::DATE, false, null);
     $tMap->addColumn('NIK', 'Nik', 'string', CreoleTypes::VARCHAR, false, 64);
 }

 public function doBuild()
 {
     $this->dbMap = Propel::getDatabaseMap('propel');
     $tMap = $this->dbMap->addTable('v_spp');
     $tMap->setPhpName('VSpp');
     $tMap->setUseIdGenerator(true);
     $tMap->addPrimaryKey('ID', 'Id', 'int', CreoleTypes::INTEGER, true, null);
     $tMap->addForeignKey('STUDENT_ID', 'StudentId', 'int', CreoleTypes::INTEGER, 'student', 'ID', false, null);
     $tMap->addForeignKey('ACADEMIC_COST_ID', 'AcademicCostId', 'int', CreoleTypes::INTEGER, 'academic_cost', 'ID', false, null);
     $tMap->addForeignKey('USER_ID', 'UserId', 'int', CreoleTypes::INTEGER, 'user', 'ID', false, null);
     $tMap->addColumn('AMOUNT', 'Amount', 'double', CreoleTypes::FLOAT, false, null);
     $tMap->addColumn('CREATED_AT', 'CreatedAt', 'int', CreoleTypes::TIMESTAMP, false, null);
     $tMap->addForeignKey('ACADEMIC_PROCESS_ID', 'AcademicProcessId', 'int', CreoleTypes::INTEGER, 'academic_process', 'ID', false, null);
     $tMap->addColumn('UPDATED_AT', 'UpdatedAt', 'int', CreoleTypes::TIMESTAMP, false, null);
     $tMap->addColumn('PAYER_TYPE', 'PayerType', 'string', CreoleTypes::CHAR, false, 1);
     $tMap->addColumn('RECEIVABLE', 'Receivable', 'double', CreoleTypes::FLOAT, false, null);
     $tMap->addColumn('PAID', 'Paid', 'double', CreoleTypes::FLOAT, false, null);
     $tMap->addColumn('STATUS', 'Status', 'string', CreoleTypes::CHAR, false, 1);
     $tMap->addColumn('COMMENTS', 'Comments', 'string', CreoleTypes::VARCHAR, false, 255);
     $tMap->addForeignKey('PAYMENT_MODEL_ID', 'PaymentModelId', 'int', CreoleTypes::INTEGER, 'payment_model', 'ID', false, null);
     $tMap->addForeignKey('TRANSACTION_STATUS_ID', 'TransactionStatusId', 'int', CreoleTypes::INTEGER, 'transaction_status', 'ID', false, null);
     $tMap->addColumn('PAID_AT', 'PaidAt', 'int', CreoleTypes::DATE, false, null);
     $tMap->addColumn('YEAR', 'Year', 'double', CreoleTypes::NUMERIC, false, 4);
     $tMap->addColumn('MONTH', 'Month', 'string', CreoleTypes::CHAR, false, 1);
     $tMap->addForeignKey('ACADEMIC_COST_COMPONENT_ID', 'AcademicCostComponentId', 'int', CreoleTypes::INTEGER, 'academic_cost_component', 'ID', false, null);
     $tMap->addForeignKey('ACADEMIC_CALENDAR_ID', 'AcademicCalendarId', 'int', CreoleTypes::INTEGER, 'academic_calendar', 'ID', false, null);
 }

 /**
  * The doBuild() method builds the DatabaseMap
  *
  * @return     void
  * @throws     PropelException
  */
 public function doBuild()
 {
     $this->dbMap = Propel::getDatabaseMap('workflow');
     $tMap = $this->dbMap->addTable('REPORT_TABLE');
     $tMap->setPhpName('ReportTable');
     $tMap->setUseIdGenerator(false);
     $tMap->addPrimaryKey('REP_TAB_UID', 'RepTabUid', 'string', CreoleTypes::VARCHAR, true, 32);
     $tMap->addColumn('PRO_UID', 'ProUid', 'string', CreoleTypes::VARCHAR, true, 32);
     $tMap->addColumn('REP_TAB_NAME', 'RepTabName', 'string', CreoleTypes::VARCHAR, true, 100);
     $tMap->addColumn('REP_TAB_TYPE', 'RepTabType', 'string', CreoleTypes::VARCHAR, true, 6);
     $tMap->addColumn('REP_TAB_GRID', 'RepTabGrid', 'string', CreoleTypes::VARCHAR, false, 150);
     $tMap->addColumn('REP_TAB_CONNECTION', 'RepTabConnection', 'string', CreoleTypes::VARCHAR, true, 32);
     $tMap->addColumn('REP_TAB_CREATE_DATE', 'RepTabCreateDate', 'int', CreoleTypes::TIMESTAMP, true, null);
     $tMap->addColumn('REP_TAB_STATUS', 'RepTabStatus', 'string', CreoleTypes::CHAR, true, 8);
     $tMap->addValidator('REP_TAB_UID', 'maxLength', 'propel.validator.MaxLengthValidator', '32', 'Report table UID can be no larger than 32 in size');
     $tMap->addValidator('REP_TAB_UID', 'required', 'propel.validator.RequiredValidator', '', 'Report table UID is required.');
     $tMap->addValidator('PRO_UID', 'maxLength', 'propel.validator.MaxLengthValidator', '32', 'Process UID can be no larger than 32 in size');
     $tMap->addValidator('PRO_UID', 'required', 'propel.validator.RequiredValidator', '', 'Process UID is required.');
     $tMap->addValidator('REP_TAB_NAME', 'maxLength', 'propel.validator.MaxLengthValidator', '100', 'Report table name can be no larger than 100 in size');
     $tMap->addValidator('REP_TAB_NAME', 'required', 'propel.validator.RequiredValidator', '', 'Report table name is required.');
     $tMap->addValidator('REP_TAB_TYPE', 'validValues', 'propel.validator.ValidValuesValidator', 'NORMAL|GRID', 'Please select a valid type.');
     $tMap->addValidator('REP_TAB_TYPE', 'required', 'propel.validator.RequiredValidator', '', 'Report table type is required.');
     $tMap->addValidator('REP_TAB_CONNECTION', 'maxLength', 'propel.validator.MaxLengthValidator', '10', 'Report table connection can be no larger than 10 in size');
     $tMap->addValidator('REP_TAB_CONNECTION', 'required', 'propel.validator.RequiredValidator', '', 'Report table connection is required.');
     $tMap->addValidator('REP_TAB_STATUS', 'validValues', 'propel.validator.ValidValuesValidator', 'ACTIVE|INACTIVE', 'Please select a valid status.');
     $tMap->addValidator('REP_TAB_STATUS', 'required', 'propel.validator.RequiredValidator', '', 'Report table status is required.');
 }

 /**
  * The doBuild() method builds the DatabaseMap
  *
  * @return     void
  * @throws     PropelException
  */
 public function doBuild()
 {
     $this->dbMap = Propel::getDatabaseMap('workflow');
     $tMap = $this->dbMap->addTable('LIST_INBOX');
     $tMap->setPhpName('ListInbox');
     $tMap->setUseIdGenerator(false);
     $tMap->addPrimaryKey('APP_UID', 'AppUid', 'string', CreoleTypes::VARCHAR, true, 32);
     $tMap->addPrimaryKey('DEL_INDEX', 'DelIndex', 'int', CreoleTypes::INTEGER, true, null);
     $tMap->addColumn('USR_UID', 'UsrUid', 'string', CreoleTypes::VARCHAR, true, 32);
     $tMap->addColumn('TAS_UID', 'TasUid', 'string', CreoleTypes::VARCHAR, true, 32);
     $tMap->addColumn('PRO_UID', 'ProUid', 'string', CreoleTypes::VARCHAR, true, 32);
     $tMap->addColumn('APP_NUMBER', 'AppNumber', 'int', CreoleTypes::INTEGER, true, null);
     $tMap->addColumn('APP_STATUS', 'AppStatus', 'string', CreoleTypes::VARCHAR, false, 32);
     $tMap->addColumn('APP_TITLE', 'AppTitle', 'string', CreoleTypes::VARCHAR, false, 255);
     $tMap->addColumn('APP_PRO_TITLE', 'AppProTitle', 'string', CreoleTypes::VARCHAR, false, 255);
     $tMap->addColumn('APP_TAS_TITLE', 'AppTasTitle', 'string', CreoleTypes::VARCHAR, false, 255);
     $tMap->addColumn('APP_UPDATE_DATE', 'AppUpdateDate', 'int', CreoleTypes::TIMESTAMP, false, null);
     $tMap->addColumn('DEL_PREVIOUS_USR_UID', 'DelPreviousUsrUid', 'string', CreoleTypes::VARCHAR, false, 32);
     $tMap->addColumn('DEL_PREVIOUS_USR_USERNAME', 'DelPreviousUsrUsername', 'string', CreoleTypes::VARCHAR, false, 100);
     $tMap->addColumn('DEL_PREVIOUS_USR_FIRSTNAME', 'DelPreviousUsrFirstname', 'string', CreoleTypes::VARCHAR, false, 50);
     $tMap->addColumn('DEL_PREVIOUS_USR_LASTNAME', 'DelPreviousUsrLastname', 'string', CreoleTypes::VARCHAR, false, 50);
     $tMap->addColumn('DEL_DELEGATE_DATE', 'DelDelegateDate', 'int', CreoleTypes::TIMESTAMP, true, null);
     $tMap->addColumn('DEL_INIT_DATE', 'DelInitDate', 'int', CreoleTypes::TIMESTAMP, false, null);
     $tMap->addColumn('DEL_DUE_DATE', 'DelDueDate', 'int', CreoleTypes::TIMESTAMP, false, null);
     $tMap->addColumn('DEL_RISK_DATE', 'DelRiskDate', 'int', CreoleTypes::TIMESTAMP, false, null);
     $tMap->addColumn('DEL_PRIORITY', 'DelPriority', 'string', CreoleTypes::VARCHAR, true, 32);
 }

 /**
  * The doBuild() method builds the DatabaseMap
  *
  * @return     void
  * @throws     PropelException
  */
 public function doBuild()
 {
     $this->dbMap = Propel::getDatabaseMap(NagiosDependencyPeer::DATABASE_NAME);
     $tMap = $this->dbMap->addTable(NagiosDependencyPeer::TABLE_NAME);
     $tMap->setPhpName('NagiosDependency');
     $tMap->setClassname('NagiosDependency');
     $tMap->setUseIdGenerator(true);
     $tMap->addPrimaryKey('ID', 'Id', 'INTEGER', true, null);
     $tMap->addForeignKey('HOST_TEMPLATE', 'HostTemplate', 'INTEGER', 'nagios_host_template', 'ID', false, null);
     $tMap->addForeignKey('HOST', 'Host', 'INTEGER', 'nagios_host', 'ID', false, null);
     $tMap->addForeignKey('SERVICE_TEMPLATE', 'ServiceTemplate', 'INTEGER', 'nagios_service_template', 'ID', false, null);
     $tMap->addForeignKey('SERVICE', 'Service', 'INTEGER', 'nagios_service', 'ID', false, null);
     $tMap->addForeignKey('HOSTGROUP', 'Hostgroup', 'INTEGER', 'nagios_hostgroup', 'ID', false, null);
     $tMap->addColumn('NAME', 'Name', 'VARCHAR', false, 255);
     $tMap->addColumn('EXECUTION_FAILURE_CRITERIA_UP', 'ExecutionFailureCriteriaUp', 'BOOLEAN', false, null);
     $tMap->addColumn('EXECUTION_FAILURE_CRITERIA_DOWN', 'ExecutionFailureCriteriaDown', 'BOOLEAN', false, null);
     $tMap->addColumn('EXECUTION_FAILURE_CRITERIA_UNREACHABLE', 'ExecutionFailureCriteriaUnreachable', 'BOOLEAN', false, null);
     $tMap->addColumn('EXECUTION_FAILURE_CRITERIA_PENDING', 'ExecutionFailureCriteriaPending', 'BOOLEAN', false, null);
     $tMap->addColumn('EXECUTION_FAILURE_CRITERIA_OK', 'ExecutionFailureCriteriaOk', 'BOOLEAN', false, null);
     $tMap->addColumn('EXECUTION_FAILURE_CRITERIA_WARNING', 'ExecutionFailureCriteriaWarning', 'BOOLEAN', false, null);
     $tMap->addColumn('EXECUTION_FAILURE_CRITERIA_UNKNOWN', 'ExecutionFailureCriteriaUnknown', 'BOOLEAN', false, null);
     $tMap->addColumn('EXECUTION_FAILURE_CRITERIA_CRITICAL', 'ExecutionFailureCriteriaCritical', 'BOOLEAN', false, null);
     $tMap->addColumn('NOTIFICATION_FAILURE_CRITERIA_OK', 'NotificationFailureCriteriaOk', 'BOOLEAN', false, null);
     $tMap->addColumn('NOTIFICATION_FAILURE_CRITERIA_WARNING', 'NotificationFailureCriteriaWarning', 'BOOLEAN', false, null);
     $tMap->addColumn('NOTIFICATION_FAILURE_CRITERIA_UNKNOWN', 'NotificationFailureCriteriaUnknown', 'BOOLEAN', false, null);
     $tMap->addColumn('NOTIFICATION_FAILURE_CRITERIA_CRITICAL', 'NotificationFailureCriteriaCritical', 'BOOLEAN', false, null);
     $tMap->addColumn('NOTIFICATION_FAILURE_CRITERIA_PENDING', 'NotificationFailureCriteriaPending', 'BOOLEAN', false, null);
     $tMap->addColumn('NOTIFICATION_FAILURE_CRITERIA_UP', 'NotificationFailureCriteriaUp', 'BOOLEAN', false, null);
     $tMap->addColumn('NOTIFICATION_FAILURE_CRITERIA_DOWN', 'NotificationFailureCriteriaDown', 'BOOLEAN', false, null);
     $tMap->addColumn('NOTIFICATION_FAILURE_CRITERIA_UNREACHABLE', 'NotificationFailureCriteriaUnreachable', 'BOOLEAN', false, null);
     $tMap->addColumn('INHERITS_PARENT', 'InheritsParent', 'BOOLEAN', false, null);
     $tMap->addForeignKey('DEPENDENCY_PERIOD', 'DependencyPeriod', 'INTEGER', 'nagios_timeperiod', 'ID', false, null);
 }

 /**
  * The doBuild() method builds the DatabaseMap
  *
  * @return     void
  * @throws     PropelException
  */
 public function doBuild()
 {
     $this->dbMap = Propel::getDatabaseMap(RpMemberApplicationReconciliationPeer::DATABASE_NAME);
     $tMap = $this->dbMap->addTable(RpMemberApplicationReconciliationPeer::TABLE_NAME);
     $tMap->setPhpName('RpMemberApplicationReconciliation');
     $tMap->setClassname('RpMemberApplicationReconciliation');
     $tMap->setUseIdGenerator(true);
     $tMap->addColumn('FIRST_NAME', 'FirstName', 'VARCHAR', true, 40);
     $tMap->addColumn('LAST_NAME', 'LastName', 'VARCHAR', true, 40);
     $tMap->addColumn('EXTERNAL_ID', 'ExternalId', 'INTEGER', false, 4);
     $tMap->addColumn('RENEWAL', 'Renewal', 'TINYINT', false, 1);
     $tMap->addColumn('DUES_AMOUNT_PAID', 'DuesAmountPaid', 'FLOAT', true, null);
     $tMap->addColumn('METHOD_OF_PAYMENT', 'MethodOfPayment', 'VARCHAR', false, 20);
     $tMap->addColumn('CHECK_NUMBER', 'CheckNumber', 'INTEGER', false, 4);
     $tMap->addColumn('DONATION_AMOUNT_PAID', 'DonationAmountPaid', 'FLOAT', false, null);
     $tMap->addColumn('APPLICATION_DATE', 'ApplicationDate', 'TIMESTAMP', true, null);
     $tMap->addColumn('APPLICATIONDATEDISPLAY', 'Applicationdatedisplay', 'VARCHAR', false, 10);
     $tMap->addColumn('PROCESSEDDATE', 'Processeddate', 'VARCHAR', false, 10);
     $tMap->addColumn('CCARD_APPROVAL_NUMBER', 'CcardApprovalNumber', 'VARCHAR', false, 20);
     $tMap->addColumn('PAYMENT_TRANSACTION_ID', 'PaymentTransactionId', 'INTEGER', false, 4);
     $tMap->addColumn('MEMBER_CLASS_ID', 'MemberClassId', 'INTEGER', true, 4);
     $tMap->addColumn('MEMBERCLASS', 'Memberclass', 'VARCHAR', true, 20);
     $tMap->addColumn('MASTER_MEMBER_ID', 'MasterMemberId', 'INTEGER', false, 4);
     $tMap->addColumn('MASTERMEMBEREXTERNALID', 'Mastermemberexternalid', 'INTEGER', false, 4);
     $tMap->addColumn('MASTERMEMBERFIRSTNAME', 'Mastermemberfirstname', 'VARCHAR', false, 40);
     $tMap->addColumn('MASTERMEMBERLASTNAME', 'Mastermemberlastname', 'VARCHAR', false, 40);
     $tMap->addColumn('RENEWAL_DATE', 'RenewalDate', 'DATE', false, null);
     $tMap->addPrimaryKey('ID', 'Id', 'INTEGER', true, null);
 }

 /**
  * The doBuild() method builds the DatabaseMap
  *
  * @return     void
  * @throws     PropelException
  */
 public function doBuild()
 {
     $this->dbMap = Propel::getDatabaseMap(PoliticoPeer::DATABASE_NAME);
     $tMap = $this->dbMap->addTable(PoliticoPeer::TABLE_NAME);
     $tMap->setPhpName('Politico');
     $tMap->setClassname('Politico');
     $tMap->setUseIdGenerator(true);
     $tMap->addPrimaryKey('ID', 'Id', 'INTEGER', true, 11);
     $tMap->addColumn('URL_KEY', 'UrlKey', 'VARCHAR', true, 45);
     $tMap->addColumn('ALIAS', 'Alias', 'VARCHAR', false, 45);
     $tMap->addColumn('NOMBRE', 'Nombre', 'VARCHAR', true, 45);
     $tMap->addColumn('APELLIDOS', 'Apellidos', 'VARCHAR', true, 150);
     $tMap->addColumn('EMAIL', 'Email', 'VARCHAR', false, 45);
     $tMap->addColumn('SEXO', 'Sexo', 'CHAR', false, 1);
     $tMap->addColumn('FECHA_NACIMIENTO', 'FechaNacimiento', 'DATE', false, null);
     $tMap->addColumn('PAIS', 'Pais', 'VARCHAR', false, 45);
     $tMap->addColumn('RESIDENCIA', 'Residencia', 'VARCHAR', false, 45);
     $tMap->addForeignKey('SF_GUARD_USER_PROFILE_ID', 'SfGuardUserProfileId', 'INTEGER', 'sf_guard_user_profile', 'ID', false, 11);
     $tMap->addColumn('CREATED_AT', 'CreatedAt', 'TIMESTAMP', false, null);
     $tMap->addForeignKey('PARTIDO_ID', 'PartidoId', 'INTEGER', 'partido', 'ID', false, 11);
     $tMap->addColumn('PARTIDO_TXT', 'PartidoTxt', 'VARCHAR', false, 150);
     $tMap->addColumn('IMAGEN', 'Imagen', 'VARCHAR', false, 50);
     $tMap->addColumn('VANITY', 'Vanity', 'VARCHAR', false, 45);
     $tMap->addColumn('LUGAR_NACIMIENTO', 'LugarNacimiento', 'VARCHAR', false, 150);
     $tMap->addColumn('SUMU', 'Sumu', 'INTEGER', true, 11);
     $tMap->addColumn('SUMD', 'Sumd', 'INTEGER', true, 11);
     $tMap->addColumn('RELACION', 'Relacion', 'CHAR', false, 2);
     $tMap->addColumn('HIJOS', 'Hijos', 'INTEGER', false, 11);
     $tMap->addColumn('HIJAS', 'Hijas', 'INTEGER', false, 11);
 }

 /**
  * The doBuild() method builds the DatabaseMap
  *
  * @return     void
  * @throws     PropelException
  */
 public function doBuild()
 {
     $this->dbMap = Propel::getDatabaseMap('workflow');
     $tMap = $this->dbMap->addTable('BPMN_EVENT');
     $tMap->setPhpName('BpmnEvent');
     $tMap->setUseIdGenerator(false);
     $tMap->addPrimaryKey('EVN_UID', 'EvnUid', 'string', CreoleTypes::VARCHAR, true, 32);
     $tMap->addForeignKey('PRJ_UID', 'PrjUid', 'string', CreoleTypes::VARCHAR, 'BPMN_PROJECT', 'PRJ_UID', true, 32);
     $tMap->addForeignKey('PRO_UID', 'ProUid', 'string', CreoleTypes::VARCHAR, 'BPMN_PROCESS', 'PRO_UID', false, 32);
     $tMap->addColumn('EVN_NAME', 'EvnName', 'string', CreoleTypes::VARCHAR, false, 255);
     $tMap->addColumn('EVN_TYPE', 'EvnType', 'string', CreoleTypes::VARCHAR, true, 30);
     $tMap->addColumn('EVN_MARKER', 'EvnMarker', 'string', CreoleTypes::VARCHAR, true, 30);
     $tMap->addColumn('EVN_IS_INTERRUPTING', 'EvnIsInterrupting', 'int', CreoleTypes::TINYINT, false, null);
     $tMap->addColumn('EVN_ATTACHED_TO', 'EvnAttachedTo', 'string', CreoleTypes::VARCHAR, false, 32);
     $tMap->addColumn('EVN_CANCEL_ACTIVITY', 'EvnCancelActivity', 'int', CreoleTypes::TINYINT, false, null);
     $tMap->addColumn('EVN_ACTIVITY_REF', 'EvnActivityRef', 'string', CreoleTypes::VARCHAR, false, 32);
     $tMap->addColumn('EVN_WAIT_FOR_COMPLETION', 'EvnWaitForCompletion', 'int', CreoleTypes::TINYINT, false, null);
     $tMap->addColumn('EVN_ERROR_NAME', 'EvnErrorName', 'string', CreoleTypes::VARCHAR, false, 255);
     $tMap->addColumn('EVN_ERROR_CODE', 'EvnErrorCode', 'string', CreoleTypes::VARCHAR, false, 255);
     $tMap->addColumn('EVN_ESCALATION_NAME', 'EvnEscalationName', 'string', CreoleTypes::VARCHAR, false, 255);
     $tMap->addColumn('EVN_ESCALATION_CODE', 'EvnEscalationCode', 'string', CreoleTypes::VARCHAR, false, 255);
     $tMap->addColumn('EVN_CONDITION', 'EvnCondition', 'string', CreoleTypes::VARCHAR, false, 255);
     $tMap->addColumn('EVN_MESSAGE', 'EvnMessage', 'string', CreoleTypes::LONGVARCHAR, false, null);
     $tMap->addColumn('EVN_OPERATION_NAME', 'EvnOperationName', 'string', CreoleTypes::VARCHAR, false, 255);
     $tMap->addColumn('EVN_OPERATION_IMPLEMENTATION_REF', 'EvnOperationImplementationRef', 'string', CreoleTypes::VARCHAR, false, 255);
     $tMap->addColumn('EVN_TIME_DATE', 'EvnTimeDate', 'string', CreoleTypes::VARCHAR, false, 255);
     $tMap->addColumn('EVN_TIME_CYCLE', 'EvnTimeCycle', 'string', CreoleTypes::VARCHAR, false, 255);
     $tMap->addColumn('EVN_TIME_DURATION', 'EvnTimeDuration', 'string', CreoleTypes::VARCHAR, false, 255);
     $tMap->addColumn('EVN_BEHAVIOR', 'EvnBehavior', 'string', CreoleTypes::VARCHAR, true, 20);
 }

 /**
  * The doBuild() method builds the DatabaseMap
  *
  * @return     void
  * @throws     PropelException
  */
 public function doBuild()
 {
     $this->dbMap = Propel::getDatabaseMap('workflow');
     $tMap = $this->dbMap->addTable('USERS');
     $tMap->setPhpName('Users');
     $tMap->setUseIdGenerator(false);
     $tMap->addPrimaryKey('USR_UID', 'UsrUid', 'string', CreoleTypes::VARCHAR, true, 32);
     $tMap->addColumn('USR_USERNAME', 'UsrUsername', 'string', CreoleTypes::VARCHAR, true, 100);
     $tMap->addColumn('USR_PASSWORD', 'UsrPassword', 'string', CreoleTypes::VARCHAR, true, 32);
     $tMap->addColumn('USR_FIRSTNAME', 'UsrFirstname', 'string', CreoleTypes::VARCHAR, true, 50);
     $tMap->addColumn('USR_LASTNAME', 'UsrLastname', 'string', CreoleTypes::VARCHAR, true, 50);
     $tMap->addColumn('USR_EMAIL', 'UsrEmail', 'string', CreoleTypes::VARCHAR, true, 100);
     $tMap->addColumn('USR_DUE_DATE', 'UsrDueDate', 'int', CreoleTypes::DATE, true, null);
     $tMap->addColumn('USR_CREATE_DATE', 'UsrCreateDate', 'int', CreoleTypes::TIMESTAMP, true, null);
     $tMap->addColumn('USR_UPDATE_DATE', 'UsrUpdateDate', 'int', CreoleTypes::TIMESTAMP, true, null);
     $tMap->addColumn('USR_STATUS', 'UsrStatus', 'string', CreoleTypes::VARCHAR, true, 32);
     $tMap->addColumn('USR_COUNTRY', 'UsrCountry', 'string', CreoleTypes::VARCHAR, true, 3);
     $tMap->addColumn('USR_CITY', 'UsrCity', 'string', CreoleTypes::VARCHAR, true, 3);
     $tMap->addColumn('USR_LOCATION', 'UsrLocation', 'string', CreoleTypes::VARCHAR, true, 3);
     $tMap->addColumn('USR_ADDRESS', 'UsrAddress', 'string', CreoleTypes::VARCHAR, true, 255);
     $tMap->addColumn('USR_PHONE', 'UsrPhone', 'string', CreoleTypes::VARCHAR, true, 24);
     $tMap->addColumn('USR_FAX', 'UsrFax', 'string', CreoleTypes::VARCHAR, true, 24);
     $tMap->addColumn('USR_CELLULAR', 'UsrCellular', 'string', CreoleTypes::VARCHAR, true, 24);
     $tMap->addColumn('USR_ZIP_CODE', 'UsrZipCode', 'string', CreoleTypes::VARCHAR, true, 16);
     $tMap->addColumn('DEP_UID', 'DepUid', 'string', CreoleTypes::VARCHAR, true, 32);
     $tMap->addColumn('USR_POSITION', 'UsrPosition', 'string', CreoleTypes::VARCHAR, true, 100);
     $tMap->addColumn('USR_RESUME', 'UsrResume', 'string', CreoleTypes::VARCHAR, true, 100);
     $tMap->addColumn('USR_BIRTHDAY', 'UsrBirthday', 'int', CreoleTypes::DATE, false, null);
     $tMap->addColumn('USR_ROLE', 'UsrRole', 'string', CreoleTypes::VARCHAR, false, 32);
     $tMap->addColumn('USR_REPORTS_TO', 'UsrReportsTo', 'string', CreoleTypes::VARCHAR, false, 32);
     $tMap->addColumn('USR_REPLACED_BY', 'UsrReplacedBy', 'string', CreoleTypes::VARCHAR, false, 32);
     $tMap->addColumn('USR_UX', 'UsrUx', 'string', CreoleTypes::VARCHAR, false, 128);
     $tMap->addValidator('USR_STATUS', 'validValues', 'propel.validator.ValidValuesValidator', 'ACTIVE|INACTIVE|VACATION|CLOSED', 'Please select a valid type.');
     $tMap->addValidator('USR_STATUS', 'required', 'propel.validator.RequiredValidator', '', 'Type is required.');
 }

 public function doBuild()
 {
     $this->dbMap = Propel::getDatabaseMap('propel');
     $tMap = $this->dbMap->addTable('v_applicant_test');
     $tMap->setPhpName('VApplicantTest');
     $tMap->setUseIdGenerator(true);
     $tMap->addPrimaryKey('ID', 'Id', 'int', CreoleTypes::INTEGER, true, null);
     $tMap->addForeignKey('TEST_APPLICANT_DETAIL_ID', 'TestApplicantDetailId', 'int', CreoleTypes::INTEGER, 'test_applicant_detail', 'ID', false, null);
     $tMap->addColumn('CODE', 'Code', 'string', CreoleTypes::VARCHAR, false, 64);
     $tMap->addColumn('CODE2', 'Code2', 'string', CreoleTypes::VARCHAR, false, 64);
     $tMap->addColumn('NAME', 'Name', 'string', CreoleTypes::VARCHAR, false, 255);
     $tMap->addForeignKey('DEPARTMENT_ID', 'DepartmentId', 'int', CreoleTypes::INTEGER, 'department', 'ID', false, null);
     $tMap->addForeignKey('CLASS_GROUP_ID', 'ClassGroupId', 'int', CreoleTypes::INTEGER, 'class_group', 'ID', false, null);
     $tMap->addForeignKey('REG_TEST_PERIOD_ID', 'RegTestPeriodId', 'int', CreoleTypes::INTEGER, 'reg_test_period', 'ID', false, null);
     $tMap->addForeignKey('LOCATION_ID', 'LocationId', 'int', CreoleTypes::INTEGER, 'location', 'ID', false, null);
     $tMap->addForeignKey('CLASS_ID', 'ClassId', 'int', CreoleTypes::INTEGER, 'class_group', 'ID', false, null);
     $tMap->addColumn('ISPASS1', 'Ispass1', 'int', CreoleTypes::INTEGER, false, 1);
     $tMap->addColumn('RANK1', 'Rank1', 'int', CreoleTypes::INTEGER, false, null);
     $tMap->addColumn('APPLICANT_TYPE', 'ApplicantType', 'string', CreoleTypes::CHAR, false, 1);
     $tMap->addColumn('ENROLLED', 'Enrolled', 'boolean', CreoleTypes::BOOLEAN, false, null);
     $tMap->addColumn('REG_INFO', 'RegInfo', 'int', CreoleTypes::INTEGER, false, null);
     $tMap->addColumn('STATUS', 'Status', 'int', CreoleTypes::INTEGER, false, null);
     $tMap->addColumn('IS_ALAZHAR', 'IsAlazhar', 'int', CreoleTypes::INTEGER, false, null);
     $tMap->addColumn('HEREG_STATUS', 'HeregStatus', 'int', CreoleTypes::INTEGER, false, null);
     $tMap->addColumn('YEAR', 'Year', 'string', CreoleTypes::VARCHAR, false, 4);
     $tMap->addColumn('PASSWORD', 'Password', 'string', CreoleTypes::VARCHAR, true, 40);
 }