<?php

/**
 * BaseProfile
 * 
 * This class has been auto-generated by the Doctrine ORM Framework
 * 
 * @property integer $user_id
 * @property integer $type_id
 * @property string $name
 * @property string $first_name
 * @property string $last_name
 * @property string $prefix
 * @property string $sufix
 * @property string $tel
 * @property string $mail
 * @property string $web
 * @property integer $country_id
 * @property integer $region_id
 * @property string $city
 * @property string $street
 * @property integer $zip
 * @property string $ic
 * @property string $bank_account
 * @property clob $text
 * @property boolean $is_public
 * @property integer $prepayment_type_id
 * @property date $prepayment_from
 * @property date $prepayment_to
 * @property boolean $prepayment_active
 * @property string $filename
 * @property integer $representant_id
 * @property boolean $is_pdf_subscriber
 * @property boolean $is_eventer
 * @property sfGuardUser $User
 * @property ProfileType $ProfileType
 * @property PrepaymentType $PrepaymentType
 * @property Region $Region
 * @property Country $Country
 * @property Representant $Representant
 * @property Doctrine_Collection $PrepaymentCounts
 * @property Doctrine_Collection $Jobs
 * @property Doctrine_Collection $Banners
 * @property Doctrine_Collection $Invoices
 * @property Doctrine_Collection $InvoiceItems
 * @property Doctrine_Collection $Subscribers
 * 
 * @method integer             getUserId()             Returns the current record's "user_id" value
 * @method integer             getTypeId()             Returns the current record's "type_id" value
 * @method string              getName()               Returns the current record's "name" value
 * @method string              getFirstName()          Returns the current record's "first_name" value
 * @method string              getLastName()           Returns the current record's "last_name" value
 * @method string              getPrefix()             Returns the current record's "prefix" value
 * @method string              getSufix()              Returns the current record's "sufix" value
 * @method string              getTel()                Returns the current record's "tel" value
 * @method string              getMail()               Returns the current record's "mail" value
 * @method string              getWeb()                Returns the current record's "web" value
 * @method integer             getCountryId()          Returns the current record's "country_id" value
 * @method integer             getRegionId()           Returns the current record's "region_id" value
 * @method string              getCity()               Returns the current record's "city" value
 * @method string              getStreet()             Returns the current record's "street" value
 * @method integer             getZip()                Returns the current record's "zip" value
 * @method string              getIc()                 Returns the current record's "ic" value
 * @method string              getBankAccount()        Returns the current record's "bank_account" value
 * @method clob                getText()               Returns the current record's "text" value
 * @method boolean             getIsPublic()           Returns the current record's "is_public" value
 * @method integer             getPrepaymentTypeId()   Returns the current record's "prepayment_type_id" value
 * @method date                getPrepaymentFrom()     Returns the current record's "prepayment_from" value
 * @method date                getPrepaymentTo()       Returns the current record's "prepayment_to" value
 * @method boolean             getPrepaymentActive()   Returns the current record's "prepayment_active" value
 * @method string              getFilename()           Returns the current record's "filename" value
 * @method integer             getRepresentantId()     Returns the current record's "representant_id" value
 * @method boolean             getIsPdfSubscriber()    Returns the current record's "is_pdf_subscriber" value
 * @method boolean             getIsEventer()          Returns the current record's "is_eventer" value
 * @method sfGuardUser         getUser()               Returns the current record's "User" value
 * @method ProfileType         getProfileType()        Returns the current record's "ProfileType" value
 * @method PrepaymentType      getPrepaymentType()     Returns the current record's "PrepaymentType" value
 * @method Region              getRegion()             Returns the current record's "Region" value
 * @method Country             getCountry()            Returns the current record's "Country" value
 * @method Representant        getRepresentant()       Returns the current record's "Representant" value
 * @method Doctrine_Collection getPrepaymentCounts()   Returns the current record's "PrepaymentCounts" collection
 * @method Doctrine_Collection getJobs()               Returns the current record's "Jobs" collection
 * @method Doctrine_Collection getBanners()            Returns the current record's "Banners" collection
 * @method Doctrine_Collection getInvoices()           Returns the current record's "Invoices" collection
 * @method Doctrine_Collection getInvoiceItems()       Returns the current record's "InvoiceItems" collection
 * @method Doctrine_Collection getSubscribers()        Returns the current record's "Subscribers" collection
 * @method Profile             setUserId()             Sets the current record's "user_id" value
 * @method Profile             setTypeId()             Sets the current record's "type_id" value
 * @method Profile             setName()               Sets the current record's "name" value
 * @method Profile             setFirstName()          Sets the current record's "first_name" value
 * @method Profile             setLastName()           Sets the current record's "last_name" value
 * @method Profile             setPrefix()             Sets the current record's "prefix" value
 * @method Profile             setSufix()              Sets the current record's "sufix" value
 * @method Profile             setTel()                Sets the current record's "tel" value
 * @method Profile             setMail()               Sets the current record's "mail" value
 * @method Profile             setWeb()                Sets the current record's "web" value
 * @method Profile             setCountryId()          Sets the current record's "country_id" value
 * @method Profile             setRegionId()           Sets the current record's "region_id" value
 * @method Profile             setCity()               Sets the current record's "city" value
 * @method Profile             setStreet()             Sets the current record's "street" value
 * @method Profile             setZip()                Sets the current record's "zip" value
 * @method Profile             setIc()                 Sets the current record's "ic" value
 * @method Profile             setBankAccount()        Sets the current record's "bank_account" value
 * @method Profile             setText()               Sets the current record's "text" value
 * @method Profile             setIsPublic()           Sets the current record's "is_public" value
 * @method Profile             setPrepaymentTypeId()   Sets the current record's "prepayment_type_id" value
 * @method Profile             setPrepaymentFrom()     Sets the current record's "prepayment_from" value
 * @method Profile             setPrepaymentTo()       Sets the current record's "prepayment_to" value
 * @method Profile             setPrepaymentActive()   Sets the current record's "prepayment_active" value
 * @method Profile             setFilename()           Sets the current record's "filename" value
 * @method Profile             setRepresentantId()     Sets the current record's "representant_id" value
 * @method Profile             setIsPdfSubscriber()    Sets the current record's "is_pdf_subscriber" value
 * @method Profile             setIsEventer()          Sets the current record's "is_eventer" value
 * @method Profile             setUser()               Sets the current record's "User" value
 * @method Profile             setProfileType()        Sets the current record's "ProfileType" value
 * @method Profile             setPrepaymentType()     Sets the current record's "PrepaymentType" value
 * @method Profile             setRegion()             Sets the current record's "Region" value
 * @method Profile             setCountry()            Sets the current record's "Country" value
 * @method Profile             setRepresentant()       Sets the current record's "Representant" value
 * @method Profile             setPrepaymentCounts()   Sets the current record's "PrepaymentCounts" collection
 * @method Profile             setJobs()               Sets the current record's "Jobs" collection
 * @method Profile             setBanners()            Sets the current record's "Banners" collection
 * @method Profile             setInvoices()           Sets the current record's "Invoices" collection
 * @method Profile             setInvoiceItems()       Sets the current record's "InvoiceItems" collection
 * @method Profile             setSubscribers()        Sets the current record's "Subscribers" collection
 * 
 * @package    Pharmalink - Inzerce
 * @subpackage model
 * @author     Tomas Naibrt <tomas@naibrt.cz>
 * @version    SVN: $Id: Builder.php 7490 2010-03-29 19:53:27Z jwage $
 */
abstract class BaseProfile extends sfDoctrineRecord
{
    public function setTableDefinition()
    {
        $this->setTableName('profile');
        $this->hasColumn('user_id', 'integer', null, array(
             'type' => 'integer',
             'notnull' => true,
             ));
        $this->hasColumn('type_id', 'integer', null, array(
             'type' => 'integer',
             'notnull' => true,
             ));
        $this->hasColumn('name', 'string', 255, array(
             'type' => 'string',
             'length' => 255,
             ));
        $this->hasColumn('first_name', 'string', 255, array(
             'type' => 'string',
             'length' => 255,
             ));
        $this->hasColumn('last_name', 'string', 255, array(
             'type' => 'string',
             'length' => 255,
             ));
        $this->hasColumn('prefix', 'string', 255, array(
             'type' => 'string',
             'length' => 255,
             ));
        $this->hasColumn('sufix', 'string', 255, array(
             'type' => 'string',
             'length' => 255,
             ));
        $this->hasColumn('tel', 'string', 255, array(
             'type' => 'string',
             'length' => 255,
             ));
        $this->hasColumn('mail', 'string', 255, array(
             'type' => 'string',
             'notnull' => true,
             'unique' => true,
             'length' => 255,
             ));
        $this->hasColumn('web', 'string', 255, array(
             'type' => 'string',
             'length' => 255,
             ));
        $this->hasColumn('country_id', 'integer', null, array(
             'type' => 'integer',
             'notnull' => true,
             ));
        $this->hasColumn('region_id', 'integer', null, array(
             'type' => 'integer',
             'notnull' => false,
             ));
        $this->hasColumn('city', 'string', 255, array(
             'type' => 'string',
             'length' => 255,
             ));
        $this->hasColumn('street', 'string', 255, array(
             'type' => 'string',
             'length' => 255,
             ));
        $this->hasColumn('zip', 'integer', null, array(
             'type' => 'integer',
             ));
        $this->hasColumn('ic', 'string', 255, array(
             'type' => 'string',
             'length' => 255,
             ));
        $this->hasColumn('bank_account', 'string', 255, array(
             'type' => 'string',
             'length' => 255,
             ));
        $this->hasColumn('text', 'clob', null, array(
             'type' => 'clob',
             ));
        $this->hasColumn('is_public', 'boolean', null, array(
             'type' => 'boolean',
             'notnull' => true,
             'default' => true,
             ));
        $this->hasColumn('prepayment_type_id', 'integer', null, array(
             'type' => 'integer',
             'notnull' => true,
             'default' => 1,
             ));
        $this->hasColumn('prepayment_from', 'date', null, array(
             'type' => 'date',
             ));
        $this->hasColumn('prepayment_to', 'date', null, array(
             'type' => 'date',
             ));
        $this->hasColumn('prepayment_active', 'boolean', null, array(
             'type' => 'boolean',
             'notnull' => false,
             'default' => false,
             ));
        $this->hasColumn('filename', 'string', 255, array(
             'type' => 'string',
             'length' => 255,
             ));
        $this->hasColumn('representant_id', 'integer', null, array(
             'type' => 'integer',
             ));
        $this->hasColumn('is_pdf_subscriber', 'boolean', null, array(
             'type' => 'boolean',
             'notnull' => true,
             'default' => false,
             ));
        $this->hasColumn('is_eventer', 'boolean', null, array(
             'type' => 'boolean',
             'notnull' => true,
             'default' => false,
             ));

        $this->option('collate', 'utf8_czech_ci');
        $this->option('charset', 'utf8');
    }

    public function setUp()
    {
        parent::setUp();
        $this->hasOne('sfGuardUser as User', array(
             'local' => 'user_id',
             'foreign' => 'id',
             'onDelete' => 'CASCADE'));

        $this->hasOne('ProfileType', array(
             'local' => 'type_id',
             'foreign' => 'id',
             'onDelete' => 'CASCADE'));

        $this->hasOne('PrepaymentType', array(
             'local' => 'prepayment_type_id',
             'foreign' => 'id',
             'onDelete' => 'CASCADE'));

        $this->hasOne('Region', array(
             'local' => 'region_id',
             'foreign' => 'id',
             'onDelete' => 'CASCADE'));

        $this->hasOne('Country', array(
             'local' => 'country_id',
             'foreign' => 'id',
             'onDelete' => 'CASCADE'));

        $this->hasOne('Representant', array(
             'local' => 'representant_id',
             'foreign' => 'id',
             'onDelete' => 'SET NULL'));

        $this->hasMany('PrepaymentCount as PrepaymentCounts', array(
             'local' => 'id',
             'foreign' => 'profile_id'));

        $this->hasMany('Job as Jobs', array(
             'local' => 'id',
             'foreign' => 'profile_id'));

        $this->hasMany('Banner as Banners', array(
             'local' => 'id',
             'foreign' => 'profile_id'));

        $this->hasMany('Invoice as Invoices', array(
             'local' => 'id',
             'foreign' => 'profile_id'));

        $this->hasMany('InvoiceItem as InvoiceItems', array(
             'local' => 'id',
             'foreign' => 'profile_id'));

        $this->hasMany('Subscriber as Subscribers', array(
             'local' => 'id',
             'foreign' => 'profile_id'));

        $timestampable0 = new Doctrine_Template_Timestampable();
        $sluggable0 = new Doctrine_Template_Sluggable(array(
             'fields' => 
             array(
              0 => 'name',
             ),
             'unique' => true,
             'builder' => 
             array(
              0 => 'saInflector',
              1 => 'urlize',
             ),
             ));
        $this->actAs($timestampable0);
        $this->actAs($sluggable0);
    }
}