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) @34800   14 years watersc1 Merge from my branch including background restoration and stack stage …
(edit) @34789   14 years bills Add column n_forced to skycalResult
(edit) @34750   14 years eugene merge from eam/20120905
(edit) @34734   14 years bills add new columns to skycalResult
(edit) @34731   14 years watersc1 updates for background restoration
(edit) @34429   14 years eugene merge changes from eam_branches/ipp-20120905 (fixes some mean values …
(edit) @34418   14 years eugene merge changes from eam_branch/ipp-20120905: add satstar profile to …
(edit) @34402   14 years eugene merge changes from eam_branches/ipp-20120805
(edit) @34264   14 years eugene merge changes from eam_branches/ipp-20120627
(edit) @34081   14 years eugene fix a number of cases of unused variables (set but otherwise not …
(edit) @33963   14 years eugene merge changes from eam_branches/ipp-20120405
(edit) @33720   14 years bills Add table skycell to the database and the program sctool (skycelltool …
(edit) @33119   14 years bills Add support for pstampJobs that depend on other jobs. This will be …
(edit) @33032   15 years heather commiting the db changes
(edit) @33030   15 years heather crap. I don't know why it thinks some of these are modified, but …
(edit) @32999   15 years bills add key(state) and changed order of the keys to match the current gpc1 …
(edit) @32963   15 years bills new sky calibration (skycal) tables
(edit) @32960   15 years bills first draft of changes to staticskytool to support skycalRun (the sky …
(edit) @32771   15 years bills add table pstampFile to keep track of nebulous files created as part …
(edit) @32695   15 years eugene fix psphotStack 2nd pass (subtract 1st pass sources from the correct …
(edit) @32634   15 years eugene merged from eam branches 20110906
(edit) @32609   15 years bills Change PRIMARY KEY for diffInputSkyfile from (diff_id, skycell_id) to …
(edit) @32510   15 years bills Add new tables and related SQL for video photometry stage
(edit) @32352   15 years eugene merge changes from eam_branches/ipp-20110710
(edit) @31946   15 years heather added 'my' tables to the create script.
(edit) @31659   15 years eugene merged from eam_branches/ipp-20110505
(edit) @31445   15 years eugene fix un-inited values and printing type mismatches
(edit) @31435   15 years watersc1 LAP code, quick stacking code, and unconvolved diff code.
(edit) @31375   15 years heather merging in addstar changes to the trunk
(edit) @31165   15 years eugene updates from eam branch
(edit) @31038   15 years watersc1 implementation of summit_id index in …
(edit) @30945   15 years watersc1 Fix bad dtime entries and add dtime_convolve to the stack stage.
(edit) @30594   15 years eugene fix difftool bug for reruns (HAF); remove debug prints in regtool
(edit) @30314   15 years bills add a column pstampDataStore.need_magic that indicates whether …
(edit) @30049   16 years watersc1 Merge of realtime burntool and new nightly science code into trunk.
(edit) @29962   16 years Serge CHASTEL ppMops -version flag supported
(edit) @29923   16 years eugene add state restriction on the detrend definebyquery; no longer need to …
(edit) @29902   16 years bills Save results of detection efficiency analaysis is the database. …
(edit) @29495   16 years bills Add path_base to magicMask. Convert destreaking to get streaks file …
(edit) @29328   16 years bills improvements to control job stoppage based on fault count
(edit) @29321   16 years bills Fix a couple of bugs related to publishing. Missing whereClause …
(edit) @28874   16 years watersc1 forgotten change to summary tables. Already made to running gpc1.
(edit) @28713   16 years bills make data_state a ke
(edit) @28486   16 years Paul Price Merging (reintegrating) branches/pap (background restoration).
(edit) @28428   16 years Paul Price Make diffphot respect/propagate magic status. No 'destreaking' set up …
(edit) @28375   16 years watersc1 merge of stack association and warp/stack/diff jpegs
(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
Note: See TracRevisionLog for help on using the revision log.