Subversion Repositories eFlore/Applications.cel

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
968 jpm 1
-- phpMyAdmin SQL Dump
2
-- version 3.4.4
3
-- http://www.phpmyadmin.net
4
--
5
-- Client: localhost
6
-- Généré le : Ven 23 Septembre 2011 à 15:52
7
-- Version du serveur: 5.1.32
8
-- Version de PHP: 5.2.17
9
 
10
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
SET time_zone = "+00:00";
12
 
13
 
14
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17
/*!40101 SET NAMES utf8 */;
18
 
19
--
20
-- Base de données: `cel`
21
--
22
 
23
-- --------------------------------------------------------
24
 
25
--
26
-- Structure de la table `cel_images`
27
--
28
 
29
CREATE TABLE IF NOT EXISTS `cel_images` (
30
  `ci_id_image` bigint(20) NOT NULL AUTO_INCREMENT,
31
  `ci_ordre` bigint(20) NOT NULL,
32
  `ci_ce_utilisateur` varchar(60) NOT NULL,
33
  `ci_publiable_eflore` tinyint(1) NOT NULL,
34
  `ci_note_image` tinyint(5) NOT NULL DEFAULT '-1',
35
  `ci_meta_height` int(11) NOT NULL,
36
  `ci_meta_width` int(11) NOT NULL,
37
  `ci_meta_make` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
38
  `ci_meta_model` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
39
  `ci_meta_x_resolution` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
40
  `ci_meta_y_resolution` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
41
  `ci_meta_date_time` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
42
  `ci_meta_date` date DEFAULT NULL,
43
  `ci_meta_date_ajout` datetime NOT NULL,
44
  `ci_meta_gps` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
45
  `ci_meta_user_comment` longtext CHARACTER SET ascii,
46
  `ci_meta_comment` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
47
  `ci_meta_mots_cles` varchar(800) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
48
  `ci_meta_exif_exposure_time` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
49
  `ci_meta_exif_f_number` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
50
  `ci_meta_exif_exif_version` int(11) DEFAULT NULL,
51
  `ci_meta_exif_compressed_bits_per_pixel` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
52
  `ci_meta_exif_shutter_speed_value` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
53
  `ci_meta_exif_aperture_value` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
54
  `ci_meta_exif_exposure_bias_value` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
55
  `ci_meta_exif_max_aperture_value` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
56
  `ci_meta_exif_metering_mode` int(5) DEFAULT NULL,
57
  `ci_meta_exif_light_source` varchar(2) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
58
  `ci_meta_exif_flash` int(5) DEFAULT NULL,
59
  `ci_meta_exif_focal_length` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
60
  `ci_meta_exif_flash_pix_version` int(10) DEFAULT NULL,
61
  `ci_meta_exif_color_space` int(5) DEFAULT NULL,
62
  `ci_meta_exif_interoperability_offset` int(10) DEFAULT NULL,
63
  `ci_meta_exif_focal_plane_x_resolution` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
64
  `ci_meta_exif_focal_plane_y_resolution` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
65
  `ci_meta_exif_focal_plane_resolution_unit` int(5) DEFAULT NULL,
66
  `ci_meta_exif_sensing_method` int(5) DEFAULT NULL,
67
  `ci_meta_exif_file_source` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
68
  `ci_meta_exif_custom_rendered` int(5) DEFAULT NULL,
69
  `ci_meta_exif_exposure_mode` int(5) DEFAULT NULL,
70
  `ci_meta_exif_white_balance` int(5) DEFAULT NULL,
71
  `ci_meta_exif_digital_zoom_ratio` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
72
  `ci_meta_exif_scene_capture_type` int(5) DEFAULT NULL,
73
  `ci_meta_exif_gain_control` int(5) DEFAULT NULL,
74
  `ci_meta_exif_contrast` int(5) DEFAULT NULL,
75
  `ci_meta_exif_saturation` int(5) DEFAULT NULL,
76
  `ci_meta_exif_sharpness` int(5) DEFAULT NULL,
77
  `ci_meta_exif_subject_distance_range` int(5) DEFAULT NULL,
78
  `ci_meta_exif_autres` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
79
  `ci_meta_iptc_category` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
80
  `ci_meta_iptc_mots_cles` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
81
  `ci_meta_iptc_by_line` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
82
  `ci_meta_iptc_by_line_title` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
83
  `ci_meta_iptc_city` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
84
  `ci_meta_iptc_sub_location` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
85
  `ci_meta_iptc_province_state` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
86
  `ci_meta_iptc_country_primary_location_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
87
  `ci_meta_iptc_country_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
88
  `ci_meta_iptc_headline` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
89
  `ci_meta_iptc_credit` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
90
  `ci_meta_iptc_copyright_notice` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
91
  `ci_meta_iptc_contact` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
92
  `ci_meta_iptc_autres` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
93
  `ci_nom_original` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
94
  `ci_md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
95
  PRIMARY KEY (`ci_id_image`),
96
  KEY `ci_id_image` (`ci_id_image`,`ci_ordre`,`ci_ce_utilisateur`),
97
  KEY `ci_ce_utilisateur` (`ci_ce_utilisateur`)
98
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=44843 ;
99
 
100
-- --------------------------------------------------------
101
 
102
--
103
-- Structure de la table `cel_inventory`
104
--
105
 
106
CREATE TABLE IF NOT EXISTS `cel_inventory` (
107
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
108
  `identifiant` varchar(128) NOT NULL,
109
  `prenom_utilisateur` varchar(255) DEFAULT NULL COMMENT 'Prénom de l''utilisateur ayant saisi l''observation.',
110
  `nom_utilisateur` varchar(255) DEFAULT NULL COMMENT 'Nom de l''utilisateur ayant saisi l''observation.',
111
  `ordre` bigint(20) NOT NULL,
112
  `nom_sel` varchar(255) NOT NULL,
113
  `num_nom_sel` int(11) NOT NULL,
114
  `nom_ret` varchar(255) NOT NULL,
115
  `num_nom_ret` int(11) NOT NULL,
116
  `num_taxon` int(11) NOT NULL,
117
  `famille` varchar(255) NOT NULL,
118
  `location` varchar(50) NOT NULL,
119
  `id_location` varchar(10) NOT NULL,
120
  `date_observation` datetime NOT NULL,
121
  `lieudit` varchar(255) NOT NULL,
122
  `station` varchar(255) NOT NULL,
123
  `milieu` varchar(255) NOT NULL,
124
  `commentaire` varchar(1024) NOT NULL,
125
  `transmission` tinyint(4) NOT NULL,
126
  `date_creation` datetime NOT NULL,
127
  `date_modification` datetime NOT NULL,
128
  `date_transmission` datetime NOT NULL,
129
  `mots_cles` longtext NOT NULL,
130
  `mots_cles_texte` text,
131
  `coord_x` varchar(50) NOT NULL,
132
  `coord_y` varchar(50) NOT NULL,
133
  `ref_geo` varchar(25) NOT NULL,
134
  PRIMARY KEY (`id`),
135
  UNIQUE KEY `identifiant_ordre` (`identifiant`,`ordre`),
136
  KEY `identifiant_date_creation` (`identifiant`,`date_creation`),
137
  KEY `id_location` (`id_location`),
138
  KEY `location` (`location`),
139
  KEY `date_observation` (`date_observation`),
140
  KEY `nom_ret` (`nom_ret`),
141
  KEY `identifiant` (`identifiant`),
142
  KEY `coordonnees` (`coord_x`,`coord_y`)
143
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=370469 ;
144
 
145
-- --------------------------------------------------------
146
 
147
--
148
-- Structure de la table `cel_mots_cles_images`
149
--
150
 
151
CREATE TABLE IF NOT EXISTS `cel_mots_cles_images` (
152
  `cmc_mot_cle` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
153
  `cmc_bg` int(10) NOT NULL,
154
  `cmc_bd` int(10) NOT NULL,
155
  `cmc_id_mot_cle_general` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
156
  `cmc_id_mot_cle_utilisateur` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
157
  `cmc_id_proprietaire` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
158
  `cmc_id_parent` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
159
  `cmc_niveau` int(10) NOT NULL,
160
  PRIMARY KEY (`cmc_mot_cle`,`cmc_id_mot_cle_general`,`cmc_id_proprietaire`)
161
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
162
 
163
-- --------------------------------------------------------
164
 
165
--
166
-- Structure de la table `cel_mots_cles_obs`
167
--
168
 
169
CREATE TABLE IF NOT EXISTS `cel_mots_cles_obs` (
170
  `cmc_mot_cle` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
171
  `cmc_bg` int(20) NOT NULL,
172
  `cmc_bd` int(20) NOT NULL,
173
  `cmc_id_mot_cle_general` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
174
  `cmc_id_mot_cle_utilisateur` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
175
  `cmc_id_proprietaire` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
176
  `cmc_id_parent` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
177
  `cmc_niveau` int(11) NOT NULL,
178
  PRIMARY KEY (`cmc_id_mot_cle_utilisateur`,`cmc_id_proprietaire`)
179
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT COMMENT='Table des mots clés, à utiliser avec des transactions !';
180
 
181
-- --------------------------------------------------------
182
 
183
--
184
-- Structure de la table `cel_obs_images`
185
--
186
 
187
CREATE TABLE IF NOT EXISTS `cel_obs_images` (
188
  `coi_ce_image` int(11) NOT NULL,
189
  `coi_ce_utilisateur` varchar(100) CHARACTER SET utf8 NOT NULL,
190
  `coi_ce_observation` int(11) NOT NULL,
191
  `coi_date_liaison` datetime NOT NULL,
192
  PRIMARY KEY (`coi_ce_image`,`coi_ce_observation`),
193
  KEY `coi_ce_utilisateur` (`coi_ce_utilisateur`),
194
  KEY `coi_ce_observation` (`coi_ce_observation`),
195
  KEY `coi_ce_image` (`coi_ce_image`)
196
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
197
 
198
-- --------------------------------------------------------
199
 
200
--
201
-- Structure de la table `locations`
202
--
203
 
204
CREATE TABLE IF NOT EXISTS `locations` (
205
  `name` varchar(50) NOT NULL,
206
  `maj_name` varchar(50) NOT NULL,
207
  `code` varchar(3) NOT NULL DEFAULT '0',
208
  `insee_code` varchar(5) NOT NULL DEFAULT '0',
209
  `sector` varchar(3) NOT NULL,
210
  `x_utm` varchar(10) NOT NULL DEFAULT '0',
211
  `y_utm` varchar(10) NOT NULL DEFAULT '0',
212
  `wgs84_latitude` double NOT NULL,
213
  `wgs84_longitude` double NOT NULL,
214
  `update_date` datetime NOT NULL,
215
  PRIMARY KEY (`name`,`code`),
216
  KEY `MAJ` (`maj_name`,`code`),
217
  KEY `sector` (`sector`,`x_utm`,`y_utm`)
218
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
219
 
220
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
221
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
222
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;