some things don't need to be primary keys
@@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS users (
);
CREATE TABLE IF NOT EXISTS items (
- uid BIGINT PRIMARY KEY NOT NULL, -- owner of the item
+ uid BIGINT NOT NULL, -- owner of the item
name VARCHAR(250) NOT NULL, -- name of the item
sell_price BIGINT, -- sell price for ONE of that item
amount BIGINT NOT NULL, -- amount of the item
@@ -43,25 +43,25 @@ CREATE TABLE IF NOT EXISTS leaderboards ( -- there are more leaderboards than th
);
CREATE TABLE IF NOT EXISTS warnings ( -- moderation warnings
- uid BIGINT PRIMARY KEY NOT NULL, -- receiver of the warning
+ uid BIGINT NOT NULL, -- receiver of the warning
gid BIGINT NOT NULL, -- guild in which the warning was done
mod_id BIGINT NOT NULL, -- moderator who did the warning
reason VARCHAR(250) NOT NULL -- reason for the warning, null for no reason
);
CREATE TABLE IF NOT EXISTS mcservers ( -- used in /randommc command
- owner_id BIGINT PRIMARY KEY NOT NULL, -- discord owner id of the server
+ owner_id BIGINT NOT NULL, -- discord owner id of the server
host VARCHAR(100), -- hostname/ip/address of server
link VARCHAR(250) -- learn more link
);
CREATE TABLE IF NOT EXISTS disabled (
- gid BIGINT PRIMARY KEY NOT NULL,
+ gid BIGINT NOT NULL,
cmd VARCHAR(20) NOT NULL
);
CREATE TABLE IF NOT EXISTS user_rcon (
- uid BIGINT PRIMARY KEY NOT NULL,
+ uid BIGINT NOT NULL,
mcserver VARCHAR(50),
rcon_port INT,
password VARCHAR(300)
