chatbotbegriffe/ext_tables.sql

CREATE TABLE tx_begriffmgt_domain_model_term (
    uid int(11) unsigned NOT NULL AUTO_INCREMENT,
    pid int(11) DEFAULT '0' NOT NULL,
    tstamp int(11) unsigned DEFAULT '0' NOT NULL,
    crdate int(11) unsigned DEFAULT '0' NOT NULL,
    cruser_id int(11) DEFAULT '0' NOT NULL,
    deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
    hidden tinyint(1) unsigned DEFAULT '0' NOT NULL,
	type VARCHAR(255) DEFAULT '' NOT NULL,
	category VARCHAR(255) DEFAULT '',
	terms text NOT NULL DEFAULT '',
	url varchar(255) DEFAULT '',
    PRIMARY KEY (uid)
);