sql statement for views / testing

diff --git a/dbscripts/create_views.sql b/dbscripts/create_views.sql
new file mode 100755 (executable)
index 0000000..2d70c9b
--- /dev/null
+++ b/dbscripts/create_views.sql
@@ -0,0 +1,14 @@
+--
+-- create_views.sql
+-- 
+
+
+-- TESTING:
+--
+-- creating list views in database to speed up selection of lists. 
+-- 
+
+
+CREATE VIEW v_content_list AS 
+       SELECT id, title, subtitle, date, place, creator, description, comment, is_published,
+                       is_produced, to_feature, webdb_create, webdb_lastchange FROM content;
\ No newline at end of file