Index: openacs-4/packages/views/sql/postgresql/views-datamodel.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/views/sql/postgresql/views-datamodel.sql,v
diff -u -r1.1 -r1.1.6.1
--- openacs-4/packages/views/sql/postgresql/views-datamodel.sql	20 May 2004 13:01:30 -0000	1.1
+++ openacs-4/packages/views/sql/postgresql/views-datamodel.sql	21 Jul 2006 11:32:44 -0000	1.1.6.1
@@ -12,26 +12,26 @@
 -- License.  Full text of the license is available from the GNU Project:
 -- http://www.fsf.org/copyleft/gpl.html
 
-create table views (
+create table views_views (
         object_id       integer
-                        constraint views_object_id_fk
+                        constraint views_views_object_id_fk
                         references acs_objects(object_id) on delete cascade
                         constraint views_object_id_nn
                         not null,
         viewer_id       integer
-                        constraint views_owner_id_fk
+                        constraint views_views_owner_id_fk
                         references parties(party_id) on delete cascade
-                        constraint views_viewer_id_nn
+                        constraint views_views_viewer_id_nn
                         not null,
-        views           integer default 1,
+        views_count     integer default 1,
         last_viewed     timestamptz default now(),
-        constraint views_pk 
+        constraint views_views_pk 
         primary key (object_id, viewer_id)
 );
 
-create unique index views_viewer_idx on views(viewer_id, object_id);
+create unique index views_views_viewer_idx on views_views(viewer_id, object_id);
 
-comment on table views is '
+comment on table views_views is '
         a simple count of how many times an object is viewed.
 ';
 
@@ -43,7 +43,7 @@
                         not null 
                         constraint view_aggregatess_pk 
                         primary key,
-        views           integer default 1,
+        views_count     integer default 1,
         unique_views    integer default 1,
         last_viewed     timestamptz default now()
 );
@@ -53,11 +53,3 @@
         trigger maintained by updates on views.
 ';
 
-
-
-
-
-
-
-
-