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 int(11) DEFAULT '0' NOT NULL,
    category int(11) DEFAULT '0' NOT NULL,
	term text NOT NULL DEFAULT '',
	url varchar(255) DEFAULT '',
    PRIMARY KEY (uid)
);

CREATE TABLE tx_begriffmgt_domain_model_category (
     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,
     title varchar(255) NOT NULL,
     terms text DEFAULT '',
     PRIMARY KEY (uid)
);


CREATE TABLE tx_begriffmgt_domain_model_type (
     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,
     title varchar(255) NOT NULL,
     terms text DEFAULT '',
     PRIMARY KEY (uid)
);