Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- afficher nom du groupe
- SELECT group_name
- FROM `group`
- WHERE group_id = 1;
- -- afficher theme, deadline, rule battle
- SELECT t.theme_name, b.deadline, r.rule_name
- FROM theme AS t
- JOIN battle AS b
- ON b.theme_id = t.theme_id
- JOIN battle_rule AS br
- ON br.battle_id = b.battle_id
- JOIN rule AS r
- ON r.rule_id = br.rule_id
- WHERE b.battle_id = 1;
- -- lier une battle a des users
- INSERT INTO user_battle
- VALUES(1, 1), (2, 1);
- -- afficher les participants
- SELECT * FROM user AS u
- JOIN user_battle AS ub
- ON ub.user_id = u.user_id
- JOIN battle AS b
- ON b.battle_id = ub.battle_id
- WHERE b.battle_id = 1;
- -- afficher les participants qui ont posté une photo
- SELECT
- -- poster une photo
- INSERT INTO photo (url, create_date, user_id, battle_id, group_id)
- VALUES('https://cdn.pixabay.com/photo/2015/11/16/16/28/bird-1045954_1280.jpg', NOW(), 1, 1, 1);
- -- modifier une photo
- -supprimer une photo
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement