--
-- Copyright (C) 2001, 2002 MIT
--
-- 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 for more
-- details.
--
--
-- create portal defaults
--
-- @author arjun@openforce.net
-- @author yon@openforce.net
-- @creation-date 2001-10-01
-- @version $Id: defaults.sql,v 1.1.1.1 2002/10/25 21:29:17 yon Exp $
--
create function inline_0 ()
returns integer as '
declare
layout_id portal_layouts.layout_id%TYPE;
theme_id portal_themes.theme_id%TYPE;
begin
-- one-column layout, without a header.
layout_id := portal_layout__new(
''1_column'',
''A simple 1-column layout'',
''layouts/simple1'',
''layouts/components/simple1''
);
-- the supported regions for that layout.
perform portal_layout__add_region(layout_id, ''1'');
-- two-column layout, without a header.
layout_id := portal_layout__new(
''2_column'',
''A simple 2-column layout'',
''layouts/simple2'',
''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'');
-- same as above, only, three columns.
layout_id := portal_layout__new(
''3_column'',
''A simple 3-column layout'',
''layouts/simple3'',
''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'');
-- Now, some element themes.
theme_id := portal_theme__new(
''simple'',
''A simple red table-based theme'',
''themes/simple-theme'',
''themes/simple-theme''
);
theme_id := portal_theme__new(
''nada'',
''The un-theme. No graphics.'',
''themes/nada-theme'',
''themes/nada-theme''
);
theme_id := portal_theme__new(
''deco'',
''An Art Deco theme'',
''themes/deco-theme'',
''themes/deco-theme''
);
return 0;
end;' language 'plpgsql';
select inline_0();
drop function inline_0();