PHP AIR2_Record::setTableDefinition方法代码示例

 /**
  * Set the table columns
  */
 public function setTableDefinition()
 {
     $this->setTableName('image');
     // identifiers and foreign keys
     $this->hasColumn('img_id', 'integer', 4, array('primary' => true, 'autoincrement' => true));
     $this->hasColumn('img_uuid', 'string', 12, array('fixed' => true, 'notnull' => true, 'unique' => true));
     $this->hasColumn('img_xid', 'integer', 4, array('notnull' => true));
     $this->hasColumn('img_ref_type', 'string', 1, array('notnull' => true));
     // file metadata
     $this->hasColumn('img_file_name', 'string', 128, array());
     $this->hasColumn('img_file_size', 'integer', 4, array());
     $this->hasColumn('img_content_type', 'string', 64, array());
     $this->hasColumn('img_dtim', 'timestamp', null, array());
     // stamps
     $this->hasColumn('img_cre_user', 'integer', 4, array('notnull' => true));
     $this->hasColumn('img_upd_user', 'integer', 4, array());
     $this->hasColumn('img_cre_dtim', 'timestamp', null, array('notnull' => true));
     $this->hasColumn('img_upd_dtim', 'timestamp', null, array());
     parent::setTableDefinition();
     // subclasses (must also be in models directory)
     $subclasses = array();
     foreach (self::$CONFIG as $ref_type => $def) {
         $subclasses[$def['class']] = array('img_ref_type' => $ref_type);
     }
     $this->setSubclasses($subclasses);
 }

 /**
  * Set the table columns
  */
 public function setTableDefinition()
 {
     $this->setTableName('password_reset');
     $this->hasColumn('pwr_uuid', 'string', 32, array('fixed' => true, 'primary' => true));
     $this->hasColumn('pwr_expiration_dtim', 'timestamp', null, array('notnull' => true));
     $this->hasColumn('pwr_user_id', 'integer', 4, array('notnull' => true));
     parent::setTableDefinition();
 }

 /**
  * Set the table columns
  */
 public function setTableDefinition()
 {
     $this->setTableName('state');
     $this->hasColumn('state_id', 'integer', 4, array('primary' => true, 'autoincrement' => true));
     $this->hasColumn('state_name', 'string', 128, array('notnull' => true));
     $this->hasColumn('state_code', 'string', 2, array('fixed' => true, 'notnull' => true));
     parent::setTableDefinition();
 }

 /**
  * Set the table columns
  */
 public function setTableDefinition()
 {
     $this->setTableName('src_org_cache');
     $this->hasColumn('soc_src_id', 'integer', 4, array('primary' => true));
     $this->hasColumn('soc_org_id', 'integer', 4, array('primary' => true));
     $this->hasColumn('soc_status', 'string', 1, array('fixed' => true, 'notnull' => true));
     parent::setTableDefinition();
 }

 /**
  * Set the table columns
  */
 public function setTableDefinition()
 {
     $this->setTableName('stale_record');
     $this->hasColumn('str_xid', 'integer', 4, array('primary' => true));
     $this->hasColumn('str_type', 'string', 1, array('primary' => true));
     $this->hasColumn('str_upd_dtim', 'timestamp', null, array('notnull' => true));
     parent::setTableDefinition();
 }

 /**
  * Set the table columns
  */
 public function setTableDefinition()
 {
     $this->setTableName('locale');
     $this->hasColumn('loc_id', 'integer', 4, array('primary' => true, 'autoincrement' => true));
     $this->hasColumn('loc_key', 'string', 5, array('fixed' => true, 'notnull' => true));
     $this->hasColumn('loc_lang', 'string', 255, array());
     $this->hasColumn('loc_region', 'string', 255, array());
     parent::setTableDefinition();
 }

 /**
  * Set the table columns
  */
 public function setTableDefinition()
 {
     $this->setTableName('api_stat');
     $this->hasColumn('as_id', 'integer', 4, array('primary' => true, 'autoincrement' => true));
     $this->hasColumn('as_ak_id', 'integer', 4, array('notnull' => true));
     $this->hasColumn('as_ip_addr', 'string', 16, array('notnull' => true));
     $this->hasColumn('as_cre_dtim', 'timestamp', null, array('notnull' => true));
     parent::setTableDefinition();
 }

 /**
  * Set the table columns
  */
 public function setTableDefinition()
 {
     $this->setTableName('tank_org');
     $this->hasColumn('to_id', 'integer', 4, array('primary' => true, 'autoincrement' => true));
     $this->hasColumn('to_tank_id', 'integer', 4, array('notnull' => true));
     $this->hasColumn('to_org_id', 'integer', 4, array('notnull' => true));
     $this->hasColumn('to_so_status', 'string', 1, array('notnull' => true, 'fixed' => true, 'default' => SrcOrg::$STATUS_OPTED_IN));
     $this->hasColumn('to_so_home_flag', 'boolean', null, array('notnull' => true, 'default' => false));
     parent::setTableDefinition();
 }

 /**
  * Setup the table columns
  */
 public function setTableDefinition()
 {
     $this->setTableName('test_related');
     $this->hasColumn('tr_id', 'integer', 4, array('primary' => true, 'autoincrement' => true));
     $this->hasColumn('tr_test_id', 'integer', 4, array('notnull' => true));
     $this->hasColumn('tr_uuid', 'string', 12, array('fixed' => true, 'notnull' => true, 'unique' => true));
     $this->hasColumn('tr_string_1', 'string', 128, array());
     $this->hasColumn('tr_string_2', 'string', 128, array());
     parent::setTableDefinition();
 }

 /**
  * Set the table columns
  */
 public function setTableDefinition()
 {
     $this->setTableName('trackback');
     $this->hasColumn('tb_id', 'integer', 4, array('primary' => true, 'autoincrement' => true));
     $this->hasColumn('tb_src_id', 'integer', 4, array('notnull' => true));
     $this->hasColumn('tb_user_id', 'integer', 4, array('notnull' => true));
     $this->hasColumn('tb_ip', 'integer', 4, array('notnull' => true, 'unsigned' => true));
     $this->hasColumn('tb_dtim', 'timestamp', null, array('notnull' => true));
     parent::setTableDefinition();
 }

 /**
  * Set the table columns
  */
 public function setTableDefinition()
 {
     $this->setTableName('bin_source');
     $this->hasColumn('bsrc_src_id', 'integer', 4, array('primary' => true));
     $this->hasColumn('bsrc_bin_id', 'integer', 4, array('primary' => true));
     $this->hasColumn('bsrc_notes', 'string', 255, array());
     $this->hasColumn('bsrc_meta', 'string', 255, array());
     $this->hasColumn('bsrc_cre_dtim', 'timestamp', null, array());
     parent::setTableDefinition();
 }

 /**
  * Set the table columns
  */
 public function setTableDefinition()
 {
     $this->setTableName('translation_map');
     $this->hasColumn('xm_id', 'integer', 4, array('primary' => true, 'autoincrement' => true));
     $this->hasColumn('xm_fact_id', 'integer', 4, array('notnull' => true));
     $this->hasColumn('xm_xlate_from', 'string', 128, array('notnull' => true));
     $this->hasColumn('xm_xlate_to_fv_id', 'integer', 4, array('notnull' => true));
     $this->hasColumn('xm_cre_dtim', 'timestamp', null, array('notnull' => false));
     parent::setTableDefinition();
 }

 /**
  * Set the table columns
  */
 public function setTableDefinition()
 {
     $this->setTableName('src_stat');
     $this->hasColumn('sstat_src_id', 'integer', 4, array('primary' => true, 'autoincrement' => false));
     $this->hasColumn('sstat_export_dtim', 'timestamp', null, array('notnull' => false));
     $this->hasColumn('sstat_contact_dtim', 'timestamp', null, array('notnull' => false));
     $this->hasColumn('sstat_submit_dtim', 'timestamp', null, array('notnull' => false));
     $this->hasColumn('sstat_bh_play_dtim', 'timestamp', null, array('notnull' => false));
     $this->hasColumn('sstat_bh_signup_dtim', 'timestamp', null, array('notnull' => false));
     parent::setTableDefinition();
 }

 /**
  * Set the table columns
  */
 public function setTableDefinition()
 {
     $this->setTableName('user_srs');
     $this->hasColumn('usrs_user_id', 'integer', 4, array('primary' => true));
     $this->hasColumn('usrs_srs_id', 'integer', 4, array('primary' => true));
     $this->hasColumn('usrs_read_flag', 'boolean', null, array('notnull' => true, 'default' => false));
     $this->hasColumn('usrs_favorite_flag', 'boolean', null, array('notnull' => true, 'default' => false));
     $this->hasColumn('usrs_cre_dtim', 'timestamp', null, array('notnull' => true));
     $this->hasColumn('usrs_upd_dtim', 'timestamp', null, array());
     parent::setTableDefinition();
 }

 /**
  * Set the table columns
  */
 public function setTableDefinition()
 {
     $this->setTableName('user_email_address');
     $this->hasColumn('uem_id', 'integer', 4, array('primary' => true, 'autoincrement' => true));
     $this->hasColumn('uem_uuid', 'string', 12, array('fixed' => true, 'notnull' => true, 'unique' => true));
     $this->hasColumn('uem_user_id', 'integer', 4, array('notnull' => true));
     $this->hasColumn('uem_address', 'string', 255, array('notnull' => true));
     $this->hasColumn('uem_primary_flag', 'boolean', null, array('notnull' => true));
     $this->hasColumn('uem_signature', 'string', null, array());
     parent::setTableDefinition();
 }