src/database/destroy.sql

   1 --
   2 -- Gnucomo database destruction script.
   3 --
   4 --
   5 -- This SQL script drops all tables and sequences from the database
   6 -- It is primarily used for testing, where we clean up after performing
   7 -- a test.
   8 --
   9 --
  10
  11 DROP SEQUENCE "action_actionid_seq";
  12
  13 DROP TABLE "action";
  14
  15 DROP SEQUENCE "action_user_actionstepid_seq";
  16
  17 DROP TABLE "action_user";
  18
  19 DROP SEQUENCE "log_logid_seq";
  20
  21 DROP TABLE "log";
  22
  23 DROP TABLE "log_adv";
  24
  25 DROP TABLE "log_notification";
  26
  27 DROP SEQUENCE "notification_notificationid_seq";
  28
  29 DROP TABLE "notification";
  30
  31 DROP SEQUENCE "object_objectid_seq";
  32
  33 DROP TABLE "object";
  34
  35 DROP TABLE "object_issue";
  36
  37 DROP TABLE "object_priority";
  38
  39 DROP TABLE "object_service";
  40
  41 DROP TABLE "object_system_user";
  42
  43 DROP TABLE "object_user";
  44
  45 DROP TABLE "priority";
  46
  47 DROP TABLE "service";
  48
  49 DROP TABLE "status";
  50
  51 DROP SEQUENCE "type_of_issue_type_of_issue_seq";
  52
  53 DROP TABLE "type_of_issue";
  54
  55 DROP SEQUENCE "unprocessed_l_unprocessedid_seq";
  56
  57 DROP TABLE "unprocessed_log";
  58
  59 DROP TABLE "user_gnucomo";
  60