[TASK] Deprecate ClientUtility

[Packages/TYPO3.CMS.git] / typo3 / sysext / core / ext_tables.sql

diff --git a/typo3/sysext/core/ext_tables.sql b/typo3/sysext/core/ext_tables.sql
index 60b2356..45373b0 100644 (file)
--- a/typo3/sysext/core/ext_tables.sql
+++ b/typo3/sysext/core/ext_tables.sql
@@ -25,7 +25,6 @@ CREATE TABLE be_groups (
        deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
        TSconfig text,
        subgroup text,
-       hide_in_lists tinyint(4) DEFAULT '0' NOT NULL,
        workspace_perms tinyint(3) DEFAULT '1' NOT NULL,
        category_perms text,
        PRIMARY KEY (uid),
@@ -37,14 +36,12 @@ CREATE TABLE be_groups (
 #
 CREATE TABLE be_sessions (
        ses_id varchar(32) DEFAULT '' NOT NULL,
-       ses_name varchar(32) DEFAULT '' NOT NULL,
        ses_iplock varchar(39) DEFAULT '' NOT NULL,
-       ses_hashlock int(11) DEFAULT '0' NOT NULL,
        ses_userid int(11) unsigned DEFAULT '0' NOT NULL,
        ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
        ses_data longblob,
        ses_backuserid int(11) NOT NULL default '0',
-       PRIMARY KEY (ses_id,ses_name),
+       PRIMARY KEY (ses_id),
        KEY ses_tstamp (ses_tstamp)
 );
 
@@ -128,10 +125,8 @@ CREATE TABLE pages (
        url varchar(255) DEFAULT '' NOT NULL,
        starttime int(11) unsigned DEFAULT '0' NOT NULL,
        endtime int(11) unsigned DEFAULT '0' NOT NULL,
-       urltype tinyint(4) unsigned DEFAULT '0' NOT NULL,
        shortcut int(10) unsigned DEFAULT '0' NOT NULL,
        shortcut_mode int(10) unsigned DEFAULT '0' NOT NULL,
-       no_cache int(10) unsigned DEFAULT '0' NOT NULL,
        fe_group varchar(100) DEFAULT '0' NOT NULL,
        subtitle varchar(255) DEFAULT '' NOT NULL,
        layout int(11) unsigned DEFAULT '0' NOT NULL,
@@ -175,7 +170,7 @@ CREATE TABLE sys_registry (
        uid int(11) unsigned NOT NULL auto_increment,
        entry_namespace varchar(128) DEFAULT '' NOT NULL,
        entry_key varchar(128) DEFAULT '' NOT NULL,
-       entry_value blob,
+       entry_value mediumblob,
        PRIMARY KEY (uid),
        UNIQUE KEY entry_identifier (entry_namespace,entry_key)
 );
@@ -313,7 +308,7 @@ CREATE TABLE sys_file_metadata (
        # Language fields
        sys_language_uid int(11) DEFAULT '0' NOT NULL,
        l10n_parent int(11) DEFAULT '0' NOT NULL,
-       l10n_diffsource mediumblob NOT NULL,
+       l10n_diffsource mediumblob,
 
        # Versioning fields
        t3ver_oid int(11) DEFAULT '0' NOT NULL,
@@ -398,7 +393,7 @@ CREATE TABLE sys_file_reference (
        # Language fields
        sys_language_uid int(11) DEFAULT '0' NOT NULL,
        l10n_parent int(11) DEFAULT '0' NOT NULL,
-       l10n_diffsource mediumblob NOT NULL,
+       l10n_diffsource mediumblob,
 
        # Reference fields (basically same as MM table)
        uid_local int(11) DEFAULT '0' NOT NULL,
@@ -411,7 +406,7 @@ CREATE TABLE sys_file_reference (
        # Local usage overlay fields
        title tinytext,
        description text,
-       alternative tinytext,
+       alternative text,
        link varchar(1024) DEFAULT '' NOT NULL,
        crop varchar(4000) DEFAULT '' NOT NULL,
        autoplay tinyint(4) DEFAULT '0' NOT NULL,
@@ -421,7 +416,8 @@ CREATE TABLE sys_file_reference (
        KEY tablenames_fieldname (tablenames(32),fieldname(12)),
        KEY deleted (deleted),
        KEY uid_local (uid_local),
-       KEY uid_foreign (uid_foreign)
+       KEY uid_foreign (uid_foreign),
+       KEY combined_1 (l10n_parent, t3ver_oid, t3ver_wsid, t3ver_state, deleted)
 );
 
 
@@ -533,19 +529,20 @@ CREATE TABLE sys_collection_entries (
 CREATE TABLE sys_history (
        uid int(11) unsigned NOT NULL auto_increment,
        pid int(11) unsigned DEFAULT '0' NOT NULL,
-       sys_log_uid int(11) DEFAULT '0' NOT NULL,
-       history_data mediumtext,
-       fieldlist text,
+       actiontype tinyint(3) DEFAULT '0' NOT NULL,
+       usertype varchar(2) DEFAULT 'BE' NOT NULL,
+       userid int(11) unsigned,
+       originaluserid int(11) unsigned,
        recuid int(11) DEFAULT '0' NOT NULL,
        tablename varchar(255) DEFAULT '' NOT NULL,
        tstamp int(11) DEFAULT '0' NOT NULL,
-       history_files mediumtext,
-       snapshot int(11) DEFAULT '0' NOT NULL,
+       history_data mediumtext,
+       workspace int(11) DEFAULT '0',
+
        PRIMARY KEY (uid),
        KEY parent (pid),
        KEY recordident_1 (tablename,recuid),
-       KEY recordident_2 (tablename,tstamp),
-       KEY sys_log_uid (sys_log_uid)
+       KEY recordident_2 (tablename,tstamp)
 ) ENGINE=InnoDB;
 
 #
@@ -580,12 +577,12 @@ CREATE TABLE sys_refindex (
        workspace int(11) DEFAULT '0' NOT NULL,
        ref_table varchar(255) DEFAULT '' NOT NULL,
        ref_uid int(11) DEFAULT '0' NOT NULL,
-       ref_string varchar(200) DEFAULT '' NOT NULL,
+       ref_string varchar(1024) DEFAULT '' NOT NULL,
 
        PRIMARY KEY (hash),
-       KEY lookup_rec (tablename,recuid),
-       KEY lookup_uid (ref_table,ref_uid),
-       KEY lookup_string (ref_string)
+       KEY lookup_rec (tablename(240),recuid),
+       KEY lookup_uid (ref_table(240),ref_uid),
+       KEY lookup_string (ref_string(255))
 );
 
 #
@@ -620,7 +617,8 @@ CREATE TABLE sys_log (
        KEY event (userid,event_pid),
        KEY recuidIdx (recuid,uid),
        KEY user_auth (type,action,tstamp),
-       KEY request (request_id)
+       KEY request (request_id),
+       KEY combined_1 (tstamp, type, userid)
 ) ENGINE=InnoDB;
 
 #
@@ -668,7 +666,7 @@ CREATE TABLE sys_category (
 
        sys_language_uid int(11) DEFAULT '0' NOT NULL,
        l10n_parent int(11) DEFAULT '0' NOT NULL,
-       l10n_diffsource mediumblob NOT NULL,
+       l10n_diffsource mediumblob,
 
        title tinytext NOT NULL,
        description text,