1# MySQL dump 6.0
2#
3# Host: localhost    Database: ilelev
4#--------------------------------------------------------
5# Server version	3.22.25
6
7#
8# Table structure for table 'level0'
9#
10CREATE TABLE level0 (
11  elev_id bigint(20) DEFAULT '0' NOT NULL auto_increment,
12  ll_lat double(16,10) DEFAULT '0.0000000000' NOT NULL,
13  ll_lon double(16,10) DEFAULT '0.0000000000' NOT NULL,
14  ul_lat double(16,10) DEFAULT '0.0000000000' NOT NULL,
15  ul_lon double(16,10) DEFAULT '0.0000000000' NOT NULL,
16  ur_lat double(16,10) DEFAULT '0.0000000000' NOT NULL,
17  ur_lon double(16,10) DEFAULT '0.0000000000' NOT NULL,
18  lr_lat double(16,10) DEFAULT '0.0000000000' NOT NULL,
19  lr_lon double(16,10) DEFAULT '0.0000000000' NOT NULL,
20  lat_interval int(11) DEFAULT '0' NOT NULL,
21  lon_interval int(11) DEFAULT '0' NOT NULL,
22  lat_points int(11) DEFAULT '0' NOT NULL,
23  lon_lines int(11) DEFAULT '0' NOT NULL,
24  vert_datum varchar(10) DEFAULT '' NOT NULL,
25  horiz_datum varchar(10) DEFAULT '' NOT NULL,
26  abs_ce int(11) DEFAULT '0' NOT NULL,
27  abs_le int(11) DEFAULT '0' NOT NULL,
28  rel_ce int(11) DEFAULT '0' NOT NULL,
29  rel_le tinyint(4) DEFAULT '0' NOT NULL,
30  path varchar(255) DEFAULT '' NOT NULL,
31  file varchar(255) DEFAULT '' NOT NULL,
32  PRIMARY KEY (elev_id),
33  KEY elev_id (elev_id),
34  UNIQUE elev_id_2 (elev_id)
35);
36
37#
38# Dumping data for table 'level0'
39#
40
41
42#
43# Table structure for table 'level1'
44#
45CREATE TABLE level1 (
46  elev_id bigint(20) DEFAULT '0' NOT NULL auto_increment,
47  ll_lat double(16,10) DEFAULT '0.0000000000' NOT NULL,
48  ll_lon double(16,10) DEFAULT '0.0000000000' NOT NULL,
49  ul_lat double(16,10) DEFAULT '0.0000000000' NOT NULL,
50  ul_lon double(16,10) DEFAULT '0.0000000000' NOT NULL,
51  ur_lat double(16,10) DEFAULT '0.0000000000' NOT NULL,
52  ur_lon double(16,10) DEFAULT '0.0000000000' NOT NULL,
53  lr_lat double(16,10) DEFAULT '0.0000000000' NOT NULL,
54  lr_lon double(16,10) DEFAULT '0.0000000000' NOT NULL,
55  lat_interval int(11) DEFAULT '0' NOT NULL,
56  lon_interval int(11) DEFAULT '0' NOT NULL,
57  lat_points int(11) DEFAULT '0' NOT NULL,
58  lon_lines int(11) DEFAULT '0' NOT NULL,
59  vert_datum varchar(10) DEFAULT '' NOT NULL,
60  horiz_datum varchar(10) DEFAULT '' NOT NULL,
61  abs_ce int(11) DEFAULT '0' NOT NULL,
62  abs_le int(11) DEFAULT '0' NOT NULL,
63  rel_ce int(11) DEFAULT '0' NOT NULL,
64  rel_le tinyint(4) DEFAULT '0' NOT NULL,
65  path varchar(255) DEFAULT '' NOT NULL,
66  file varchar(255) DEFAULT '' NOT NULL,
67  PRIMARY KEY (elev_id),
68  KEY elev_id (elev_id),
69  UNIQUE elev_id_2 (elev_id)
70);
71
72#
73# Dumping data for table 'level1'
74#
75
76
77#
78# Table structure for table 'level2'
79#
80CREATE TABLE level2 (
81  elev_id bigint(20) DEFAULT '0' NOT NULL auto_increment,
82  ll_lat double(16,10) DEFAULT '0.0000000000' NOT NULL,
83  ll_lon double(16,10) DEFAULT '0.0000000000' NOT NULL,
84  ul_lat double(16,10) DEFAULT '0.0000000000' NOT NULL,
85  ul_lon double(16,10) DEFAULT '0.0000000000' NOT NULL,
86  ur_lat double(16,10) DEFAULT '0.0000000000' NOT NULL,
87  ur_lon double(16,10) DEFAULT '0.0000000000' NOT NULL,
88  lr_lat double(16,10) DEFAULT '0.0000000000' NOT NULL,
89  lr_lon double(16,10) DEFAULT '0.0000000000' NOT NULL,
90  lat_interval int(11) DEFAULT '0' NOT NULL,
91  lon_interval int(11) DEFAULT '0' NOT NULL,
92  lat_points int(11) DEFAULT '0' NOT NULL,
93  lon_lines int(11) DEFAULT '0' NOT NULL,
94  vert_datum varchar(10) DEFAULT '' NOT NULL,
95  horiz_datum varchar(10) DEFAULT '' NOT NULL,
96  abs_ce int(11) DEFAULT '0' NOT NULL,
97  abs_le int(11) DEFAULT '0' NOT NULL,
98  rel_ce int(11) DEFAULT '0' NOT NULL,
99  rel_le tinyint(4) DEFAULT '0' NOT NULL,
100  path varchar(255) DEFAULT '' NOT NULL,
101  file varchar(255) DEFAULT '' NOT NULL,
102  PRIMARY KEY (elev_id),
103  KEY elev_id (elev_id),
104  UNIQUE elev_id_2 (elev_id)
105);
106
107#
108# Dumping data for table 'level2'
109#
110
111
112