| 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 */;
|