summaryrefslogtreecommitdiffstats
path: root/db_demo/sql/soft_drop.sql
diff options
context:
space:
mode:
authorWilrik de Loose <wilrik@wilrik.nl>2008-05-27 09:50:18 (GMT)
committerWilrik de Loose <wilrik@wilrik.nl>2008-05-27 09:50:18 (GMT)
commite2b5d9764888e0f307ebcdf9c20835b197a0f63c (patch)
tree00bf9c6fbc7dae49d14ac91d44fe5e3f20d1454d /db_demo/sql/soft_drop.sql
parent9b5236ed96a79e0fe979e2d7a7bc7173170af6cf (diff)
download2iv55-e2b5d9764888e0f307ebcdf9c20835b197a0f63c.zip
2iv55-e2b5d9764888e0f307ebcdf9c20835b197a0f63c.tar.gz
2iv55-e2b5d9764888e0f307ebcdf9c20835b197a0f63c.tar.bz2
db functies
Diffstat (limited to 'db_demo/sql/soft_drop.sql')
-rw-r--r--db_demo/sql/soft_drop.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/db_demo/sql/soft_drop.sql b/db_demo/sql/soft_drop.sql
new file mode 100644
index 0000000..2a8490c
--- /dev/null
+++ b/db_demo/sql/soft_drop.sql
@@ -0,0 +1,10 @@
+-- drop views (3)
+DROP VIEW vw_turn;
+DROP VIEW vw_test;
+DROP VIEW vw_person;
+
+-- drop functions (4)
+DROP FUNCTION insert_person (boolean, boolean, integer);
+DROP FUNCTION insert_results (boolean, boolean, integer, boolean[], boolean[], boolean[], integer[], time[][], integer[][], integer[][]);
+DROP FUNCTION insert_test (integer, boolean, boolean, boolean, integer);
+DROP FUNCTION insert_turn (integer, time, integer, integer);