Index: trunk/ippMonitor/def/example.d
===================================================================
--- trunk/ippMonitor/def/example.d	(revision 9136)
+++ trunk/ippMonitor/def/example.d	(revision 9136)
@@ -0,0 +1,29 @@
+# this file il
+# master detrend runs which have been accepted
+
+TABLE detRunSummary, detRun
+TITLE Master Detrend Images
+FILE  masterDetrendImages.php
+MENU  ipp.detrend.dat
+
+# the following WHERE clauses are added to all queries joined by AND
+WHERE detRunSummary.accept = 1
+WHERE detRun.position = detRunSummary.det_id
+WHERE detRun.iteration = detRunSummary.iteration
+
+#     field                    width name           show         link to           extras
+FIELD detRunSummary.det_id,    7,    det_id
+FIELD detRun.det_type,         5,    type
+FIELD detRunSummary.iteration, 5,    iter
+FIELD *,                       20,   choose,       value=input, detInputExp.php,  det_id=$detRunSummary.det_id,iteration=$detRunSummary.iteration
+FIELD *,                       20,   choose,       value=resid, detResidExp.php,  det_id=$detRunSummary.det_id,iteration=$detRunSummary.iteration
+FIELD detRunSummary.bg,        20,   bg
+FIELD detRunSummary.bg_stdev,  20,   bg_stdev
+# FIELD bg_mean_stdev, 20,   bg_mean_stdev
+
+# this file illustrates a simple inner join to generate the output table
+# assuming no other dynamic restrictions are added, this generates the following query:
+# SELECT detRunSummary.det_id,detRunSummary.iteration,detRunSummary.iteration,detRun.det_type,detRunSummary.bg,detRunSummary.bg_stdev \
+# FROM detRunSummary, detRun \
+# WHERE detRunSummary.accept = 1 AND detRun.position = detRunSummary.det_id AND detRun.iteration = detRunSummary.iteration \
+# LIMIT 20
Index: trunk/ippMonitor/doc/notes.txt
===================================================================
--- trunk/ippMonitor/doc/notes.txt	(revision 9136)
+++ trunk/ippMonitor/doc/notes.txt	(revision 9136)
@@ -0,0 +1,20 @@
+
+- to update the mysql database from a dump:
+  * mysql -u root -p
+    create database NAME;
+    grant all on NAME.* to ipp@localhost;
+  * mysql -u ipp NAME -p < DUMPFILE
+
+- norm exp need to use dettool (-toresid ?) to get the list.
+
+- select * from detNormalizedImfile where detid,iteration
+  union select from detStackedImfile where detid,iteration,normalize=0
+  
+- create users table:
+  create database ippadmin;
+  use ippadmin;
+  create table users (username char(20) not null, password varchar(255));
+  insert into users (username, password) values ('eugene', 'test1');
+
+  create table cookies (username char(20) not null, cookie varchar(255));
+  insert into cookies (username, cookie) values ('eugene', 'foobar');