Modify ↓

Opened 9 years ago

Closed 5 years ago

#1222 closed Frage (fixed)

Warum customers.refferers_id ist Varchar?

Reported by: INETvisio Owned by: somebody
Priority: normal Milestone: modified-shop-2.0.5.1
Component: Shop Version: 2.0.2.2
Keywords: Cc:
Blocked By: Blocking:

Description

Hallo,

Shop hat ?refID= String, der folgenden Felder entspricht: campaigns.campaigns_refID und orders.refferers_id.

Folgendes hat mir aufgefallen:

Tabelle: campaigns
1. campaigns_id INT(11) NOT NULL

  1. campaigns_refID VARCHAR(64) NOT NULL

Tabelle: orders

  1. refferers_id VARCHAR(32) NOT NULL

- Hier sollte VARCHAR(64) sein.

Tabelle: customers

  1. refferers_id VARCHAR(32) DEFAULT '0' NOT NULL

- Hier wird aber campaigns_id abgespeichert. Hier sollte es INT(11) sein.
Laut ​https://www.modified-shop.org/wiki/Customers wurde der Datentyp von INT auf VARCHAR ab Version 1.02 geändert. Gibt es wichtigen Grund dafür? Normalerweise, wenn man 2 Felder miteinander verknüpft, Datenbank sollte schneller sein, wenn die Typen gleich sind.

Gruß,
Jürgen H.

Attachments (0)

Change History (5)

comment:1 by Torsten Riemer, 9 years ago

Milestone: DB-Performance → modified-shop-2.0.3.0
Priority: niedrig → normal
Version: 2.0.4.0 → 2.0.2.2

comment:2 by Torsten Riemer, 8 years ago

Milestone: modified-shop-2.0.3.0 → modified-shop-2.0.3.1

comment:3 by Torsten Riemer, 8 years ago

Milestone: modified-shop-2.0.4.0

comment:4 by Torsten Riemer, 5 years ago

Milestone: → modified-shop-2.0.5.1

comment:5 by Gerhard Waldemair, 5 years ago

Resolution: → fixed
Status: new → closed

In 12666:

fix #1222 - update campaigns

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.