Code:
Tabellen anlegen
Alle auswählen
CREATE TABLE tl_nc_gateway (
id INT UNSIGNED AUTO_INCREMENT NOT NULL,
tstamp INT UNSIGNED DEFAULT 0 NOT NULL,
title VARCHAR(255) DEFAULT '' NOT NULL,
type VARCHAR(32) DEFAULT '' NOT NULL,
queue_targetGateway INT DEFAULT 0 NOT NULL,
queue_delay VARCHAR(64) DEFAULT '' NOT NULL,
queue_cronEnable CHAR(1) DEFAULT '' NOT NULL,
queue_cronInterval VARCHAR(12) DEFAULT '' NOT NULL,
queue_cronMessages INT DEFAULT 0 NOT NULL,
email_overrideSmtp CHAR(1) DEFAULT '' NOT NULL,
email_smtpHost VARCHAR(255) DEFAULT '' NOT NULL,
email_smtpUser VARCHAR(255) DEFAULT '' NOT NULL,
email_smtpPass VARCHAR(255) DEFAULT '' NOT NULL,
email_smtpEnc VARCHAR(3) DEFAULT '' NOT NULL,
email_smtpPort VARCHAR(16) DEFAULT '' NOT NULL,
file_type VARCHAR(4) DEFAULT '' NOT NULL,
file_connection VARCHAR(8) DEFAULT '' NOT NULL,
file_host VARCHAR(255) DEFAULT '' NOT NULL,
file_port VARCHAR(5) DEFAULT '' NOT NULL,
file_username VARCHAR(255) DEFAULT '' NOT NULL,
file_password VARCHAR(255) DEFAULT '' NOT NULL,
file_path VARCHAR(255) DEFAULT '' NOT NULL,
postmark_key VARCHAR(64) DEFAULT '' NOT NULL,
postmark_test CHAR(1) DEFAULT '' NOT NULL,
postmark_ssl CHAR(1) DEFAULT '' NOT NULL,
INDEX queue_croninterval (queue_croninterval),
PRIMARY KEY(id)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB ROW_FORMAT = DYNAMIC
CREATE TABLE tl_nc_language (
id INT UNSIGNED AUTO_INCREMENT NOT NULL,
pid INT UNSIGNED DEFAULT 0 NOT NULL,
tstamp INT UNSIGNED DEFAULT 0 NOT NULL,
gateway_type VARCHAR(32) DEFAULT '' NOT NULL,
language VARCHAR(5) DEFAULT '' NOT NULL,
fallback CHAR(1) DEFAULT '' NOT NULL,
recipients VARCHAR(255) DEFAULT '' NOT NULL,
attachment_tokens VARCHAR(255) DEFAULT '' NOT NULL,
attachments BLOB DEFAULT NULL,
attachment_templates BLOB DEFAULT NULL,
email_sender_name VARCHAR(255) DEFAULT '' NOT NULL,
email_sender_address VARCHAR(255) DEFAULT '' NOT NULL,
email_recipient_cc TEXT DEFAULT NULL,
email_recipient_bcc TEXT DEFAULT NULL,
email_replyTo VARCHAR(255) DEFAULT '' NOT NULL,
email_subject VARCHAR(255) DEFAULT '' NOT NULL,
email_mode VARCHAR(16) DEFAULT '' NOT NULL,
email_text TEXT DEFAULT NULL,
email_html TEXT DEFAULT NULL,
email_external_images CHAR(1) DEFAULT '' NOT NULL,
file_name VARCHAR(255) DEFAULT '' NOT NULL,
file_storage_mode VARCHAR(8) DEFAULT '' NOT NULL,
file_content TEXT DEFAULT NULL,
INDEX pid (pid),
INDEX language (language),
PRIMARY KEY(id)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB ROW_FORMAT = DYNAMIC
CREATE TABLE tl_nc_message (
id INT UNSIGNED AUTO_INCREMENT NOT NULL,
pid INT UNSIGNED DEFAULT 0 NOT NULL,
tstamp INT UNSIGNED DEFAULT 0 NOT NULL,
title VARCHAR(255) DEFAULT '' NOT NULL,
gateway INT UNSIGNED DEFAULT 0 NOT NULL,
gateway_type VARCHAR(32) DEFAULT '' NOT NULL,
email_priority INT UNSIGNED DEFAULT 0 NOT NULL,
email_template VARCHAR(255) DEFAULT '' NOT NULL,
postmark_tag VARCHAR(255) DEFAULT '' NOT NULL,
postmark_trackOpens CHAR(1) DEFAULT '' NOT NULL,
published CHAR(1) DEFAULT '' NOT NULL,
INDEX pid (pid),
PRIMARY KEY(id)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB ROW_FORMAT = DYNAMIC
CREATE TABLE tl_nc_notification (
id INT UNSIGNED AUTO_INCREMENT NOT NULL,
tstamp INT UNSIGNED DEFAULT 0 NOT NULL,
title VARCHAR(255) DEFAULT '' NOT NULL,
type VARCHAR(32) DEFAULT '' NOT NULL,
flatten_delimiter VARCHAR(255) DEFAULT '' NOT NULL,
templates BLOB DEFAULT NULL,
PRIMARY KEY(id)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB ROW_FORMAT = DYNAMIC
CREATE TABLE tl_nc_queue (
id INT UNSIGNED AUTO_INCREMENT NOT NULL,
sourceQueue INT UNSIGNED DEFAULT 0 NOT NULL,
targetGateway INT UNSIGNED DEFAULT 0 NOT NULL,
message INT UNSIGNED DEFAULT 0 NOT NULL,
dateAdded INT UNSIGNED DEFAULT 0 NOT NULL,
dateDelay INT UNSIGNED DEFAULT NULL,
dateSent VARCHAR(10) DEFAULT '' NOT NULL,
error CHAR(1) DEFAULT '' NOT NULL,
tokens BLOB DEFAULT NULL,
language VARCHAR(5) DEFAULT '' NOT NULL,
attachments BLOB DEFAULT NULL,
INDEX message (message),
INDEX sourcequeue (sourcequeue),
INDEX targetgateway (targetgateway),
PRIMARY KEY(id)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Spalten anlegen
Alle auswählen
ALTER TABLE tl_form ADD nc_notification INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_module ADD nc_activation_notification INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_module ADD nc_notification INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_undo ADD haste_data BLOB DEFAULT NULL
Lesezeichen