ChatAppServer/SetupContacts.sql at main · CodiChun/ChatAppServer · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
--Remove all contcts
DELETE FROM Contacts;


--Add the relationship between test1 and test2
INSERT INTO
    Contacts(memberid_a, memberid_b, verified)
VALUES
    ((SELECT MemberID from Members WHERE Email='test1@test.com'),
    (SELECT MemberID from Members WHERE Email='test2@test.com'), 1);


--Add the relationship between test1 and test3
INSERT INTO
    Contacts(memberid_a, memberid_b, verified)
VALUES
    ((SELECT MemberID from Members WHERE Email='test1@test.com'),
    (SELECT MemberID from Members WHERE Email='test3@test.com'), 1);

--Add the relationship between test2 and test3
INSERT INTO
    Contacts(memberid_a, memberid_b, verified)
VALUES
    ((SELECT MemberID from Members WHERE Email='test2@test.com'),
    (SELECT MemberID from Members WHERE Email='test3@test.com'), 1);