Subversion Repositories eFlore/Applications.cel

Rev

Rev 3857 | Details | Compare with Previous | 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 */;