001 SET echo OFF;
002 set linesize 132;
003 drop table JTSH_data2tag cascade constraints;
004 drop table JTSH_data cascade constraints;
005 create table JTSH_data (
006 JTSH_data_id number(10),
007 OPLENGTH float(63),
008 OPINNRAD float(63),
009 OPOUTRAD float(63),
010 IPLENGTH float(63),
011 IPINNRA1 float(63),
012 IPOUTRAD float(63),
013 IPTILTAN float(63),
014 IPZOFFSE float(63),
015 PRLENGTH float(63),
016 PRINNRAD float(63),
017 PROUTRAD float(63),
018 PREXTTAN float(63),
019 PRIPEXLE float(63),
020 ZPOSITIO float(63),
021 YROTATIO float(63),
022 IPINNRA2 float(63),
023 PREXTZPO float(63),
024 OPZPOSI1 float(63),
025 OPZPOSI2 float(63),
026 IPZPOSI1 float(63),
027 IPZPOSI2 float(63),
028 PRZPOSI1 float(63),
029 PRZPOSI2 float(63),
030 PRZPOSI3 float(63)
031 ) ;
032
033 alter table JTSH_data add constraint JTSH_data_pk
034 primary key (JTSH_data_id);
035
036 create table JTSH_data2tag (
037 JTSH_vers varchar2(255),
038 JTSH_data_id number(10)
039 ) ;
040
041 alter table JTSH_data2tag add constraint JTSH_data2tag_pk
042 primary key (JTSH_vers, JTSH_data_id);
043 alter table JTSH_data2tag add constraint JTSH_data2tag_vers_fk
044 foreign key (JTSH_vers) references hvs_nodevers (vers_name);
045 alter table JTSH_data2tag add constraint JTSH_data2tag_data_fk
046 foreign key (JTSH_data_id) references JTSH_data (JTSH_data_id);
047
048 delete from hvs_relation where CHILD_NODENAME = 'JTSH';
049 delete from hvs_nodevers where VERS_NAME = 'MuonSpectrometer-01';
050 delete from hvs_nodevers where NODE_NAME = 'JTSH';
051 delete from hvs_node where NODE_NAME = 'JTSH';
052
053 insert into hvs_node values ('JTSH','MuonSpectrometer', '');
054 insert into hvs_nodevers values ('JTSH', 'JTSH-01', '');
055 insert into hvs_nodevers values ('MuonSpectrometer','MuonSpectrometer-01','');
056 insert into hvs_relation values ('MuonSpectrometer','MuonSpectrometer-01','JTSH','JTSH-01');
057 insert into JTSH_data (
058 JTSH_data_id,
059 OPLENGTH,
060 OPINNRAD,
061 OPOUTRAD,
062 IPLENGTH,
063 IPINNRA1,
064 IPOUTRAD,
065 IPTILTAN,
066 IPZOFFSE,
067 PRLENGTH,
068 PRINNRAD,
069 PROUTRAD,
070 PREXTTAN,
071 PRIPEXLE,
072 ZPOSITIO,
073 YROTATIO,
074 IPINNRA2,
075 PREXTZPO,
076 OPZPOSI1,
077 OPZPOSI2,
078 IPZPOSI1,
079 IPZPOSI2,
080 PRZPOSI1,
081 PRZPOSI2,
082 PRZPOSI3
083 ) values ( 1,
084 4740.0000, 562.5000, 789.0000, 3685.0000, 171.0000, 548.0000,
085 1.1000, 1000.0000, 4560.0000, 809.0000, 849.0000, 18.0000,
086 205.0000, 7894.0000, 180.0000, 262.0126, 123.1073, 205.0000,
087 4945.0000, 1000.0000, 4685.0000, 261.8927, 385.0000, 4945.0000
088 );
089 insert into JTSH_data2tag values ('JTSH-01', 1);
090
091 comment on column JTSH_data.JTSH_data_id is 'Unique identifier';
092 comment on column JTSH_data.OPLENGTH is 'OUTERPLUGS_LENGTH ';
093 comment on column JTSH_data.OPINNRAD is 'OUTERPLUGS_INNERRADIUS ';
094 comment on column JTSH_data.OPOUTRAD is 'OUTERPLUGS_OUTERRADIUS ';
095 comment on column JTSH_data.IPLENGTH is 'INNERPLUGS_LENGTH ';
096 comment on column JTSH_data.IPINNRA1 is 'INNERPLUGS_INNERRADIUS1 ';
097 comment on column JTSH_data.IPOUTRAD is 'INNERPLUGS_OUTERRADIUS ';
098 comment on column JTSH_data.IPTILTAN is 'INNERPLUGS_TILTANGLE ';
099 comment on column JTSH_data.IPZOFFSE is 'INNERPLUGS_ZOFFSET ';
100 comment on column JTSH_data.PRLENGTH is 'POLYRINGS_LENGTH ';
101 comment on column JTSH_data.PRINNRAD is 'POLYRINGS_INNERRADIUS ';
102 comment on column JTSH_data.PROUTRAD is 'POLYRINGS_OUTERRADIUS ';
103 comment on column JTSH_data.PREXTTAN is 'POLYRINGS_EXTENSION_TILTANGLE ';
104 comment on column JTSH_data.PRIPEXLE is 'POLYRINGS_IPEXTENSION_LENGTH ';
105 comment on column JTSH_data.ZPOSITIO is 'SHIELD_Z ';
106 comment on column JTSH_data.YROTATIO is 'SHIELD_ROTY ';
107 comment on column JTSH_data.IPINNRA2 is 'INNERPLUGS_INNERRADIUS2 ';
108 comment on column JTSH_data.PREXTZPO is 'POLYRINGS_EXTENSION_Z ';
109 comment on column JTSH_data.OPZPOSI1 is 'OUTERPLUGS_Z1 ';
110 comment on column JTSH_data.OPZPOSI2 is 'OUTERPLUGS_Z2 ';
111 comment on column JTSH_data.IPZPOSI1 is 'INNERPLUGS_Z1 ';
112 comment on column JTSH_data.IPZPOSI2 is 'INNERPLUGS_Z2 ';
113 comment on column JTSH_data.PRZPOSI1 is 'POLYRINGS_Z1 ';
114 comment on column JTSH_data.PRZPOSI2 is 'POLYRINGS_Z2 ';
115 comment on column JTSH_data.PRZPOSI3 is 'POLYRINGS_Z3 ';
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.
|
|