Bug 12834

Summary:	oracle_setup.pl leaves out contract field from groups table
Product:	[Community] Bugzilla	Reporter:	amoore
Component:	Bugzilla General	Assignee:	David Lawrence <dkl>
Status:	CLOSED DEFERRED	QA Contact:	David Lawrence <dkl>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	2.8
Target Milestone:	---
Target Release:	---
Hardware:	i386
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2000-06-22 23:59:09 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description amoore 2000-06-22 23:59:07 UTC

The definition of the groups table in the oracle_setup.pl setup script
leaves out a column. It fails to create the "contract" field. near line 643
in the table definition for "groups" a line like:

contract    INTEGER      DEFAULT(0)";

needs to be inserted.

(this field is used by the AddGroup in the same script for example)

Comment 1 David Lawrence 2000-06-23 14:33:54 UTC

Thank you for bringing this to my attention. The oracle_setup.pl file is a
serious need of updating. I did the conversion of check_setup.pl (for Mysql) a
while back and then had to make a lot of changes to the database structure that
I have not had a chance to add them into the oracle_setup.pl script as of yet. I
will hopefully be finishing this up real soon now. Until then I recommend people
with database experience to use the .sql scripts located in the oracle sub
directory until then.

Comment 2 David Lawrence 2000-06-23 14:55:35 UTC

*** Bug 12835 has been marked as a duplicate of this bug. ***