diff options
| author | Matthew Lemon <lemon@matthewlemon.com> | 2020-05-25 20:21:06 +0100 |
|---|---|---|
| committer | Matthew Lemon <lemon@matthewlemon.com> | 2020-05-25 20:21:06 +0100 |
| commit | 73fb885d219f53380f66eb244bab6ebc95dc27fd (patch) | |
| tree | 79fab1203928d645c24cfd459b21e5604ddc5fd1 /utility/truncate_script.sql | |
| parent | c0e528b0826877dbd132e533c406dd0d5d09bb6e (diff) | |
fixed trunc and populate script and user generation
Diffstat (limited to 'utility/truncate_script.sql')
| -rw-r--r-- | utility/truncate_script.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/utility/truncate_script.sql b/utility/truncate_script.sql index 864b99f..3ddebcf 100644 --- a/utility/truncate_script.sql +++ b/utility/truncate_script.sql @@ -12,6 +12,11 @@ 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; @@ -19,4 +24,5 @@ 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; +TRUNCATE TABLE users_user RESTART IDENTITY CASCADE; DELETE FROM users_user WHERE username != 'mrlemon'; |