# 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_template varchar(100) DEFAULT '',
    tx_opentalent_template_preferences text DEFAULT '',
    tx_opentalent_matomo_id bigint
);

#
# 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)
);