| ChrisC | 5e9feb2 | 2017-06-21 02:38:57 -0700 | [diff] [blame] | 1 | # |
| Determe, Sebastien (sd378r) | b3a21f7 | 2017-08-08 02:58:27 -0700 | [diff] [blame^] | 2 | # Drop CLDS database objects (tables, etc.) |
| ChrisC | 5e9feb2 | 2017-06-21 02:38:57 -0700 | [diff] [blame] | 3 | # |
| 4 | |
| 5 | |
| 6 | ALTER TABLE template |
| 7 | DROP FOREIGN KEY template_image_id_fkey01; |
| 8 | ALTER TABLE template |
| 9 | DROP FOREIGN KEY template_bpmn_id_fkey01; |
| 10 | ALTER TABLE template |
| 11 | DROP FOREIGN KEY template_doc_id_fkey01; |
| Determe, Sebastien (sd378r) | b3a21f7 | 2017-08-08 02:58:27 -0700 | [diff] [blame^] | 12 | |
| ChrisC | 5e9feb2 | 2017-06-21 02:38:57 -0700 | [diff] [blame] | 13 | ALTER TABLE model |
| 14 | DROP FOREIGN KEY template_id_fkey01; |
| 15 | ALTER TABLE model |
| 16 | DROP FOREIGN KEY model_prop_id_fkey01; |
| 17 | ALTER TABLE model |
| 18 | DROP FOREIGN KEY model_blueprint_id_fkey01; |
| 19 | ALTER TABLE model |
| 20 | DROP FOREIGN KEY event_id_fkey01; |
| 21 | |
| Determe, Sebastien (sd378r) | b3a21f7 | 2017-08-08 02:58:27 -0700 | [diff] [blame^] | 22 | DROP TABLE clds_service_cache; |
| 23 | |
| ChrisC | 5e9feb2 | 2017-06-21 02:38:57 -0700 | [diff] [blame] | 24 | DROP TABLE model_instance; |
| 25 | DROP TABLE model_blueprint; |
| 26 | DROP TABLE model_properties; |
| 27 | DROP TABLE event; |
| 28 | DROP TABLE model; |
| 29 | |
| 30 | DROP TABLE template_doc; |
| 31 | DROP TABLE template_image; |
| 32 | DROP TABLE template_bpmn; |
| 33 | DROP TABLE template; |