#
# Table structure for table 'tx_career_domain_model_source'
#
CREATE TABLE tx_career_domain_model_source (

    type varchar(255) DEFAULT '' NOT NULL,
    company_id varchar(255) DEFAULT '' NOT NULL,
    company_name varchar(255) DEFAULT '' NOT NULL,
	api_key varchar(255) DEFAULT '' NOT NULL,

);


#
# Table structure for table 'tx_career_api_token_collection'
#
CREATE TABLE tx_career_api_token_collection(

      uid int(11) NOT NULL auto_increment,
      crdate int(11) unsigned DEFAULT '0' NOT NULL,
      deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
      hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,

      access_token varchar(255) DEFAULT '' NOT NULL,
      client_id varchar(255) DEFAULT '' NOT NULL,
      client_secret varchar(255) DEFAULT '' NOT NULL,
      refresh_token varchar(255) DEFAULT '' NOT NULL,
      api_domain varchar(255) DEFAULT '' NOT NULL,
      token_type varchar(255) DEFAULT '' NOT NULL,
      expires_in varchar(255) DEFAULT '' NOT NULL,
      is_refresh int(11) unsigned DEFAULT '0',

      PRIMARY KEY (uid),
);
