From 0b8bc8b883e28dbee9eae7267ee29fb15f4dd9b5 Mon Sep 17 00:00:00 2001
From: zacheiss <zacheiss>
Date: Wed, 22 Aug 2001 08:05:44 +0000
Subject: [PATCH] Add contact and account_number fields to subnet table, to
 support private subnets.

---
 db/schema.sql | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

diff --git a/db/schema.sql b/db/schema.sql
index e6d31299..25b91ea3 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -93,8 +93,10 @@ 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,
+	status		INTEGER		DEFAULT 0	NOT NULL,
+	contact		VARCHAR(32)	DEFAULT CHR(0)	NOT NULL,
+	account_number	VARCHAR(10)	DEFAULT CHR(0)	NOT NULL,
 	saddr		INTEGER		DEFAULT 0	NOT NULL,
 	mask		INTEGER		DEFAULT 0	NOT NULL,
 	low		INTEGER		DEFAULT 0	NOT NULL,
-- 
2.45.1