diff options
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/database.sql b/database.sql index 36beec8..a92ad46 100644 --- a/database.sql +++ b/database.sql @@ -87,6 +87,12 @@ CREATE TABLE IF NOT EXISTS badges ( created_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP ); +CREATE TABLE IF NOT EXISTS user_badges ( + id CHAR(32) NOT NULL PRIMARY KEY DEFAULT REPLACE(UUID(),'-',''), + user_id CHAR(32) NOT NULL REFERENCES users(id) ON DELETE CASCADE, + badge_id CHAR(32) NOT NULL REFERENCES badges(id) ON DELETE CASCADE +); + CREATE TABLE IF NOT EXISTS roles ( id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, priority INTEGER NOT NULL DEFAULT 0, |