# 
# 
# rename "hostconfig"
#     to "hostconfig.dist"
# 
# add_file "TODO"
#  content [35bfbacfdeb69eba0f9c08fde8201265ab532555]
# 
# add_file "schema.sql"
#  content [3001fb127cc6523680d0b6691d938e7745a9f164]
# 
# patch "README"
#  from [bc70210de10219e59d3621429c06ca1a767f39e6]
#    to [c66843122901d904dc11f75fd54f9e64b3bc7950]
# 
# patch "reset"
#  from [e03f22f58ed710cc61fbe18a710085f412dc5a15]
#    to [5086bf043c1fc5fbd7e55828a1a993ed31626f66]
# 
# patch "www/common.php"
#  from [75a41f4b1a6c60cff1c6c07204bc3aa61c855357]
#    to [37e91cbd376ee1e8fbbba7c04c0aba99c16bc1ba]
# 
============================================================
--- TODO	35bfbacfdeb69eba0f9c08fde8201265ab532555
+++ TODO	35bfbacfdeb69eba0f9c08fde8201265ab532555
@@ -0,0 +1,24 @@
+script to keep viewmtn database in sync with server database
+	projects/*/database		server database
+	projects/*/database.viewmtn	viewmtn database
+	projects/*/database.transfer	extra database
+	
+	pull -d database.transfer
+	ln database.viewmtn database.temp
+	mv database.transfer database.viewmtn
+	mv database.temp database.transfer
+	
+	from note_netsync_revision_received, with at(1) and a flag so multiple
+	times don't get queued at once?
+	
+	...or just be very sure that attempted concurrent access from viewmtn
+	and the server won't crash the server.
+
+script to remove the oldest files from graphs/ whenever it gets too big
+
+www/admin-web*
+	maybe have webspace?
+
+www/admin-resources*
+	have links to various things (ml, irc logs, newsgroups, etc)
+	have these links go in the sidebar?
============================================================
--- schema.sql	3001fb127cc6523680d0b6691d938e7745a9f164
+++ schema.sql	3001fb127cc6523680d0b6691d938e7745a9f164
@@ -0,0 +1,13 @@
+
+CREATE TABLE users ( username varchar(80), password varchar(80) );
+
+CREATE TABLE projects ( name varchar(80) );
+
+CREATE TABLE permissions ( username varchar(80),
+			project varchar(80),
+			give smallint,
+			upload smallint,
+			homepage smallint,
+			access smallint,
+			server smallint,
+			description smallint );
============================================================
--- README	bc70210de10219e59d3621429c06ca1a767f39e6
+++ README	c66843122901d904dc11f75fd54f9e64b3bc7950
@@ -1,8 +1,15 @@
 make symlinks
 	Set up a couple of symlinks
 make usher
 	Modified usher that uses the project database for a server list,
 	and uses the same config file as the web interface.
+createdb <dbname>
+psql -f schema.sql <dbname>
+	setup database, if not done as the webserver user, that user will need
+	permission to read/insert/update.
+	If you want the reset script to work, you need permission to delete.
+cp hostconfig.dist hostconfig
+	and then update to match your local setup
 
 skel/		Some useful files
 
============================================================
--- reset	e03f22f58ed710cc61fbe18a710085f412dc5a15
+++ reset	5086bf043c1fc5fbd7e55828a1a993ed31626f66
@@ -5,4 +5,3 @@
 psql -c 'delete from permissions;' testdb
 rm -rf projects/*
 rm -rf www/projects/*
-echo -e 'userpass <username> <password>\n' >usherlist
============================================================
--- www/common.php	75a41f4b1a6c60cff1c6c07204bc3aa61c855357
+++ www/common.php	37e91cbd376ee1e8fbbba7c04c0aba99c16bc1ba
@@ -1,7 +1,7 @@
 <?
 ini_set("display_errors", false);
 
-$conffile = "/home/timothy/experiment/hostconfig";
+$conffile = dirname(__FILE__) . "/../hostconfig";
 
 # read conffile
 $firstkey = '^[^\s"[]\S*';