aboutsummaryrefslogtreecommitdiffstats
path: root/utility/truncate_script.sql
blob: 929cd9a19dafcea7688e7d500431ac9c8551fcab (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
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 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_essentialservice RESTART IDENTITY CASCADE;
DELETE FROM users_user WHERE username != 'mrlemon';