Project

General

Profile

mi_la_data_sql.txt

Kyle Hazelwood, 01/15/2015 11:48 AM

 
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