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) @28348   16 years Paul Price Fix error.
(edit) @28343   16 years Paul Price Adding database tables and tools for (re-)photometry of diffs.
(edit) @28294   16 years bills Add timestamp to pstampRequest
(edit) @28106   16 years bills Get the 'webrequest number' frm the database
(edit) @28096   16 years eugene more work on the staticsky interactions
(edit) @28091   16 years eugene updates to staticskytool (now mostly working)
(edit) @28089   16 years watersc1 Hopefully final edits for maskstats code
(edit) @28056   16 years watersc1 Updates to fix the fact that the set of warpSkyfiles for a given …
(edit) @28043   16 years watersc1 Merging czw_branch (maskstats and software versions) back into the trunk
(edit) @27874   16 years bills Various changes to the postage stamp server and associated tables. …
(edit) @27856   16 years bills Add table Label which through priority column may be used to order …
(edit) @27781   16 years bills changes to pstampDependent
(edit) @27764   16 years Paul Price Key/index additions for distribution tables.
(edit) @27763   16 years Paul Price Add key/index to magicDSRun to make it go faster for cleanup.
(edit) @27741   16 years bills changes to pstampDependent
(edit) @27734   16 years Paul Price Removing stray comma.
(edit) @27731   16 years Paul Price Fix cut/paste error.
(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
Note: See TracRevisionLog for help on using the revision log.