From: zacheiss <zacheiss>
Date: Tue, 19 Dec 2000 07:33:04 +0000 (+0000)
Subject: Add billing_contact column to machine table.
X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/commitdiff_plain/d007b6bac056a53ed7d223b25f7d8fc676bf17bf?ds=sidebyside

Add billing_contact column to machine table.
---

diff --git a/db/schema.sql b/db/schema.sql
index 7073f68f..b756465c 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -63,6 +63,7 @@ create table machine
 	os		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
 	location	VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
 	contact		VARCHAR(32) 	DEFAULT CHR(0)	NOT NULL,
+	billing_contact	VARCHAR(32)	DEFAULT CHR(0)	NOT NULL,
 	use		INTEGER		DEFAULT 0	NOT NULL,
 	status		INTEGER		DEFAULT 0	NOT NULL,
 	statuschange	DATE    	DEFAULT SYSDATE	NOT NULL,