aboutsummaryrefslogblamecommitdiffstats
path: root/utility/truncate_script.sql
blob: d20a09505a1f2ed4cc8b5e9131f5c8e1c498c612 (plain) (tree)
1
2
3
4
5
6
7
8
9
                                              
                                                                   

                                                                  



                                                                  
                                                                     


                                                                              

                                                    
                                                         
                                                             




                                                                              




                                                                                  

                                                                     
                                                  
                                                     
DELETE FROM auth_group WHERE name='cct_users';
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 != 'mlemon';
DELETE FROM users_user WHERE username = 'inspector1';