From: zacheiss <zacheiss>
Date: Mon, 20 Aug 2001 08:12:26 +0000 (+0000)
Subject: Add new columns and tables for IP address billing support:
X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/commitdiff_plain/8b656b149b754233faaa67dfd5d47cf25e70ba4a

Add new columns and tables for IP address billing support:

- machine table gets an account_number column.

- subnet table gets a status column.

- add an accountnumbers table containing all valid account numbers that
  can be billed.
---

diff --git a/db/schema.sql b/db/schema.sql
index 5a5ed49a..e6d31299 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -64,6 +64,7 @@ create table machine
 	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,
+	account_number	VARCHAR(10)	DEFAULT CHR(0)	NOT NULL,	
 	use		INTEGER		DEFAULT 0	NOT NULL,
 	status		INTEGER		DEFAULT 0	NOT NULL,
 	statuschange	DATE    	DEFAULT SYSDATE	NOT NULL,
@@ -92,6 +93,7 @@ create table subnet
 (
 	name		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
 	snet_id		INTEGER		DEFAULT 0	NOT NULL,
+	status		INTEGER		DEFAULT 0	NOT NULL,
 	description	VARCHAR(48) 	DEFAULT CHR(0)	NOT NULL,
 	saddr		INTEGER		DEFAULT 0	NOT NULL,
 	mask		INTEGER		DEFAULT 0	NOT NULL,
@@ -417,3 +419,8 @@ create table mcntmap
 	mach_id		INTEGER		DEFAULT 0	NOT NULL,
 	cnt_id		INTEGER		DEFAULT 0	NOT NULL
 );
+
+create table accountnumbers
+(
+	account_number	VARCHAR(10)	DEFAULT CHR(0)	NOT NULL
+);
diff --git a/db/unschema.sql b/db/unschema.sql
index 5d90174a..3a7bab58 100644
--- a/db/unschema.sql
+++ b/db/unschema.sql
@@ -30,3 +30,4 @@ drop table usersids;
 drop table listsids;
 drop table containers;
 drop table mcntmap;
+drop table accountnumbers;