search

schlatt-co / stonks

Jschlatt sub server company management plugin
Apache License 2.0
3 stars 1 forks source link

Primary keys between HoldingsAccount and CompanyAccount are not unique #20

Closed Tsarcasm closed 4 years ago

Tsarcasm commented 4 years ago

This is a really big problem we need to fix asap. There needs to be one increment between the two tables, at the moment you can have two accounts with the same PK if they are in different tables.

Tsarcasm commented 4 years ago

Auto increment could be retrieved using a query like SHOW TABLE STATUS LIKE 'tableName'

Tsarcasm commented 4 years ago

Solved in 575ed9e158db2391a2ef6ecd749fc6fca46f84e4