Changeset 14023 for trunk/dbconfig/tasks.md
- Timestamp:
- Jul 5, 2007, 3:16:08 PM (19 years ago)
- File:
-
- 1 edited
-
trunk/dbconfig/tasks.md (modified) (11 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/dbconfig/tasks.md
r14017 r14023 1 # $Id: tasks.md,v 1.13 5 2007-07-05 20:13:45jhoblitt Exp $1 # $Id: tasks.md,v 1.136 2007-07-06 01:16:08 jhoblitt Exp $ 2 2 3 3 # this table records all exposure ID ever seen from the summit 4 # exp_ id== fileset4 # exp_name == fileset 5 5 6 6 # note that dec is a MySQL reserved word … … 8 8 # note that exp is a MySQL reserved word 9 9 10 # for use with this stored procedure to generate exp_ tags under Mysql 5+10 # for use with this stored procedure to generate exp_ids under Mysql 5+ 11 11 # 12 #CREATE FUNCTION genTag (exp_ idvarchar(64)) RETURNS VARCHAR(64)12 #CREATE FUNCTION genTag (exp_name varchar(64)) RETURNS VARCHAR(64) 13 13 #BEGIN 14 14 # UPDATE expTagCounter SET counter = LAST_INSERT_ID(counter + 1); 15 # RETURN CONCAT(exp_ id, '.', LAST_INSERT_ID());15 # RETURN CONCAT(exp_name, '.', LAST_INSERT_ID()); 16 16 #END 17 17 # 18 expTagCounter METADATA19 counter U64 020 END18 #expTagCounter METADATA 19 # counter U64 0 20 #END 21 21 22 22 # list of source exposures -- updated as exposures are seen … … 24 24 # -1 as NULL or 0 might be a valid value (empty fileset) 25 25 summitExp METADATA 26 exp_ idSTR 64 # Primary Key26 exp_name STR 64 # Primary Key 27 27 camera STR 64 # Primary Key 28 28 telescope STR 64 # Primary Key … … 37 37 # list of source images -- updated as exposures/filesets are queried 38 38 summitImfile METADATA 39 exp_ idSTR 64 # Primary Key39 exp_name STR 64 # Primary Key 40 40 camera STR 64 # Primary Key 41 41 telescope STR 64 # Primary Key … … 51 51 # downloaded) 52 52 pzPendingExp METADATA 53 exp_ idSTR 64 # Primary Key53 exp_name STR 64 # Primary Key 54 54 camera STR 64 # Primary Key 55 55 telescope STR 64 # Primary Key … … 57 57 58 58 pzPendingImfile METADATA 59 exp_ idSTR 64 # Primary Key59 exp_name STR 64 # Primary Key 60 60 camera STR 64 # Primary Key 61 61 telescope STR 64 # Primary Key 62 62 class STR 64 # Primary Key 63 63 class_id STR 64 # Primary Key 64 exp_ tag STR64 # Unique Key64 exp_id S64 64 # Unique Key 65 65 END 66 66 67 67 # list of exposures that have had all of their imfiles downloaded 68 68 pzDoneExp METADATA 69 exp_ idSTR 64 # Primary Key69 exp_name STR 64 # Primary Key 70 70 camera STR 64 # Primary Key 71 71 telescope STR 64 # Primary Key … … 73 73 74 74 pzDoneImfile METADATA 75 exp_ idSTR 64 # Primary Key75 exp_name STR 64 # Primary Key 76 76 camera STR 64 # Primary Key 77 77 telescope STR 64 # Primary Key 78 78 class STR 64 # Primary Key 79 79 class_id STR 64 # Primary Key 80 exp_ tag STR64 # Unique Key80 exp_id S64 64 # Unique Key 81 81 uri STR 255 82 82 END 83 83 84 84 newExp METADATA 85 exp_tag STR 64 # Primary Key 86 exp_id STR 64 # Key 85 exp_id S64 0 # Primary Key AUTO_INCREMENT 86 tmp_exp_name STR 64 # Key 87 tmp_camera STR 64 # Key 88 tmp_telescope STR 64 # Key 87 89 state STR 64 # Key 88 camera STR 64 # Key89 telescope STR 64 # Key90 90 imfiles S32 0 91 91 workdir STR 255 # destination for output files … … 96 96 # from there 97 97 newImfile METADATA 98 exp_ tag STR 64 # Primary Key fkey(exp_tag) ref newExp(exp_tag)99 class_id STR64 # Primary Key98 exp_id S64 64 # Primary Key fkey(exp_id) ref newExp(exp_id) 99 tmp_class_id STR 64 # Primary Key 100 100 uri STR 255 101 101 END … … 103 103 # paired with rawImfile 104 104 rawExp METADATA 105 exp_ tag STR 64 # Primary Key fkey(exp_tag) ref newExp(exp_tag)106 exp_ id STR 64 # Key105 exp_id S64 64 # Primary Key fkey(exp_id) ref newExp(exp_id) 106 exp_name STR 64 107 107 camera STR 64 108 108 telescope STR 64 109 109 dateobs UTC 0001-01-01T00:00:00Z 110 exp_tag STR 255 110 111 exp_type STR 64 111 112 imfiles S32 0 … … 136 137 137 138 rawImfile METADATA 138 exp_tag STR 64 # Primary Key fkey(exp_tag, class_id) ref newImfile(exp_tag, class_id) 139 exp_id S64 64 # Primary Key fkey(exp_id, tmp_class_id) ref newImfile(exp_id, tmp_class_id) 140 exp_name STR 64 141 camera STR 64 142 telescope STR 64 143 dateobs UTC 0001-01-01T00:00:00Z 144 tmp_class_id STR 64 # Key 139 145 class_id STR 64 # Primary Key 140 146 uri STR 255 … … 163 169 user_5 F64 0.0 164 170 object STR 64 165 dateobs UTC 0001-01-01T00:00:00Z166 171 fault S16 0 # Key NOT NULL 167 172 END 168 169 #170 # XXX - temporarily (???) stop carrying around class in imfiles after rawImfile171 #
Note:
See TracChangeset
for help on using the changeset viewer.
