From 398885eb67c3a29b3912e2b0fe154e4f938759b9 Mon Sep 17 00:00:00 2001 From: Étienne Loks Date: Mon, 26 Sep 2011 12:13:59 +0200 Subject: Update documentation --- database/views.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 database/views.sql (limited to 'database/views.sql') diff --git a/database/views.sql b/database/views.sql new file mode 100644 index 000000000..a924fbfc0 --- /dev/null +++ b/database/views.sql @@ -0,0 +1,15 @@ +create view file_department (id, department_id, file_id) as + select town."id", town."departement_id", file_towns."file_id" + from ishtar_base_town town + inner join ishtar_base_file_towns file_towns on + file_towns."town_id"=town."id" order by town."departement_id"; +CREATE RULE file_department_delete + AS ON DELETE TO file_department DO INSTEAD(); +create view operation_department (id, department_id, operation_id) as + select town."id", town."departement_id", operation_towns."operation_id" + from ishtar_base_town town + inner join ishtar_base_operation_towns operation_towns on + operation_towns."town_id"=town."id" order by town."departement_id"; +CREATE RULE operation_department_delete + AS ON DELETE TO operation_department DO INSTEAD(); + -- cgit v1.2.3