Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

replace left in xbt_peers since it's a reserved word #93

Open
VisiGod opened this issue Aug 19, 2020 · 3 comments
Open

replace left in xbt_peers since it's a reserved word #93

VisiGod opened this issue Aug 19, 2020 · 3 comments

Comments

@VisiGod
Copy link

VisiGod commented Aug 19, 2020

I would like to know if it's possible to replace the left field in xbt_peers with something else (left1 i.e.) since left is a reserved word for MySQL/MariaDB and it's impossible to update the tables via scripting.

The field is used on the tracker in the following files:
tracker.cpp
tracker.h
tracker_input.cpp
tracker_input.h
transaction.cpp
xbt_tracker.sql (not really used for compilation but it's the DB schema)

Note1: I think there's a restrition due to the bittorrent protocol itself use of the "left" field but wanted to know if there are alternatives...

@OlafvdSpek
Copy link
Owner

Table names can be quoted with backticks, doesn't that solve the problem in a script?

@VisiGod
Copy link
Author

VisiGod commented Aug 20, 2020

I know, just wanted to make sure the db was more standard. The left can be used to overcome that.

You may close the ticket if you do not wish to go on with it.

@OlafvdSpek
Copy link
Owner

It might be nice to have it configurable indeed..

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants