Index: openacs-4/contrib/obsolete-packages/ticket-tracker/sql/postgresql/ticket-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker/sql/postgresql/ticket-create.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/ticket-tracker/sql/postgresql/ticket-create.sql	4 Jun 2001 16:53:27 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/ticket-tracker/sql/postgresql/ticket-create.sql	9 Jul 2001 16:18:59 -0000	1.2
@@ -9,93 +9,89 @@
 --
 -- @cvs-id $Id$
 --
+-- Ported to OpenACS - Vinod Kurup (vkurup@massmed.org)
+--
 
 ----------------------------------
 -- KNOWLEDGE LEVEL OBJECTS
 ----------------------------------
---declare
---    attr_id     acs_attributes.attribute_id%TYPE;
---begin
 
-    select acs_object_type__create_type (
-        'ttracker_ticket',
-        'Ticket Tracker Ticket',
-        'Ticket Tracker Tickets',
-        'acs_message',
-        'ttracker_tickets',
-        'ticket_id',
-        'ttracker_ticket',
-		'f',
-		null,
-        'ttracker_ticket.name'
-    );    
+select acs_object_type__create_type (
+	'ttracker_ticket',
+	'Ticket Tracker Ticket',
+	'Ticket Tracker Tickets',
+	'acs_message',
+	'ttracker_tickets',
+	'ticket_id',
+	'ttracker_ticket',
+	'f',
+	null,
+	'ttracker_ticket.name'
+);    
 
-    select acs_attribute__create_attribute (
-        'ttracker_ticket',
-        'category_id',
-        'integer',
-        'Category ID',
-        'Category IDs',
-		null,
-		null,
-		null,
-		1,
-		1,
-		null,
-		'type_specific',
-		'f'
-    );
+select acs_attribute__create_attribute (
+	'ttracker_ticket',
+	'category_id',
+	'integer',
+	'Category ID',
+	'Category IDs',
+	null,
+	null,
+	null,
+	1,
+	1,
+	null,
+	'type_specific',
+	'f'
+);
 
-    select acs_attribute__create_attribute (
-        'ttracker_ticket',
-        'subject',
-        'string',
-        'Subject',
-        'Subjects',
-		null,
-		null,
-		null,
-		1,
-		1,
-		null,
-		'type_specific',
-		'f'
-    );
+select acs_attribute__create_attribute (
+	'ttracker_ticket',
+	'subject',
+	'string',
+	'Subject',
+	'Subjects',
+	null,
+	null,
+	null,
+	1,
+	1,
+	null,
+	'type_specific',
+	'f'
+);
 
-    select acs_attribute__create_attribute (
-        'ttracker_ticket',
-        'severity',
-        'integer',
-        'Severity',
-        'Severities',
-		null,
-		null,
-		null,
-		1,
-		1,
-		null,
-		'type_specific',
-		'f'
-    );
+select acs_attribute__create_attribute (
+	'ttracker_ticket',
+	'severity',
+	'integer',
+	'Severity',
+	'Severities',
+	null,
+	null,
+	null,
+	1,
+	1,
+	null,
+	'type_specific',
+	'f'
+);
 
-    select acs_attribute__create_attribute (
-        'ttracker_ticket',
-        'priority',
-        'integer',
-        'Priority',
-        'Priorities',
-		null,
-		null,
-		null,
-		1,
-		1,
-		null,
-		'type_specific',
-		'f'
-    );
---end;
---/
---show errors
+select acs_attribute__create_attribute (
+	'ttracker_ticket',
+	'priority',
+	'integer',
+	'Priority',
+	'Priorities',
+	null,
+	null,
+	null,
+	1,
+	1,
+	null,
+	'type_specific',
+	'f'
+);
 
 ----------------------------------
 -- OPERATIONAL LEVEL
@@ -129,10 +125,12 @@
                      not null
 );
 
--- to prevent ttracker_tickets from getting locked when ttracker_categories table is being updated
+-- to prevent ttracker_tickets from getting locked 
+-- when ttracker_categories table is being updated
 create index tt_category_id_idx on ttracker_tickets (category_id);
 
--- to prevent ttracker_tickets from getting locked when persons table is being updated
+-- to prevent ttracker_tickets from getting locked 
+-- when persons table is being updated
 create index tt_creation_user_idx on ttracker_tickets (creation_user);
 
 comment on table ttracker_tickets is '