|
|
| Reporter | Stefan Krenz | Assigned To | | |
|---|
| Priority | normal | Severity | major | Reproducibility | always |
|---|
| Status | resolved | Resolution | fixed | |
|---|
| Product Version | 4.7.0 / 5.0.0 revision 51243 | |
|---|
| Fixed in Version | 6.0.0-rc.2 | |
|---|
|
|
| Summary | 0005029: PrimaryKey in "oxstates" table only set on column "OXID" |
|---|
| Description | The primary key in the table "oxstates" is only set on the column "OXID", which includes only the abbreviation of the state.
If you have two states with the same abbreviation, but different countries, they can not be stored in the database. |
|---|
| Additional Information | The PK should be set on the column "OXCOUNTRYID" and "OXID" (in this order), to get really be unique. |
|---|
| Tags | No tags attached. |
|---|
|
|
| Theme | Azure |
|---|
| Browser | All |
|---|
| PHP Version | Not defined |
|---|
| Database Version | All |
|---|
|
|
