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