* @version SVN: $Id: Builder.php 7490 2010-03-29 19:53:27Z jwage $ */ abstract class BaseJobSpecialization extends sfDoctrineRecord { public function setTableDefinition() { $this->setTableName('job_specialization'); $this->hasColumn('category_id', 'integer', null, array( 'type' => 'integer', 'notnull' => true, )); $this->hasColumn('name', 'string', 255, array( 'type' => 'string', 'notnull' => true, 'length' => 255, )); $this->hasColumn('priority', 'integer', null, array( 'type' => 'integer', 'notnull' => true, 'default' => 100, )); $this->option('collate', 'utf8_czech_ci'); $this->option('charset', 'utf8'); } public function setUp() { parent::setUp(); $this->hasOne('JobCategory', array( 'local' => 'category_id', 'foreign' => 'id', 'onDelete' => 'CASCADE')); $this->hasMany('Job as Jobs', array( 'refClass' => 'JobSpecializationRelation', 'local' => 'specialization_id', 'foreign' => 'job_id')); $this->hasMany('JobSpecializationRelation as JobSpecializationRelations', array( 'local' => 'id', 'foreign' => 'specialization_id')); } }