Changeset 20973 for trunk/dbconfig
- Timestamp:
- Dec 13, 2008, 10:17:34 AM (18 years ago)
- Location:
- trunk/dbconfig
- Files:
-
- 7 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/dbconfig/changes.txt
r20855 r20973 717 717 alter table magicDSRun add column cam_id BIGINT after stage_id; 718 718 719 -- Version: 1.1.47 720 721 -- WARNING WARNING WARNING 722 -- Updating a database which has populated diffRun's requires editing 723 -- the contents of the tables in a way that cannot be expresed here. 724 -- The script tools/collapsdiffinputs.pl does the appropriate edits 725 -- and should be run at the spot indicated below 726 727 -- fix order of workdir to match pxadmin_create_tables.sql 728 ALTER TABLE diffRun CHANGE COLUMN workdir workdir VARCHAR(255) AFTER state; 729 730 -- add exposure id to diffRun 731 ALTER TABLE diffRun ADD COLUMN exp_id BIGINT; 732 ALTER TABLE diffRun ADD FOREIGN KEY (exp_id) REFERENCES rawExp(exp_id); 733 ALTER TABLE diffRun DROP COLUMN skycell_id; 734 735 736 -- drop exiting foreign key constraints 737 ALTER TABLE diffInputSkyfile drop FOREIGN KEY diffInputSkyfile_ibfk_1; 738 ALTER TABLE diffInputSkyfile drop FOREIGN KEY diffInputSkyfile_ibfk_2; 739 ALTER TABLE diffInputSkyfile drop FOREIGN KEY diffInputSkyfile_ibfk_3; 740 741 ALTER TABLE diffInputSkyfile DROP COLUMN kind; 742 ALTER TABLE diffInputSkyfile CHANGE COLUMN skycell_id skycell_id VARCHAR(64) AFTER diff_id; 743 744 -- WARNING WARNING 745 -- If you have existing diff runs they must be converted 746 747 -- run the script collapse_diffinputs.pl here. 748 -- collapse_diffinputs.pl dbname dbuser dbpass dbhost 749 750 DELETE FROM diffInputSkyfile where template = 1; 751 752 ALTER TABLE diffInputSkyfile DROP PRIMARY KEY; 753 ALTER TABLE diffInputSkyfile ADD PRIMARY KEY (diff_id, skycell_id); 754 ALTER TABLE diffInputSkyfile DROP COLUMN template; 755 756 ALTER TABLE diffInputSkyfile CHANGE COLUMN warp_id warp1 BIGINT; 757 ALTER TABLE diffInputSkyfile ADD COLUMN stack1 BIGINT AFTER warp1, ADD KEY(stack1); 758 ALTER TABLE diffInputSkyfile ADD COLUMN warp2 BIGINT AFTER stack1, ADD KEY(warp2); 759 ALTER TABLE diffInputSkyfile CHANGE COLUMN stack_id stack2 BIGINT AFTER warp2; 760 ALTER TABLE diffInputSkyfile ADD FOREIGN KEY (diff_id) REFERENCES diffRun(diff_id); 761 762 # need to check these 763 ALTER TABLE diffInputSkyfile ADD FOREIGN KEY (warp1, skycell_id, tess_id) REFERENCES warpSkyfile(warp_id, skycell_id, tess_id); 764 ALTER TABLE diffInputSkyfile ADD FOREIGN KEY (warp2, skycell_id, tess_id) REFERENCES warpSkyfile(warp_id, skycell_id, tess_id); 765 766 ALTER TABLE diffInputSkyfile ADD FOREIGN KEY (stack1) REFERENCES stackRun(stack_id); 767 ALTER TABLE diffInputSkyfile ADD FOREIGN KEY (stack2) REFERENCES stackRun(stack_id); 768 769 -- add unique ids for each image and flags that indicate whether the image has been 770 -- magic destreaked 771 ALTER TABLE diffSkyfile ADD COLUMN skycell_id VARCHAR(64) AFTER diff_id; 772 ALTER TABLE diffSkyfile DROP PRIMARY KEY, ADD PRIMARY KEY (diff_id, skycell_id); 773 ALTER TABLE diffSkyfile ADD COLUMN diff_image_id BIGINT NOT NULL AUTO_INCREMENT, ADD KEY(diff_image_id); 774 ALTER TABLE diffSkyfile ADD COLUMN magicked TINYINT; 775 776 ALTER TABLE warpRun DROP COLUMN magiced; 777 778 ALTER TABLE warpSkyfile ADD COLUMN warp_image_id BIGINT NOT NULL AUTO_INCREMENT, ADD KEY(warp_image_id); 779 ALTER TABLE warpSkyfile ADD COLUMN magicked TINYINT; 780 781 ALTER TABLE chipProcessedImfile ADD COLUMN chip_image_id BIGINT NOT NULL AUTO_INCREMENT, ADD KEY(chip_image_id); 782 ALTER TABLE chipProcessedImfile ADD COLUMN magicked TINYINT; 783 784 ALTER TABLE rawImfile ADD COLUMN raw_image_id BIGINT NOT NULL AUTO_INCREMENT, ADD KEY(raw_image_id); 785 ALTER TABLE rawImfile ADD COLUMN magicked TINYINT; 786 787 -- magic adaptations to diff reorginization 788 ALTER TABLE magicRun ADD COLUMN diff_id BIGINT AFTER exp_id; 789 ALTER TABLE magicRun ADD CONSTRAINT FOREIGN KEY(diff_id) REFERENCES diffRun(diff_id); 790 ALTER TABLE magicRun ADD CONSTRAINT FOREIGN KEY(exp_id) REFERENCES rawExp(exp_id); 791 ALTER TABLE magicInputSkyfile DROP PRIMARY KEY, ADD PRIMARY KEY(magic_id, diff_id, node); 792 -
trunk/dbconfig/chip.md
r20240 r20973 81 81 path_base STR 255 82 82 fault S16 0 # Key NOT NULL 83 chip_image_id S64 0 # Key AUTO_INCREMENT 84 magicked BOOL f 83 85 END 84 86 -
trunk/dbconfig/config.md
r20275 r20973 2 2 pkg_name STR ippdb 3 3 pkg_namespace STR ippdb 4 pkg_version STR 1.1.4 64 pkg_version STR 1.1.47 5 5 END -
trunk/dbconfig/diff.md
r20061 r20973 1 # $Id: diff.md,v 1.1 4 2008-10-11 02:33:40 priceExp $1 # $Id: diff.md,v 1.15 2008-12-13 20:17:34 bills Exp $ 2 2 3 3 diffRun METADATA 4 4 diff_id S64 0 # Primary Key AUTO_INCREMENT 5 5 state STR 64 # Key 6 workdir STR 255 6 7 label STR 64 # Key 7 8 reduction STR 64 # Reduction class 8 workdir STR 2559 9 dvodb STR 255 10 10 registered TAI NULL 11 skycell_id STR 64 # Key12 11 tess_id STR 64 # Key 12 exp_id S64 0 # fkey(exp_id) ref rawExp(exp_id) 13 13 END 14 14 … … 17 17 # 18 18 19 # only ever 2 per run - one template / one not20 19 diffInputSkyfile METADATA 21 20 diff_id S64 0 # Primary Key fkey(diff_id) ref diffRun(diff_id) 22 template BOOL f # Primary Key 23 stack_id S64 0 # fkey(stack_id) ref stackSumSkyfile(stack_id) 24 warp_id S64 0 # fkey(warp_id, skycell_id, tess_id) ref warpSkyfile(warp_id, skycell_id, tess_id) 25 skycell_id STR 64 # Key 21 skycell_id STR 64 # Primary Key 22 warp1 S64 0 # fkey(warp1, skycell_id, tess_id) ref warpSkyfile(warp_id, skycell_id, tess_id) 23 stack1 S64 0 # fkey(stack1) ref stackSumSkyfile(stack_id) 24 warp2 S64 0 # fkey(warp2, skycell_id, tess_id) ref warpSkyfile(warp_id, skycell_id, tess_id) 25 stack2 S64 0 # fkey(stack2) ref stackSumSkyfile(stack_id) 26 26 tess_id STR 64 # Key 27 # either a input or a template28 kind STR 64 # Key29 27 END 30 28 31 29 diffSkyfile METADATA 32 30 diff_id S64 0 # Primary Key fkey(diff_id) ref diffRun(diff_id) 31 skycell_id STR 64 # 33 32 uri STR 255 34 33 path_base STR 255 … … 53 52 good_frac F32 0.0 # Key 54 53 fault S16 0 # Key 54 diff_image_id S64 0 # Key NOT NULL AUTO_INCREMENT 55 magicked BOOL f 55 56 END -
trunk/dbconfig/magic.md
r20841 r20973 1 # $Id: magic.md,v 1.1 2 2008-11-26 03:21:13bills Exp $1 # $Id: magic.md,v 1.13 2008-12-13 20:17:34 bills Exp $ 2 2 3 3 ### Fault in magicRun indicates that the processing tree failed … … 5 5 magic_id S64 0 # Primary Key AUTO_INCREMENT 6 6 exp_id S64 0 # Key 7 diff_id S64 0 # Key 7 8 state STR 64 # Key 8 9 workdir STR 255 -
trunk/dbconfig/tasks.md
r20608 r20973 1 # $Id: tasks.md,v 1.15 8 2008-11-09 23:51:01 priceExp $1 # $Id: tasks.md,v 1.159 2008-12-13 20:17:34 bills Exp $ 2 2 3 3 # this table records all exposure ID ever seen from the summit … … 239 239 fault S16 0 # Key NOT NULL 240 240 epoch UTC 0001-01-01T00:00:00Z 241 END 241 magicked BOOL f 242 END -
trunk/dbconfig/warp.md
r19930 r20973 1 # $Id: warp.md,v 1. 19 2008-10-07 00:01:28 priceExp $1 # $Id: warp.md,v 1.20 2008-12-13 20:17:34 bills Exp $ 2 2 3 3 # … … 11 11 warpRun METADATA 12 12 warp_id S64 0 # Primary Key AUTO_INCREMENT 13 fake_id 13 fake_id S64 0 # Key INDEX(warp_id, fake_id) fkey(fake_id) ref camProcessedExp(fake_id) 14 14 mode STR 64 # Key 15 15 state STR 64 # Key … … 22 22 registered TAI NULL 23 23 # if magic is T then look for the exp_id in the magic output tables 24 magiced BOOL f # Key25 24 END 26 25 … … 52 51 ignored BOOL f # Key 53 52 fault S16 0 # Key 53 warp_image_id S64 0 # Key AUTO_INCREMENT 54 magicked BOOL f 54 55 END 55 56
Note:
See TracChangeset
for help on using the changeset viewer.
