[1319] in Moira

home help back first fref pref prev next nref lref last post

change to schema

daemon@ATHENA.MIT.EDU (Garry Zacheiss)
Fri Feb 4 01:35:36 2000

Message-Id: <200002040635.BAA09500@mary-kay-commandos.mit.edu>
To: moiradev@MIT.EDU
Date: Fri, 04 Feb 2000 01:35:33 -0500
From: Garry Zacheiss <zacheiss@MIT.EDU>

	To have the hesiod cluster data for the new Linux-athena
machines fit in the svc table, we need to make a column bigger.  I'll
have a convenient chance to deploy this change when the moira server is
upgraded soon.

Garry

Index: db/schema.sql
===================================================================
RCS file: /afs/athena.mit.edu/astaff/project/moiradev/repository//moira/db/schema.sql,v
retrieving revision 1.13
diff -c -r1.13 schema.sql
*** schema.sql	1999/11/16 04:27:26	1.13
--- schema.sql	2000/02/04 06:32:43
***************
*** 124,130 ****
  (
  	clu_id		INTEGER		DEFAULT 0	NOT NULL,
  	serv_label	VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
! 	serv_cluster	VARCHAR(32) 	DEFAULT CHR(0)	NOT NULL
  );
  
  create table list
--- 124,130 ----
  (
  	clu_id		INTEGER		DEFAULT 0	NOT NULL,
  	serv_label	VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
! 	serv_cluster	VARCHAR(128) 	DEFAULT CHR(0)	NOT NULL
  );
  
  create table list

home help back first fref pref prev next nref lref last post