4
CREATE DATABASE IF NOT EXISTS esahelio_svdb0;
12
CREATE TABLE `esahelio_svdb0`.`image` (
13
`id` int(10) unsigned NOT NULL auto_increment,
14
`measurementId` int(10) unsigned NOT NULL default '0',
15
`timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
16
`filetype` varchar(4) default NULL,
18
) ENGINE=MyISAM AUTO_INCREMENT=9198 DEFAULT CHARSET=utf8;
22
DROP TABLE IF EXISTS `tile`;
23
CREATE TABLE IF NOT EXISTS `tile` (
24
`imageId` int(11) NOT NULL default '0',
25
`x` int(11) NOT NULL default '0',
26
`y` int(11) NOT NULL default '0',
27
`zoom` int(11) NOT NULL default '0',
28
`url` varchar(255) default NULL,
30
PRIMARY KEY (`imageId`,`x`,`y`,`zoom`)
31
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
34
CREATE TABLE `detector` (
35
`id` int(10) unsigned NOT NULL auto_increment,
36
`abbreviation` varchar(4) NOT NULL default '',
37
`name` varchar(255) default NULL,
38
`instrumentId` int(10) unsigned NOT NULL default '0',
39
`imgSunRatio` float(6,3) default NULL,
40
`lowestRegularZoomLevel` tinyint(4) default NULL,
41
`opacityGroupId` int(10) unsigned NOT NULL default '1',
43
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
48
INSERT INTO `detector` VALUES(11, 'MDI', 'MDI', 8, NULL, NULL, 1);
49
INSERT INTO `detector` VALUES(12, '0C3', '0C3', 9, NULL, NULL, 3);
50
INSERT INTO `detector` VALUES(13, '0C2', '0C2', 9, NULL, NULL, 2);
51
INSERT INTO `detector` VALUES(14, 'EIT', 'EIT', 10, NULL, NULL, 1);
57
CREATE TABLE `instrument` (
58
`id` int(10) unsigned NOT NULL auto_increment,
59
`abbreviation` varchar(4) NOT NULL default '',
60
`name` varchar(255) default NULL,
61
`observatoryId` int(10) unsigned NOT NULL default '0',
63
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
68
INSERT INTO `instrument` VALUES(8, 'MDI', 'MDI', 3);
69
INSERT INTO `instrument` VALUES(9, 'LAS', 'LAS', 3);
70
INSERT INTO `instrument` VALUES(10, 'EIT', 'EIT', 3);
76
CREATE TABLE `measurement` (
77
`id` int(10) unsigned NOT NULL auto_increment,
78
`measurementTypeId` int(10) unsigned NOT NULL default '0',
79
`detectorId` int(10) unsigned NOT NULL default '0',
80
`name` varchar(255) default NULL,
81
`abbreviation` varchar(4) NOT NULL default '',
83
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=25 ;
88
INSERT INTO `measurement` VALUES(17, 0, 11, 'mag', 'mag');
89
INSERT INTO `measurement` VALUES(18, 0, 11, 'int', 'int');
90
INSERT INTO `measurement` VALUES(19, 0, 12, '0WL', '0WL');
91
INSERT INTO `measurement` VALUES(20, 0, 13, '0WL', '0WL');
92
INSERT INTO `measurement` VALUES(21, 1, 14, '195', '195');
93
INSERT INTO `measurement` VALUES(22, 1, 14, '171', '171');
94
INSERT INTO `measurement` VALUES(23, 1, 14, '304', '304');
95
INSERT INTO `measurement` VALUES(24, 1, 14, '284', '284');
101
CREATE TABLE `measurementType` (
102
`id` int(10) unsigned NOT NULL auto_increment,
103
`name` varchar(255) NOT NULL default '',
104
`unit` varchar(255) default NULL,
106
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
111
INSERT INTO `measurementType` VALUES(0, 'measurement', NULL);
112
INSERT INTO `measurementType` VALUES(1, 'wavelength', 'nm');
118
CREATE TABLE `observatory` (
119
`id` int(10) unsigned NOT NULL auto_increment,
120
`abbreviation` varchar(4) NOT NULL default '',
121
`name` varchar(255) default NULL,
123
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
128
INSERT INTO `observatory` VALUES(3, 'soho', 'soho');
134
CREATE TABLE `opacityGroup` (
135
`id` int(10) unsigned NOT NULL auto_increment,
136
`description` varchar(255) NOT NULL,
138
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
143
INSERT INTO `opacityGroup` VALUES(1, 'Full Disc Image');
144
INSERT INTO `opacityGroup` VALUES(2, 'Coronagraph Image, in the range of LASCO C2');
145
INSERT INTO `opacityGroup` VALUES(3, 'Coronagraph Image, in the range of LASCO C3');