53 lines
1.6 KiB
SQL
53 lines
1.6 KiB
SQL
CREATE TABLE MUSIC
|
|
(
|
|
musicID SERIAL NOT NULL,
|
|
musicSourceURL TEXT NOT NULL,
|
|
musicUserRequesterID BIGINT NOT NULL, -- TO BE TRANSMUTED TO U64 ?
|
|
PRIMARY KEY (musicid)
|
|
);
|
|
|
|
CREATE TABLE MUSIC_INFO
|
|
(
|
|
musicInfoSourceURL TEXT NOT NULL,
|
|
musicInfoTitle TEXT NOT NULL,
|
|
musicInfoThumbnailURL TEXT,
|
|
musicInfoLength INTEGER NOT NULL,
|
|
musicInfoMusicID INTEGER NOT NULL,
|
|
PRIMARY KEY (musicInfoSourceURL)
|
|
);
|
|
|
|
CREATE TABLE MUSIC_SESSION
|
|
(
|
|
musicSessionID SERIAL NOT NULL,
|
|
musicSessionCurrentPlayingIndex SMALLINT DEFAULT 0, -- START FROM 0
|
|
musicSessionGuildID BIGINT NOT NULL,
|
|
musicSessionTextChannelID BIGINT NOT NULL,
|
|
musicSessionPlayingChannelID BIGINT NOT NULL,
|
|
PRIMARY KEY (musicsessionid)
|
|
);
|
|
|
|
CREATE TABLE MUSIC_SESSION_LIST
|
|
(
|
|
musicSessionID INTEGER NOT NULL,
|
|
musicID INTEGER NOT NULL,
|
|
musicSessionListIndex SMALLINT NOT NULL,
|
|
PRIMARY KEY (musicSessionID, musicID, musicSessionListIndex)
|
|
);
|
|
|
|
CREATE TABLE SETTINGS
|
|
(
|
|
settingsGuildID BIGINT NOT NULL,
|
|
settingsMuteRoleID BIGINT,
|
|
settingsRouletteKickEnabled BOOLEAN DEFAULT FALSE,
|
|
settingsLogChannelID BIGINT,
|
|
PRIMARY KEY (settingsGuildID)
|
|
);
|
|
|
|
ALTER TABLE MUSIC_INFO
|
|
ADD FOREIGN KEY (musicInfoMusicID) REFERENCES MUSIC (musicID);
|
|
|
|
ALTER TABLE MUSIC_SESSION_LIST
|
|
ADD FOREIGN KEY (musicID) REFERENCES MUSIC (musicID);
|
|
|
|
ALTER TABLE MUSIC_SESSION_LIST
|
|
ADD FOREIGN KEY (musicSessionID) REFERENCES MUSIC_SESSION (musicSessionID); |