Технические вопросы

Debug info: Table 'mdl_tool_dataprivacy_request' already exists
CREATE TABLE mdl_tool_dataprivacy_request (
id BIGINT(10) NOT NULL auto_increment,
type BIGINT(10) NOT NULL DEFAULT 0,
comments LONGTEXT COLLATE utf8mb4_unicode_ci,
commentsformat TINYINT(2) NOT NULL DEFAULT 0,
userid BIGINT(10) NOT NULL DEFAULT 0,
requestedby BIGINT(10) NOT NULL DEFAULT 0,
status TINYINT(2) NOT NULL DEFAULT 0,
dpo BIGINT(10) DEFAULT 0,
dpocomment LONGTEXT COLLATE utf8mb4_unicode_ci,
dpocommentformat TINYINT(2) NOT NULL DEFAULT 0,
usermodified BIGINT(10) NOT NULL DEFAULT 0,
timecreated BIGINT(10) NOT NULL DEFAULT 0,
timemodified BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_tooldatarequ_use3_ix (userid)
, KEY mdl_tooldatarequ_req2_ix (requestedby)
, KEY mdl_tooldatarequ_dpo2_ix (dpo)
, KEY mdl_tooldatarequ_use4_ix (usermodified)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Table for data requests'
;
CREATE TABLE mdl_tool_dataprivacy_purpose (
id BIGINT(10) NOT NULL auto_increment,
name VARCHAR(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
description LONGTEXT COLLATE utf8mb4_unicode_ci,
descriptionformat TINYINT(1),
lawfulbases LONGTEXT COLLATE utf8mb4_unicode_ci NOT NULL,
sensitivedatareasons LONGTEXT COLLATE utf8mb4_unicode_ci,
retentionperiod VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
protected TINYINT(1),
usermodified BIGINT(10) NOT NULL,
timecreated BIGINT(10) NOT NULL,
timemodified BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Data purposes'
;
CREATE TABLE mdl_tool_dataprivacy_category (
id BIGINT(10) NOT NULL auto_increment,
name VARCHAR(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
description LONGTEXT COLLATE utf8mb4_unicode_ci,
descriptionformat TINYINT(1),
usermodified BIGINT(10) NOT NULL,
timecreated BIGINT(10) NOT NULL,
timemodified BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Data categories'
;
CREATE TABLE mdl_tool_dataprivacy_ctxinstance (
id BIGINT(10) NOT NULL auto_increment,
contextid BIGINT(10) NOT NULL,
purposeid BIGINT(10),
categoryid BIGINT(10),
usermodified BIGINT(10) NOT NULL,
timecreated BIGINT(10) NOT NULL,
timemodified BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY mdl_tooldatactxi_con2_uix (contextid)
, KEY mdl_tooldatactxi_pur2_ix (purposeid)
, KEY mdl_tooldatactxi_cat2_ix (categoryid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Default comment for the table, please edit me'
;
CREATE TABLE mdl_tool_dataprivacy_ctxlevel (
id BIGINT(10) NOT NULL auto_increment,
contextlevel SMALLINT(3) NOT NULL,
purposeid BIGINT(10),
categoryid BIGINT(10),
usermodified BIGINT(10) NOT NULL,
timecreated BIGINT(10) NOT NULL,
timemodified BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY mdl_tooldatactxl_con2_uix (contextlevel)
, KEY mdl_tooldatactxl_cat2_ix (categoryid)
, KEY mdl_tooldatactxl_pur2_ix (purposeid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Default comment for the table, please edit me'
;
CREATE TABLE mdl_tool_dataprivacy_ctxexpired (
id BIGINT(10) NOT NULL auto_increment,
contextid BIGINT(10) NOT NULL,
status TINYINT(2) NOT NULL DEFAULT 0,
usermodified BIGINT(10) NOT NULL,
timecreated BIGINT(10) NOT NULL,
timemodified BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY mdl_tooldatactxe_con2_uix (contextid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Default comment for the table, please edit me'
;
CREATE TABLE mdl_tool_dataprivacy_contextlist (
id BIGINT(10) NOT NULL auto_increment,
component VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
timecreated BIGINT(10) NOT NULL DEFAULT 0,
timemodified BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='List of contexts for a component'
;
CREATE TABLE mdl_tool_dataprivacy_ctxlst_ctx (
id BIGINT(10) NOT NULL auto_increment,
contextid BIGINT(10) NOT NULL,
contextlistid BIGINT(10) NOT NULL,
status TINYINT(2) NOT NULL DEFAULT 0,
timecreated BIGINT(10) NOT NULL DEFAULT 0,
timemodified BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_tooldatactxlctx_con_ix (contextlistid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='A contextlist context item'
;
CREATE TABLE mdl_tool_dataprivacy_rqst_ctxlst (
id BIGINT(10) NOT NULL auto_increment,
requestid BIGINT(10) NOT NULL,
contextlistid BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_tooldatarqstctxl_req_ix (requestid)
, KEY mdl_tooldatarqstctxl_con_ix (contextlistid)
, UNIQUE KEY mdl_tooldatarqstctxl_reqco_uix (requestid, contextlistid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Association table joining requests and contextlists'
Error code: ddlexecuteerror

×Stack trace:

• line 492 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
• line 1070 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
• line 77 of /lib/ddl/database_manager.php: call to mysqli_native_moodle_database->change_database_structure()
• line 425 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
• line 370 of /lib/ddl/database_manager.php: call to database_manager->install_from_xmldb_structure()
• line 526 of /lib/upgradelib.php: call to database_manager->install_from_xmldb_file()
• line 1754 of /lib/upgradelib.php: call to upgrade_plugins()
• line 699 of /admin/index.php: call to upgrade_noncore()