[1840] in Moira
change to container schema
daemon@ATHENA.MIT.EDU (Qing Dong)
Fri Aug 10 13:53:44 2001
Message-Id: <200108101752.NAA02485@melbourne-city-street.mit.edu>
Date: Fri, 10 Aug 2001 13:52:27 -0400
To: moiradev@mit.edu
From: Qing Dong <dongq@MIT.EDU>
Cc: jcalz@mit.edu
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Sorry, I just found out that Active Directory only allow
container names to be a maximum length of 64 characters.
Here is the schema change.
Thanks.
Qing
Index: schema.sql
===================================================================
RCS file:
\\dongq-afs\all\athena.mit.edu\astaff\project\moiradev\repository/moira/db/s
chema.sql,v
retrieving revision 1.23
diff -c -r1.23 schema.sql
*** schema.sql 2001/07/27 07:29:27 1.23
--- schema.sql 2001/08/10 17:47:36
***************
*** 398,404 ****
create table containers
(
! name VARCHAR(255) DEFAULT CHR(0) NOT NULL,
cnt_id INTEGER DEFAULT 0 NOT NULL,
description VARCHAR(255) DEFAULT CHR(0) NOT NULL,
location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
--- 398,404 ----
create table containers
(
! name VARCHAR(64) DEFAULT CHR(0) NOT NULL,
cnt_id INTEGER DEFAULT 0 NOT NULL,
description VARCHAR(255) DEFAULT CHR(0) NOT NULL,
location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
