Modify ↓

Opened 8 years ago

Closed 6 years ago

Last modified 6 years ago

#1284 closed Bug/Fehler (fixed)

database-design: Kein Primary-Key auf Table products_tags

Reported by: Volker Strähle Owned by: somebody
Priority: normal Milestone: modified-shop-2.0.5.0
Component: Shop Version: 2.0.3.0
Keywords: Cc:
Blocked By: Blocking:

Description

Warum ist da kein unique oder primary-key auf der Tabelle products_tags?

ALTER TABLE `products_tags` ADD UNIQUE( `products_id`, `options_id`, `values_id`, `products_options_id`);

sollte funktionieren.

Attachments (0)

Change History (5)

comment:1 by Torsten Riemer, 8 years ago

Milestone: modified-shop-2.0.4.0

comment:2 by Torsten Riemer, 6 years ago

Milestone: → modified-shop-2.0.5.0

comment:3 by Gerhard Waldemair, 6 years ago

Resolution: → fixed
Status: new → closed

In 11814:

fix #1284 & #1355 - add primary keys

comment:4 by Torsten Riemer, 6 years ago

In 11820:

Revised r11814 (fix #1284 & #1355 - add primary keys)

comment:5 by Torsten Riemer, 6 years ago

In 12059:

Revised r11814 (fix #1284 & #1355 - add primary keys)

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 .
Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.