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.

Sign up for GitHub

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

fix some error #3819

Open
wants to merge 1 commit into
base: master
Choose a base branch
from
Open

fix some error #3819

Changes from all commits
Commits
Show all changes
1 commit
Select commit
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
9 changes: 5 additions & 4 deletions priv/mysql.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -321,8 +321,8 @@ CREATE TABLE muc_light_rooms(
luser VARCHAR(250) NOT NULL,
lserver VARCHAR(250) NOT NULL,
version VARCHAR(20) NOT NULL,
PRIMARY KEY (lserver, luser),
UNIQUE KEY k_id USING HASH (id)
PRIMARY KEY (id),
UNIQUE KEY (lserver, luser)
) CHARACTER SET utf8mb4
ROW_FORMAT=DYNAMIC;

Expand Down Expand Up @@ -359,11 +359,12 @@ CREATE TABLE muc_light_blocking(
CREATE INDEX i_muc_light_blocking_su USING BTREE ON muc_light_blocking(lserver, luser);

CREATE TABLE muc_rooms(
id SERIAL,
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
Copy link

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

https://dev.mysql.com/doc/refman/8.4/en/numeric-type-syntax.html
Please have a look SERIAL have same meaning.

muc_host VARCHAR(250) NOT NULL,
room_name VARCHAR(250) NOT NULL,
options JSON NOT NULL,
PRIMARY KEY (muc_host, room_name)
PRIMARY KEY (id),
UNIQUE KEY (muc_host, room_name)
);

CREATE TABLE muc_room_aff(
Expand Down