/**
* 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();
}
