ipa_haller_jan: QFQ-Wiki. refs #15634

ipa_haller_jan: QFQ-Wiki. refs #15634

extension/Classes/Sql/qfqDefaultTables.sql

@@ -308,9 +308,22 @@ CREATE TABLE IF NOT EXISTS `WikiPage`
     `created`       DATETIME                            NOT NULL DEFAULT CURRENT_TIMESTAMP,
 
     PRIMARY KEY (`id`),
-    FOREIGN KEY (`wpIdParent`) REFERENCES `WikiPage` (`id`),
-    FOREIGN KEY (`wpIdCurrent`) REFERENCES `WikiPage` (`id`)
 )
+    ENGINE=InnoDB
+    DEFAULT CHARSET = utf8mb4
+    AUTO_INCREMENT = 0;
+
+CREATE TABLE IF NOT EXISTS `WikiAttachment`
+(
+    `id`            INT(11)                             NOT NULL AUTO_INCREMENT,
+    `wpId`          INT(11)                             NOT NULL,
+    `feUser`        VARCHAR(64)                         NOT NULL,
+    `pathFileName`  VARCHAR(512)                        NOT NULL,
+    `modified`      DATETIME                            NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+    `created`       DATETIME                            NOT NULL DEFAULT CURRENT_TIMESTAMP,
+
+    PRIMARY KEY (`id`)
+    )
     ENGINE=InnoDB
     DEFAULT CHARSET = utf8mb4
     AUTO_INCREMENT = 0;
\ No newline at end of file