Changeset 10059
- Timestamp:
- Nov 17, 2006, 2:19:16 PM (20 years ago)
- Location:
- trunk/dbconfig
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/dbconfig/config.md
r9969 r10059 2 2 pkg_name STR ippdb 3 3 pkg_namespace STR ippdb 4 pkg_version STR 0.0.5 54 pkg_version STR 0.0.56 5 5 END -
trunk/dbconfig/tasks.md
r9969 r10059 1 # $Id: tasks.md,v 1.9 4 2006-11-14 03:15:04jhoblitt Exp $1 # $Id: tasks.md,v 1.95 2006-11-18 00:19:16 jhoblitt Exp $ 2 2 3 3 # this table records all exposure ID ever seen from the summit … … 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+ 11 # 12 #CREATE FUNCTION genTag (exp_id varchar(64)) RETURNS VARCHAR(64) 13 #BEGIN 14 # UPDATE expTagCounter SET counter = LAST_INSERT_ID(counter + 1); 15 # RETURN CONCAT(exp_id, '.', LAST_INSERT_ID()); 16 #END 17 # 18 #expTagCounter METADATA 19 # counter U64 0 20 #END 21 22 # list of source exposures -- updated as exposures are seen 23 # summitExp.imfiles is updated as filesets are queried default value should be 24 # -1 as NULL or 0 might be a valid value (empty fileset) 10 25 summitExp METADATA 11 26 exp_id STR 64 # Primary Key 12 27 camera STR 64 # Primary Key 13 28 telescope STR 64 # Primary Key 14 time UTC NULL 15 exp_type STR 64 16 uri STR 255 17 END 18 19 pzPendingExp METADATA 20 exp_id STR 64 # Primary Key 21 camera STR 64 # Primary Key 22 telescope STR 64 # Primary Key 23 # time 24 exp_type STR 64 25 # class STR 64 29 dateobs UTC NULL 30 exp_type STR 64 31 uri STR 255 26 32 imfiles S32 0 27 33 END … … 29 35 # class == type of file 30 36 # class_id == type set id 31 pzPendingImfile METADATA 37 # list of source images -- updated as exposures/filesets are queried 38 summitImfile METADATA 32 39 exp_id STR 64 # Primary Key 33 40 camera STR 64 # Primary Key … … 35 42 bytes S32 0 36 43 md5sum STR 32 37 class STR 64 38 class_id STR 64 # Primary Key 44 class STR 64 # Primary Key 45 class_id STR 64 # Primary Key 46 uri STR 255 47 END 48 49 # list of exposures that have had their imfiles/files registered (but not 50 # downloaded) 51 pzPendingExp METADATA 52 exp_id STR 64 # Primary Key 53 camera STR 64 # Primary Key 54 telescope STR 64 # Primary Key 55 END 56 57 pzPendingImfile METADATA 58 exp_id STR 64 # Primary Key 59 camera STR 64 # Primary Key 60 telescope STR 64 # Primary Key 61 class STR 64 # Primary Key 62 class_id STR 64 # Primary Key 63 exp_tag STR 64 # Unique Key 64 END 65 66 # list of exposures that have had all of their imfiles downloaded 67 pzDoneExp METADATA 68 exp_id STR 64 # Primary Key 69 camera STR 64 # Primary Key 70 telescope STR 64 # Primary Key 71 END 72 73 pzDoneImfile METADATA 74 exp_id STR 64 # Primary Key 75 camera STR 64 # Primary Key 76 telescope STR 64 # Primary Key 77 class STR 64 # Primary Key 78 class_id STR 64 # Primary Key 79 exp_tag STR 64 # Unique Key 39 80 uri STR 255 40 81 END 41 82 42 83 newExp METADATA 43 exp_tag STR 64 # Primary Key 84 # exp_tag STR 64 # Primary Key 85 exp_tag U64 0 # Primary Key AUTO_INCREMENT 44 86 exp_id STR 64 # Key 45 camera STR 64 46 telescope STR 64 47 # timeUTC NULL87 camera STR 64 # Key 88 telescope STR 64 # Key 89 dateobs UTC NULL 48 90 exp_type STR 64 49 91 imfiles S32 0 … … 54 96 newImfile METADATA 55 97 exp_tag STR 64 # Primary Key 56 class STR 64 98 class STR 64 # Primary Key 57 99 class_id STR 64 # Primary Key 58 100 uri STR 255 … … 62 104 rawDetrendExp METADATA 63 105 exp_tag STR 64 # Primary Key 106 # exp_id STR 64 # Key 64 107 camera STR 64 65 108 telescope STR 64 … … 85 128 rawScienceExp METADATA 86 129 exp_tag STR 64 # Primary Key 130 # exp_id STR 64 # Key 87 131 camera STR 64 88 132 telescope STR 64
Note:
See TracChangeset
for help on using the changeset viewer.
