/** * 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(); }
/** * Set the table columns */ public function setTableDefinition() { $this->setTableName('bin_src_response_set'); $this->hasColumn('bsrs_bin_id', 'integer', 4, array('primary' => true)); $this->hasColumn('bsrs_srs_id', 'integer', 4, array('primary' => true)); // cached srs columns to speed things up $this->hasColumn('bsrs_inq_id', 'integer', 4, array('notnull' => true)); $this->hasColumn('bsrs_src_id', 'integer', 4, array('notnull' => true)); $this->hasColumn('bsrs_cre_dtim', 'timestamp', null, array()); parent::setTableDefinition(); }
/** * Set the table columns */ public function setTableDefinition() { $this->setTableName('project_saved_search'); $this->hasColumn('pss_prj_id', 'integer', 4, array('primary' => true)); $this->hasColumn('pss_ssearch_id', 'integer', 4, array('primary' => true)); $this->hasColumn('pss_cre_user', 'integer', 4, array('notnull' => true)); $this->hasColumn('pss_upd_user', 'integer', 4, array()); $this->hasColumn('pss_cre_dtim', 'timestamp', null, array('notnull' => true)); $this->hasColumn('pss_upd_dtim', 'timestamp', null, array()); parent::setTableDefinition(); }
/** * Set the table columns */ public function setTableDefinition() { $this->setTableName('project_inquiry'); $this->hasColumn('pinq_prj_id', 'integer', 4, array('primary' => true)); $this->hasColumn('pinq_inq_id', 'integer', 4, array('primary' => true)); $this->hasColumn('pinq_status', 'string', 1, array('fixed' => true, 'notnull' => true, 'default' => self::$STATUS_ACTIVE)); $this->hasColumn('pinq_cre_user', 'integer', 4, array('notnull' => true)); $this->hasColumn('pinq_upd_user', 'integer', 4, array()); $this->hasColumn('pinq_cre_dtim', 'timestamp', null, array('notnull' => true)); $this->hasColumn('pinq_upd_dtim', 'timestamp', null, array()); parent::setTableDefinition(); }
/** * Set the table columns */ public function setTableDefinition() { $this->setTableName('system_message'); $this->hasColumn('smsg_id', 'integer', 4, array('primary' => true)); $this->hasColumn('smsg_value', 'string', 255, array()); $this->hasColumn('smsg_status', 'string', 1, array('fixed' => true, 'default' => self::$STATUS_ACTIVE)); $this->hasColumn('smsg_cre_user', 'integer', 4, array('notnull' => true)); $this->hasColumn('smsg_upd_user', 'integer', 4, array()); $this->hasColumn('smsg_cre_dtim', 'timestamp', null, array('notnull' => true)); $this->hasColumn('smsg_upd_dtim', 'timestamp', null, array()); parent::setTableDefinition(); }
/** * Set the table columns */ public function setTableDefinition() { $this->setTableName('tank_log'); $this->hasColumn('tlog_id', 'integer', 4, array('primary' => true, 'autoincrement' => true)); $this->hasColumn('tlog_tank_id', 'integer', 4, array('notnull' => true)); $this->hasColumn('tlog_user_id', 'integer', 4, array('notnull' => true)); $this->hasColumn('tlog_dtim', 'timestamp', null, array('notnull' => true)); $this->hasColumn('tlog_text', 'string', null, array()); $this->hasColumn('tlog_type', 'string', 1, array('fixed' => true, 'notnull' => true)); $this->hasColumn('tlog_status', 'string', 1, array('fixed' => true, 'notnull' => true)); parent::setTableDefinition(); }
/** * Set the table columns */ public function setTableDefinition() { $this->setTableName('src_org_email'); $this->hasColumn('soe_id', 'integer', 4, array('primary' => true, 'autoincrement' => true)); $this->hasColumn('soe_sem_id', 'integer', 4, array('notnull' => true)); $this->hasColumn('soe_org_id', 'integer', 4, array('notnull' => true)); $this->hasColumn('soe_status', 'string', 1, array('notnull' => true, 'fixed' => true)); $this->hasColumn('soe_status_dtim', 'timestamp', null, array('notnull' => true)); $this->hasColumn('soe_type', 'string', 1, array('fixed' => true, 'notnull' => true, 'default' => self::$TYPE_LYRIS)); parent::setTableDefinition(); $this->index('soe_uniqueidx_1', array('fields' => array('soe_sem_id', 'soe_org_id', 'soe_type'), 'type' => 'unique')); }
/** * Set the table columns */ public function setTableDefinition() { $this->setTableName('user_phone_number'); $this->hasColumn('uph_id', 'integer', 4, array('primary' => true, 'autoincrement' => true)); $this->hasColumn('uph_uuid', 'string', 12, array('fixed' => true, 'notnull' => true, 'unique' => true)); $this->hasColumn('uph_user_id', 'integer', 4, array('notnull' => true)); $this->hasColumn('uph_country', 'string', 3, array('fixed' => true, 'notnull' => true)); $this->hasColumn('uph_number', 'string', 12, array('notnull' => true)); $this->hasColumn('uph_ext', 'string', 12, array()); $this->hasColumn('uph_primary_flag', 'boolean', null, array('notnull' => true)); parent::setTableDefinition(); }
/** * Set the table columns */ public function setTableDefinition() { $this->setTableName('out_annotation'); $this->hasColumn('oa_id', 'integer', 4, array('primary' => true, 'autoincrement' => true)); $this->hasColumn('oa_out_id', 'integer', 4, array('notnull' => true, 'default' => 1)); $this->hasColumn('oa_value', 'string', 255, array('notnull' => true)); $this->hasColumn('oa_cre_user', 'integer', 4, array('notnull' => true)); $this->hasColumn('oa_upd_user', 'integer', 4, array()); $this->hasColumn('oa_cre_dtim', 'timestamp', null, array('notnull' => true)); $this->hasColumn('oa_upd_dtim', 'timestamp', null, array()); parent::setTableDefinition(); }
/** * Set the table columns */ public function setTableDefinition() { $this->setTableName('geo_lookup'); $this->hasColumn('zip_code', 'string', 16, array('primary' => true)); $this->hasColumn('state', 'string', 128, array('notnull' => true)); $this->hasColumn('city', 'string', 255, array('notnull' => true)); $this->hasColumn('county', 'string', 128, array()); $this->hasColumn('latitude', 'float', null, array()); $this->hasColumn('longitude', 'float', null, array()); $this->hasColumn('population', 'integer', 4, array()); parent::setTableDefinition(); }
/** * Set the table columns */ public function setTableDefinition() { $this->setTableName('inquiry_annotation'); $this->hasColumn('inqan_id', 'integer', 4, array('primary' => true, 'autoincrement' => true)); $this->hasColumn('inqan_inq_id', 'integer', 4, array('notnull' => true)); $this->hasColumn('inqan_value', 'string', null, array()); $this->hasColumn('inqan_cre_user', 'integer', 4, array('notnull' => true)); $this->hasColumn('inqan_upd_user', 'integer', 4, array()); $this->hasColumn('inqan_cre_dtim', 'timestamp', null, array('notnull' => true)); $this->hasColumn('inqan_upd_dtim', 'timestamp', null, array()); parent::setTableDefinition(); }
/** * Set the table columns */ public function setTableDefinition() { $this->setTableName('api_key'); $this->hasColumn('ak_id', 'integer', 4, array('primary' => true, 'autoincrement' => true)); $this->hasColumn('ak_key', 'string', 32, array('notnull' => true, 'unique' => true)); $this->hasColumn('ak_email', 'string', 255, array('notnull' => true)); $this->hasColumn('ak_contact', 'string', 255, array('notnull' => true)); $this->hasColumn('ak_approved', 'integer', 1, array('default' => 0)); $this->hasColumn('ak_cre_dtim', 'timestamp', null, array('notnull' => true)); $this->hasColumn('ak_upd_dtim', 'timestamp', null, array()); parent::setTableDefinition(); }
/** * Set the table columns */ public function setTableDefinition() { $this->setTableName('iptc_master'); $this->hasColumn('iptc_id', 'integer', 4, array('primary' => true, 'autoincrement' => true)); $this->hasColumn('iptc_concept_code', 'string', 32, array('notnull' => true)); $this->hasColumn('iptc_name', 'string', 255, array('notnull' => true, 'unique' => true)); $this->hasColumn('iptc_cre_user', 'integer', 4, array('notnull' => true)); $this->hasColumn('iptc_upd_user', 'integer', 4, array()); $this->hasColumn('iptc_cre_dtim', 'timestamp', null, array('notnull' => true)); $this->hasColumn('iptc_upd_dtim', 'timestamp', null, array()); parent::setTableDefinition(); }
/** * Set the table columns */ public function setTableDefinition() { $this->setTableName('tag_master'); $this->hasColumn('tm_id', 'integer', 4, array('primary' => true, 'autoincrement' => true)); $this->hasColumn('tm_type', 'string', 1, array('fixed' => true, 'notnull' => true, 'default' => self::$TYPE_JOURNALISTIC)); $this->hasColumn('tm_name', 'string', 32, array('unique' => true, 'airvalid' => array('/^[a-zA-Z0-9 _\\-\\.]*$/' => 'Invalid character(s)! Use [A-Za-z0-9] and [ -_.]', '/^[\\S].*[\\S]$/' => 'Invalid leading or trailing whitespace'))); $this->hasColumn('tm_iptc_id', 'integer', 4, array('unique' => true)); $this->hasColumn('tm_cre_user', 'integer', 4, array('notnull' => true)); $this->hasColumn('tm_upd_user', 'integer', 4, array()); $this->hasColumn('tm_cre_dtim', 'timestamp', null, array('notnull' => true)); $this->hasColumn('tm_upd_dtim', 'timestamp', null, array()); parent::setTableDefinition(); }
/** * Set the table columns */ public function setTableDefinition() { $this->setTableName('user_uri'); $this->hasColumn('uuri_id', 'integer', 4, array('primary' => true, 'autoincrement' => true)); $this->hasColumn('uuri_uuid', 'string', 12, array('fixed' => true, 'notnull' => true, 'unique' => true)); $this->hasColumn('uuri_user_id', 'integer', 4, array('notnull' => true)); $this->hasColumn('uuri_type', 'string', 1, array('fixed' => true, 'notnull' => true)); $this->hasColumn('uuri_value', 'string', 255, array('notnull' => true)); $this->hasColumn('uuri_feed', 'string', 255, array()); $this->hasColumn('uuri_upd_int', 'integer', 4, array()); $this->hasColumn('uuri_handle', 'string', 128, array()); parent::setTableDefinition(); }
/** * Set the table columns */ public function setTableDefinition() { $this->setTableName('admin_role'); $this->hasColumn('ar_id', 'integer', 4, array('primary' => true, 'autoincrement' => true)); $this->hasColumn('ar_code', 'string', 1, array('fixed' => true, 'notnull' => true, 'unique' => true)); $this->hasColumn('ar_name', 'string', 128, array('notnull' => true)); $this->hasColumn('ar_status', 'string', 1, array('fixed' => true, 'notnull' => true, 'default' => self::$STATUS_ACTIVE)); $this->hasColumn('ar_cre_user', 'integer', 4, array('notnull' => true)); $this->hasColumn('ar_upd_user', 'integer', 4, array()); $this->hasColumn('ar_cre_dtim', 'timestamp', null, array('notnull' => true)); $this->hasColumn('ar_upd_dtim', 'timestamp', null, array()); parent::setTableDefinition(); }