Index: openacs-4/contrib/packages/portal/sql/postgresql/portal-core-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/portal/sql/postgresql/portal-core-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/packages/portal/sql/postgresql/portal-core-create.sql	25 Oct 2002 21:29:17 -0000	1.1
+++ openacs-4/contrib/packages/portal/sql/postgresql/portal-core-create.sql	25 Sep 2003 02:12:16 -0000	1.2
@@ -47,7 +47,7 @@
     description                     varchar(200)
 );
 
-comment on table portal_datasources '
+comment on table portal_datasources is '
 ';
 
 create table portal_datasource_parameters (
@@ -78,7 +78,7 @@
 
 );
 
-comment on table portal_datasource_parameters '
+comment on table portal_datasource_parameters is '
     maintains a set of default parameters for portal datsources. these
     are copied to a portal element when it is created.
 
@@ -100,15 +100,15 @@
                       |                   | default is provided.
 ';
 
-comment on column portal_datasource_parameters.config_required_p '
+comment on column portal_datasource_parameters.config_required_p is '
     this parameter requires configuration. if configured_p is true then no
     action is needed at portal element creation since the portal element
     can simply use the default value provided. if configured_p is false then
     the portal element must provide a value for this parameter at creation
     time.
 ';
 
-comment on column portal_datasource_parameters.configured_p '
+comment on column portal_datasource_parameters.configured_p is '
     if true then a default value is provided for this parameter.
 ';
 
@@ -128,13 +128,13 @@
     resource_dir                    varchar(200)
 );
 
-comment on table portal_layouts '
+comment on table portal_layouts is '
 ';
 
-comment on column portal_layouts.filename '
+comment on column portal_layouts.filename is '
 ';
 
-comment on column portal_layouts.resource_dir '
+comment on column portal_layouts.resource_dir is '
 ';
 
 create table portal_layout_regions (
@@ -151,10 +151,10 @@
     primary key (layout_id, region)
 );
 
-comment on table portal_layout_regions '
+comment on table portal_layout_regions is '
 ';
 
-comment on column portal_layout_regions.region '
+comment on column portal_layout_regions.region is '
 ';
 
 -- Themes are templates with decoration for PEs, nothing more.
@@ -175,13 +175,13 @@
     resource_dir                    varchar(200)
 );
 
-comment on table portal_themes '
+comment on table portal_themes is '
 ';
 
-comment on column portal_themes.filename '
+comment on column portal_themes.filename is '
 ';
 
-comment on column portal_themes.resource_dir '
+comment on column portal_themes.resource_dir is '
 ';
 
 -- Portals are essentially "containers" for PEs that bind to DSs.
@@ -208,10 +208,10 @@
                                     references portals (portal_id)
 );
 
-comment on table portals '
+comment on table portals is '
 ';
 
-comment on column portals.template_id '
+comment on column portals.template_id is '
 ';
 
 create table portal_pages (
@@ -243,10 +243,10 @@
 
 create index portal_pages_prtl_page_idx on portal_pages (portal_id, page_id);
 
-comment on table portal_pages '
+comment on table portal_pages is '
 ';
 
-comment on column portal_pages.sort_key '
+comment on column portal_pages.sort_key is '
 ';
 
 -- Support for multi-page portals (think my.yahoo.com)
@@ -305,13 +305,13 @@
     unique (page_id, name)
 );
 
-comment on table portal_elements '
+comment on table portal_elements is '
 ';
 
-comment on column portal_elements.sort_key '
+comment on column portal_elements.sort_key is '
 ';
 
-comment on column portal_elements.state '
+comment on column portal_elements.state is '
 ';
 
 create table portal_element_parameters (
@@ -344,11 +344,11 @@
 
 create index p_element_params_element_key_idx on portal_element_parameters (element_id, key);
 
-comment on table portal_element_parameters '
+comment on table portal_element_parameters is '
 ';
 
-comment on column portal_element_parameters.config_required_p '
+comment on column portal_element_parameters.config_required_p is '
 ';
 
-comment on column portal_element_parameters.configured_p '
+comment on column portal_element_parameters.configured_p is '
 ';
