Danach kamen neue Felder und eine neue Tabelle hinzu.
Diese lassen sich über die folgenden SQL-Statements nachträglich anlegen:
Code: Alles auswählen
ALTER TABLE `phpbb_dl_versions` ADD COLUMN `ver_file_hash` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '';
ALTER TABLE `phpbb_dl_versions` ADD COLUMN `ver_text` mediumtext COLLATE utf8_bin NOT NULL;
ALTER TABLE `phpbb_dl_versions` ADD COLUMN `ver_uid` char(8) COLLATE utf8_bin NOT NULL DEFAULT '';
ALTER TABLE `phpbb_dl_versions` ADD COLUMN `ver_bitfield` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '';
ALTER TABLE `phpbb_dl_versions` ADD COLUMN `ver_flags` int(11) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_dl_versions` ADD COLUMN `ver_active` tinyint(1) unsigned NOT NULL DEFAULT '0';
CREATE TABLE `phpbb_dl_ver_files` (
`ver_file_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`dl_id` int(11) NOT NULL DEFAULT '0',
`ver_id` int(11) NOT NULL DEFAULT '0',
`real_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`file_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`file_title` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`file_type` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`ver_file_id`)
);