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