CcSubjsTableMap.php 3.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374
  1. <?php
  2. /**
  3. * This class defines the structure of the 'cc_subjs' table.
  4. *
  5. *
  6. *
  7. * This map class is used by Propel to do runtime db structure discovery.
  8. * For example, the createSelectSql() method checks the type of a given column used in an
  9. * ORDER BY clause to know whether it needs to apply SQL to make the ORDER BY case-insensitive
  10. * (i.e. if it's a text column type).
  11. *
  12. * @package propel.generator.airtime.map
  13. */
  14. class CcSubjsTableMap extends TableMap {
  15. /**
  16. * The (dot-path) name of this class
  17. */
  18. const CLASS_NAME = 'airtime.map.CcSubjsTableMap';
  19. /**
  20. * Initialize the table attributes, columns and validators
  21. * Relations are not initialized by this method since they are lazy loaded
  22. *
  23. * @return void
  24. * @throws PropelException
  25. */
  26. public function initialize()
  27. {
  28. // attributes
  29. $this->setName('cc_subjs');
  30. $this->setPhpName('CcSubjs');
  31. $this->setClassname('CcSubjs');
  32. $this->setPackage('airtime');
  33. $this->setUseIdGenerator(true);
  34. $this->setPrimaryKeyMethodInfo('cc_subjs_id_seq');
  35. // columns
  36. $this->addPrimaryKey('ID', 'DbId', 'INTEGER', true, null, null);
  37. $this->addColumn('LOGIN', 'DbLogin', 'VARCHAR', true, 255, '');
  38. $this->addColumn('PASS', 'DbPass', 'VARCHAR', true, 255, '');
  39. $this->addColumn('TYPE', 'DbType', 'CHAR', true, 1, 'U');
  40. $this->addColumn('FIRST_NAME', 'DbFirstName', 'VARCHAR', true, 255, '');
  41. $this->addColumn('LAST_NAME', 'DbLastName', 'VARCHAR', true, 255, '');
  42. $this->addColumn('LASTLOGIN', 'DbLastlogin', 'TIMESTAMP', false, null, null);
  43. $this->addColumn('LASTFAIL', 'DbLastfail', 'TIMESTAMP', false, null, null);
  44. $this->addColumn('SKYPE_CONTACT', 'DbSkypeContact', 'VARCHAR', false, 255, null);
  45. $this->addColumn('JABBER_CONTACT', 'DbJabberContact', 'VARCHAR', false, 255, null);
  46. $this->addColumn('EMAIL', 'DbEmail', 'VARCHAR', false, 255, null);
  47. $this->addColumn('CELL_PHONE', 'DbCellPhone', 'VARCHAR', false, 255, null);
  48. $this->addColumn('LOGIN_ATTEMPTS', 'DbLoginAttempts', 'INTEGER', false, null, 0);
  49. // validators
  50. } // initialize()
  51. /**
  52. * Build the RelationMap objects for this table relationships
  53. */
  54. public function buildRelations()
  55. {
  56. $this->addRelation('CcFilesRelatedByDbOwnerId', 'CcFiles', RelationMap::ONE_TO_MANY, array('id' => 'owner_id', ), null, null);
  57. $this->addRelation('CcFilesRelatedByDbEditedby', 'CcFiles', RelationMap::ONE_TO_MANY, array('id' => 'editedby', ), null, null);
  58. $this->addRelation('CcPerms', 'CcPerms', RelationMap::ONE_TO_MANY, array('id' => 'subj', ), 'CASCADE', null);
  59. $this->addRelation('CcShowHosts', 'CcShowHosts', RelationMap::ONE_TO_MANY, array('id' => 'subjs_id', ), 'CASCADE', null);
  60. $this->addRelation('CcPlaylist', 'CcPlaylist', RelationMap::ONE_TO_MANY, array('id' => 'creator_id', ), 'CASCADE', null);
  61. $this->addRelation('CcBlock', 'CcBlock', RelationMap::ONE_TO_MANY, array('id' => 'creator_id', ), 'CASCADE', null);
  62. $this->addRelation('CcPref', 'CcPref', RelationMap::ONE_TO_MANY, array('id' => 'subjid', ), 'CASCADE', null);
  63. $this->addRelation('CcSess', 'CcSess', RelationMap::ONE_TO_MANY, array('id' => 'userid', ), 'CASCADE', null);
  64. $this->addRelation('CcSubjsToken', 'CcSubjsToken', RelationMap::ONE_TO_MANY, array('id' => 'user_id', ), 'CASCADE', null);
  65. } // buildRelations()
  66. } // CcSubjsTableMap