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

#
# Table structure for table 'tx_opentalent_router'
#
CREATE TABLE tx_opentalent_router (
    uid INT UNSIGNED NOT NULL AUTO_INCREMENT,
    domain VARCHAR(2048) NOT NULL,
    root_uid INT UNSIGNED NOT NULL,
    slug VARCHAR(2048) NOT NULL,
    page_uid INT UNSIGNED NOT NULL,
    last_update DATETIME NOT NULL,
    PRIMARY KEY (uid)
);