HTML-Code:
Tabelle tl_crawl_queue hinzufügen
CREATE TABLE tl_crawl_queue (id INT UNSIGNED AUTO_INCREMENT NOT NULL, job_id CHAR(128) NOT NULL, uri LONGTEXT NOT NULL, uri_hash CHAR(40) NOT NULL, found_on LONGTEXT DEFAULT NULL, level SMALLINT NOT NULL, processed TINYINT(1) NOT NULL, tags LONGTEXT DEFAULT NULL, INDEX job_id (job_id), INDEX uri_hash (uri_hash), INDEX processed (processed), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_cron_job hinzufügen
CREATE TABLE tl_cron_job (id INT UNSIGNED AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, lastRun DATETIME NOT NULL, INDEX name (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_remember_me hinzufügen
CREATE TABLE tl_remember_me (id INT UNSIGNED AUTO_INCREMENT NOT NULL, series BINARY(32) NOT NULL COMMENT '(DC2Type:binary_string)', value BINARY(64) NOT NULL COMMENT '(DC2Type:binary_string)', lastUsed DATETIME NOT NULL, expires DATETIME DEFAULT NULL, class VARCHAR(100) NOT NULL, username VARCHAR(200) NOT NULL, INDEX series (series), UNIQUE INDEX value (value), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_trusted_device hinzufügen
CREATE TABLE tl_trusted_device (id INT AUTO_INCREMENT NOT NULL, created DATETIME NOT NULL, userClass VARCHAR(255) DEFAULT NULL, userId INT DEFAULT NULL, user_agent LONGTEXT DEFAULT NULL, ua_family VARCHAR(255) DEFAULT NULL, os_family VARCHAR(255) DEFAULT NULL, device_family VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_calendar hinzufügen
CREATE TABLE tl_calendar (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL, jumpTo INT UNSIGNED DEFAULT 0 NOT NULL, protected CHAR(1) DEFAULT '' NOT NULL, groups BLOB DEFAULT NULL, allowComments CHAR(1) DEFAULT '' NOT NULL, notify VARCHAR(32) DEFAULT 'notify_admin' NOT NULL, sortOrder VARCHAR(32) DEFAULT 'ascending' NOT NULL, perPage SMALLINT UNSIGNED DEFAULT 0 NOT NULL, moderate CHAR(1) DEFAULT '' NOT NULL, bbcode CHAR(1) DEFAULT '' NOT NULL, requireLogin CHAR(1) DEFAULT '' NOT NULL, disableCaptcha CHAR(1) DEFAULT '' NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_calendar_events hinzufügen
CREATE TABLE tl_calendar_events (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, featured CHAR(1) DEFAULT '' NOT NULL, alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`, author INT UNSIGNED DEFAULT 0 NOT NULL, addTime CHAR(1) DEFAULT '' NOT NULL, startTime BIGINT DEFAULT NULL, endTime BIGINT DEFAULT NULL, startDate BIGINT DEFAULT NULL, endDate BIGINT DEFAULT NULL, pageTitle VARCHAR(255) DEFAULT '' NOT NULL, robots VARCHAR(32) DEFAULT '' NOT NULL, description TEXT DEFAULT NULL, location VARCHAR(255) DEFAULT '' NOT NULL, address VARCHAR(255) DEFAULT '' NOT NULL, teaser TEXT DEFAULT NULL, addImage CHAR(1) DEFAULT '' NOT NULL, overwriteMeta CHAR(1) DEFAULT '' NOT NULL, singleSRC BINARY(16) DEFAULT NULL, alt VARCHAR(255) DEFAULT '' NOT NULL, imageTitle VARCHAR(255) DEFAULT '' NOT NULL, size VARCHAR(64) DEFAULT '' NOT NULL, imagemargin VARCHAR(128) DEFAULT '' NOT NULL, imageUrl VARCHAR(2048) DEFAULT '' NOT NULL, fullsize CHAR(1) DEFAULT '' NOT NULL, caption VARCHAR(255) DEFAULT '' NOT NULL, floating VARCHAR(32) DEFAULT 'above' NOT NULL, recurring CHAR(1) DEFAULT '' NOT NULL, repeatEach VARCHAR(64) DEFAULT '' NOT NULL, repeatEnd INT UNSIGNED DEFAULT 0 NOT NULL, recurrences SMALLINT UNSIGNED DEFAULT 0 NOT NULL, addEnclosure CHAR(1) DEFAULT '' NOT NULL, enclosure BLOB DEFAULT NULL, source VARCHAR(32) DEFAULT 'default' NOT NULL, jumpTo INT UNSIGNED DEFAULT 0 NOT NULL, articleId INT UNSIGNED DEFAULT 0 NOT NULL, url VARCHAR(2048) DEFAULT '' NOT NULL, target CHAR(1) DEFAULT '' NOT NULL, cssClass VARCHAR(255) DEFAULT '' NOT NULL, noComments CHAR(1) DEFAULT '' NOT NULL, published CHAR(1) DEFAULT '' NOT NULL, start VARCHAR(10) DEFAULT '' NOT NULL, stop VARCHAR(10) DEFAULT '' NOT NULL, INDEX alias (alias), INDEX pid_published_featured_start_stop (pid, published, featured, start, stop), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_calendar_feed hinzufügen
CREATE TABLE tl_calendar_feed (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL, alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`, language VARCHAR(32) DEFAULT '' NOT NULL, calendars BLOB DEFAULT NULL, format VARCHAR(32) DEFAULT 'rss' NOT NULL, source VARCHAR(32) DEFAULT 'source_teaser' NOT NULL, maxItems SMALLINT UNSIGNED DEFAULT 25 NOT NULL, feedBase VARCHAR(255) DEFAULT '' NOT NULL, description TEXT DEFAULT NULL, imgSize VARCHAR(255) DEFAULT '' NOT NULL, INDEX alias (alias), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_comments hinzufügen
CREATE TABLE tl_comments (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, source VARCHAR(32) DEFAULT '' NOT NULL, parent INT UNSIGNED DEFAULT 0 NOT NULL, date VARCHAR(64) DEFAULT '' NOT NULL, name VARCHAR(64) DEFAULT '' NOT NULL, email VARCHAR(255) DEFAULT '' NOT NULL, website VARCHAR(128) DEFAULT '' NOT NULL, member INT UNSIGNED DEFAULT 0 NOT NULL, comment TEXT DEFAULT NULL, addReply CHAR(1) DEFAULT '' NOT NULL, author INT UNSIGNED DEFAULT 0 NOT NULL, reply TEXT DEFAULT NULL, published CHAR(1) DEFAULT '' NOT NULL, ip VARCHAR(64) DEFAULT '' NOT NULL, notified CHAR(1) DEFAULT '' NOT NULL, notifiedReply CHAR(1) DEFAULT '' NOT NULL, INDEX published (published), INDEX source_parent_published (source, parent, published), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_comments_notify hinzufügen
CREATE TABLE tl_comments_notify (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, source VARCHAR(32) DEFAULT '' NOT NULL, parent INT UNSIGNED DEFAULT 0 NOT NULL, name VARCHAR(128) DEFAULT '' NOT NULL, email VARCHAR(255) DEFAULT '' NOT NULL, url VARCHAR(2048) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`, addedOn VARCHAR(10) DEFAULT '' NOT NULL, active CHAR(1) DEFAULT '' NOT NULL, tokenRemove VARCHAR(32) DEFAULT '' NOT NULL, INDEX source_parent_active_email (source, parent, active, email), INDEX tokenremove (tokenremove), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_faq hinzufügen
CREATE TABLE tl_faq (id INT UNSIGNED AUTO_INCREMENT NOT NULL, pid INT UNSIGNED DEFAULT 0 NOT NULL, sorting INT UNSIGNED DEFAULT 0 NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, question VARCHAR(255) DEFAULT '' NOT NULL, alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`, author INT UNSIGNED DEFAULT 0 NOT NULL, answer TEXT DEFAULT NULL, pageTitle VARCHAR(255) DEFAULT '' NOT NULL, robots VARCHAR(32) DEFAULT '' NOT NULL, description TEXT DEFAULT NULL, addImage CHAR(1) DEFAULT '' NOT NULL, overwriteMeta CHAR(1) DEFAULT '' NOT NULL, singleSRC BINARY(16) DEFAULT NULL, alt VARCHAR(255) DEFAULT '' NOT NULL, imageTitle VARCHAR(255) DEFAULT '' NOT NULL, size VARCHAR(64) DEFAULT '' NOT NULL, imagemargin VARCHAR(128) DEFAULT '' NOT NULL, imageUrl VARCHAR(2048) DEFAULT '' NOT NULL, fullsize CHAR(1) DEFAULT '' NOT NULL, caption VARCHAR(255) DEFAULT '' NOT NULL, floating VARCHAR(12) DEFAULT 'above' NOT NULL, addEnclosure CHAR(1) DEFAULT '' NOT NULL, enclosure BLOB DEFAULT NULL, noComments CHAR(1) DEFAULT '' NOT NULL, published CHAR(1) DEFAULT '' NOT NULL, INDEX pid_published (pid, published), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_faq_category hinzufügen
CREATE TABLE tl_faq_category (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL, headline VARCHAR(255) DEFAULT '' NOT NULL, jumpTo INT UNSIGNED DEFAULT 0 NOT NULL, allowComments CHAR(1) DEFAULT '' NOT NULL, notify VARCHAR(16) DEFAULT 'notify_admin' NOT NULL, sortOrder VARCHAR(12) DEFAULT 'ascending' NOT NULL, perPage SMALLINT UNSIGNED DEFAULT 0 NOT NULL, moderate CHAR(1) DEFAULT '' NOT NULL, bbcode CHAR(1) DEFAULT '' NOT NULL, requireLogin CHAR(1) DEFAULT '' NOT NULL, disableCaptcha CHAR(1) DEFAULT '' NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_news hinzufügen
CREATE TABLE tl_news (id INT UNSIGNED AUTO_INCREMENT NOT NULL, pid INT UNSIGNED DEFAULT 0 NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, headline VARCHAR(255) DEFAULT '' NOT NULL, featured CHAR(1) DEFAULT '' NOT NULL, alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`, author INT UNSIGNED DEFAULT 0 NOT NULL, date INT UNSIGNED DEFAULT 0 NOT NULL, time INT DEFAULT 0 NOT NULL, pageTitle VARCHAR(255) DEFAULT '' NOT NULL, robots VARCHAR(32) DEFAULT '' NOT NULL, description TEXT DEFAULT NULL, subheadline VARCHAR(255) DEFAULT '' NOT NULL, teaser TEXT DEFAULT NULL, addImage CHAR(1) DEFAULT '' NOT NULL, overwriteMeta CHAR(1) DEFAULT '' NOT NULL, singleSRC BINARY(16) DEFAULT NULL, alt VARCHAR(255) DEFAULT '' NOT NULL, imageTitle VARCHAR(255) DEFAULT '' NOT NULL, size VARCHAR(64) DEFAULT '' NOT NULL, imagemargin VARCHAR(128) DEFAULT '' NOT NULL, imageUrl VARCHAR(2048) DEFAULT '' NOT NULL, fullsize CHAR(1) DEFAULT '' NOT NULL, caption VARCHAR(255) DEFAULT '' NOT NULL, floating VARCHAR(12) DEFAULT 'above' NOT NULL, addEnclosure CHAR(1) DEFAULT '' NOT NULL, enclosure BLOB DEFAULT NULL, source VARCHAR(12) DEFAULT 'default' NOT NULL, jumpTo INT UNSIGNED DEFAULT 0 NOT NULL, articleId INT UNSIGNED DEFAULT 0 NOT NULL, url VARCHAR(2048) DEFAULT '' NOT NULL, target CHAR(1) DEFAULT '' NOT NULL, cssClass VARCHAR(255) DEFAULT '' NOT NULL, noComments CHAR(1) DEFAULT '' NOT NULL, published CHAR(1) DEFAULT '' NOT NULL, start VARCHAR(10) DEFAULT '' NOT NULL, stop VARCHAR(10) DEFAULT '' NOT NULL, INDEX alias (alias), INDEX pid_published_featured_start_stop (pid, published, featured, start, stop), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_news_archive hinzufügen
CREATE TABLE tl_news_archive (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL, jumpTo INT UNSIGNED DEFAULT 0 NOT NULL, protected CHAR(1) DEFAULT '' NOT NULL, groups BLOB DEFAULT NULL, allowComments CHAR(1) DEFAULT '' NOT NULL, notify VARCHAR(16) DEFAULT 'notify_admin' NOT NULL, sortOrder VARCHAR(32) DEFAULT 'ascending' NOT NULL, perPage SMALLINT UNSIGNED DEFAULT 0 NOT NULL, moderate CHAR(1) DEFAULT '' NOT NULL, bbcode CHAR(1) DEFAULT '' NOT NULL, requireLogin CHAR(1) DEFAULT '' NOT NULL, disableCaptcha CHAR(1) DEFAULT '' NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_news_feed hinzufügen
CREATE TABLE tl_news_feed (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL, alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`, language VARCHAR(32) DEFAULT '' NOT NULL, archives BLOB DEFAULT NULL, format VARCHAR(32) DEFAULT 'rss' NOT NULL, source VARCHAR(32) DEFAULT 'source_teaser' NOT NULL, maxItems SMALLINT UNSIGNED DEFAULT 25 NOT NULL, feedBase VARCHAR(255) DEFAULT '' NOT NULL, description TEXT DEFAULT NULL, imgSize VARCHAR(255) DEFAULT '' NOT NULL, INDEX alias (alias), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_newsletter hinzufügen
CREATE TABLE tl_newsletter (id INT UNSIGNED AUTO_INCREMENT NOT NULL, pid INT UNSIGNED DEFAULT 0 NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, subject VARCHAR(255) DEFAULT '' NOT NULL, alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`, content MEDIUMTEXT DEFAULT NULL, text MEDIUMTEXT DEFAULT NULL, addFile CHAR(1) DEFAULT '' NOT NULL, files BLOB DEFAULT NULL, template VARCHAR(64) DEFAULT '' NOT NULL, sendText CHAR(1) DEFAULT '' NOT NULL, externalImages CHAR(1) DEFAULT '' NOT NULL, mailerTransport VARCHAR(255) DEFAULT '' NOT NULL, sender VARCHAR(255) DEFAULT '' NOT NULL, senderName VARCHAR(128) DEFAULT '' NOT NULL, sent CHAR(1) DEFAULT '' NOT NULL, date VARCHAR(10) DEFAULT '' NOT NULL, INDEX pid (pid), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_newsletter_channel hinzufügen
CREATE TABLE tl_newsletter_channel (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL, jumpTo INT UNSIGNED DEFAULT 0 NOT NULL, template VARCHAR(32) DEFAULT '' NOT NULL, mailerTransport VARCHAR(255) DEFAULT '' NOT NULL, sender VARCHAR(255) DEFAULT '' NOT NULL, senderName VARCHAR(128) DEFAULT '' NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_newsletter_deny_list hinzufügen
CREATE TABLE tl_newsletter_deny_list (id INT UNSIGNED AUTO_INCREMENT NOT NULL, pid INT UNSIGNED DEFAULT 0 NOT NULL, hash VARCHAR(32) DEFAULT NULL, UNIQUE INDEX pid_hash (pid, hash), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_newsletter_recipients hinzufügen
CREATE TABLE tl_newsletter_recipients (id INT UNSIGNED AUTO_INCREMENT NOT NULL, pid INT UNSIGNED DEFAULT 0 NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, email VARCHAR(255) DEFAULT '' NOT NULL, active CHAR(1) DEFAULT '' NOT NULL, addedOn VARCHAR(10) DEFAULT '' NOT NULL, UNIQUE INDEX pid_email (pid, email), INDEX email (email), INDEX active (active), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_opt_in hinzufügen
CREATE TABLE tl_opt_in (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, token VARCHAR(24) DEFAULT '' NOT NULL, createdOn INT UNSIGNED DEFAULT 0 NOT NULL, confirmedOn INT UNSIGNED DEFAULT 0 NOT NULL, removeOn INT UNSIGNED DEFAULT 0 NOT NULL, invalidatedThrough VARCHAR(24) DEFAULT '' NOT NULL, email VARCHAR(255) DEFAULT '' NOT NULL, emailSubject VARCHAR(255) DEFAULT '' NOT NULL, emailText TEXT DEFAULT NULL, UNIQUE INDEX token (token), INDEX removeon (removeon), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_opt_in_related hinzufügen
CREATE TABLE tl_opt_in_related (id INT UNSIGNED AUTO_INCREMENT NOT NULL, pid INT UNSIGNED DEFAULT 0 NOT NULL, relTable VARCHAR(64) DEFAULT NULL, relId INT UNSIGNED DEFAULT 0 NOT NULL, INDEX reltable_relid (reltable, relid), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_preview_link hinzufügen
CREATE TABLE tl_preview_link (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, url VARCHAR(2048) DEFAULT '' NOT NULL, showUnpublished CHAR(1) DEFAULT '' NOT NULL, restrictToUrl CHAR(1) DEFAULT '1' NOT NULL, createdAt INT UNSIGNED DEFAULT 0 NOT NULL, expiresAt INT UNSIGNED DEFAULT 0 NOT NULL, published CHAR(1) DEFAULT '' NOT NULL, createdBy INT UNSIGNED DEFAULT 0 NOT NULL, INDEX id_published_expiresat (id, published, expiresat), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_search hinzufügen
CREATE TABLE tl_search (id INT UNSIGNED AUTO_INCREMENT NOT NULL, pid INT UNSIGNED DEFAULT 0 NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, title TEXT DEFAULT NULL, url VARCHAR(2048) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`, text MEDIUMTEXT DEFAULT NULL, filesize DOUBLE PRECISION DEFAULT '0' NOT NULL, checksum VARCHAR(32) DEFAULT '' NOT NULL, protected CHAR(1) DEFAULT '' NOT NULL, groups BLOB DEFAULT NULL, language VARCHAR(5) DEFAULT '' NOT NULL, vectorLength DOUBLE PRECISION DEFAULT '0' NOT NULL, meta MEDIUMTEXT DEFAULT NULL, UNIQUE INDEX url (url), UNIQUE INDEX checksum_pid (checksum, pid), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_search_index hinzufügen
CREATE TABLE tl_search_index (pid INT UNSIGNED NOT NULL, termId INT UNSIGNED NOT NULL, relevance SMALLINT UNSIGNED NOT NULL, INDEX pid (pid), PRIMARY KEY(termid, pid)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_search_term hinzufügen
CREATE TABLE tl_search_term (id INT UNSIGNED AUTO_INCREMENT NOT NULL, term VARCHAR(64) NOT NULL COLLATE `utf8mb4_bin`, documentFrequency INT UNSIGNED NOT NULL, UNIQUE INDEX term (term), INDEX documentfrequency (documentfrequency), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_repository_installs löschen
Tabelle tl_repository_instfiles löschen
Tabelle tl_session löschen
Tabelle tl_rocksolid_slider löschen
Tabelle tl_rocksolid_mega_menu_column löschen
Tabelle tl_dma_eg_fields löschen
Tabelle tl_rocksolid_slide löschen
Tabelle tl_dma_eg löschen
Tabelle tl_rocksolid_mega_menu löschen
Tabelle tl_cron löschen
Index "pid_start_stop_published_sorting" aus tl_article löschen
Feld tl_article.teaser ändern
TEXT DEFAULT NULL
ALTER TABLE tl_article CHANGE teaser teaser TEXT DEFAULT NULL
Feld tl_article.keywords ändern
TEXT DEFAULT NULL
ALTER TABLE tl_article CHANGE keywords keywords TEXT DEFAULT NULL
Feld tl_article.inColumn ändern
VARCHAR(32) DEFAULT 'main' NOT NULL
ALTER TABLE tl_article CHANGE inColumn inColumn VARCHAR(32) DEFAULT 'main' NOT NULL
Feld tl_article.alias ändern
VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_article CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
Feld tl_article.space löschen
Index "pid_published_incolumn_start_stop" zu tl_article hinzufügen
pid, published, incolumn, start, stop
CREATE INDEX pid_published_incolumn_start_stop ON tl_article (pid, published, incolumn, start, stop)
Index "pid_ptable_invisible_sorting" aus tl_content löschen
Feld tl_content.vimeoOptions ändern
TEXT DEFAULT NULL
ALTER TABLE tl_content CHANGE vimeoOptions vimeoOptions TEXT DEFAULT NULL
Feld tl_content.playerOptions ändern
TEXT DEFAULT NULL
ALTER TABLE tl_content CHANGE playerOptions playerOptions TEXT DEFAULT NULL
Feld tl_content.overwriteLink ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE overwriteLink overwriteLink CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.youtubeOptions ändern
TEXT DEFAULT NULL
ALTER TABLE tl_content CHANGE youtubeOptions youtubeOptions TEXT DEFAULT NULL
Feld tl_content.overwriteMeta ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE overwriteMeta overwriteMeta CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.stop ändern
VARCHAR(10) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE stop stop VARCHAR(10) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.start ändern
VARCHAR(10) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE start start VARCHAR(10) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.invisible ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE invisible invisible CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.guests ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE guests guests CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.protected ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE protected protected CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.sliderContinuous ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE sliderContinuous sliderContinuous CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.playerSize ändern
VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE playerSize playerSize VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.youtube ändern
VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE youtube youtube VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.customTpl ändern
VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE customTpl customTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.galleryTpl ändern
VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE galleryTpl galleryTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.metaIgnore ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE metaIgnore metaIgnore CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.sortBy ändern
VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE sortBy sortBy VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.perRow ändern
SMALLINT UNSIGNED DEFAULT 4 NOT NULL
ALTER TABLE tl_content CHANGE perRow perRow SMALLINT UNSIGNED DEFAULT 4 NOT NULL
Feld tl_content.useHomeDir ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE useHomeDir useHomeDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.useImage ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE useImage useImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.target ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE target target CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.url ändern
TEXT DEFAULT NULL
ALTER TABLE tl_content CHANGE url url TEXT DEFAULT NULL
Feld tl_content.code ändern
TEXT DEFAULT NULL
ALTER TABLE tl_content CHANGE code code TEXT DEFAULT NULL
Feld tl_content.highlight ändern
VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE highlight highlight VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.sortOrder ändern
VARCHAR(32) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE sortOrder sortOrder VARCHAR(32) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
Feld tl_content.sortable ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE sortable sortable CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.tleft ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE tleft tleft CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.tfoot ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE tfoot tfoot CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.thead ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE thead thead CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.listtype ändern
VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE listtype listtype VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.html ändern
MEDIUMTEXT DEFAULT NULL
ALTER TABLE tl_content CHANGE html html MEDIUMTEXT DEFAULT NULL
Feld tl_content.floating ändern
VARCHAR(32) CHARACTER SET ascii DEFAULT 'above' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE floating floating VARCHAR(32) CHARACTER SET ascii DEFAULT 'above' NOT NULL COLLATE `ascii_bin`
Feld tl_content.fullsize ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE fullsize fullsize CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.imageUrl ändern
TEXT DEFAULT NULL
ALTER TABLE tl_content CHANGE imageUrl imageUrl TEXT DEFAULT NULL
Feld tl_content.imagemargin ändern
VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE imagemargin imagemargin VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.size ändern
VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE size size VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.addImage ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE addImage addImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.text ändern
MEDIUMTEXT DEFAULT NULL
ALTER TABLE tl_content CHANGE text text MEDIUMTEXT DEFAULT NULL
Feld tl_content.headline ändern
VARCHAR(255) DEFAULT 'a:2:{s:5:"value";s:0:"";s:4:"unit";s:2:"h2";}' NOT NULL
ALTER TABLE tl_content CHANGE headline headline VARCHAR(255) DEFAULT 'a:2:{s:5:"value";s:0:"";s:4:"unit";s:2:"h2";}' NOT NULL
Feld tl_content.type ändern
VARCHAR(64) CHARACTER SET ascii DEFAULT 'text' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE type type VARCHAR(64) CHARACTER SET ascii DEFAULT 'text' NOT NULL COLLATE `ascii_bin`
Feld tl_content.ptable ändern
VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE ptable ptable VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.youtubeStop löschen
Feld tl_content.youtubeStart löschen
Feld tl_content.rsts_visibleAreaAlign löschen
Feld tl_content.rsts_thumbControls löschen
Feld tl_content.rsts_import_settings_from löschen
Feld tl_content.rsts_import_settings löschen
Feld tl_content.dmaElementTpl löschen
Feld tl_content.dma_eg_data löschen
Feld tl_content.rsts_cssPrefix löschen
Feld tl_content.rsts_customSkin löschen
Feld tl_content.rsts_combineNavItems löschen
Feld tl_content.rsts_rowSlideRatio löschen
Feld tl_content.rsts_rowMinSize löschen
Feld tl_content.rsts_rowMaxCount löschen
Feld tl_content.rsts_slideMaxSize löschen
Feld tl_content.rsts_slideMinSize löschen
Feld tl_content.rsts_visibleAreaMax löschen
Feld tl_content.rsts_visibleArea löschen
Feld tl_content.rsts_prevNextSteps löschen
Feld tl_content.rsts_slideMaxCount löschen
Feld tl_content.rsts_thumbs_rowSlideRatio löschen
Feld tl_content.rsts_thumbs_rowMinSize löschen
Feld tl_content.rsts_thumbs_rowMaxCount löschen
Feld tl_content.rsts_thumbs_slideMaxSize löschen
Feld tl_content.rsts_thumbs_slideMinSize löschen
Feld tl_content.rsts_thumbs_visibleAreaMax löschen
Feld tl_content.rsts_thumbs_visibleArea löschen
Feld tl_content.rsts_thumbs_prevNextSteps löschen
Feld tl_content.rsts_thumbs_slideMaxCount löschen
Feld tl_content.rsts_thumbs_imgSize löschen
Feld tl_content.rsts_thumbs_controls löschen
Feld tl_content.rsts_thumbs_imagePosition löschen
Feld tl_content.rsts_thumbs_scaleMode löschen
Feld tl_content.rsts_thumbs_duration löschen
Feld tl_content.rsts_thumbs_gapSize löschen
Feld tl_content.rsts_thumbs_height löschen
Feld tl_content.rsts_thumbs_width löschen
Feld tl_content.rsts_thumbs löschen
Feld tl_content.rsts_captions löschen
Feld tl_content.rsts_keyboard löschen
Feld tl_content.rsts_deepLinkPrefix löschen
Feld tl_content.rsts_imagePosition löschen
Feld tl_content.rsts_scaleMode löschen
Feld tl_content.rsts_invertControls löschen
Feld tl_content.rsts_controls löschen
Feld tl_content.rsts_navType löschen
Feld tl_content.rsts_pauseAutoplayOnHover löschen
Feld tl_content.rsts_autoplayProgress löschen
Feld tl_content.rsts_autoplayRestart löschen
Feld tl_content.rsts_videoAutoplay löschen
Feld tl_content.rsts_autoplay löschen
Feld tl_content.rsts_duration löschen
Feld tl_content.rsts_gapSize löschen
Feld tl_content.rsts_preloadSlides löschen
Feld tl_content.rsts_height löschen
Feld tl_content.rsts_width löschen
Feld tl_content.rsts_skin löschen
Feld tl_content.rsts_centerContent löschen
Feld tl_content.rsts_loop löschen
Feld tl_content.rsts_random löschen
Feld tl_content.rsts_direction löschen
Feld tl_content.rsts_type löschen
Feld tl_content.rsts_template löschen
Feld tl_content.rsts_id löschen
Feld tl_content.rsts_content_type löschen
Feld tl_content.rsce_data löschen
Feld tl_content.rs_columns_small löschen
Feld tl_content.rs_columns_medium löschen
Feld tl_content.rs_columns_large löschen
Feld tl_content.space löschen
Feld tl_content.autoplay löschen
Feld tl_content.shClass löschen
Feld tl_content.com_template hinzufügen
VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content ADD com_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.com_requireLogin hinzufügen
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content ADD com_requireLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.com_disableCaptcha hinzufügen
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content ADD com_disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.com_bbcode hinzufügen
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content ADD com_bbcode CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.com_moderate hinzufügen
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content ADD com_moderate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.com_perPage hinzufügen
SMALLINT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_content ADD com_perPage SMALLINT UNSIGNED DEFAULT 0 NOT NULL
Feld tl_content.com_order hinzufügen
VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content ADD com_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
Feld tl_content.data hinzufügen
TEXT DEFAULT NULL
ALTER TABLE tl_content ADD data TEXT DEFAULT NULL
Feld tl_content.playerColor hinzufügen
VARCHAR(6) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content ADD playerColor VARCHAR(6) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.playerPreload hinzufügen
VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content ADD playerPreload VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.splashImage hinzufügen
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content ADD splashImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.playerAspect hinzufügen
VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content ADD playerAspect VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.playerCaption hinzufügen
VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_content ADD playerCaption VARCHAR(255) DEFAULT '' NOT NULL
Feld tl_content.vimeo hinzufügen
VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content ADD vimeo VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.markdownSource hinzufügen
VARCHAR(12) CHARACTER SET ascii DEFAULT 'sourceText' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content ADD markdownSource VARCHAR(12) CHARACTER SET ascii DEFAULT 'sourceText' NOT NULL COLLATE `ascii_bin`
Feld tl_content.inline hinzufügen
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content ADD inline CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.showPreview hinzufügen
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content ADD showPreview CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Index "pid_ptable_invisible_start_stop" zu tl_content hinzufügen
pid, ptable, invisible, start, stop
CREATE INDEX pid_ptable_invisible_start_stop ON tl_content (pid, ptable, invisible, start, stop)
Index "type" zu tl_content hinzufügen
type
CREATE INDEX type ON tl_content (type)
Index "path" aus tl_files löschen
Feld tl_files.name ändern
VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_files CHANGE name name VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
Feld tl_files.extension ändern
VARCHAR(16) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_files CHANGE extension extension VARCHAR(16) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
Feld tl_files.path ändern
VARCHAR(1022) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_files CHANGE path path VARCHAR(1022) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
Feld tl_files.lastModified hinzufügen
INT UNSIGNED DEFAULT NULL
ALTER TABLE tl_files ADD lastModified INT UNSIGNED DEFAULT NULL
CREATE INDEX path ON tl_files (path(768))
CREATE INDEX path ON tl_files (path(768))
Feld tl_form.method ändern
VARCHAR(12) DEFAULT 'POST' NOT NULL
ALTER TABLE tl_form CHANGE method method VARCHAR(12) DEFAULT 'POST' NOT NULL
Feld tl_form.format ändern
VARCHAR(12) DEFAULT 'raw' NOT NULL
ALTER TABLE tl_form CHANGE format format VARCHAR(12) DEFAULT 'raw' NOT NULL
Feld tl_form.alias ändern
VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_form CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
Feld tl_form.tableless löschen
Feld tl_form.customTpl hinzufügen
VARCHAR(64) DEFAULT '' NOT NULL
ALTER TABLE tl_form ADD customTpl VARCHAR(64) DEFAULT '' NOT NULL
Feld tl_form.mailerTransport hinzufügen
VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_form ADD mailerTransport VARCHAR(255) DEFAULT '' NOT NULL
Index "pid" aus tl_form_field löschen
Feld tl_form_field.extensions ändern
VARCHAR(255) DEFAULT 'jpg,jpeg
ALTER TABLE tl_form_field gif
ALTER TABLE tl_form_field png
ALTER TABLE tl_form_field pdf
ALTER TABLE tl_form_field doc
ALTER TABLE tl_form_field docx
ALTER TABLE tl_form_field xls
ALTER TABLE tl_form_field xlsx
ALTER TABLE tl_form_field ppt
ALTER TABLE tl_form_field pptx' NOT NULL
ALTER TABLE tl_form_field CHANGE extensions extensions VARCHAR(255) DEFAULT 'jpg,jpeg,gif,png,pdf,doc,docx,xls,xlsx,ppt,pptx' NOT NULL
Feld tl_form_field.size ändern
VARCHAR(255) DEFAULT 'a:2:{i:0;i:4;i:1;i:40;}' NOT NULL
ALTER TABLE tl_form_field CHANGE size size VARCHAR(255) DEFAULT 'a:2:{i:0;i:4;i:1;i:40;}' NOT NULL
Feld tl_form_field.html ändern
TEXT DEFAULT NULL
ALTER TABLE tl_form_field CHANGE html html TEXT DEFAULT NULL
Feld tl_form_field.text ändern
TEXT DEFAULT NULL
ALTER TABLE tl_form_field CHANGE text text TEXT DEFAULT NULL
Feld tl_form_field.type ändern
VARCHAR(64) DEFAULT 'text' NOT NULL
ALTER TABLE tl_form_field CHANGE type type VARCHAR(64) DEFAULT 'text' NOT NULL
Feld tl_form_field.rsce_data löschen
Feld tl_form_field.addSubmit löschen
Feld tl_form_field.fsType löschen
Feld tl_form_field.step hinzufügen
VARCHAR(10) DEFAULT '' NOT NULL
ALTER TABLE tl_form_field ADD step VARCHAR(10) DEFAULT '' NOT NULL
Feld tl_form_field.maxval hinzufügen
VARCHAR(10) DEFAULT '' NOT NULL
ALTER TABLE tl_form_field ADD maxval VARCHAR(10) DEFAULT '' NOT NULL
Feld tl_form_field.minval hinzufügen
VARCHAR(10) DEFAULT '' NOT NULL
ALTER TABLE tl_form_field ADD minval VARCHAR(10) DEFAULT '' NOT NULL
Feld tl_form_field.maxImageHeight hinzufügen
INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_form_field ADD maxImageHeight INT UNSIGNED DEFAULT 0 NOT NULL
Feld tl_form_field.maxImageWidth hinzufügen
INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_form_field ADD maxImageWidth INT UNSIGNED DEFAULT 0 NOT NULL
Feld tl_form_field.errorMsg hinzufügen
VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_form_field ADD errorMsg VARCHAR(255) DEFAULT '' NOT NULL
Feld tl_form_field.customRgxp hinzufügen
VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_form_field ADD customRgxp VARCHAR(255) DEFAULT '' NOT NULL
Index "pid_invisible" zu tl_form_field hinzufügen
pid, invisible
CREATE INDEX pid_invisible ON tl_form_field (pid, invisible)
Feld tl_image_size.lazyLoading hinzufügen
CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_image_size ADD lazyLoading CHAR(1) DEFAULT '' NOT NULL
Feld tl_image_size.formats hinzufügen
VARCHAR(1024) DEFAULT '' NOT NULL
ALTER TABLE tl_image_size ADD formats VARCHAR(1024) DEFAULT '' NOT NULL
Feld tl_image_size.cssClass hinzufügen
VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_image_size ADD cssClass VARCHAR(255) DEFAULT '' NOT NULL
Feld tl_layout.minifyMarkup ändern
CHAR(1) DEFAULT '1' NOT NULL
ALTER TABLE tl_layout CHANGE minifyMarkup minifyMarkup CHAR(1) DEFAULT '1' NOT NULL
Feld tl_layout.combineScripts ändern
CHAR(1) DEFAULT '1' NOT NULL
ALTER TABLE tl_layout CHANGE combineScripts combineScripts CHAR(1) DEFAULT '1' NOT NULL
Feld tl_layout.scripts ändern
TEXT DEFAULT NULL
ALTER TABLE tl_layout CHANGE scripts scripts TEXT DEFAULT NULL
Feld tl_layout.align ändern
VARCHAR(32) DEFAULT 'center' NOT NULL
ALTER TABLE tl_layout CHANGE align align VARCHAR(32) DEFAULT 'center' NOT NULL
Feld tl_layout.script ändern
TEXT DEFAULT NULL
ALTER TABLE tl_layout CHANGE script script TEXT DEFAULT NULL
Feld tl_layout.analytics ändern
TEXT DEFAULT NULL
ALTER TABLE tl_layout CHANGE analytics analytics TEXT DEFAULT NULL
Feld tl_layout.mootools ändern
TEXT DEFAULT NULL
ALTER TABLE tl_layout CHANGE mootools mootools TEXT DEFAULT NULL
Feld tl_layout.jquery ändern
TEXT DEFAULT NULL
ALTER TABLE tl_layout CHANGE jquery jquery TEXT DEFAULT NULL
Feld tl_layout.head ändern
TEXT DEFAULT NULL
ALTER TABLE tl_layout CHANGE head head TEXT DEFAULT NULL
Feld tl_layout.loadingOrder ändern
VARCHAR(16) DEFAULT 'external_first' NOT NULL
ALTER TABLE tl_layout CHANGE loadingOrder loadingOrder VARCHAR(16) DEFAULT 'external_first' NOT NULL
Feld tl_layout.framework ändern
VARCHAR(255) DEFAULT 'a:2:{i:0;s:10:"layout.css";i:1;s:14:"responsive.css";}' NOT NULL
ALTER TABLE tl_layout CHANGE framework framework VARCHAR(255) DEFAULT 'a:2:{i:0;s:10:"layout.css";i:1;s:14:"responsive.css";}' NOT NULL
Feld tl_layout.cols ändern
VARCHAR(8) DEFAULT '2cll' NOT NULL
ALTER TABLE tl_layout CHANGE cols cols VARCHAR(8) DEFAULT '2cll' NOT NULL
Feld tl_layout.`rows` ändern
VARCHAR(8) DEFAULT '2rwh' NOT NULL
ALTER TABLE tl_layout CHANGE `rows` `rows` VARCHAR(8) DEFAULT '2rwh' NOT NULL
Feld tl_layout.rs_columns_load_css löschen
Feld tl_layout.mooSource löschen
Feld tl_layout.jSource löschen
Feld tl_layout.picturefill löschen
Feld tl_layout.doctype löschen
Feld tl_layout.sPosition löschen
Feld tl_layout.defaultImageDensities hinzufügen
VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_layout ADD defaultImageDensities VARCHAR(255) DEFAULT '' NOT NULL
Feld tl_layout.lightboxSize hinzufügen
VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_layout ADD lightboxSize VARCHAR(255) DEFAULT '' NOT NULL
Feld tl_log.text ändern
TEXT DEFAULT NULL
ALTER TABLE tl_log CHANGE text text TEXT DEFAULT NULL
Feld tl_log.ip löschen
Index "autologin" aus tl_member löschen
Index "activation" aus tl_member löschen
Feld tl_member.password ändern
VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_member CHANGE password password VARCHAR(255) DEFAULT '' NOT NULL
Feld tl_member.username ändern
VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_member CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
Feld tl_member.language ändern
VARCHAR(64) DEFAULT '' NOT NULL
ALTER TABLE tl_member CHANGE language language VARCHAR(64) DEFAULT '' NOT NULL
Feld tl_member.activation löschen
Feld tl_member.autologin löschen
Feld tl_member.loginCount löschen
Feld tl_member.newsletter hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_member ADD newsletter BLOB DEFAULT NULL
Feld tl_member.backupCodes hinzufügen
TEXT DEFAULT NULL
ALTER TABLE tl_member ADD backupCodes TEXT DEFAULT NULL
Feld tl_member.useTwoFactor hinzufügen
CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_member ADD useTwoFactor CHAR(1) DEFAULT '' NOT NULL
Feld tl_member.secret hinzufügen
BINARY(128) DEFAULT NULL
ALTER TABLE tl_member ADD secret BINARY(128) DEFAULT NULL
Feld tl_member.loginAttempts hinzufügen
SMALLINT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_member ADD loginAttempts SMALLINT UNSIGNED DEFAULT 0 NOT NULL
Index "login_disable_start_stop" zu tl_member hinzufügen
login, disable, start, stop
CREATE INDEX login_disable_start_stop ON tl_member (login, disable, start, stop)
Feld tl_member.createdOn löschen
Feld tl_member.trustedTokenVersion hinzufügen
INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_member ADD trustedTokenVersion INT UNSIGNED DEFAULT 0 NOT NULL
Index "disable_start_stop" zu tl_member_group hinzufügen
disable, start, stop
CREATE INDEX disable_start_stop ON tl_member_group (disable, start, stop)
Feld tl_module.list_info_layout ändern
VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE list_info_layout list_info_layout VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.list_layout ändern
VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE list_layout list_layout VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.list_info_where ändern
TINYTEXT DEFAULT NULL
ALTER TABLE tl_module CHANGE list_info_where list_info_where TINYTEXT DEFAULT NULL
Feld tl_module.list_info ändern
TINYTEXT DEFAULT NULL
ALTER TABLE tl_module CHANGE list_info list_info TINYTEXT DEFAULT NULL
Feld tl_module.list_sort ändern
TINYTEXT DEFAULT NULL
ALTER TABLE tl_module CHANGE list_sort list_sort TINYTEXT DEFAULT NULL
Feld tl_module.list_search ändern
TINYTEXT DEFAULT NULL
ALTER TABLE tl_module CHANGE list_search list_search TINYTEXT DEFAULT NULL
Feld tl_module.list_where ändern
TINYTEXT DEFAULT NULL
ALTER TABLE tl_module CHANGE list_where list_where TINYTEXT DEFAULT NULL
Feld tl_module.list_fields ändern
TINYTEXT DEFAULT NULL
ALTER TABLE tl_module CHANGE list_fields list_fields TINYTEXT DEFAULT NULL
Feld tl_module.list_table ändern
VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE list_table list_table VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.guests ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE guests guests CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.protected ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE protected protected CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.reg_password ändern
TEXT DEFAULT NULL
ALTER TABLE tl_module CHANGE reg_password reg_password TEXT DEFAULT NULL
Feld tl_module.reg_text ändern
TEXT DEFAULT NULL
ALTER TABLE tl_module CHANGE reg_text reg_text TEXT DEFAULT NULL
Feld tl_module.reg_activate ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE reg_activate reg_activate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.reg_assignDir ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE reg_assignDir reg_assignDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.reg_close ändern
VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE reg_close reg_close VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.reg_skipName ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE reg_skipName reg_skipName CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.reg_allowLogin ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE reg_allowLogin reg_allowLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.disableCaptcha ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE disableCaptcha disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.numberOfItems ändern
SMALLINT UNSIGNED DEFAULT 3 NOT NULL
ALTER TABLE tl_module CHANGE numberOfItems numberOfItems SMALLINT UNSIGNED DEFAULT 3 NOT NULL
Feld tl_module.rss_template ändern
VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE rss_template rss_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.rss_feed ändern
TEXT DEFAULT NULL
ALTER TABLE tl_module CHANGE rss_feed rss_feed TEXT DEFAULT NULL
Feld tl_module.rss_cache ändern
INT UNSIGNED DEFAULT 3600 NOT NULL
ALTER TABLE tl_module CHANGE rss_cache rss_cache INT UNSIGNED DEFAULT 3600 NOT NULL
Feld tl_module.html ändern
TEXT DEFAULT NULL
ALTER TABLE tl_module CHANGE html html TEXT DEFAULT NULL
Feld tl_module.fullsize ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE fullsize fullsize CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.useCaption ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE useCaption useCaption CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.imgSize ändern
VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE imgSize imgSize VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.url ändern
TEXT DEFAULT NULL
ALTER TABLE tl_module CHANGE url url TEXT DEFAULT NULL
Feld tl_module.loadFirst ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE loadFirst loadFirst CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.inColumn ändern
VARCHAR(32) CHARACTER SET ascii DEFAULT 'main' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE inColumn inColumn VARCHAR(32) CHARACTER SET ascii DEFAULT 'main' NOT NULL COLLATE `ascii_bin`
Feld tl_module.searchTpl ändern
VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE searchTpl searchTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.searchType ändern
VARCHAR(16) CHARACTER SET ascii DEFAULT 'simple' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE searchType searchType VARCHAR(16) CHARACTER SET ascii DEFAULT 'simple' NOT NULL COLLATE `ascii_bin`
Feld tl_module.contextLength ändern
VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE contextLength contextLength VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.fuzzy ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE fuzzy fuzzy CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.queryType ändern
VARCHAR(8) CHARACTER SET ascii DEFAULT 'and' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE queryType queryType VARCHAR(8) CHARACTER SET ascii DEFAULT 'and' NOT NULL COLLATE `ascii_bin`
Feld tl_module.memberTpl ändern
VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE memberTpl memberTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.redirectBack ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE redirectBack redirectBack CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.autologin ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE autologin autologin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.showHidden ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE showHidden showHidden CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.customTpl ändern
VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE customTpl customTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.navigationTpl ändern
VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE navigationTpl navigationTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.defineRoot ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE defineRoot defineRoot CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.showProtected ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE showProtected showProtected CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.hardLimit ändern
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE hardLimit hardLimit CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.type ändern
VARCHAR(64) CHARACTER SET ascii DEFAULT 'navigation' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE type type VARCHAR(64) CHARACTER SET ascii DEFAULT 'navigation' NOT NULL COLLATE `ascii_bin`
Feld tl_module.headline ändern
VARCHAR(255) DEFAULT 'a:2:{s:5:"value";s:0:"";s:4:"unit";s:2:"h2";}' NOT NULL
ALTER TABLE tl_module CHANGE headline headline VARCHAR(255) DEFAULT 'a:2:{s:5:"value";s:0:"";s:4:"unit";s:2:"h2";}' NOT NULL
Feld tl_module.rsts_visibleAreaAlign löschen
Feld tl_module.rsts_thumbControls löschen
Feld tl_module.rsts_import_settings_from löschen
Feld tl_module.rsts_import_settings löschen
Feld tl_module.dma_eg_data löschen
Feld tl_module.rsmm_template löschen
Feld tl_module.rsts_cssPrefix löschen
Feld tl_module.rsts_customSkin löschen
Feld tl_module.rsts_combineNavItems löschen
Feld tl_module.rsts_rowSlideRatio löschen
Feld tl_module.rsts_rowMinSize löschen
Feld tl_module.rsts_rowMaxCount löschen
Feld tl_module.rsts_slideMaxSize löschen
Feld tl_module.rsts_slideMinSize löschen
Feld tl_module.rsts_visibleAreaMax löschen
Feld tl_module.rsts_visibleArea löschen
Feld tl_module.rsts_prevNextSteps löschen
Feld tl_module.rsts_slideMaxCount löschen
Feld tl_module.rsts_thumbs_rowSlideRatio löschen
Feld tl_module.rsts_thumbs_rowMinSize löschen
Feld tl_module.rsts_thumbs_rowMaxCount löschen
Feld tl_module.rsts_thumbs_slideMaxSize löschen
Feld tl_module.rsts_thumbs_slideMinSize löschen
Feld tl_module.rsts_thumbs_visibleAreaMax löschen
Feld tl_module.rsts_thumbs_visibleArea löschen
Feld tl_module.rsts_thumbs_prevNextSteps löschen
Feld tl_module.rsts_thumbs_slideMaxCount löschen
Feld tl_module.rsts_thumbs_imgSize löschen
Feld tl_module.rsts_thumbs_controls löschen
Feld tl_module.rsts_thumbs_imagePosition löschen
Feld tl_module.rsts_thumbs_scaleMode löschen
Feld tl_module.rsts_thumbs_duration löschen
Feld tl_module.rsts_thumbs_gapSize löschen
Feld tl_module.rsts_thumbs_height löschen
Feld tl_module.rsts_thumbs_width löschen
Feld tl_module.rsts_thumbs löschen
Feld tl_module.rsts_captions löschen
Feld tl_module.rsts_keyboard löschen
Feld tl_module.rsts_deepLinkPrefix löschen
Feld tl_module.rsts_imagePosition löschen
Feld tl_module.rsts_scaleMode löschen
Feld tl_module.rsts_invertControls löschen
Feld tl_module.rsts_controls löschen
Feld tl_module.rsts_navType löschen
Feld tl_module.rsts_pauseAutoplayOnHover löschen
Feld tl_module.rsts_autoplayProgress löschen
Feld tl_module.rsts_autoplayRestart löschen
Feld tl_module.rsts_videoAutoplay löschen
Feld tl_module.rsts_autoplay löschen
Feld tl_module.rsts_duration löschen
Feld tl_module.rsts_gapSize löschen
Feld tl_module.rsts_preloadSlides löschen
Feld tl_module.rsts_height löschen
Feld tl_module.rsts_width löschen
Feld tl_module.rsts_skin löschen
Feld tl_module.rsts_centerContent löschen
Feld tl_module.rsts_loop löschen
Feld tl_module.rsts_random löschen
Feld tl_module.rsts_direction löschen
Feld tl_module.rsts_type löschen
Feld tl_module.rsts_template löschen
Feld tl_module.rsts_id löschen
Feld tl_module.rsts_content_type löschen
Feld tl_module.rsce_data löschen
Feld tl_module.space löschen
Feld tl_module.flashJS löschen
Feld tl_module.flashID löschen
Feld tl_module.interactive löschen
Feld tl_module.source löschen
Feld tl_module.altContent löschen
Feld tl_module.flashvars löschen
Feld tl_module.transparent löschen
Feld tl_module.size löschen
Feld tl_module.tableless löschen
Feld tl_module.cols löschen
Feld tl_module.nl_template hinzufügen
VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD nl_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.nl_unsubscribe hinzufügen
TEXT DEFAULT NULL
ALTER TABLE tl_module ADD nl_unsubscribe TEXT DEFAULT NULL
Feld tl_module.nl_subscribe hinzufügen
TEXT DEFAULT NULL
ALTER TABLE tl_module ADD nl_subscribe TEXT DEFAULT NULL
Feld tl_module.nl_hideChannels hinzufügen
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD nl_hideChannels CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.nl_text hinzufügen
TEXT DEFAULT NULL
ALTER TABLE tl_module ADD nl_text TEXT DEFAULT NULL
Feld tl_module.nl_channels hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_module ADD nl_channels BLOB DEFAULT NULL
Feld tl_module.newsletters hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_module ADD newsletters BLOB DEFAULT NULL
Feld tl_module.cal_featured hinzufügen
VARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD cal_featured VARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin`
Feld tl_module.cal_showQuantity hinzufügen
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD cal_showQuantity CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.cal_ctemplate hinzufügen
VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD cal_ctemplate VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.cal_template hinzufügen
VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD cal_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.cal_limit hinzufügen
SMALLINT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_module ADD cal_limit SMALLINT UNSIGNED DEFAULT 0 NOT NULL
Feld tl_module.cal_readerModule hinzufügen
INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_module ADD cal_readerModule INT UNSIGNED DEFAULT 0 NOT NULL
Feld tl_module.cal_order hinzufügen
VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD cal_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
Feld tl_module.cal_ignoreDynamic hinzufügen
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD cal_ignoreDynamic CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.cal_format hinzufügen
VARCHAR(32) CHARACTER SET ascii DEFAULT 'cal_month' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD cal_format VARCHAR(32) CHARACTER SET ascii DEFAULT 'cal_month' NOT NULL COLLATE `ascii_bin`
Feld tl_module.cal_startDay hinzufügen
SMALLINT UNSIGNED DEFAULT 1 NOT NULL
ALTER TABLE tl_module ADD cal_startDay SMALLINT UNSIGNED DEFAULT 1 NOT NULL
Feld tl_module.cal_hideRunning hinzufügen
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD cal_hideRunning CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.cal_noSpan hinzufügen
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD cal_noSpan CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.cal_calendar hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_module ADD cal_calendar BLOB DEFAULT NULL
Feld tl_module.news_showQuantity hinzufügen
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD news_showQuantity CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.news_order hinzufügen
VARCHAR(32) CHARACTER SET ascii DEFAULT 'order_date_desc' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD news_order VARCHAR(32) CHARACTER SET ascii DEFAULT 'order_date_desc' NOT NULL COLLATE `ascii_bin`
Feld tl_module.news_startDay hinzufügen
SMALLINT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_module ADD news_startDay SMALLINT UNSIGNED DEFAULT 0 NOT NULL
Feld tl_module.news_format hinzufügen
VARCHAR(32) CHARACTER SET ascii DEFAULT 'news_month' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD news_format VARCHAR(32) CHARACTER SET ascii DEFAULT 'news_month' NOT NULL COLLATE `ascii_bin`
Feld tl_module.news_template hinzufügen
VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD news_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.news_metaFields hinzufügen
VARCHAR(255) CHARACTER SET ascii DEFAULT 'a:2:{i:0;s:4:"date";i:1;s:6:"author";}' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD news_metaFields VARCHAR(255) CHARACTER SET ascii DEFAULT 'a:2:{i:0;s:4:"date";i:1;s:6:"author";}' NOT NULL COLLATE `ascii_bin`
Feld tl_module.news_readerModule hinzufügen
INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_module ADD news_readerModule INT UNSIGNED DEFAULT 0 NOT NULL
Feld tl_module.news_jumpToCurrent hinzufügen
VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD news_jumpToCurrent VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.news_featured hinzufügen
VARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD news_featured VARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin`
Feld tl_module.news_archives hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_module ADD news_archives BLOB DEFAULT NULL
Feld tl_module.com_template hinzufügen
VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD com_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.com_disableCaptcha hinzufügen
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD com_disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.com_requireLogin hinzufügen
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD com_requireLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.com_bbcode hinzufügen
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD com_bbcode CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.com_moderate hinzufügen
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD com_moderate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.com_order hinzufügen
VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD com_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
Feld tl_module.faq_readerModule hinzufügen
INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_module ADD faq_readerModule INT UNSIGNED DEFAULT 0 NOT NULL
Feld tl_module.faq_categories hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_module ADD faq_categories BLOB DEFAULT NULL
Feld tl_module.rootPageDependentModules hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_module ADD rootPageDependentModules BLOB DEFAULT NULL
Feld tl_module.data hinzufügen
TEXT DEFAULT NULL
ALTER TABLE tl_module ADD data TEXT DEFAULT NULL
Feld tl_module.reg_deleteDir hinzufügen
CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD reg_deleteDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.overviewPage hinzufügen
INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_module ADD overviewPage INT UNSIGNED DEFAULT 0 NOT NULL
Index "pid_type_start_stop_published" aus tl_page löschen
Feld tl_page.urlSuffix ändern
VARCHAR(16) DEFAULT '' NOT NULL
ALTER TABLE tl_page CHANGE urlSuffix urlSuffix VARCHAR(16) DEFAULT '' NOT NULL
Feld tl_page.urlPrefix ändern
VARCHAR(128) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_page CHANGE urlPrefix urlPrefix VARCHAR(128) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
Feld tl_page.useSSL ändern
CHAR(1) DEFAULT '1' NOT NULL
ALTER TABLE tl_page CHANGE useSSL useSSL CHAR(1) DEFAULT '1' NOT NULL
Feld tl_page.url ändern
VARCHAR(2048) DEFAULT '' NOT NULL
ALTER TABLE tl_page CHANGE url url VARCHAR(2048) DEFAULT '' NOT NULL
Feld tl_page.redirect ändern
VARCHAR(32) DEFAULT 'permanent' NOT NULL
ALTER TABLE tl_page CHANGE redirect redirect VARCHAR(32) DEFAULT 'permanent' NOT NULL
Feld tl_page.description ändern
TEXT DEFAULT NULL
ALTER TABLE tl_page CHANGE description description TEXT DEFAULT NULL
Feld tl_page.language ändern
VARCHAR(64) DEFAULT '' NOT NULL
ALTER TABLE tl_page CHANGE language language VARCHAR(64) DEFAULT '' NOT NULL
Feld tl_page.type ändern
VARCHAR(64) DEFAULT 'regular' NOT NULL
ALTER TABLE tl_page CHANGE type type VARCHAR(64) DEFAULT 'regular' NOT NULL
Feld tl_page.alias ändern
VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_page CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
Feld tl_page.rsmm_id löschen
Feld tl_page.rsmm_enabled löschen
Feld tl_page.rsmm_color löschen
Feld tl_page.mobileLayout löschen
Feld tl_page.sitemapName löschen
Feld tl_page.createSitemap löschen
Feld tl_page.twoFactorJumpTo hinzufügen
INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_page ADD twoFactorJumpTo INT UNSIGNED DEFAULT 0 NOT NULL
Feld tl_page.enforceTwoFactor hinzufügen
CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page ADD enforceTwoFactor CHAR(1) DEFAULT '' NOT NULL
Feld tl_page.clientCache hinzufügen
INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_page ADD clientCache INT UNSIGNED DEFAULT 0 NOT NULL
Feld tl_page.alwaysLoadFromCache hinzufügen
CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page ADD alwaysLoadFromCache CHAR(1) DEFAULT '' NOT NULL
Feld tl_page.subpageLayout hinzufügen
INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_page ADD subpageLayout INT UNSIGNED DEFAULT 0 NOT NULL
Feld tl_page.validAliasCharacters hinzufügen
VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_page ADD validAliasCharacters VARCHAR(255) DEFAULT '' NOT NULL
Feld tl_page.canonicalKeepParams hinzufügen
VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_page ADD canonicalKeepParams VARCHAR(255) DEFAULT '' NOT NULL
Feld tl_page.canonicalLink hinzufügen
VARCHAR(2048) DEFAULT '' NOT NULL
ALTER TABLE tl_page ADD canonicalLink VARCHAR(2048) DEFAULT '' NOT NULL
Feld tl_page.enableCanonical hinzufügen
CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page ADD enableCanonical CHAR(1) DEFAULT '' NOT NULL
Feld tl_page.maintenanceMode hinzufügen
CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page ADD maintenanceMode CHAR(1) DEFAULT '' NOT NULL
Feld tl_page.robotsTxt hinzufügen
TEXT DEFAULT NULL
ALTER TABLE tl_page ADD robotsTxt TEXT DEFAULT NULL
Feld tl_page.disableLanguageRedirect hinzufügen
CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page ADD disableLanguageRedirect CHAR(1) DEFAULT '' NOT NULL
Feld tl_page.redirectBack hinzufügen
CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page ADD redirectBack CHAR(1) DEFAULT '' NOT NULL
Feld tl_page.routePriority hinzufügen
INT DEFAULT 0 NOT NULL
ALTER TABLE tl_page ADD routePriority INT DEFAULT 0 NOT NULL
Feld tl_page.requireItem hinzufügen
CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page ADD requireItem CHAR(1) DEFAULT '' NOT NULL
Index "type_dns" zu tl_page hinzufügen
type, dns
CREATE INDEX type_dns ON tl_page (type, dns)
Index "pid_published_type_start_stop" zu tl_page hinzufügen
pid, published, type, start, stop
CREATE INDEX pid_published_type_start_stop ON tl_page (pid, published, type, start, stop)
Feld tl_page.rsmm_image löschen
Feld tl_page.favicon hinzufügen
BINARY(16) DEFAULT NULL
ALTER TABLE tl_page ADD favicon BINARY(16) DEFAULT NULL
Feld tl_page.rsmm_subtitle löschen
Feld tl_page.mailerTransport hinzufügen
VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_page ADD mailerTransport VARCHAR(255) DEFAULT '' NOT NULL
Feld tl_style.own ändern
TEXT DEFAULT NULL
ALTER TABLE tl_style CHANGE own own TEXT DEFAULT NULL
Feld tl_style_sheet.vars ändern
TEXT DEFAULT NULL
ALTER TABLE tl_style_sheet CHANGE vars vars TEXT DEFAULT NULL
Feld tl_style_sheet.mediaQuery ändern
TEXT DEFAULT NULL
ALTER TABLE tl_style_sheet CHANGE mediaQuery mediaQuery TEXT DEFAULT NULL
Feld tl_style_sheet.media ändern
VARCHAR(255) DEFAULT 'a:1:{i:0;s:3:"all";}' NOT NULL
ALTER TABLE tl_style_sheet CHANGE media media VARCHAR(255) DEFAULT 'a:1:{i:0;s:3:"all";}' NOT NULL
Feld tl_style_sheet.disablePie löschen
Feld tl_theme.vars ändern
TEXT DEFAULT NULL
ALTER TABLE tl_theme CHANGE vars vars TEXT DEFAULT NULL
Feld tl_undo.query ändern
TEXT DEFAULT NULL
ALTER TABLE tl_undo CHANGE query query TEXT DEFAULT NULL
Feld tl_undo.preview hinzufügen
MEDIUMBLOB DEFAULT NULL
ALTER TABLE tl_undo ADD preview MEDIUMBLOB DEFAULT NULL
Feld tl_user.inherit ändern
VARCHAR(12) DEFAULT 'group' NOT NULL
ALTER TABLE tl_user CHANGE inherit inherit VARCHAR(12) DEFAULT 'group' NOT NULL
Feld tl_user.password ändern
VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_user CHANGE password password VARCHAR(255) DEFAULT '' NOT NULL
Feld tl_user.useCE ändern
CHAR(1) DEFAULT '1' NOT NULL
ALTER TABLE tl_user CHANGE useCE useCE CHAR(1) DEFAULT '1' NOT NULL
Feld tl_user.useRTE ändern
CHAR(1) DEFAULT '1' NOT NULL
ALTER TABLE tl_user CHANGE useRTE useRTE CHAR(1) DEFAULT '1' NOT NULL
Feld tl_user.thumbnails ändern
CHAR(1) DEFAULT '1' NOT NULL
ALTER TABLE tl_user CHANGE thumbnails thumbnails CHAR(1) DEFAULT '1' NOT NULL
Feld tl_user.showHelp ändern
CHAR(1) DEFAULT '1' NOT NULL
ALTER TABLE tl_user CHANGE showHelp showHelp CHAR(1) DEFAULT '1' NOT NULL
Feld tl_user.language ändern
VARCHAR(64) DEFAULT '' NOT NULL
ALTER TABLE tl_user CHANGE language language VARCHAR(64) DEFAULT '' NOT NULL
Feld tl_user.username ändern
VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_user CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
Feld tl_user.loginCount löschen
Feld tl_user.newsletterp hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user ADD newsletterp BLOB DEFAULT NULL
Feld tl_user.newsletters hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user ADD newsletters BLOB DEFAULT NULL
Feld tl_user.calendarfeedp hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user ADD calendarfeedp BLOB DEFAULT NULL
Feld tl_user.calendarfeeds hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user ADD calendarfeeds BLOB DEFAULT NULL
Feld tl_user.calendarp hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user ADD calendarp BLOB DEFAULT NULL
Feld tl_user.calendars hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user ADD calendars BLOB DEFAULT NULL
Feld tl_user.newsfeedp hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user ADD newsfeedp BLOB DEFAULT NULL
Feld tl_user.newsfeeds hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user ADD newsfeeds BLOB DEFAULT NULL
Feld tl_user.newp hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user ADD newp BLOB DEFAULT NULL
Feld tl_user.news hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user ADD news BLOB DEFAULT NULL
Feld tl_user.faqp hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user ADD faqp BLOB DEFAULT NULL
Feld tl_user.faqs hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user ADD faqs BLOB DEFAULT NULL
Feld tl_user.trustedTokenVersion hinzufügen
INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_user ADD trustedTokenVersion INT UNSIGNED DEFAULT 0 NOT NULL
Feld tl_user.backupCodes hinzufügen
TEXT DEFAULT NULL
ALTER TABLE tl_user ADD backupCodes TEXT DEFAULT NULL
Feld tl_user.loginAttempts hinzufügen
SMALLINT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_user ADD loginAttempts SMALLINT UNSIGNED DEFAULT 0 NOT NULL
Feld tl_user.useTwoFactor hinzufügen
CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_user ADD useTwoFactor CHAR(1) DEFAULT '' NOT NULL
Feld tl_user.secret hinzufügen
BINARY(128) DEFAULT NULL
ALTER TABLE tl_user ADD secret BINARY(128) DEFAULT NULL
Feld tl_user.amg hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user ADD amg BLOB DEFAULT NULL
Feld tl_user.fields hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user ADD fields BLOB DEFAULT NULL
Feld tl_user.elements hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user ADD elements BLOB DEFAULT NULL
Feld tl_user.fullscreen hinzufügen
CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_user ADD fullscreen CHAR(1) DEFAULT '' NOT NULL
Feld tl_user_group.newsletterp hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD newsletterp BLOB DEFAULT NULL
Feld tl_user_group.newsletters hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD newsletters BLOB DEFAULT NULL
Feld tl_user_group.calendarfeedp hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD calendarfeedp BLOB DEFAULT NULL
Feld tl_user_group.calendarfeeds hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD calendarfeeds BLOB DEFAULT NULL
Feld tl_user_group.calendarp hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD calendarp BLOB DEFAULT NULL
Feld tl_user_group.calendars hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD calendars BLOB DEFAULT NULL
Feld tl_user_group.newsfeedp hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD newsfeedp BLOB DEFAULT NULL
Feld tl_user_group.newsfeeds hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD newsfeeds BLOB DEFAULT NULL
Feld tl_user_group.newp hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD newp BLOB DEFAULT NULL
Feld tl_user_group.news hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD news BLOB DEFAULT NULL
Feld tl_user_group.faqp hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD faqp BLOB DEFAULT NULL
Feld tl_user_group.faqs hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD faqs BLOB DEFAULT NULL
Feld tl_user_group.amg hinzufügen
BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD amg BLOB DEFAULT NULL
Index "pid" aus tl_version löschen
Index "fromTable" aus tl_version löschen
Feld tl_version.editUrl ändern
TEXT DEFAULT NULL
ALTER TABLE tl_version CHANGE editUrl editUrl TEXT DEFAULT NULL
CREATE UNIQUE INDEX pid_fromtable_version ON tl_version (pid, fromtable, version)
CREATE UNIQUE INDEX pid_fromtable_version ON tl_version (pid, fromtable, version)
Index "userid" zu tl_version hinzufügen
userid
CREATE INDEX userid ON tl_version (userid)
Also jeder Eintrag ist halt mit einem roten x versehen.
Lesezeichen