001 SET echo OFF;
002 set linesize 132;
003 drop table WCSC_data2tag cascade constraints;
004 drop table WCSC_data cascade constraints;
005 create table WCSC_data (
006 WCSC_data_id number(10),
007 VERS number(10),
008 JSTA number(10),
009 LAYCSC number(10),
010 TTOTAL float(63),
011 TNOMEX float(63),
012 TLAG10 float(63),
013 WISPA float(63),
014 DANCAT float(63),
015 PCATRE float(63),
016 AZCAT float(63),
017 GSTRIP float(63),
018 WRESTR float(63),
019 WFLSTR float(63),
020 TRRWAS float(63),
021 WROXA float(63),
022 GROXWI float(63),
023 WGASBA float(63),
024 TGASBA float(63),
025 WGASCU float(63),
026 TGASCU float(63),
027 WFIXWI float(63),
028 TFIXWI float(63),
029 PBA1WI float(63),
030 PBA2WI float(63),
031 PBA3WI float(63),
032 PSNDCO float(63)
033 ) tablespace data02;
034
035 alter table WCSC_data add constraint WCSC_data_pk
036 primary key (WCSC_data_id)
037 using index tablespace indx02;
038
039 create table WCSC_data2tag (
040 WCSC_vers varchar2(255),
041 WCSC_data_id number(10)
042 ) tablespace data02;
043
044 alter table WCSC_data2tag add constraint WCSC_data2tag_pk
045 primary key (WCSC_vers, WCSC_data_id)
046 using index tablespace indx02;
047 alter table WCSC_data2tag add constraint WCSC_data2tag_vers_fk
048 foreign key (WCSC_vers) references hvs_nodevers (vers_name);
049 alter table WCSC_data2tag add constraint WCSC_data2tag_data_fk
050 foreign key (WCSC_data_id) references WCSC_data (WCSC_data_id);
051
052 delete from hvs_relation where CHILD_NODENAME = 'WCSC';
053 delete from hvs_nodevers where VERS_NAME = 'MuonSpectrometer-07';
054 delete from hvs_nodevers where NODE_NAME = 'WCSC';
055 delete from hvs_node where NODE_NAME = 'WCSC';
056
057 insert into hvs_node values ('WCSC','MuonSpectrometer', '');
058 insert into hvs_nodevers values ('WCSC', 'WCSC-07', '');
059 insert into hvs_nodevers values ('MuonSpectrometer','MuonSpectrometer-07','');
060 insert into hvs_relation values ('MuonSpectrometer','MuonSpectrometer-07','WCSC','WCSC-07');
061 insert into WCSC_data (
062 WCSC_data_id,
063 VERS,
064 JSTA,
065 LAYCSC,
066 TTOTAL,
067 TNOMEX,
068 TLAG10,
069 WISPA,
070 DANCAT,
071 PCATRE,
072 AZCAT,
073 GSTRIP,
074 WRESTR,
075 WFLSTR,
076 TRRWAS,
077 WROXA,
078 GROXWI,
079 WGASBA,
080 TGASBA,
081 WGASCU,
082 TGASCU,
083 WFIXWI,
084 TFIXWI,
085 PBA1WI,
086 PBA2WI,
087 PBA3WI,
088 PSNDCO
089 ) values ( 0,
090 7, 1, 4, 12.3500, 1.9050, 0.0820, 0.2500,
091 0.2500, 0.5560, 1.2920, 0.0250, 0.1600, 1.2520,
092 0.0017, 0.4800, 0.1500, 0.5000, 2.0300, 0.7620,
093 0.1500, 2.2860, 0.2500, 3.2100, 2.0300, 1.1800,
094 0.0000
095 );
096 insert into WCSC_data2tag values ('WCSC-07', 0);
097 insert into WCSC_data (
098 WCSC_data_id,
099 VERS,
100 JSTA,
101 LAYCSC,
102 TTOTAL,
103 TNOMEX,
104 TLAG10,
105 WISPA,
106 DANCAT,
107 PCATRE,
108 AZCAT,
109 GSTRIP,
110 WRESTR,
111 WFLSTR,
112 TRRWAS,
113 WROXA,
114 GROXWI,
115 WGASBA,
116 TGASBA,
117 WGASCU,
118 TGASCU,
119 WFIXWI,
120 TFIXWI,
121 PBA1WI,
122 PBA2WI,
123 PBA3WI,
124 PSNDCO
125 ) values ( 1,
126 7, 2, 4, 12.3500, 1.9050, 0.0820, 0.2500,
127 0.2500, 0.5310, 2.1000, 0.0250, 0.1520, 2.0600,
128 0.0017, 0.4800, 0.1500, 0.5000, 2.0300, 0.7620,
129 0.1500, 2.2860, 0.2500, 3.2100, 2.0300, 1.1800,
130 0.0000
131 );
132 insert into WCSC_data2tag values ('WCSC-07', 1);
133
134 comment on column WCSC_data.WCSC_data_id is 'Unique identifier';
135 comment on column WCSC_data.VERS is 'VERSION ';
136 comment on column WCSC_data.JSTA is 'JSTA TYPE NUMBER ';
137 comment on column WCSC_data.LAYCSC is 'NBER OF CSCS LAYERS ';
138 comment on column WCSC_data.TTOTAL is 'TOTAL THICKNESS ';
139 comment on column WCSC_data.TNOMEX is 'NOMEX HONEYCOMB THICKNESS ';
140 comment on column WCSC_data.TLAG10 is 'G10 LAMINATES THICKNESS ';
141 comment on column WCSC_data.WISPA is 'WIRE SPACING ';
142 comment on column WCSC_data.DANCAT is 'ANODE-CATHODE DISTANCE ';
143 comment on column WCSC_data.PCATRE is 'CATHODE READOUT PITCH ';
144 comment on column WCSC_data.AZCAT is 'CATHODE READOUT PITCH, AZIMUTAL ';
145 comment on column WCSC_data.GSTRIP is 'GAP BETWEEN CATHODE STRIPS ';
146 comment on column WCSC_data.WRESTR is 'WIDTH OF READOUT STRIPS ';
147 comment on column WCSC_data.WFLSTR is 'WIDTH OF FLOATING STRIPS ';
148 comment on column WCSC_data.TRRWAS is 'RIGIT RECTANGULAR WASHER THICKNES ';
149 comment on column WCSC_data.WROXA is 'ROXACELL WIDTH ';
150 comment on column WCSC_data.GROXWI is 'ROXACELL AND WIRE BAR GAP ';
151 comment on column WCSC_data.WGASBA is 'FULL GAS GAP BAR WIDTH ';
152 comment on column WCSC_data.TGASBA is 'FULL GAS GAP BAR THICK. ';
153 comment on column WCSC_data.WGASCU is 'CUTS GAS GAP BAR WIDTH ';
154 comment on column WCSC_data.TGASCU is 'CUTS GAS GAP BAR THICK. ';
155 comment on column WCSC_data.WFIXWI is 'FULL WIRE FIX. BAR WID. ';
156 comment on column WCSC_data.TFIXWI is 'FULL WIRE FIX. BAR THICK. ';
157 comment on column WCSC_data.PBA1WI is 'WIRE BAR POSITION ';
158 comment on column WCSC_data.PBA2WI is 'WIRE BAR POSITION ';
159 comment on column WCSC_data.PBA3WI is 'WIRE BAR POSITION ';
160 comment on column WCSC_data.PSNDCO is '2ND COORDINATE PITCH ';
Due to the LXR bug, the updates fail sometimes to remove references to deleted files. The Saturday's full rebuilds fix these problems |
This page was automatically generated by the
LXR engine.
|
|