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.2.2.3 -r1.2.2.4
--- openacs-4/packages/lars-blogger/sql/oracle/lars-blogger-create.sql	13 Jun 2003 09:15:00 -0000	1.2.2.3
+++ openacs-4/packages/lars-blogger/sql/oracle/lars-blogger-create.sql	13 Jun 2003 13:51:00 -0000	1.2.2.4
@@ -48,7 +48,35 @@
                                 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		
+);
+
+
 @@ lars-blogger-package-create
 @@ rss-register
 @@ notifications-init
