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) @37885   11 years bills add a missing comma and delte statements for two new tables
(edit) @37833   12 years eugene merging changes from ipp-pv3-20140717 (via …
(edit) @37769   12 years eugene merge tracking
(edit) @36914   12 years bills have psastro output a mask for each chip ASTROM_CHIPS. It has the …
(edit) @36529   12 years eugene merged changes from eam_branches/ipp-20140214
(edit) @36507   12 years watersc1 Database changes for new remote processing code.
(edit) @36493   12 years eugene merge changes from eam_branches/ipp-20131211
(edit) @36455   13 years bills only property changes triggered by my merge
(edit) @36441   13 years bills Iniital implementation of the full force stages to the pipeline. …
(edit) @36374   13 years eugene merge changes from eam_branches/ipp-20130904
(edit) @36077   13 years eugene merging in EAM branch
(edit) @35897   13 years bills add relExp.mcal
(edit) @35896   13 years bills Add columns ippRelease.dvodb and ippRelease.ubercal_file and …
(edit) @35838   13 years bills create dqstatsRun and dqstatsConent
(edit) @35789   13 years bills add chipRun.update_mode. If set do not use the config dump file when …
(edit) @35770   13 years eugene merge changes from eam_branches/ipp-20130509
(edit) @35558   13 years eugene remove unused variable
(edit) @35471   13 years bills Forgot to add unique keys ippRelease UNIQUE KEY(surveyID, …
(edit) @35453   13 years bills Add key to relStack UNIQUE KEY (rel_id, tess_id, skycell_id, filter, …
(edit) @35418   13 years eugene merged changes from eam_branches/ipp-20130307
(edit) @35308   13 years bills sript, ippTools, and database changes to support queuing staticsky …
(edit) @35295   13 years bills add username, proj_id, and registered to table pstampRequest
(edit) @35239   13 years eugene merge changes from eam_branches/ipp-20130207
(edit) @35227   13 years bills updates to release tables. This version was used to create the tables …
(edit) @35213   13 years bills Add tables relGroup and lapGroup Add group_id to relExp Rename …
(edit) @35196   13 years bills tweaks to release tables. Further progress on releasetool
(edit) @35153   13 years bills remove warpBackgroundRun.alt_cam_label add chipBackgroundRun.cam_id …
(edit) @35150   13 years watersc1 Set of changes to implement background continuity.
(edit) @35134   13 years bills For warp_bg stage add column alt_cam_label. If set use the smf file …
(edit) @35110   13 years eugene merge changes from eam_branches/ipp-20121219
(edit) @35048   13 years bills define relStack table add ippRelease.priority Change ippRelease.state …
(edit) @34912   14 years bills add survey ippRelease, and relExp
(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
Note: See TracRevisionLog for help on using the revision log.