Changeset 36826 for branches/eam_branches/ipp-20140423/ippToPsps/config/README

Timestamp:

Jun 7, 2014, 5:36:39 AM (12 years ago)

Author:

eugene

Message:

merge changes from trunk

File:

• branches/eam_branches/ipp-20140423/ippToPsps/config/README (modified) (2 diffs)

branches/eam_branches/ipp-20140423/ippToPsps/config/README

@@ -1 @@
-ippToPspsDbSchema.sql  : SQL commands to build the real (not scratch) ipptopsps database
+ippToPspsDbSchema.sql  : SQL commands to build the real (not scratch) ipptopsps
+database ( the database that tracks/queues the batch creation)
 settings.xml           : locations of things such as mysql dbs of interest
 tables.IN.full.vot     : original version of the init batch tables, with invalid SkyCell, ProjectionCell, Regions
@@ -6 +7 @@
 tables.P2.vot          : P2 detection batch table
 tables.ST.vot          : stack detection batch table
+tables.DF.vot          : diff detection batch table
+tables.DO.vot          : diff object batch table
+tables.FW.vot          : forced warp measurement table
+tables.FO.vot          : forced mean object table
+
+
+Heather's Vague Instructions:
+
+to create a new batch db:
+
+create database ipptopsps2
+cut and paste the sql file - should be no problems, I tried to reorganize them so no foriegn key constraint fails.
+
+to make a scratch db:
+ check settings.xml if necessary and recompile
+ mysql -h localhost -u dvo -pdvo -e "create database ipptopsps2_scratch"
+ ippjython setupScratchDb.py
+
+should be good to go!