IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

source: trunk/ippTools/share/pxadmin_create_tables.sql

Revision Log Mode:


Legend:

Added
Modified
Copied or renamed
Diff Rev Age Author Log Message
(edit) @27546   16 years Paul Price Adding work in progress on static sky analysis workflow definition. …
(edit) @27450   16 years bills add alternate to distRun get inputs from alternate location add …
(edit) @27175   16 years bills Add timestamp and poll interval to pstampDataStore. Don't poll for new …
(edit) @27149   16 years watersc1 Code and regtool rewrites to enable the lossy compression of old data …
(edit) @27116   16 years bills add diffRun.diff_mode
(edit) @27028   16 years Paul Price Schema change to support requirement of magicked detections for MOPS …
(edit) @26519   17 years bills Add dist_group to distRun. It is needed for the data store and joining …
(edit) @26446   17 years bills Add some stats to magicDSFile. On the receive side, make it possible …
(edit) @26015   17 years bills Spread building of distribution bundles over a number of hosts …
(edit) @25929   17 years Paul Price Giving publishClient an 'active' column, and add mode to pubtool to …
(edit) @25913   17 years eugene adding feature to control if analysis generates a correction image or not
(edit) @25856   17 years bills forgot to update the definition of distTarget
(edit) @25851   17 years bills Add a new table to the database dbversion where we will store the …
(edit) @25835   17 years bills Add data_group, dist_group, and note to the pipeline. These new …
(edit) @25816   17 years eugene updates to the addstar stage; modify flatcorr to interact correctly …
(edit) @25795   17 years bills Rats. Forgot to include the final table definitions.
(edit) @25793   17 years bills Add new table pstampDependent. An entry gets created by the postage …
(edit) @25711   17 years bills add options to pstampJob move sql for -listjob to a sql file
(edit) @25513   17 years bills add magic_ds_id to distRun so that we can find them to censor if necessary
(edit) @25493   17 years bills In distribution server merge rcDSProduct into rcDestination. It was …
(edit) @25479   17 years bills remove duplicate burntool_state
(edit) @25425   17 years watersc1 changes to support new burntool_state
(edit) @25420   17 years bills Add burntool_state to rawImfile
(edit) @25418   17 years bills Store the size in bytes and md5sum of the Compressed raw image files …
(edit) @25382   17 years bills add comma that I should have added 6 weeks ago!
(edit) @25299   17 years watersc1 Merge my branch back into the trunk. This includes: ipp_cleanup.pl : …
(edit) @25256   17 years Paul Price Merging branches/pap_mops into trunk. ppMops now merges multiple …
(edit) @25012   17 years bills add inv_magic_id to magicDSRun to support warp-warp diffs
(edit) @24967   17 years bills Remove args and URI from pstampJob tables
(edit) @24740   17 years bills add a constraint to insure that targets are unique
(edit) @24730   17 years bills fix bug in table defintion
(edit) @24725   17 years bills change distTarget.obs_mode to distTarget.label add filter require that …
(edit) @24681   17 years bills Add magicked column to camRun
(edit) @24552   17 years bills changed the columns magicked from TINYINT to BIGINT store magic_ds_id …
(edit) @24512   17 years Paul Price Done with development of mechanism to automatically publish …
(edit) @24487   17 years Paul Price Adding reduction classes to warp stage.
(edit) @24177   17 years bills remove foreign key constraint for dropped column
(edit) @24174   17 years Paul Price Merging branches/pap_magic@24173 into trunk. One conflict in …
(edit) @24125   17 years bills Pass information about the paths from the distribution server to the …
(edit) @24105   17 years bills save bytes, md5sum, file_type, and component in receiveFile
(edit) @24038   17 years bills on receive side of distribution, optionally create a fileset in a …
(edit) @23953   17 years Paul Price Adding key for dateobs to make it easier to get ccd_temp for XY24.
(edit) @23940   17 years Paul Price Adding new column to diffSkyfile: deconv_max, which is the maximum …
(edit) @23912   17 years bills Distribution progress
(edit) @23893   17 years Paul Price Add UNIQUE constraint to ensure we're not downloading the same …
(edit) @23885   17 years Paul Price Modifying distribution client workflow (currently composed of …
(edit) @23880   17 years Paul Price Adding receivetool, for the other end of the distribution.
(edit) @23877   17 years bills add diffSkyfile.data_state
(edit) @23863   17 years Paul Price Removing stray comma.
(edit) @23842   17 years bills modes to disttool for creating rcDSFileset objects tweaks to the …
(edit) @23776   17 years bills remove prod_id from rcInterest
(edit) @23688   17 years Paul Price Merging in branches/pap/ from r23685. Some conflicts, most notably in …
(edit) @23659   17 years bills add no_magic flag to support cameras that dont' need to run magic …
(edit) @23566   17 years bills progress on query for components ready to be processed
(edit) @23390   17 years bills add 'run' level magicked bits add tables to build distribution bundles …
(edit) @23229   17 years eugene merging changes from branches/eam_branches/eam_branch_20090303 …
(edit) @21308   17 years bills Changed the way image ids are handled. For chip and warp new tables …
(edit) @20973   18 years bills Rework the diff stage to process the skycells from an exposure in a …
(edit) @20841   18 years bills Add the stage_id and cam_id to magicDSRun. This vastly reduces the …
(edit) @20786   18 years bills add magicDSRun and magicDSFile
(edit) @20608   18 years Paul Price Change to run a subset of a camera seems to work, based on a simtest …
(edit) @20397   18 years eugene adding include fields to flatcorrChipLink and flatcorrCamLink
(edit) @20376   18 years eugene add det_type to flatcorr
(edit) @20310   18 years bills add hostname to pzDownloadImfile
(edit) @20276   18 years eugene renaming zp_mean, zp_stdev to zpt_obs, zpt_stdev; adding zpt_lq, …
(edit) @20244   18 years eugene adding iq, fwhm fields to chip and cam, adding camera, telescope, …
(edit) @20105   18 years eugene adding obs_mode, obs_group fields to rawExp, rawImfile
(edit) @20062   18 years Paul Price Adding more QA fields for diff.
(edit) @19970   18 years eugene adding dtime_astrom and dtime_addstar
(edit) @19941   18 years eugene adding IQ stats, n_psfstars, n_iqstars
(edit) @19931   18 years Paul Price Reusing astrometry time field since ppImage doesn't do that any more. …
(edit) @19760   18 years bills add table pstampProject
(edit) @19693   18 years bills add new fields
(edit) @19678   18 years bills removed data_state
(edit) @19673   18 years Paul Price Adding statistics on number of stamps
(edit) @19646   18 years Paul Price Adding additional statistics for stacking.
(edit) @19639   18 years Paul Price Adding additional statistics for diff.
(edit) @19621   18 years eugene changing detrend verify mode to behave just like master mode in terms …
(edit) @19558   18 years bills changes to support cleanup, purge, and update processing
(edit) @19392   18 years bills add missing comma
(edit) @19372   18 years eugene adding label, reduction, data_state to diff, stack, warp tables, mods …
(edit) @19334   18 years bills Add modes for transitioning chipProcessedImfiles from full to cleaned …
(edit) @19325   18 years eugene substantial work on flatcorr; reworked the sequence somewhat
(edit) @19219   18 years bills add exp_id to pstampJob. Rename -processedreq to -updatereq and …
(edit) @19092   18 years eugene extensive changes from eam_branch_20080719: * added the 'cleanup' …
(edit) @18764   18 years bills My last "fix" was in error. It turns out that the trailing semicolon …
(edit) @18761   18 years bills add missing semicolon at the end of the file
(edit) @18665   18 years bills apply changes to the pstamp tables
(edit) @18662   18 years Paul Price Adding exposure identifier in magicRun.
(edit) @18576   18 years Paul Price Reformatting some of my tables. Adding "filter" to stackRun.
(edit) @18520   18 years Paul Price Updating tables for magic (adding fault codes, removing skyfilemask)
(edit) @18029   18 years jhoblitt merge faketool branch
(edit) @17881   18 years jhoblitt fix fkey
(edit) @17879   18 years jhoblitt add faketables
(edit) @17872   18 years jhoblitt add epoch fields to pz*, new*, & raw* tables
(add) @17856   18 years jhoblitt add createMode() function and mode table creation into …
Note: See TracRevisionLog for help on using the revision log.