[freshports-cvs-all] CVS update: database-schema

Dan Langille dan at xeon.unixathome.org
Sun Jul 30 18:37:12 PDT 2006

Date:	Sunday July 30, 2006 @ 21:37
Author:	root

Update of /home/repositories/freshports-1/database-schema
In directory xeon.unixathome.org:/tmp/cvs-serv70014

Modified Files:
Log Message:
A late check of data.

new tables for cross platform and cross arch testing of ports:
releases    - what releases have we had?
archs       - what archs do we have?
port_status - status of a given port with respect to release and arch

add fields to ports table already in production:
- is_interactive
- only_for_archs
- not_for_archs

For person watch lists on watch_list, create a token 
using generate_watch_list_token()

For filtering, add new table element_pathname


File: no file createdb.sql		Status: Needs Checkout

   Working revision:	1.83	Mon Jul 31 01:37:12 2006
   Repository revision:	1.83	/home/repositories/freshports-1/database-schema/createdb.sql,v

   Existing Tags:
	FreshPorts-VuXML         	(revision: 1.78)
	FreshPorts_2003_05_04    	(revision: 1.53)
	RELEASE-beta-2003_03_07  	(revision: 1.22)
	FreshPorts2              	(branch: 1.22.2)

More information about the freshports-cvs-all mailing list