# ext_tables.sql contient les directives permettant d ajouter des tables et champs à la DB

#
# Table structure for table 'pages'
#
CREATE TABLE pages (
	tx_opentalent_structure_id bigint,
	tx_opentalent_structure_domain varchar(255)
);

#
# Table structure for table 'tx_opentalent_custom_domains'
#
CREATE TABLE tx_opentalent_custom_domains
(
    uid INT UNSIGNED NOT NULL,
    organization_id INT NOT NULL,
    domain VARCHAR(2048) NOT NULL
);

#
# Table structure for table 'tx_opentalent_log'
#
CREATE TABLE tx_opentalent_log (
    request_id varchar(13) DEFAULT '' NOT NULL,
    time_micro double(16,4) NOT NULL default '0.0000',
    component varchar(255) DEFAULT '' NOT NULL,
    level tinyint(1) unsigned DEFAULT '0' NOT NULL,
    message text,
    data text,

    KEY request (request_id)
);
