Task #45532 ยป fal_performance.diff
| t3lib/stddb/tables.sql | ||
|---|---|---|
|
processingfolder tinytext,
|
||
|
PRIMARY KEY (uid),
|
||
|
KEY parent (pid)
|
||
|
KEY parent (pid,deleted)
|
||
|
);
|
||
|
#
|
||
| ... | ... | |
|
alternative text,
|
||
|
PRIMARY KEY (uid),
|
||
|
KEY parent (pid),
|
||
|
KEY t3ver_oid (t3ver_oid,t3ver_wsid)
|
||
|
KEY parent (pid,deleted),
|
||
|
KEY t3ver_oid (t3ver_oid,t3ver_wsid),
|
||
|
KEY sel01 (storage,identifier(20)),
|
||
|
KEY sha1 (sha1(40))
|
||
|
);
|
||
|
#
|
||
| ... | ... | |
|
downloadname tinytext,
|
||
|
PRIMARY KEY (uid),
|
||
|
KEY uid_local (uid_local),
|
||
|
KEY uid_foreign (uid_foreign),
|
||
|
KEY parent (pid)
|
||
|
KEY parent (pid,deleted)
|
||
|
);
|
||
| ... | ... | |
|
folder text NOT NULL,
|
||
|
PRIMARY KEY (uid),
|
||
|
KEY parent (pid),
|
||
|
KEY parent (pid,deleted),
|
||
|
KEY t3ver_oid (t3ver_oid,t3ver_wsid)
|
||
|
);
|
||
| ... | ... | |
|
items int(11) DEFAULT '0' NOT NULL,
|
||
|
PRIMARY KEY (uid),
|
||
|
KEY parent (pid),
|
||
|
KEY parent (pid,deleted),
|
||
|
KEY t3ver_oid (t3ver_oid,t3ver_wsid)
|
||
|
);
|
||
| ... | ... | |
|
KEY uid_local_foreign (uid_local,uid_foreign),
|
||
|
KEY uid_foreign_tablenames (uid_foreign,tablenames)
|
||
|
);
|
||
|
);
|
||