From 067d82355ab83b5232bbd3a006542d8026dd4253 Mon Sep 17 00:00:00 2001 From: rk Date: Sat, 26 Jan 2002 13:47:19 +0000 Subject: [PATCH] sql statement for views / testing --- dbscripts/create_views.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100755 dbscripts/create_views.sql diff --git a/dbscripts/create_views.sql b/dbscripts/create_views.sql new file mode 100755 index 00000000..2d70c9b7 --- /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 -- 2.11.0