Opened 4 years ago

Closed 22 months ago

Last modified 22 months ago

#1284 closed Bug/Fehler (fixed)

database-design: Kein Primary-Key auf Table products_tags

Reported by: webald Owned by: somebody
Priority: normal Milestone: modified-shop-2.0.5.0
Component: Shop Version: 2.0.3.0

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 Changed 3 years ago by Tomcraft

  • Milestone modified-shop-2.0.4.0 deleted

comment:2 Changed 22 months ago by Tomcraft

  • Milestone set to modified-shop-2.0.5.0

comment:3 Changed 22 months ago by GTB

  • Resolution set to fixed
  • Status changed from new to closed

In 11814:

fix #1284 & #1355 - add primary keys

comment:4 Changed 22 months ago by Tomcraft

In 11820:

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

comment:5 Changed 22 months ago by Tomcraft

In 12059:

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

Add Comment

Modify Ticket

Action
as closed
The resolution will be deleted. Next status will be 'reopened'
Author


E-mail address and user name can be saved in the Preferences.

Attachments ↑
 
Note: See TracTickets for help on using tickets.