Index: openacs-4/packages/lars-blogger/sql/oracle/lars-blogger-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/sql/oracle/lars-blogger-create.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/lars-blogger/sql/oracle/lars-blogger-create.sql	27 Jan 2003 16:17:55 -0000	1.3
+++ openacs-4/packages/lars-blogger/sql/oracle/lars-blogger-create.sql	28 Aug 2003 09:41:54 -0000	1.4
@@ -33,6 +33,7 @@
     package_id                  constraint pinds_blog_entry_package_id_fk
                                 references apm_packages(package_id),
     title                       varchar(500),
+    title_url                   varchar(500),
     content                     clob,
     content_format              varchar(50) 
                                 default 'text/html'
@@ -48,7 +49,37 @@
                                 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 => null
+    );
+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_pck_user_un
+  unique (package_id, user_id)
+);
+
+
 @@ lars-blogger-package-create
 @@ rss-register
 @@ notifications-init