--
-- lars-blogger-create.sql
-- 
-- @author Lars Pind
-- @author Yon (Yon@milliped.com) Oracle Port
-- 
-- @cvs-id $Id: lars-blogger-create.sql,v 1.2.2.5 2003/07/01 13:28:25 simonc Exp $
--

declare
begin
    acs_object_type.create_type(
        object_type => 'pinds_blog_entry',
        pretty_name => 'Blog Entry',
        pretty_plural => 'Blog Entries',
        supertype => 'acs_object',
        table_name => 'pinds_blog_entries',
        id_column => 'entry_id',
        package_name => null,
        abstract_p => 'f',
        type_extension_table => null,
        name_method => 'pinds_blog_entry.title'
    );
end;
/
show errors

create table pinds_blog_entries (
    entry_id                    constraint pinds_blog_entry_id_fk
                                references acs_objects(object_id)
                                constraint pinds_blog_entries_pk
                                primary key,
    package_id                  constraint pinds_blog_entry_package_id_fk
                                references apm_packages(package_id),
    title                       varchar(500),
    content                     clob,
    content_format              varchar(50) 
                                default 'text/html'
                                constraint pinds_blog_entr_cnt_format_nn
                                not null,
    entry_date                  date,
    posted_date                 date,
    draft_p                     char(1) default 'f'
                                constraint pinds_blog_entries_draft_ck
                                check (draft_p in ('t','f')),
    deleted_p                   char(1) default 'f'
                                constraint pinds_blog_entries_deleted_ck
                                check (deleted_p in ('t','f'))
);

declare
begin
    acs_object_type.create_type(
        object_type => 'weblogger_channel',
        pretty_name => 'Weblogger Channel',
        pretty_plural => 'Weblogger Channels',
        supertype => 'acs_object',
        table_name => 'weblogger_channel',
        id_column => 'channel_id',
        package_name => null,
        abstract_p => 'f',
        type_extension_table => null,
        name_method => 'weblogger_channel.name'
    );
end;
/
show errors

create table weblogger_channels (
  channel_id    	        constraint weblogger_channels_cid_fk
                                references acs_objects(object_id)
                                constraint weblogger_channels_cid_pk
                                primary key,
  package_id                    constraint weblogger_channels_pid_kf
                                references apm_packages(package_id),
  user_id		        integer,
  constraint weblogger_chnls_package_user_un
  unique (package_id, user_id)
);


@@ lars-blogger-package-create
@@ rss-register
@@ notifications-init