blob: b1b4386b3961427512e308e5a9e72d4dca0accb5 (
plain) (
blame)
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
|
TRUNCATE TABLE organisations_organisation RESTART IDENTITY CASCADE;
TRUNCATE TABLE organisations_person RESTART IDENTITY CASCADE;
TRUNCATE TABLE organisations_person_role RESTART IDENTITY CASCADE;
TRUNCATE TABLE organisations_mode RESTART IDENTITY CASCADE;
TRUNCATE TABLE organisations_role RESTART IDENTITY CASCADE;
TRUNCATE TABLE organisations_address RESTART IDENTITY CASCADE;
TRUNCATE TABLE organisations_addresstype RESTART IDENTITY CASCADE;
TRUNCATE TABLE organisations_incidentreport RESTART IDENTITY CASCADE;
TRUNCATE TABLE register_engagementevent_participants RESTART IDENTITY CASCADE;
TRUNCATE TABLE register_engagementtype RESTART IDENTITY CASCADE;
TRUNCATE TABLE register_engagementevent RESTART IDENTITY CASCADE;
TRUNCATE TABLE caf_grading RESTART IDENTITY CASCADE;
TRUNCATE TABLE caf_caf RESTART IDENTITY CASCADE;
TRUNCATE TABLE caf_documentfile RESTART IDENTITY CASCADE;
TRUNCATE TABLE caf_applicablesystem RESTART IDENTITY CASCADE;
TRUNCATE TABLE caf_filestore RESTART IDENTITY CASCADE;
TRUNCATE TABLE caf_documentfile RESTART IDENTITY CASCADE;
TRUNCATE TABLE register_engagementevent RESTART IDENTITY CASCADE;
TRUNCATE TABLE register_engagementtype RESTART IDENTITY CASCADE;
TRUNCATE TABLE register_engagementevent_participants RESTART IDENTITY CASCADE;
TRUNCATE TABLE assessments_cafcontributingoutcome RESTART IDENTITY CASCADE;
TRUNCATE TABLE assessments_cafobjective RESTART IDENTITY CASCADE;
TRUNCATE TABLE assessments_cafprinciple RESTART IDENTITY CASCADE;
TRUNCATE TABLE assessments_cafselfassessment RESTART IDENTITY CASCADE;
TRUNCATE TABLE assessments_cafselfassessmentoutcomescore RESTART IDENTITY CASCADE;
TRUNCATE TABLE assessments_achievementlevel RESTART IDENTITY CASCADE;
TRUNCATE TABLE assessments_igp RESTART IDENTITY CASCADE;
DELETE FROM users_user WHERE username != 'mrlemon';
DELETE FROM users_user WHERE username = 'inspector1';
DELETE FROM auth_group WHERE name='cct_users';
|
