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

There are Small errors on schema.sql #10

Open
2 tasks done
LaercioLeal opened this issue Dec 25, 2024 · 0 comments
Open
2 tasks done

There are Small errors on schema.sql #10

LaercioLeal opened this issue Dec 25, 2024 · 0 comments

Comments

@LaercioLeal
Copy link

LaercioLeal commented Dec 25, 2024

Before creating an issue, please ensure:

  • This is a bug in the software that resides in this repository, and not a
    support matter (use contact.millhiorebt.com for support)
  • This issue is reproducible without changes to the C++ code in this repository

Steps to reproduce (include any configuration/script required to reproduce)

  1. Create a new database. I use xampp
  2. Import the Schema.sql on main.

Expected behaviour

Create all table without errors

Actual behaviour

Many errors in different tables.
On table players:
randomizeshader tinyint NOT NULL DEFAULT '0'; (line 43)
Remove the ; and put a ,

On table player_mounts:
ADD PRIMARY KEY (player_id, mount_id) (line 357)
Should not have this "ADD"
And has 2 player_mounts creation code, line 354 and 382

On table player_shaders:
shader_id smallint(5) UNSIGNED NOT NULL DEFAULT 0 (line 405)
Need a , at the end

I think this is all. Thanks.

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

1 participant