been auto-discovered, but are waiting for the testbed admins to
'approve' them. They don't need nearly as much information as the
real nodes and interfaces tables.

who gets root on widearea nodes, inside and outside of jail. Kinda
brute force; might need to make this more flexible at some point,
perhaps with a node/user mapping table for widearearoot (root outside
the jail), and a widearea_trust slot to the group_membership table
(root inside a jail), but this will do for now since its handled
entirely inside of tmcd.

I was originally using local_root to determine root access inside the
jail, but we need to more finely control who gets root on widearea
nodes. Outside the jail, only tbadmin got jail, and thats definitely
too restrictive!

- Added 'Country' to users table
- Changed "Zip" to "ZIP/Postal Code"
- Reformatted Postal Address Forms

Changed sitevariables table to use 'varchar(255)' for
name column instead of 'text'.
Made name column primary key.

This is pretty much a comment field for now;
NULL is a safe value, but if a node is a RON node
"ron:" followed by the name of the node in the ron
hosts table (in the external-to-emulab ron db) is
the preferred value. (This may facilitate automatic
db synchronization later.)

Changed widearea_nodeinfo address columns to tinytext,
to make them consistent with users table.

Added 'sitevariables' table.

This is the table prompted by Mac's email yesterday, which
can contain site-specific configuration options.

'default' _must_ be set for each row, and will be used if
'value' is NULL.

'description' _should_ be set for each row.

The table doesn't have a primary key, but is indexed to
32 characters on the "name" column, so it should be plenty efficient.

libdb functions and web interface forthcoming...

finally! These have been in the DB for a long time, but never used.
As Eric pointed out, its easier to get realistic address info from
people if we provide the right forms. The downside is that all current
users will have to adjust their info the next time they edit their
info. Thats okay. I thought about forcing all users to do it the next
time they log in, but I figured people would scream.

Instructions for adding 'webnews' table.

only pid, to pid/gid like most other things in the testbed. Also add a
"global" slot to denote images that are globally available to all
projects (system images). The older "shared" attribute is now used to
denote images that are shared within a project (available to all
subgroups in the project). The migration path for existing DBs is
given in the migrate file. Be sure to run those commands on an
existing testbed or things will break!

www/newimageid, www/newimageid_ez: A bunch of changes for
shared/global attributes. Added a group menu to the form so users can
create images in subgroups. Beefed up the Java code that constructs
the path name to use the gid, shared, and global attributes of the
form to give the user the best possible path that we can. Improved the
pathname checking code so that we do not allow just any old path in
case the user elects to disregard the path we carefully constructed
for them. Also check the proj/group membership, and setup defaults for
users that have permission in just one pid/gid to create images.

libdb.in: Changed permission check in TBImageIDAccessCheck() to
reflect shared/global attribute changes.

os_load: Get rid of test that checked path of the image. The path
checking is done in the web interface anyway, so why duplicate in 4
places. Other minor changes reflecting shared->global name change.
Also note that images can come from the group directory now.

create_image: Get rid of test that checked path of the image. The path
checking is done in the web interface anyway, so why duplicate in 4
places. Also note that images can come from the group directory now.

www/dbdefs: Changed permission check in TBImageIDAccessCheck() to
reflect shared/global attribute changes.

www/showimageid_list, www/showstuff: Minor global/shared attribute
changes.

www/menu: Change osids/imageids pointer to point to the image list,
not the osid list. This is more reasonable for mere users who have
access to the EZ form, and thus never really need to concern
themselves with osids.

www/editimageid: Add proper pathname checking. There were no checks at
all before!

Bad idea. Use an auto_incrementing idx field instead.

by assign_wrapper to help control emulated links. When set for an
emulated link, assign uses the BW spec for mapping the links (onto
phys links) but does not insert a linkdelay to traffic shape it
(unless the link is shaped in some other manner, like a delay or plr,
in which case a linkdelay is inserted, but with no bw cap). This might
be temporary syntax, expecially if we cannot make emulated links work
right!

of emulated and linkdelays on a per-link/lan basis (although you
cannot make a lan emulated at this time).

	tb-set-link-uselinkdelay $link0 1
	tb-set-lan-uselinkdelay $lan0 1
	tb-set-link-emulated $link0 1

Added slots to the virt_lans table, used in assign_wrapper to control
these features on a per link/lan basis. Note, the global options are
still available to prefer/force linkdelays for an entire experiment.
When setting uselinkdelays on a per link/basis, if the link would not
otherwise be shaped, you are requesting that a linkdelay be inserted
anyway (in otherwords, its the equiv of tb-set-forcelinkdelays on an
individual basis).

to a specific one, for the purposes of mapping things like FBSD-STD to
FBSD47-STD (the current OSID to use). This is technically more correct
than what os_setup used to do, which was map FBSD-STD to whatever
FreeBSD OSID was currently on the disk. Now it maps to a specific one,
and if that is not loaded, it sets up a reload.

existing DB to bring it into compliance with the changes. Its
a text file, but please put in actual sql commands or script.
Mark each change with the CVS revision number of the corresponding
change in database-create.sql.