|
1
|
use appdb
|
|
2
|
go
|
|
3
|
drop table mi_la_dir
|
|
4
|
go
|
|
5
|
create table mi_la_dir (
|
|
6
|
rid int not null, /* ring id */
|
|
7
|
fid int not null, /* fid id */
|
|
8
|
sid int not null, /* source id */
|
|
9
|
date int not null,
|
|
10
|
title char(28) not null,
|
|
11
|
tune_h real not null,
|
|
12
|
tune_v real not null
|
|
13
|
)
|
|
14
|
go
|
|
15
|
create unique clustered index idx on mi_la_dir(rid,fid)
|
|
16
|
go
|
|
17
|
grant select,insert,update,delete on mi_la_dir to PA1793
|
|
18
|
go
|
|
19
|
grant select on mi_la_dir to PUBLIC
|
|
20
|
go
|
|
21
|
|
|
22
|
drop table mi_la_data
|
|
23
|
go
|
|
24
|
create table mi_la_data (
|
|
25
|
rid int not null, /* ring id */
|
|
26
|
fid int not null, /* fid id */
|
|
27
|
slot int not null,
|
|
28
|
element_name char(40) not null,
|
|
29
|
element_type char(20) not null,
|
|
30
|
s_value real, /* Units of meters */
|
|
31
|
alpha_x real, /* unitless */
|
|
32
|
beta_x real, /* Units of meters */
|
|
33
|
psi_x real, /* units of radians */
|
|
34
|
disp_x real, /* units of meters */
|
|
35
|
d_prime_x real, /* unitless */
|
|
36
|
alpha_y real, /* unitless */
|
|
37
|
beta_y real, /* units of meters */
|
|
38
|
psi_y real, /* units of radians */
|
|
39
|
disp_y real, /* units of meters */
|
|
40
|
d_prime_y real /* unitless */
|
|
41
|
)
|
|
42
|
go
|
|
43
|
create unique clustered index idx1 on mi_la_data(rid,fid,slot)
|
|
44
|
go
|
|
45
|
grant select,insert,update,delete on mi_la_data to PA1793
|
|
46
|
go
|
|
47
|
grant select on mi_la_data to PUBLIC
|
|
48
|
go
|
|
49
|
|