Modify

Opened 2 years ago

Closed 2 years ago

#2527 closed Erweiterung (fixed)

Installer erweitern um notwendige Spalten für Trusted Shops & ShopVote

Reported by: Torsten Riemer Owned by: somebody
Priority: normal Milestone: modified-shop-2.0.8.0
Component: Installer Version: trunk
Keywords: Cc:
Blocked By: Blocking:

Description

Wir sollten den Installer bzw. die "update_system.php" noch erweitern um die Ergäzung der notwendigen Spalten "external_id" & "external_source" sowie Indizes für die Trusted Shops & ShopVote Module.

Die Änderungen kamen in r15190 & r15195.

Alternativ wäre auch zu überlegen, ob wir die Datenbank-Erweiterung nicht einfach generell über die "update_2.0.7.2_to_2.0.8.0.sql" ausliefern:

ALTER TABLE `reviews` ADD `external_id` VARCHAR(256) DEFAULT NULL AFTER `reviews_status`;
ALTER TABLE `reviews` ADD `external_source` VARCHAR(32) DEFAULT NULL AFTER `external_id`;

ALTER TABLE `reviews` ADD INDEX `idx_external_id` (`external_id`);
ALTER TABLE `reviews` ADD INDEX `idx_external_source` (`external_source`);

Attachments (0)

Change History (1)

comment:1 by Gerhard Waldemair, 2 years ago

Resolution: fixed
Status: newclosed

In 15305:

fix #2527 - update installer for external reviews

Modify Ticket

Action
as closed The owner will remain somebody.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.