ice-breaker/clear_db.sql at main · CodeX-SIT/ice-breaker · 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
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
DELETE FROM about_user;
DELETE FROM accounts;
DELETE FROM avatars;
DELETE FROM assigned;
DELETE FROM game_codes;
DELETE FROM selfies;
DELETE FROM sessions;
DELETE FROM sqlite_sequence
WHERE name = 'accounts';
DELETE FROM sqlite_sequence
WHERE name = 'game_codes';
DELETE FROM sqlite_sequence
WHERE name = 'sessions';
DELETE FROM sqlite_sequence
WHERE name = 'user_games';
DELETE FROM sqlite_sequence
WHERE name = 'users';
DELETE FROM sqlite_sequence
WHERE name = 'verification_tokens';
DELETE FROM user_games;
DELETE FROM users;
DELETE FROM verification_tokens;
-- If you also want to reset the sequence values, you need to use the following command
-- SQLite does not automatically reset the sequence when you delete all rows, so you need to manually update the sequence if necessary:
UPDATE sqlite_sequence
SET seq = 0
WHERE name = 'accounts';
UPDATE sqlite_sequence
SET seq = 0
WHERE name = 'game_codes';
UPDATE sqlite_sequence
SET seq = 0
WHERE name = 'sessions';
UPDATE sqlite_sequence
SET seq = 0
WHERE name = 'user_games';
UPDATE sqlite_sequence
SET seq = 0
WHERE name = 'users';
UPDATE sqlite_sequence
SET seq = 0
WHERE name = 'verification_tokens';