Index: openacs-4/packages/new-portal/sql/postgresql/defaults.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/sql/postgresql/defaults.sql,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/new-portal/sql/postgresql/defaults.sql 11 Jun 2002 04:18:08 -0000 1.2 +++ openacs-4/packages/new-portal/sql/postgresql/defaults.sql 1 Jul 2002 20:03:25 -0000 1.3 @@ -1,80 +1,94 @@ -- +-- Copyright(C) 2001, 2002 OpenForce, Inc. +-- +-- This file is part of dotLRN. +-- +-- dotLRN is free software; you can redistribute it and/or modify it under the +-- terms of the GNU General Public License as published by the Free Software +-- Foundation; either version 2 of the License, or(at your option) any later +-- version. +-- +-- dotLRN is distributed in the hope that it will be useful, but WITHOUT ANY +-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS +-- FOR A PARTICULAR PURPOSE. See the GNU General Public License foreign key more +-- details. +-- + +-- -- The New Portal Package --- copyright 2001, OpenForce, Inc. --- distributed under the GNU GPL v2 -- --- Arjun Sanyal (arjun@openforce.net) --- $Id$ +-- @author Arjun Sanyal(arjun@openforce.net) +-- @version $Id$ -- - --- ampersands break if I don't do this. --- set scan off - --- Insert some default templates. create function inline_0 () returns integer as ' declare - layout_id portal_layouts.layout_id%TYPE; - theme_id portal_element_themes.theme_id%TYPE; + layout_id portal_layouts.layout_id%TYPE; + theme_id portal_element_themes.theme_id%TYPE; begin + -- two-column layout, without a header. + layout_id := portal_layout__new( + ''Simple 2-Column'', + ''A simple 2-column layout'', + ''layouts/simple2'', + ''layouts/components/simple2'' + ); --- two-column layout, without a header. - layout_id := portal_layout__new ( - /* name */ ''Simple 2-Column'', - /* description */ ''A simple 2-column layout'', - /* filename */ ''layouts/simple2'', - /* resource_dir */ ''layouts/components/simple2''); + -- the supported regions for that layout. + perform portal_layout__add_region(layout_id, ''1''); + perform portal_layout__add_region(layout_id, ''2''); --- the supported regions for that layout. - perform portal_layout__add_region (/* layout_id */ layout_id, /* region */ ''1''); - perform portal_layout__add_region (/* layout_id */ layout_id, /* region */ ''2''); + -- one-column layout, without a header. + layout_id := portal_layout__new( + ''Simple 1-Column'', + ''A simple 1-column layout'', + ''layouts/simple1'', + ''layouts/components/simple1'' + ); --- one-column layout, without a header. - layout_id := portal_layout__new ( - /* name */ ''Simple 1-Column'', - /* description */ ''A simple 1-column layout'', - /* filename */ ''layouts/simple1'', - /* resource_dir */ ''layouts/components/simple1''); + -- the supported regions for that layout. + perform portal_layout__add_region(layout_id, ''1''); --- the supported regions for that layout. - perform portal_layout__add_region (/* layout_id */ layout_id, /* region */ ''1''); + -- same as above, only, three columns. + layout_id := portal_layout__new( + ''Simple 3-Column'', + ''A simple 3-column layout'', + ''layouts/simple3'', + ''layouts/components/simple3'' + ); --- same as above, only, three columns. - layout_id := portal_layout__new ( - /* name */ ''Simple 3-Column'', - /* description */ ''A simple 3-column layout'', - /* filename */ ''layouts/simple3'', - /* resource_dir */ ''layouts/components/simple3''); + perform portal_layout__add_region(layout_id, ''1''); + perform portal_layout__add_region(layout_id, ''2''); + perform portal_layout__add_region(layout_id, ''3''); - perform portal_layout__add_region (/* layout_id */ layout_id, /* region */ ''1''); - perform portal_layout__add_region (/* layout_id */ layout_id, /* region */ ''2''); - perform portal_layout__add_region (/* layout_id */ layout_id, /* region */ ''3''); + -- Now, some element themes. + theme_id := portal_element_theme__new( + ''simple'', + ''A simple red table-based theme'', + ''themes/simple-theme'', + ''themes/simple-theme'' + ); --- Now, some element themes. + theme_id := portal_element_theme__new( + ''nada'', + ''The un-theme. No graphics.'', + ''themes/nada-theme'', + ''themes/nada-theme'' + ); - theme_id := portal_element_theme__new ( - /* name */ ''simple'', - /* description */ ''A simple red table-based theme'', - /* filename */ ''themes/simple-theme'', - /* resource_dir */ ''themes/simple-theme''); + theme_id := portal_element_theme__new( + ''deco'', + ''An Art Deco theme'', + ''themes/deco-theme'', + ''themes/deco-theme'' + ); - theme_id := portal_element_theme__new ( - /* name */ ''nada'', - /* description */ ''The un-theme. No graphics.'', - /* filename */ ''themes/nada-theme'', - /* resource_dir */ ''themes/nada-theme''); - - theme_id := portal_element_theme__new ( - /* name */ ''deco'', - /* description */ ''An Art Deco theme'', - /* filename */ ''themes/deco-theme'', - /* resource_dir */ ''themes/deco-theme''); - return 0; end;' language 'plpgsql'; -select inline_0 (); -drop function inline_0 (); +select inline_0(); + +drop function inline_0();