|
Compares the database table and field definitions of the current database with the specifications from all loaded extensions' ext_tables.sql files. Depending on the specification, the analyzer can update, delete, and change tables and fields.
|
|
Remove unused fields (rename with prefix)
|
|
|
|
select/deselect all
|
|
DROP INDEX t3ver_oid_f068716b
|
|
DROP INDEX translation_source_c9bb4567
|
|
DROP INDEX parent_90041b40
|
|
DROP INDEX slug_d357d1e2
|
|
DROP INDEX language_identifier_8c77f4c2
|
|
DROP INDEX determineSiteRoot_5c54427f
|
|
CREATE TEMPORARY TABLE __temp__pages AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, sorting, rowDescription, editlock, sys_language_uid, l10n_parent, l10n_source, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, perms_userid, perms_groupid, perms_user, perms_group, perms_everybody, title, slug, doktype, TSconfig, is_siteroot, php_tree_stop, url, shortcut, shortcut_mode, subtitle, layout, target, media, lastUpdated, keywords, cache_timeout, cache_tags, newUntil, description, no_search, SYS_LASTCHANGED, abstract, module, extendToSubpages, author, author_email, nav_title, nav_hide, content_from_pid, mount_pid, mount_pid_ol, alias, l18n_cfg, fe_login_mode, backend_layout, backend_layout_next_level, tsconfig_includes, legacy_overlay_uid, categories, seo_title, no_index, no_follow, og_title, og_description, og_image, twitter_title, twitter_description, twitter_image, canonical_link, sitemap_priority, sitemap_changefreq, twitter_card, zzz_deleted_t3ver_id FROM "pages"
|
|
DROP TABLE "pages"
|
|
CREATE TABLE "pages" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, fe_group VARCHAR(255) DEFAULT '0' NOT NULL COLLATE BINARY, sorting INTEGER DEFAULT 0 NOT NULL, rowDescription CLOB DEFAULT NULL COLLATE BINARY, editlock SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_source INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, perms_userid INTEGER UNSIGNED DEFAULT 0 NOT NULL, perms_groupid INTEGER UNSIGNED DEFAULT 0 NOT NULL, perms_user SMALLINT UNSIGNED DEFAULT 0 NOT NULL, perms_group SMALLINT UNSIGNED DEFAULT 0 NOT NULL, perms_everybody SMALLINT UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, slug VARCHAR(2048) DEFAULT NULL COLLATE BINARY, doktype INTEGER UNSIGNED DEFAULT 0 NOT NULL, TSconfig CLOB DEFAULT NULL COLLATE BINARY, is_siteroot SMALLINT DEFAULT 0 NOT NULL, php_tree_stop SMALLINT DEFAULT 0 NOT NULL, url VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, shortcut INTEGER UNSIGNED DEFAULT 0 NOT NULL, shortcut_mode INTEGER UNSIGNED DEFAULT 0 NOT NULL, subtitle VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, layout INTEGER UNSIGNED DEFAULT 0 NOT NULL, target VARCHAR(80) DEFAULT '' NOT NULL COLLATE BINARY, media INTEGER UNSIGNED DEFAULT 0 NOT NULL, lastUpdated INTEGER UNSIGNED DEFAULT 0 NOT NULL, keywords CLOB DEFAULT NULL COLLATE BINARY, cache_timeout INTEGER UNSIGNED DEFAULT 0 NOT NULL, cache_tags VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, newUntil INTEGER UNSIGNED DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, no_search SMALLINT UNSIGNED DEFAULT 0 NOT NULL, SYS_LASTCHANGED INTEGER UNSIGNED DEFAULT 0 NOT NULL, abstract CLOB DEFAULT NULL COLLATE BINARY, module VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, extendToSubpages SMALLINT UNSIGNED DEFAULT 0 NOT NULL, author VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, author_email VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, nav_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, nav_hide SMALLINT DEFAULT 0 NOT NULL, content_from_pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, mount_pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, mount_pid_ol SMALLINT DEFAULT 0 NOT NULL, alias VARCHAR(32) DEFAULT '' NOT NULL COLLATE BINARY, l18n_cfg SMALLINT DEFAULT 0 NOT NULL, fe_login_mode SMALLINT DEFAULT 0 NOT NULL, backend_layout VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, backend_layout_next_level VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, tsconfig_includes CLOB DEFAULT NULL COLLATE BINARY, legacy_overlay_uid INTEGER UNSIGNED DEFAULT 0 NOT NULL, categories INTEGER DEFAULT 0 NOT NULL, seo_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, no_index SMALLINT DEFAULT 0 NOT NULL, no_follow SMALLINT DEFAULT 0 NOT NULL, og_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, og_description CLOB DEFAULT NULL COLLATE BINARY, og_image INTEGER UNSIGNED DEFAULT 0 NOT NULL, twitter_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, twitter_description CLOB DEFAULT NULL COLLATE BINARY, twitter_image INTEGER UNSIGNED DEFAULT 0 NOT NULL, canonical_link VARCHAR(2048) DEFAULT '' NOT NULL COLLATE BINARY, sitemap_priority NUMERIC(1, 1) DEFAULT '0.5' NOT NULL, sitemap_changefreq VARCHAR(10) DEFAULT '' NOT NULL COLLATE BINARY, twitter_card VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, "zzz_deleted_t3ver_id" INTEGER UNSIGNED DEFAULT 0 NOT NULL)
|
|
INSERT INTO "pages" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, sorting, rowDescription, editlock, sys_language_uid, l10n_parent, l10n_source, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, perms_userid, perms_groupid, perms_user, perms_group, perms_everybody, title, slug, doktype, TSconfig, is_siteroot, php_tree_stop, url, shortcut, shortcut_mode, subtitle, layout, target, media, lastUpdated, keywords, cache_timeout, cache_tags, newUntil, description, no_search, SYS_LASTCHANGED, abstract, module, extendToSubpages, author, author_email, nav_title, nav_hide, content_from_pid, mount_pid, mount_pid_ol, alias, l18n_cfg, fe_login_mode, backend_layout, backend_layout_next_level, tsconfig_includes, legacy_overlay_uid, categories, seo_title, no_index, no_follow, og_title, og_description, og_image, twitter_title, twitter_description, twitter_image, canonical_link, sitemap_priority, sitemap_changefreq, twitter_card, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, sorting, rowDescription, editlock, sys_language_uid, l10n_parent, l10n_source, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, perms_userid, perms_groupid, perms_user, perms_group, perms_everybody, title, slug, doktype, TSconfig, is_siteroot, php_tree_stop, url, shortcut, shortcut_mode, subtitle, layout, target, media, lastUpdated, keywords, cache_timeout, cache_tags, newUntil, description, no_search, SYS_LASTCHANGED, abstract, module, extendToSubpages, author, author_email, nav_title, nav_hide, content_from_pid, mount_pid, mount_pid_ol, alias, l18n_cfg, fe_login_mode, backend_layout, backend_layout_next_level, tsconfig_includes, legacy_overlay_uid, categories, seo_title, no_index, no_follow, og_title, og_description, og_image, twitter_title, twitter_description, twitter_image, canonical_link, sitemap_priority, sitemap_changefreq, twitter_card, zzz_deleted_t3ver_id FROM __temp__pages
|
|
DROP TABLE __temp__pages
|
|
CREATE INDEX t3ver_oid_f068716b ON "pages" (t3ver_oid, t3ver_wsid)
|
|
CREATE INDEX translation_source_c9bb4567 ON "pages" (l10n_source)
|
|
CREATE INDEX parent_90041b40 ON "pages" (pid, deleted, hidden)
|
|
CREATE INDEX slug_d357d1e2 ON "pages" (slug)
|
|
CREATE INDEX language_identifier_8c77f4c2 ON "pages" (l10n_parent, sys_language_uid)
|
|
CREATE INDEX determineSiteRoot_5c54427f ON "pages" (is_siteroot)
|
|
CREATE TABLE "pages" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, fe_group VARCHAR(255) DEFAULT '0' NOT NULL COLLATE BINARY, sorting INTEGER DEFAULT 0 NOT NULL, rowDescription CLOB DEFAULT NULL COLLATE BINARY, editlock SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_source INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, perms_userid INTEGER UNSIGNED DEFAULT 0 NOT NULL, perms_groupid INTEGER UNSIGNED DEFAULT 0 NOT NULL, perms_user SMALLINT UNSIGNED DEFAULT 0 NOT NULL, perms_group SMALLINT UNSIGNED DEFAULT 0 NOT NULL, perms_everybody SMALLINT UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, slug VARCHAR(2048) DEFAULT NULL COLLATE BINARY, doktype INTEGER UNSIGNED DEFAULT 0 NOT NULL, TSconfig CLOB DEFAULT NULL COLLATE BINARY, is_siteroot SMALLINT DEFAULT 0 NOT NULL, php_tree_stop SMALLINT DEFAULT 0 NOT NULL, url VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, shortcut INTEGER UNSIGNED DEFAULT 0 NOT NULL, shortcut_mode INTEGER UNSIGNED DEFAULT 0 NOT NULL, subtitle VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, layout INTEGER UNSIGNED DEFAULT 0 NOT NULL, target VARCHAR(80) DEFAULT '' NOT NULL COLLATE BINARY, media INTEGER UNSIGNED DEFAULT 0 NOT NULL, lastUpdated INTEGER UNSIGNED DEFAULT 0 NOT NULL, keywords CLOB DEFAULT NULL COLLATE BINARY, cache_timeout INTEGER UNSIGNED DEFAULT 0 NOT NULL, cache_tags VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, newUntil INTEGER UNSIGNED DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, no_search SMALLINT UNSIGNED DEFAULT 0 NOT NULL, SYS_LASTCHANGED INTEGER UNSIGNED DEFAULT 0 NOT NULL, abstract CLOB DEFAULT NULL COLLATE BINARY, module VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, extendToSubpages SMALLINT UNSIGNED DEFAULT 0 NOT NULL, author VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, author_email VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, nav_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, nav_hide SMALLINT DEFAULT 0 NOT NULL, content_from_pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, mount_pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, mount_pid_ol SMALLINT DEFAULT 0 NOT NULL, alias VARCHAR(32) DEFAULT '' NOT NULL COLLATE BINARY, l18n_cfg SMALLINT DEFAULT 0 NOT NULL, fe_login_mode SMALLINT DEFAULT 0 NOT NULL, backend_layout VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, backend_layout_next_level VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, tsconfig_includes CLOB DEFAULT NULL COLLATE BINARY, legacy_overlay_uid INTEGER UNSIGNED DEFAULT 0 NOT NULL, categories INTEGER DEFAULT 0 NOT NULL, seo_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, no_index SMALLINT DEFAULT 0 NOT NULL, no_follow SMALLINT DEFAULT 0 NOT NULL, og_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, og_description CLOB DEFAULT NULL COLLATE BINARY, og_image INTEGER UNSIGNED DEFAULT 0 NOT NULL, twitter_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, twitter_description CLOB DEFAULT NULL COLLATE BINARY, twitter_image INTEGER UNSIGNED DEFAULT 0 NOT NULL, canonical_link VARCHAR(2048) DEFAULT '' NOT NULL COLLATE BINARY, sitemap_priority NUMERIC(1, 1) DEFAULT '0.5' NOT NULL, sitemap_changefreq VARCHAR(10) DEFAULT '' NOT NULL COLLATE BINARY, twitter_card VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_label" VARCHAR(255) DEFAULT '' NOT NULL)
|
|
CREATE TABLE "pages" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, fe_group VARCHAR(255) DEFAULT '0' NOT NULL COLLATE BINARY, sorting INTEGER DEFAULT 0 NOT NULL, rowDescription CLOB DEFAULT NULL COLLATE BINARY, editlock SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_source INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, perms_userid INTEGER UNSIGNED DEFAULT 0 NOT NULL, perms_groupid INTEGER UNSIGNED DEFAULT 0 NOT NULL, perms_user SMALLINT UNSIGNED DEFAULT 0 NOT NULL, perms_group SMALLINT UNSIGNED DEFAULT 0 NOT NULL, perms_everybody SMALLINT UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, slug VARCHAR(2048) DEFAULT NULL COLLATE BINARY, doktype INTEGER UNSIGNED DEFAULT 0 NOT NULL, TSconfig CLOB DEFAULT NULL COLLATE BINARY, is_siteroot SMALLINT DEFAULT 0 NOT NULL, php_tree_stop SMALLINT DEFAULT 0 NOT NULL, url VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, shortcut INTEGER UNSIGNED DEFAULT 0 NOT NULL, shortcut_mode INTEGER UNSIGNED DEFAULT 0 NOT NULL, subtitle VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, layout INTEGER UNSIGNED DEFAULT 0 NOT NULL, target VARCHAR(80) DEFAULT '' NOT NULL COLLATE BINARY, media INTEGER UNSIGNED DEFAULT 0 NOT NULL, lastUpdated INTEGER UNSIGNED DEFAULT 0 NOT NULL, keywords CLOB DEFAULT NULL COLLATE BINARY, cache_timeout INTEGER UNSIGNED DEFAULT 0 NOT NULL, cache_tags VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, newUntil INTEGER UNSIGNED DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, no_search SMALLINT UNSIGNED DEFAULT 0 NOT NULL, SYS_LASTCHANGED INTEGER UNSIGNED DEFAULT 0 NOT NULL, abstract CLOB DEFAULT NULL COLLATE BINARY, module VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, extendToSubpages SMALLINT UNSIGNED DEFAULT 0 NOT NULL, author VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, author_email VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, nav_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, nav_hide SMALLINT DEFAULT 0 NOT NULL, content_from_pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, mount_pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, mount_pid_ol SMALLINT DEFAULT 0 NOT NULL, alias VARCHAR(32) DEFAULT '' NOT NULL COLLATE BINARY, l18n_cfg SMALLINT DEFAULT 0 NOT NULL, fe_login_mode SMALLINT DEFAULT 0 NOT NULL, backend_layout VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, backend_layout_next_level VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, tsconfig_includes CLOB DEFAULT NULL COLLATE BINARY, legacy_overlay_uid INTEGER UNSIGNED DEFAULT 0 NOT NULL, categories INTEGER DEFAULT 0 NOT NULL, seo_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, no_index SMALLINT DEFAULT 0 NOT NULL, no_follow SMALLINT DEFAULT 0 NOT NULL, og_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, og_description CLOB DEFAULT NULL COLLATE BINARY, og_image INTEGER UNSIGNED DEFAULT 0 NOT NULL, twitter_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, twitter_description CLOB DEFAULT NULL COLLATE BINARY, twitter_image INTEGER UNSIGNED DEFAULT 0 NOT NULL, canonical_link VARCHAR(2048) DEFAULT '' NOT NULL COLLATE BINARY, sitemap_priority NUMERIC(1, 1) DEFAULT '0.5' NOT NULL, sitemap_changefreq VARCHAR(10) DEFAULT '' NOT NULL COLLATE BINARY, twitter_card VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_alias" VARCHAR(32) DEFAULT '' NOT NULL)
|
|
DROP INDEX t3ver_oid_2afb6cbb
|
|
DROP INDEX parent_8d466b11
|
|
DROP INDEX fal_filelist_3fe1fc5b
|
|
DROP INDEX file_a8a43bc7
|
|
CREATE TEMPORARY TABLE __temp__sys_file_metadata AS SELECT uid, pid, tstamp, crdate, cruser_id, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, file, title, width, height, description, alternative, categories, zzz_deleted_t3ver_id FROM "sys_file_metadata"
|
|
DROP TABLE "sys_file_metadata"
|
|
CREATE TABLE "sys_file_metadata" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, file INTEGER DEFAULT 0 NOT NULL, title CLOB DEFAULT NULL COLLATE BINARY, width INTEGER DEFAULT 0 NOT NULL, height INTEGER DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, alternative CLOB DEFAULT NULL COLLATE BINARY, categories INTEGER DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_id" INTEGER UNSIGNED DEFAULT 0 NOT NULL)
|
|
INSERT INTO "sys_file_metadata" (uid, pid, tstamp, crdate, cruser_id, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, file, title, width, height, description, alternative, categories, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, file, title, width, height, description, alternative, categories, zzz_deleted_t3ver_id FROM __temp__sys_file_metadata
|
|
DROP TABLE __temp__sys_file_metadata
|
|
CREATE INDEX t3ver_oid_2afb6cbb ON "sys_file_metadata" (t3ver_oid, t3ver_wsid)
|
|
CREATE INDEX parent_8d466b11 ON "sys_file_metadata" (pid)
|
|
CREATE INDEX fal_filelist_3fe1fc5b ON "sys_file_metadata" (l10n_parent, sys_language_uid)
|
|
CREATE INDEX file_a8a43bc7 ON "sys_file_metadata" (file)
|
|
CREATE TABLE "sys_file_metadata" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, file INTEGER DEFAULT 0 NOT NULL, title CLOB DEFAULT NULL COLLATE BINARY, width INTEGER DEFAULT 0 NOT NULL, height INTEGER DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, alternative CLOB DEFAULT NULL COLLATE BINARY, categories INTEGER DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_label" VARCHAR(255) DEFAULT '' NOT NULL)
|
|
DROP INDEX t3ver_oid_08d845fb
|
|
DROP INDEX parent_3efdb54b
|
|
DROP INDEX combined_1_b25ed807
|
|
DROP INDEX uid_foreign_84870ada
|
|
DROP INDEX uid_local_6e063d86
|
|
DROP INDEX deleted_ec55f9ff
|
|
DROP INDEX tablenames_fieldname_2fe50272
|
|
CREATE TEMPORARY TABLE __temp__sys_file_reference AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, sys_language_uid, l10n_parent, l10n_state, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, uid_local, uid_foreign, tablenames, fieldname, sorting_foreign, table_local, title, description, alternative, link, crop, autoplay, zzz_deleted_t3ver_id FROM "sys_file_reference"
|
|
DROP TABLE "sys_file_reference"
|
|
CREATE TABLE "sys_file_reference" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, uid_local INTEGER DEFAULT 0 NOT NULL, uid_foreign INTEGER DEFAULT 0 NOT NULL, tablenames VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, fieldname VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, sorting_foreign INTEGER DEFAULT 0 NOT NULL, table_local VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, title CLOB DEFAULT NULL COLLATE BINARY, description CLOB DEFAULT NULL COLLATE BINARY, alternative CLOB DEFAULT NULL COLLATE BINARY, link VARCHAR(1024) DEFAULT '' NOT NULL COLLATE BINARY, crop VARCHAR(4000) DEFAULT '' NOT NULL COLLATE BINARY, autoplay SMALLINT DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_id" INTEGER UNSIGNED DEFAULT 0 NOT NULL)
|
|
INSERT INTO "sys_file_reference" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, sys_language_uid, l10n_parent, l10n_state, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, uid_local, uid_foreign, tablenames, fieldname, sorting_foreign, table_local, title, description, alternative, link, crop, autoplay, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, sys_language_uid, l10n_parent, l10n_state, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, uid_local, uid_foreign, tablenames, fieldname, sorting_foreign, table_local, title, description, alternative, link, crop, autoplay, zzz_deleted_t3ver_id FROM __temp__sys_file_reference
|
|
DROP TABLE __temp__sys_file_reference
|
|
CREATE INDEX t3ver_oid_08d845fb ON "sys_file_reference" (t3ver_oid, t3ver_wsid)
|
|
CREATE INDEX parent_3efdb54b ON "sys_file_reference" (pid, deleted, hidden)
|
|
CREATE INDEX combined_1_b25ed807 ON "sys_file_reference" (l10n_parent, t3ver_oid, t3ver_wsid, t3ver_state, deleted)
|
|
CREATE INDEX uid_foreign_84870ada ON "sys_file_reference" (uid_foreign)
|
|
CREATE INDEX uid_local_6e063d86 ON "sys_file_reference" (uid_local)
|
|
CREATE INDEX deleted_ec55f9ff ON "sys_file_reference" (deleted)
|
|
CREATE INDEX tablenames_fieldname_2fe50272 ON "sys_file_reference" (tablenames, fieldname)
|
|
CREATE TABLE "sys_file_reference" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, uid_local INTEGER DEFAULT 0 NOT NULL, uid_foreign INTEGER DEFAULT 0 NOT NULL, tablenames VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, fieldname VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, sorting_foreign INTEGER DEFAULT 0 NOT NULL, table_local VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, title CLOB DEFAULT NULL COLLATE BINARY, description CLOB DEFAULT NULL COLLATE BINARY, alternative CLOB DEFAULT NULL COLLATE BINARY, link VARCHAR(1024) DEFAULT '' NOT NULL COLLATE BINARY, crop VARCHAR(4000) DEFAULT '' NOT NULL COLLATE BINARY, autoplay SMALLINT DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_label" VARCHAR(255) DEFAULT '' NOT NULL)
|
|
DROP INDEX t3ver_oid_d19f62d6
|
|
DROP INDEX parent_cfb58add
|
|
CREATE TEMPORARY TABLE __temp__sys_file_collection AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, type, files, storage, folder, recursive, category, zzz_deleted_t3ver_id FROM "sys_file_collection"
|
|
DROP TABLE "sys_file_collection"
|
|
CREATE TABLE "sys_file_collection" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title CLOB DEFAULT NULL COLLATE BINARY, type VARCHAR(30) DEFAULT 'static' NOT NULL COLLATE BINARY, files INTEGER DEFAULT 0 NOT NULL, storage INTEGER DEFAULT 0 NOT NULL, folder CLOB DEFAULT NULL COLLATE BINARY, recursive SMALLINT DEFAULT 0 NOT NULL, category INTEGER DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_id" INTEGER UNSIGNED DEFAULT 0 NOT NULL)
|
|
INSERT INTO "sys_file_collection" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, type, files, storage, folder, recursive, category, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, type, files, storage, folder, recursive, category, zzz_deleted_t3ver_id FROM __temp__sys_file_collection
|
|
DROP TABLE __temp__sys_file_collection
|
|
CREATE INDEX t3ver_oid_d19f62d6 ON "sys_file_collection" (t3ver_oid, t3ver_wsid)
|
|
CREATE INDEX parent_cfb58add ON "sys_file_collection" (pid, deleted, hidden)
|
|
CREATE TABLE "sys_file_collection" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title CLOB DEFAULT NULL COLLATE BINARY, type VARCHAR(30) DEFAULT 'static' NOT NULL COLLATE BINARY, files INTEGER DEFAULT 0 NOT NULL, storage INTEGER DEFAULT 0 NOT NULL, folder CLOB DEFAULT NULL COLLATE BINARY, recursive SMALLINT DEFAULT 0 NOT NULL, category INTEGER DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_label" VARCHAR(255) DEFAULT '' NOT NULL)
|
|
DROP INDEX t3ver_oid_f30873cd
|
|
DROP INDEX parent_9a244dea
|
|
CREATE TEMPORARY TABLE __temp__sys_collection AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, type, table_name, items, zzz_deleted_t3ver_id FROM "sys_collection"
|
|
DROP TABLE "sys_collection"
|
|
CREATE TABLE "sys_collection" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, fe_group VARCHAR(255) DEFAULT '0' NOT NULL COLLATE BINARY, description CLOB DEFAULT NULL COLLATE BINARY, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title CLOB DEFAULT NULL COLLATE BINARY, type VARCHAR(32) DEFAULT 'static' NOT NULL COLLATE BINARY, table_name CLOB DEFAULT NULL COLLATE BINARY, items INTEGER DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_id" INTEGER UNSIGNED DEFAULT 0 NOT NULL)
|
|
INSERT INTO "sys_collection" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, type, table_name, items, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, type, table_name, items, zzz_deleted_t3ver_id FROM __temp__sys_collection
|
|
DROP TABLE __temp__sys_collection
|
|
CREATE INDEX t3ver_oid_f30873cd ON "sys_collection" (t3ver_oid, t3ver_wsid)
|
|
CREATE INDEX parent_9a244dea ON "sys_collection" (pid, deleted, hidden)
|
|
CREATE TABLE "sys_collection" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, fe_group VARCHAR(255) DEFAULT '0' NOT NULL COLLATE BINARY, description CLOB DEFAULT NULL COLLATE BINARY, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title CLOB DEFAULT NULL COLLATE BINARY, type VARCHAR(32) DEFAULT 'static' NOT NULL COLLATE BINARY, table_name CLOB DEFAULT NULL COLLATE BINARY, items INTEGER DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_label" VARCHAR(255) DEFAULT '' NOT NULL)
|
|
DROP INDEX recordident_2_78d43f6c
|
|
DROP INDEX recordident_1_e1dd6ed6
|
|
CREATE TEMPORARY TABLE __temp__sys_history AS SELECT uid, pid, tstamp, actiontype, usertype, userid, originaluserid, recuid, tablename, history_data, workspace, correlation_id, zzz_deleted_pid FROM "sys_history"
|
|
DROP TABLE "sys_history"
|
|
CREATE TABLE "sys_history" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, actiontype SMALLINT DEFAULT 0 NOT NULL, usertype VARCHAR(2) DEFAULT 'BE' NOT NULL COLLATE BINARY, userid INTEGER UNSIGNED DEFAULT NULL, originaluserid INTEGER UNSIGNED DEFAULT NULL, recuid INTEGER DEFAULT 0 NOT NULL, tablename VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, history_data CLOB DEFAULT NULL COLLATE BINARY, workspace INTEGER DEFAULT 0, correlation_id VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, "zzz_deleted_pid" INTEGER UNSIGNED DEFAULT 0 NOT NULL)
|
|
INSERT INTO "sys_history" (uid, pid, tstamp, actiontype, usertype, userid, originaluserid, recuid, tablename, history_data, workspace, correlation_id, zzz_deleted_pid) SELECT uid, pid, tstamp, actiontype, usertype, userid, originaluserid, recuid, tablename, history_data, workspace, correlation_id, zzz_deleted_pid FROM __temp__sys_history
|
|
DROP TABLE __temp__sys_history
|
|
CREATE INDEX recordident_2_78d43f6c ON "sys_history" (tablename, tstamp)
|
|
CREATE INDEX recordident_1_e1dd6ed6 ON "sys_history" (tablename, recuid)
|
|
DROP INDEX parent_b7280232
|
|
CREATE TEMPORARY TABLE __temp__sys_language AS SELECT uid, pid, tstamp, hidden, sorting, title, flag, language_isocode, static_lang_isocode, zzz_deleted_static_lang_isocode FROM "sys_language"
|
|
DROP TABLE "sys_language"
|
|
CREATE TABLE "sys_language" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sorting INTEGER DEFAULT 0 NOT NULL, title VARCHAR(80) DEFAULT '' NOT NULL COLLATE BINARY, flag VARCHAR(20) DEFAULT '' NOT NULL COLLATE BINARY, language_isocode VARCHAR(2) DEFAULT '' NOT NULL COLLATE BINARY, static_lang_isocode INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_static_lang_isocode" INTEGER UNSIGNED DEFAULT 0 NOT NULL)
|
|
INSERT INTO "sys_language" (uid, pid, tstamp, hidden, sorting, title, flag, language_isocode, static_lang_isocode, zzz_deleted_static_lang_isocode) SELECT uid, pid, tstamp, hidden, sorting, title, flag, language_isocode, static_lang_isocode, zzz_deleted_static_lang_isocode FROM __temp__sys_language
|
|
DROP TABLE __temp__sys_language
|
|
CREATE INDEX parent_b7280232 ON "sys_language" (pid, hidden)
|
|
DROP INDEX t3ver_oid_0fc5a153
|
|
DROP INDEX parent_a4d3f12f
|
|
DROP INDEX category_list_9214ae08
|
|
DROP INDEX category_parent_f5445003
|
|
CREATE TEMPORARY TABLE __temp__sys_category AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, sorting, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, parent, items, slug, zzz_deleted_t3ver_id FROM "sys_category"
|
|
DROP TABLE "sys_category"
|
|
CREATE TABLE "sys_category" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, sorting INTEGER DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title CLOB NOT NULL COLLATE BINARY, parent INTEGER DEFAULT 0 NOT NULL, items INTEGER DEFAULT 0 NOT NULL, slug VARCHAR(2048) DEFAULT NULL COLLATE BINARY, "zzz_deleted_t3ver_id" INTEGER UNSIGNED DEFAULT 0 NOT NULL)
|
|
INSERT INTO "sys_category" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, sorting, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, parent, items, slug, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, sorting, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, parent, items, slug, zzz_deleted_t3ver_id FROM __temp__sys_category
|
|
DROP TABLE __temp__sys_category
|
|
CREATE INDEX t3ver_oid_0fc5a153 ON "sys_category" (t3ver_oid, t3ver_wsid)
|
|
CREATE INDEX parent_a4d3f12f ON "sys_category" (pid, deleted, hidden)
|
|
CREATE INDEX category_list_9214ae08 ON "sys_category" (pid, deleted, sys_language_uid)
|
|
CREATE INDEX category_parent_f5445003 ON "sys_category" (parent)
|
|
CREATE TABLE "sys_category" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, sorting INTEGER DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title CLOB NOT NULL COLLATE BINARY, parent INTEGER DEFAULT 0 NOT NULL, items INTEGER DEFAULT 0 NOT NULL, slug VARCHAR(2048) DEFAULT NULL COLLATE BINARY, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_label" VARCHAR(255) DEFAULT '' NOT NULL)
|
|
DROP INDEX t3ver_oid_01f605d5
|
|
DROP INDEX parent_a0d332a6
|
|
DROP INDEX roottemplate_b05d9c09
|
|
CREATE TEMPORARY TABLE __temp__sys_template AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, sorting, description, t3_origuid, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, sitetitle, root, clear, include_static_file, constants, config, nextLevel, basedOn, includeStaticAfterBasedOn, static_file_mode, zzz_deleted_t3ver_id FROM "sys_template"
|
|
DROP TABLE "sys_template"
|
|
CREATE TABLE "sys_template" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, sorting INTEGER DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, sitetitle VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, root SMALLINT UNSIGNED DEFAULT 0 NOT NULL, clear SMALLINT UNSIGNED DEFAULT 0 NOT NULL, include_static_file CLOB DEFAULT NULL COLLATE BINARY, constants CLOB DEFAULT NULL COLLATE BINARY, config CLOB DEFAULT NULL COLLATE BINARY, nextLevel VARCHAR(5) DEFAULT '' NOT NULL COLLATE BINARY, basedOn CLOB DEFAULT NULL COLLATE BINARY, includeStaticAfterBasedOn SMALLINT UNSIGNED DEFAULT 0 NOT NULL, static_file_mode SMALLINT UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_id" INTEGER UNSIGNED DEFAULT 0 NOT NULL)
|
|
INSERT INTO "sys_template" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, sorting, description, t3_origuid, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, sitetitle, root, clear, include_static_file, constants, config, nextLevel, basedOn, includeStaticAfterBasedOn, static_file_mode, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, sorting, description, t3_origuid, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, sitetitle, root, clear, include_static_file, constants, config, nextLevel, basedOn, includeStaticAfterBasedOn, static_file_mode, zzz_deleted_t3ver_id FROM __temp__sys_template
|
|
DROP TABLE __temp__sys_template
|
|
CREATE INDEX t3ver_oid_01f605d5 ON "sys_template" (t3ver_oid, t3ver_wsid)
|
|
CREATE INDEX parent_a0d332a6 ON "sys_template" (pid, deleted, hidden)
|
|
CREATE INDEX roottemplate_b05d9c09 ON "sys_template" (deleted, hidden, root)
|
|
CREATE TABLE "sys_template" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, sorting INTEGER DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, sitetitle VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, root SMALLINT UNSIGNED DEFAULT 0 NOT NULL, clear SMALLINT UNSIGNED DEFAULT 0 NOT NULL, include_static_file CLOB DEFAULT NULL COLLATE BINARY, constants CLOB DEFAULT NULL COLLATE BINARY, config CLOB DEFAULT NULL COLLATE BINARY, nextLevel VARCHAR(5) DEFAULT '' NOT NULL COLLATE BINARY, basedOn CLOB DEFAULT NULL COLLATE BINARY, includeStaticAfterBasedOn SMALLINT UNSIGNED DEFAULT 0 NOT NULL, static_file_mode SMALLINT UNSIGNED DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_label" VARCHAR(255) DEFAULT '' NOT NULL)
|
|
CREATE TABLE "sys_template" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, sorting INTEGER DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, sitetitle VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, root SMALLINT UNSIGNED DEFAULT 0 NOT NULL, clear SMALLINT UNSIGNED DEFAULT 0 NOT NULL, include_static_file CLOB DEFAULT NULL COLLATE BINARY, constants CLOB DEFAULT NULL COLLATE BINARY, config CLOB DEFAULT NULL COLLATE BINARY, nextLevel VARCHAR(5) DEFAULT '' NOT NULL COLLATE BINARY, basedOn CLOB DEFAULT NULL COLLATE BINARY, includeStaticAfterBasedOn SMALLINT UNSIGNED DEFAULT 0 NOT NULL, static_file_mode SMALLINT UNSIGNED DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_nextLevel" VARCHAR(5) DEFAULT '' NOT NULL)
|
|
DROP INDEX translation_source_fcef6e2f
|
|
DROP INDEX language_6f2c39a6
|
|
DROP INDEX t3ver_oid_be974a6e
|
|
DROP INDEX parent_8b16a914
|
|
CREATE TEMPORARY TABLE __temp__tt_content AS SELECT uid, rowDescription, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, sorting, editlock, sys_language_uid, l18n_parent, l10n_source, l10n_state, t3_origuid, l18n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, CType, header, header_position, bodytext, bullets_type, uploads_description, uploads_type, assets, image, imagewidth, imageorient, imagecols, imageborder, media, layout, frame_class, cols, spaceBefore, spaceAfter, space_before_class, space_after_class, records, pages, colPos, subheader, header_link, image_zoom, header_layout, list_type, sectionIndex, linkToTop, file_collections, filelink_size, filelink_sorting, filelink_sorting_direction, target, date, recursive, imageheight, pi_flexform, accessibility_title, accessibility_bypass, accessibility_bypass_text, selected_categories, category_field, table_class, table_caption, table_delimiter, table_enclosure, table_header_position, table_tfoot, categories, zzz_deleted_t3ver_id FROM "tt_content"
|
|
DROP TABLE "tt_content"
|
|
CREATE TABLE "tt_content" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rowDescription CLOB DEFAULT NULL COLLATE BINARY, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, fe_group VARCHAR(255) DEFAULT '0' NOT NULL COLLATE BINARY, sorting INTEGER DEFAULT 0 NOT NULL, editlock SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l18n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_source INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l18n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, CType VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header_position VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, bodytext CLOB DEFAULT NULL COLLATE BINARY, bullets_type SMALLINT UNSIGNED DEFAULT 0 NOT NULL, uploads_description SMALLINT UNSIGNED DEFAULT 0 NOT NULL, uploads_type SMALLINT UNSIGNED DEFAULT 0 NOT NULL, assets INTEGER UNSIGNED DEFAULT 0 NOT NULL, image INTEGER UNSIGNED DEFAULT 0 NOT NULL, imagewidth INTEGER UNSIGNED DEFAULT 0 NOT NULL, imageorient SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imagecols SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imageborder SMALLINT UNSIGNED DEFAULT 0 NOT NULL, media INTEGER UNSIGNED DEFAULT 0 NOT NULL, layout INTEGER UNSIGNED DEFAULT 0 NOT NULL, frame_class VARCHAR(60) DEFAULT 'default' NOT NULL COLLATE BINARY, cols INTEGER UNSIGNED DEFAULT 0 NOT NULL, spaceBefore SMALLINT UNSIGNED DEFAULT 0 NOT NULL, spaceAfter SMALLINT UNSIGNED DEFAULT 0 NOT NULL, space_before_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, space_after_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, records CLOB DEFAULT NULL COLLATE BINARY, pages CLOB DEFAULT NULL COLLATE BINARY, colPos INTEGER UNSIGNED DEFAULT 0 NOT NULL, subheader VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header_link VARCHAR(1024) DEFAULT '' NOT NULL COLLATE BINARY, image_zoom SMALLINT UNSIGNED DEFAULT 0 NOT NULL, header_layout VARCHAR(30) DEFAULT '0' NOT NULL COLLATE BINARY, list_type VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, sectionIndex SMALLINT UNSIGNED DEFAULT 0 NOT NULL, linkToTop SMALLINT UNSIGNED DEFAULT 0 NOT NULL, file_collections CLOB DEFAULT NULL COLLATE BINARY, filelink_size SMALLINT UNSIGNED DEFAULT 0 NOT NULL, filelink_sorting VARCHAR(17) DEFAULT '' NOT NULL COLLATE BINARY, filelink_sorting_direction VARCHAR(4) DEFAULT '' NOT NULL COLLATE BINARY, target VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, date INTEGER UNSIGNED DEFAULT 0 NOT NULL, recursive SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imageheight INTEGER UNSIGNED DEFAULT 0 NOT NULL, pi_flexform CLOB DEFAULT NULL COLLATE BINARY, accessibility_title VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, accessibility_bypass SMALLINT UNSIGNED DEFAULT 0 NOT NULL, accessibility_bypass_text VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, selected_categories CLOB DEFAULT NULL COLLATE BINARY, category_field VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, table_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, table_caption VARCHAR(255) DEFAULT NULL COLLATE BINARY, table_delimiter SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_enclosure SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_header_position SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_tfoot SMALLINT UNSIGNED DEFAULT 0 NOT NULL, categories INTEGER DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_id" INTEGER UNSIGNED DEFAULT 0 NOT NULL)
|
|
INSERT INTO "tt_content" (uid, rowDescription, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, sorting, editlock, sys_language_uid, l18n_parent, l10n_source, l10n_state, t3_origuid, l18n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, CType, header, header_position, bodytext, bullets_type, uploads_description, uploads_type, assets, image, imagewidth, imageorient, imagecols, imageborder, media, layout, frame_class, cols, spaceBefore, spaceAfter, space_before_class, space_after_class, records, pages, colPos, subheader, header_link, image_zoom, header_layout, list_type, sectionIndex, linkToTop, file_collections, filelink_size, filelink_sorting, filelink_sorting_direction, target, date, recursive, imageheight, pi_flexform, accessibility_title, accessibility_bypass, accessibility_bypass_text, selected_categories, category_field, table_class, table_caption, table_delimiter, table_enclosure, table_header_position, table_tfoot, categories, zzz_deleted_t3ver_id) SELECT uid, rowDescription, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, sorting, editlock, sys_language_uid, l18n_parent, l10n_source, l10n_state, t3_origuid, l18n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, CType, header, header_position, bodytext, bullets_type, uploads_description, uploads_type, assets, image, imagewidth, imageorient, imagecols, imageborder, media, layout, frame_class, cols, spaceBefore, spaceAfter, space_before_class, space_after_class, records, pages, colPos, subheader, header_link, image_zoom, header_layout, list_type, sectionIndex, linkToTop, file_collections, filelink_size, filelink_sorting, filelink_sorting_direction, target, date, recursive, imageheight, pi_flexform, accessibility_title, accessibility_bypass, accessibility_bypass_text, selected_categories, category_field, table_class, table_caption, table_delimiter, table_enclosure, table_header_position, table_tfoot, categories, zzz_deleted_t3ver_id FROM __temp__tt_content
|
|
DROP TABLE __temp__tt_content
|
|
CREATE INDEX translation_source_fcef6e2f ON "tt_content" (l10n_source)
|
|
CREATE INDEX language_6f2c39a6 ON "tt_content" (l18n_parent, sys_language_uid)
|
|
CREATE INDEX t3ver_oid_be974a6e ON "tt_content" (t3ver_oid, t3ver_wsid)
|
|
CREATE INDEX parent_8b16a914 ON "tt_content" (pid, sorting)
|
|
CREATE TABLE "tt_content" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rowDescription CLOB DEFAULT NULL COLLATE BINARY, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, fe_group VARCHAR(255) DEFAULT '0' NOT NULL COLLATE BINARY, sorting INTEGER DEFAULT 0 NOT NULL, editlock SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l18n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_source INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l18n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, CType VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header_position VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, bodytext CLOB DEFAULT NULL COLLATE BINARY, bullets_type SMALLINT UNSIGNED DEFAULT 0 NOT NULL, uploads_description SMALLINT UNSIGNED DEFAULT 0 NOT NULL, uploads_type SMALLINT UNSIGNED DEFAULT 0 NOT NULL, assets INTEGER UNSIGNED DEFAULT 0 NOT NULL, image INTEGER UNSIGNED DEFAULT 0 NOT NULL, imagewidth INTEGER UNSIGNED DEFAULT 0 NOT NULL, imageorient SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imagecols SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imageborder SMALLINT UNSIGNED DEFAULT 0 NOT NULL, media INTEGER UNSIGNED DEFAULT 0 NOT NULL, layout INTEGER UNSIGNED DEFAULT 0 NOT NULL, frame_class VARCHAR(60) DEFAULT 'default' NOT NULL COLLATE BINARY, cols INTEGER UNSIGNED DEFAULT 0 NOT NULL, spaceBefore SMALLINT UNSIGNED DEFAULT 0 NOT NULL, spaceAfter SMALLINT UNSIGNED DEFAULT 0 NOT NULL, space_before_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, space_after_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, records CLOB DEFAULT NULL COLLATE BINARY, pages CLOB DEFAULT NULL COLLATE BINARY, colPos INTEGER UNSIGNED DEFAULT 0 NOT NULL, subheader VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header_link VARCHAR(1024) DEFAULT '' NOT NULL COLLATE BINARY, image_zoom SMALLINT UNSIGNED DEFAULT 0 NOT NULL, header_layout VARCHAR(30) DEFAULT '0' NOT NULL COLLATE BINARY, list_type VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, sectionIndex SMALLINT UNSIGNED DEFAULT 0 NOT NULL, linkToTop SMALLINT UNSIGNED DEFAULT 0 NOT NULL, file_collections CLOB DEFAULT NULL COLLATE BINARY, filelink_size SMALLINT UNSIGNED DEFAULT 0 NOT NULL, filelink_sorting VARCHAR(17) DEFAULT '' NOT NULL COLLATE BINARY, filelink_sorting_direction VARCHAR(4) DEFAULT '' NOT NULL COLLATE BINARY, target VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, date INTEGER UNSIGNED DEFAULT 0 NOT NULL, recursive SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imageheight INTEGER UNSIGNED DEFAULT 0 NOT NULL, pi_flexform CLOB DEFAULT NULL COLLATE BINARY, accessibility_title VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, accessibility_bypass SMALLINT UNSIGNED DEFAULT 0 NOT NULL, accessibility_bypass_text VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, selected_categories CLOB DEFAULT NULL COLLATE BINARY, category_field VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, table_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, table_caption VARCHAR(255) DEFAULT NULL COLLATE BINARY, table_delimiter SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_enclosure SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_header_position SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_tfoot SMALLINT UNSIGNED DEFAULT 0 NOT NULL, categories INTEGER DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_label" VARCHAR(255) DEFAULT '' NOT NULL)
|
|
CREATE TABLE "tt_content" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rowDescription CLOB DEFAULT NULL COLLATE BINARY, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, fe_group VARCHAR(255) DEFAULT '0' NOT NULL COLLATE BINARY, sorting INTEGER DEFAULT 0 NOT NULL, editlock SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l18n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_source INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l18n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, CType VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header_position VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, bodytext CLOB DEFAULT NULL COLLATE BINARY, bullets_type SMALLINT UNSIGNED DEFAULT 0 NOT NULL, uploads_description SMALLINT UNSIGNED DEFAULT 0 NOT NULL, uploads_type SMALLINT UNSIGNED DEFAULT 0 NOT NULL, assets INTEGER UNSIGNED DEFAULT 0 NOT NULL, image INTEGER UNSIGNED DEFAULT 0 NOT NULL, imagewidth INTEGER UNSIGNED DEFAULT 0 NOT NULL, imageorient SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imagecols SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imageborder SMALLINT UNSIGNED DEFAULT 0 NOT NULL, media INTEGER UNSIGNED DEFAULT 0 NOT NULL, layout INTEGER UNSIGNED DEFAULT 0 NOT NULL, frame_class VARCHAR(60) DEFAULT 'default' NOT NULL COLLATE BINARY, cols INTEGER UNSIGNED DEFAULT 0 NOT NULL, spaceBefore SMALLINT UNSIGNED DEFAULT 0 NOT NULL, spaceAfter SMALLINT UNSIGNED DEFAULT 0 NOT NULL, space_before_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, space_after_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, records CLOB DEFAULT NULL COLLATE BINARY, pages CLOB DEFAULT NULL COLLATE BINARY, colPos INTEGER UNSIGNED DEFAULT 0 NOT NULL, subheader VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header_link VARCHAR(1024) DEFAULT '' NOT NULL COLLATE BINARY, image_zoom SMALLINT UNSIGNED DEFAULT 0 NOT NULL, header_layout VARCHAR(30) DEFAULT '0' NOT NULL COLLATE BINARY, list_type VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, sectionIndex SMALLINT UNSIGNED DEFAULT 0 NOT NULL, linkToTop SMALLINT UNSIGNED DEFAULT 0 NOT NULL, file_collections CLOB DEFAULT NULL COLLATE BINARY, filelink_size SMALLINT UNSIGNED DEFAULT 0 NOT NULL, filelink_sorting VARCHAR(17) DEFAULT '' NOT NULL COLLATE BINARY, filelink_sorting_direction VARCHAR(4) DEFAULT '' NOT NULL COLLATE BINARY, target VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, date INTEGER UNSIGNED DEFAULT 0 NOT NULL, recursive SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imageheight INTEGER UNSIGNED DEFAULT 0 NOT NULL, pi_flexform CLOB DEFAULT NULL COLLATE BINARY, accessibility_title VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, accessibility_bypass SMALLINT UNSIGNED DEFAULT 0 NOT NULL, accessibility_bypass_text VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, selected_categories CLOB DEFAULT NULL COLLATE BINARY, category_field VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, table_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, table_caption VARCHAR(255) DEFAULT NULL COLLATE BINARY, table_delimiter SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_enclosure SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_header_position SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_tfoot SMALLINT UNSIGNED DEFAULT 0 NOT NULL, categories INTEGER DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_spaceBefore" SMALLINT UNSIGNED DEFAULT 0 NOT NULL)
|
|
CREATE TABLE "tt_content" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rowDescription CLOB DEFAULT NULL COLLATE BINARY, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, fe_group VARCHAR(255) DEFAULT '0' NOT NULL COLLATE BINARY, sorting INTEGER DEFAULT 0 NOT NULL, editlock SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l18n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_source INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l18n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, CType VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header_position VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, bodytext CLOB DEFAULT NULL COLLATE BINARY, bullets_type SMALLINT UNSIGNED DEFAULT 0 NOT NULL, uploads_description SMALLINT UNSIGNED DEFAULT 0 NOT NULL, uploads_type SMALLINT UNSIGNED DEFAULT 0 NOT NULL, assets INTEGER UNSIGNED DEFAULT 0 NOT NULL, image INTEGER UNSIGNED DEFAULT 0 NOT NULL, imagewidth INTEGER UNSIGNED DEFAULT 0 NOT NULL, imageorient SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imagecols SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imageborder SMALLINT UNSIGNED DEFAULT 0 NOT NULL, media INTEGER UNSIGNED DEFAULT 0 NOT NULL, layout INTEGER UNSIGNED DEFAULT 0 NOT NULL, frame_class VARCHAR(60) DEFAULT 'default' NOT NULL COLLATE BINARY, cols INTEGER UNSIGNED DEFAULT 0 NOT NULL, spaceBefore SMALLINT UNSIGNED DEFAULT 0 NOT NULL, spaceAfter SMALLINT UNSIGNED DEFAULT 0 NOT NULL, space_before_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, space_after_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, records CLOB DEFAULT NULL COLLATE BINARY, pages CLOB DEFAULT NULL COLLATE BINARY, colPos INTEGER UNSIGNED DEFAULT 0 NOT NULL, subheader VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header_link VARCHAR(1024) DEFAULT '' NOT NULL COLLATE BINARY, image_zoom SMALLINT UNSIGNED DEFAULT 0 NOT NULL, header_layout VARCHAR(30) DEFAULT '0' NOT NULL COLLATE BINARY, list_type VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, sectionIndex SMALLINT UNSIGNED DEFAULT 0 NOT NULL, linkToTop SMALLINT UNSIGNED DEFAULT 0 NOT NULL, file_collections CLOB DEFAULT NULL COLLATE BINARY, filelink_size SMALLINT UNSIGNED DEFAULT 0 NOT NULL, filelink_sorting VARCHAR(17) DEFAULT '' NOT NULL COLLATE BINARY, filelink_sorting_direction VARCHAR(4) DEFAULT '' NOT NULL COLLATE BINARY, target VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, date INTEGER UNSIGNED DEFAULT 0 NOT NULL, recursive SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imageheight INTEGER UNSIGNED DEFAULT 0 NOT NULL, pi_flexform CLOB DEFAULT NULL COLLATE BINARY, accessibility_title VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, accessibility_bypass SMALLINT UNSIGNED DEFAULT 0 NOT NULL, accessibility_bypass_text VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, selected_categories CLOB DEFAULT NULL COLLATE BINARY, category_field VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, table_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, table_caption VARCHAR(255) DEFAULT NULL COLLATE BINARY, table_delimiter SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_enclosure SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_header_position SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_tfoot SMALLINT UNSIGNED DEFAULT 0 NOT NULL, categories INTEGER DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_spaceAfter" SMALLINT UNSIGNED DEFAULT 0 NOT NULL)
|
|
DROP INDEX t3ver_oid_8dc31fea
|
|
DROP INDEX parent_30db6e61
|
|
CREATE TEMPORARY TABLE __temp__backend_layout AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, sorting, description, t3_origuid, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, config, icon, zzz_deleted_t3ver_id FROM "backend_layout"
|
|
DROP TABLE "backend_layout"
|
|
CREATE TABLE "backend_layout" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sorting INTEGER DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, config CLOB NOT NULL COLLATE BINARY, icon CLOB DEFAULT NULL COLLATE BINARY, "zzz_deleted_t3ver_id" INTEGER UNSIGNED DEFAULT 0 NOT NULL)
|
|
INSERT INTO "backend_layout" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, sorting, description, t3_origuid, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, config, icon, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, sorting, description, t3_origuid, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, config, icon, zzz_deleted_t3ver_id FROM __temp__backend_layout
|
|
DROP TABLE __temp__backend_layout
|
|
CREATE INDEX t3ver_oid_8dc31fea ON "backend_layout" (t3ver_oid, t3ver_wsid)
|
|
CREATE INDEX parent_30db6e61 ON "backend_layout" (pid, deleted, hidden)
|
|
CREATE TABLE "backend_layout" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sorting INTEGER DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, config CLOB NOT NULL COLLATE BINARY, icon CLOB DEFAULT NULL COLLATE BINARY, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_label" VARCHAR(255) DEFAULT '' NOT NULL)
|
|
|
|
Drop fields (really!)
|
|
|
|
select/deselect all
|
|
DROP INDEX t3ver_oid_f068716b
|
|
DROP INDEX translation_source_c9bb4567
|
|
DROP INDEX parent_90041b40
|
|
DROP INDEX slug_d357d1e2
|
|
DROP INDEX language_identifier_8c77f4c2
|
|
DROP INDEX determineSiteRoot_5c54427f
|
|
CREATE TEMPORARY TABLE __temp__pages AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, sorting, rowDescription, editlock, sys_language_uid, l10n_parent, l10n_source, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, perms_userid, perms_groupid, perms_user, perms_group, perms_everybody, title, slug, doktype, TSconfig, is_siteroot, php_tree_stop, url, shortcut, shortcut_mode, subtitle, layout, target, media, lastUpdated, keywords, cache_timeout, cache_tags, newUntil, description, no_search, SYS_LASTCHANGED, abstract, module, extendToSubpages, author, author_email, nav_title, nav_hide, content_from_pid, mount_pid, mount_pid_ol, alias, l18n_cfg, fe_login_mode, backend_layout, backend_layout_next_level, tsconfig_includes, legacy_overlay_uid, categories, seo_title, no_index, no_follow, og_title, og_description, og_image, twitter_title, twitter_description, twitter_image, canonical_link, sitemap_priority, sitemap_changefreq, twitter_card, zzz_deleted_t3ver_id FROM "pages"
|
|
DROP TABLE "pages"
|
|
CREATE TABLE "pages" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, fe_group VARCHAR(255) DEFAULT '0' NOT NULL COLLATE BINARY, sorting INTEGER DEFAULT 0 NOT NULL, rowDescription CLOB DEFAULT NULL COLLATE BINARY, editlock SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_source INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, perms_userid INTEGER UNSIGNED DEFAULT 0 NOT NULL, perms_groupid INTEGER UNSIGNED DEFAULT 0 NOT NULL, perms_user SMALLINT UNSIGNED DEFAULT 0 NOT NULL, perms_group SMALLINT UNSIGNED DEFAULT 0 NOT NULL, perms_everybody SMALLINT UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, slug VARCHAR(2048) DEFAULT NULL COLLATE BINARY, doktype INTEGER UNSIGNED DEFAULT 0 NOT NULL, TSconfig CLOB DEFAULT NULL COLLATE BINARY, is_siteroot SMALLINT DEFAULT 0 NOT NULL, php_tree_stop SMALLINT DEFAULT 0 NOT NULL, url VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, shortcut INTEGER UNSIGNED DEFAULT 0 NOT NULL, shortcut_mode INTEGER UNSIGNED DEFAULT 0 NOT NULL, subtitle VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, layout INTEGER UNSIGNED DEFAULT 0 NOT NULL, target VARCHAR(80) DEFAULT '' NOT NULL COLLATE BINARY, media INTEGER UNSIGNED DEFAULT 0 NOT NULL, lastUpdated INTEGER UNSIGNED DEFAULT 0 NOT NULL, keywords CLOB DEFAULT NULL COLLATE BINARY, cache_timeout INTEGER UNSIGNED DEFAULT 0 NOT NULL, cache_tags VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, newUntil INTEGER UNSIGNED DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, no_search SMALLINT UNSIGNED DEFAULT 0 NOT NULL, SYS_LASTCHANGED INTEGER UNSIGNED DEFAULT 0 NOT NULL, abstract CLOB DEFAULT NULL COLLATE BINARY, module VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, extendToSubpages SMALLINT UNSIGNED DEFAULT 0 NOT NULL, author VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, author_email VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, nav_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, nav_hide SMALLINT DEFAULT 0 NOT NULL, content_from_pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, mount_pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, mount_pid_ol SMALLINT DEFAULT 0 NOT NULL, alias VARCHAR(32) DEFAULT '' NOT NULL COLLATE BINARY, l18n_cfg SMALLINT DEFAULT 0 NOT NULL, fe_login_mode SMALLINT DEFAULT 0 NOT NULL, backend_layout VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, backend_layout_next_level VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, tsconfig_includes CLOB DEFAULT NULL COLLATE BINARY, legacy_overlay_uid INTEGER UNSIGNED DEFAULT 0 NOT NULL, categories INTEGER DEFAULT 0 NOT NULL, seo_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, no_index SMALLINT DEFAULT 0 NOT NULL, no_follow SMALLINT DEFAULT 0 NOT NULL, og_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, og_description CLOB DEFAULT NULL COLLATE BINARY, og_image INTEGER UNSIGNED DEFAULT 0 NOT NULL, twitter_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, twitter_description CLOB DEFAULT NULL COLLATE BINARY, twitter_image INTEGER UNSIGNED DEFAULT 0 NOT NULL, canonical_link VARCHAR(2048) DEFAULT '' NOT NULL COLLATE BINARY, sitemap_priority NUMERIC(1, 1) DEFAULT '0.5' NOT NULL, sitemap_changefreq VARCHAR(10) DEFAULT '' NOT NULL COLLATE BINARY, twitter_card VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL)
|
|
INSERT INTO "pages" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, sorting, rowDescription, editlock, sys_language_uid, l10n_parent, l10n_source, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, perms_userid, perms_groupid, perms_user, perms_group, perms_everybody, title, slug, doktype, TSconfig, is_siteroot, php_tree_stop, url, shortcut, shortcut_mode, subtitle, layout, target, media, lastUpdated, keywords, cache_timeout, cache_tags, newUntil, description, no_search, SYS_LASTCHANGED, abstract, module, extendToSubpages, author, author_email, nav_title, nav_hide, content_from_pid, mount_pid, mount_pid_ol, alias, l18n_cfg, fe_login_mode, backend_layout, backend_layout_next_level, tsconfig_includes, legacy_overlay_uid, categories, seo_title, no_index, no_follow, og_title, og_description, og_image, twitter_title, twitter_description, twitter_image, canonical_link, sitemap_priority, sitemap_changefreq, twitter_card, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, sorting, rowDescription, editlock, sys_language_uid, l10n_parent, l10n_source, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, perms_userid, perms_groupid, perms_user, perms_group, perms_everybody, title, slug, doktype, TSconfig, is_siteroot, php_tree_stop, url, shortcut, shortcut_mode, subtitle, layout, target, media, lastUpdated, keywords, cache_timeout, cache_tags, newUntil, description, no_search, SYS_LASTCHANGED, abstract, module, extendToSubpages, author, author_email, nav_title, nav_hide, content_from_pid, mount_pid, mount_pid_ol, alias, l18n_cfg, fe_login_mode, backend_layout, backend_layout_next_level, tsconfig_includes, legacy_overlay_uid, categories, seo_title, no_index, no_follow, og_title, og_description, og_image, twitter_title, twitter_description, twitter_image, canonical_link, sitemap_priority, sitemap_changefreq, twitter_card, zzz_deleted_t3ver_id FROM __temp__pages
|
|
DROP TABLE __temp__pages
|
|
CREATE INDEX t3ver_oid_f068716b ON "pages" (t3ver_oid, t3ver_wsid)
|
|
CREATE INDEX translation_source_c9bb4567 ON "pages" (l10n_source)
|
|
CREATE INDEX parent_90041b40 ON "pages" (pid, deleted, hidden)
|
|
CREATE INDEX slug_d357d1e2 ON "pages" (slug)
|
|
CREATE INDEX language_identifier_8c77f4c2 ON "pages" (l10n_parent, sys_language_uid)
|
|
CREATE INDEX determineSiteRoot_5c54427f ON "pages" (is_siteroot)
|
|
DROP INDEX t3ver_oid_2afb6cbb
|
|
DROP INDEX parent_8d466b11
|
|
DROP INDEX fal_filelist_3fe1fc5b
|
|
DROP INDEX file_a8a43bc7
|
|
CREATE TEMPORARY TABLE __temp__sys_file_metadata AS SELECT uid, pid, tstamp, crdate, cruser_id, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, file, title, width, height, description, alternative, categories, zzz_deleted_t3ver_id FROM "sys_file_metadata"
|
|
DROP TABLE "sys_file_metadata"
|
|
CREATE TABLE "sys_file_metadata" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, file INTEGER DEFAULT 0 NOT NULL, title CLOB DEFAULT NULL COLLATE BINARY, width INTEGER DEFAULT 0 NOT NULL, height INTEGER DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, alternative CLOB DEFAULT NULL COLLATE BINARY, categories INTEGER DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL)
|
|
INSERT INTO "sys_file_metadata" (uid, pid, tstamp, crdate, cruser_id, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, file, title, width, height, description, alternative, categories, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, file, title, width, height, description, alternative, categories, zzz_deleted_t3ver_id FROM __temp__sys_file_metadata
|
|
DROP TABLE __temp__sys_file_metadata
|
|
CREATE INDEX t3ver_oid_2afb6cbb ON "sys_file_metadata" (t3ver_oid, t3ver_wsid)
|
|
CREATE INDEX parent_8d466b11 ON "sys_file_metadata" (pid)
|
|
CREATE INDEX fal_filelist_3fe1fc5b ON "sys_file_metadata" (l10n_parent, sys_language_uid)
|
|
CREATE INDEX file_a8a43bc7 ON "sys_file_metadata" (file)
|
|
DROP INDEX t3ver_oid_08d845fb
|
|
DROP INDEX parent_3efdb54b
|
|
DROP INDEX combined_1_b25ed807
|
|
DROP INDEX uid_foreign_84870ada
|
|
DROP INDEX uid_local_6e063d86
|
|
DROP INDEX deleted_ec55f9ff
|
|
DROP INDEX tablenames_fieldname_2fe50272
|
|
CREATE TEMPORARY TABLE __temp__sys_file_reference AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, sys_language_uid, l10n_parent, l10n_state, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, uid_local, uid_foreign, tablenames, fieldname, sorting_foreign, table_local, title, description, alternative, link, crop, autoplay, zzz_deleted_t3ver_id FROM "sys_file_reference"
|
|
DROP TABLE "sys_file_reference"
|
|
CREATE TABLE "sys_file_reference" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, uid_local INTEGER DEFAULT 0 NOT NULL, uid_foreign INTEGER DEFAULT 0 NOT NULL, tablenames VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, fieldname VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, sorting_foreign INTEGER DEFAULT 0 NOT NULL, table_local VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, title CLOB DEFAULT NULL COLLATE BINARY, description CLOB DEFAULT NULL COLLATE BINARY, alternative CLOB DEFAULT NULL COLLATE BINARY, link VARCHAR(1024) DEFAULT '' NOT NULL COLLATE BINARY, crop VARCHAR(4000) DEFAULT '' NOT NULL COLLATE BINARY, autoplay SMALLINT DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL)
|
|
INSERT INTO "sys_file_reference" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, sys_language_uid, l10n_parent, l10n_state, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, uid_local, uid_foreign, tablenames, fieldname, sorting_foreign, table_local, title, description, alternative, link, crop, autoplay, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, sys_language_uid, l10n_parent, l10n_state, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, uid_local, uid_foreign, tablenames, fieldname, sorting_foreign, table_local, title, description, alternative, link, crop, autoplay, zzz_deleted_t3ver_id FROM __temp__sys_file_reference
|
|
DROP TABLE __temp__sys_file_reference
|
|
CREATE INDEX t3ver_oid_08d845fb ON "sys_file_reference" (t3ver_oid, t3ver_wsid)
|
|
CREATE INDEX parent_3efdb54b ON "sys_file_reference" (pid, deleted, hidden)
|
|
CREATE INDEX combined_1_b25ed807 ON "sys_file_reference" (l10n_parent, t3ver_oid, t3ver_wsid, t3ver_state, deleted)
|
|
CREATE INDEX uid_foreign_84870ada ON "sys_file_reference" (uid_foreign)
|
|
CREATE INDEX uid_local_6e063d86 ON "sys_file_reference" (uid_local)
|
|
CREATE INDEX deleted_ec55f9ff ON "sys_file_reference" (deleted)
|
|
CREATE INDEX tablenames_fieldname_2fe50272 ON "sys_file_reference" (tablenames, fieldname)
|
|
DROP INDEX t3ver_oid_d19f62d6
|
|
DROP INDEX parent_cfb58add
|
|
CREATE TEMPORARY TABLE __temp__sys_file_collection AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, type, files, storage, folder, recursive, category, zzz_deleted_t3ver_id FROM "sys_file_collection"
|
|
DROP TABLE "sys_file_collection"
|
|
CREATE TABLE "sys_file_collection" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title CLOB DEFAULT NULL COLLATE BINARY, type VARCHAR(30) DEFAULT 'static' NOT NULL COLLATE BINARY, files INTEGER DEFAULT 0 NOT NULL, storage INTEGER DEFAULT 0 NOT NULL, folder CLOB DEFAULT NULL COLLATE BINARY, recursive SMALLINT DEFAULT 0 NOT NULL, category INTEGER DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL)
|
|
INSERT INTO "sys_file_collection" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, type, files, storage, folder, recursive, category, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, type, files, storage, folder, recursive, category, zzz_deleted_t3ver_id FROM __temp__sys_file_collection
|
|
DROP TABLE __temp__sys_file_collection
|
|
CREATE INDEX t3ver_oid_d19f62d6 ON "sys_file_collection" (t3ver_oid, t3ver_wsid)
|
|
CREATE INDEX parent_cfb58add ON "sys_file_collection" (pid, deleted, hidden)
|
|
DROP INDEX t3ver_oid_f30873cd
|
|
DROP INDEX parent_9a244dea
|
|
CREATE TEMPORARY TABLE __temp__sys_collection AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, type, table_name, items, zzz_deleted_t3ver_id FROM "sys_collection"
|
|
DROP TABLE "sys_collection"
|
|
CREATE TABLE "sys_collection" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, fe_group VARCHAR(255) DEFAULT '0' NOT NULL COLLATE BINARY, description CLOB DEFAULT NULL COLLATE BINARY, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title CLOB DEFAULT NULL COLLATE BINARY, type VARCHAR(32) DEFAULT 'static' NOT NULL COLLATE BINARY, table_name CLOB DEFAULT NULL COLLATE BINARY, items INTEGER DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL)
|
|
INSERT INTO "sys_collection" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, type, table_name, items, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, type, table_name, items, zzz_deleted_t3ver_id FROM __temp__sys_collection
|
|
DROP TABLE __temp__sys_collection
|
|
CREATE INDEX t3ver_oid_f30873cd ON "sys_collection" (t3ver_oid, t3ver_wsid)
|
|
CREATE INDEX parent_9a244dea ON "sys_collection" (pid, deleted, hidden)
|
|
DROP INDEX recordident_2_78d43f6c
|
|
DROP INDEX recordident_1_e1dd6ed6
|
|
CREATE TEMPORARY TABLE __temp__sys_history AS SELECT uid, pid, tstamp, actiontype, usertype, userid, originaluserid, recuid, tablename, history_data, workspace, correlation_id, zzz_deleted_pid FROM "sys_history"
|
|
DROP TABLE "sys_history"
|
|
CREATE TABLE "sys_history" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, actiontype SMALLINT DEFAULT 0 NOT NULL, usertype VARCHAR(2) DEFAULT 'BE' NOT NULL COLLATE BINARY, userid INTEGER UNSIGNED DEFAULT NULL, originaluserid INTEGER UNSIGNED DEFAULT NULL, recuid INTEGER DEFAULT 0 NOT NULL, tablename VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, history_data CLOB DEFAULT NULL COLLATE BINARY, workspace INTEGER DEFAULT 0, correlation_id VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, zzz_deleted_pid INTEGER UNSIGNED DEFAULT 0 NOT NULL)
|
|
INSERT INTO "sys_history" (uid, pid, tstamp, actiontype, usertype, userid, originaluserid, recuid, tablename, history_data, workspace, correlation_id, zzz_deleted_pid) SELECT uid, pid, tstamp, actiontype, usertype, userid, originaluserid, recuid, tablename, history_data, workspace, correlation_id, zzz_deleted_pid FROM __temp__sys_history
|
|
DROP TABLE __temp__sys_history
|
|
CREATE INDEX recordident_2_78d43f6c ON "sys_history" (tablename, tstamp)
|
|
CREATE INDEX recordident_1_e1dd6ed6 ON "sys_history" (tablename, recuid)
|
|
DROP INDEX parent_b7280232
|
|
CREATE TEMPORARY TABLE __temp__sys_language AS SELECT uid, pid, tstamp, hidden, sorting, title, flag, language_isocode, static_lang_isocode, zzz_deleted_static_lang_isocode FROM "sys_language"
|
|
DROP TABLE "sys_language"
|
|
CREATE TABLE "sys_language" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sorting INTEGER DEFAULT 0 NOT NULL, title VARCHAR(80) DEFAULT '' NOT NULL COLLATE BINARY, flag VARCHAR(20) DEFAULT '' NOT NULL COLLATE BINARY, language_isocode VARCHAR(2) DEFAULT '' NOT NULL COLLATE BINARY, static_lang_isocode INTEGER UNSIGNED DEFAULT 0 NOT NULL, zzz_deleted_static_lang_isocode INTEGER UNSIGNED DEFAULT 0 NOT NULL)
|
|
INSERT INTO "sys_language" (uid, pid, tstamp, hidden, sorting, title, flag, language_isocode, static_lang_isocode, zzz_deleted_static_lang_isocode) SELECT uid, pid, tstamp, hidden, sorting, title, flag, language_isocode, static_lang_isocode, zzz_deleted_static_lang_isocode FROM __temp__sys_language
|
|
DROP TABLE __temp__sys_language
|
|
CREATE INDEX parent_b7280232 ON "sys_language" (pid, hidden)
|
|
DROP INDEX t3ver_oid_0fc5a153
|
|
DROP INDEX parent_a4d3f12f
|
|
DROP INDEX category_list_9214ae08
|
|
DROP INDEX category_parent_f5445003
|
|
CREATE TEMPORARY TABLE __temp__sys_category AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, sorting, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, parent, items, slug, zzz_deleted_t3ver_id FROM "sys_category"
|
|
DROP TABLE "sys_category"
|
|
CREATE TABLE "sys_category" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, sorting INTEGER DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title CLOB NOT NULL COLLATE BINARY, parent INTEGER DEFAULT 0 NOT NULL, items INTEGER DEFAULT 0 NOT NULL, slug VARCHAR(2048) DEFAULT NULL COLLATE BINARY, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL)
|
|
INSERT INTO "sys_category" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, sorting, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, parent, items, slug, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, sorting, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, parent, items, slug, zzz_deleted_t3ver_id FROM __temp__sys_category
|
|
DROP TABLE __temp__sys_category
|
|
CREATE INDEX t3ver_oid_0fc5a153 ON "sys_category" (t3ver_oid, t3ver_wsid)
|
|
CREATE INDEX parent_a4d3f12f ON "sys_category" (pid, deleted, hidden)
|
|
CREATE INDEX category_list_9214ae08 ON "sys_category" (pid, deleted, sys_language_uid)
|
|
CREATE INDEX category_parent_f5445003 ON "sys_category" (parent)
|
|
DROP INDEX t3ver_oid_01f605d5
|
|
DROP INDEX parent_a0d332a6
|
|
DROP INDEX roottemplate_b05d9c09
|
|
CREATE TEMPORARY TABLE __temp__sys_template AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, sorting, description, t3_origuid, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, sitetitle, root, clear, include_static_file, constants, config, nextLevel, basedOn, includeStaticAfterBasedOn, static_file_mode, zzz_deleted_t3ver_id FROM "sys_template"
|
|
DROP TABLE "sys_template"
|
|
CREATE TABLE "sys_template" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, sorting INTEGER DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, sitetitle VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, root SMALLINT UNSIGNED DEFAULT 0 NOT NULL, clear SMALLINT UNSIGNED DEFAULT 0 NOT NULL, include_static_file CLOB DEFAULT NULL COLLATE BINARY, constants CLOB DEFAULT NULL COLLATE BINARY, config CLOB DEFAULT NULL COLLATE BINARY, nextLevel VARCHAR(5) DEFAULT '' NOT NULL COLLATE BINARY, basedOn CLOB DEFAULT NULL COLLATE BINARY, includeStaticAfterBasedOn SMALLINT UNSIGNED DEFAULT 0 NOT NULL, static_file_mode SMALLINT UNSIGNED DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL)
|
|
INSERT INTO "sys_template" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, sorting, description, t3_origuid, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, sitetitle, root, clear, include_static_file, constants, config, nextLevel, basedOn, includeStaticAfterBasedOn, static_file_mode, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, sorting, description, t3_origuid, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, sitetitle, root, clear, include_static_file, constants, config, nextLevel, basedOn, includeStaticAfterBasedOn, static_file_mode, zzz_deleted_t3ver_id FROM __temp__sys_template
|
|
DROP TABLE __temp__sys_template
|
|
CREATE INDEX t3ver_oid_01f605d5 ON "sys_template" (t3ver_oid, t3ver_wsid)
|
|
CREATE INDEX parent_a0d332a6 ON "sys_template" (pid, deleted, hidden)
|
|
CREATE INDEX roottemplate_b05d9c09 ON "sys_template" (deleted, hidden, root)
|
|
DROP INDEX translation_source_fcef6e2f
|
|
DROP INDEX language_6f2c39a6
|
|
DROP INDEX t3ver_oid_be974a6e
|
|
DROP INDEX parent_8b16a914
|
|
CREATE TEMPORARY TABLE __temp__tt_content AS SELECT uid, rowDescription, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, sorting, editlock, sys_language_uid, l18n_parent, l10n_source, l10n_state, t3_origuid, l18n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, CType, header, header_position, bodytext, bullets_type, uploads_description, uploads_type, assets, image, imagewidth, imageorient, imagecols, imageborder, media, layout, frame_class, cols, spaceBefore, spaceAfter, space_before_class, space_after_class, records, pages, colPos, subheader, header_link, image_zoom, header_layout, list_type, sectionIndex, linkToTop, file_collections, filelink_size, filelink_sorting, filelink_sorting_direction, target, date, recursive, imageheight, pi_flexform, accessibility_title, accessibility_bypass, accessibility_bypass_text, selected_categories, category_field, table_class, table_caption, table_delimiter, table_enclosure, table_header_position, table_tfoot, categories, zzz_deleted_t3ver_id FROM "tt_content"
|
|
DROP TABLE "tt_content"
|
|
CREATE TABLE "tt_content" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rowDescription CLOB DEFAULT NULL COLLATE BINARY, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, fe_group VARCHAR(255) DEFAULT '0' NOT NULL COLLATE BINARY, sorting INTEGER DEFAULT 0 NOT NULL, editlock SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l18n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_source INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l18n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, CType VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header_position VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, bodytext CLOB DEFAULT NULL COLLATE BINARY, bullets_type SMALLINT UNSIGNED DEFAULT 0 NOT NULL, uploads_description SMALLINT UNSIGNED DEFAULT 0 NOT NULL, uploads_type SMALLINT UNSIGNED DEFAULT 0 NOT NULL, assets INTEGER UNSIGNED DEFAULT 0 NOT NULL, image INTEGER UNSIGNED DEFAULT 0 NOT NULL, imagewidth INTEGER UNSIGNED DEFAULT 0 NOT NULL, imageorient SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imagecols SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imageborder SMALLINT UNSIGNED DEFAULT 0 NOT NULL, media INTEGER UNSIGNED DEFAULT 0 NOT NULL, layout INTEGER UNSIGNED DEFAULT 0 NOT NULL, frame_class VARCHAR(60) DEFAULT 'default' NOT NULL COLLATE BINARY, cols INTEGER UNSIGNED DEFAULT 0 NOT NULL, spaceBefore SMALLINT UNSIGNED DEFAULT 0 NOT NULL, spaceAfter SMALLINT UNSIGNED DEFAULT 0 NOT NULL, space_before_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, space_after_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, records CLOB DEFAULT NULL COLLATE BINARY, pages CLOB DEFAULT NULL COLLATE BINARY, colPos INTEGER UNSIGNED DEFAULT 0 NOT NULL, subheader VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header_link VARCHAR(1024) DEFAULT '' NOT NULL COLLATE BINARY, image_zoom SMALLINT UNSIGNED DEFAULT 0 NOT NULL, header_layout VARCHAR(30) DEFAULT '0' NOT NULL COLLATE BINARY, list_type VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, sectionIndex SMALLINT UNSIGNED DEFAULT 0 NOT NULL, linkToTop SMALLINT UNSIGNED DEFAULT 0 NOT NULL, file_collections CLOB DEFAULT NULL COLLATE BINARY, filelink_size SMALLINT UNSIGNED DEFAULT 0 NOT NULL, filelink_sorting VARCHAR(17) DEFAULT '' NOT NULL COLLATE BINARY, filelink_sorting_direction VARCHAR(4) DEFAULT '' NOT NULL COLLATE BINARY, target VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, date INTEGER UNSIGNED DEFAULT 0 NOT NULL, recursive SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imageheight INTEGER UNSIGNED DEFAULT 0 NOT NULL, pi_flexform CLOB DEFAULT NULL COLLATE BINARY, accessibility_title VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, accessibility_bypass SMALLINT UNSIGNED DEFAULT 0 NOT NULL, accessibility_bypass_text VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, selected_categories CLOB DEFAULT NULL COLLATE BINARY, category_field VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, table_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, table_caption VARCHAR(255) DEFAULT NULL COLLATE BINARY, table_delimiter SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_enclosure SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_header_position SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_tfoot SMALLINT UNSIGNED DEFAULT 0 NOT NULL, categories INTEGER DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL)
|
|
INSERT INTO "tt_content" (uid, rowDescription, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, sorting, editlock, sys_language_uid, l18n_parent, l10n_source, l10n_state, t3_origuid, l18n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, CType, header, header_position, bodytext, bullets_type, uploads_description, uploads_type, assets, image, imagewidth, imageorient, imagecols, imageborder, media, layout, frame_class, cols, spaceBefore, spaceAfter, space_before_class, space_after_class, records, pages, colPos, subheader, header_link, image_zoom, header_layout, list_type, sectionIndex, linkToTop, file_collections, filelink_size, filelink_sorting, filelink_sorting_direction, target, date, recursive, imageheight, pi_flexform, accessibility_title, accessibility_bypass, accessibility_bypass_text, selected_categories, category_field, table_class, table_caption, table_delimiter, table_enclosure, table_header_position, table_tfoot, categories, zzz_deleted_t3ver_id) SELECT uid, rowDescription, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, sorting, editlock, sys_language_uid, l18n_parent, l10n_source, l10n_state, t3_origuid, l18n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, CType, header, header_position, bodytext, bullets_type, uploads_description, uploads_type, assets, image, imagewidth, imageorient, imagecols, imageborder, media, layout, frame_class, cols, spaceBefore, spaceAfter, space_before_class, space_after_class, records, pages, colPos, subheader, header_link, image_zoom, header_layout, list_type, sectionIndex, linkToTop, file_collections, filelink_size, filelink_sorting, filelink_sorting_direction, target, date, recursive, imageheight, pi_flexform, accessibility_title, accessibility_bypass, accessibility_bypass_text, selected_categories, category_field, table_class, table_caption, table_delimiter, table_enclosure, table_header_position, table_tfoot, categories, zzz_deleted_t3ver_id FROM __temp__tt_content
|
|
DROP TABLE __temp__tt_content
|
|
CREATE INDEX translation_source_fcef6e2f ON "tt_content" (l10n_source)
|
|
CREATE INDEX language_6f2c39a6 ON "tt_content" (l18n_parent, sys_language_uid)
|
|
CREATE INDEX t3ver_oid_be974a6e ON "tt_content" (t3ver_oid, t3ver_wsid)
|
|
CREATE INDEX parent_8b16a914 ON "tt_content" (pid, sorting)
|
|
DROP INDEX t3ver_oid_8dc31fea
|
|
DROP INDEX parent_30db6e61
|
|
CREATE TEMPORARY TABLE __temp__backend_layout AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, sorting, description, t3_origuid, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, config, icon, zzz_deleted_t3ver_id FROM "backend_layout"
|
|
DROP TABLE "backend_layout"
|
|
CREATE TABLE "backend_layout" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sorting INTEGER DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, config CLOB NOT NULL COLLATE BINARY, icon CLOB DEFAULT NULL COLLATE BINARY, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL)
|
|
INSERT INTO "backend_layout" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, sorting, description, t3_origuid, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, config, icon, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, sorting, description, t3_origuid, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, config, icon, zzz_deleted_t3ver_id FROM __temp__backend_layout
|
|
DROP TABLE __temp__backend_layout
|
|
CREATE INDEX t3ver_oid_8dc31fea ON "backend_layout" (t3ver_oid, t3ver_wsid)
|
|
CREATE INDEX parent_30db6e61 ON "backend_layout" (pid, deleted, hidden)
|
