Tabellen ändern |
|
Alle auswählen |
|
ALTER TABLE tl_files ENGINE = InnoDB |
|
DROP INDEX alias ON tl_form |
|
ALTER TABLE tl_form ENGINE = InnoDB |
|
ALTER TABLE tl_form_field ENGINE = InnoDB |
|
ALTER TABLE tl_image_size ENGINE = InnoDB |
|
ALTER TABLE tl_image_size_item ENGINE = InnoDB |
|
ALTER TABLE tl_layout ENGINE = InnoDB |
|
ALTER TABLE tl_lead ENGINE = InnoDB |
|
ALTER TABLE tl_lead_data ENGINE = InnoDB |
|
ALTER TABLE tl_lead_export ENGINE = InnoDB |
|
ALTER TABLE tl_log ENGINE = InnoDB |
|
DROP INDEX email ON tl_member |
|
ALTER TABLE tl_member ENGINE = InnoDB |
|
ALTER TABLE tl_member_group ENGINE = InnoDB |
|
ALTER TABLE tl_module ENGINE = InnoDB |
|
ALTER TABLE tl_nc_gateway ENGINE = InnoDB |
|
ALTER TABLE tl_nc_language ENGINE = InnoDB |
|
ALTER TABLE tl_nc_message ENGINE = InnoDB |
|
ALTER TABLE tl_nc_notification ENGINE = InnoDB |
|
ALTER TABLE tl_nc_queue ENGINE = InnoDB |
|
ALTER TABLE tl_om_backend_element_classes ENGINE = InnoDB |
|
ALTER TABLE tl_om_backend_links_main ENGINE = InnoDB |
|
ALTER TABLE tl_om_backend_links_top ENGINE = InnoDB |
|
ALTER TABLE tl_om_backend_sysinfo ENGINE = InnoDB |
|
ALTER TABLE tl_opt_in ENGINE = InnoDB |
|
ALTER TABLE tl_opt_in_related ENGINE = InnoDB |
|
DROP INDEX type_dns ON tl_page |
|
DROP INDEX alias ON tl_page |
|
ALTER TABLE tl_page ENGINE = InnoDB |
|
ALTER TABLE tl_preview_link ENGINE = InnoDB |
|
ALTER TABLE tl_search ENGINE = InnoDB |
|
ALTER TABLE tl_search_index ENGINE = InnoDB |
|
ALTER TABLE tl_search_term ENGINE = InnoDB |
|
ALTER TABLE tl_style ENGINE = InnoDB |
|
ALTER TABLE tl_style_sheet ENGINE = InnoDB |
|
ALTER TABLE tl_theme ENGINE = InnoDB |
|
ALTER TABLE tl_undo ENGINE = InnoDB |
|
DROP INDEX email ON tl_user |
|
ALTER TABLE tl_user ENGINE = InnoDB |
|
ALTER TABLE tl_user_group ENGINE = InnoDB |
|
DROP INDEX pid_fromtable_version ON tl_version |
|
ALTER TABLE tl_version ENGINE = InnoDB |
Spalten ändern |
|
Alle auswählen |
|
ALTER TABLE tl_article CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8_bin` |
|
ALTER TABLE tl_calendar_events CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8_bin` |
|
ALTER TABLE tl_calendar_feed CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8_bin` |
|
ALTER TABLE tl_content CHANGE showPreview showPreview CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_content CHANGE markdownSource markdownSource VARCHAR(12) CHARACTER SET ascii DEFAULT 'sourceText' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_content CHANGE splashImage splashImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_content CHANGE inline inline CHAR(1) 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` |
|
ALTER TABLE tl_content CHANGE start start VARCHAR(10) 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` |
|
ALTER TABLE tl_content CHANGE guests guests 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` |
|
ALTER TABLE tl_content CHANGE sliderContinuous sliderContinuous CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_content CHANGE playerColor playerColor VARCHAR(6) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_content CHANGE playerPreload playerPreload VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_content CHANGE playerAspect playerAspect VARCHAR(8) 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` |
|
ALTER TABLE tl_content CHANGE vimeo vimeo VARCHAR(64) 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` |
|
ALTER TABLE tl_content CHANGE customTpl customTpl 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` |
|
ALTER TABLE tl_content CHANGE metaIgnore metaIgnore CHAR(1) 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` |
|
ALTER TABLE tl_content CHANGE useHomeDir useHomeDir 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` |
|
ALTER TABLE tl_content CHANGE overwriteLink overwriteLink 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` |
|
ALTER TABLE tl_content CHANGE highlight highlight VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_content CHANGE sortOrder sortOrder VARCHAR(32) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_content CHANGE sortable sortable 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` |
|
ALTER TABLE tl_content CHANGE tfoot tfoot 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` |
|
ALTER TABLE tl_content CHANGE listtype listtype VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_content CHANGE floating floating VARCHAR(32) CHARACTER SET ascii DEFAULT 'above' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_content CHANGE fullsize fullsize CHAR(1) 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` |
|
ALTER TABLE tl_content CHANGE size size VARCHAR(128) 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` |
|
ALTER TABLE tl_content CHANGE addImage addImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_content CHANGE type type VARCHAR(64) CHARACTER SET ascii DEFAULT 'text' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_content CHANGE ptable ptable VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` |
|
DROP INDEX path ON tl_files |
|
ALTER TABLE tl_files CHANGE name name VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8_bin` |
|
ALTER TABLE tl_files CHANGE extension extension VARCHAR(16) DEFAULT '' NOT NULL COLLATE `utf8_bin` |
|
ALTER TABLE tl_files CHANGE path path VARCHAR(1022) DEFAULT '' NOT NULL COLLATE `utf8_bin` |
|
ALTER TABLE tl_form CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8_bin` |
|
ALTER TABLE tl_member CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8_bin` |
|
ALTER TABLE tl_module CHANGE cal_noSpan cal_noSpan CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_module CHANGE cal_hideRunning cal_hideRunning CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_module CHANGE cal_format cal_format VARCHAR(32) CHARACTER SET ascii DEFAULT 'cal_month' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_module CHANGE cal_ignoreDynamic cal_ignoreDynamic CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_module CHANGE cal_order cal_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_module CHANGE cal_template cal_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_module CHANGE cal_ctemplate cal_ctemplate VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_module CHANGE cal_showQuantity cal_showQuantity CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_module CHANGE cal_featured cal_featured VARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_module CHANGE reg_deleteDir reg_deleteDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_module CHANGE leadOptInSuccessType leadOptInSuccessType VARCHAR(8) DEFAULT 'message' NOT NULL COLLATE `utf8_bin` |
|
ALTER TABLE tl_module CHANGE leadOptInUserInteractionSubmit leadOptInUserInteractionSubmit VARCHAR(128) DEFAULT '' NOT NULL COLLATE `utf8_bin` |
|
ALTER TABLE tl_module CHANGE list_info_layout list_info_layout 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` |
|
ALTER TABLE tl_module CHANGE list_table list_table VARCHAR(64) 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` |
|
ALTER TABLE tl_module CHANGE protected protected 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` |
|
ALTER TABLE tl_module CHANGE reg_assignDir reg_assignDir CHAR(1) 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` |
|
ALTER TABLE tl_module CHANGE reg_skipName reg_skipName 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` |
|
ALTER TABLE tl_module CHANGE disableCaptcha disableCaptcha CHAR(1) 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` |
|
ALTER TABLE tl_module CHANGE fullsize fullsize 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` |
|
ALTER TABLE tl_module CHANGE imgSize imgSize VARCHAR(128) 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` |
|
ALTER TABLE tl_module CHANGE inColumn inColumn VARCHAR(32) CHARACTER SET ascii DEFAULT 'main' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_module CHANGE searchTpl searchTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_module CHANGE searchType searchType VARCHAR(16) CHARACTER SET ascii DEFAULT 'simple' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_module CHANGE contextLength contextLength VARCHAR(64) 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` |
|
ALTER TABLE tl_module CHANGE queryType queryType VARCHAR(8) CHARACTER SET ascii DEFAULT 'and' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_module CHANGE memberTpl memberTpl VARCHAR(64) 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` |
|
ALTER TABLE tl_module CHANGE autologin autologin 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` |
|
ALTER TABLE tl_module CHANGE customTpl customTpl 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` |
|
ALTER TABLE tl_module CHANGE defineRoot defineRoot 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` |
|
ALTER TABLE tl_module CHANGE hardLimit hardLimit CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_module CHANGE type type VARCHAR(64) CHARACTER SET ascii DEFAULT 'navigation' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_page CHANGE urlPrefix urlPrefix VARCHAR(128) DEFAULT '' NOT NULL COLLATE `utf8_bin` |
|
ALTER TABLE tl_page CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8_bin` |
|
ALTER TABLE tl_search CHANGE url url VARCHAR(767) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` |
|
ALTER TABLE tl_search_term CHANGE term term VARCHAR(64) NOT NULL COLLATE `utf8_bin` |
|
ALTER TABLE tl_user CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8_bin` |
Spalten anlegen |
|
Alle auswählen |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
ALTER TABLE tl_cookie ADD sourceVersioning CHAR(1) DEFAULT '' NOT NULL |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
ALTER TABLE tl_cookiebar ADD hideOnInit CHAR(1) DEFAULT '' NOT NULL |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
|
CREATE |
Spalten löschen |
|
Alle auswählen |
|
ALTER TABLE tl_preview_link DROP expiresInDays |